Page 1 of 1

jTDS SQL Server

PostPosted: Fri Sep 09, 2011 2:45 pm
by Garantisoft
...
Class.forName("net.sourceforge.jtds.jdbc.Driver");

Connection connection = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/testdb","sa", "");

dba = DBAccess.getDBAccess(connection);
dba.open();
put("dBAccess", dba);
...

Using jTDS 1.2.5 to the SQL Server connection,
"Invalid object name 'sys.database_principals'." I get the error.
What can I be missing.

Re: jTDS SQL Server

PostPosted: Fri Sep 09, 2011 5:18 pm
by Support@SIB
We recommend the usage of DBCredentials and/or DataSourceHandler, because JVx uses jtds for MSSql.

It is also possible to use the MSSQLDBAccess direct:

Code: Select all
MSSQLDBAccess dba = new MSSQLDBAccess();


Please post your StackTrace and SQLServer version.

Re: jTDS SQL Server

PostPosted: Tue Sep 13, 2011 3:34 pm
by Garantisoft
Sory, I can't post StackTrace. SQLServer version 2000.

Re: jTDS SQL Server

PostPosted: Tue Sep 13, 2011 4:00 pm
by Support@SIB
Without Stack Trace we have no chance to find the error cause/position. If you don't want to show your classes, remove your classes from the stack trace. We only need JVx information!

Do you get the error during open() or when accessing data or...?

Re: jTDS SQL Server

PostPosted: Wed Sep 14, 2011 11:28 am
by Development@SIB
This is a problem with metadata detection in MSSql 2000, because schema handling is different.

Details are available in the Support System.