Narendra Dhande

Hi,
I am using Spring batch 2.2.7 for data processing. The process run in the Tasklet. While processing the data I want to write the information log in the separate file for each batch run instance according to batch Id. Since It is written as cutom Tasklet all the codes are running the execute methods.

public RepeatStatus execute(StepContribution contribution, ChunkContext chunkContext) throws Exception { // some processing here lofToFile(fileName, "message here"); } public void logToFile(String filename, String data) { try { //File file = new File(filename); //FileUtils.writeStringToFile(file, data + "\n","UTF-8", true); if ( Files.notExists(path, LinkOption.NOFOLLOW_LINKS)) { Files.createFile(path); } //Files.write(path, data.getBytes(),StandardOpenOption.SYNC,StandardOpenOption.APPEND); BufferedWriter napis = Files.newBufferedWriter(path,Charset.forName("ISO-8859-1"),StandardOpenOption.SYNC,StandardOpenOption.APPEND); napis.write(data); napis.flush(); napis.close(); } catch (Exception e) { logger.info("Error while writing file log ", e); } }

The codes are working file. but when there is exception in the batch processing, transaction rollback happens and the log written in the file is also vanishes. I want to preserve the contains of this file.
Please suggest the appropriate alternative.

Hi,

The problem is with package name

SELECT DISTINCT new in.mycompany.CustomerProfile( c.name, c.phone ) FROM Customer c WHERE c.id = 100

The prefix is 'in' instead of 'com'. While parsing the query the 'in' is treated as reserved world. As the 'in'(India) prefix is required, is there is any way to escape the package name in queries.

Thanks

Hi,

I am trying the query with JPA ( Hibernate 4.1.4)

SELECT DISTINCT new com.mycompany.CustomerProfile( c.name, c.phone ) FROM Customer c WHERE c.id = 100

If the constructor expression is removed, the query work file and return Object[],
With the constructor expression, gives the following error at the time of loading the application to the container. Both the c.name and c.phone are String type and the CustomerProfile have constructor for the agruments.

Caused by: java.lang.ClassCastException: org.hibernate.hql.internal.ast.tree.SqlNode cannot be cast to org.hibernate.hql.internal.ast.tree.FromReferenceNode at org.hibernate.hql.internal.ast.tree.DotNode.getLhs(DotNode.java:614) at org.hibernate.hql.internal.ast.tree.DotNode.getPath(DotNode.java:629) at org.hibernate.hql.internal.ast.tree.DotNode.getPath(DotNode.java:635) at org.hibernate.hql.internal.ast.tree.DotNode.getPath(DotNode.java:635) at org.hibernate.hql.internal.ast.tree.ConstructorNode.prepare(ConstructorNode.java:142) at org.hibernate.hql.internal.ast.HqlSqlWalker.processConstructor(HqlSqlWalker.java:1019) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectExpr(HqlSqlBaseWalker.java:2138) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectExprList(HqlSqlBaseWalker.java:2004) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectClause(HqlSqlBaseWalker.java:1445) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:571) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168) at org.hibernate.internal.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:1132) at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:525) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1744) at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:94) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:905) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:890) at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74) at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:286) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:310) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1545) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1483)

any hints to rectify the problem ?

Thanks

Dear all,

I am using JPA layer from application development. The environment is tomcat 7, Hibernate 4.1.4 and database is Sybase ASE 15.7 Developer edition. The JPA context is built using Hibernate. I am trying the pagination Query, but it is giving the strange results.
The JPA Query is :
@NamedQuery(name = "cbValidationJobRegister.findJobsByParams", query = "SELECT c FROM CbValidationJobRegister c WHERE c.param IN :param ORDER BY c.id DESC") ,
The Query in the dao is
@Transactional(readOnly = true) public List<CbValidationJobRegister> getCurrentResults(int currentPage, int pageSize, final List<String> param) { List<CbValidationJobRegister> list = entityManager .createNamedQuery("cbValidationJobRegister.findJobsByParams", CbValidationJobRegister.class) .setFirstResult(currentPage * pageSize) .setMaxResults(pageSize).setParameter("param", param) .getResultList(); return list; }

The execution is
List<CbValidationJobRegister> l ; System.out.println("Query - 1"); l= cbValidationJobRegisterDao.getCurrentResults(0,5,getUserBus()); for (CbValidationJobRegister i : l ) { System.out.println(i.getId()); } System.out.println("Query - 2"); l= cbValidationJobRegisterDao.getCurrentResults(1,5,getUserBus()); for (CbValidationJobRegister i : l ) { System.out.println(i.getId()); } System.out.println("Query - 3"); l= cbValidationJobRegisterDao.getCurrentResults(2,5,getUserBus()); for (CbValidationJobRegister i : l ) { System.out.println(i.getId()); } System.out.println("Query - 4"); l= cbValidationJobRegisterDao.getCurrentResults(4,5,getUserBus()); for (CbValidationJobRegister i : l ) { System.out.println(i.getId()); } System.out.println();

There are 36 records in the sybase table. the Ids are primary key and the field is IDENTITY.
The Result is

Query - 1 36 35 34 33 32 Query - 2 33 32 31 30 29 Query - 3 33 32 31 30 29 Query - 4 33 32 31 30 29

The Query 1 and Query 2 shows the correct results, but after that the query generating the same result for next offsets.

Please help to sort out the problem. Any Sybase specific setting are required ?

Thanks

Hi,

Found the problem. The sybase database is running in development environment and shut down everyday. There is identity gap due to this.

Thanks

Dear all,

I am using the spring batch 2.1.9. The jobRepository is setup using the sybase database. Everything is running fine. But while creation of job-ids the job ids are not in sequential manner. Every day the sequence is prefixes with different number and generating the job ids from one. I want the behaviour to start the sequenece number from 1 and continues by incrementing by 1 for every new job.

Is any setting at xml configuration level or database level needs to change ?

The job repository is defined as
<bean id="jobRepository" init-method="" class="org.springframework.batch.core.repository.support.JobRepositoryFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="transactionManager" ref="transactionManager" /> <property name="isolationLevelForCreate" value="ISOLATION_DEFAULT" /> <property name="databaseType" value="sybase" /> <property name="tablePrefix" value="BATCH_" /> <property name="lobHandler" ref="lobHandler" /> </bean>

and the sequence table definition from jar is

CREATE TABLE BATCH_STEP_EXECUTION_SEQ (ID BIGINT IDENTITY); CREATE TABLE BATCH_JOB_EXECUTION_SEQ (ID BIGINT IDENTITY); CREATE TABLE BATCH_JOB_SEQ (ID BIGINT IDENTITY);

Thanks

Yes, The database using ISO charset and the application is using UTF-8. May be there is a problem while conversion. Previously I put the jdbc jar files in glassfish/endorsed directory. Now I have shifted them to domain_dir/lib directory. I think the problem is not related exactly to the application, but related to glassfish gizzy framework.
Thanks

Hi,

The first problem may be the proxy. The STS take the proxy setting from your system proxy, but the maven is not. Set the appropriate maven proxy setting.

If you have direct connection, you can try follwing :
1. Right click on the your project name in the right side pane. Select Maven, then select Update project Configuration and check the box 'Force Update Snapshot/Release'. This will update your project maven dependencies.
2. If the problem still exists, Right click the project, select Run As -> maven Install, This will update your maven plugins.

Thanks

Hi Mark

Instead of using the batch namespec I have defined the bean for jobRepository and now it is working fine. The additional property is the databaseType

<bean id="jobRepository" init-method="" class="org.springframework.batch.core.repository.support.JobRepositoryFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="transactionManager" ref="transactionManager" /> <property name="databaseType" value="sybase"/> </bean>

Thanks

Hi Bill,

I had used similar solutions and worked fine. After some efforts I found the problem. The problem is the bug in the Glassfish 3.1.2. After installing the suggested patch it is working fine.
The JiRA link is Glassfish Jira

Thanks .

Hi Bill,

The debug log shows me that the method is mapped correctly to URL.

Thanks

Hi Bill,

The problem is due to the wrong placement of JDBC jar file. The problem is resolved after correcting the error.

Thanks

Hi all

I am trying to write the fileUploader controller.

The JSP code are :

<form method="post" action="validation" enctype="multipart/form-data"> <input type="file" id="filename" name="filename" /> <input type="submit" value="Upload File" /> </form>

The controller method is

@RequestMapping(value = "/validation/validation", method = RequestMethod.POST) public String post(@RequestParam(value="filename", required=false) MultipartFile file, HttpServletRequest req, HttpServletResponse response) throws Exception { ......

The request is mapped correctly to the method when I execute the code.

The Multipart resolver configured in context is



<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <!-- one of the properties available; the maximum file size in bytes --> <property name="maxUploadSize" value="10000000" /> </bean>

The spring version I am using is 3.1.1 The application server is glassfish 3.1.2

The error is


INFO: 2012-06-26 19:20:46,006 [http-thread-pool-9090(5)] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'test' processing POST request for [/test/validation/validation] INFO: 2012-06-26 19:20:46,052 [http-thread-pool-9090(5)] DEBUG org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /validation/validation INFO: 2012-06-26 19:20:46,053 [http-thread-pool-9090(5)] DEBUG org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Returning handler method [public java.lang.String in.mahadiscom.web.ValidationController.post(org.springframework.web.multipart.MultipartFile,javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) throws java.lang.Exception] INFO: 2012-06-26 19:20:46,053 [http-thread-pool-9090(5)] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'validationController' INFO: 2012-06-26 19:20:46,068 [http-thread-pool-9090(5)] DEBUG org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver - Resolving exception from handler [public java.lang.String in.mahadiscom.web.ValidationController.post(org.springframework.web.multipart.MultipartFile,javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) throws java.lang.Exception]: org.springframework.web.bind.MissingServletRequestParameterException: Required MultipartFile parameter 'filename' is not present INFO: 2012-06-26 19:20:46,073 [http-thread-pool-9090(5)] DEBUG org.springframework.web.servlet.mvc.annotation.ResponseStatusExceptionResolver - Resolving exception from handler [public java.lang.String in.mahadiscom.web.ValidationController.post(org.springframework.web.multipart.MultipartFile,javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) throws java.lang.Exception]: org.springframework.web.bind.MissingServletRequestParameterException: Required MultipartFile parameter 'filename' is not present INFO: 2012-06-26 19:20:46,073 [http-thread-pool-9090(5)] DEBUG org.springframework.web.servlet.mvc.support.DefaultHandlerExceptionResolver - Resolving exception from handler [public java.lang.String in.mahadiscom.web.ValidationController.post(org.springframework.web.multipart.MultipartFile,javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) throws java.lang.Exception]: org.springframework.web.bind.MissingServletRequestParameterException: Required MultipartFile parameter 'filename' is not present

The browser return HTTP 400 with message descriptionThe request sent by the client was syntactically incorrect ().

Pl. Help

Thanks

Hi all,


I am trying to setup small Spring Roo application. The setup is STS 2.9.2 , Spring Roo 1.2.2 and the glassfish 3.1.2. After creating new Spring Roo project. I issued only follwing command

web mvc setup

The initial application was successfully built and running on the VFbric default server. When I try to depoly the application on Glassfish The deployment error occurs. The Glassfish is configured through the eclipes server adopter in STS. I am not getting any clue what the exact error is. I guess , the error is due to the nio package , which is throwing the NullPointerException. The full error message is as in attatchment
INFO: 2012-06-25 13:07:54,955 [admin-thread-pool-4848(3)] ERROR org.springframework.web.servlet.DispatcherServlet - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter#0': Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter]: Constructor threw exception; nested exception is java.lang.NullPointerException at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:997) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:943) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) ............. Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter]: Constructor threw exception; nested exception is java.lang.NullPointerException at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:162) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:76) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:990) ... 60 more Caused by: java.lang.NullPointerException at java.nio.charset.Charset.put(Charset.java:512) at java.nio.charset.Charset.access$300(Charset.java:240) at java.nio.charset.Charset$4.run(Charset.java:553) at java.security.AccessController.doPrivileged(Native Method) at java.nio.charset.Charset.availableCharsets(Charset.java:546) at org.springframework.http.converter.StringHttpMessageConverter.<init>(StringHttpMessageConverter.java:52) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.<init>(RequestMappingHandlerAdapter.java:143) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147) ... 62 more
Pl. help

Thanks

Hi Mark,

The application run correctly if I use the jdbc 3 drivers. The problem is , we are going to use Sybase ASE 15.7 in production. For this the jconnect drivers 3 are not supplied by default. Only jconn4.jar is available with distribution. My question is, if the particular method is not supported with the sybase drivers, how it was used in the spring batch implementation. The sybase documentation stated that if, the method is unimplemented, do not use the method.

Thanks