Don't think current temporary tables is designed to work in read-only databases. It is not documented as a supported behavior. So don't think this is a bug.
http://db.apache.org/derby/docs/10.1/ref/rrefdeclaretemptable.html Also look at Developer guide about read-only databases: http://db.apache.org/derby/docs/10.1/devguide/tdevdeploy26887.html However, this may be useful. An IMPROVEMENT request would be good to file. Satheesh Rick Hillegas wrote: > Hi Ian, > > This sounds like the wrong behavior to me, and you are welcome to file > a bug. I realize that is cold comfort. > > Regards, > -Rick > > Leslie Software wrote: > >> I have created a read-only database (currently a directory structure >> but eventually it will be moved into a .jar). I setup the properties >> for the database log and the temp directory fine and most things seem >> to work. If I perform a complex query I can see temporary files being >> created in the temp directory I specified; however when I try to create >> my own temporary table - like this: >> >> declare global temporary table test (name VARCHAR(10), value INT) not >> logged >> >> I get this error: >> SQL Execution Error:Execute error (25503): >> DDL is not permitted for a read-only connection, user or database. >> >> Should I be able to create temporary tables for a ready-only >> database? If not how will I be able to write multi stage queries >> (perform step >> one and place results in a temporary table then join the temp table to >> the other tables to get the results needed)? I am sure that as I >> develop my application I will run into cases where I will need to use >> temporary tables to perform the queries I need. I followed the steps >> in the manual >> <http://db.apache.org/derby/docs/10.0/manuals/develop/develop34.html#Creating+and+Preparing+the+Database+for+Read-Only+Use> >> >> to set things up. >> >> Any advice would be appreciated. >> >> Thanks, >> >> Ian >> >> >> >> >> >> >> __________________________________________________________ Find your >> next car at http://autos.yahoo.ca >> >> > > >
