Database URL and Driver Classes

Example of configuring a database in eFORMz

Troubleshooting information is at https://www.minisoft.com/support/index.php/troubleshooting-a-database-connection/.

DB2 (iSeries)

Database name:
Connection name. The actual database name is not required.

Driver Class:
com.ibm.as400.access.AS400JDBCDriver

URL:
jdbc:as400://123.456.78.90

Add the following properties and their values:

• user
• password
• databasename

For example:

jdbc:as400://HostNameOrIP/<databasename>;naming=sql;prompt=false;libraries=*LIBL,QTEMP,OTHERLIB;user=<username>;password=<password>

• HostNameOrIP = the host or IP where DB2 is running, e.g. server23 or 10.25.172.59
• <databasename> = the name of the database to which to connect
• <username> = the user name for connecting
• <password> = the password for connecting
• prompt=false = Do not try to prompt for passwords or anything else, as we are not running in an interactive environment
• libraries=*LIBL,QTEMP,OTHERLIB = This specifies a list of libraries (similar to databases in iSeries realm) to search. *LIBL and QTEMP are standard iSeries libraries, whereas OTHERLIB should be replaced by an actual library name that should be searched. For example, the database containing the Manhattan data could be listed here. Additional libraries can be specified as well.
• naming is an optional property that specifies whether to use SQL naming or System naming; possible value: sql or system. If sql, then object names are qualified by libname.objname; if system, then it’s libname/objname.

Example:

jdbc:as400:10.35.24.195:8471;user=eformz;password=zformeprd;libraries=DGM14BAPD;prompt=false

If you do not know the database name, logon to your AS/400 and run WRKRDBDIRE from the command line. Only the database marked *LOCAL is the local database that resides on the AS/400 system.

References

IBM Toolbox for Java JDBC properties

H2

Database connection name: HMS_H2
Driver class: org.h2.Driver
URL: jdbc:h2:C:\Minisoft\eFORMz_6\h2db\HMS_H2;AUTO_SERVER=TRUE

References

H2 Database

Image and Eloquence

Database name:
Connection name. Actual database name not needed in this field.

Driver Class:
com.minisoft.jdbc.MSJDBCDriver

URL:

Write access:
jdbc:MSJDBC:///?Server=xxx.xxx.xx.xxx&ServerPort=30007&User=xxx&UserPassword=
xxx&Group=xxx&Account=xxx&ImageDatabase0=eformz,WRITE,0,1,0

Read access:
jdbc:MSJDBC:///?Server=xxx.xxx.xx.xxx&ServerPort=30007&User=xxx&UserPassword=
xxx&Group=xxx&Account=xxx&ImageDatabase0=eformz,READALL,0,5,0

Note: Requires Minisoft’s JDBC (Java Database Connectivity) driver.

Informix

Driver Class:
com.informix.jdbc.IfxDriver

URL:
jdbc:informix-sqli://:/:
INFORMIXSERVER=;user=;password=

Example:
jdbc:informix-sqli://Sturgeon:9088/stores_demo:
INFORMIXSERVER=informix_server;user=admin;password=xxx

Microsoft Access

Option A

Driver Class:
sun.jdbc.odbc.JdbcOdbcDriver

Oracle removed jdbcOdbcDriver from Java in Java Version 8. You can still use Java 7 with the latest version of eFORMz. Please see Option B below for driver for Java 8.

URL direct path example:
jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=c:\\Minisoft\\eFORMz_6\\Projects\\eDirect\\Sample3\\emaildb.mdb

Note: Path specification is case sensitive.

URL using system DSN:
jdbc:odbc:[database name]

Example:
jdbc:odbc:emaildb

Create a System DSN
1. From your Start menu, select Settings > Control Panel.
2. The Control Panel dialog box appears. Select Administrative Tools and ODBC Data Source.
3. The ODBC Data Source Administrator window appears. Select the System DSN tab and then click Add.
4. The Create New Data Source dialog box appears. Select Microsoft Access Driver (*.mdb) from the list of drivers. Click Finish.
5. The ODBC Microsoft Access Setup dialog box appears.
6. From the Database section click on Select to establish the path to your database, located on your PC.
7. Once the Database path has been established, enter a database reference name in the Data Source Name field.
8. Enter a database description, if needed, in the Description field. Once complete click OK.
10. Your newly created database reference will appear in the ODBC Data Source Administrator dialog box under the System DSN tab. Click OK.

Option B

Driver Class:
net.ucanaccess.jdbc.UcanaccessDriver

URL/Connection String:
jdbc:ucanaccess://[database name]

JAR Files:

From your UCanAccess installation folder copy the following files into the
C:\Minisoft\eFORMz_6\jars\Local\folder:

ucanaccess-X.X.X.jar
commons-lang-X.X.jar
commons-logging-X.X.X.jar
hsqldb.jar
jackcess-X.X.X.jar

More information for Connection String Properties:
http://ucanaccess.sourceforge.net/site.html#examples

Download Link:
http://ucanaccess.sourceforge.net/site.html#home

Maria DB

Driver Class:
com.mysql.jdbc.Driver

URL: jdbc:mysql://[host name or ip address]/[database name]?user=[user
name]&password=[user password]

jdbc:mysql://localhost/schema?user=admin&password=Password

MySQL

Driver Class:
com.mysql.jdbc.Driver

URL:
jdbc:mysql://[host name or ip address]/[database name]?user=[user
name]&password=[user password]
jdbc:mysql://123.456.78.90/eformz?user=eformz&password=eformz

When you reference the database URL in the web.xml file, you can exclude the user name and password. For example:

jdbc:mysql://123.456.78.90/eformz

For eFORMz to connect to your MySQL database, you must copy your MySQL jdbc driver class into your eFORMz jar folder:

Copy:
\sqlDriver\mysql-connector-java-xxxx\mysql-connector-java-xxxxx-bin.jar
to the following directory:
C:\Minisoft\eFORMz_6\jars\Local

Oracle

Driver Class:
oracle.jdbc.driver.OracleDriver

URL:
jdbc:oracle:thin:<user>/<password>@<DB server name or IP>:1521/<dbname>

<user> = user name for database
<password> = password for database
<DB server name or IP> = name or IP address of the database server
<dbname> = database name to use

Example:
jdbc:oracle:thin:@123.456.78.90:1521/emaildb

For eFORMz to connect to your Oracle database, you must copy your oracle jdbc driver class into your eFORMz jar folder:

Copy:
[Oracle_Home]\jdbc\lib\classesXXX.zip
to the following directory:
C:\Minisoft\eFORMz_6\jars\Local
and then rename the classesXXX.zip to classesXXX.jar

*NOTE: Post Oracle upgrade you will need to download and copy over the new ojdbcX.jar file, and possibly remove the old classesXXX.jar file.

Oracle Cluster

JDBC URL for Oracle RAC ( Real Application Cluster )

jdbc:oracle:thin:[user]/[password]@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=service)))

Progress

Driver Class:
com.ddtek.jdbc.openedge.OpenEdgeDriver

URL:
jdbc:datadirect:openedge://servername:10005;databaseName=c:\progressdb\
sportstest;user=username;password=password;defaultschema=pub

JAR Files:

From your Progress installation folder copy the following files into the C:\Minisoft\eFORMz_6\jars\Local\ folder:

base.jar
openedge.jar
util.jar

SQL Server

Driver Class:
com.microsoft.sqlserver.jdbc.SQLServerDriver

URL:
jdbc:sqlserver://12.34.567.899:1433;databaseName=ECOMVER;
user=minisoft;password=minisoft2007;selectMethod=cursor;
parametersAsUnicode=false

You must specify the correct IP address, port (if different), database name, user, and password.

NOTE: SQL Server users running on older version of Java will experience delays. Use Java 1.8 or above (sqljdbc41.jar needed) is recommended.

ADDITIONAL NOTE: Microsoft has three flavors of JDBC jar file for SQL Server connections.

https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver?view=sql-server-ver15

Of relevance to us are the 8 and 14 builds. While 14 will be used by the default installation, 8 is still needed for some installations (iSeries and Glassfish).

Sybase

Driver Class:
com.sybase.jdbc3.jdbc.SybDriver

URL:
jdbc:sybase:Tds:localhost:2638

Parameters:
SERVICENAME=demo
HOSTNAME=localhost
user=DBA
password=sql
STREAM_CACHE_SIZE=10000
LITERAL_PARAMS=false
CURSOR_ROWS=0
SESSION_TIMEOUT=300
JCONNECT_VERSION=6
CANCEL_ALL=true
DYNAMIC_PREPARE=true
LANGUAGE_CURSOR=false
SEND_LONG_PARAMS_REGARDLESS_OF_CAPABILITIES=false
IGNORE_DONE_IN_PROC=false
REQUEST_HA_SESSION=false
ELIMINATE_010SM=true
GET_BY_NAME_USES_COLUMN_LABEL=false
ESCAPE_PROCESSING_DEFAULT=false

JAR File:
Place the Sybase jar file into the C:\Minisoft\eFORMz_6\Local\ folder:
jconn3.jar

TAGS: Connection string; driver class