hi ya,
which database are you using ?
if it is MS access then you need to close the database ( MS
access ) GUI ....
guru
-----Original Message-----
From: Ying Su [mailto:[EMAIL PROTECTED]]
Sent: 03 April 2002 04:05
To: [EMAIL PROTECTED]
Subject: Strange problem--please help!
Dear all,
I am using JBuilder 6 to run my servlet and application. I use my servlet to
listen on port 80, and use the application to send a MIME message to the
servlet. After sending out the message, the application updates a database,
adding the message number in it.
The relating program is:
try{ con = connMgr.getConnection();
if(con != null)
System.out.println(con.toString());
stmt = con.createStatement ();
if(stmt != null)
System.out.println(stmt.toString());
int result = stmt.executeUpdate(query);
con.commit();
System.out.println(result);
return result;
}
catch(SQLException ex)
{
throw new SQLException(ex.getMessage());
}
finally{
try{
stmt.close();
connMgr.releaseConnection (con);
System.out.println("finally");
}
catch (SQLException se)
{
se.printStackTrace();
}
}
I found that running the application in JBuilder can't update the database,
although it gives no errors. Running the application in
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
