JDBC
Tue, 03/03/2009 - 15:57
Hi Timmy,
Can you please post a JDBC URL you are using connect ?
The error looks like general JDBC error. Basically JDBC driver cannot connect to DB using URL you provided. Looks like you suggesting that Oracle RAC (Real Application Cluster) is in use. Oracle RAC enviroment can provide additional challanges when configuring JDBC and connecting to DB. Thus I would recomment that you make sure that you can connect to it outside of Presto from Java program using the same JDBC driver you are using in presto. You can use some free Java based DB browsers fro example http://squirrel-sql.sourceforge.net/
Regards, Alexi
Wed, 03/04/2009 - 16:31
Hi,
I am having another connection issue. My last issue was installing the driver files in the following folder
<presto-install-location>\server\apache-tomcat-5.5.20\webapps\presto\WEB-INF\lib
This helped me and I was able to connect to DB no prob. However I want to connect to another DB and it just aint working,on Tomcat Im getting a 'ServiceInvocationException: 7'. I know it doesn't tell much but a pointer in the right direction would help a lot
Just an update error which im getting in Eclipse
Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869824)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))))
Also just been told that the server is a rack (not to sure what that means)
Thanks
Timmy, Ireland