{"id":3088,"date":"2015-05-21T19:05:38","date_gmt":"2015-05-21T19:05:38","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=3088"},"modified":"2021-05-25T09:39:33","modified_gmt":"2021-05-25T16:39:33","slug":"database-url-and-driver-classes","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/database-url-and-driver-classes\/","title":{"rendered":"Database URL and Driver Classes"},"content":{"rendered":"<h3>Example of configuring a database in eFORMz<\/h3>\n<h2><a href=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-8358\" src=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3.png\" alt=\"\" width=\"647\" height=\"401\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3.png 647w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-300x186.png 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-150x93.png 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-250x155.png 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-550x341.png 550w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-290x180.png 290w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-484x300.png 484w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/a><\/h2>\n<p>Troubleshooting information is at\u00a0<a href=\"\/support\/index.php\/troubleshooting-a-database-connection\/\">https:\/\/www.minisoft.com\/support\/index.php\/troubleshooting-a-database-connection\/<\/a>.<\/p>\n<h2>DB2 (iSeries)<\/h2>\n<p>Database name:<br \/>\nConnection name. The actual database name is not required.<\/p>\n<p>Driver Class:<br \/>\ncom.ibm.as400.access.AS400JDBCDriver<\/p>\n<p>URL:<br \/>\njdbc:as400:\/\/123.456.78.90<\/p>\n<p>Add the following properties and their values:<\/p>\n<ul>\n<li>user<\/li>\n<li>password<\/li>\n<li>databasename<\/li>\n<\/ul>\n<p>For example:<\/p>\n<pre>jdbc:as400:\/\/HostNameOrIP\/&lt;databasename&gt;;naming=sql;prompt=false;libraries=*LIBL,QTEMP,OTHERLIB;user=&lt;username&gt;;password=&lt;password&gt;<\/pre>\n<p>\u2022 <code>HostNameOrIP<\/code> = the host or IP where DB2 is running, e.g. server23 or 10.25.172.59<br \/>\n\u2022 <code>&lt;databasename&gt;<\/code> = the name of the database to which to connect<br \/>\n\u2022 <code>&lt;username&gt;<\/code> = the user name for connecting<br \/>\n\u2022 <code>&lt;password&gt;<\/code> = the password for connecting<br \/>\n\u2022 <code>prompt=false<\/code> = Do not try to prompt for passwords or anything else, as we are not running in an interactive environment<br \/>\n\u2022 <code>libraries=*LIBL,QTEMP,OTHERLIB<\/code> = This specifies a list of libraries (similar to databases in iSeries realm) to search. <code>*LIBL<\/code> and <code>QTEMP<\/code> are standard iSeries libraries, whereas <code>OTHERLIB<\/code> 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.<br \/>\n\u2022 <code>naming<\/code> 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 <code>libname.objname<\/code>; if system, then it\u2019s <code>libname\/objname<\/code>.<\/p>\n<p>Example:<\/p>\n<pre>jdbc:as400:10.35.24.195:8471;user=eformz;password=zformeprd;libraries=DGM14BAPD;prompt=false<\/pre>\n<p>If you do not know the database name, logon to your AS\/400 and run WRKRDBDIRE\u00a0from the command line. Only the database marked *LOCAL is the local database that\u00a0resides on the AS\/400 system.<\/p>\n<h3>References<\/h3>\n<p class=\"js-topic-title ibm-h2 ibm-padding-content\" dir=\"auto\" tabindex=\"0\"><a href=\"https:\/\/www.ibm.com\/support\/knowledgecenter\/en\/ssw_ibm_i_73\/rzahh\/jdbcproperties.htm\"><strong>IBM Toolbox for Java JDBC properties<\/strong><\/a><\/p>\n<h2>H2<\/h2>\n<p>Database connection name:\u00a0<code>HMS_H2<\/code><br \/>\nDriver class:\u00a0<code>org.h2.Driver<\/code><br \/>\nURL:\u00a0<code>jdbc:h2:C:\\Minisoft\\eFORMz_6\\h2db\\HMS_H2;AUTO_SERVER=TRUE<\/code><\/p>\n<h3>References<\/h3>\n<p class=\"js-topic-title ibm-h2 ibm-padding-content\" dir=\"auto\" tabindex=\"0\"><a href=\"\/support\/index.php\/h2-database\/\"><strong>H2 Database<\/strong><\/a><\/p>\n<h2>Image and Eloquence<\/h2>\n<p>Database name:<br \/>\nConnection name. Actual database name not needed in this field.<\/p>\n<p>Driver Class:<br \/>\ncom.minisoft.jdbc.MSJDBCDriver<\/p>\n<p>URL:<\/p>\n<p>Write access:<br \/>\njdbc:MSJDBC:\/\/\/?Server=xxx.xxx.xx.xxx&amp;ServerPort=30007&amp;User=xxx&amp;UserPassword=<br \/>\nxxx&amp;Group=xxx&amp;Account=xxx&amp;ImageDatabase0=eformz,WRITE,0,1,0<\/p>\n<p>Read access:<br \/>\njdbc:MSJDBC:\/\/\/?Server=xxx.xxx.xx.xxx&amp;ServerPort=30007&amp;User=xxx&amp;UserPassword=<br \/>\nxxx&amp;Group=xxx&amp;Account=xxx&amp;ImageDatabase0=eformz,READALL,0,5,0<\/p>\n<p>Note: Requires Minisoft\u2019s JDBC (Java Database Connectivity) driver.<\/p>\n<h2>Informix<\/h2>\n<p>Driver Class:<br \/>\ncom.informix.jdbc.IfxDriver<\/p>\n<p>URL:<br \/>\njdbc:informix-sqli:\/\/:\/:<br \/>\nINFORMIXSERVER=;user=;password=<\/p>\n<p>Example:<br \/>\njdbc:informix-sqli:\/\/Sturgeon:9088\/stores_demo:<br \/>\nINFORMIXSERVER=informix_server;user=admin;password=xxx<\/p>\n<h2>Microsoft Access<\/h2>\n<p><strong>Option A<\/strong><\/p>\n<p>Driver Class:<br \/>\nsun.jdbc.odbc.JdbcOdbcDriver<\/p>\n<p><strong>Oracle removed jdbcOdbcDriver from Java in Java Version 8. You can still<\/strong><strong>\u00a0use Java 7 with the latest version of eFORMz. Please see Option B below for driver for Java 8.<\/strong><\/p>\n<p>URL direct path example:<br \/>\njdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};<br \/>\nDBQ=c:\\\\Minisoft\\\\eFORMz_6\\\\Projects\\\\eDirect\\\\Sample3\\\\emaildb.mdb<\/p>\n<p>Note: Path specification is case sensitive.<\/p>\n<p>URL using system DSN:<br \/>\njdbc:odbc:[database name]<\/p>\n<p>Example:<br \/>\njdbc:odbc:emaildb<\/p>\n<p>Create a System DSN<br \/>\n1. From your Start menu, select <em>Settings &gt; Control Panel<\/em>.<br \/>\n2. The Control Panel dialog box appears. Select <em>Administrative Tools<\/em> and <em>ODBC Data Source<\/em>.<br \/>\n3. The ODBC Data Source Administrator window appears. Select the <em>System DSN<\/em> tab and then click <em>Add<\/em>.<br \/>\n4. The Create New Data Source dialog box appears. Select <em>Microsoft Access Driver (*.mdb)<\/em> from the list of drivers. Click <em>Finish<\/em>.<br \/>\n5. The ODBC Microsoft Access Setup dialog box appears.<br \/>\n6. From the <em>Database<\/em> section click on <em>Select<\/em> to establish the path to your database, located on your PC.<br \/>\n7. Once the Database path has been established, enter a database reference name in the <em>Data Source Name<\/em> field.<br \/>\n8. Enter a database description, if needed, in the <em>Description<\/em> field. Once complete click <em>OK<\/em>.<br \/>\n10. Your newly created database reference will appear in the ODBC Data Source Administrator dialog box under the <em>System DSN<\/em> tab. Click <em>OK<\/em>.<\/p>\n<p><strong>Option B<\/strong><\/p>\n<p>Driver Class:<br \/>\nnet.ucanaccess.jdbc.UcanaccessDriver<\/p>\n<p>URL\/Connection String:<br \/>\njdbc:ucanaccess:\/\/[database name]<\/p>\n<p>JAR Files:<\/p>\n<p>From your UCanAccess installation folder copy the following files into the<br \/>\nC:\\Minisoft\\eFORMz_6\\jars\\Local\\folder:<\/p>\n<p>ucanaccess-X.X.X.jar<br \/>\ncommons-lang-X.X.jar<br \/>\ncommons-logging-X.X.X.jar<br \/>\nhsqldb.jar<br \/>\njackcess-X.X.X.jar<\/p>\n<p>More information for Connection String Properties:<br \/>\nhttp:\/\/ucanaccess.sourceforge.net\/site.html#examples<\/p>\n<p>Download Link:<br \/>\nhttp:\/\/ucanaccess.sourceforge.net\/site.html#home<\/p>\n<h2>Maria DB<\/h2>\n<p>Driver Class:<br \/>\ncom.mysql.jdbc.Driver<\/p>\n<p>URL: jdbc:mysql:\/\/[host name or ip address]\/[database name]?user=[user<br \/>\nname]&amp;password=[user password]<\/p>\n<p>jdbc:mysql:\/\/localhost\/schema?user=admin&amp;password=Password<\/p>\n<h2>MySQL<\/h2>\n<p>Driver Class:<br \/>\ncom.mysql.jdbc.Driver<\/p>\n<p>URL:<br \/>\njdbc:mysql:\/\/[host name or ip address]\/[database name]?user=[user<br \/>\nname]&amp;password=[user password]<br \/>\njdbc:mysql:\/\/123.456.78.90\/eformz?user=eformz&amp;password=eformz<\/p>\n<p>When you reference the database URL in the web.xml file, you can exclude the user name and\u00a0password. For example:<\/p>\n<p>jdbc:mysql:\/\/123.456.78.90\/eformz<\/p>\n<p>For eFORMz to connect to your MySQL database, you must copy\u00a0your MySQL jdbc driver class into your eFORMz jar folder:<\/p>\n<p>Copy:<br \/>\n\\sqlDriver\\mysql-connector-java-xxxx\\mysql-connector-java-xxxxx-bin.jar<br \/>\nto the following directory:<br \/>\nC:\\Minisoft\\eFORMz_6\\jars\\Local<\/p>\n<h2>Oracle<\/h2>\n<p>Driver Class:<br \/>\noracle.jdbc.driver.OracleDriver<\/p>\n<p>URL:<br \/>\njdbc:oracle:thin:&lt;user&gt;\/&lt;password&gt;@&lt;DB server name or IP&gt;:1521\/&lt;dbname&gt;<\/p>\n<p><code>&lt;user&gt;<\/code> = user name for database<br \/>\n<code>&lt;password&gt;<\/code> = password for database<br \/>\n<code>&lt;DB server name or IP&gt;<\/code> = name or IP address of the database server<br \/>\n<code>&lt;dbname&gt;<\/code> = database name to use<\/p>\n<p>Example:<br \/>\njdbc:oracle:thin:@123.456.78.90:1521\/emaildb<\/p>\n<p>For eFORMz to connect to your Oracle database, you must copy\u00a0your oracle jdbc driver class into your eFORMz jar folder:<\/p>\n<p>Copy:<br \/>\n[Oracle_Home]\\jdbc\\lib\\classesXXX.zip<br \/>\nto the following directory:<br \/>\nC:\\Minisoft\\eFORMz_6\\jars\\Local<br \/>\nand then rename the classesXXX.zip to classesXXX.jar<\/p>\n<p>*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.<\/p>\n<h2>Oracle Cluster<\/h2>\n<p>JDBC URL for Oracle RAC ( Real Application Cluster )<\/p>\n<p>jdbc:oracle:thin:[user]\/[password]@(DESCRIPTION=(LOAD_BALANCE=on)<br \/>\n(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))<br \/>\n(ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))<br \/>\n(CONNECT_DATA=(SERVICE_NAME=service)))<\/p>\n<h2>Progress<\/h2>\n<p>Driver Class:<br \/>\ncom.ddtek.jdbc.openedge.OpenEdgeDriver<\/p>\n<p>URL:<br \/>\njdbc:datadirect:openedge:\/\/servername:10005;databaseName=c:\\progressdb\\<br \/>\nsportstest;user=username;password=password;defaultschema=pub<\/p>\n<p>JAR Files:<\/p>\n<p>From your <em>Progress<\/em> installation folder copy the following files into the C:\\Minisoft\\eFORMz_6\\jars\\Local\\ folder:<\/p>\n<p>base.jar<br \/>\nopenedge.jar<br \/>\nutil.jar<\/p>\n<h2>SQL Server<\/h2>\n<p>Driver Class:<br \/>\ncom.microsoft.sqlserver.jdbc.SQLServerDriver<\/p>\n<p>URL:<br \/>\njdbc:sqlserver:\/\/12.34.567.899:1433;databaseName=ECOMVER;<br \/>\nuser=minisoft;password=minisoft2007;selectMethod=cursor;<br \/>\nparametersAsUnicode=false<\/p>\n<p>You must specify the correct IP address, port (if different), database name, user, and password.<\/p>\n<p><strong>NOTE:\u00a0SQL Server users running on older version of Java will experience delays. Use Java 1.8 or above (sqljdbc41.jar needed) is recommended.<\/strong><\/p>\n<p><strong>ADDITIONAL NOTE: Microsoft has three flavors of JDBC jar file for SQL Server connections.<\/strong><\/p>\n<p><strong>https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/jdbc\/system-requirements-for-the-jdbc-driver?view=sql-server-ver15<\/strong><\/p>\n<p><strong>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).<\/strong><\/p>\n<h2>Sybase<\/h2>\n<p>Driver Class:<br \/>\ncom.sybase.jdbc3.jdbc.SybDriver<\/p>\n<p>URL:<br \/>\njdbc:sybase:Tds:localhost:2638<\/p>\n<p>Parameters:<br \/>\nSERVICENAME=demo<br \/>\nHOSTNAME=localhost<br \/>\nuser=DBA<br \/>\npassword=sql<br \/>\nSTREAM_CACHE_SIZE=10000<br \/>\nLITERAL_PARAMS=false<br \/>\nCURSOR_ROWS=0<br \/>\nSESSION_TIMEOUT=300<br \/>\nJCONNECT_VERSION=6<br \/>\nCANCEL_ALL=true<br \/>\nDYNAMIC_PREPARE=true<br \/>\nLANGUAGE_CURSOR=false<br \/>\nSEND_LONG_PARAMS_REGARDLESS_OF_CAPABILITIES=false<br \/>\nIGNORE_DONE_IN_PROC=false<br \/>\nREQUEST_HA_SESSION=false<br \/>\nELIMINATE_010SM=true<br \/>\nGET_BY_NAME_USES_COLUMN_LABEL=false<br \/>\nESCAPE_PROCESSING_DEFAULT=false<\/p>\n<p>JAR File:<br \/>\nPlace the Sybase jar file into the C:\\Minisoft\\eFORMz_6\\Local\\ folder:<br \/>\njconn3.jar<\/p>\n<p>TAGS: Connection string; driver class<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Example of configuring a database in eFORMz Troubleshooting information is at\u00a0https:\/\/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\/&lt;databasename&gt;;naming=sql;prompt=false;libraries=*LIBL,QTEMP,OTHERLIB;user=&lt;username&gt;;password=&lt;password&gt; \u2022 HostNameOrIP = the host or IP where DB2 is running, e.g. server23 [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[84,100],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/3088"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=3088"}],"version-history":[{"count":30,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/3088\/revisions"}],"predecessor-version":[{"id":9261,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/3088\/revisions\/9261"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=3088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=3088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=3088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}