1. JdbcCursorItemReader Example forum.springsource.org |
2. Extending JdbcCursorItemReader no longer reads db. forum.springsource.orgExtending 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.orgConnection 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.orgJdbcCursorItemReader 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 |
5. Chunk handling from JdbcCursorItemReader forum.springsource.orgChunk 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.orgHow 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.orgERROR [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.orgJul 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.orgException 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.orgJdbcCursorItemReader - 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.orgI 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.orgDynamic 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.orgIterating 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.orgHi 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.orgjdbccursoritemreader 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.orgJdbcCursorItemReader / 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.orgJdbcCursorItemReader / 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.orgI 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.orgJdbcCursorItemReader - 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.orgUnable 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.orgJdbcCursorItemReader. 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.orgHi 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.orgHi, 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.orgGuys, 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.orgin 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.org2 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.orgJDBCCursorItemReader - 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.orgHi, 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.orgHi 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.orgConnection 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.orgJdbcCursorItemReader 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.orgUsing 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.orgExample of JdbcCursorItemReader configuration: |
34. Calling a Stored Procedure by writing custom class that extends JdbcCursorItemReader forum.springsource.orgCalling 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.orgJdbcCursorItemReader - 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.orgJdbcCursorItemReader 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.orgDisplay 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.orgJdbcCursorItemReader 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.orgHi, 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.orgJan 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.orgupdatetable 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.orgHi 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.orgMay 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.orgJun 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.orgJdbcCursorItemReader 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 ... |