Thanks Damon.. >hope you don't mind me CC'ing CF-Talk, NP.. i was going to put some private string details of the connection.. but i took it out.
> IBM drivers? (BTW, can you get connected with > those?) Yes.. this works very well.. and i think its faster than client access ODBC.. havent done any stress/performance testing though. Am curious if the DataDirect Drivers will perform better...atleast "DataDirect Claims SO" and i think they are using it somewhere in IBM Websphere. > First, there's a bug in JRun4 (and therefore > CFMX Server) - #48118, "jrpatch.jar" We already have this file dated 12/11/2002. I guess it came with CFMX Updater 2. Do i still need to try the below instructions? If "Yes".. will do and post the results this weekend or so.. Thanks again for you help. Joe On Fri, 13 Dec 2002 16:35:47 -0500 Damon Cooper <[EMAIL PROTECTED]> wrote: > 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 >
