I was being dense, it was file permissions. Thanks for the response. Mike.
>-----Original Message----- >From: Michael Segel [mailto:[email protected]] On Behalf Of >[email protected] >Sent: Wednesday, September 02, 2009 9:32 AM >To: 'Derby Discussion' >Subject: RE: Read only connection? > > >What are your privileges? > >Depending on the database, you can grant users different permissions on >connection, table (insert update delete), the ability to execute dll >(alter >database statements) etc ... > >So I'd check your permissions that are granted to the user. > >HTH > >> -----Original Message----- >> From: Mike Baranski [mailto:[email protected]] >> Sent: Wednesday, September 02, 2009 8:21 AM >> To: [email protected] >> Subject: Read only connection? >> >> I have an embedded derby DB, and when I connect and try to insert, I >get: >> >> Exception: An SQL data change is not permitted for a read-only >connection, >> user or database. >> >> This is the only thing connected to it, and is the same version (the >same >> exact files, actually) of the jars that were used to create it. The >> connection string is: >> >> String connectionURL = "jdbc:derby:/path/to/db/;create=false;"; >> >> I can read data all day long. Same thing happens with the IJ tool. >> >> Can someone help? >> >> Thanks, >> Mike. >>
