Here is a stack trace of what CF is doing when it verifies a data source
from CF ADMIN.
Unfortunately these files are encrypted, so there is no (Legal) way to
find out how the code looks.
"jrpp-88" in Object.wait()
- locked <138> (a coldfusion.server.j2ee.sql.pool.JDBCPool)
at java.lang.Object.wait(Native Method)
at java.lang.Thread.join(Thread.java:1009)
at
coldfusion.server.j2ee.sql.pool.ConnectionRunner.fetchConnection(Connect
ionRunner.java:43)
at
coldfusion.server.j2ee.sql.pool.JDBCPool.create(JDBCPool.java:519)
at
coldfusion.server.j2ee.sql.pool.JDBCPool._checkOut(JDBCPool.java:444)
at
coldfusion.server.j2ee.sql.pool.JDBCPool.checkOut(JDBCPool.java:350)
at
coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java
:720)
at
coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManage
r.java:123)
at
coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.j
ava:138)
at
coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.j
ava:125)
at
coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:37)
at coldfusion.sql.Executive.verifyDatasource(Executive.java:260)
at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at coldfusion.runtime.StructBean.invoke(StructBean.java:391)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1662)
at
cfudflibrary2ecfm24721086$funcVERIFYDSN.runFunction(C:\blackstone_update
s\cfusion\wwwroot\CFIDE\administrator\datasources\udflibrary.cfm:14)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.j
ava:254)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
56)
at
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1772)
at
cfindex2ecfm1536982671._factor11(C:\blackstone_updates\cfusion\wwwroot\C
FIDE\administrator\datasources\index.cfm:432)
~Brad
-----Original Message-----
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 19, 2007 11:43 AM
To: CF-Talk
Subject: RE: Testing Database Connection within Application
Doesn't look promising anymore.
http://livedocs.adobe.com/coldfusion/7/htmldocs/00001738.htm
That link tells you how to add data sources to CF with the admin API.
The last step says:
(Optional) To verify this data source later, click the verify icon in
the Actions column.
Note: To check the status of all data sources available to ColdFusion
MX, click Verify All Connections.
If there was a way to do it via the API they probably wouldn't tell you
to go to the CF Administrator interface.
~Brad
-----Original Message-----
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 19, 2007 11:30 AM
To: CF-Talk
Subject: RE: Testing Database Connection within Application
There is a decent chance that the admin api functionality gives you
access to the same thing that happens when you click the "verify data
source" icon in CF Admin.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275870
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
