SQLException « oracle « Java Database Q&A

1.	Blob
2.	cassandra
3.	column
4.	Connection
5.	Cursor
6.	dao
7.	Data Type
8.	Database
9.	Database Product
10.	DataSource
11.	Date
12.	db2
13.	derby
14.	Development
15.	Driver
16.	Exception
17.	file
18.	hadoop
19.	hbase
20.	hsqldb
21.	ibatis
22.	JDBC
23.	memcached
24.	mongodb
25.	MS Access
26.	mysql
27.	ODBC
28.	Operation
29.	oracle
30.	postgresql
31.	Record
32.	result
33.	Resultset
34.	Schema
35.	SQL
36.	sqlite
37.	SQLserver
38.	Statement
39.	stored procedure
40.	sybase
41.	Table
42.	Transaction
43.	Trigger

Java Database Q&A » oracle » SQLException

1. Exception while calling stored procedure :Bigger type length than Maximum stackoverflow.com

HI I am getting this exception when I am calling any stored procedure from my J2EE app.

Exception while calling stored procedure :Bigger type length than Maximum

I am having Oracle ...

2. Upgrading to Oracle JDBC thin driver results in SQLException: Unexpected exception while enlisting XAConnection stackoverflow.com

In Upgrading to Oracle JDBC thin driver results in SQLException: Unexpected exception while enlisting XAConnection (WebLogic Server 10.0, oracle version ) we are getting the error listed below. We did follow Oracle's ...

3. SQLException: Protocol violation. Oracle JDBC Driver issue stackoverflow.com

I'm getting the following excpetion:

java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)
at oracle.jdbc.driver.T4C80all.receive(T4C80all.java:766)
at oracle.jdbc.driver.T4CPreparedStatement.do0all8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1225)
at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:373)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:284)

The Oracle system is running 10.2.0.3.0 on Solaris 5.10. The jdbc driver is running on JDK 1.6.0_21 ...

4. What is the proper way to catch and handle ORA-00001 SQLException with JDBC? stackoverflow.com

I'm creating a simple form that stores entered data in an extremely simple Oracle database table via a Java Servlet using JDBC. That table is using the email address as ...

5. sqlException : "Invalid scale size. Cannot be less than zero." when executing script with UNION stackoverflow.com

I received this sqlException while debugging : Invalid scale size. Cannot be less than zero. I was executing this script :

select trunc(A.ft_dt) - trunc(sysdate) from table_name A
UNION
select trunc(A.bp_dt) - trunc(sysdate) from other_table_name ...

6. Does Oracle PreparedStatement.executeUpdate() handle connection pool exhaution by throwing an instance of SQLException? stackoverflow.com

Will Oracle PreparedStatement.executeUpdate() API throw an exception of type SQLException if the connection pool is exhausted? My application codes (KMDatabaseDAO.insert()) is calling the Oracle PreparedStatement.executeUpdate() API, however, the method seems to only ...

7. Java Oracle localhost connection error (ORA-12505) stackoverflow.com

I am trying to currently connect to a database on my current computer.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Main {
    public static void main(String[] argv) throws Exception {

 ...