skip to main content
Configuring Hybrid Data Pipeline for JDBC : Troubleshooting : SQL errors

Try Now

SQL errors

Hybrid Data Pipeline reports errors to the calling application by returning SQL exceptions. The message indicates which component generated the error.
The following components can report errors:
*Hybrid Data Pipeline Driver for JDBC - [DataDirect][JDBC Hybrid Driver]  Example: [DataDirect][JDBC Hybrid Driver][Service]Object has been closed 
*Hybrid Data Pipeline connectivity service - [DataDirect][JDBC Hybrid Driver][Service]  Example: [DataDirect][JDBC Hybrid Driver][Service]Invalid user ID or password. 
*Hybrid Data Pipeline data store - [DataDirect][JDBC Hybrid Driver][data_store]  Example: [DataDirect][JDBC Hybrid Driver][Salesforce]Column not found: FOO in statement [SELECT foo FROM Account]
You may need to check the last JDBC call your application made and refer to the JDBC specification for the recommended action.
When a JDBC call fails it throws a SQLException. Calling getMessage or toString on the SQLException will return these messages. For example:
try {
rs = stmt.executeQuery ("SELECT * FROM foobar");
catch (SQLException e) {
System.out.println (e.toString ());
System.out.println (e.getMessage ());
java.sql.SQLSyntaxErrorException: [DataDirect][JDBC Hybrid driver][Salesforce]Table not
found in statement [SELECT * FROM foobar]
[DataDirect][JDBC Hybrid driver][Salesforce]Table not found in statement [SELECT * FROM