Hey Joe....hope you don't mind me CC'ing CF-Talk, so everyone can use this info if necessary...
First, there's a bug in JRun4 (and therefore CFMX Server) - #48118, that can obscure the actual JDBC exception that you're encountering, giving the generic one below. So let's first see what the actual error is you're encountering.... 1) Shut down CFMX. 2) Grab this file: ftp://ftp.allaire.com/outgoing/damonc/jrpatch.jar 3) Move aside (and SAVE!) your existing {cf_root}/lib/jrpatch.jar (if you have one), and put this "jrpatch.jar" down as {cf_root}/lib/jrpatch.jar. 4) Start CFMX 5) Try to connect again and send the error you're getting Next, I don't see any reference to "libraries" in the DataDirect documentation anywhere, so perhaps the concept is only relevant for the IBM drivers? (BTW, can you get connected with those?) The "Native" DB connections we have are essentially just direct convenience mappings for you...they're not treated "specially" in any way, except for setup, connection, and some easier-to-use panels for customers. Connection pooling is achieved via our JDBCPool class. The pooling behavior is defined by the DSN settings you've set up in the Admin...we'll create a new connection as necessary, and if you've not disallowed connection pooling, we'll re-use an existing connection if the connection info is the same, and there's one available in the pool. -----Original Message----- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 4:03 PM To: Damon Cooper Subject: RE: DB Driver Inf / DB2 on AS/400 / Joe / PDF Ref Doc / etc etc Hi Damon.. Connection failed with this error Connection verification failed for data source: SYSTEMB_DUDB []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Is there anyway to know whether it created the package? Libraries are data space objects in DB400.. This is what my native(JTOpen) connection string looks like.. jdbc:as400://200.0.0.0/DBDATA;libraries=JDB,JEB JDB and JEB are libraries. Does CFMX treat "Native" DB connection different from default.. DB connections? How is connection pooling achieved? One Connection, mutiple statemens? Thanks Joe
