spring batch JdbcCursorItemReader failure
hi all,
i'm developping a spring batch application using version 1.1.1.REALEASE for spring batch. But the job is fired my jdbcCursor throws this exception
Code:
[11/06/2010 09:00:00]-[AbstractStep] Encountered an error executing the step: class org.springframework.batch.core.UnexpectedJobExecutionException: Failed to initialize the step
[11/06/2010 09:00:00]-[QuartzFacebookJob] Une Exception s'est produite lors du declenchement du job JumboJob
[11/06/2010 09:00:00]-[QuartzFacebookJob] org.springframework.batch.core.UnexpectedJobExecutionException: Failed to initialize the step
at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:170)
at org.springframework.batch.core.job.SimpleJob.execute(SimpleJob.java:100)
at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:86)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:81)
at com.tunisiana.jumbo.wapfacebook.batch.quartz.QuartzFacebookJob.execute(QuartzFacebookJob.java:44)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.springframework.batch.item.ItemStreamException: Failed to initialize the reader
at org.springframework.batch.item.support.AbstractBufferedItemReaderItemStream.open(AbstractBufferedItemReaderItemStream.java:157)
at org.springframework.batch.item.support.CompositeItemStream.open(CompositeItemStream.java:103)
at org.springframework.batch.core.step.item.ItemOrientedStep.open(ItemOrientedStep.java:439)
at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:167)
... 7 more
Caused by: org.springframework.jdbc.UncategorizedSQLException: Executing query; uncategorized SQLException for SQL [
select * from S_SUBSCRIPTION where SERVICE_NAME='MYSERVICE' and SUBSCRIBER_STATUS='SUBSCRIBED' and trunc(SUBSCRIPTION_END_DATE) = trunc(sysdate)
]; SQL state [null]; error code [17023]; Unsupported feature; nested exception is java.sql.SQLException: Unsupported feature
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.batch.item.database.JdbcCursorItemReader.executeQuery(JdbcCursorItemReader.java:185)
at org.springframework.batch.item.database.JdbcCursorItemReader.doOpen(JdbcCursorItemReader.java:407)
at org.springframework.batch.item.support.AbstractBufferedItemReaderItemStream.open(AbstractBufferedItemReaderItemStream.java:154)
... 10 more
Caused by: java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:689)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:3269)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:432)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:399)
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 org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:364)
at $Proxy33.prepareStatement(Unknown Source)
at org.springframework.batch.item.database.JdbcCursorItemReader.executeQuery(JdbcCursorItemReader.java:174)
... 12 more
[11/06/2010 09:05:00]-[JumboJob] Une Exception s'est produite lors du declenchement du job JumboJob
[11/06/2010 09:05:00]-[JumboJob] org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'studentOfferGraceJob' is defined
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:387)
at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:968)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:881)
at com.tunisiana.jumbo.quartz.JumboJob.execute(JumboJob.java:35)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
I'm using an Oracle 9i database version and as driver ojdbc14.jar. I don't have a clue about this exception if any one can help?
