• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JdbcExeption

 
Murray Meyer
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 50175
79
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21416
33
Eclipse IDE Firefox Browser MySQL Database
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 20661
65
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic