Dear guru,
Yes, I am using MS Access. But I didn't open the database (Access) GUI when I
excecuting the application. And the con.getAutoCommit() is true. Do you have any
suggestions? THanks!!
Ying
----- Original Message -----
From: "Raghupathy, Gurumoorthy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 3:57 PM
Subject: Re: Strange problem--please help!
> 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
>
>
>
��칻 �&ޱ��zf���%��lz��j���w(��݊w%�ע��^n�r��azg��� �('���K2
LDDI0+r�z�m���j�!�����ڲ�ܢoڭ�b��?����b�z�a�iQz�.�Ǭ��i��ڽ�.��&���v�-�� ��^������jZ��q�!�iK!$�GzZa���
0�� ��&�f���l�� ���z�m�
