Announcement Announcement Module
Collapse
No announcement yet.
Job Runtime JDBC exception: Missing Defines Exception from Oracle Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Job Runtime JDBC exception: Missing Defines Exception from Oracle

    Currently trying to run our batch job to process a significant load of records from Oracle. We are kicking this off form the jobs springframework.batch.core.launch.support.CommandL ineJobRunner

    It works fine for awhile and then dies at around 100k records.

    Error Stack: being returned from Oracle below

    13:12:37,289 ERROR main CommandLineJobRunner:203 - Job Terminated in error:
    org.springframework.jdbc.UncategorizedSQLException : CallableStatementCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [17021]; Missing defines; nested exception is java.sql.SQLException: Missing defines
    at org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.translate(SQLStateSQLExceptionTransl ator.java:124)
    at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.translate(SQLErrorCodeSQLExcepti onTranslator.java:322)
    at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:949)
    at org.springframework.jdbc.core.JdbcTemplate.call(Jd bcTemplate.java:982)
    at org.springframework.batch.sample.dao.JdbcMVestTrad eDao.getRate(JdbcMVestTradeDao.java:70)
    at org.springframework.batch.sample.dao.MVestTradeCom monTransformer.transform(MVestTradeCommonTransform er.java:64)
    at org.springframework.batch.item.transform.Composite ItemTransformer.transform(CompositeItemTransformer .java:23)
    at org.springframework.batch.item.transform.ItemTrans formerItemWriter.doProcess(ItemTransformerItemWrit er.java:21)
    at org.springframework.batch.item.support.DelegatingI temWriter.write(DelegatingItemWriter.java:42)
    at org.springframework.batch.item.support.DelegatingI temWriter.write(DelegatingItemWriter.java:43)
    at org.springframework.batch.core.step.item.BatchList enerFactoryHelper$2.write(BatchListenerFactoryHelp er.java:101)
    at org.springframework.batch.core.step.item.SimpleIte mHandler.doWrite(SimpleItemHandler.java:100)
    at org.springframework.batch.core.step.item.SimpleIte mHandler.write(SimpleItemHandler.java:92)
    at org.springframework.batch.core.step.item.SimpleIte mHandler.handle(SimpleItemHandler.java:66)
    at org.springframework.batch.core.step.item.ItemOrien tedStep$2.doInIteration(ItemOrientedStep.java:495)
    at org.springframework.batch.repeat.support.RepeatTem plate.getNextResult(RepeatTemplate.java:346)
    at org.springframework.batch.repeat.support.RepeatTem plate.executeInternal(RepeatTemplate.java:212)
    at org.springframework.batch.repeat.support.RepeatTem plate.iterate(RepeatTemplate.java:143)
    at org.springframework.batch.core.step.item.ItemOrien tedStep.processChunk(ItemOrientedStep.java:488)
    at org.springframework.batch.core.step.item.ItemOrien tedStep$1.doInIteration(ItemOrientedStep.java:288)
    at org.springframework.batch.repeat.support.RepeatTem plate.getNextResult(RepeatTemplate.java:346)
    at org.springframework.batch.repeat.support.RepeatTem plate.executeInternal(RepeatTemplate.java:212)
    at org.springframework.batch.repeat.support.RepeatTem plate.iterate(RepeatTemplate.java:143)
    at org.springframework.batch.core.step.item.ItemOrien tedStep.execute(ItemOrientedStep.java:269)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.aop.support.AopUtils.invokeJoi npointUsingReflection(AopUtils.java:310)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.invokeJoinpoint(ReflectiveMethodInvocat ion.java:182)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :149)
    at org.springframework.aop.aspectj.AspectJAfterAdvice .invoke(AspectJAfterAdvice.java:42)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :171)
    at org.springframework.aop.aspectj.AspectJAfterAdvice .invoke(AspectJAfterAdvice.java:42)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :171)
    at org.springframework.aop.aspectj.AspectJAfterThrowi ngAdvice.invoke(AspectJAfterThrowingAdvice.java:54 )
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :171)
    at org.springframework.aop.framework.adapter.MethodBe foreAdviceInterceptor.invoke(MethodBeforeAdviceInt erceptor.java:50)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :171)
    at org.springframework.aop.aspectj.AspectJAfterThrowi ngAdvice.invoke(AspectJAfterThrowingAdvice.java:54 )
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :171)
    at org.springframework.aop.framework.adapter.MethodBe foreAdviceInterceptor.invoke(MethodBeforeAdviceInt erceptor.java:50)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :171)
    at org.springframework.aop.interceptor.ExposeInvocati onInterceptor.invoke(ExposeInvocationInterceptor.j ava:90)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :171)
    at org.springframework.aop.framework.JdkDynamicAopPro xy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy2.execute(Unknown Source)
    at org.springframework.batch.core.job.SimpleJob.execu te(SimpleJob.java:125)
    at org.springframework.batch.core.launch.support.Simp leJobLauncher$1.run(SimpleJobLauncher.java:86)
    at org.springframework.core.task.SyncTaskExecutor.exe cute(SyncTaskExecutor.java:49)
    at org.springframework.batch.core.launch.support.Simp leJobLauncher.run(SimpleJobLauncher.java:81)
    at org.springframework.batch.core.launch.support.Comm andLineJobRunner.start(CommandLineJobRunner.java:1 99)
    at org.springframework.batch.core.launch.support.Comm andLineJobRunner.main(CommandLineJobRunner.java:24 8)
    Caused by: java.sql.SQLException: Missing defines
    at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:208)
    at oracle.jdbc.driver.NumberCommonAccessor.getObject( NumberCommonAccessor.java:6309)
    at oracle.jdbc.driver.T4CVarnumAccessor.getObject(T4C VarnumAccessor.java:286)
    at oracle.jdbc.driver.OracleCallableStatement.getObje ct(OracleCallableStatement.java:1401)
    at org.apache.commons.dbcp.DelegatingCallableStatemen t.getObject(DelegatingCallableStatement.java:143)
    at org.springframework.jdbc.core.JdbcTemplate.extract OutputParameters(JdbcTemplate.java:1079)
    at org.springframework.jdbc.core.JdbcTemplate$5.doInC allableStatement(JdbcTemplate.java:994)
    at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:933)
    ... 50 more
    13:12:37,290 INFO main SessionFactoryImpl:769 - closing
    main SessionFactoryImpl:769 - closing

  • #2
    It looks like you've got some kind of error in your custom DAO, so I can't really say why the issue is being caused. However, you can configure the framework to skip the bad record causing this failure. The following section in the reference docs explains how to set this up:

    http://static.springframework.org/sp...n.html#d0e3747

    Also, please use code tags when posting stack traces or code snippets.

    Comment

    Working...
    X