Welcome, Guest
Guest Settings
Help

DCM4CHE Support Forums » dcm4che development » dcm4chee

Thread: Failed to register driver for: com.microsoft.jdbc.sqlserver.SQLServerDriver


This question is not answered. Helpful answers available: 4. Correct answers available: 1.

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List

Permlink Replies: 1 - Pages: 1 - Last Post: Dec 13, 2012 2:54 PM Last Post By: admin
yutian

Posts: 1
Registered: 12/8/12
Failed to register driver for: com.microsoft.jdbc.sqlserver.SQLServerDriver
Posted: Dec 8, 2012 9:07 AM
 
  Click to reply to this thread Reply
Attachment server.log (689.4 KB)
Attachment server.log (689.4 KB)
Hello,everyone! I download the dcm4chee-2.17.2-mssql.zip file and setup the Database Microsoft SQL Server 2008 R2, follow the DCM4CHEE 2.17.1 Installation Instructions step by step ,well ,at last when I start the Jboss server,However,it couldn't connection to the Database .At firt it shows infomation like this:
Caused by: org.jboss.resource.JBossResourceException: Could not create connectio
n; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to reg
ister driver for: net.sourceforge.jtds.jdbc.Driver; - nested throwable: (java.la
ng.ClassNotFoundException: Unexpected error during load of: net.sourceforge.jtds
.jdbc.Driver, msg=net/sourceforge/jtds/jdbc/Driver : Unsupported major.minor ver
sion 51.0))
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
reateManagedConnection(LocalManagedConnectionFactory.java:190)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
eateConnectionEventListener(InternalManagedConnectionPool.java:619)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
tConnection(InternalManagedConnectionPool.java:264)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BaseP
ool.getConnection(JBossManagedConnectionPool.java:575)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage
dConnection(BaseConnectionManager2.java:347)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCo
nnection(TxConnectionManager.java:330)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
onnection(BaseConnectionManager2.java:402)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
nManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
erDataSource.java:89)
... 170 more

after I found some similar questions ,I download the latest jdbc jar file from http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 ,and put the two jar file "
sqljdbc.jar" and "sqljdbc4.jar " into the fold ~/server\default\deploy ;However it still don't work .
Here is my pacs-mssql -ds.xml :

<datasources>
<local-tx-datasource>
<jndi-name>pacsDS</jndi-name>

<!--
<connection-url>jdbc:jtds:sqlserver://localhost:1433;DatabaseName=pacsdb</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
-->
<connection-url>jdbc:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=pacsdb</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>

<user-name>pacs</user-name>
<password>pacs</password>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->

<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>MS SQLSERVER2000</type-mapping>
</metadata>
</local-tx-datasource>

</datasources>

when it is instead use the Microsoft JDBC driver , at the time jboss run ,it give me the error infomation :

2012-12-08 16:05:07,894 INFO -> (main) http://org.jboss.resource.connectionmanager.ConnectionFactoryBindingService Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
2012-12-08 16:05:07,942 INFO -> (main) http://org.jboss.resource.connectionmanager.ConnectionFactoryBindingService Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=pacsDS' to JNDI name 'java:pacsDS'
2012-12-08 16:05:07,971 WARN -> (main) http://org.jboss.resource.connectionmanager.JBossManagedConnectionPool Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.jdbc.sqlserver.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: com.microsoft.jdbc.sqlserver.SQLServerDriver))
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)


What shoud I do now?Thank you !

admin

Posts: 20
Registered: 11/15/07
Re: Failed to register driver for: com.microsoft.jdbc.sqlserver.SQLServerDriver
Posted: Dec 13, 2012 2:54 PM   in response to: yutian in response to: yutian
 
  Click to reply to this thread Reply
Please stop posting here. Migrate to Google Groups dcm4che forum
Legend
Expert: 501 - 999999 pts
Contributor: 151 - 500 pts
Member: 1 - 150 pts
dcm4che team
community contributor
Helpful Answer
Correct Answer

Point your RSS reader here for a feed of the latest messages in all forums