I 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?
Assuming you are using either Web Determinations or Determinations Server (and not the engine directly), you need to put the Oracle DB jar file in the WEB-INF/lib directory so it can find the class.
A common mistake is to put it in the Plugins directory, but it won't be added to the classpath there.