SQuirreL's taking over my Databases
SQuirreL SQL:
What are correct connection strings?
Where Derby databases being saved?
So... I installed SQuirreL on my PC and Mac so that I may work with both Access and Apache Derby Embedded databases. I wanted to convert from an MS Access db (PC) to an Apache Derby Embedded db (Mac) so that I may continue coding a specific project on my sometimes annoying Mac. Oy! I sucessfully did the conversion and got my PC's .mdb moved to my Mac as a Derby Embedded to make ColdFusion happy. Note I am using ColdFusion 8 Developer Edition.
A few things I learned: 1). What connection strings are valid. 2).Where the databases like to be saved. For my situation (others' may be different)...
Connection String for MS Acess on PC= jdbc:odbc:databasenamehere;
Connection String for Derby database on PC and MAC= jdbc:derby:databasenamehere;
Where Derby database files are saved on a PC:
In SQuirreL's app directory.
Where Derby database files are saved on a MAC:
1. Show SQuirreL's Package Contents (right-click)...
2. Find db in the Java directory (in this example, "nrd2009")...
Very helpful article for this post :
http://www.ibm.com/developerworks/rational/library/07/1218_gouveia/index.html
