Hello, Reading all your suggestions, i think i will take this approach:
A. Using TCP server mode, the H2 server is started by our application. For example: jdbc:h2:tcp://10.20.30.40/data/mydb1 B. Clients then connect to IP of the server using jdbc:h2:tcp://10.20.30.40/data/mydb1 But then i have 3 more questions: 1. If we are using encryption, should client connects using this URL? jdbc:h2:tcp://10.20.30.40/data/mydb1;CIPHER=AES, AND supplying <file password><space><user password> when connecting, just like embedded mode? 2. How to start server from application? 3. Using server mode (TCP), will clients have access to database content? Can user connect using web browser? Or write another TCP client then dump (scrip) all data without knowing user password? 4. How we prevent database user from dumping data (script to, backup, etc)? Thank you, andy On Tue, 24 May 2011 22:29:00 +0700 Thomas Mueller <[email protected]> wrote: >Hi, > >I agree it might be easier to use the server mode. > >Anyway, if you can't or don't want to: To improve performance, you >could use the fast (but relatively new, and still experimental) >pseudo-encryption algorithm "FOG". It makes the data _appear_ to >be >encrypted. This algorithm is cryptographically extremely weak, and >should only be used to hide data from reading the plain text using >a >text editor. To use it, replace AES (or XTEA) with FOG. You could >use >a fixed (hardcoded) password (with regular encryption or the 'FOG' >algorithm). > >Regards, >Thomas > >-- >You received this message because you are subscribed to the Google >Groups "H2 Database" group. >To post to this group, send email to [email protected]. >To unsubscribe from this group, send email to h2- >[email protected]. >For more options, visit this group at >http://groups.google.com/group/h2-database?hl=en. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
