copy jconn3.jar (or jconn2.jar) to $com.sun.aas.instanceRoot/domain_name/lib
configure Connection Pool
Datasource Classname: com.sybase.jdbc3.jdbc.SybDataSource
(or com.sybase.jdbc2.jdbc.SybDataSource if you are using jconn2.jar)
Resource Type: javax.sql.DataSource
Configure Additional Properties
databaseName
dataSourceName
password
portNumber
serverName
user
And guess what you got if there is more than one database running on server...
WARNING|glassfish|javax.enterprise.resource.resourceadapter_...
Connection could not be allocated because: JZ00L: Login failed.
After a bit investigating i found that it tries to connect to first database started at server. databaseName seems to be ignored.
Solution
Additional Properties -> Add
ServiceName : your database name here
Optionally you can add
BE_AS_JDBC_COMPLIANT_AS_POSSIBLE – true
FAKE_METADATA – true
UPDATE 2008/04/10
Newer versions of glassfish recognize properties from driver so you will end with ~150+ properties when creating new pool
Subscribe to:
Posts (Atom)