JDBC for Process Flow

I am new to Lawson (I got the lucky assignment of being the new lawson technical admin and boy am I having fun.. I found this forum ).

My current issue is that my process flow programmer has asked that I install the oracle jdbc for a flow that he needs to develop.

I read through the process flow admin guide (Chapter 5) on page 46 found information about Configuring JDBC.

We are running LSF9 with 8.0.3.11 apps on an AIX box (unix)

I downloaded the JDBC driver from the Oracle site and dropped it into the $GENDIR/bpm/jar folder (as directed by the documentation)

Now I am to run the pfserv config command and place the configuration options into the process flow configuration and I am stuck.

The examples in the documentation are throwing me off my game.

The JDBC Driver: The name of the JDBC driver. The example shows "oracle.jdbc.driver.OracleDriver" Is this correct? This is the actual name, so I assume that the driver is contained within the jar file.. right?

The JDBC URL: I have no idea of what to put here? I don't even have a guess

The JDBC User: I am thinking that it would be an Oracle User that has permissions to the Lawson Data (like what I use in the ORACLE file).. Right?

The JDBC Password: Again just the password of the Oracle user.

Help on this would be great. Even pointing me to another location to find more information about this issue.

thanks in advance for any assistance
Tony

Talk to your Oracle Administrator. He will have to configure the internal jdbc connections, then he can supply you with the user,password, links, etc..

g'luck!!

My 2-cents'-worth: JDBC URL - If the same as must be supplied to WebSphere for JDBC Providers, will probably be in the format of: jdbc:oracle:oci:@ABCDEF where ABCDEF is the name of the Oracle schema which you will connect to. I believe that the schema name should be in the tnsnames.ora file which Oracle will use to look up connection information. Your Oracle DBA is going to have to assist you.

Here's a sample for you, hope this helps: