I am having a hard time implementing an embedded DB. First off, I am using java to connect to the DB and manipulate the information it contains. I can successfully connect to and work with Derby, but I need an application like Access to create and enter the 100+ lines of information. When I open the Derby DB in OpenOffice Base, it will not allow me to edit my data.
Which brings me to attempt number 2. I created a DB with OO Base, but when I query the new DB with Java, It gives me a "table not found in statement" error. I ran a simple Select * From defs query. I can get the statement to execute in OO by adding quotation marks to the table name like so: Select * From "defs". If I leave off the quotation marks, I get the previously defined error.
Does anyone have any clue about what may be going on? Would someone have any suggestions about another approach to adding an embedded DB to my app? Any help would be greatly appreciated.