Configure SN JDBC connection

Yes, we have our Lawson database using Oracle and I just went through this last week for MS SQL.
You can try following the screen shots without installing the Oracle JDBC driver.... but I suspect you'll need to install it.

Thanks Greg. I did same as in your screen shots, but it failed to connect. Did you install Oracle JDBC Driver somewhere?

It's been a LONG while since I've actually installed LBI...(upgraded a lot...)
but I'm sure that I did at one point install the Oracle JDBC driver. --- Check your LBI server for ojdbc something dot jar

Depending on your version of Oracle, it'll be ojdbc5.jar or ojdbc6.jar If you don't find one, you'll need to have your DBA install one.

Thanks again. Can you post your webshpere variables for Oracle JDBC driver path in websphere on LBI server. I did install ojdbc5.jar and point to the path. still no luck.

Xin,

Have you been able to create a data source in WebSphere and test it successfully? If so then I would recommend creating a JNDI connection in SN instead of struggling with the JDBC.

If you haven't created the Oracle provider in WebSphere just create a new data connection. You'll be prompted to select the provider type and it will walk you through setting up everything that's required.

Thank you Matthew.

I have successfully created JNDI data source in Websphere. However, when I tried to create datasource in SN using the same JNDI it failed the test with error as "Invalid arguments in CallDSRA0010E: SQL state=99999, Error code=17,068"

Did you test it in WebSphere and the test passed?

Yes, It passed in Websphere.

See attached screenshot.

then if you use the JNDI name from WebSphere (jdbc/LawsonSN for instance) in SN using a JNDI connection it should be the same.

Be sure you created the JNDI on the same scope (server, node, cell) as you have installed SmartNotes on.

I see that you entered just 'SNgen' for the JNDI name parameter... try entering jdbc/SNgen in both Websphere and SN for the JNDI name parameter.

I got it work. We need to add jdbc driver path to Websphere JVM classpath.