Hi, H2 uses many system properties, which is unfortunate because those can only be set for the whole system (meaning they must be the same for all databases). Also setting those properties is not user friendly (java -D... or System.setProperty(...)). The plan for the future is to not use any system properties for database related settings. Of course in the near future all system properties will still be supported for backward compatibility.
Many system properties will be replaced with connection properties that are only valid in the database URL. Example: jdbc:h2:~/test;analyzeSample=10. I started implementing this, but it will take some time. I'm not sure yet if those will also be supported using the SET command (some can be supported in theory, such as analyzeSample, other can't because they technically can't change once a database is open, such as functionsInSchema). System properties that are not related to a database will remain for now (for example h2.objectCache). So there will still be: - system properties - database settings (some only supported in the database URL, some persistent) - session settings > 2) Implement a command or UDF: > SET PROPERTY "property_name" TO "property_value" [persistent]; No, H2 will not support this. The current SET <propertyName> <propertyValue> is sufficient. > 3) Use the driver's connection properties. This is already supported. 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 h2-datab...@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
