Weblogic and sybase

[Goober]

I am using weblogic 5.1 sp 6 on win 2000, I have a oracle connection,
working fine now I need to connect to sybase to get some info form 2nd
Database: here is the change that I made in welogic.property file how ever I
must have some kind of bug with it since I get an exception.(see below) I am
trying to use Jconnect5.2 thank you for any pointers or help

weblogic.jdbc.connectionPool.SybaseUcmsPool=\
url=jdbc:sybase:Tds:xxx.xxx.xxx.xxx:5000,\
driver=com.sybase.jdbcx.SybDriver.VERSION_5,\
initialCapacity=1,\
maxCapacity=20,\
capacityIncrement=2,\
loginDelaySecs=0,\
allowShrinking=true,\
shrinkPeriodMins=2,\
refreshMinutes=10,\
testTable=dual,\
testConnsOnReserve=true,\
testConnsOnRelease=true,\
props=user=user1;password=password1
weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.taskPool=SybaseUcmsPool

Tue Apr 03 10:14:54 EDT 2001:<I> <JDBC Pool> Creating connection pool
SybaseUcmsPool with:
{aclName=weblogic.jdbc.connectionPool.SybaseUcmsPool,
url=jdbc:sybase:Tds:xxx.xxx.xxx.xxx:5000, poolName=SybaseUcmsPool}
Tue Apr 03 10:14:54 EDT 2001:<E> <JDBC Pool> Failed to create connection
pool "SybaseUcmsPool"
java.lang.Exception: Missing startup value "driver" in JDBC Connection Pool
SybaseUcmsPool
at
weblogic.jdbc.common.internal.ConnectionPool.getPoolValue(ConnectionPool.jav
a:359)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:247
)
at
weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java:117)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
at
weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java:109)
at
weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)

[Goober]

Thank you for answer and yes I do have it in classpath. I got a connection
going and it appears that the problem was actually little with the jts
weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.taskPool=SybaseUcmsPool
once I removed this line all seemed to work.

Do you know what is the proper way to set up the jts ?

"Steve Healey" <Stephen...@sybase.com> wrote in message
news:3ACA0B66...@sybase.com...
> Do you have the JConnect jconn2.jar file in your CLASSPATH?
>
> Steve Healey
> Sybase TS

[Steve Healey]

Do you have the JConnect jconn2.jar file in your CLASSPATH?

Steve Healey
Sybase TS

[Dave Wolf [Sybase]]

Try using the driver class

com.sybase.jdbc2.jdbc.SybXADataSource

If you want to use XA.

Dave Wolf
Internet Applications Division

"Goober" <javam...@hotmail.com> wrote in message
news:foa9toG...@forums.sybase.com...