Questions about listprovider connecting to Siebel Oracle DB
913983Oct 19 2012 — edited Oct 21 2012I am building a listprovider that connects to the list of values table of Siebel. I have two questions:
(for the record: I am an OPA developer/architect and not a Siebel/Java guru)
1) How do I connect to the Oracle DB (10.2.0.1.0) and to the table itself? I have tried the 'oracle.jdbc.OracleDriver' with Class.forName(driver); but it fails. I have added 'ojdbc14.jar' to the build path.
2) How can I use a properties file to parameterise some of the statements. I want to set a relative path to the configuration directory of web determinations, but do not know how. Is there a way to reference to this directory?
Philip.