Problem with database reader on sql server 2005

[merics]

Hallo, i update my mirth to the new version 2.2.1.5861 (old 1.8.2.4472) and i have setted mirth with sql driver jdbc (sqljdbc4.jar) and i have added the new line on dbdrivers.xml file for SQL Server 2005.
But it doesn't work, i have a problem with all the channel that connecting on database reader with ms sql server 2005 connection.
The channel open a connection with this string "jdbc:sqlserver://xxxxx:1433;databaseName=yyy;" and sql specific account but don't retrieve the tables from the db. With the older version i didn't have any problem, the sql account is the same and the connection string also.
Any help is appreciated!

[upstart33]

Try this instead:

jdbc:jtds:sqlserver://server:port/database

[cory_cole]

Are you getting any errors?

[merics]

Yes i receive this error:
Thanks

[2012-07-11 12:05:15,343] ERROR (org.mule.impl.model.seda.SedaModel:194): Error encountered starting channel: 8084dcd5-d0c0-4d38-895b-cea02dd84ba2
org.mule.providers.FatalConnectException: ReconnectStrategy "org.mule.providers.SingleAttemptConnectionStrateg y" failed to reconnect receiver on endpoint "jdbc://query"
at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:34 )
at org.mule.providers.AbstractConnectionStrategy.conn ect(AbstractConnectionStrategy.java:67)
at org.mule.providers.AbstractMessageReceiver.start(A bstractMessageReceiver.java:391)
at org.mule.providers.AbstractConnector.registerListe ner(AbstractConnector.java:508)
at org.mule.impl.model.AbstractModel.registerListener s(AbstractModel.java:240)
at org.mule.impl.model.AbstractModel.registerComponen t(AbstractModel.java:190)
at com.mirth.connect.server.controllers.MuleEngineCon troller.registerChannel(MuleEngineController.java: 380)
at com.mirth.connect.server.controllers.MuleEngineCon troller.deployChannels(MuleEngineController.java:2 22)
at com.mirth.connect.server.controllers.MuleEngineCon troller.redeployAllChannels(MuleEngineController.j ava:334)
at com.mirth.connect.server.servlets.EngineServlet.do Post(EngineServlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:547)
at org.eclipse.jetty.servlet.ServletHandler.doHandle( ServletHandler.java:480)
at org.eclipse.jetty.server.session.SessionHandler.do Handle(SessionHandler.java:225)
at org.eclipse.jetty.server.handler.ContextHandler.do Handle(ContextHandler.java:941)
at org.eclipse.jetty.servlet.ServletHandler.doScope(S ervletHandler.java:409)
at org.eclipse.jetty.server.session.SessionHandler.do Scope(SessionHandler.java:186)
at org.eclipse.jetty.server.handler.ContextHandler.do Scope(ContextHandler.java:875)
at org.eclipse.jetty.server.handler.ScopedHandler.han dle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.HandlerList.handl e(HandlerList.java:47)
at org.eclipse.jetty.server.handler.HandlerWrapper.ha ndle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java :349)
at org.eclipse.jetty.server.HttpConnection.handleRequ est(HttpConnection.java:441)
at org.eclipse.jetty.server.HttpConnection$RequestHan dler.content(HttpConnection.java:936)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpPa rser.java:801)
at org.eclipse.jetty.http.HttpParser.parseAvailable(H ttpParser.java:224)
at org.eclipse.jetty.server.AsyncHttpConnection.handl e(AsyncHttpConnection.java:51)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.han dle(SelectChannelEndPoint.java:586)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.r un(SelectChannelEndPoint.java:44)
at org.eclipse.jetty.util.thread.QueuedThreadPool.run Job(QueuedThreadPool.java:598)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.r un(QueuedThreadPool.java:533)
at java.lang.Thread.run(Unknown Source)Caused by: org.mule.providers.FatalConnectException: ReconnectStrategy "org.mule.providers.SingleAttemptConnectionStrateg y" failed to reconnect receiver on endpoint "jdbc://query"
at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:34 )
at org.mule.providers.AbstractConnectionStrategy.conn ect(AbstractConnectionStrategy.java:67)
at org.mule.providers.AbstractMessageReceiver.connect (AbstractMessageReceiver.java:348)
at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:32 )
... 32 moreCaused by: org.mule.providers.ConnectException: Initialisation Failure: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:jtds:sqlserver://GVMSMACKSQL:1433/SLW'
at com.mirth.connect.connectors.jdbc.JdbcMessageRecei ver.doConnect(JdbcMessageReceiver.java:112)
at org.mule.providers.AbstractMessageReceiver.connect (AbstractMessageReceiver.java:355)
at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:32 )
... 35 moreCaused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:jtds:sqlserver://GVMSMACKSQL:1433/SLW'
at org.apache.commons.dbcp.BasicDataSource.createConn ectionFactory(BasicDataSource.java:1452)
at org.apache.commons.dbcp.BasicDataSource.createData Source(BasicDataSource.java:1371)
at org.apache.commons.dbcp.BasicDataSource.getConnect ion(BasicDataSource.java:1044)
at com.mirth.connect.connectors.jdbc.JdbcConnector.ge tConnection(JdbcConnector.java:425)
at com.mirth.connect.connectors.jdbc.JdbcMessageRecei ver.doConnect(JdbcMessageReceiver.java:109)
... 37 moreCaused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createConn ectionFactory(BasicDataSource.java:1437)
... 41 more

[merics]

Instead if i use this string: jdbc:sqlserver://xxx:1433;databaseName=yyy; the error that i receive is:

[2012-07-11 12:17:25,401] FATAL (org.mule.impl.DefaultComponentExceptionStrategy:8 4): The error is: com.microsoft.sqlserver.jdbc.SQLServerException: Could not retrieve database tables select .....

[cory_cole]

Try to run your query directly in SQL Server.

[merics]

The query succeded on SQL Server, it's a simple select * from table. The query is the same that was on the old version of Mirth. Nothing was changed, only the version of Mirth. The server is the same with same account...can be a problem with permission of the sql account? I don't have another solution. Thank you very much

[upstart33]

Maybe this thread will help?

http://www.mirthcorp.com/community/f...atabase+tables

[merics]

In this mode i have resolved:
Use Javascript = YES and
var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('com.microsoft.sqlserver.jdbc.SQLServerDriver','j dbc:sqlserver://XXX:1433;databaseName=YYY;','user','pwd');
var exp = "select * from xxx";
var result = dbConn.executeCachedQuery(exp);
dbConn.commit();
dbConn.close();
return result;

Thank you very much!