| Author |
MS SQL Server 2000 JDBC driver and databasename
|
|
| Jouni Peltonen 2004-02-04, 12:39 am |
|
Hi,
I have tried to switch from using WebLogic jDriver for MS SQL Server to using
MS SQL Server 2000 JDBC Driver as recommended by Bea for WebLogic 7.0. I can get
the connection pooling to work with the new driver but I cannot get it to work
for certain database. It seems to always connect to the defaul database even though
I specify the database in console with property databasename=DBNAME. Any ideas
what could be wrong?
Thanks!
Cheers,
Jouni
| |
| Pete Inman 2004-02-04, 12:39 am |
|
We had this working fine with WLS7, this is the entry from our config.xml
<JDBCConnectionPool DriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
InitialCapacity="50" MaxCapacity="50" Name="SQLServerConnectionPool" Password="{3DES}UkODkM1JaCU="
Properties=" user=Destin8;SelectMethod=cursor;databas
eName=Destin8V3" ShrinkingEnabled="false"
Targets="Destin8Cluster1" URL="jdbc:microsoft:sqlserver://mcp1:1433"/>
Hope this helps..
Pete
"Jouni Peltonen" <jouni@hotelzon.com> wrote:quote:
>
>Hi,
>
>I have tried to switch from using WebLogic jDriver for MS SQL Server
>to using
>MS SQL Server 2000 JDBC Driver as recommended by Bea for WebLogic 7.0.
>I can get
>the connection pooling to work with the new driver but I cannot get it
>to work
>for certain database. It seems to always connect to the defaul database
>even though
>I specify the database in console with property databasename=DBNAME.
>Any ideas
>what could be wrong?
>
>Thanks!
>
>Cheers,
>Jouni
| |
| Pete Inman 2004-02-04, 12:39 am |
|
Forgot the datasource def.
<JDBCTxDataSource EnableTwoPhaseCommit="true" JNDIName="Destin8.Destin8DataSource"
Name="Destin8TXDataSource" PoolName="SQLServerConnectionPool" Targets="Destin8Cluster1"/>
"Jouni Peltonen" <jouni@hotelzon.com> wrote:quote:
>
>Hi,
>
>I have tried to switch from using WebLogic jDriver for MS SQL Server
>to using
>MS SQL Server 2000 JDBC Driver as recommended by Bea for WebLogic 7.0.
>I can get
>the connection pooling to work with the new driver but I cannot get it
>to work
>for certain database. It seems to always connect to the defaul database
>even though
>I specify the database in console with property databasename=DBNAME.
>Any ideas
>what could be wrong?
>
>Thanks!
>
>Cheers,
>Jouni
| |
| Shyun Chen 2004-07-28, 6:15 pm |
| I need to use Microsoft JDBC driver with WL 7.0 (with connection pool & data source).
How do I install the Microsoft JDBC driver ? (where should I put the jar files ?)
Thanks,
Shyun Chen
| |
| Slava Imeshev 2004-07-28, 6:15 pm |
| Hi Shyun,
"Shyun Chen" <noemail@noemail.given> wrote in message news:15548405.1090971087670.JavaMail.root@jserv5...
> I need to use Microsoft JDBC driver with WL 7.0 (with connection pool & data source).
> How do I install the Microsoft JDBC driver ? (where should I put the jar files ?)
You can place the driver anywhere you like. Server installation "lib"
dir may be a good place to start. You will also have to modify server's
startup script to make sure that path to the driver jar is the first thing
in the server startup CLASSPATH.
Regards,
Slava Imeshev
|
|
|
|