Hi Thomas, I thought the same, I thought it could be a bug in my application. Then I restored my latest backup file by using the web interface of H2 by clicking on "Tools" -> "Restore" -> "Start". And the result was the same: Trace-output of error messages in trace.db-file even if I remove the trace file before starting to restore. That's why I offered you to send you my backup file so you can try it with the web interface, too.
I'm 100% sure, it has nothing to do with my application. The only mistake I could have done was when I created my database the first time and then accessed it without the trace = 0 parameters in my db url. I guess H2 saved the trace parameters TRACE_LEVEL_SYSTEM_OUT = 1 and TRACE_LEVEL_FILE = 1 (default) inside the database files so changing the url parameters later won't affect anything. Nevertheless, thank you for your reply again. Best regards, Michael Am Mittwoch, 17. Juli 2013 18:35:14 UTC+2 schrieb Thomas Mueller: > > Hi, > > > I definitely use the "h2-1.3.172.dll" file. > > Yes, I understand. > > > I understand that my trace-db file contains old dates but I don't > understand why > > Well, the most simple explanation is that those files are old files. > Probably your application restored them from somewhere (I think I wrote > that already). You need to figure out why this happens. This is your > application, and I can't really help you there. This is not a problem of H2. > > > I would like to send you my backup file, so you can try to restore the > file on your machine. > > Sorry, I'm not quite sure how this would help. It seems you need to figure > out what's wrong with your application, why it restores old .trace.db > files. This is your application, and I'm not able to help you with that. > > Regards, > Thomas > > > > > > On Wed, Jul 17, 2013 at 12:50 PM, EDV-Services <[email protected]> wrote: > >> 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_** >>>>> FIL**E=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 h2-database+unsubscribe@**googlegroups.com. >>>> To post to this group, send email to [email protected]. >>>> Visit this group at >>>> http://groups.google.com/**group/h2-database<http://groups.google.com/group/h2-database> >>>> . >>>> For more options, visit >>>> https://groups.google.com/**groups/opt_out<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. >> >> >> > > -- 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.
