sql server2005 or 2008:
- ds.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
- ds.jdbcUrl=jdbc:sqlserver://localhost:1433;databaseName=
- ds.username=
- ds.password=
mysql:
- data source
- ds.driverClass=com.mysql.jdbc.Driver
- ds.jdbcUrl=jdbc:mysql://192.168.137.1:3306/n
- ds.username=root
- ds.password=
sybase:
- ds.driverClass=com.sybase.jdbc3.jdbc.SybDriver
- ds.jdbcUrl=jdbc:sybase:Tds:10.6.1.1:4200/m?CharSet=cp936
- ds.username=m
- ds.password=1
db2:
- ds.driverClass=com.ibm.db2.jcc.DB2Driver 或<span style="font-family: Verdana, Arial, Helvetica, sans-serif;font-size:12px; line-height: 23px;">COM.ibm.db2.jdbc.net.DB2Driver或<span style="font-family: Verdana, Arial, Helvetica, sans-serif;font-size:12px; line-height: 23px;">COM.ibm.db2.jdbc.app.DB2Driver</span></span>
- ds.url=jdbc:db2://127.0.0.1:50000/f
- ds.username=w
- ds.password=123456
oracle:
- ds.driverClass=oracle.jdbc.driver.OracleDriver
- ds.jdbcUrl=jdbc:oracle:thin:@192.168.172.80:1521:admin
- ds.username=user
- ds.password=pass
PostgreSQL:
- ds.driverClass=org.postgresql.Driver
- ds.jdbcUrl=jdbc:postgresql://localhost:5432/db_name
- ds.username=user
- ds.password=pass
用过的就这么几个了,写出来以备后用。