aspose file tools*
The moose likes JDBC and the fly likes Invalid Object exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Invalid Object exception" Watch "Invalid Object exception" New topic
Author

Invalid Object exception

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I am trying to use the jdbc-odbc bridge to access a SQL database. I have created several user tables with a dbo-level user. I am trying to connect to the database with another dbo-level user, but I keep getting an exception trying to access the user tables. It works fine when I retrieve system tables, so I know the connection is okay. I'm assuming this is a SQL server issue. Anyone have clues?
Thanks,
Chris
Carl Trusiak
Sheriff

Joined: Jun 13, 2000
Posts: 3340
Yes, this sounds like a database issue. If you create a table as one user, that user has to grant permissions for other users to use it. Additionally other users must use the full name for the table which is usually owner_name.table_name or an administrator has to create a synonm for the table so that everyone can access it with just table_name. Consult the documenttations for your database on grants and synonms.


I Hope This Helps
Carl Trusiak, SCJP2, SCWCD
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Invalid Object exception
 
Similar Threads
SQL Server 2005 Express error logs
jdbc-msAccess
Pl. Help Urgent
No access to SQL Express 2005/2008 database
Error : [SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'jdbc'