Differences between Classes12.jar,ojdbc14.jar,ojdbc5.jar and Ojdbc6.jar, the difference betweenWhen using the Oracle JDBC driver, are there some problems that you can solve by replacing different versions of the Oracle JDBC driver
Drivers and JDBC URLs for commonly used databases:
Oracle Database:
Driver Package Name: Ojdbc14.jar
Name of the driver class: Oracle.jdbc.driver.OracleDriver
JDBC url:jdbc:oracle:thin:@ Dbip:port:databasename
Description: Driver
driver, we also need to register the real realdriver, but we need to ensure that we register first, so that drivermanager will first find us in the "Registry, otherwise, we will not be able to get the expected results. Don't forget, we are going to print the SQL statement into the format we need. Let's call it "injection" because it sounds cool! Well, if our database is dbmaker (SYSCOM product), we should first put its
% dbms oraxa10.lib % ORACLE_HOME % precompibmsvcorasql10.lib# Oracle 9Oracle_XA; xaosw; % ORACLE_HOME % dbms oraxa9.lib % ORACLE_HOME % precompibmsvcorasql9.libIn UnixOracle_XA: xaosw :....1. In windows, the semicolon ";" is followed by ORACLE_XA and xaosw, not the colon ":"Second, the above LIB is written on one line, separated by spaces in the middle. If ORACLE_HOME is not set in the system environment variable, the absolute path is written.
'Java
Recently, the ghost had the idea of jdbc, because it was necessary to integrate the oracle driver into the software.
This is a common problem, but I am not prepared to solve it in a common way.
The common method is to get a "simplified" oracle client (you need to write the Registry) or directly connect to the client fr
Mm. mysql is a mysql JDBC driver of Type 4 (pure java) that complies with the jdbc2 specification. The current version is 2.0pre5 (beta. worldserver. commm. mysql downloads the latest driver. This article only briefly describes mm. install and use mysql 1. download mm. mysql2, extract to a drive, such as c: 3, modify c
Complete installation and testing of SQLServer2000 JDBC driver through JSP connection to various databasesComplete installation and testing of SQLServer2000 JDBC Driver (reprinted)1. Download The jdbc
Complete installation and testing of SQLServer2000 JDBC driver through JSP connection to various databasesComplete installation and testing of SQLServer2000 JDBC driver (reprinted)1. Download the jdbc
Complete installation and test description of sqlserver2000 JDBC driver
Author: shiyq Date: 2003.06.2
Note: When I wrote this article, I specifically referred to some online users for the essence and experience in sqlserver2000 JDBC.
1. Download The JDBC
js|server|sqlserver| Data | Database JSP connection All kinds of databases Daquan SQLServer2000 JDBC driver Complete installation and test instructions
SQLServer2000 JDBC Driver Complete installation and test instructions (reprint)
First, download the SQLSERVER2000
MM. MySQLMySQL JDBC driver introduction mm. mysql is a Type 4 (pure java) mysql jdbc driver that complies with jdbc 2 specifications. The current version is 2.0 pre 5 (beta). you can download the latest
.
Why use jdt:
Why use jtds?
Jtds is free software. jtds is released under the terms of the GNU lgpl, Giving you notOnly the posibility to debug and tweak it to your own liking but alsoTo use it in and distribute it with your free or invalid cialApplications.
The other "free" choices, the JDBC-ODBC bridge andMicrosoft's own JDBC driver are not actually free. If
are no longer supported.
2. The supported SQL Server versions are:
Microsoft SQL Server 2012
Microsoft SQL Server 2008 R2
Microsoft SQL Server 2008
Microsoft SQL Server 2005
Microsoft SQL AzureTM (new)
SQL Server 2000 and earlier versions are no longer supported. SQL Server 3.0/2000/2005 r2 is supported.(Http://www.microsoft.com/downloads/zh-cn/details.aspx? FamilyID = a737000d-68d0-4531-b65d-da0f2a735707)
Did a test, download Microsoft
Microsoft has been committed to improving interoperability and has released a new Java database connection (JDBC) driver.Program. All SQL Server users can download SQL Server JDBC driver 2.0 for free, you can access SQL Server 2000, SQL Server 2005, and SQL Server 2008 from any Java application, application server, or
% dbms oraxa10.lib % ORACLE_HOME % precompibmsvcorasql10.lib# Oracle 9Oracle_XA; xaosw; % ORACLE_HOME % dbms oraxa9.lib % ORACLE_HOME % precompibmsvcorasql9.libIn UnixOracle_XA: xaosw :....1. In windows, the semicolon ";" is followed by ORACLE_XA and xaosw, not the colon ":"Second, the above LIB is written on one line, separated by spaces in the middle. If ORACLE_HOME is not set in the system environment variable, the absolute path is written.
'Java
various Database Drivers
Database name
Description
Mysql
http://www.mysql.com/products/connector/j/
Shipped. But need to download the latest for MySQL 4.1 or higher.
Oracle
http://sourceforge.net/project/showfiles.php?group_id=33291Software/tech/java/sqlj_jdbc/index.html
Included.
SQL Server by Jtds
http://sourcefor
successfully upgrade to SP3.2. Download SQL Server Driver for JDBC Service Pack 3Http://www.microsoft.com/downloads/details.aspx?familyid=07287b11-0502-461a-b138-2aa54bfdc03adisplaylang=en Iv. system firewall or anti-virus softwareSuppose the system is open firewall or anti-virus software, in some cases can also appear similar problems.Not met, someone said so.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.