That worked... somehow I missed to try that...
Thanks a lot...
On Monday, April 7, 2014 3:12:35 PM UTC+1, Noel Grandin wrote:
>
>
> I think you are misreading the documentation.
>
> If you want it to return it a ResultSet, you need to omit the "TO" section
> of the command.
>
> So your comman
I think you are misreading the documentation.
If you want it to return it a ResultSet, you need to omit the "TO" section of
the command.
So your command should look like:
SCRIPT NOPASSWORDS NOSETTINGS DROP TABLE
On 2014-04-07 15:56, Chandra DhulipalaV wrote:
This is the error log... Y
Hi Noel,
This is the error log... You can see that I have not given any filename and
just left it as empty (''). H2 is trying to write to script.sql and throws
"access is denied" exception...
SCRIPT NOPASSWORDS NOSETTINGS DROP TO '' TABLE *TABLE_NAME* [90028-175];
nested exception is org.h2.jd
Can you post the full stack trace?
Today there was an IO Exception saying FIleNotFound for the script file. It
means H2 internally still uses a file in a
physical location to generate the result set. This is not mentioned in H2 site.
Is this correct?
--
You received this message because you
Hi,
I have used the SCRIPT command to generate e database table script in our
application. As I do not want to write to a file for security reasons and
do not want to handle file deletion permission issues, I did not specify
the file name and used the result set in the application.
Today there