my dog learned polymorphism*
The moose likes JForum and the fly likes Derby Support Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Derby Support" Watch "Derby Support" New topic
Author

Derby Support

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi,

I was trying to bring up JForum on an embedded Derby database. This is the Java-based database that IBM donated to Apache. It used to be the commercial product "Cloudscape".

Anyway, Derby would be a very powerful, pure Java, embedded (as well as network server based) db engine. You can learn more about Derby here: http://incubator.apache.org/derby/.

I added the "derby" directory and files for derby under WEB-INF/config/database/, and added derby to the list of databases in the <select> of the install page. However, when I click to install, the database gets changed back to mysql on the confirmation page. I presume because some Java code is checking the database name and concluding there is no "derby" and defaulting to mysql.

Could you please indicate where this check is taking place and how I can get around it?

thanks.
[originally posted on jforum.net by time]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I suggest to not use the installer, since it much probably will require changes on it. Use manuall installation. For derby specific sql syntax you also will need to implement a DataAccessDriver and the respective model interfaces. Take a look in the hsqldb implementation as example. It is under src/net/jforum/drivers/hsqldb

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thanks. Actually, I use MySQL at the moment I just thought I would add the support for Derby and contribute, if it was simple enough. I think it would be good for JForum to support Derby.

[originally posted on jforum.net by time]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I guess it should not be complicated. Even the implementation for HSQLDB is very easy. The only thing we have do deal with is with database "proprietary" sql sintax.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Derby Support
 
Similar Threads
problem to connect to a derby database...
Creating and building Standalone application
Installation of a Swing Application
java and MySQL size issues
Please help me in creating setup in java