Hi Thomas,
thank you again for your reply.
I definitely use the "h2-1.3.172.dll" file. I've downloaded the jar file
some days ago and I used IKVM to transform the jar file into a dll file to
be able to use H2 in my .NET project.
I understand that my trace-db file contains old dates but I don't
understand why as I don't know anything about the internal H2 db processes.
All I can say is that I delete the trace-file before doing a restore and
then that output is created.
> One explanation is that you restore old files over existing files
Thats true. In my application you have a database running and you can do
backups and restores whenever you want.
When I do a restore, the database already exists. I don't delete the
database before I restore an old backup file.
Is that the problem?
Also true is, that before I haven't used the same URL as now.
As I told you, I've added the two parameters
"TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0;" later.
Maybe H2 saves the url parameters into the database files on first database
connection so if you add these two parameters to your connection URL later,
then they won't affect the trace output anymore.
I would like to send you my backup file, so you can try to restore the file
on your machine.
Are you okay with that? If yes, then please tell me your email address.
Best regards
Michael
Am Dienstag, 16. Juli 2013 08:42:16 UTC+2 schrieb Thomas Mueller:
>
> 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].
>> 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.
>>
>>
>>
>
--
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.
