jQuery in Action, 3rd edition
The moose likes JBoss/WildFly and the fly likes Connect to SQL 2005 with JBOSS 4.0.3 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Connect to SQL 2005 with JBOSS 4.0.3" Watch "Connect to SQL 2005 with JBOSS 4.0.3" New topic

Connect to SQL 2005 with JBOSS 4.0.3

anji anji

Joined: Nov 12, 2006
Posts: 2
I tried to connect sql 2005 database with JBOSS 4.0.3sp1 server,in ds.xml file i mentioned connection url,driver class.

i kept sqljdbc.jar in class path and enabled TCP\IP port number 1433 also in sql server.

after setting all these i tried to start my JBOSS server.
it is giving error..not able to connect db..

org.jboss.resource.connectionmanager.InternalManagedConnectionPool:getConnection:232 Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out: connect)

can any one help..where is problem..where to change.

Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

Don't you also need a username and password?


Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
I agree. Here's the link: http://aspose.com/file-tools
subject: Connect to SQL 2005 with JBOSS 4.0.3
It's not a secret anymore!