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. >
