jdbcdrivers.xml
jdbcdrivers.xml:
<JDBC-Drivers> <Driver> <DriverName>IBM Type 2 Driver for DB2 7.x/8.x</DriverName> <ClassName>COM.ibm.db2.jdbc.app.DB2Driver</ClassName> <URL>jdbc:db2:[dbname]</URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM SYSIBM.SYSTABLES</TestSql> </Driver> <Driver> <DriverName>IBM Type 2 XA Driver for DB2 7.x/8.x</DriverName> <ClassName>COM.ibm.db2.jdbc.DB2XADataSource</ClassName> <URL>jdbc:db2:[dbname]</URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM SYSIBM.SYSTABLES</TestSql> </Driver> <Driver> <DriverName>IBM Type 4 Driver for DB2 7.x/8.x</DriverName> <ClassName>COM.ibm.db2.jdbc.net.DB2Driver</ClassName> <URL>jdbc:db2://[host]:6789/[dbName]</URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM SYSIBM.SYSTABLES</TestSql> </Driver> <Driver> <DriverName>IBM Type 4 Driver for Informix</DriverName> <ClassName>com.informix.jdbc.IfxDriver</ClassName> <URL>jdbc:informix-sqli://[host]:[1526]/[dbName]:informixserver=[myserver];user=[username];password=[password] </URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM SYSTABLES</TestSql> </Driver> <Driver> <DriverName>IBM Type 4 XA Driver for Informix</DriverName> <ClassName>com.informix.jdbcx.IfxXADataSource</ClassName> <URL>jdbc:informix-sqli://[host]:[1526]/[dbName]:informixserver=[myserver];user=[username];password=[password] </URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM SYSTABLES</TestSql> </Driver> <Driver> <DriverName>Derby Client Driver</DriverName> <ClassName>org.apache.derby.jdbc.ClientDriver</ClassName> <URL>jdbc:derby://[host]:[port]/[database]</URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM SYS.SYSTABLES</TestSql> </Driver> <Driver> <DriverName>Microsoft Type 4 XA Driver for MS SQL Server 2000 </DriverName> <ClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</ClassName> <URL>jdbc:microsoft:sqlserver://[host]:[1433];DatabaseName=[dbName] </URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM sysobjects</TestSql> </Driver> <Driver> <DriverName>Microsoft Driver for MS SQL Server 2005+</DriverName> <ClassName>com.microsoft.jdbc.sqlserver.SQLServerDriver</ClassName> <URL>jdbc:sqlserver://[host]:[1433];DatabaseName=[dbName]</URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM sysobjects</TestSql> </Driver> <Driver> <DriverName>MySQL Connector/J Type 4 Driver for MySQL</DriverName> <ClassName>com.mysql.jdbc.Driver</ClassName> <URL>jdbc:mysql://[host]:[3306]/[dbName]?user=test</URL> <level>system</level> <TestSql>SELECT 1</TestSql> </Driver> <Driver> <DriverName>MM.MySQL Type 4 Driver for MySQL</DriverName> <ClassName>org.gjt.mm.mysql.Driver</ClassName> <URL>jdbc:mysql://[host]:[3306]/[dbName]?user=test</URL> <level>system</level> <TestSql>SELECT 1</TestSql> </Driver> <Driver> <DriverName>Oracle Type 4 Driver for Oracle 8.1.7,9.0.1,9.2.0 </DriverName> <ClassName>oracle.jdbc.driver.OracleDriver</ClassName> <URL>jdbc:oracle:thin:@[host]:[1521]:[dbName]</URL> <level>system</level> <TestSql>SELECT 1 from DUAL</TestSql> </Driver> <Driver> <DriverName>Oracle Type 4 XA Driver for Oracle 8.1.7,9.0.1,9.2.0 </DriverName> <ClassName>oracle.jdbc.xa.client.OracleXADataSource</ClassName> <URL>jdbc:oracle:thin:@[host]:[1521]:[dbName]</URL> <level>system</level> <TestSql>SELECT 1 from DUAL</TestSql> </Driver> <Driver> <DriverName>Oracle OCI Driver for Oracle 8.1.7,9.0.1,9.2.0 </DriverName> <ClassName>oracle.jdbc.driver.OracleDriver</ClassName> <URL>jdbc:oracle:oci8:@[dbName]</URL> <level>system</level> <TestSql>SELECT 1 from DUAL</TestSql> </Driver> <Driver> <DriverName>Oracle OCI XA Driver for Oracle 8.1.7,9.0.1,9.2.0 </DriverName> <ClassName>oracle.jdbc.xa.client.OracleXADataSource</ClassName> <URL>jdbc:oracle:oci8:@[dbName]</URL> <level>system</level> <TestSql>SELECT 1 from DUAL</TestSql> </Driver> <Driver> <DriverName>TongTech Driver Wrapper for Oracle </DriverName> <ClassName>com.tongweb.jdbc.OracleDriverWrapper</ClassName> <URL>jdbc:oracle:thin:@[host]:[1521]:[dbName]</URL> <level>system</level> <TestSql>SELECT * from duel</TestSql> </Driver> <Driver> <DriverName>postgreSQL type 4 Driver for postgreSq</DriverName> <ClassName>org.postgresql.Driver</ClassName> <URL>jdbc:postgresql://[host]:[5432]/[dbName]</URL> <level>system</level> <TestSql>SELECT 1</TestSql> </Driver> <Driver> <DriverName>Sybase type 4 Driver for Sybase 11.x</DriverName> <ClassName>com.sybase.jdbc.SybDriver</ClassName> <URL>jdbc:sybase:Tds:[host]:[2048]/[dbName]</URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM sysobjects</TestSql> </Driver> <Driver> <DriverName>Sybase type 4 XA Driver for Sybase 12.x</DriverName> <ClassName>com.sybase.jdbc2.jdbc.SybXADataSource</ClassName> <URL>jdbc:sybase:Tds:[host]:[2048]/[dbName]?charset=eucgb</URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM sysobjects</TestSql> </Driver> <Driver> <DriverName>HSQL JDBC Driver</DriverName> <ClassName>org.hsqldb.jdbcDriver</ClassName> <URL>jdbc:hsqldb:hsql://[host]:[9001]/default</URL> <level>system</level> <TestSql>SELECT 1</TestSql> </Driver> <Driver> <DriverName>Sybase15 JDBC Driver</DriverName> <ClassName>com.sybase.jdbc3.jdbc.SybDriver</ClassName> <URL>jdbc:sybase:Tds:[host]:[5000]/[dbName]</URL> <level>system</level> <TestSql>SELECT COUNT(*) FROM sysobjects</TestSql> </Driver> <Driver> <DriverName>Kingbase JDBC Driver</DriverName> <ClassName>com.kingbase.Driver</ClassName> <URL>jdbc:kingbase://[host]:[54321]/[dbName]</URL> <level>system</level> <TestSql>SELECT 1</TestSql> </Driver> <Driver> <DriverName>dameng JDBC Driver</DriverName> <ClassName>dm.jdbc.driver.DmDriver</ClassName> <URL>jdbc:dm://127.0.0.1:12345/TEST</URL> <level>system</level> <TestSql>SELECT 1</TestSql> </Driver> </JDBC-Drivers>