Problem with tOleDbInput, foxpro driver - database connection failed
I have configured a simple job using tOleDbInput to connect to a local dbf data file using the MS Visual Foxpro OLE DB provider. The job itself runs and data is returned, so my configuration and dependencies seem to be correct. However, at design time in the Component pane I cannot access the metadata about the data file. For example, when I click on Table Name button this exception is thrown:
Database connection is failed.
java.lang.RuntimeException: java.lang.NullPointerException at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195) at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1044) at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315) at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:301) at org.talend.designer.core.ui.editor.properties.controllers.DbTableController.checkConnection(DbTableController.java:769) at org.talend.designer.core.ui.editor.properties.controllers.DbTableController$6.run(DbTableController.java:558) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: java.lang.NullPointerException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:121) at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:146) ... 6 more
So I can only configure this job by manually creating the input schema and SQL query.
The connection URL I have specified for the component is "Provider=VFPOLEDB.1;Data Source=C:\\Users\\xyz\\Documents\\abc.dbf;Collating Sequence=MACHINE;"
The dependent janet-java-1.1.jar for tOleDbInput is installed in TOS, and janet-win32.dll is located in my JRE bin folder.
