Difficulty connecting to MS SQL
Submitted by Anonymous on Mon, 2009-06-22 11:12
Hi There,
I have some difficulty setting up my server to connect to a MS SQL 2005 server.
I get the following error: " Can't initialize VHost repositoryjava.lang.ClassNotFoundException: jtds:sqlserver"
can someone please help me setting up the server to connect to MS SQL.
Regards
jb
- 743 reads
Printer-friendly version- Send to friend
Actually it will soon be
Actually it will soon be supported again. I have received patches from one of users which ported tigase schema to SQL Server for the Tigase version 5.x.
arrrrrrg! I have just spent
arrrrrrg!
I have just spent the best part of 4 hours trying to set up Tigase with SQL Server just to discover that it doesn't work with anything after v4 by chance from this post.
You really need to make it clear that SQL Server is not supported anymore.
Unfortunately it is not
Unfortunately it is not ready yet. The problem is that the Tigase extensively uses stored procedures in the database to perform most of the data access actions. So creation of the new schema for a database is more than just table structure design.
Has anyone updated the mssql
Has anyone updated the mssql schema yet? or is anyone currently working on it as i really need to get tigase working with mssql
thnx
The error message you have
The error message you have got has nothing to do with what I am going to say here. However it might be not worth the effort to fix the problem as the current Tigase version does not work with MS SQL Server.
We have changed DB schema for Tigase 4.x and the schema for MS SQLServer has not yet been updated.
So what you can do right now is to use any of supported databases or update the schema for MS SQLServer on your own. I can assist you with this if you like.
Post new comment