Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007
    Posts
    64

    Thumbs down Unanswered: InValid object name 'tableA'

    Hi ,

    I am using jtds-1.2.jar to connect to SQL Server using driver net.sourceforge.jtds.jdbc.Driver .

    When i try to access the table 'tableA' below error is being thrown . The Table 'tableA' is present in the database . Please suggest me how to handle this .

    error message received :
    java.sql.SQLException: Invalid object name 'tableA'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnos tic(SQLDiagnostic.java:365)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(Td sCore.java:2781)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2224)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(T dsCore.java:628)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL Query(JtdsStatement.java:418)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeQue ry(JtdsStatement.java:1258)
    Thanks ,
    Sush

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Are you specifying the schema?

    e.g.
    Code:
    SELECT *
    FROM   something.tablea
    George
    Home | Blog

  3. #3
    Join Date
    Aug 2007
    Posts
    64
    no i am not specifying schema

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    ...so can you try specifying the schema and see if you get the same problem?
    Can you run the offending query directly in Enterprise Manager / Query Analyzer / Management studio ok?
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •