Problem with tOleDbInput, foxpro driver - database connection failed

_AnonymousUser — Thu, 22 Dec 2016 12:59:03 GMT

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.

I am running a 32 bit TOS/JDK stack on Windows 7.

Re: Problem with tOleDbInput, foxpro driver - database connection failed

_AnonymousUser — Thu, 22 Dec 2016 13:28:57 GMT

I am running Talend Open Studio for Data Integration Version: 6.3.0

topic Problem with tOleDbInput, foxpro driver - database connection failed in Talend Studio

Problem with tOleDbInput, foxpro driver - database connection failed

Re: Problem with tOleDbInput, foxpro driver - database connection failed