Re: [OJB-developers] OJB + M$ JDBC drivers ?

[Darren S. <dsy...@ci...>]

Here's how to configure the MS drivers within the repository:

<JdbcConnectionDescriptor id=3D"default">
    <dbms.name>Testdb</dbms.name>
    <driver.name>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver.nam=
e>
    <url.protocol>jdbc</url.protocol>
    <url.subprotocol>microsoft:sqlserver</url.subprotocol>
    <url.dbalias>//DEV-IRIS:1433;DatabaseName=3DTestdb</url.dbalias>
    <user.name>SQLAuth</user.name>
    <user.passwd>password</user.passwd>
</JdbcConnectionDescriptor> -->

The url alias format is:
//host:port;DatabaseName=3DTestdb

host =3D the database server machine name.  Port is typically the default=
 and
finally the database name.

You may also need the SelectMethod=3Dcursor - this allows multiple object=
s to
be opened on the connection - i.e. you can perform both a select and upda=
te
within a transaction on the same connection.  You can specify this option=
 on
the url.dbalias element:

<url.dbalias>//DEV-IRIS:1433;DatabaseName=3DTestdb;SelectMethod=3Dcursor<=
/url.db
alias>


Darren


----- Original Message -----
From: "Ricardo Arg=FCello" <ri...@ya...>
To: "Objectbridge (E-Mail)" <obj...@li...=
t>
Sent: Friday, March 01, 2002 11:48 PM
Subject: [OJB-developers] OJB + M$ JDBC drivers ?


Hello,

Because of the performance problems I've had with MySQL (maybe it's a
mm.mysql JDBC driver issue, but I have no time to make more tests! My use=
rs
are gonna kill me!), I'll try to import my tables to a MS SQL Server 2000
here in my office.

I downloaded the free JDBC drivers here:
http://www.microsoft.com/sql/downloads/2000/jdbc.asp

(Note: the .exe installer doesn't work, just download the .tar version, a=
nd
use the 3 jars from the lib directory)

Question:
How can I specify the MS driver in the repository.xml file?
There is no <dbms.name>MSSQL</dbms.name> entry in the documentation.

Does anybody has experience using OJB + MSSQL 2k?

Thanks in advance,

Ricardo Arguello




_______________________________________________
Objectbridge-developers mailing list
Obj...@li...
https://lists.sourceforge.net/lists/listinfo/objectbridge-developers