SQLException « oracle « Java Database Q&A

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 {

 ...