Xin LiPrivatePrivate (288 points) Veteran Member Posts:130  Send Message: 
| 01/28/2013 2:32 PM |
|
|
Anyone know how to configure JDBC connection to back end Oracle database? Do I need to install Oracle JDBC drive on LBII server or not?
|
|
|
|
Greg MoellerPrivatePrivate(3915 points) Veteran Member Posts:1391  Send Message:
| 01/28/2013 2:51 PM |
|
|
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.
|
|
|
|
Xin LiPrivatePrivate(288 points) Veteran Member Posts:130 Send Message:
| 01/28/2013 3:27 PM |
|
|
Thanks Greg. I did same as in your screen shots, but it failed to connect. Did you install Oracle JDBC Driver somewhere?
|
|
|
|
Greg MoellerPrivatePrivate(3915 points) Veteran Member Posts:1391 Send Message:
| 01/28/2013 3:54 PM |
|
|
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.
|
|
|
|
Xin LiPrivatePrivate(288 points) Veteran Member Posts:130 Send Message:
| 01/28/2013 4:52 PM |
|
|
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.
|
|
|
|
Matthew NyePrivatePrivate(1532 points) Veteran Member Posts:514  Send Message:
| 01/28/2013 5:03 PM |
|
|
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.
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated!
www.linkedin.com/pub/matthew-nye/1a/886/760/
|
|
|
|
Xin LiPrivatePrivate(288 points) Veteran Member Posts:130 Send Message:
| 01/29/2013 10:58 AM |
|
|
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"
|
|
|
|
Matthew NyePrivatePrivate(1532 points) Veteran Member Posts:514 Send Message:
| 01/29/2013 11:19 AM |
|
|
Did you test it in WebSphere and the test passed?
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated!
www.linkedin.com/pub/matthew-nye/1a/886/760/
|
|
|
|
Xin LiPrivatePrivate(288 points) Veteran Member Posts:130 Send Message:
| 01/29/2013 12:44 PM |
|
|
Yes, It passed in Websphere.
See attached screenshot.
|
|
|
|
Matthew NyePrivatePrivate(1532 points) Veteran Member Posts:514 Send Message:
| 01/29/2013 3:29 PM |
|
|
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.
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated!
www.linkedin.com/pub/matthew-nye/1a/886/760/
|
|
|
|
Greg MoellerPrivatePrivate(3915 points) Veteran Member Posts:1391 Send Message:
| 01/29/2013 3:37 PM |
|
|
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.
|
|
|
|
Xin LiPrivatePrivate(288 points) Veteran Member Posts:130 Send Message:
| 01/30/2013 4:06 PM |
|
|
I got it work. We need to add jdbc driver path to Websphere JVM classpath.
|
|
|
|