a variety of transaction isolation levels, which correspond to different levels of interference,The higher the isolation level, the better the consistency of data, but the weaker the concurrency.Isolation level in the JDBC Conntion classint Transaction_none= 0;READ UNCOMMITTED dataint transaction_read_uncommitted = 1;Read submitted dataint transaction_read_committed = 2;REPEATABLE READ data: Make sure things can read the same value from a field multi
Oracle do not really support batch processing. Only the preparedstatement object actually supports batch processing. We can use the addbatch () and executebatch () Methods to select a standard JDBC batch, or use the setexecutebatch () method of the preparedstatement object and the standard executeupdate () method () method: select an oracle proprietary method th
create bridges between Java programs and data sources. The application needs to be written once and can be moved to a variety of drivers to run. Sun provides a driver manager, a database vendor-such as MySQL, Oracle, which provides drivers that meet the requirements of the driver manager and can be identified to work properly. Therefore, JDBC is not limited by the database vendor.The
JAVA-JDBC connecting Oracle databases, statement and PreparedStatement comparisons (querying query)
1. PreparedStatement Interface Inheritance Statement, the PreparedStatement instance contains compiled SQL statements, so it executes faster than the Statement object. 2. As a subclass of Statement, PreparedStatement inherits all the functions of Statement. Three methods execute, ExecuteQuery, and execu
Tags: ar using data problem as new database SQL CDatabase version: Oracle 10gCharacter set: Simplified Chinese_china. Us7asciiJdk:1.6.0_45Oracle Driver: Ojdbc14.jarUse JDBC to manipulate the database, get connections, execute SQL without problems. However, the results of the query, all Chinese characters, are displayed as garbled.Debug check See in the data from the database to get out of the time, is alrea
The RAC configuration is as follows:
Node1: IP address 192.168.60.132, Instance name: Rac1, Host Name: Rac1
Node2: IP address 192.168.60.144, Instance name: rac2, Host Name: rac2
The RAC service name is oratest.
My application server is Apache + Tomcat
The configuration process is as follows:
1. After searching, we found that there are many connection RAC methods and copied the following jdbcurl:
JDBC:
Label:Java Connection to Oracle database JDBC (Java Data Base Connectivity,java database connection), then how do we use Java to connect the database? importjava.sql.connection;
importjava.sql.drivermanager;
importjava.sql.preparedstatement;
importjava.sql.resultset;
importjava.sql.sqlexception; publicclassjdbc{Publicstaticvoidmain (String[]args) {//1. Importing jar Packages Project name---->buidpath-----
triggersA. Enabling and disabling triggers: When to prohibit: Prohibit data import and exportsql> ALTER TRIGGER aiu_itemfile DISABLE;sql> ALTER TRIGGER aiu_itemfile ENABLE;B. recompiling a trigger: After a database object has changedC. Deleting a triggersql> DROP TRIGGER Aiu_itemfile;19. Triggers and stored proceduresTrigger Stored proceduresWrite no parameter, return value has parameter, return value (parameter)Write cannot commit or rollback canCall-way events occur automatically when called
How to process Oracle BLOB fields in JDBC
Source: Java resources Source: Hao congping
How to process Oracle BLOB fields in JDBCWhy should I write this article?I encountered this problem in my project some time ago. It took me two days to solve the Blob problem. I have also tried various methods introduced on the Internet. They all use the s
The following error is reported in the Oracle warning log:
ReferenceORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [], []Current SQL statement for this session:Select value from NLS_INSTANCE_PARAMETERS where parameter = 'nls _ DATE_FORMAT'
After analysis, this is a bug in connecting JDBC (Thin JDBC driver) to
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: \ jdbc directory, and execute the command
Mvn install: insta
We are using the ojdbc14.jar driver to talk to a 10.1.0.4 version database. when calling GetObject () on a rowset, asking for a column that has database type Timestamp (9), I need CT to get a java. SQL. timestamp. instead, I get an oracle. SQL. timestamp, which cannot be casted to Java. SQL. timestamp.
Reading the Oracle forums and manuals, I get the impression that the default mapping shoshould be to the
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.