Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue with JDBC Connection to SQL Server 2005 database when default schema

843859Dec 2 2009 — edited Dec 8 2009
I am new to Java. I have a custom built Java application that is using a MS SQL Server 2005 database as a datasource with a JDBC connection.

When the database was initially setup the default schema was kept at dbo. When using the dbo schema our connection works fine and the application runs as expected.

We now have a need to change the default schema to something other than dbo. When we made the change to the schema on the SQL Server 2005 database the connection no longer works from the Java application. If we set the schema back to dbo the connection works fine. Here is what we have done and the error we are receiving:


The tables had the schema named, there was a default schema set (for the user), the rights where read and write (through out the schema) . We tested specifying the schema and lettting it default, it errored both ways.
It worked fine in sql management studio (query). but not in JAVA....we tested with the same user signing on in both applications.

Error from Java Application:

Vehicles could not be created![FaultEvent fault=[RPC Fault faultString="There was an unhandled failure on the server. Unable to locate table meta data for 'inventoryVehicles' in the default schema" faultCode="Server.Processing" faultDetail="null"] messageId="6B2620B4-AD0B-88FF-5431-F02BCEBA21CD" type="fault" bubbles=false cancelable=true eventPhase=2]

Any help on this error would be great! Thank you!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2010
Added on Dec 2 2009
5 comments
321 views