Wed, 02/25/2009 - 07:37
Hi Timmy,
If you are using the Remote Server mode for running the EMML script, you need to copy the drivers into the <presto-install-location>\server\apache-tomcat-5.5.20\webapps\presto\WEB-INF\lib, and restart the tomcat.
If you are using the embedded server mode, you can copy the drivers into the plugins folder of eclipse and restart eclipse as specified in the documentation.
Thanks,
Mythri
Wed, 02/25/2009 - 08:47
Hi Mashers,
I'm having a strange issue thats killing me. I have created a new EMML using Eclipse. What it does is connect to an Oracle DB using the <datasource /> code. This works sometimes but mostly does not work. I've set up JDBC drivers in Presto and that works all the time. I've also copied the drivers into the plugin folders and still no joy. So the error I get is
Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'org.hsqldb.jdbcDriver' for connect URL '<my URL connection>'
I've also tried with the the code driverclassname="oracle.jdbc.driver.OracleDriver" and I even get a less detailed error
Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
At the moment Im only getting into Mashups so Im running off localhost. I know its probably just and easy setting but its really stopping me from taking off. I find the prospects of Mashups amazing and when it works its brilliant. Please help me get over this bump in the road. Thanks again and great work
UPDATE1: I think it maybe because the DB I'm connecting to is 9i. I tried a 10g connection and that worked fine, can you help me with the 9i issue?
UPDATE2: Now 10g connection doesn't work...Think I need to clear out some cache or something?
Timmy, Ireland