SQL server connection with spring

Question

I created a spring mvc application to connect with sqlserver database. I used jtds driver for connection.

<beans:bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
    destroy-method="close">
    <beans:property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" />
    <beans:property name="url"
        value="jdbc:jtds:sqlserver://localhost:1433;databaseName=3PLTest;" />
    <beans:property name="username" value="sa" />
    <beans:property name="password" value="sa" />
</beans:bean>

When i am trying to run the server it gives the error.

ERROR: org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect)
Nov 03, 2014 10:33:46 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [appServlet] in context with path [/warehouse] threw exception [Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection] with root cause
java.net.ConnectException: Connection refused: connect

I am using SQLEXPRESS. How does this happen?

is your username and password correct? Are you able to directly connect to the database from an sql client? — basiljames, Nov 03 '14 at 05:31
Can you connect using a SQL Client? Have you added the jtds jar, what version of jtds, Java are you using? — Piyush Mattoo, Nov 03 '14 at 05:57

score 0 · Accepted Answer · edited May 23 '17 at 10:33

0

Have you enabled the TCP/IP protocol to your localhost SQL Server installation?

SQL Server connection refused

edited May 23 '17 at 10:33

Community

1
1

answered Nov 03 '14 at 10:45

alfcope

2,327
2
13
21

SQL server connection with spring

1 Answers1