Closed Connections?

[agoerig]

We were all set to go live yesterday with the new server. However, The DSN
keeps reporting "closed connections". I can sqlplus to the database from the
new server and I can use Java to connect to the Database. But Coldfusion
simply does not want to connect. I used to the same environment with my java
program that coldfusion would do.

The last time the new server worked was around 3pm yesterday prior to me
shutting it down to commence the an upgrade to an application from old server
to the new server. We didn't even touch the Coldfusion App directory which is
the strangest thing.

But after we tried to start the server

Coldfusion error message:

Connection verification failed for data source: LAW
java.sql.SQLException: Closed Connection
The root cause was that: java.sql.SQLException: Closed Connection


exception.log
"Error","jrpp-0","01/31/06","03:45:20",,"Error Executing Database Query.Closed
Connection The specific sequence of files included or processed is:
/opt/lawtrac5/BCFLegal/default.cfm "

CFMX6.1 on Suse Linux
Apache 2
Java 1.4.2
Oracle 9.2.0.4.0

[BKBK]

Is your database server still running? if so, what settings do you use for datasource in the Coldfusion Administrator?