Hi all,
I think this is a bug, but wondering if there is a quick work-around.
I am migrating from SQL Server 2000 database with Latin1_General_BIN collation to SQL Server 2008 with Latin1_General_BIN collation.
In MSSQL Server 2008, tMSSQLTableList comes back with:
Exception in component tMSSqlTableList_1
java.sql.SQLException: Invalid object name 'information_schema.tables'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304)
at testing.test1_0_1.TEST1.tMSSqlTableList_1Process(TEST1.java:411)
at testing.test1_0_1.TEST1.tMSSqlConnection_1Process(TEST1.java:320)
at testing.test1_0_1.TEST1.runJobInTOS(TEST1.java:638)
at testing.test1_0_1.TEST1.main(TEST1.java:509)
The reason is that in MSSQL 2008 the Views for information_schema.tables are infact "INFORMATION_SCHEMA.TABLES".
If I change the Database to non-binary, it works, but I can't.
Any help?
TOS 4.1.0M3 and 4.1.0RC2 java
