The url format is the same as that you would use to connect to the database
from any java program it should look something like this:
jdbc:sybase:Tds:XXX:YYY?ELIMINATE_010SM=true
where XXX is the address of the database (i.e. along the lines of
mydb.mycompany.com)
and YYY is the port you should be connecting to.
The ?ELIMINATE_010SM=true part of the URL is optional. It turns off a
Sysbase warning message that is generated because the databases we connect
to don't support all of the features of JConnect, this isn't a problem in
itself as it works fine. However without the flag to turn the warning off
Jboss will catch the warning, decide things don't look too good, and ignore
this dataSource (so you would never be able to connect to this Db).
The JDBC User and Password fields should be set to the same values as you
use for username and password when you connect normally.
Hope this helps
Rob
-Original Message-
From: Jason Wells [mailto:[EMAIL PROTECTED]]
Sent: 27 April 2001 01:09
To: [EMAIL PROTECTED]
Subject: [JBoss-user] JDBC Sybase configuration?
Hello,
I'm trying to get JBoss to use the Sybase JConnect 5.2 JDBC driver for CMP
entity beans. I've been looking at the "Using MS SQL Server with JBoss"
tutorial on the JBoss site, which is the closest thing I've found in terms
of relevant documentation:
http://www.jboss.org/documentation/HTML/ch11s17.html
And actually, it seems pretty applicable. But there's one area where the
instructions aren't too useful, because they vary considerably from driver
to driver, and that's the connection pool MBean declaration. I'm thinking it
would look something like this...
com.sybase.jdbcx.SybDataSource
SybasePool
???
user=dbusername;
password=dbpassword
4
10
false
120
12
false
false
true
false
false
180
1.0
But, I have no idea how to formulate the JDBC URL, or if it's even needed.
Also, I wonder if I need "JDBCUser" and "Password" attributes. All of these
things seem to vary from driver to driver. Has anyone set this up for the
Sybase JDBC driver? Any help is appreciated.
Thanks,
Jason
___
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
