It's good that you've given us a thorough description of your development environment, but unfortunately you haven't given us enough information to help solve your problem.
Check out this link for a description of the type of information we need.
In addition to this:
1-Show us how you've defined the datasource (In Struts? in JBoss?) and include snippets of the xml file. 2-Show us how you're trying to access the datasource in your code. 3-It's essential to know specifically what's going wrong and what error messages you're getting.
Steps to configure JBoss for MS SQL Server database and Struts
1)MS SQL Server driver classes are required in the Classpath. Copy MS SQL Server JDBC driver class; jar files mssqlserver.jar, msbase.jar, msutil.jar to the server/default/lib directory.
2)To configure with non-XA MS SQL Server datasource-copy /docs/examples/jca/mssql-ds.xml to /server/default/deploy directory.
3)To configure with MS SQL Server XA datasource copy /docs/examples/jca/mssql-xa-ds.xml to /server/default/deploy dir. Modify mssql-ds.xml configuration file. Driver Class and Connection URL settings for MS SQL Server JDBC Drivers are as follows: 3.1) <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver </driver-class> 3.2) <connection-url> jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDatabase </connection-url>
4) To configure with XA JDBC driver for MS SQL Server modify the mssql-xa-ds.xml configuration file. 4.1) <driver-class>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</driver-class>
5)The standardjbosscmp-jdbc.xml configuration file is configured with Hypersonic database. To configure JBoss server with MS SQL Server modify /server/default/conf/standardjbosscmp-jdbc.xml configuration file.
I am new to this forum. Is the JBoss forum not very helpful, because this sure does not look like a Struts question? Maybe you should post this info over there if other JBoss users would find it helpful. Are you using EJBs or are you connecting to the database in your Action classes?
Joined: Oct 24, 2005
Welcome to the forum !!
I thought its better to learn complete set up for the combo in one go - Jboss, Struts and SQL Server 2000.
I am not using EJB, i am connecting to DataBase through Action Servlets.