Hi,
I'm using Pentaho Kettle in order to connect to a Paradox database, but i receive the following message after installing and configuring your JDBC driver:
Connection URL: jdbc:paradox:///c:/
Custom Driver Class Name: com.hxtt.sql.paradox.ParadoxDriver
Unable to retrieve database information because of an error
Error occurred while trying to connect to the database
Error connecting to database: (using class com.hxtt.sql.paradox.ParadoxDriver)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113)
at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run (GetDatabaseInfoProgressDialog.java:65)
at org.pentaho.di.core.database.DatabaseMetaInformation.getData (DatabaseMetaInformation.java:193)
at org.pentaho.di.core.database.Database.connect (Database.java:300)
at org.pentaho.di.core.database.Database.connect (Database.java:310)
at org.pentaho.di.core.database.Database.connect (Database.java:357)
at org.pentaho.di.core.database.Database.normalConnect (Database.java:400)
at org.pentaho.di.core.database.Database.connectUsingClass (Database.java:547)
at java.sql.DriverManager.getConnection (null:-1)
at java.sql.DriverManager.getConnection (null:-1)
at com.googlecode.paradox.Driver.connect (Driver.java:42)
at com.googlecode.paradox.ParadoxConnection. (ParadoxConnection.java:107)
at java.nio.channels.FileChannel.tryLock (null:-1)
at sun.nio.ch.FileChannelImpl.tryLock (null:-1)
at sun.nio.ch.SharedFileLockTable.add (null:-1)
at sun.nio.ch.SharedFileLockTable.checkList (null:-1)
Can you help me, please?
Regards.
|
> at com.googlecode.paradox.Driver.connect (Driver.java:42)
It's not an error of com.hxtt.sql.paradox.ParadoxDriver . You should check your setting.
|
Adding parameter missingMemoFile with repair value to connection URL solved my problem.
Thanks.
|