This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark ""Add Sequence" (with Pentaho and Oracle)" Watch ""Add Sequence" (with Pentaho and Oracle)" New topic
Author

"Add Sequence" (with Pentaho and Oracle)

John Borys
Greenhorn

Joined: Jul 21, 2004
Posts: 10
posted
0
Quote
I am trying to create a simple data load from an Excel spreadsheet to an Oracle Database. The primary key for the table to be loaded is an Oracle Sequence. There is nothing in the Oracle Bulk Loader that addresses sequences.

How do I integrate the Add sequence under "Transform" to insert a new sequence number into a Table while loading data.
I have tried using it as a step that passes along the next value to the Excel spreadsheet but have not been able to get it to actually load the data. Is there documentation on this any where? Do you cover this topic in your book?
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: "Add Sequence" (with Pentaho and Oracle)
 
Similar Threads
Outputting sql output to spreadsheet
Servlet MS Excel.
using ms excel as a database
web reporting...
Exporting Data (Excel to Oracle)