Common JDBC driver name and URL list

2011-05-06  来源:本站原创  分类:Database  人气:128 

Popular JDBC driver name, and  URL  List  

ODBC  driver
sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:name 

 COM.ibm.db2.jdbc.net.DB2Driver connect  DB2  Database
 A DB2 URL example :
jdbc:db2://aServer.myCompany.com:50002/name 

 Com.sybase.jdbc.SybDriver connect  Sybase  Database
 A Sybase URL example :
jdbc:sybase:Tds:aServer.myCompany.com:2025 

MySQL driver
com.mysql.jdbc.Driver
jdbc:mysql://hostname:3306/dbname?useUnicode=true&characterEncoding=GBK 

Microsoft SQL Server Driver
com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=WapSvc;User=sa;Password=pwd 

Informix
com.informix.jdbc.IfxDriver
jdbc:informix-sqli://hostname:1526/dbname:INFORMIXSERVER=informixservername;user=username;password=password 

Oracle
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@hostname:1521:<SID> 

Postgresql
org.postgresql.Driver
jdbc:postgresql://localhost/soft 

Apache Derby/Java DB
org.apache.derby.jdbc.ClientDriver
jdbc:derby://localhost:1527/databaseName;create=true 

Access  Is through an ODBC connection . Excel  You can also. You can even dynamically construct the connection string : 

 This can directly connect to the Access database file . 

jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\mydata.mdb 

 Similar Excel file or you can use similar methods : 

jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=.\mydata.xls
相关文章
  • Common JDBC driver name and URL list 2011-05-06

    Popular JDBC driver name, and URL List ODBC driver sun.jdbc.odbc.JdbcOdbcDriver jdbc:odbc:name COM.ibm.db2.jdbc.net.DB2Driver connect DB2 Database A DB2 URL example : jdbc:db2://aServer.myCompany.com:50002/name Com.sybase.jdbc.SybDriver connect Sybas

  • DB2 JDBC driver and connection URL Summary 2011-08-23

    According to the JDBC specification, there are four types of JDBC driver architectures: Type 1: JDBC API such as a driver to another data access API mapping to achieve, such as Open Database Connectivity (Open Database Connectivity, ODBC). Such drive

  • [Reprinted] Subject: MySql the JDBC driver does not support batch operations (update) 2010-09-25

    Subject: MySql the JDBC driver does not support batch operations (update) srdrm response is very good:) While the use mysql Not too many companies have been using mssql. Landlord of the test results very disappointing ... But mysql reputation so grea

  • Analyze the details of the Oracle JDBC driver 2010-09-09

    Oracle database connection oracle JDBC driver all the details. These details include: 1, import JDBC package 2, registered oracle JDBC drivers 3, open the database connection 4, execute SQL DML statements in a database table to get, add, modify, and

  • [Reserved] Topic: MySql JDBC driver does not support bulk operations (update) 2010-09-25

    Topic: MySql JDBC driver does not support bulk operations (update) srdrm response is very good:) mysql Although used much, the company has been using the mssql. Landlord of the test results very disappointing ... However, such a great reputation mysq

  • jdbc driver 4 and the common types of jdbc connection string 2009-11-19

    1: jdbc driver 4 types Type1: through the use of JDBC-odbc bridge to connect oracle, poor portability Type2: oracle oci: relatively poor portability, it is necessary to depend on the oracle of the oci (client) installation But can be more efficient.

  • Cannot create JDBC driver of class''for connect URL 'null' 2010-03-29

    Record a configuration point! Tomcat 5.5.27 environment, configure a connection pool: <Resource name="openEAP_DS" type="javax.sql.DataSource" driverClassName="com.sybase.jdbc3.jdbc.SybDriver" url="jdbc:sybase:Tds:172.

  • Download a variety of databases and JDBC driver connection URL string written summary 2011-03-06

    Download a variety of databases and JDBC driver connection URL string writing Download a variety of databases and JDBC driver connection URL string writing sun on the official website of the JDBC driver list: http://java.sun.com/products/jdbc/referen

  • JDBC driver 2009-11-13

    1. Drive based on: What is the driver? It is the operating system and hardware interfaces, operating system, through its identification of the hardware, operating system hardware in accordance with instructions given by the specific operation. Each t

  • MyEclipse 8.0 M1 in the SQL Server JDBC Driver Configuration 2010-06-30

    First, download the driver. 1. Download http://download.microsoft.com, search for Microsoft SQL Server JDBC Driver 3.0, and download, download the file named sqljdbc_3.0.1301.101_chs.exe (after version 1.1 support sql2005, 2.0 support for sql2008 ).

  • Using the JDBC driver 2010-10-16

    Other versions of SQL Server 2008 R2 SQL Server 2008SQL Server 2005 This section provides use of Microsoft SQL Server JDBC Driver SQL Server databases with a simple connection of the quick start guide. Connecting to SQL Server database, you must firs

  • Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' 2008-05-14

    Tomcat6.0 used to configure the database connection pool The lack of msbase.jar, mssqlserver.jar, msutil.jar And, in tomcat's lib files on the next to join And WebRoot \ WEB-INF \ lib files on the next to join dbcp connection pooling package to be in

  • SQL Server JDBC Driver configuration 2008-10-03

    SQL Server JDBC Driver configuration keywords: sql server jdbc driver configuration method a and download drivers. Download: http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/sqljdbc_1.2.2323.101_enu.exe First, downloa

  • Maven can not find the oracle jdbc driver, Whose Fault? 2010-03-17

    Maven can not find the oracle jdbc driver, Whose Fault? Source: http://stackoverflow.com/questions/1074869/find-jdbc-driver-in-maven-repository Q: I want to add the oracle jdbc driver to my project as dependency (runtime scope) - ojdbc14. In MVNrepos

  • jtds drive instead of jdbc driver 2010-04-14

    As jdbc in the bug (return to text type data, such as length 0) the program will error. Exception is as follows: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Underlying input stream returned zero bytes Microsoft error recognition

  • Various JDBC driver and use the current version of the syntax ver.20080708 2010-06-22

    There are many version of Friends of the JDBC driver to find or how to use the driver frequently ask questions In here I simply sort out the driver with more typical usage. Microsoft SQL Server series (6.5, 7.x, 2000, 2005) and Sybase 10 JDBC Name: j

  • How to install the JDBC driver MYSQL5.0 2010-08-30

    1, download mysql for jdbc driver. http://dev.mysql.com/downloads/connector/j/3.1.html MySQL Connector / J is distributed as a. Zip or. Tar.gz archive containing the sources and class files as well as a class-file only "binary". jar archive name

  • Analyzing the details of Oracle JDBC driver 2010-09-09

    Oracle database to connect all the details of the oracle JDBC driver. These details include: 1, Import JDBC packages 2, registered oracle JDBC drivers 3, open the database connection 4, the implementation of SQL DML statements in the database table a

  • Spring configure DB2 errors Cannot create JDBC driver of class 2010-10-03

    Today in the configuration file in the Spring when the DB2 data source, Tomcat load, always appear "Cannot create JDBC driver of class 'COM.ibm.db2.jdbc.app.DB2Driver' for connect URL 'jdbc: db2: school' . "solution in search of a half-day progr

  • About informix jdbc driver to upgrade to 3.5 after the change in the migration 2010-10-20

    Informix database-driven projects need to be upgraded, and change to the latest version of the jdbc driver 3.5 version. When in the upgrade package is just replace the jar can not achieve the desired effect. Update, the addresses on the database conn