Apache Derby Embedded datasource in ColdFusion on Linux

I'm working on moving an application over from my development machine (WinXp Pro) to my testing/production servers (RedHat Linux). The application uses an Apache Derby Embedded datasource in ColdFusion 8. Setting up the datasource on my Windows machine worked like a charm, but when I went to do the same thing on the Linux machines, the ColdFusion administrator interface shows "Data & Services > Datasources > Other" when I select "Apache Derby Embedded" as the datasource type on the main Datasource screen for adding datasources. On my Windows machine, it goes to the "Data & Services > Datasources > Apache Derby Embedded" screen. In order to work around this bug, I used the following data on the "Other" datasource entry screen to hook up to the Derby database:

JDBC URL: jdbc:derby:/the/datasource/path/databasefolder;create=true
Driver Class: org.apache.derby.jdbc.EmbeddedDriver
Driver Name: Apache Derby Embedded

The create=true is the same as checking the box for Create Database on the normal datasource entry screen in Windows. Seems to work like a charm!

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
BlogCFC was created by Raymond Camden. This blog is running version 5.8.