Hmmm, well I have now done a re-install of apache to 2.0.44 to accomodate CF
Updater2. It appears I have the same issue. I have checked the mysql.err
file for errors and have found none.

I don't beleive this to be a database issue with MySQL since when I change
the timeout period of the "maintain connections" portion of CF Administrator
datasource setup, the error happens accordingly after the specified time has
expired. Thus, it appears to be a CF issue that doesn't know how to hold the
connection information or re-establish the connection. Although I agree, it
looks like there is a problem creating the db connection, but it appears to
be on the CFMX side of things.

Also, I can login to mysql with simultaneous users using MyCC all while this
is going on, so I don't believe it to be a max users issue.

Paul

-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]

> java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to
> connect, please check your username, password, URL, and other connectivity
> info.
>       at jrun.sql.pool.JDBCPool.createPhysicalConnection(Unknown Source)


Looks to me like a problem creating a new connection (the maximum number
of connections to the datbase is reached?). Make sure you enable
sufficient logging options on the MySQL side and watch what happens there.

Jochem

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to