sorry that I had brings this prob here !
I got the problems when write a servlet program connect to mysql database
through jdbc mm_... driver.
my code ...
.
.
.
pstmt_log=con_log.prepareStatement("select connectid from ARA_CONNECT where
USER_SEQ_ID=? and start_time=?");
pstmt_log.setInt(1,uid);
pstmt_log.setLong(2,time);
rs_log=pstmt_log.executeQuery();
if(!rs_log.next())
{
System.out.println("22222222222222222222222222222");
rs_log.close();
pstmt_log.close();
pstmt_log=con_log.prepareStatement("insert into ARA_CONNECT
(eventid,USER_SEQ_ID,start_time,con_type) values (?,?,222222,'ETH')");
pstmt_log.setInt(1,1);
pstmt_log.setInt(2,2);
pstmt_log.executeUpdate();
pstmt_log.close();
}
else
{
rs_log.close();
pstmt_log.close();
}
It sometimes work but some times exception:
java.sql.SQLException: Results returned for UPDATE ONLY.
java.sql.SQLException: Results returned for UPDATE ONLY.
at
org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java)
...
I don't understand what this Exception means any one can tell me.
Thanks a lot.
Rgds
Rod
___________________________________________________________________________
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
