자바를 사용해서 연결할 수 있는 다양한 데이터베이스의 JDBC 드라이버 설정 내용입니다.
DB2
Vendor Site | http://www.ibm.com/db2/![]() |
Driver Name | com.ibm.db2.jcc.DB2Driver |
Sample URL | jdbc:db2://127.0.0.1:50000/dbname |
Derby
(since Cayenne 1.2)
Vendor Site | http://db.apache.org/derby/![]() |
Embedded | |
---|---|
Driver Name | org.apache.derby.jdbc.EmbeddedDriver |
Sample URL | jdbc:derby:path-to-hsql-db-files;create=true |
Remote Server | |
Driver Name | org.apache.derby.jdbc.ClientDriver |
Sample URL | jdbc:derby://127.0.0.1/testdb |
FireBird (Interbase)
Vendor Site | http://www.firebirdsql.org/![]() |
Driver Name | org.firebirdsql.jdbc.FBDriver |
Sample URL | jdbc:firebirdsql:127.0.0.1/10007:/path-to-dbname.fdb |
Notes | FirebirdAdapter hasn’t been well-tested for some time. Looking for volunteer FireBird users to help us. |
FrontBase
(since Cayenne 1.2)
Vendor Site | http://www.frontbase.com/![]() |
Driver Name | jdbc.FrontBase.FBJDriver |
Sample URL | jdbc:FrontBase://127.0.0.1/dbname |
HSQLDB
Vendor Site | http://hsqldb.org/![]() |
Driver Name | org.hsqldb.jdbcDriver |
Embedded | |
---|---|
Sample URL | jdbc:hsqldb:file:/path-to-hsql-db-files![]() |
Remote Server | |
Sample URL | jdbc:hsqldb:hsql://127.0.0.1 |
MySQL
Vendor Site | http://www.mysql.com/![]() |
Driver Name | com.mysql.jdbc.Driver |
Sample URL | jdbc:mysql://127.0.0.1/dbname |
OpenBase
Vendor Site | http://www.openbase.com/![]() |
Driver Name | com.openbase.jdbc.ObDriver |
Sample URL | jdbc:openbase://127.0.0.1/dbname |
Oracle (10i)
Vendor Site | http://oracle.com/![]() |
Driver Name | oracle.jdbc.driver.OracleDriver |
Sample URL | jdbc:oracle:thin:@//127.0.0.1:1521/dbname |
Oracle (8, 8i, 9i)
Vendor Site | http://oracle.com/![]() |
Driver Name | oracle.jdbc.driver.OracleDriver |
Sample URL | jdbc:oracle:thin:@127.0.0.1:1521:dbname |
PostgreSQL (7.4, 8.*)
Vendor Site | http://www.postgresql.org/![]() |
Driver Name | org.postgresql.Driver |
Sample URL | jdbc:postgresql://127.0.0.1:5432/dbname |
SQLServer
Microsoft Driver – SQL Server 2005 | |
---|---|
Vendor Site | http://www.microsoft.com/sql/default.asp![]() |
Driver Name | com.microsoft.sqlserver.jdbc.SQLServerDriver |
Sample URL | jdbc:sqlserver://127.0.0.1;databaseName=dbname |
Microsoft Driver – SQL Server prior to 2005 | |
Vendor Site | http://www.microsoft.com/sql/default.asp![]() |
Driver Name | com.microsoft.jdbc.sqlserver.SQLServerDriver |
Sample URL | jdbc:microsoft:sqlserver://127.0.0.1;databaseName=dbname;SelectMethod=cursor |
jTDS Driver | |
Vendor Site | http://jtds.sourceforge.net/![]() |
Driver Name | net.sourceforge.jtds.jdbc.Driver |
Sample URL | jdbc:jtds:sqlserver://127.0.0.1:5000/dbname |
Sybase
Sybase Driver | |
---|---|
Vendor Site | http://www.sybase.com/![]() |
Driver Name | com.sybase.jdbc3.jdbc.SybDriver |
Sample URL | jdbc:sybase:Tds:127.0.0.1:5000/dbname |
jTDS Driver | |
Vendor Site | http://jtds.sourceforge.net/![]() |
Driver Name | net.sourceforge.jtds.jdbc.Driver |
Sample URL | jdbc:jtds:sybase://127.0.0.1:5000/dbname;useLOBs=false;TDS=4.2 |
* Reference
– https://cayenne.apache.org/docs/3.0/database-support.html
Mssql, Sybase 등에서는 jtds가 좋을 듯 하네요.. ^^