Win a copy of TDD for a Shopping Website LiveProject this week in the Testing forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

Spring batch 2.1.8 jobRepository creation problem

 
Narendra Dhande
Ranch Hand
Posts: 951
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,

I am developing batch job using spring batch. The application server is Glassfish 3.1.1 and the database is sybase ASE 15.2 . The JDBC driver file is jconn4.jar. The application context contains the following codes


The JNDI datasource is working file. while deploying the application following error is received.




do not have any idea about getClientInfo() method and why it require to initiate jobRepository.

Please give the solution.

Thanks


 
Mark Spritzler
ranger
Posts: 17346
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Are the Spring Batch tables created on your database?

Mark
 
Narendra Dhande
Ranch Hand
Posts: 951
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Dear Mark,

Yes, actually the application is running fine , if I change the JDBC drivers to type 3 level. For this I have to use jconn3.jar provided with sybase. My JPA is using the Jdbc type 4 (jconn4.jar). The Sybase version I am using is 15.5 and not 15.2.
Somewhere I found that the getClientInfo() method is related to JDBC type 4. Please suggest , is it feasible to downgrade the JDBC level for whole application. I am getting time precision related warning by JPA provider (hibernate) if I use jconn3.jar.

I am not considering jTds open source drivers as the high availability and DTM modes are not working with it.

Please suggest.

Thanks
 
Mark Spritzler
ranger
Posts: 17346
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Not sure. You could try to run your application with the Jdbc 3 driver and see what happens.

Mark
 
Narendra Dhande
Ranch Hand
Posts: 951
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Mark Spritzler
ranger
Posts: 17346
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I haven't looked at any exact code in the depth of Spring Batch internal code, but it is open source and you can download it and try to find where that method is called. But I don't think just commenting out that line will make it work. Just because Sybase doesn't provide the driver by default, why can't you still use the one that you do have?

It just sounds like you have a compatibility issue where Batch doesn't support Jdbc4 drivers and would have to wait for an update of Batch in the future that might support it. I recommend posting on the Spring Batch forum at www.springframework.org. There you will probably get a reply from the Batch developers themselves.

Good Luck

Mark
 
Narendra Dhande
Ranch Hand
Posts: 951
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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



Thanks

 
Surfs up space ponies, I'm making gravy without this lumpy, tiny ad:
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter
reply
    Bookmark Topic Watch Topic
  • New Topic