Leave your feedback here
Der Inhalt ist noch nicht in Ihre Sprache übersetzt worden. Hier ist die englische Version.
Configure the database connection information ON THIS PAGE
Available in... Data Fabric Data Services Platform ESB MDM Platform Real-Time Big Data Platform
Procedure
Open the <TomcatPath>/conf/context.xml
file and add the following lines, according to your database server:
For H2:
< Resourcename = " jdbc/datasource" auth = " Container" type = " javax.sql.DataSource" username = " sa" password = " " driverClassName = " org.h2.Driver" url = " jdbc:h2:tcp://localhost/~/test" maxActive = " 8" maxIdle = " 30" maxWait = " 10000" /> Copy code to clipboard
For Derby:
< Resourcename = " jdbc/datasource" auth = " Container" type = " javax.sql.DataSource" username = " test" password = " test" driverClassName = " org.apache.derby.jdbc.ClientDriver" url = " jdbc:derby://localhost:1527/db;create= true" maxActive = " 8" maxIdle = " 30" maxWait = " 10000" /> Copy code to clipboard
For MySql:
< Resourcename = " jdbc/datasource" auth = " Container" type = " javax.sql.DataSource" username = " test" password = " test" driverClassName = " com.mysql.jdbc.Driver" url = " jdbc:mysql://localhost:3306/test" maxActive = " 8" maxIdle = " 30" maxWait = " 10000" /> Copy code to clipboard
For DB2:
< Resourcename = " jdbc/datasource" auth = " Container" type = " javax.sql.DataSource" username = " db2admin" password = " qwaszx" driverClassName = " com.ibm.db2.jcc.DB2Driver" url = " jdbc:db2://localhost:50000/TEST" maxActive = " 8" maxIdle = " 30" maxWait = " 10000" /> Copy code to clipboard
For SQLServer:
< Resourcename = " jdbc/datasource" auth = " Container" type = " javax.sql.DataSource" username = " test" password = " test" driverClassName = " com.microsoft.sqlserver.jdbc.SQLServerDriver" url = " jdbc:sqlserver://localhost:1029;instanceName= sqlexpress;databaseName= Test" maxActive = " 8" maxIdle = " 30" maxWait = " 10000" /> Copy code to clipboard
For Oracle:
< Resourcename = " jdbc/datasource" auth = " Container" type = " javax.sql.DataSource" username = " xxx" password = " xxx" driverClassName = " oracle.jdbc.pool.OracleDataSource" url = " jdbc:oracle:thin:@localhost:1521:XE" maxActive = " 8" maxIdle = " 30" maxWait = " 10000" /> Copy code to clipboard
Check the database connection information specified in the
following file, and edit them if needed:
<TomcatPath>/webapps/sam-server-war/WEB-INF/logserver.properties
