Help Center

Burgeonsoft | Contact Us | Chinese

Configure JDBC Connection

 

After you created database schema and user, you should configure JDBC connection to allow DocCare to connect to your database.
If you plan to use other database servers, such as Oracle or MS SQL Server, please contact usContact Burgeonsoft.


HSQLDB

DocCare installation package contains an embedded HSQLDB 1.8 Java database server and JDBC driver.
Edit ${BURGEON_HOME}/conf/database.properties and setup the parameters correctly.
The following example shows a JDBC configuration. It allows DocCare to connect HSQLDB in an exclusive way.

############################
# HSQLDB setup
# The JDBC driver is packaged with DocCare
###########################
 DB_TYPE=HSQLDB
DB_DRIVER=org.hsqldb.jdbcDriver
#DB_URL=jdbc:hsqldb:hsql://localhost/doccare2
DB_URL=jdbc:hsqldb:file:///${BURGEON_HOME}/data/hsqldb/doccare2
USERNAME=sa
PASSWORD=

MySQL 5

DocCare does not contains MySQL database driver.
You can download MySQL driver for JAVA from http://dev.mysql.com/downloads/mysql/5.1.html, and copy the .jar file to ${BURGEON_HOME}/common/lib目录下。
Edit ${BURGEON_HOME}/conf/database.properties and setup the parameters correctly.
The following example shows a JDBC configuration. It allows DocCare to connect MySQL database service.

############################
# MySQL setup
# You can download the driver from the URL below.
# For MySQL 5.1,
# http://dev.mysql.com/downloads/connector/j/5.1.html
# For MySQL 5.0,
# http://dev.mysql.com/downloads/connector/j/5.0.html
###########################
 DB_TYPE=MySQL
DB_DRIVER=com.mysql.jdbc.Driver
DB_URL=jdbc:mysql://localhost:3306/doccare?characterEncoding=utf-8
USERNAME=dcuser
PASSWORD=dcpwd

MS SQL Server 2000/2005/2008

DocCare installation package does not contains MS SQL Server 2000/2005/2008 database driver.
You can download a third party driver from http://jtds.sourceforge.net/and copy the .jar to ${BURGEON_HOME}/common/lib.
Edit ${BURGEON_HOME}/conf/database.properties and setup the parameters correctly.
See the example below:

############################
# MS SQL Server setup
# You can download the driver from the URL below:
# jTDS,
# http://jtds.sourceforge.net/
###########################
 DB_TYPE=MSSQL
DB_DRIVER=net.sourceforge.jtds.jdbc.Driver
DB_URL=jdbc:jtds:sqlserver://localhost:1433/doccare
USERNAME=dcuser
PASSWORD=dcpwd

Note: you should restart DocCare after change the JDBC configuration.