0 Replies Latest reply on Nov 19, 2002 1:51 PM by Shaun Appleton

    No Such Column when using MS SQL Server

    Shaun Appleton Newbie

      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