jTDS SQL Server

General questions regarding the development with JVx.

jTDS SQL Server

Postby Garantisoft » Fri Sep 09, 2011 2:45 pm

...
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.
Garantisoft
 
Posts: 16
Joined: Wed Aug 17, 2011 3:26 pm

Re: jTDS SQL Server

Postby Support@SIB » Fri Sep 09, 2011 5:18 pm

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.
User avatar
Support@SIB
 
Posts: 198
Joined: Mon Sep 28, 2009 1:56 pm

Re: jTDS SQL Server

Postby Garantisoft » Tue Sep 13, 2011 3:34 pm

Sory, I can't post StackTrace. SQLServer version 2000.
Garantisoft
 
Posts: 16
Joined: Wed Aug 17, 2011 3:26 pm

Re: jTDS SQL Server

Postby Support@SIB » Tue Sep 13, 2011 4:00 pm

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...?
User avatar
Support@SIB
 
Posts: 198
Joined: Mon Sep 28, 2009 1:56 pm

Re: jTDS SQL Server

Postby Development@SIB » Wed Sep 14, 2011 11:28 am

This is a problem with metadata detection in MSSql 2000, because schema handling is different.

Details are available in the Support System.
User avatar
Development@SIB
 
Posts: 310
Joined: Mon Sep 28, 2009 1:54 pm


Return to Development