Talend community forum / Can't retrieve schema through JDBC

mhedrich · 2011-01-05 19:50:53

We have set up a JDBC connection to a Progress/OpenEdge database, but when trying to retrieve schema objects nothing shows up. We can enter a value in the name filter, but when we hit Next no schemas appear in the 'list' of schemas (table structures) to retrieve. The tables can be queried through the SQL Builder window (Edit Queries) - we just can't retrieve their definitions.

We think this is because the userName we connect with is not the owner of the tables, but has privileges on them. Is there a way to connect as ‘userName’ and see the tables owned by ‘owner’? What options do we have?

TOS 4.1.1

Any ideas?

Last edited by mhedrich (2011-01-05 20:44:56)

cantoine · 2011-01-05 22:31:51

First of all, can you try to use the owner as a userName to retrieve the table definition and see if that works.
If that works, I advice to use this userName who is the owner for the step of Retrieve the table definition.
Then when the step of Retrieve schema is done, you can edit the connection and reuse again your favorite userName.

Second solution is to find in the JDBC documentation of Progress; what's the correct JDBC URL to connect and specify the Schema you want to use as the default schema. Adding this into the JDBC URL can help you to focus your retrieve action on the correct schema catalog.

Best regards.

mhedrich · 2011-01-06 21:55:46

Thanks for the quick response.

We tried adding schema to the URL, but that didn't help.
jdbc:datadirect:openedge://<IP>:<PORT>;databaseName=SUBS;schema=PUB

When creating the database connection there is a warning message at the top of the window that says "Schema must be specified". Can you tell me how to do that? Which field should it be in? What might the syntax be?

Thanks

rscott · 2011-04-09 12:06:07

Did you ever get this to work?

shong · 2011-04-11 04:01:22

Hi mhedrich

Have you tried cantoine's solution to retrieve schema use the owner as a userName to retrieve the table definition, you can't see the owner of table through Talend, you could find its information on database server.

Best regards
Shong

Roman_be · 2012-03-27 17:21:52

Did you get this to work? I have the same problem and would be happy about a solution.

Best regards

Roman

tale103108 · 2012-06-22 21:58:08

General JDBC

JDBC URL -> jdbc:datadirect:openedge://100.10.10.10:20000;databaseName=DATABASE;schema=PUB
Driver jar -> C:\skyward\dlc\java\openedge.jar
Class name -> com.ddtek.jdbc.openedge.OpenEdgeDriver
User name -> user
Password -> password
Mapping file -> mysql_id

The above worked for me in retrieving the table schemas and building (and running) any SQL.
However, when used within a job I get the following error:

Exception in thread "main" java.lang.Error: java.lang.NoClassDefFoundError: com/ddtek/jdbc/base/BaseDriver
at jdbc_connectivity_test.jdbc_connect_to_db_0_1.JDBC_Connect_to_db.tJDBCInput_2Process(JDBC_Connect_to_db.java:701)
at jdbc_connectivity_test.jdbc_connect_to_db_0_1.JDBC_Connect_to_db.runJobInTOS(JDBC_Connect_to_db.java:872)
at jdbc_connectivity_test.jdbc_connect_to_db_0_1.JDBC_Connect_to_db.main(JDBC_Connect_to_db.java:746)
Caused by: java.lang.NoClassDefFoundError: com/ddtek/jdbc/base/BaseDriver

Announcement

Unanswered posts

#1 2011-01-05 19:50:53

Can't retrieve schema through JDBC

#2 2011-01-05 22:31:51

Re: Can't retrieve schema through JDBC

#3 2011-01-06 21:55:46

Re: Can't retrieve schema through JDBC

#4 2011-04-09 12:06:07

Re: Can't retrieve schema through JDBC

#5 2011-04-11 04:01:22

Re: Can't retrieve schema through JDBC

#6 2012-03-27 17:21:52

Re: Can't retrieve schema through JDBC

#7 2012-06-22 21:58:08

Re: Can't retrieve schema through JDBC

Board footer