Kbase P128129: Unable to configure a JDBC Connection Pool with Sun Java System Application Server 9 and Progress 9.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/14/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Attempting to configure a JDBC Connection Pool in Sun Java System Application Server 9 (SJSAS9)
Using Progress 9.1x JDBC drivers
SJSAS9 Ping test fails with "An error has occurred"
Datasource Classname is set to com.progress.sql.jdbcx.pooling.JdbcProgressPooledConnectionDataSource
Resource Type is set to javax.sql.XADataSource
Correct Additional Properties have been set and populated:
portNumber = value of -S
databaseName = value of -db
serverName = value of -H
user = SQL-92 username
password = SQL-92 password
CAUSE:
SJSAS9 runs on JVM 1.5 and later. Progress 9.1x runs on JVM 1.3.x. The JDBC drivers that are shipped with Progress 9.1x are not compatible with the later JVM used by SJSAS9.
FIX:
Upgrade to OpenEdge 10.1x.
OpenEdge 10.1x uses a later JVM version and ships with Type 4 JDBC drivers which are compatible with the JVM used by SJSAS9.