JBoss MSSQL datasource connection

[NuniPR]

Hi Guys!

I haven't written in a while, but I guess I need your help on this. I've been working on this non-stop for the past 2 days and I am just about to give up.

I have to create a datasource in JBoss running on Windows 2k3. Of course, I have no idea how to do this, since there's no web-console installed. So, it has to be done manually.

I downloaded the SQL Server JDBC from Microsoft, and placed the sqljdbc.jar in jboss\server\default\lib. I then went to jboss\server\all\deploy and modified the existing ds.xml to reflect this:

<local-tx-datasource>
  <jndi-name>NuniPRDS</jndi-name>
  <connection-url>jdbc:sqlserver://servername:1433;DatabaseName=databasename</connection-url>
   <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
   <user-name>Username</user-name>
   <password>Password</password>
   <check-valid-connection-sql>SELECT 1 FROM sysobjects</check-valid-connection-sql>
   <metadata>
    <type-mapping>MS SQLSERVER2000</type-mapping>
    </metadata>
</local-tx-datasource>

I also made the same entry in the mssql-ds.xml file.

When I test, this is the error I get:

“Exception: NuniPRDS not bound. Cause: NuniPRDS not bound”

I don't know if I had to specify that .jar someplace else or what am I doing wrong. I've tried switching sqlserver.jdbc for jdbc.sqlserver as suggested on some sites. No luck. Can you help?

Thank you tons!


Nunina
IT Manager
San Juan, PR

http://www.viveconendometriosis.com

 

[Diancecht]

Any help here?

Cheers,
Dian

 

[NuniPR]

No Dian, no luck at that site. I can't even load that page!

Nunina
IT Manager
San Juan, PR

http://www.viveconendometriosis.com

 

[Diancecht]

Try this one: [URL unfurl="true"]http://www.techienuggets.com/Comments?tx=14045[/url]

Cheers,
Dian

 

[TonHu]

I'd go for the much more stable and performant free JDBC driver for MSSQL from jTDS at

http://jtds.sourceforge.net/

Switched once, as the MS driver wasn't working and only throwing exceptions, and never looked back. Easy as pie.