Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Mysql JDBC Driver

 2 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Robert
Veteran Member
Posts: 82
Veteran Member
12/8/2009 6:41 PM

    I have installed the driver to the  mysql connector driver to:

    C:\Program Files\Lawson Software\ProcessFlow901\lib

    desinger.bat:  I have appended the CLASSPATH with:
    .\lib\mysql-connector-java-5.1.10-bin.jar

    I have used the following connect parameters.

    Driver:  com.mysql.jdbc.Driver
    URL:  dbc:mysql//localhost:3306/grades

    Error:  JDBC Driver not found: com.mysql.jdbc.Driver

    I know this configuration works, as I have done J2EE development on my laptop via NetBeans, and the jdbc connection is granted.

    Theory is that jdbc should be agnostic, so PF should accept any driver.
    I have a feeling that is not the case, and only certain drivers work.

    JVM = JRE6.  I will give 5.0.06 a shot.

    Shane Jones
    Veteran Member
    Posts: 460
    Veteran Member
    1/24/2010 7:40 PM

      Did anyone help you with this? We didn't find the connection using JDBC to be as intuitive as expected. However, we do have it working currently to integrate with an SQL server.

      Maybe this will help you or someone else:
      http://www.herongyang.com...-Connection-URL.html

      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...
      Robert
      Veteran Member
      Posts: 82
      Veteran Member
      2/1/2010 4:52 PM

        Shane:

        I appreciate the reply, but I don't believe PFlow is going to recognize the mysql JDBC driver.  I have dropped into ProcessFlow's subordinate "lib" folder, and added the jar file to the designer.bat, but ProcessFlow will not use the driver.