Announcement Announcement Module
Collapse
No announcement yet.
spring batch JdbcCursorItemReader failure Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

  • #2
    Check the version of your ojdbc14.jar, there are several versions for the oracle9 family, and they support different features.

    I had similiar problems with oracle jdbc drivers recently, upgrading to the latest oracle9 jdbc driver fixed them (9.2.0.8 if i remember correctly).

    Comment

    Working...
    X