db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emmanuel Cecchet <m...@frogthinker.org>
Subject Re: Tomcat derby JSP "java.sql.SQLException: No suitable driver"
Date Tue, 09 Dec 2008 00:02:04 GMT
Mike,

Just to check, which JVM are you using? What is the output of 'java 
-version'?
Did you make sure that both Tomcat and Derby where using the same JVM?

manu

teamderby wrote:
> Stephan,
>
> Thanks a lot for your response. Your time and effort is very much
> appreciated.
>
> I am unfortunately still having problems, the jsp message:
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of
> class '' for connect URL 'null'
>
> I have followed your instructions above exactly with a clean download of
> Tomcat. I can therefore assume it is something silly I am doing in setting
> up the database or launching tomcat. I can not see how you have set the
> environment variables or the classpath.
>
>
> After following your instructions exactly I have placed a clean derby
> installation at /derby. I opened two terminals. in one:
>
>  export DERBY_HOME=/derby
>  export PATH="$DERBY_HOME/bin:$PATH"
>  cd derby/bin
>  setNetworkClientCP                       // this apparently sets the
> classpath for the client driver
>  ij
>  ij> CONNECT 'jdbc:derby:db;create=true';     
>  ij> CREATE TABLE DB.....                 // and then SQL to create the
> tables.
>  java -jar $DERBY_HOME/lib/derbyrun.jar server start     // this seems to
> successfully start the db listening to port 1527
>
>
>
> In terminal two:
>
> cd CATALINA_HOME/bin
> ./startup.sh
>
> I then tried accessing localhost:8080 with your index.jsp page in ROOT. I
> understand I must be misunderstanding something. your help would be much
> appreciated. thanks,
>
> Mike


-- 
Emmanuel Cecchet
FTO @ Frog Thinker 
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: manu@frogthinker.org
Skype: emmanuel_cecchet


Mime
View raw message