When using my code(BMP), JBoss + MySQL on my development machine it all works well. Transferring the same code to another machine JBoss + MS SQL Server 2000 throws an exception.
my BMP code uses the following SQL statement
select Tblcriteria.DOCcriteria, TblCapability.CoreCapability,
TblClass.Classification, TblEntry.* from Tblcriteria, TblCapability,
TblEntry, TblClass WHERE TblEntry.Classification = TblClass.ID AND
TblEntry.DOCCriteria = Tblcriteria.DOCcriteriaID AND
TblEntry.Capability = TblCapability.CoreCapabilityID
ORDER BY TblEntry.LISerial ASC
With both the Microsoft JDBC driver and the free jTDS drivers the exceptions I get are
java.sql.Exception No such column TblClass.Classification
net.sourceforge.jtds.jdbc.AbstractResultSet.findColumn
net.sourceforge.jtds.jdbc.AbstractResultSet.getString
...
(for the jtds driver)
and
java.sql.Exception No such column TblClass.Classification
com.microsoft.jdbc.base.BaseException.createException
com.microsoft.jdbc.base.BaseException.getException
...
(for the microsoft driver)
The Table and column do exist and when I test the same SQL statement in
MS Access (using an ODBC connection) it returns the desired results.
Any pointers would be gratefully received.
Thanks,
Shaun