BlindAbraxas
New Member
I recently connected to a Progress 9.1D database using the Progress 9.1D07 JDBC Driver provided with the Linux Client Networking package from Progress.
The Database runs on a Windows NT4 (sp6) box.
I connected using JOnAS 3.2, a J2EE application server which was running on a Mandrake 9.2 machine with Sun's Java SDK 1.4.2_02 installed.
The following properties file was what was needed by JOnAS to connect to the Database, JOnAS handled the logging in and creating (and pooling) the connection itself:
#################### Progress DataSource Configuration
#
##########
# DataSource configuration
#
datasource.name jdbc_1
datasource.url jdbc:jdbcprogress:T:10.1.0.58:2000:dps1
datasource.classname com.progress.sql.jdbc.JdbcProgressDriver
datasource.username <insert your progress db userid here>
datasource.password <insert your progress db password here>
datasource.mapper rdb
#####
# ConnectionManager configuration
#
# JDBC connection checking level.
# 0 = no special checking
# 1 = check physical connection is still open before reusing it
# 2 = try every connection before reusing it
jdbc.connchecklevel 2
# Max age for jdbc connections
# nb of minutes a connection can be kept in the pool
jdbc.connmaxage 30
# Test statement
jdbc.connteststmt select * from dual
I figured I should share, in case anyone is using J2EE and Progress and looking for a little kickstart. Note that the datasource.url should be customized for the host-name or ip address of your database, and the database name obviously (mine was dps1).
The following environment variables need to be set in linux in order for the JDBC driver to load:
DLC=/usr/dlc (or wherever you installed Progress on Linux)
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$DLC/lib
CLASSPATH=$CLASSPATH:$DLC/java/jdbc.jar:$DLC/java/progress.jar
This makes hitting the database from the web so much easier than using the Progress Appserver, in my opinion.
*whew*.
Chris Bush
The Database runs on a Windows NT4 (sp6) box.
I connected using JOnAS 3.2, a J2EE application server which was running on a Mandrake 9.2 machine with Sun's Java SDK 1.4.2_02 installed.
The following properties file was what was needed by JOnAS to connect to the Database, JOnAS handled the logging in and creating (and pooling) the connection itself:
#################### Progress DataSource Configuration
#
##########
# DataSource configuration
#
datasource.name jdbc_1
datasource.url jdbc:jdbcprogress:T:10.1.0.58:2000:dps1
datasource.classname com.progress.sql.jdbc.JdbcProgressDriver
datasource.username <insert your progress db userid here>
datasource.password <insert your progress db password here>
datasource.mapper rdb
#####
# ConnectionManager configuration
#
# JDBC connection checking level.
# 0 = no special checking
# 1 = check physical connection is still open before reusing it
# 2 = try every connection before reusing it
jdbc.connchecklevel 2
# Max age for jdbc connections
# nb of minutes a connection can be kept in the pool
jdbc.connmaxage 30
# Test statement
jdbc.connteststmt select * from dual
I figured I should share, in case anyone is using J2EE and Progress and looking for a little kickstart. Note that the datasource.url should be customized for the host-name or ip address of your database, and the database name obviously (mine was dps1).
The following environment variables need to be set in linux in order for the JDBC driver to load:
DLC=/usr/dlc (or wherever you installed Progress on Linux)
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$DLC/lib
CLASSPATH=$CLASSPATH:$DLC/java/jdbc.jar:$DLC/java/progress.jar
This makes hitting the database from the web so much easier than using the Progress Appserver, in my opinion.
*whew*.
Chris Bush