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
