RE: [JBoss-user] using ms sql server 2000 with jboss

[JD Brennan]

Here's what worked for me with JBoss 2.4.4...   Put the MS SQL JDBC driver in <JDK>/jre/lib/ext   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=JdbcProvider">      <attribute name="Drivers">org.hsqldb.jdbcDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver</attribute>   </mbean>   <!-- add mbean for SQL Server Pool -->   <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=SQLServerPool">     <attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</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">user</attribute>     <attribute name="Password">pass</attribute>   </mbean>   I also modified standardjaws.xml (lines 3 and 4) to make SQLServerPool the default 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: Li Xiang [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 12:05 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [JBoss-user] using ms sql server 2000 with jboss   I have already added a mbean named MSSQL2000DS just below the mbean named DefaultDS. but when I restart the JBoss,the MSSQL2000DS couldn't start,in fact, I do not find any information about MSSQL2000DS in the logfile at all, Why? Where is my new DataSource? Anybody can help me ? Thanks a lot!