Does anyone have an example connecting to Oracle for the .net batch processor?
What would the config <options> look like for .Net?
I want to try that out, as the java/jdbc is very sloooooowwwww....
Here is what the jdbc connection looks like:
<output type="db" />
I have a simple table with 1,000,000 records in it that maps to "global". I can process those same records in a few minutes as a CSV file on my local PC. It takes hours on the database before it completes.
Maybe the problem is not having enough documentation on the --blocksize <number> parameter and so it is committing after every row? Maybe I should write back to the same table I read from?
In any case, I need to try other things like the .Net drivers.
It would be 10x faster to download the data into a CSV file, process the CSV file, and then upload the results back into the database.
Thoughts? Thank you (ps. I may not get back to this until Monday.)
I should rephrase the questions...
Can someone provide an example of a batch .Net config to connect to Oracle?
Are there any parameters to tune from the OPA side of the house for databases (specifically Oracle)? (For instance, is --blocksize relevant with Oracle?)
The .NET version of the Batch Processor does not currently support database connections. As identified in the documentation - see http://docs.oracle.com/html/E36316_01/Content/Batch%20Processor/Dbase_Input_for_Batch_Processor.htm - database connectivity is supported for the Java version only.
Edited by: Ben O'Keeffe on 24-Sep-2012 16:56
Edited by: Ben O'Keeffe on 24-Sep-2012 16:58
Ah. That solves my .Net connectivity problem :-)
Now I have to figure out why a single oracle table with only 5 input columns for the conditions and 1 output column for the conclusion is taking so long to process...
Since I have now examined every variable available to me from OPA, I can ask the DBAs to look on their side.