topic Re: Database Connection - schema retreival issue in Talend Studio

Database Connection - schema retreival issue

Anonymous — Fri, 25 Mar 2016 20:06:03 GMT

I have a custom JDBC to a datasource. This has worked in Talend data integration studio 5.1, but now trying with latest 6.
You can see in the images below, Talend is able to pull up the tables in database, but has an error when trying to retreive the schema for a table.
Strangely, when i use "Read Queries" on the connection, the columns and data preview work fine.
Same table, same JDBC, same connection. I am not sure where to start looking, but any help is appreciated

Re: Database Connection - schema retreival issue

Anonymous — Sat, 26 Mar 2016 20:24:04 GMT

This function strongly depends on the driver and the way the driver implements the Metadata API.
What database and release do you use?
Fetching data records is much easier than fetching the table meta data.

Re: Database Connection - schema retreival issue

Anonymous — Mon, 28 Mar 2016 19:49:07 GMT

Thanks for your response. I dont think version will help as its a custom JDBC we created to a NoSQL database. To use with data tools like talend and BI tools.
I do see the exception, and am trying to put debug statements into our JDBC connector code to see what the Metadata requests are sending us. below is from <talenddir>\workspace\.metadata\.log.
If i put custom debug statements into our JDBC connector, do you know where that would print out?

java.lang.NullPointerException
at com.codemettle.sherpa.jdbc.SherpaResultSet.getInt(SherpaResultSet.java:508)
at com.codemettle.sherpa.jdbc.SherpaResultSet.getInt(SherpaResultSet.java:515)
at org.talend.metadata.managment.model.DBConnectionFillerImpl.getIntFromResultSet(DBConnectionFillerImpl.java:1333)
at org.talend.metadata.managment.model.DBConnectionFillerImpl.fillColumns(DBConnectionFillerImpl.java:1423)
at org.talend.metadata.managment.model.MetadataFillFactory.fillColumns(MetadataFillFactory.java:351)
at org.talend.core.model.metadata.builder.database.manager.ExtractManager.returnColumns(ExtractManager.java:395)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.returnColumns(ExtractMetaDataFromDataBase.java:206)
at org.talend.repository.ui.wizards.metadata.table.database.SelectorTableForm$RetrieveColumnRunnable.run(SelectorTableForm.java:1532)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Re: Database Connection - schema retreival issue

Anonymous — Mon, 04 Apr 2016 18:07:10 GMT

jlolling, Thanks for the explanation. We updated the JDBC to be compliant with Talend
i will try to close this topic as resolved