| ... |
... |
@@ -1,12
+1,43 @@ |
| 1 |
1 |
{{figure image="database_driver_en.png"}} |
| 2 |
|
-The error message when no database drivers are installed. You need to install the appropriate database driver for your database management system |
|
2 |
+The error message appears when no database drivers are installed. You need to install the appropriate database driver for your database management system. |
| 3 |
3 |
{{/figure}} |
| 4 |
4 |
|
| 5 |
|
-As of version 5.0.13, {{formcycle/}} does not ship with the database driver anymore. This allows you to use different drivers and driver versions. You need to install the appropriate driver for the database management system(s) you are using. The driver are available here: |
|
5 |
+{{formcycle/}} does not ship with any database driver anymore. This allows you to use different drivers and driver versions. However, you must first install the appropriate driver for the database management system you are using. The driver are available from the official page of the respective database management system: |
| 6 |
6 |
|
| 7 |
|
-* [[MySQL>>https://dev.mysql.com/downloads/connector/j/||target="_blank"]] |
| 8 |
|
-* [[OracleDB>>http://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html||target="_blank"]] |
| 9 |
|
-* [[PostgreSQL>>https://jdbc.postgresql.org/download.html||target="_blank"]] |
| 10 |
|
-* [[SQLServer>>https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server?view=sql-server-2017||target="_blank"]] |
|
7 |
+* [[Oracle MySQL>>https://dev.mysql.com/downloads/connector/j/||rel="noopener noreferrer" target="_blank"]] |
|
8 |
+* [[OracleDB>>http://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html||rel="noopener noreferrer" target="_blank"]] |
|
9 |
+* [[PostgreSQL>>https://jdbc.postgresql.org/download.html||rel="noopener noreferrer" target="_blank"]] |
|
10 |
+* [[SQLServer>>https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server?view=sql-server-2017||rel="noopener noreferrer" target="_blank"]] |
| 11 |
11 |
|
| 12 |
|
-The installation procedure is different depending on which server you are using. An example for the installation on Tomcat can be found [[here>>doc:Formcycle.SystemSettings.TomcatSettings.InstallDBDriver]]. |
|
12 |
+The installation procedure depends on the application server you are using. You can find instructions for Apache Tomcat [[here>>doc:Formcycle.SystemSettings.TomcatSettings.InstallDBDriver]]. |
|
13 |
+ |
|
14 |
+== Notes on Oracle MySQL == |
|
15 |
+ |
|
16 |
+{{figure image="database_mysql_unicode_en.png"}} |
|
17 |
+Using Unicode with //Oracle MySQL//. Normally, the database driver recognizes the encoding automatically. In case it does not, you can specify the encoding explicitly. |
|
18 |
+{{/figure}} |
|
19 |
+ |
|
20 |
+Since version 8, Oracle MySQL does not recognize the timezone name {{smallcaps}}Cest{{/smallcaps}} anymore. By default, the operating system transmit the timezone to the database. When it transmit that timezone name, the database connection cannot be established. In this case, you can specify the timezone explicitly via the {{smallcaps}}Jdbc{{/smallcaps}}-{{smallcaps}}Url{{/smallcaps}}: |
|
21 |
+ |
|
22 |
+{{code language="text"}} |
|
23 |
+jdbc:mysql://localhost/db?serverTimezone=Europe/London |
|
24 |
+{{/code}} |
|
25 |
+ |
|
26 |
+Also, there are some circumstances when the character encoding is not recognized correctly. If that happens, you can pass the encoding via {{smallcaps}}Jdbc{{/smallcaps}}-{{smallcaps}}Url{{/smallcaps}} as well. For example, when using Unicode and the database setting //connection collation// was set to //utf8_general_ci//: |
|
27 |
+ |
|
28 |
+{{code language="text"}} |
|
29 |
+jdbc:mysql://localhost/db?useUnicode=true&characterEncoding=UTF-8 |
|
30 |
+{{/code}} |
|
31 |
+ |
|
32 |
+== Using different database systems |
|
33 |
+ |
|
34 |
+It is also possible to use different database management systems such as HSQLDB, Derby, or Informix. This requires that you installed the corresponding database driver. Here is a list of the {{smallcaps}}Jdbc{{/smallcaps}}-{{smallcaps}}Url{{/smallcaps}} and driver class for some database management systems: |
|
35 |
+ |
|
36 |
+{{table dataTypeAlpha="0-2" preSort="0-asc"}} |
|
37 |
+|=Name|=JDBC-URL|=JDBC-driver class |
|
38 |
+| Maria DB| jdbc:mariadb:~/~/<dbhost>/<dbname>| org.mariadb.jdbc.Driver |
|
39 |
+| SAP HANA| jdbc:sap:~/~/<dbhost>:30015/| com.sap.db.jdbc.Driver |
|
40 |
+| Informix| jdbc:informix-sqli:~/~/<dbhost>:9088/sysuser:INFORMIXSERVER=hpjp|com.informix.jdbc.IfxDriver |
|
41 |
+| HSQLDB| jdbc:hsqldb:mem:<dbname>| org.hsqldb.jdbc.JDBCDriver |
|
42 |
+| Derby| jdbc:derby:target/tmp/derby/hpjp;databaseName=<dbname>;create=true| org.apache.derby.jdbc.EmbeddedDriver |
|
43 |
+{{/table}} |