Configure SN JDBC connection

Sort:
You are not authorized to post a reply.
Author
Messages
Xin Li
Veteran Member
Posts: 133
Veteran Member
    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
    Veteran Member
    Posts: 1498
    Veteran Member
      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
      Veteran Member
      Posts: 133
      Veteran Member
        Thanks Greg. I did same as in your screen shots, but it failed to connect. Did you install Oracle JDBC Driver somewhere?
        Greg Moeller
        Veteran Member
        Posts: 1498
        Veteran Member
          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
          Veteran Member
          Posts: 133
          Veteran Member
            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
            Veteran Member
            Posts: 514
            Veteran Member
              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
              Veteran Member
              Posts: 133
              Veteran Member
                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
                Veteran Member
                Posts: 514
                Veteran Member
                  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
                  Veteran Member
                  Posts: 133
                  Veteran Member
                    Yes, It passed in Websphere.

                    See attached screenshot.
                    Attachments
                    Matthew Nye
                    Veteran Member
                    Posts: 514
                    Veteran Member
                      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
                      Veteran Member
                      Posts: 1498
                      Veteran Member
                        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
                        Veteran Member
                        Posts: 133
                        Veteran Member
                          I got it work. We need to add jdbc driver path to Websphere JVM classpath.
                          You are not authorized to post a reply.