aspose file tools*
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
Author

Connect to SQL 2005 with JBOSS 4.0.3

anji anji
Greenhorn

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.
<connection-url>
jdbc:sqlserver://3.109.105.219:1433;DatabaseName=MMOffshore;
</connection-url>
<driver-class>
com.microsoft.sqlserver.jdbc.SQLServerDriver
</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.



Thanks,
Anji
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17260
    
    6

Don't you also need a username and password?

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
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