List dirvers and connection-urls for connecting java program to databases

DB2
Driver : "com.ibm.db2.jcc.DB2Driver"
URL: "jdbc:db2://localhost:5021/database","user","password"


Apache Derby
driver: "org.apache.derby.jdbc.EmbeddedDriver"
URL: "jdbc:derby://localhost/databasename","user","password"
FrontBase
Driver : "jdbc.frontbase.FBDriver"
URL : "jdbc:frontbase:/DerbyDB/AssetDB","user","password"
OpenBase
Driver : "com.openbase.jdbc.ObDriver"
URL : "jdbc:openbase://localhost/databasename","user","password"
MySQL
Driver : "com.mysql.jdbc.Driver"
URL: "jdbc:mysql://localhost:3306/databasename","user","password"
H2Database
Driver : "org.h2.Driver"
URL: "jdbc:h2:tcp://localhost//data/databasename","user","password"
More info. 
PostgreSQL
Driver : "org.postgresql.Driver"
URL: "jdbc:postgresql://localhost/databasename","user","password"
More info. 
Cache
Driver : "com.intersys.jdbc.CacheDriver"
URL: "jdbc:Cache://localhost/databasename","user","password"
More info. 


Cubrid
Driver : cubrid.jdbc.driver.CUBRIDDriver"
URL: jdbc:CUBRID:127.0.0.1:30000:demodb:dba::","user","password"
More info. 
Oracle 10g
Driver : "oracle.jdbc.OracleDriver"
URL: "jdbc:oracle:thin:@localhost:1521:databasename","user","password"
More info 
Sybase
Driver : "com.sybase.jdbc4.jdbc.SybDriver"
URL: "jdbc:sybase:Tds:localhost:5000/databasename","user","password"
More info  
SQLite
Driver : "org.sqlite.JDBC"
URL: "jdbc:sqlite:db_file_path","user","password"
More info  
Microsoft SQL Server
Driver : "com.microsoft.jdbc.sqlserver.SQLServerDriver"
URL: "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=databasename","user","password"
More info , Read More
SAP MaxDB
Driver : "com.sap.dbtech.jdbc.DriverSapDB"
URL: "jdbc:sapdb://localhost:3306/databasename","user","password"
More info
Informix
Driver : "com.informix.jdbc.IfxDriver"
URL: "jdbc:informix-sqli://localhost:3306/databasename","user","password"
HypersonicSQL
Driver : "org.hsqldb.jdbcDriver"
URL: "jdbc:hsqldb:directoryname/filename","user","password"
Ingres
Driver : "com.ingres.jdbc.IngresDriver"
URL: "jdbc:ingres://localhost:117/databasename","user","password"
MonetDB
Driver : "nl.cwi.monetdb.jdbc.MonetDriver"
URL: "jdbc:monetdb://localhost/database", "monetdb", "monetdb"
More info 
SmallSQL
Driver : "smallsql.database.SSDrive"
URL: "jdbc:smallsql:db1","user","password"
FireBird
Driver : "org.firebirdsql.jdbc.FBDriver"
URL: "jdbc:firebirdsql://localhost:10007/dbname.fdb","user","password"
Pointbase
Driver : "com.pointbase.jdbc.jdbcUniversalDriver"
URL: ""jdbc:pointbase:server://localhost/databasename","user","password"
FrontBase
Driver : "jdbc.FrontBase.FBJDriver"
URL: "jdbc:FrontBase://localhost/databasename","user","password"

No comments:

Popular Posts