Hi All,
I'm on WL 12.1 and am getting some JDBC connection test failures. If I'm reading what Wily is telling me correctly, I think the test SQL is "test server connectivity" and need to know how to fix that. This is as much info I have in Wily on the actual error:
- Exception: Backends|entitlements on myserver.mycompany.com-49103 (MS SQL Server DB)|SQL|Dynamic|Query|TEST SERVER CONNECTIVITY: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'Connectivity'.
Unfortunately I have no stack traces and WL seems to be reconnecting gracefully. I want to get rid of these because Wily counts them as errors.
I have a server with data sources connecting to Oracle 11g, SQLServer 2008, Teradata 14, and DB2 (not sure which version.) I'm using the built-in drivers for all but Teradata (because there aren't built-in TD drivers.) I get the failures for SQLServer and DB2, but not Oracle and Teradata.
SQLServer and DB2 use the "jdbc:weblogic" style URLs. I get occasional failures on all such datasources. The others use jdbc:oracle and jdbc:teradata. I get no failures on those.
All datasources have "test connection on create" and "test connection on reserve" set to true. For SQLServer, the test SQL is "sql select 1." For DB2 it's "SYSIBM.SYSDATATYPES."
Are these settings being ignored? How do I get rid of the failures?
Thanks
John