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
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?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)


Reply With Quote