jQuery in Action, 2nd edition*
The moose likes Spring and the fly likes Spring batch 2.0 (How to stop calling sequence) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "Spring batch 2.0 (How to stop calling sequence)" Watch "Spring batch 2.0 (How to stop calling sequence)" New topic
Author

Spring batch 2.0 (How to stop calling sequence)

Kousik Majumder
Ranch Hand

Joined: Sep 30, 2007
Posts: 229
Hi all,

I am trying to run Spring batch 2.0 examples.But it is getting an error for not creating sequence. Can anybody tell me how can I stop my batch to call creating DB Sequence? Beacuse I have no permission to create a DB sequence.
Is it mandatory for Spring Batch to create a DB sequence to run? Can not I skip this step?
If there is any alternate way please tell that with codes.

Error StackTrace:-

Oct 1, 2010 8:39:22 PM org.springframework.batch.core.launch.support.Comm andLineJobRunner start
SEVERE: Job Terminated in error:
org.springframework.dao.DataAccessResourceFailureE xception: Could not obtain sequence value; nested exception is java
.sql.SQLException: ORA-02289: sequence does not exist

at org.springframework.jdbc.support.incrementer.Abstr actSequenceMaxValueIncrementer.getNextKey(Abstract Sequen
ceMaxValueIncrementer.java:78)
at org.springframework.jdbc.support.incrementer.Abstr actDataFieldMaxValueIncrementer.nextLongValue(Abst ractDa
taFieldMaxValueIncrementer.java:125)
at org.springframework.batch.core.repository.dao.Jdbc JobInstanceDao.createJobInstance(JdbcJobInstanceDa o.java
:110)
at org.springframework.batch.core.repository.support. SimpleJobRepository.createJobExecution(SimpleJobRe posito
ry.java:127)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoi npointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethod Invocation.invokeJoinpoint(ReflectiveMethodInvocat ion.ja
va:182)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :149)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.invoke(TransactionInterceptor.jav a:106)

at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :171)
at org.springframework.aop.framework.JdkDynamicAopPro xy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy0.createJobExecution(Unknown Source)
at org.springframework.batch.core.launch.support.Simp leJobLauncher.run(SimpleJobLauncher.java:102)
at org.springframework.batch.core.launch.support.Comm andLineJobRunner.start(CommandLineJobRunner.java:2 07)
at org.springframework.batch.core.launch.support.Comm andLineJobRunner.main(CommandLineJobRunner.java:25 4)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJava Mojo.java:271)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-02289: sequence does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 623)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:112)
at oracle.jdbc.driver.T4CStatement.execute_for_descri be(T4CStatement.java:351)
at oracle.jdbc.driver.OracleStatement.execute_maybe_d escribe(OracleStatement.java:896)
at oracle.jdbc.driver.T4CStatement.execute_maybe_desc ribe(T4CStatement.java:383)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:986)
at oracle.jdbc.driver.OracleStatement.executeQuery(Or acleStatement.java:1125)
at org.apache.commons.dbcp.DelegatingStatement.execut eQuery(DelegatingStatement.java:208)
at org.springframework.jdbc.support.incrementer.Abstr actSequenceMaxValueIncrementer.getNextKey(Abstract Sequen
ceMaxValueIncrementer.java:69)
... 23 more
Oct 1, 2010 8:39:22 PM org.springframework.context.support.AbstractApplic ationContext doClose
INFO: Closing org.springframework.context.support.ClassPathXmlAp plicationContext@61736e: display name [org.springfram
ework.context.support.ClassPathXmlApplicationConte xt@61736e]; startup date [Fri Oct 01 20:39:08 IST 2010]; root of co
ntext hierarchy
Oct 1, 2010 8:39:22 PM org.springframework.beans.factory.support.DefaultS ingletonBeanRegistry destroySingletons
INFO: Destroying singletons in org.springframework.beans.factory.support.DefaultL istableBeanFactory@1381960: defining
beans [jobLauncher,org.springframework.batch.core.configu ration.support.JobRegistryBeanPostProcessor#0,jobR epository
,jobOperator,jobExplorer,jobRegistry,jdbcTemplate, logAdvice,eventAdvice,dataSource,transactionManager,environment,ove
rrideProperties,placeholderProperties,org.springfr amework.batch.core.scope.internalStepScope,org.spr ingframework.bean
s.factory.config.CustomEditorConfigurer,fetchRecor d,counterJob,inputMemberSource,opWriter]; root of factory hierarchy


Thanks in Advance,
Kousik
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Spring batch 2.0 (How to stop calling sequence)
 
Similar Threads
Problem With StrutsTestCase
Error while executing query through JDBC
Weird error !!
SQLGrammarException: could not get next sequence value
JDBC Connection