Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connect to SQL 2005 with JBOSS 4.0.3

 
anji anji
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Don't you also need a username and password?

Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic