It turned out that the driver wasn't happy here, 
D:\jrun4\servers\xxx\cfusion.ear\cfusion.war\WEB-INF\lib\basisjdbc.jar, and 
CFMX7 was only half-heartedly using it.

I probably could have added the path to the classpath, but instead, I just 
moved the jar up to a higher lib directory (D:\jrun4\servers\lib).

Works fine now.

Thanks,
Jamie

> I'm trying to connect to a database via JDBC. I can connect through 
> Java apps running on the Web server (using CFMX7's built-in JVM), but 
> the same data source configuration in the CFMX7 admin throws an 
> error:
> 
> Connection verification failed for data source: BASIS10
> java.sql.SQLException: Timed out trying to establish connection
> The root cause was that: java.sql.SQLException: Timed out trying to 
> establish connection
> 
> Here's what I'm using to (successfully) connect directly through a 
> Java app (personal info exxed out).
> D:\JRun4\jre\bin\java -classpath .;D:\jrun4\servers\xxx\cfusion.
> ear\cfusion.war\WEB-INF\lib\basisjdbc.jar TestConnection com.opentext.
> basis.jdbc.BasisDriver jdbc:opentext:basis://xxx:[EMAIL PROTECTED]
> xx:7300/library_docs xxx xxx
> 
> Any ideas what's wrong, or how to troubleshoot?
> 
> Thanks,
> Jamie
> 
> P.S. Yes, it's a weird DB (OpenText BASIS), but it uses JDBC.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:275599
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to