RE: [JBoss-user] MS SQL7 JDBC-ODBC parameters
The free JDBC-ODBC driver is evil. Sun's free JDBC-ODBC driver [written by/with Merant if memory serves] isn't a great driver. It has poor performance and other issues with threading for instance. www.merant.com and www.EasySoft.com both offer substantially better JDBC-ODBC drivers. They are very good indeed. They are Type 3 drivers since they can't be 100% Java unless someone decided to re-write ODBC in Java (a *very* pointless task IMO). One benefit of ODBC is that the ODBC layer can handle connection pooling /transaction enlistment transparently using native Windows services. If you *prefer* an ODBC-JDBC solution, this is the way to go. If not, then a Type 4 driver is the way forward. The only time I would recommend Sun's JDBC-ODBC driver if for basic development or while you are awaiting delivery of your new driver ;-) As for free MS SQL Drivers, the only one I am aware of is FreeTDS and is listed in Kunle's HowTo. I wouldn't rely on Sybase drivers, the protocols began to diverge quite a while ago and certainly for SQL7 and SQL2000, a Sybase product would not be ideal. See http://www.jboss.org/documentation/HTML/ch10s22.html Cheers! Micheal -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Routtier-Wone Sent: 30 March 2001 07:00 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] MS SQL7 JDBC-ODBC parameters ODBC is evil. There is more than one free pure Java JDBC driver for TDS (the M$ and Sybase protocol). Search the net for TDS near JDBC. - Original Message - From: Steve Shier To: '[EMAIL PROTECTED]' Sent: Tuesday, March 27, 2001 8:05 PM Subject: [JBoss-user] MS SQL7 JDBC-ODBC parameters I want to use the JDBC-ODBC bridge to a Microsoft SQL 7.0 database and ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] MS SQL7 JDBC-ODBC parameters
ODBC is evil. There is more than one free pure Java JDBC driver for TDS (the M$ and Sybase protocol). Search the net for TDS near JDBC. - Original Message - From: Steve Shier To: '[EMAIL PROTECTED]' Sent: Tuesday, March 27, 2001 8:05 PM Subject: [JBoss-user] MS SQL7 JDBC-ODBC parameters I want to use the JDBC-ODBC bridge to a Microsoft SQL 7.0 database and ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] MS SQL7 JDBC-ODBC parameters
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 datasourcejava:/SQLServerPool/datasource type-mappingMS SQLSERVER/type-mapping default-entity remove-tablefalse/remove-table /default-entity type-mappings type-mapping nameMS 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