Subject: Derby database (newbie) 2006-11-19 - By Ne'Bahn
Back
> I got the driver string from the Drivers list in the netbeans Projects
> window
(1) Check your CLASSPATH for the new libraries (.jar files) added (database
drivers), download them anyway, java.lang.ClassNotFoundException:
org.apache.derby.jdbc.EmbeddedDriver seems to match perfectly your problem
(the most common).
On windows:
CLASSPATH=%CLASSPATH%;<drive>:\wherever_you_put_jar_files\libraries.jar
On UNIX:
CLASSPATH=$CLASSPATH:/wherever/you/put/jar/files/libraries.jar
(2) In my opinion I should reconsider the string "protocol" adding the
specific port (localhost : the_port), though you have two database servers
running, and softs aren't completely "smart", just for consistency, although
it might not be imperative.
(3) Anyway check your Derby installation (I mean, the classpath for your
.jar files), Apache should give (via web, of course) a nice documentation
about their product, I've never used Derby but Tomcat / Lenya / Tapestry /
Lucene and so others, all them with a very high level documentation about
almost everything you can do with the piece of soft.
Regards, Me
-- -- Original Message -- --
From: "Peter Bradley" <p.bradley@(protected)>
To: <J2EE-INTEREST@(protected)>
Sent: Saturday, November 18, 2006 9:40 a.m.
Subject: Derby database (newbie)
> Good afternoon.
>
> I've bought SAMS Teach Yourself J2EE in 21 days, but even though I've
> downloaded the J2EE 1.4 package, it uses the Derby database rather than
> the
> Pointbase database on which the book is based. Can anyone tell me how I
> can
> convert the sample code supplied with the book to use Derby instead?
>
> I have J2EE 1.4.03 and jdk 1.5.0.09 with netbeans 5.5.
>
> The first exercise is to set up the database, and I tried changing:
>
> // PointBase
> private static final String driver =
> "com.pointbase.jdbc.jdbcUniversalDriver";
> private static final String protocol =
> "jdbc:pointbase:server://localhost/sun-appserv-samples,new";
> private static final String user = "pbPublic";
> private static final String password = "pbPublic";
>
> To:
>
> // Derby
> private static final String driver =
> "org.apache.derby.jdbc.EmbeddedDriver";
> private static final String protocol =
> "jdbc:derby://localhost/sun-appserv-samples,new";
> private static final String user = "app";
> private static final String password = "app";
>
> But with no luck.
>
> The ant files that the book provides contain some references to Pointbase
> that I don't really understand so I've left them alone.
>
> I got the driver string from the Drivers list in the netbeans Projects
> window.
>
> I've tried using the supplied source file in a new netbeans project, but
> although it compiles just fine, it fails at runtime with the message:
>
> java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
>
> Presumably that means the required library isn't on whatever classpath
> netbeans is using - but I'm only guessing. It's a long time since I did
> any
> Java programming, especially with netbeans.
>
> Any suggestions as to how I should proceed will be gratefully received.
>
> Thanks
>
>
> Peter
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
|
|
