3.5.1.2. Configuring the OpenJPA DataSource
If you choose to use OpenJPA’s DataSource, then you must specify the following properties:
-
openjpa.ConnectionUserName: The JDBC user name for connecting to the database. -
openjpa.ConnectionPassword: The JDBC password for the above user. -
openjpa.ConnectionURL: The JDBC URL for the database. -
openjpa.ConnectionDriverName: The JDBC driver class.
To configure advanced features, use the following optional properties. The syntax of these property strings follows the syntax of OpenJPA plugin parameters described in Plugin Configuration.
-
openjpa.ConnectionProperties: If the listed driver is an instance ofjava.sql.Driver, this string will be parsed into aPropertiesinstance, which will then be used to obtain database connections through theDriver.connect(String url, Properties props)method. If, on the other hand, the listed driver is ajavax.sql.DataSource, the string will be treated as a plugin properties string, and matched to the bean setter methods of theDataSourceinstance. -
openjpa.ConnectionFactoryProperties: OpenJPA’s built-inDataSourceallows you to set the following options via this plugin string: -
QueryTimeout: The maximum number of seconds the JDBC driver will wait for a statement to execute. -
PrettyPrint: Boolean indicating whether to pretty-print logged SQL statements. -
PrettyPrintLineLength: The maximum number of characters in each pretty-printed SQL line. -
PrintParameters: A boolean indicating whether SQL parameter values will be included in exception text and when logging is enabled. Since the parameter values may contain sensitive information the default value is false.
<property name="openjpa.ConnectionUserName" value="user"/>
<property name="openjpa.ConnectionPassword" value="pass"/>
<property name="openjpa.ConnectionURL" value="jdbc:hsqldb:db-hypersonic"/>
<property name="openjpa.ConnectionDriverName" value="org.hsqldb.jdbcDriver"/>
<property name="openjpa.ConnectionFactoryProperties"
value="PrettyPrint=true, PrettyPrintLineLength=80, PrintParameters=true"/>