LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Connecting to MySQL

    Employee
    Posted 07-01-2010 08:11

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: j thomas

    Hi, I'm a LavaStorm newbie and I'm trying to connect to a MySQL database using a JDBC Query node. I get the error "unable to load db driver: com.mysql.jdbc.Driver".

    I know where the jar for this driver is but how do I tell BRAIN? Based on something I read in another post I've tried adding the path (to the jar file itself and to the directory containing it) to the Windows CLASSPATH and path variables (restarting the console each time) but nothing worked. What am I doing wrong? Is there an in-built driver I should be using instead?

    Thanks,
    Jenny


  • 2.  RE: Connecting to MySQL

    Employee
    Posted 07-01-2010 10:18

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    The jar files need to be in
    C:\Program Files\Lavastorm\BRAIN 4.1\Java\lib\ext


  • 3.  RE: Connecting to MySQL

    Employee
    Posted 10-08-2010 07:47

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: j thomas

    Thanks stonysmith. Sorry for the slow acknowledgement!

    For info in case anyone else is wondering I've since found that you could also update the classpath in setBrainEnv.bat to include the location of jars you want to use.


  • 4.  RE: Connecting to MySQL

    Employee
    Posted 08-31-2011 06:46

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: yossi

    Where is that on Windows 7? Aka, what is the path to where the Jar file should be? Something like:

    C:\Program Files (x86)\Lavastorm\LAE 4.5?

    looks like if I drop in

    mysql-connector-java-5.1.17-bin
    (available in the zip at http://dev.mysql.com/downloads/connector/j/5.0.html)

    to

    C:\Program Files (x86)\Lavastorm\LAE 4.5\platform\windows-x86-32\java\jre\lib\ext

    and enter :
    DbDriver com.mysql.jdbc.Driver
    jdbc:mysql://DBHost:DBPort/DBName

    I am happy connecting to MySQL


  • 5.  RE: Connecting to MySQL

    Employee
    Posted 08-31-2011 07:11

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    It's very similar:

    C:\Program Files\Lavastorm\LAE 4.5\lib\java\ext

    we changed the path slightly from LAE 4.1.x to 4.5.x, so this is not a Windows 7 artifact, but from that.

    Cheers
    Rich