Put MS SQL Server JDBC driver in your class path. I just put it in
<JAVA_HOME>/jre/lib/ext - you could probably put it in the JBoss
lib directory, but I haven't tried that.
Here's what I had to change in the jboss.jcml file for SQL Server:
<!-- modify Drivers to add class name of JDBC driver -->
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProv
ider">
<attribute name="Drivers">org.hsqldb.jdbcDriver,com.microsoft.jdbc.sqlserve
r.SQLServerDriver</attribute>
</mbean>
<!-- add mbean for SQL Server Pool -->
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XA
DataSource,name=SQLServerPool">
<attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourc
eImpl</attribute>
<attribute name="PoolName">SQLServerPool</attribute>
<attribute name="URL">jdbc:microsoft:sqlserver://sqltest1:1433;SelectMethod=
cursor</attribute>
<attribute name="Properties">DatabaseName=testlog</attribute>
<attribute name="JDBCUser">rn_user</attribute>
<attribute name="Password">rn_user</attribute>
</mbean>
I also modified standardjaws.xml (lines 3 and 4) to make SQLServerPool the defau
lt datasource
(instead of Hypersonic) and changed the type mapping to MS SQLSERVER as well:
<datasource>java:/SQLServerPool</datasource>
<type-mapping>MS SQLSERVER</type-mapping>
JD
-----Original Message-----
From: makapur
To: [EMAIL PROTECTED]
Sent: 5/31/2002 10:16 PM
Subject: [JBoss-user] SQL Server connection problem
Hi,
I am new to JBOSS.
I am not getting how to connect to the SQL Server database.
Please anybody can help me with proper steps to connect to sql server.
I am using JBOSS 2.4.4
Thanks in advance.
regards
makapur