Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: How to access spt_monitor table using JDBC?

    Hello gurus-,
    I connected to the database using jdbc adn trid to execute "select * from spt_monitor" sql query and i get an exception saying that "com.sybase.jdbc2.jdbc.SybSQLException: spt_monitor not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output)."
    but when i connect thru isql with the same username/password asnd exceute the query it is working fine.
    Do you guys have any idea why this happening please let me know

    Thanks

    Kalatta

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    Maybe you need to put a DB qualifier on it? e.g. select * from database..foo ?
    Thanks,

    Matt

Posting Permissions

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