PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/30/2013 4:06 PM by  Xin Li
Configure SN JDBC connection
 11 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Xin Li
Private
Private
Veteran Member
(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 Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    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.
    Attachments
    Xin Li
    Private
    Private
    Veteran Member
    (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 Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    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 Li
    Private
    Private
    Veteran Member
    (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 Nye
    Private
    Private
    Veteran Member
    (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 Li
    Private
    Private
    Veteran Member
    (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 Nye
    Private
    Private
    Veteran Member
    (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 Li
    Private
    Private
    Veteran Member
    (288 points)
    Veteran Member
    Posts:130


    Send Message:

    --
    01/29/2013 12:44 PM
    Yes, It passed in Websphere.

    See attached screenshot.
    Attachments
    Matthew Nye
    Private
    Private
    Veteran Member
    (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 Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    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 Li
    Private
    Private
    Veteran Member
    (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.
    You are not authorized to post a reply.