Questions about listprovider connecting to Siebel Oracle DB

913983 Oct 19, 2012 2:15 AM

Currently Being Moderated

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?

Philip.

1. Re: Questions about listprovider connecting to Siebel Oracle DB

frank.hampshire Oct 21, 2012 2:42 PM (in response to 913983)

Currently Being Moderated

Phillip,

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.

Cheers
Frank
Report Abuse

Like (0)

Actions

Legend

Correct Answers - 10 points
Helpful Answers - 5 points