#707 MS SQL Sever => Invalid object name '<Table Name>' even though table exists under dbo schema and works with MS SQL JDBC DRIVER

[Soma G]

Even though table exists on database exception is being thrown as
Invalid object name "<Table Name>"

and with MS SQL JDBC driver it works fine

tables are under default schema <dbo>

Thanks
Soma G

[momo]

You didn't even mention what exactly you where trying to do and went wrong, nor did you provide any further details about your environment or any sample code. So how could anyone help you with that?

Btw. you specified jTDS 2.x as the affected version. Please note that jTDS 2.x is an unsupported experimental version that is not being maintained nor developed any further.

Cheers,
momo

[Soma G]

Momo,

I am sorry about not providing too many details and thanks for your quick response,
ENV : SQL Server 2008

the problem turned out to be wrongly formatted : URL

Database is specified using database instead of databaseName
'my_test_server:<1433>;database=FRAMSAPP71_Perf;instanceName=I01'

We never had problem with this previously because the default database being set on the user name we are using to be the right database and when we migrated to our new environment default database was set to master instead of the application related database

'my_test_server:<1433>;databaseName=FRAMSAPP71_Perf;instanceName=I01'
replacing database with databaseName resolved the issue

Thanks
Soma G

[momo]

Great to hear that you were able to solve the issue!

Cheers,
momo