Dave, Thanks for your response. I have got your point and will try to follow the guidelines from my next mail on.
I was basically interested in knowing all the steps that are required to connect to a remote SQL server 2000 using Struts on JBoss. After a night of trial and errors, I have finally established the connection. I am listing the steps to perform this task. It may be helpful to few people. ********************************************************************** 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. 6) Make the changes as: <jbosscmp-jdbc> <defaults> <datasource>java:/MSSQLDS</datasource> <datasource-mapping>MS SQLSERVER2000</datasource-mapping> </defaults> </jbosscmp-jdbc> 7) Modify login-config.xml configuration file with MS SQL Server database settings. Add the following <application- policy/> element to login-config.xml. <application-policy name = "MSSQLDbRealm"> <authentication> <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required"> <module-option name = "principal">sa</module-option> <module-option name = "userName">sa</module-option> <module-option name = "password">password</module-option> <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MSSQLDS> </module-option> </login-module> </authentication> </application-policy> By modifying the mssql-ds.xml, standardjbosscmp-jdbc.xml and login-config.xml the JBoss 4.0 server is configured to be used with a MS SQL Server database. 8) Download these two files to use data connection using Struts and copy them to the server/default/lib directory. 1. Commons-pool-1.2.jar 2. Commons-dbcp-1.2.1.jar Regards, Jitendra -----Original Message----- From: Dave Newton [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 5:48 PM To: Struts Users Mailing List Subject: [OT] Re: Struts 1.1 issue (myEclipse+Jboss 3.2.5+SQL Server 2000) Jitendra Kumar wrote: > Using the above I simply want to print the records of any table in my > SQL Server 2K DB. > > The problem: > I am not able to do the above. I have tried changing some files in > Jboss. I have copied some jars of DB Drivers in WEB-INF/lib folder etc. > http://www.catb.org/~esr/faqs/smart-questions.html <http://www.catb.org/%7Eesr/faqs/smart-questions.html> By what mechanism would you expect us to be able to answer this question? Besides the fact that this has absolutely nothing to do with Struts, you have provided essentially zero information that would allow us to even BEGIN to help. Do you get an error? If so, what error? What JARS are you using? How are you accessing the database? Dave --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]