The user configuration is stored in the database.
By default, the data is stored in a Java in-memory HSQL database, supplied as standard.
<userConfiguration driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:file:C:/CloudVFS/wagonSettings;shutdown=true"/ >
Using another DBMS
Using another DBMS requires an ad hoc JDBC driver and the following information to be specified:
<userConfiguration driverClassName="..." url="..." username="..." password="..." tableName="..."/> |
Attribute |
Value |
Notes |
driverClassName |
Name of driver class. |
Required. |
url |
DBMS connection URL. |
Required, can be encoded in RSA. |
username |
Connection profile. |
Optional, can be encoded in RSA. |
password |
Password. |
Optional, can be encoded in RSA. |
tableName |
Information storage table. |
Optional. If no name is specified, the data is stored in the USER_PARAMS table. |
Oracle
To use an Oracle DBMS, oracle ojdbc6.jar drivers need to be retrieved and made available to the application server.
Example:
For Tomcat, put the files in the TOMCAT_HOME/lib directory.
<userConfiguration driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@hostname:1521:SID" username="MyUser" password="MyPwd" tableName="MyTable"/> |
SQL Server
To use a SQL Server DBMS, the java jtds-1.2.5.jar http://jtds.sourceforge.net/ driver needs to be retrieved and made available to the application server.
<userConfiguration driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://hostname/MyBd" username="MyUser" password="MyPwd" tableName="MyTable"/> |
iSeries
To use an iSeries DBMS, the java jt400.jar http://jt400.sourceforge.net/ driver needs to be retrieved and made available to the application server.
<userConfiguration driverClassName="com.ibm.as400.access.AS400JDBCDriver" url="jdbc:as400://hostname/library" username="MyUser" password="MyPwd" tableName="MyTable"/> |
DB2 UDB
To use a DB2 UDB DBMS, the java db2jcc.jar and db2jcc_license_cu.jar driver needs to be retrieved and made available to the application server.
<userConfiguration driverClassName="com.ibm.db2.jcc.DB2Driver" url="jdbc:db2://hostname:50000/myBd" username="MyUser" password="MyPwd" tableName="MyTable"/> |