DataBase Driver and URL Configurations

Since TomEE does not have any UI, all the data sources should be created manually in tomee.xml file in conf directory. Below are the parameters and their corresponding values for different databases.

Oracle

jdbcDriver = oracle.jdbc.driver.OracleDriver

jdbcUrl = jdbc:oracle:thin:@<host>:<port>:<sid>

DB2

jdbcDriver = com.ibm.db2.jcc.DB2Driver

jdbcUrl = jdbc:db2://<host>:<port>/<databasename>:currentSchema=<schemaname>;

SQLServer

jdbcDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbcUrl = jdbc:sqlserver://<host>:<port>;DatabaseName=<databasename>