PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/13/2012 11:07 AM by  masonp
Installing and Configuring MSSQL JDBC for ProcessFlow Integrator
 23 Replies
Sort:
You are not authorized to post a reply.
Author Messages
John Henley
Private
Private
Senior Member
(9638 points)
Senior Member
Posts:3230


Send Message:

--
12/04/2008 4:11 PM

    Using SQL Update (as well as the SQL Query) nodes require locating/downloading and then installing/configuring JDBC drivers for your desired database(s) (e.g., Oracle, SQL Server, DB2, etc.) on your development workstation as well as your Lawson LSF9/ProcessFlow Server. You will also need some knowledge of JDBC connection string syntax. None of this is well-documented by Lawson (nor is configuration support provided by GSC). Here are instructions for installing/configuring MSSQL JDBC for ProcessFlow Integrator.

    Read Installing and Configuring MSSQL JDBC for ProcessFlow Integrator.

    Thanks for using the LawsonGuru.com forums!
    John
    mcissell
    Private
    Private
    Basic Member
    (19 points)
    Basic Member
    Posts:7


    Send Message:

    --
    12/04/2008 4:11 PM
    Hi John, I tried following these steps and now I get an error when I try to build my query "No Suitable Driver" Do I also need to install jar files on the DB server? Thanks, Marty
    mcissell
    Private
    Private
    Basic Member
    (19 points)
    Basic Member
    Posts:7


    Send Message:

    --
    12/04/2008 5:28 PM
    Turns out, if I actually type correctly, it works correctly. Thanks a million for the guide, I don't know how long this would have taken me without it.
    John Henley
    Private
    Private
    Senior Member
    (9638 points)
    Senior Member
    Posts:3230


    Send Message:

    --
    12/04/2008 7:02 PM
    Glad it was helpful!
    Thanks for using the LawsonGuru.com forums!
    John
    mcissell
    Private
    Private
    Basic Member
    (19 points)
    Basic Member
    Posts:7


    Send Message:

    --
    12/07/2008 3:56 PM

    hi John,

    I'm successfully using this in Designer, but the first time I tried to run it on the server I get the message:

    Please add jdbc driver to ProcessFlow Server classpath.

    SQLException: JDBC Driver not found: com.microsoft.jdbc.sqlserver:SQLServerDriver

    Any thoughts?

    Thanks,

    Marty

    John Henley
    Private
    Private
    Senior Member
    (9638 points)
    Senior Member
    Posts:3230


    Send Message:

    --
    12/07/2008 5:02 PM
    Did you add the jar files to pfserv config file, stop/start PF server?
    Thanks for using the LawsonGuru.com forums!
    John
    John Cunningham
    Private
    Private
    Advanced Member
    (73 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    11/05/2009 8:43 PM

    I am trying to do this on a UNIX server are there any differences.  I put the files in the correct location $GENDIR/bpm/jar but I still get the error "No Suitable Driver" 

    Thanks,

    John

    Joe Haveman
    Private
    Private
    Advanced Member
    (71 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    11/06/2009 10:51 AM

    There should be a config location that tells UNIX that the jar files are there.  You need to do this on the processflow server.

    John Cunningham
    Private
    Private
    Advanced Member
    (73 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    11/16/2009 8:24 AM
    When you say config location, do you mean the pfserv config or do you mean that it needs to be in the path?
    Brian6
    Basic Member
    (18 points)
    Basic Member
    Posts:8


    Send Message:

    --
    12/08/2009 3:29 PM
    Hi John,
    It looks like Microsoft no longer provides the SQL Server 2000 jdbc driver. Does Lawson now support 2005 with Processflow? If not do you know where I could get my hands on the 2000 drivers?

    thanks for your help
    Brian
    John Henley
    Private
    Private
    Senior Member
    (9638 points)
    Senior Member
    Posts:3230


    Send Message:

    --
    12/08/2009 3:53 PM
    No, Microsoft doesn't supply/support it anymore. Unfortunately you do have to use it in order to match the JVM version that ProcessFlow uses. If you use the MSSQL 2005 jdbc driver, you will spend a lot of time trying to get it to work, to no avail.
    Thanks for using the LawsonGuru.com forums!
    John
    John Cunningham
    Private
    Private
    Advanced Member
    (73 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    12/08/2009 8:31 PM

    Brian,

    I was able to get it to work with the 2005 sql driver for UNIX.  I downloaded it from the MS website.  The zip file is called sqljdbc_1.2.2828.100_enu.tar.gz.

    Brian6
    Basic Member
    (18 points)
    Basic Member
    Posts:8


    Send Message:

    --
    12/09/2009 8:43 AM
    Hi John and John,
    thanks for the responses. I'm actually trying to get it configured with the designer on my pc. I might be able to grab the drivers off an old install cd we have for SQL Server 2000. I thought that we were behind on technology...is Lawson ever going to move to a supported set of jdbc drivers? They've got(or used to have) the same issues with Oracle where the only support the 9i driver and I've heard there are issues with DB2 as well.
    John Cunningham
    Private
    Private
    Advanced Member
    (73 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    12/09/2009 9:10 AM
    There are instructions on the first post that walk you through step by step for installing it on the designer. The key is getting those jar files. I think that I actually had to search the internet for them. But you should be able to find them on your sql server 2000 cd. As far as when Lawson will support 2005 I could not tell you.
    Joe Haveman
    Private
    Private
    Advanced Member
    (71 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    12/18/2009 6:32 AM

    Brian,

    I'm a SQL dba and had the same problem.  I can help if you want.  We discussed this here:

    https://www.lawsonguru.com/Forums/tabid/96/aff/12/aft/6296/afv/topic/Default.aspx

    The location of the 2000 driver is here: (get it while it's still there!)

    http://drivers.softpedia....-Download-17961.html

    April
    Private
    Private
    Basic Member
    (37 points)
    Basic Member
    Posts:15


    Send Message:

    --
    12/18/2009 6:55 AM
    I am out of the office and will return on Friday December 18th. If you need immediate assistance, please contact the helpdesk at 410-871-6809.

    April Dunbar

    Shane Jones
    Private
    Private
    Veteran Member
    (1246 points)
    Veteran Member
    Posts:460


    Send Message:

    --
    01/07/2010 2:45 PM

    How about connecting to a simple MS Acess database?   Does this apply or is there a different node that should be used?

    Shane Jones
    Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
    Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
    ** Teach others to fish...
    John Henley
    Private
    Private
    Senior Member
    (9638 points)
    Senior Member
    Posts:3230


    Send Message:

    --
    01/07/2010 3:08 PM
    I haven't tried it--nor do I plan to :)
    But you should be able to create an ODBC connection against the Access database and use the JDBC wrapper for ODBC (sun.jdbc.odbc.JdbcOdbcDriver) ...

    Thanks for using the LawsonGuru.com forums!
    John
    JudeBac
    Private
    Private
    Veteran Member
    (335 points)
    Veteran Member
    Posts:129


    Send Message:

    --
    03/17/2010 8:52 AM
    I just installed PFI and next step is configure it to connect to MS SQL Server 2008, which is 64 bit. My workstation is Win XP 32bit Ver 2002.

    Looks like the JDBC drivers is in http://msdn.microsoft.com.../data/aa937724.aspx.

    Would appreciate if anyone can share their JDBC configuration in the same setup.

    Thank you
    JudeBac
    Private
    Private
    Veteran Member
    (335 points)
    Veteran Member
    Posts:129


    Send Message:

    --
    03/17/2010 9:48 AM
    I better discuss mine in https://www.lawsonguru.com/Forums/tabid/96/aff/12/aft/6296/afv/topic/Default.aspx
    JudeBac
    Private
    Private
    Veteran Member
    (335 points)
    Veteran Member
    Posts:129


    Send Message:

    --
    03/22/2010 8:56 AM

    I have configured GENDIR/bin/pfserv config to include JDBC

    Placed the sqljdbc4.jar and sqljdbc.jar to $GENDIR/bpm/jar. I tried to delete sqljdbc.jar, but it won't allow me with message "being used".

    I have added the line pfserv.common.classpath.5 %GENDIR%/bpm/jar/sqljdbc4.jar to $LAWDIR/system/pfserv.cfg

    Servers were restarted this morning which includes PFstart. And still get this error in PF designer when I test run a SQL Query to "Run on Server"

    Executing Sql ..... SELECT EMPLOYEE, LAST_NAME FROM lawson.EMPLOYEE where EMPLOYEE=9999
    SQLException: JDBC Driver not found: Undefined
    Please add jdbc driver to ProcessFlow Server classpath.

    Please note that running on my desktop "override JDBC" to use my local old JDBC driver, it will work.

    What am I missing?


    Thank you,

    Jude

    JudeBac
    Private
    Private
    Veteran Member
    (335 points)
    Veteran Member
    Posts:129


    Send Message:

    --
    03/22/2010 3:43 PM
    Came to find that the PF servers were not restarted this morning as requested. Sorry to crowd this thread. All my settings were fine.

    Use the old JDBC when testing, however the SQL Query build does not work. That is fine with me since I can just type my own SQL. On the server side, I use sqljdbc4.jar as earlier advised.

    Thank you all

    Jude
    masonp
    Systems Analyst
    Young Life
    (9 points)
    Posts:3


    Send Message:

    --
    03/07/2012 4:08 PM
    Has anybody tried doing this for the 9.0.1 eclipse version of the designer?  I'm getting the following error despite updating the the driver for JRE version 1.6.

    SQLException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
    masonp
    Systems Analyst
    Young Life
    (9 points)
    Posts:3


    Send Message:

    --
    03/13/2012 11:07 AM
    I found the answer to my problem.  Turns out you can't have both the sqljdbc.jar and sqljdbc4.jar file in the same directory on the server.  I deleted the sqljdbc.jar file and it finally recognized the sqljdbc4.jar file.  Now all is well.
    You are not authorized to post a reply.