This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Configuring SQL Server 2008 to JBOSS

 
Vikki Fiawoo
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 312
Java MS IE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please refer to, http://www.coderanch.com/t/544587/JDBC/java/no-sqljdbc-auth-java-library
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic