Hi,
I understand that it doesn't work for your case, but I'm afraid I can't
help you much because it works for me, and so far you didn't provide enough
information to reproduce the problem.
Just a few things I noticed:
* You wrote you use the latest version of H2, but in fact the latest error
message you got is from an older version (1.3.170). Reason: the build
number is included in the error code, which is [42001-170]. So the build is
170.
* The .trace.db file contains old dates. You wrote you reproduce the
problem now, but the error message starts with "07-09 12:51:43". So it
clearly was written at 2013-07-09 and not July 15th. The same with older
messages.
* You seem to backup and possibly restore files. One explanation is that
you restore old files over existing files.
* My guess is that you didn't always use the database URL you provided.
That's all I can say right now. I don't think this is a bug in H2.
Regards,
Thomas
On Monday, July 15, 2013, EDV-Services wrote:
> Sorry again, now I deleted all the data in all database tables except for
> the table "EINSTELLUNGEN"
> The full content of the trace.db-file is as follows:
>
> 07-09 12:51:43 jdbc[2]: exception
> org.h2.jdbc.JdbcSQLException: Syntax Fehler in SQL Befehl "EINSTELLUNGEN";
> erwartet "EXPLAIN, EXECUTE, {"
> Syntax error in SQL statement "EINSTELLUNGEN"; expected "EXPLAIN, EXECUTE,
> {"; SQL statement:
> EINSTELLUNGEN [42001-170]
>
> It seems like the errors only occur when H2 tries to restore the database
> data.
> And what does that error message mean? EXPLAIN, EXECUTE?
>
>
> Am Sonntag, 14. Juli 2013 16:14:31 UTC+2 schrieb EDV-Services:
>>
>>
>> Hi guys,
>>
>> I've developed a software project and I've noticed that there is a file
>> in my user folder called "mydb.trace.db".
>> When I open this file, I see a lot of sql statements exposing some tables
>> of my database.
>> I use the following connection string: jdbc:h2:~/mydb;TRACE_LEVEL_**
>> FILE=0;TRACE_LEVEL_SYSTEM_OUT=**0;CIPHER=AES"
>> I thought these two TRACE parameters in my connection string must be
>> enough to avoid creating the mydb.trace.db file.
>>
>> That's the trace output from "mydb.trace.db":
>>
>> 02-25 11:47:33 jdbc[2]: exception
>> org.h2.jdbc.JdbcSQLException: Syntax Fehler in SQL Befehl "INSERT INTO
>> CUSTOMER(xxx, yyy) VALUES('xxx', 'yyy');
>> ...
>>
>> I'm using the latest version "h2-1.3.172.dll" (dll file created from jar
>> file with ikvm).
>> The trace entries occur when i use the following vb.net code:
>>
>> Dim restore As New Restore()
>> restore.execute("backup.bck", "~", "mydb")
>>
>> I don't want hackers to be able to see my database content so imho it's a
>> serious security flaw.
>> Can anyone give me a hint what I'm doing wrong?
>>
>> Best regards
>> Michael
>>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected] <javascript:_e({},
> 'cvml', 'h2-database%[email protected]');>.
> To post to this group, send email to
> [email protected]<javascript:_e({}, 'cvml',
> '[email protected]');>
> .
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
