The question is not valid now - I found the solution. The matter was: the connection I tried to set AutoCommit for, was earlier used for statement executing. I can set AutoCommit false only when connection was not used for any statements before. But setting it true after operations is not a problem. I think it makes creating Connection Pools more complicated... Rafal >I am working currently with Ms Access 97 database via JDBC:ODBC on Win95/NT. >I tried to use transaction in my servlet by setting Connection.setAutoCommit(false) >but on >this statement I caught an SQLException: > >java.sql.SQLException: [Microsoft][ODBC Microsoft Access 97 Driver]Operation invalid >at >this time > >Additional info: ErrorCode is 59, SQL State is S1011. >I am not able to find any information about this exception. What have I to do to use >>transactions with this database? > >Rafal ___________________________________________________________________________ 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
