Currently, the JDBC driver that is being used is hardcoded in the template configuration files, e.g.:

hibernate.connection.driver_class=com.mysql.jdbc.Driver

Preferably, this should be configurable as well for the following reasons:

• You can specify another JDBC driver for a different database type, e.g. PostgreSQL
• You can configure WebDSL to use the MySQL replication driver (com.mysql.jdbc.ReplicationDriver), so that the MySQL database can be clustered and read from slaves. For this, also the JDBC option parameters must be configurable, e.g.:

jdbc:mysql://@DBSERVER@/@DBNAME@?useServerPrepStmts=false&characterEncoding=UTF-8&useUnicode=true&roundRobinLoadBalance=true

the latter GET parameter roundRobinLoadBalance=true is required to enable round robin read from slaves

Submitted by Sander van der Burg on 15 July 2011 at 14:51