Re: JDBC and transaction processing

Peter By default, JDBC assumes every execute[Update|Query] call is a transaction. You can defer the commit by setting Connection.setAutoCommit(false). I think that there is also a static variable that you can set to turn off transactions, but cant remember it offhand, try checking the manuals. HTH Sujit Peter Wages <pmwages@chele.cais.net> on 02/22/2000 10:25:10 AM To: informix-list@iiug.org cc: Subject: JDBC and transaction processing We have a web application which accesses 2 informix databases thru Weblogic's JDBC driver. As one executes the application going from html page to another , app open and closes connections. At each close , according to onstat -g sql a commit work is attempted which fails with -255 ( no begin work - no transaction ). Simultaeousl or apaparantly simultaneeus ly the java code seems to trigger a nullpointer exception. The java code does not start any transaction processing ( no begin work ). Does the JDBC driver? Is there any way to turn it off? ciao p ****************************************************************************** Peter Wages pmwages@cais.com Work: (703) 741-7436 Home: (703) 528-9569 ******************************************************************************