Discover oracle jdbc oracledriver jar, include the articles, news, trends, analysis and practical advice about oracle jdbc oracledriver jar on alibabacloud.com
, when I was working on a project, I needed to access data from other databases. I could only use the ODBC driver on the Windows platform. The cost of doing so is that you can only deploy applications on the Windows platform, rather than using Unix-like systems. This is like being shackled. My requirement is to be cross-platform, so there is only one option-JDBC.
This is not surprising. In today's enterprise applications, only
Tags: CPM baidu ext tar installation start warehouse user color1. Due to Oracle licensing issues, MAVEN3 does not provide Oracle JDBC driver, and in order to apply the Oracle JDBC driver in a MAVEN project, it must be manually added to the local warehouse , which uses
1. Create a table:
Create Table stud (Sid int,Sname varchar2 (50))Insert a data recordInsert into stud values (1, 'Tom ')
2. Define a cursor through the packageCreate or replace package pack_studIs-- Declare a cursor typeType cur is ref cursor;End;3. Create a stored procedure
Create or replace procedure pro_select_stud (My_cur out pack_stud.cur)IsBeginOpen my_cur for select * from stud;End;
4. Call in JDBC
Import java. SQL. callablestatement;Import ja
Add the Oracle JDBC driver to the Maven Repository
Due to Oracle authorization problems, Maven3 does not provide Oracle JDBC driver. To Apply Oracle JDBC driver to Maven projects, you m
1. Create a table
Create Table stud (Sid int,Sname varchar2 (50 ),Age number,Score number (4, 2 ))And insert some data (manually insert some data)2. Create a function
Create or replace function fun_getscores (V_age in stud. Age % Type)Return numberIsV_score number;BeginSelect sum (score) into v_score from stud where age> v_age;Return v_score;-- Exception HandlingExceptionWhen others thenDbms_output.put_line (sqlcode | sqlerrm );Return-1;End;3. Call in JDBC
Tags: uil www art one file drive pre connection Count dependentOne, when we need to connect to a database in a MAVEN project, we only need to configure its dependencies, but Maven does not provide Oracle JDBC driver, which is not available due to Oracle licensing issues and needs to be added manually. Second, get the jar
Import java.sql.*;
Several problems needing attention in JBuilder correctly connecting Oracle ArrayiOracle8 above should all use the Classes12.jar file as JDBC driver;Correctly set up the enterprise Setup, configure libraries in Windows Classpath and JBuilder, and add the Casses12.jar path to the place where you need
Import java. SQL .*;
Public class ora8iconnect{Public ora8iconnect (string dB, string ID, string PWD){Dbname = dB;Userid = ID;Userpwd = PWD;Beginconnect (); // connect to the database}/*-* Returns a connection object.*/Public connection getconnection () {return conn ;}
/*-* Connect to the database. If the connection succeeds, 1 is returned. Otherwise, 0 is returned.*/Public int beginconnect (){Try{// Load an oracle driverDrivermanager. register
Due to Oracle licensing issues, MAVEN3 does not provide Oracle JDBC driver and must be manually added to the local warehouse in order to apply the Oracle JDBC driver in the MAVEN project.first, to get the Oracle
The following articles mainly introduce three different types of JDBC drivers in Oracle databases. We all know that jdbc drivers in Oracle mainly include the following three types: 1. jdbc oci: oci is the abbreviation of Oracle ca
Because of Oracle licensing issues, MAVEN does not provide Oracle JDBC driver, which must be manually added to the local warehouse in order to apply the Oracle JDBC driver in the MAVEN project.I. Obtaining the Oracle
1. Find the available oracle jdbs driver jar package and place it in the specified directory (which can be customized as needed) D: \ jdbc \ ojdbc14.jar
2. Install maven. Configure the environment variable MAVEN_HOME = 'point to the maven installation directory'
3. Open the cmd window, jump to the D: \
The driver packages from Oracle8 to ORACLE10,JDBC directories are different. Look at Oracle's documentation, understand their use, I believe you are sometimes very confused, write to share.
These are the names of the driver packages under oracle10g and their role, and other versions of Oracle are basically similar.
Classes12.jar (1,417,089 bytes)-Use under JDK 1.
An exception occurs when the maximum number of jdbc cursors is exceeded. The relationship between oracle and jdbc has been improved. Record it for future reference. If you have any errors, please note. Oral
An exception occurs when the maximum number of jdbc cursors is exceeded. The relationship between
Label:has been using MySQL, has recently switched to Oracle, Oracle's first step is the JDBC connection The first step: Download the jar package, I use the oracle11g is Oracle6.jar Step two: Load the jar package Then find the downloaded
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.