Here is a doc page on SQL Server:
http://www.jboss.org/documentation/mssql.htm
Plus you need to add a jaws.xml file that is similar to this:
<?xml version="1.0" encoding="UTF-8"?>
<jaws>
<datasource>java:/SQLServerPool</datasource>
<type-mapping>MS SQLSERVER</type-mapping>
<default-entity>
<remove-table>false</remove-table>
</default-entity>
<type-mappings>
<type-mapping>
<name>MS SQLSERVER</name>
<!-- INSERT MAPPINGS FROM standardjaws.xml HERE -->
</type-mapping>
</type-mappings>
</jaws>
-----------------------------------
Brenton House
Java Software Engineer
Pixel Magic Imaging, Inc.
----- Original Message -----
From: "Steve Shier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 4:05 AM
Subject: [JBoss-user] MS SQL7 JDBC-ODBC parameters
I want to use the JDBC-ODBC bridge to a Microsoft SQL 7.0 database and
would like to know the configuration parameters. They are listed in
the manual only for MS Access (see
http://www.jboss.org/documentation/HTML/ch03s05.html) and shown here
below-which of these MS Access parameters needs to be changed for MSSQL7
and to what values?
MS Access Configuration:
1. jboss.properties
jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver
2. jboss.conf
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="JetEngineDB">
<ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
3. jboss.jcml
<mbean name="DefaultDomain:service=XADataSource,name=JetEngineDB">
<attribute name="URL">jdbc:odbc:ODBC datasource name</attribute>
<attribute name="JDBCUser"></attribute>
<attribute name="Password"></attribute>
</mbean>
Is there anything else that needs to be done/avoided, such as in the
mappings in the jaws.xml file? I am using JDK 1.3 and JBoss 2.0 on WinNT
4.0 Server SP6a .
TIA,
Steve Shier
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
