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.  JDBC Node Error "Unable To Load DB Driver"

    Employee
    Posted 09-19-2014 08:42

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

    Originally posted by: rullmer

    Hello,

    I'm using Lavastorm client on a Windows 2012 AWS EC2 instance. Works fine.

    Version is BRE v 5.0.0.1 Build 527

    I am attempting to access an AWS Redshift DB via a JDBC Node.

    When I execute, I get an "unable to load db driver" error message. I am using the DB driver specified by AWS for redshift, "postgresql-8.4-703.jdbc4"

    Any idea what could be wrong?

    Thanks,
    Ray


  • 2.  RE: JDBC Node Error "Unable To Load DB Driver"

    Employee
    Posted 09-19-2014 09:30

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

    Originally posted by: stonysmith

    The JDBC driver (JAR file) needs to be in the folder {installation directory}/lib/java/ext


  • 3.  RE: JDBC Node Error "Unable To Load DB Driver"

    Employee
    Posted 09-19-2014 12:56

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

    Originally posted by: rullmer

    I moved the jdbc4 file to /lib/java/ext and i get the same error


  • 4.  RE: JDBC Node Error "Unable To Load DB Driver"

    Employee
    Posted 11-22-2017 18:36

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

    Originally posted by: Tris_717684

    Hello @stonysmith,

    I have the same problem of @rullmer... has this been resolved? can i please request guidance on the resolution so I can link LAE to Hadoop?

    Thanks in advance for the kind help!

    Regards,

    tris


  • 5.  RE: JDBC Node Error "Unable To Load DB Driver"

    Employee
    Posted 01-18-2018 12:50

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

    Originally posted by: anoop

    Hello
    Was this resolved , if so can someone please provide the resolution here.
    Thanks

    Anoop


  • 6.  RE: JDBC Node Error "Unable To Load DB Driver"

    Employee
    Posted 01-18-2018 13:07

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

    Originally posted by: stonysmith

    The field DbDriver has to match the internal name inside of that file.
    It's best to consult the documentation for postgresql-8.4-703.jdbc4.jar


  • 7.  RE: JDBC Node Error "Unable To Load DB Driver"

    Employee
    Posted 01-18-2018 13:13

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

    Originally posted by: gmullin

    According to this the driver is RedshiftJDBC42-1.2.10.1009.jar and class name is com.amazon.redshift.jdbc42.Driver. I don't have a working example right now, but I've connected to Redshift with LAE in the past.


  • 8.  RE: JDBC Node Error "Unable To Load DB Driver"

    Employee
    Posted 01-19-2018 07:30

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

    Originally posted by: gmullin

    Adrian also pointed out that on our new product - Dataverse - we explicitly point out that the Redshift driver can clash with the Postgres driver. If you have both drivers in your lib/java/ext directory try putting the Redshift one in some other directory and creating a parameter in the node called Classpaths, enter the full path with the jar file in it and try to run the node.