• Post Reply Bookmark Topic Watch Topic
  • New Topic

No such column in SQL server

 
Shaun Appleton
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 throw a JDBC 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
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!