Issue with JDBC Connection to SQL Server 2005 database when default schema is changed
I am new to Java. I have a custom built Java application. I am using a MS SQL Server 2005 database as a datasource. I am using 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]