Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Pervasive JDBC

  1. #1
    Join Date
    Nov 2008
    Posts
    2

    Default Pervasive JDBC

    Hi

    I'm desperately trying to setup a JDBC connection with Pervasive PSQL9 Database

    I've read a post in the forum (http://forums.pentaho.org/showthread.php?t=62678&highlight=pervasive) but I'm not ...a so advanced user
    I've tryed but I get a classnotfound exception

    Can you send me detailed steps to corretcly configure kettle ?

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Below are the files found in your Pervasive client, copy them as specified:
    • pvjdbc2.dll : copy to libswt\win32 folder
    • pvjdbc2.jar : copy to libext\JDBC
    • pvjdbc2x.jar : copy to libext\JDBC
    • jpscs.jar : copy to libext\JDBC
    Restart Spoon, create a generic database connection:

    URL : jdbc:pervasive://<your-host>:1583/<your-database>
    Driver class : com.pervasive.jdbc.v2.Driver

    You need to replace <your-host> and <your-database>.

    Good luck,
    Matt

  3. #3

    Default

    FYI: for the my progress dll's which I know is unrelated but all the same, I also had to put them in c:\windows\system32. Probably not required for you guys but handy if things don't work
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  4. #4
    Join Date
    Nov 2008
    Posts
    2

    Default

    again the error
    please read below

    java.lang.reflect.InvocationTargetException: Rilevato un problema nel prelevare le informazioni dal database: org.pentaho.di.core.exception.KettleDatabaseException:
    Impossibile prelevare le informazioni sul database a causa di un errore
    Error occured while trying to connect to the database
    Exception while loading class
    com.pervasive.jdbc.v2.Driver

    at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:68)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Impossibile prelevare le informazioni sul database a causa di un errore
    Error occured while trying to connect to the database
    Exception while loading class
    com.pervasive.jdbc.v2.Driver

    at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:320)
    at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:64)
    ... 1 more
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Exception while loading class
    com.pervasive.jdbc.v2.Driver

    at org.pentaho.di.core.database.Database.normalConnect(Database.java:318)
    at org.pentaho.di.core.database.Database.connect(Database.java:267)
    at org.pentaho.di.core.database.Database.connect(Database.java:229)
    at org.pentaho.di.core.database.Database.connect(Database.java:219)
    at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:168)
    ... 2 more
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Exception while loading class
    com.pervasive.jdbc.v2.Driver
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:365)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:302)
    ... 6 more
    Caused by: java.lang.ClassNotFoundException: com.pervasive.jdbc.v2.Driver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:357)
    ... 7 more

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    In that case I have no idea.

  6. #6

    Default

    Hi piccirm,
    Quote Originally Posted by piccirm View Post
    ...Caused by: java.lang.ClassNotFoundException: com.pervasive.jdbc.v2.Driver...
    What does that (the root reason/exception) tell us? The JDBC driver class can not be found.
    Maybe you put the jar in wrong directory?
    EDIT: If you are sure to put it in right location, modify the .bat/.sh file to output the classpath before starting pan/kitchen/spoon in last line. (e.g. echo %CLASSPATH% or echo $CLASSPATH) Post the line here.

    Regards,
    Christoph
    Last edited by christophWeißenborn; 11-07-2008 at 08:33 AM.
    21 is only half the truth

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.