RE: [JBoss-user] SQL Server connection problem

[Bill Burke]

Title: RE: [JBoss-user] SQL Server connection problem

you do not have to put the JDBC driver classes in /jre/lib/ext....  Put the jar in <JBOSS_HOME>/lib/ext. 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JD Brennan
Sent: Saturday, June 01, 2002 2:09 AM
To: 'makapur '
Cc: '[EMAIL PROTECTED]'
Subject: RE: [JBoss-user] SQL Server connection problem

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