aspose file tools*
The moose likes JDBC and the fly likes JdbcExeption Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JdbcExeption" Watch "JdbcExeption" New topic
Author

JdbcExeption

Murray Meyer
Greenhorn

Joined: Oct 27, 2012
Posts: 1
Can anyone help please !!! I'm new to Java an I'm getting an error. We are passing a lot of fields to a stored procedure to mssql but I'm getting the following error:
Caused by: com.freesoft.n2j.jdbc.exception.JdbcException: OpenedStatements size > 100, possibily statement closing is missing
Is the error in the store procedure or in the java program ? (and what is it?) It seems to process 90 odd records in the stored procedure and then something go's wrong.



Error:

......
15:32:04,314 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.wrapper.FsPreparedStatement: exec udsp_UpdAccount 'stringVal' 02010103670000,1011,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4467989,1150000,0,0,0,372332.41,
372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,
1522332.49,60070.81,412121.81,935668.64,469287.07,469287.07,469287.09,469287.90,5814.59,469287.09,
469287.07,469287.09,877537.26,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,null
15:32:04,314 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.wrapper.FsPreparedStatement: exec udsp_UpdAccount 'stringVal' 02000002310000,1011,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4467989,1150000,0,0,0,
372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,
372332.41,372332.41,1522332.49,60070.81,412121.81,935668.64,469287.07,469287.07,469287.09,
469287.90,5814.59,469287.09,469287.07,469287.09,877537.26,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,null
15:32:04,329 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.wrapper.FsPreparedStatement: exec udsp_UpdAccount 'stringVal' 02000002460000,1011,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4467989,1150000,0,0,0,372332.41,372332.41,372332.41,
372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,1522332.49,60070.81,412121.81,
935668.64,469287.07,469287.07,469287.09,469287.90,5814.59,469287.09,469287.07,469287.09,877537.26,0.00,0.00,0.00,
0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,null
15:32:04,329 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.wrapper.FsPreparedStatement: exec udsp_UpdAccount 'stringVal' 02000002520000,1011,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4467989,1150000,0,0,0,372332.41,372332.41,372332.41,
372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,1522332.49,60070.81,412121.81,935668.64,
469287.07,469287.07,469287.09,469287.90,5814.59,469287.09,469287.07,469287.09,877537.26,0.00,0.00,0.00,0.00,0.00,0.00,0.00,
0.00,0.00,0.00,0.00,0.00,null
15:32:04,329 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.wrapper.FsPreparedStatement: exec udsp_UpdAccount 'stringVal' 02000003540000,1011,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4467989,1150000,0,0,0,372332.41,372332.41,372332.41,
372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,1522332.49,60070.81,412121.81,
935668.64,469287.07,469287.07,469287.09,469287.90,5814.59,469287.09,469287.07,469287.09,877537.26,0.00,0.00,0.00,
0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,null
15:32:04,329 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.wrapper.FsPreparedStatement: exec udsp_UpdAccount 'stringVal' 02000003560000,1011,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4467989,1150000,0,0,0,372332.41,372332.41,372332.41,
372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,1522332.49,60070.81,412121.81,
935668.64,469287.07,469287.07,469287.09,469287.90,5814.59,469287.09,469287.07,469287.09,877537.26,0.00,0.00,0.00,
0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,null
15:32:04,329 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.wrapper.FsPreparedStatement: exec udsp_UpdAccount 'stringVal' 02000003590000,1011,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4467989,1150000,0,0,0,372332.41,372332.41,372332.41,
372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,1522332.49,60070.81,412121.81,
935668.64,469287.07,469287.07,469287.09,469287.90,5814.59,469287.09,469287.07,469287.09,877537.26,0.00,0.00,0.00,
0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,null
15:32:04,329 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.wrapper.FsPreparedStatement: exec udsp_UpdAccount 'stringVal' 02000003670000,1011,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4467989,1150000,0,0,0,372332.41,372332.41,372332.41,
372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,372332.41,1522332.49,60070.81,412121.81,
935668.64,469287.07,469287.07,469287.09,469287.90,5814.59,469287.09,469287.07,469287.09,877537.26,0.00,0.00,0.00,
0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,null
15:32:04,329 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.mssqlserver.MsCallableStatement: select top 1 T1.[ISN], T1.[VERSION] from MAS_GB_ACCOUNTS T1 WITH(READPAST) where (T1.[FIN_YEAR] = ? and T1.[ACC_NO] = ?) order by T1.[ISN]
15:32:04,345 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.mssqlserver.MsCallableStatement: select top 1 T1.[ISN], T1.[VERSION] from MAS_GB_ACCOUNTS T1 WITH(READPAST) where (T1.[FIN_YEAR] = ? and T1.[ACC_NO] = ?) order by T1.[ISN]
15:32:04,345 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.mssqlserver.MsCallableStatement: select top 1 T1.[ISN], T1.[VERSION] from MAS_GB_ACCOUNTS T1 WITH(READPAST) where (T1.[FIN_YEAR] = ? and T1.[ACC_NO] = ?) order by T1.[ISN]
15:32:04,345 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.mssqlserver.MsCallableStatement: select top 1 T1.[ISN], T1.[VERSION] from MAS_GB_ACCOUNTS T1 WITH(READPAST) where (T1.[FIN_YEAR] = ? and T1.[ACC_NO] = ?) order by T1.[ISN]
15:32:04,345 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.mssqlserver.MsCallableStatement: select top 1 T1.[ISN], T1.[VERSION] from MAS_GB_ACCOUNTS T1 WITH(READPAST) where (T1.[FIN_YEAR] = ? and T1.[ACC_NO] = ?) order by T1.[ISN]
15:32:04,345 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.mssqlserver.MsCallableStatement: select top 1 T1.[ISN], T1.[VERSION] from MAS_GB_ACCOUNTS T1 WITH(READPAST) where (T1.[FIN_YEAR] = ? and T1.[ACC_NO] = ?) order by T1.[ISN]
15:32:04,345 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.mssqlserver.MsCallableStatement: select top 1 T1.[ISN], T1.[VERSION] from MAS_GB_ACCOUNTS T1 WITH(READPAST) where (T1.[FIN_YEAR] = ? and T1.[ACC_NO] = ?) order by T1.[ISN]
15:32:04,345 INFO JdbcDataContextBase:311 - com.freesoft.n2j.jdbc.mssqlserver.MsCallableStatement: select top 1 T1.[ISN], T1.[VERSION] from MAS_GB_ACCOUNTS T1 WITH(READPAST) where (T1.[FIN_YEAR] = ? and T1.[ACC_NO] = ?) order by T1.[ISN]
15:32:04,360 ERROR Invoker:86 - OpenedStatements size > 100, possibily statement closing is missing
com.freesoft.n2j.jdbc.exception.JdbcException: OpenedStatements size > 100, possibily statement closing is missing
at com.freesoft.n2j.jdbc.JdbcDataContextBase.addOpenedStatement(JdbcDataContextBase.java:314)
at com.freesoft.n2j.jdbc.mssqlserver.MsSqlServerJdbcDataContext.createPreparedStatement(MsSqlServerJdbcDataContext.java:677)
at com.freesoft.n2j.jdbc.AppJdbcDataContext.createPreparedStatement(AppJdbcDataContext.java:57)
at com.freesoft.n2j.jdbc.definition.JdbcDetailList.check(JdbcDetailList.java:207)
at com.freesoft.n2j.jdbc.definition.JdbcDetailList.size(JdbcDetailList.java:240)
at com.freesoft.n2j.model.ListHelper.get(ListHelper.java:208)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:227)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.FSControllerBase.call(FSControllerBase.java:549)
at za.co.bcx.solar.llib.Gcb10002.gcb10002(Gcb10002.java:475)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at com.freesoft.n2j.controller.FSControllerBase.execute(FSControllerBase.java:461)
at com.freesoft.n2j.controller.BatchContainerController.start(BatchContainerController.java:129)
at com.freesoft.n2j.controller.Batch.executeProgram(Batch.java:104)
at com.freesoft.n2j.controller.Batch.<init>(Batch.java:55)
at com.freesoft.bcx.BatchApplication.<init>(BatchApplication.java:65)
at com.freesoft.bcx.BatchApplication.main(BatchApplication.java:102)
15:32:04,360 ERROR Invoker:86 - Invoke error
com.freesoft.n2j.controller.OnErrorException: Error occured: com.freesoft.n2j.jdbc.exception.JdbcException: OpenedStatements size > 100, possibily statement closing is missing
at com.freesoft.n2j.controller.Invoker.ignorePseudoException(Invoker.java:104)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:40)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:258)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.FSControllerBase.call(FSControllerBase.java:549)
at za.co.bcx.solar.llib.Gcb10002.gcb10002(Gcb10002.java:475)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
at com.freesoft.n2j.controller.FSControllerBase.execImpl(FSControllerBase.java:728)
at com.freesoft.n2j.controller.BatchContainerController.exec(BatchContainerController.java:179)
at com.freesoft.n2j.controller.FSControllerBase.execute(FSControllerBase.java:461)
at com.freesoft.n2j.controller.BatchContainerController.start(BatchContainerController.java:129)
at com.freesoft.n2j.controller.Batch.executeProgram(Batch.java:104)
at com.freesoft.n2j.controller.Batch.<init>(Batch.java:55)
at com.freesoft.bcx.BatchApplication.<init>(BatchApplication.java:65)
at com.freesoft.bcx.BatchApplication.main(BatchApplication.java:102)
Caused by: com.freesoft.n2j.jdbc.exception.JdbcException: OpenedStatements size > 100, possibily statement closing is missing
at com.freesoft.n2j.jdbc.JdbcDataContextBase.addOpenedStatement(JdbcDataContextBase.java:314)
at com.freesoft.n2j.jdbc.mssqlserver.MsSqlServerJdbcDataContext.createPreparedStatement(MsSqlServerJdbcDataContext.java:677)
at com.freesoft.n2j.jdbc.AppJdbcDataContext.createPreparedStatement(AppJdbcDataContext.java:57)
at com.freesoft.n2j.jdbc.definition.JdbcDetailList.check(JdbcDetailList.java:207)
at com.freesoft.n2j.jdbc.definition.JdbcDetailList.size(JdbcDetailList.java:240)
at com.freesoft.n2j.model.ListHelper.get(ListHelper.java:208)
at za.co.bcx.solar.llib.Gzs01001.forLoop39(Gzs01001.java:227)
at za.co.bcx.solar.llib.Gzs01001.loopAccount37(Gzs01001.java:166)
at za.co.bcx.solar.llib.Gzs01001.gzs01001(Gzs01001.java:100)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.freesoft.n2j.controller.Invoker.invoke(Invoker.java:36)
... 79 more
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36478
    
  16
Don’t know. Sorry. But I think this discussion would fit better in our JDBC forum, so I shall move it.

And welcome to the Ranch
I had to break up some of the long lines in the post, because they made it very difficult to read.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18121
    
    8

The error message alleges that you aren't closing your statements after you use them.

And it's true that if your SQL throws an exception, you aren't closing the statement which did that. You should use a "finally" block to close the statement whether or not an exception is caught.

Note that just because this code was where the error message first appears, it doesn't mean that this code was the code responsible for failing to close statements. You should review all of your code which creates statements and make sure that they are always closed.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19541
    
  16

You're using PreparedStatement, but you're setting all the parameters before you create it. That takes away all security PreparedStatement provides. You should instead create the query with ? as placeholders for each parameter, then set them after you've created the PreparedStatement.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JdbcExeption
 
Similar Threads
Problem with hibernate jar files in WID WPS
MySql - XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected
SAAJ client issue
JDBCRealm Problem
How to add two criteria with Disjunction in hibernate.