Installing and Configuring MSSQL JDBC for ProcessFlow Integrator

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

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.

Glad it was helpful!

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

Did you add the jar files to pfserv config file, stop/start PF server?

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

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

When you say config location, do you mean the pfserv config or do you mean that it needs to be in the path?

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

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.

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.

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.

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.

Brian,

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

https://www.lawsonguru.co...v/topic/Default.aspx

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

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

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

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

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) ...

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

I better discuss mine in https://www.lawsonguru.co...v/topic/Default.aspx

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

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

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.

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.