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

Try Now
SQL errors
Hybrid Data Pipeline reports errors to the calling application by returning SQL exceptions. The message indicates which Hybrid Data Pipeline 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
foobar]