java.sql.SQLException: Protocol violation

[Rahul Juneja]

Hi,

I was just wondering if anybody has faced this problem in past when i am trying to get the connection

Also I am trying to connect to Oracle 9i from JSDK 1.4.2_08_b3 and including proper classes12.zip in the classpath

java.sql.SQLException: Protocol violation
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:857)
        at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:519)
        at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:256)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:249)
        at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:111)
        at DBTest.main(DBTest.java:20)
 
C:\Documents and Settings\rahul.juneja\Desktop\event>java notify
Class name for AA_Transaction property is : AATransaction
java.sql.SQLException: Protocol violation
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:857)
        at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:519)
        at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:256)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:249)
        at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:111)
        at AATransaction.DBEvent(AATransaction.java:34)
        at notify.eventNotify(notify.java:39)
        at notify.main(notify.java:57)
java.lang.NullPointerException
        at notify.eventNotify(notify.java:41)
        at notify.main(notify.java:57)  

let me know if u have any suggestions.

Cheers,
Rahul

[Rahul Juneja]

Thanks Guys !

I got the solution myself... the problem was my DB connecting password was showing an error ORA-28002: the password will expire within 25 day.

As soon as i reset the password its working fine now.

Cheers,
Rahul

[Jeanne Boyarsky]

Rahul,
Thanks for posting the solution for others who come across this thread in the future!

[RashMin Gadhavi]

Jeanne Boyarsky wrote:Rahul,
Thanks for posting the solution for others who come across this thread in the future!

Hello Rahul!

It just came across the same problem. Our Oracle Version is 11gR2 and I was getting the same Password expiry problem on Oracle. The DBs were locked, once we reset the password and un-lock the DB, problem got resolved!

Thank a lot !