Subject: Derby database (newbie) 2006-11-20 - By Peter Bradley
Back
Ysgrifennodd Ne'Bahn:
>> 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
Many thanks. I did eventually get it sorted. You are correct about the
classpath and the port.
There were a couple of gotchas:
* The port needed to be specified (as you say)
* The driver required was the ClientDriver
* There are some differences between the SQL required by Derby and
the SQL required by Pointbase. In particular, the syntax for
specifying a non-compound primary key is different, and also Derby
does not support the BOOLEAN data type.
I actually, in the end, managed to go through all the ant scripts and
make the necessary changes so that the projects build OK from those. It
was a bit fiddly, but it worked in the end: so far anyway. I'm not sure
when the lack of a boolean type is going to come back to bite (byte?)
me. I've used smallint, but I can see some problems down the line.
The only thing I don't seem to be able to do is to see the database in
netbeans. I can make a connection using the same driver and
credentials, but the tables don't show in the Runtime tab. It's only a
small thing, but it is annoying.
Thanks again.
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".
|
|
