0
If you need to access a database with Java, you need a driver. This is a list of the drivers available, what database they can access, who makes it, and how to contact them.
IBM DB2
jdbc:db2://<HOST>:<PORT>/<DB>
COM.ibm.db2.jdbc.app.DB2Driver
JDBC-ODBC Bridge
jdbc:odbc:<DB>
sun.jdbc.odbc.JdbcOdbcDriver
Microsoft SQL Server
jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT>
weblogic.jdbc.mssqlserver4.Driver
Oracle Thin
jdbc:oracle:thin:@<HOST>:<PORT>:<SID>
oracle.jdbc.driver.OracleDriver
PointBase Embedded Server
jdbc:pointbase://embedded[:<PORT>]/<DB>
com.pointbase.jdbc.jdbcUniversalDriver
Cloudscape
jdbc:cloudscape:<DB>
COM.cloudscape.core.JDBCDriver
Cloudscape RMI
jdbc:rmi://<HOST>:<PORT>/jdbc:cloudscape:<DB>
RmiJdbc.RJDriver
Firebird (JCA/JDBC Driver)
jdbc:firebirdsql:[//<HOST>[:<PORT>]/]<DB>
org.firebirdsql.jdbc.FBDriver
IDS Server
jdbc:ids://<HOST>:<PORT>/conn?dsn='<ODBC_DSN_NAME>'
ids.sql.IDSDriver
Informix Dynamic Server
jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME>
com.informix.jdbc.IfxDriver
InstantDB (v3.13 and earlier)
jdbc:idb:<DB>
jdbc.idbDriver
InstantDB (v3.14 and later)
jdbc:idb:<DB>
org.enhydra.instantdb.jdbc.idbDriver
Interbase (InterClient Driver)
jdbc:interbase://<HOST>/<DB>
interbase.interclient.Driver
Hypersonic SQL (v1.2 and earlier)
jdbc:HypersonicSQL:<DB>
hSql.hDriver
Hypersonic SQL (v1.3 and later)
jdbc:HypersonicSQL:<DB>
org.hsql.jdbcDriver
Microsoft SQL Server (JTurbo Driver)
jdbc:JTurbo://<HOST>:<PORT>/<DB>
com.ashna.jturbo.driver.Driver
Microsoft SQL Server (Sprinta Driver)
jdbc:inetdae:<HOST>:<PORT>?database=<DB>
com.inet.tds.TdsDriver
Microsoft SQL Server 2000 (Microsoft Driver)
jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>]
com.microsoft.sqlserver.jdbc.SQLServerDriver
MySQL (MM.MySQL Driver)
jdbc:mysql://<HOST>:<PORT>/<DB>
org.gjt.mm.mysql.Driver
Oracle OCI 8i
jdbc:oracle:oci8:@<SID>
oracle.jdbc.driver.OracleDriver
Oracle OCI 9i
jdbc:oracle:oci:@<SID>
oracle.jdbc.driver.OracleDriver
PostgreSQL (v6.5 and earlier)
jdbc:postgresql://<HOST>:<PORT>/<DB>
postgresql.Driver
PostgreSQL (v7.0 and later)
jdbc:postgresql://<HOST>:<PORT>/<DB>
org.postgresql.Driver
Sybase (jConnect 4.2 and earlier)
jdbc:sybase:Tds:<HOST>:<PORT>
com.sybase.jdbc.SybDriver
Sybase (jConnect 5.2)
jdbc:sybase:Tds:<HOST>:<PORT>
com.sybase.jdbc2.jdbc.SybDriver
To test your driver once it's installed, try the following code: { Class.forName("Driver name"); Connection con = DriverManager.getConnenction("jdbcurl","username","password"); //other manipulation using jdbc commands } catch(Exception e) { }
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
List four JDBC drivers?
JDBC ODBC BridgeNative API Partly Java DriverNet Protocol full Java driverare some types of jdbc drivers
Driver name for Microsoft sql server jdbc driver?
There are more than one JDBC drivers for Microsoft SQL Server. Each one has a different driver name.
What is type 4 jdbc driver?
JDBC is short for java database connectivity. There are 4 type of JDBC drivers : 1) JDBC-ODBC 2) Native-API 3) JDBC-Net 4) Native-Protocol.
Which types of JDBC drivers allows your java programs to communicate with the ODBC driver of your dbms?
JDBC - ODBC bridge
What do you understand by JDBC driver in java?
JDBC driver is an interface enabling a java application to interact with a database. To connect with individual database, JDBC requires drivers for each database.
JDBC drivers and driver maneger?
JDBC Driver Manager is a class that manages a list of database drivers. It matches connection requests from the java application with the proper database driver using communication sub protocol.
How java and database is communicated?
Actually coming to this one, we need to discuss about those companies which are invented the java(Sun Micro System) and database(Oracle), in olden days these companies were tie up that time, so that's why we are accessing the database with application program written in java. now coming to our topic, We need to select the suitable drivers to our application(Desktop or Web Application) load the drivers through application. Those drivers are JDBC drivers, JDBC is nothing but pool of drivers in which some drivers are default in Windows OS, when ever we create the DATABASE Application like ORACLE, then automatically drivers are also included in JDBC.
Describe about JDBC architectural overview?
General JDBC Architecture consist of two layers: JDBC API - this provides the application to JDBC manager connection. JDBC driver API - this supports the JDBC manager to driver connection.
What do you do in order to ensure that the JDBC driver for PostgreSQL is available to the DriverManager?
Call java.sql.DriverManager.loadDriver("postgresql");.
I installed Oracle 8.0.3.0 in XP here my doubt is Whether Oracle 8.0.3.0 supports JDBC?
I'm not sure that JDBC is supported for that Version of Oracle. I would recomend installing at least ORACLE 8.1.7 , referrably Oracle 9iR2 Check the following for JDBC drivers for 8.1.7 http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc817.html
Is it possible while developing any software by using java can you manage database?
Yes. In Java this is done through the JDBC classes.Yes. In Java this is done through the JDBC classes.Yes. In Java this is done through the JDBC classes.Yes. In Java this is done through the JDBC classes.
Does jdbc come along with j2ee?
JDBC comes as part of the standard JDK & JRE set up.
