This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Configuring SQL Server 2008 to JBOSS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Configuring SQL Server 2008 to JBOSS" Watch "Configuring SQL Server 2008 to JBOSS" New topic
Author

Configuring SQL Server 2008 to JBOSS

Vikki Fiawoo
Greenhorn

Joined: Oct 22, 2010
Posts: 11
Good Morning,

I am trying to run a simple jsp that will Sql Server 2008 connection using JBOSS 5.1 (Enterprise Application). Please find below the tutorial. It is under the section
Configuring a datasource for Microsoft SQL Server 200x
http://docs.jboss.org/jbossas/docs/Installation_And_Getting_Started_Guide/5/html/Using_other_Databases.html

1.)

Here is how I modified the mssql-ds.xml file:



I placed this file in the C:\Program Files\EnterprisePlatform-5.1.0\jboss-eap-5.1\jboss-as\server\default\deploy folder.


2.) I copied the sqljdbc4.jar file in the C:\Program Files\EnterprisePlatform-5.1.0\jboss-eap-5.1\jboss-as\server\default\lib folder

3.) I created a WAR folder jdbcclient.war in the C:\Program Files\EnterprisePlatform-5.1.0\jboss-eap-5.1\jboss-as\server\default\deploy folder.

4.) I created a jsp called client.jsp and saved it in the jbdcclient.war folder. Here is the client.jsp code:



5. I tried to test if the connectioni using the following url

http://localhost:8080/jdbcclient/client.jsp


There are a few things I would like to mention. After reading some of the many posts in this forum on this topic, I have noticed that do not have sqljdbc_auth.dll file copied anywhere in JBOSS. So I only copied the path tot the sqljdbc_auth.dll to the Systems Variables PATH. Should this file be copied anywhere else? If so, where specifically where I copy the file.

Also, I am using a Window Authenciation to access the Sql Server database. I feel very strongly that my mssql-ds.xml file is not configured properly. I have tried modified this file several different ways and have read numerous documentation and still can not get this client.jsp to work.

I am just trying to test my connectivity from Sql Server to JBoss and this seems to be so difficult to do.

Please provide me with assistances on how to modified my files and/or where to copy any necessary jars. I have been on this for 12 hours and at this point I do not now what to do. I have also attached the error message I am receiving.
Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

Please refer to, http://www.coderanch.com/t/544587/JDBC/java/no-sqljdbc-auth-java-library


S.D. MADHAN
Not many get the right opportunity !
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Configuring SQL Server 2008 to JBOSS
 
Similar Threads
How to make a data source connection without writing a User name & Password and the -ds.xml file
Exception thrown org.jboss.util.NestedSQLException
MySQL Datasource
JBoss MS SQL server connectivity problems
Configure to MS SQL Server 6.5