JDBC invalid object name, but the object exists

• webrunner

  SSC-Dedicated

  Points: 31711

  More actions

  April 12, 2021 at 11:37 pm

  #3870303

  Hello experts,

  A developer reported this error when trying to query a DB:

  invalid object ERROR o.h.util.JDBCExceptionReporter - Invalid object name ...

  However, I checked the DB and the table exists, and I logged in as the app login and can see and select from the table.

  Can anyone recommend a general approach to troubleshooting this kind of behavior? Should I check the SQL drivers on the client, ask the developer or systems people what they see in the logs? It seems so odd an error to report if the object in fact exists and the permissions are there.

  Thanks for any help.

  -- webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  April 14, 2021 at 12:10 am

  #3870755

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.