Results 1 to 8 of 8

Thread: JDBC Node Error "Unable To Load DB Driver"

  1. #1

    Default JDBC Node Error "Unable To Load DB Driver"

    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. #2
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    782

    Default

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

  3. #3

    Default

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

  4. #4

    Default

    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. #5

    Default

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

    Anoop

  6. #6
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    782

    Default

    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. #7
    Lavastorm Employee gmullin's Avatar
    Join Date
    May 2014
    Location
    Chicago
    Posts
    164

    Default

    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. #8
    Lavastorm Employee gmullin's Avatar
    Join Date
    May 2014
    Location
    Chicago
    Posts
    164

    Default

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •