Details
Description
A user reports a problem with Sybase, where JIRA starts up correctly, creating the tables, but breaks on the first actual database update, with errors:
2007-01-10 08:50:35,994 http-8080-Processor25 WARN [NoModule] [SQLProcessor.commit]: SQL Exception occurred on commit. Error was:java.sql.SQLException: I/O Error: DB server closed connection. 2007-01-10 08:50:35,995 http-8080-Processor25 ERROR [module.propertyset.ofbiz.OFBizPropertySet] Error setting value in PropertySet org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: DB server closed connection.) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:116) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153) at org.ofbiz.core.entity.GenericDAO.storeAll(GenericDAO.java:291) at org.ofbiz.core.entity.GenericHelperDAO.storeAll(GenericHelperDAO.java:221) at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1482) at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1428) at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:182) ....
In the Sybase logs one sees:
02:00000:00649:2007/01/09 09:26:56.79 kernel current process (0x565c01f4) infected with 10 02:00000:00649:2007/01/09 09:26:56.85 kernel Address 0x004c49e8 (s_retparams+0xbc), siginfo (code, address) = (1, 0x00000027) 02:00000:00649:2007/01/09 09:26:56.86 kernel ************************************ 02:00000:00649:2007/01/09 09:26:56.86 kernel SQL causing error : UPDATE propertystring SET propertyvalue= @P0 WHERE ID= @P1 ì^V 02:00000:00649:2007/01/09 09:26:56.86 kernel ************************************ 02:00000:00649:2007/01/09 09:26:56.86 server SQL Text: UPDATE propertystring SET propertyvalue= @P0 WHERE ID= @P1 ì^V 02:00000:00649:2007/01/09 09:26:56.86 kernel curdb = 70 tempdb = 2 pstat = 0x10000 02:00000:00649:2007/01/09 09:26:56.86 kernel lasterror = 0 preverror = 0 transtate = 0 02:00000:00649:2007/01/09 09:26:56.86 kernel curcmd = 197 program = jTDS