Hi Thomas, thank you for your reply.
I've opened the trace.db-file in Notepad++ and I deleted every single line in that file. The file was empty. Then I tried to restore a backup file and Notepad++ reloaded the file with the input I've posted above. I also tried to delete the file, but H2 created it again. Regarding the date I'd like to tell you that my trace.db file contains a lot of such lines with different dates: 02-25 11:47:33 jdbc[2]: exception ... 02-25 11:50:27 jdbc[2]: exception ... 02-25 11:51:02 jdbc[2]: exception ... 02-25 11:51:33 jdbc[2]: exception ... 02-25 11:52:34 jdbc[2]: exception ... 02-25 11:59:05 jdbc[2]: exception ... 02-25 20:47:35 jdbc[2]: exception ... 02-25 21:06:55 jdbc[2]: exception ... 02-25 21:07:06 jdbc[2]: exception ... 02-25 21:07:15 jdbc[2]: exception ... 02-25 21:08:24 jdbc[2]: exception ... 02-25 21:11:05 jdbc[2]: exception ... 02-25 21:11:18 jdbc[2]: exception ... 02-25 21:16:21 jdbc[2]: exception ... 02-25 21:17:06 jdbc[2]: exception ... 02-25 21:51:59 jdbc[2]: exception ... 02-25 21:52:10 jdbc[2]: exception ... 02-25 21:52:13 jdbc[2]: exception ... 02-27 13:43:27 jdbc[2]: exception ... 03-06 19:08:42 jdbc[2]: exception ... 03-07 16:39:26 jdbc[2]: exception ... 03-07 16:39:33 jdbc[2]: exception ... 03-08 15:24:57 jdbc[2]: exception ... 03-08 15:24:57 jdbc[2]: exception ... 03-08 16:46:04 jdbc[2]: exception ... 03-07 19:39:57 jdbc[2]: exception ... Before I haven't used this code "TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0". I just started to use it 4 weeks ago. And I used "h2-1.3.160" until last week. Last Sunday I switched to "h2-1.3.172" because I thought it could solve my problem but it didn't. What I've noticed is that the backup file is restored with a lot of errors. Sometimes the column number of a table doesn't fit which is very curious because the restore file contains the db structure and also the db data. So why are there errors when I make a backup and after 5 seconds I try to restore the same file? Thank you again for your help. Best regards, Michael Am Montag, 15. Juli 2013 19:26:35 UTC+2 schrieb Thomas Mueller: > > Hi, > > Sorry I can't reproduce the problem. The *.trace.db file is not created in > my case, with the latest version of H2. > > Please note the message you posted starts with "02-25 11:47:33", this > means the message is from February 25th. Are you sure you disabled the > setting back then? What version of H2 did you use back then? > > Regards, > Thomas > > > On Sun, Jul 14, 2013 at 4:14 PM, EDV-Services <[email protected]<javascript:> > > wrote: > >> >> 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:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> 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.
