JdbcCursorItemReader « Database « Spring Q&A





1. JdbcCursorItemReader Example    forum.springsource.org

2. Extending JdbcCursorItemReader no longer reads db.    forum.springsource.org

Extending JdbcCursorItemReader no longer reads db. I am trying to extend the JdbcCursorItemReader so that I can dynamically set the SQL select statement. Starting with a working batch job that retrieves ...

3. Connection problems in JdbcCursorItemReader    forum.springsource.org

Connection problems in JdbcCursorItemReader I've been developing a batch system based on Spring Batch 2.1.5 and I've used the JdbcCursorItemReader as the reader component to run against an Oracle database. The ...

4. JdbcCursorItemReader is hung    forum.springsource.org

JdbcCursorItemReader is hung Hi, I've a job which writes a flat file after reading the data from database using JdbcCursorItemReader. Also, I've a ItemWriteListener which is registered inside ItemWriteListener. When, I ...

5. Chunk handling from JdbcCursorItemReader    forum.springsource.org

Chunk handling from JdbcCursorItemReader Bonjour, I am trying to adapt the sample in RemoteChunkStepIntegrationTests-context.xml by changing the following: 1) Use JdbcCursorItemReader 2) Write directly to the "requests" channel from the ItemWriter ...

6. How to pass dynamically params to sql when using JdbcCursorItemReader    forum.springsource.org

How to pass dynamically params to sql when using JdbcCursorItemReader Hi, I have read about ListPreparedStatementSetter, listeners, JobContext, StepContext, etc. but, I need to set the sql parameters dynamically and I ...

7. JdbcCursorItemReader & AsyncTaskExecutor    forum.springsource.org

ERROR [AbstractStep] Encountered an error executing the step org.springframework.jdbc.UncategorizedSQLException : Attempt to process next row failed; uncategorized SQLException for SQL [select * from MY_TABLE]; SQL state [null]; error code [17011]; exhausted ...

8. Late binding use in JdbcCursorItemReader    forum.springsource.org

Jul 25th, 2011, 04:46 PM #1 ricardo87 View Profile View Forum Posts Private Message Junior Member Join Date Jul 2011 Posts 5 Late binding use in JdbcCursorItemReader Hi, i would like ...

9. Exception Handling with JDBCCursorItemReader    forum.springsource.org

Exception Handling with JDBCCursorItemReader I'm new to Spring Batch and am seeking help regarding the following. I have a job with a single step which has an itemReader, itemProcessor and ItemWriter. ...





10. JdbcCursorItemReader - Connection    forum.springsource.org

JdbcCursorItemReader - Connection Hi All, I have a batch that contain one master job with a tasklet step. Inside the tasklet I will register the job (Considering as child job) and ...

11. Configure 2 Databases using JdbcCursorItemReader    forum.springsource.org

I have a requirement where I need to read 2 databases. I am able to read input from a single database however I dont know whether we can configure more than ...

12. Dynamic SQL in JdbcCursorItemReader    forum.springsource.org

Dynamic SQL in JdbcCursorItemReader Hello all i was wondering if i can build, for my jdbcCursorItemReader, a sql like this . Assuming i defined in my jobParameters a parameter name Code: ...

13. Iterating again on a second request for each item with JdbcCursorItemReader    forum.springsource.org

Iterating again on a second request for each item with JdbcCursorItemReader Hello, I need to use a JdbcCursorItemReader, and for each red item, call a second SQL request and iterate again. ...

14. JdbcCursorItemReader and 'IN' parameter lists    forum.springsource.org

Hi Spring's JdbcTemplate supports providing an array of arguments to be populated into a sql statement containing an "in" eg "SELECT column FROM tble WHERE id IN ( :values )" I've ...

15. jdbccursoritemreader issue    forum.springsource.org

jdbccursoritemreader issue Hi, before i start the step i got listener to set the sql like something select * from b where b.i=01 and b.k=02. The data in the table should ...

16. JdbcCursorItemReader / DB2 - limited rows read before out of memory    forum.springsource.org

JdbcCursorItemReader / DB2 - limited rows read before out of memory Hi, I'm using the JdbcCursorItemReader for some benchmarking exercises against a very large table in DB2 (type 4, z/OS connect). ...





17. JdbcCursorItemReader / DB2 - limited rows read before out of memory    forum.springsource.org

JdbcCursorItemReader / DB2 - limited rows read before out of memory Hi, I'm using the JdbcCursorItemReader for some benchmarking exercises against a very large table in DB2 (type 4, z/OS connect). ...

18. How to create empty file - JdbcCursorItemReader    forum.springsource.org

I am using JdbcCursorItemReader and FlatFileItemWriter. There is no data so framework does not create empty file. We have business requirement to create empty file when there is no data. Is ...

19. JdbcCursorItemReader - Stored Procedure call    forum.springsource.org

JdbcCursorItemReader - Stored Procedure call Currently I am using JdbcCursorItemReader and FlatFileItemWriter in a job step. Due to performance issue we have to use stored procedure. Is there a way to ...

20. Unable to use JdbcCursorItemReader    forum.springsource.org

Unable to use JdbcCursorItemReader I am trying to use JdbcCursorItemReader as a reader and then write to a flat file. When i run the job, i get the following error: Code: ...

21. JdbcCursorItemReader. Frequent Start/Stop job throws UncategorizedSQLException.    forum.springsource.org

JdbcCursorItemReader. Frequent Start/Stop job throws UncategorizedSQLException. I have a spring batch application running on an app server. I have a given a provision to the user to stop the job in ...

22. JdbcCursorItemReader parameters for sql    forum.springsource.org

Hi guys, I have tried setting some parameters on my sql query in the applicationContext.xml via the late binding features, but that did not work for me. Is there another way ...

23. Chunking JdbcCursorItemReader    forum.springsource.org

Hi, is there any support in Spring Batch to chunk/repeat the JdbcCursorItemReader based on a query criteria range, eg. id between lowId and highId. I want to read a very large ...

24. Use Stored procedure for JdbcCursorItemReader    forum.springsource.org

Guys, I'm wiring my JdbcCursorItemReader with a SQL query in my xml config file. This query is getting rather large and it changes frequently. Is it possible to use the reader ...

25. JdbcCursorItemReader and JdbcPagingItemReader    forum.springsource.org

in springbatch2.0, when read from database, there are two options: JdbcCursorItemReader and JdbcPagingItemReader. the former can config "fetchSize", the later similar property is "pageSize". both can fetch many records in one ...

26. 2 datasource in one JdbcCursorItemReader?    forum.springsource.org

2 datasource in one JdbcCursorItemReader? Hello, I must to pull data from 2 datasource (2 Mysql DB) and then perform some business modification on this... For now, I just configured one ...

27. JDBCCursorItemReader - Multithreading    forum.springsource.org

JDBCCursorItemReader - Multithreading Hi, We have table of 100,000 records or so and Id column is primary key. And we decided to use multithreading using taskExecutor. The question that the team ...

28. JdbcCursorItemReader - Dynamic values    forum.springsource.org

Hi, In JdbcCursorItemReader, we have to set the SQL query string in job configuration XML file. Is it possible to parameterize them / send dynamic values from the program? E.g: Can ...

29. JdbcCursorItemReader    forum.springsource.org

Hi Is the JdbcCursorItemReader thread-safe ? I ask the question because if the verifyCursorPosition is true, the reader throws a exception. (I'm using SB 2.0.0) Thanks for answers.

30. Connection used for consecutive fetch : JdbcCursorItemReader    forum.springsource.org

Connection used for consecutive fetch : JdbcCursorItemReader Hi, Spring batch version used in the project:1.1.2.RELEASE During consecutive database queries to fetch results sets for processing, does JdbcCursorItemReader use a single connection/open ...

31. JdbcCursorItemReader with stored procedure call    forum.springsource.org

JdbcCursorItemReader with stored procedure call Hi all, There are any implementation of a JdbcCursorItemReader class that accept ResultSets from stored procedures? If not, Which is the best approach to implement one? ...

32. Using JdbcCursorItemReader with join clause and restart    forum.springsource.org

Using JdbcCursorItemReader with join clause and restart Hello, Summary We need to retrieve client items from a database (the data spans 2 tables) and for each client its contracts (1 client ...

33. is it possible to pass the sql to JdbcCursorItemReader dynamically?    forum.springsource.org

Example of JdbcCursorItemReader configuration: I need to pass the ...

34. Calling a Stored Procedure by writing custom class that extends JdbcCursorItemReader    forum.springsource.org

Calling a Stored Procedure by writing custom class that extends JdbcCursorItemReader Hi, We have a requirement of reading the data from a Stored Procedure rather than plain SQL. Since there is ...

35. JdbcCursorItemReader - Setting PreparedStatementSetter    forum.springsource.org

JdbcCursorItemReader - Setting PreparedStatementSetter Hello -- I am learning how to utilize the JdbcCursorItemReader within a Job. I started with the Spring Batch sample and created a working job that will ...

36. JdbcCursorItemReader reads nothing the second time    forum.springsource.org

JdbcCursorItemReader reads nothing the second time Hi, I search on the web using google and also on this forum but I could not find anyone that had a problem like mine. ...

37. Display SQL Property for JdbcCursorItemReader    forum.springsource.org

Display SQL Property for JdbcCursorItemReader Hi All, Is there any way we can display sql we configure as property for JdbcCursorItemReader. Eg:

38. JdbcCursorItemReader with named parameters    forum.springsource.org

JdbcCursorItemReader with named parameters Hello, is it possible to use named parameters with the JdbcCursorItemReader? I'm aware of setPreparedStatementSetter(PreparedStatementSetter preparedStatementSetter), but with it you have no named parameters. regards docstrange e.g. ...

39. JDBCCursorItemReader - read multiple rows as one object    forum.springsource.org

Hi, I`m using JdbcCursorItemReader to read database. How can I read multiple rows with one cursor call? This resultset (say about 5 rows) should be mapped to one object with mapper. ...

40. JdbcCursorItemReader test fails on step scope    forum.springsource.org

Jan 29th, 2010, 04:43 PM #1 Shriblue View Profile View Forum Posts Private Message Member Join Date Oct 2009 Location San Francisco CA Posts 42 JdbcCursorItemReader test fails on step scope ...

41. updatetable JdbcCursorItemReader    forum.springsource.org

updatetable JdbcCursorItemReader Hello, we are converting programs with a complex business logic, we didn't want to change. In this programs updateable cursors are used for tables with no primary key. In ...

42. Pass parameter with JdbcCursorItemReader    forum.springsource.org

Hi everybody. I'm with a problem when I pass parameter to class that extends JdbcCursorItemReader. I did the same class implementing the ItemReader interface and it worked, the problem is I ...

43. problem with jdbcCursorItemReader    forum.springsource.org

May 26th, 2010, 10:17 AM #1 rubenalia View Profile View Forum Posts Private Message Junior Member Join Date Apr 2010 Posts 21 problem with jdbcCursorItemReader Hi all, I want to read ...

44. spring batch JdbcCursorItemReader failure    forum.springsource.org

Jun 11th, 2010, 04:24 AM #1 shadowLaw View Profile View Forum Posts Private Message Member Join Date Nov 2008 Location Tunisia Posts 66 spring batch JdbcCursorItemReader failure hi all, i'm developping ...

45. JdbcCursorItemReader parameterized using stepExecutionContext    forum.springsource.org

JdbcCursorItemReader parameterized using stepExecutionContext Hi Guys, I created the job with partitioning using the sample partitionJdbcJob, however I'm experiencing strange problem on passing minValue,maxValue to the JdbcCursorItemReader using stepExecutionContext. The job ...