named connection

mikenereson · **Joined:** Wed Jan 17, 2007 10:32 am **Posts:** 6

Hi Hibernate Forum.

How do I connect to a database using named connections?

I am attempting to connect to an MSSQL database. I am using a connection string looking like:

Code:

jdbc:microsoft:sqlserver://ptlacpt01\ptldev01:1433;databaseName=CC2DEV;selectMethod=cursor;

and getting:

Code:

Message: Error debug in getConnection() : [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Using

Code:

version 3.2.1

Code:

<bean id="internalDataSourceDev" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
   <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
   <property name="url"
value="jdbc:microsoft:sqlserver://PTLACPT01.companydomain.com\ptldev01:1433;DatabaseName=CC2DEV;SelectMethod=Cursor"/>
   <property name="username" value="username"/>
   <property name="password" value="password"/>
</bean>

Someone not using Hibernate doing it all with JDBC seems to have no problem with this URL.

Any ideas?

~ Mike

max · **Posted:** Thu Jan 18, 2007 1:49 pm

i don't see anything related to hibernate in that.....

mikenereson · **Joined:** Wed Jan 17, 2007 10:32 am **Posts:** 6

max wrote:

i don't see anything related to hibernate in that.....

My apologies. Thanks.