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:
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!

There are no comments for this entry.
[Add Comment]