On startup: ClassNotFoundException: jtds:sqlserver

6 replies [Last post]
Thu, 2010-04-22 22:32
Anonymous

hi,

I was unable to do the proper install because unfortunately the GUI installer is a little out of date and mangles the JDBC string for MS SQL Server. I installed the db myself and then tried to start up Tigase by using the tigase.bat script. The log file shows some missing scripts (including scripts\admin\ConfigList.groovy) and then it gets a bunch of errors that are ClassNotFoundException: jtds:sqlserver. Do I have to download the jtds jar separately and install it myself? Or is something else going on? In my init.properties file I have this for the db:

--user-db-uri = jdbc:jtds:sqlserver://mydb/tigase;user=tigaseUser;password=tigase123

Top
Thu, 2010-04-22 23:40
#1
Anonymous (not verified)

never mind about the classnotfoundexception, my --user-db was set wrong. now working on "no suitable driver found for " error.

Top
Thu, 2010-04-22 23:45
#2
Anonymous (not verified)

fixed that i had --user-db set wrong. now i'm still getting "no suitable driver found for " errors though.

Top
Fri, 2010-04-23 01:11
#3
Anonymous (not verified)

Found out how to get JDBC working:

1) Download the latest jtds jar
2) Put it in the \libs directory
3) Add that jar to the list of jars in wrapper.conf (and remove the deadwood jars that don't actually exist)
4) In tigase.conf make sure that net.sourceforge.jtds.jdbc.Driver is included in the -Djdbc.drivers entry

Top
Fri, 2010-04-23 01:30
#4
Anonymous (not verified)

...and also set --user.db=tigase.db.jdbc.JDBCRepository in etc\init.properties

Top
Sat, 2010-04-24 21:37
#5
kobit's picture
Artur Hefczyc
Offline
Joined: 2006-09-03
Points: 267814

I guess you handled this already on your own. If not please let me know. If you have any more questions or issues please, do not hesitate to ask.

Top
Tue, 2010-06-01 23:52
#6
Malvolio (not verified)

I downloaded the Derby jar and put it in the libs directory; the problem went away.

Top

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly.