| java.sql.SQLException: Protocol violation [message #90953] |
Mon, 07 January 2002 00:27  |
Fabio
Messages: 23
Registered: October 2001
|
Junior Member |
|
|
|
Hi, I don't have a solution about java.sql.SQLException: Protocol violation that occurs occasionally. I'm using Linux, JRun3.1, jdk1.3.1, Oracle 8.1.7 and classes12.zip. Do you know if this configuration's environment could have same problems!? Thanks.- Fabio
|
|
|
|
|
|
| Re: java.sql.SQLException: Protocol violation [message #91027 is a reply to message #90953] |
Thu, 21 February 2002 03:05  |
Fabio
Messages: 23
Registered: October 2001
|
Junior Member |
|
|
hi,
i'm sorry but i've not found a solution about Protocol Violation Exception.. i've solved the problem caching query's results and limiting access to db. Now works fine! I think that this exception occurs when you have not enough memory free... i think that this is A reason-
bye F.
|
|
|
|
|
|
|
|
|
|
| Re: java.sql.SQLException: Protocol violation [message #91072 is a reply to message #90953] |
Thu, 21 March 2002 22:04 |
EnterSSE
Messages: 1
Registered: March 2002
|
Junior Member |
|
|
Ensure that all JDBC actions are properly handled in __one__ transaction. The closing of each and every created JDBC resource solved these problems for me. It might sound obvious, but this was the only way I got my program to work with the thin driver under Oracle 8i and 9i. By the way, the same program had had no problems with the oci driver and other JDBC drivers.
java.sql.Connection connection = DriverManager.getConnection(...);
// The following calls preferably in one method, to ensure prompt closure
java.sql.Statement statement = connection.createStatement();
java.sql.Resultset resultset = statement.executeQuery(sqlstatement);
while (resultset.next())
{
// collect your data here
}
resultset.close();
statement.close();
// end of method
// do other transactions processes with the connection
connection.close();
connection = null;
I think Oracle 9i JDBC implements some kind of connection pooling, so the performance hit 'cause of closing the connection after each use is minimal.
|
|
|
|
|
|
| Re: java.sql.SQLException: Protocol violation [message #91081 is a reply to message #90953] |
Wed, 27 March 2002 04:39 |
Darrem
Messages: 1
Registered: March 2002
|
Junior Member |
|
|
Hi Guys and Girls
I stumbled across your link when searching for a sol.
to this problem and thank you very much for the comments This is how I solved the problem.
I am using J Developer (don't laugh) anyway I am using jdbc:oracle:thin:@<serverlocaion>
I was getting the Protocol violation until I included the classes
Oracle 8.1.6 SDK JDBC NLS Support
this is really "nls_charset12.zip"
and
Oracle 8.1.6 SDK JDBC
really classes12.zip
Hope This Helps
Darren
|
|
|
|
|
|
| Re: java.sql.SQLException: Protocol violation [message #91241 is a reply to message #91027] |
Thu, 13 June 2002 01:11 |
umesh
Messages: 23
Registered: March 2000
|
Junior Member |
|
|
Hi All,
I am also having "java.sql.sqlexception: Protocol Violation"
I am using thin Oracle client (classes12.zip) in Java program to access Oracle db. The program was working in the begining, but now I am having problem.
I think the problem is something to do with the Oracle database, because the same program has no problem connecting to another Oracle instance on the same machine. I have no idea how to resolve the problem. Any help would be appreciated.
|
|
|
|
|
|
|
|
| Re: java.sql.SQLException: Protocol violation [message #91510 is a reply to message #90953] |
Tue, 15 October 2002 11:53 |
Eva P
Messages: 1
Registered: October 2002
|
Junior Member |
|
|
|
I tried to recompile ("create or replace...") all my functions and procedures, because I only saw this problem appear after I modified the tables in the database but failed to re-compile the stored code. I will keep monitoring to see if this solves the "protocol violation" - good luck to everyone.
|
|
|
|
| Re: java.sql.SQLException: Protocol violation:-SOLUTION [message #91617 is a reply to message #90953] |
Tue, 10 December 2002 10:06 |
Girish
Messages: 16
Registered: September 1998
|
Junior Member |
|
|
ALL,
The problem of Protocol Voilation comes when you try to connect to Oracle and istead of getting response in recordset or execution there is a blockage appears. for example in Oracle if you have setup like changing userid after 90 days or 60 days. What happened is Oracle will start asking you a question that your password is expiring do you want to change it or not, It means Before connecting to Oracle JDBC is blocked by this question and Oracle needs an Answer yes or no before executing your Query. So, You have to either take the user id which never expires or see the setting in Oracle for such kind of things.
I Hope this helps you
|
|
|
|
| Re: java.sql.SQLException: Protocol violation:-SOLUTION [message #91686 is a reply to message #91617] |
Thu, 09 January 2003 16:40 |
Maggie
Messages: 9
Registered: January 2003
|
Junior Member |
|
|
|
I think Girish's solution may be correct for some cases. The same problem of Protocol Violation has happened to me. I thought maybe it was because the keyword will expire, so I tried to solve the problem by changing the password. It worked. But after two months or so, today the exception happened again. And when I log into Oracle, there was no trouble and it didn't ask me any question. So there must be some other reasons that cause this problem. I use JSP, Oracle 9i in Unix environment. If somebody happens to have the same experience and knows the solution, please let me know. Thanks!
|
|
|
|
| Re: java.sql.SQLException: Protocol violation [message #91878 is a reply to message #90953] |
Tue, 17 June 2003 07:11 |
Christophe CAILLEUX
Messages: 1
Registered: June 2003
|
Junior Member |
|
|
Hi,
I have also the same problem : "protocol violation" occasionaly occurs for some obscure reason.
This error is often associated with 2 other errors : "java.sql.SQLException: Bigger type length than Maximum" and "java.sql.SQLException: Refcursor value is invalid".
I am using weblogic server 6.1, jdk 1.3.1, oracle 8.1.7 and jdbc thin driver 8.1.7 (or 9.2.0.3) on solaris 8.
Did you solve your problem ?
Thank you for any hint,
Regards,
Christophe
|
|
|
|
|
|
| Re: java.sql.SQLException: Protocol violation [message #92228 is a reply to message #91878] |
Sun, 25 April 2004 12:17 |
Jose Luis
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
I have the same problem with Oracle thin driver, classes12.zip, jdk 1.4, oracle 8.1.7 and 9.2., Bea Weblogic 7.0 sp4.
Did you found a solution?
I use Prepared Statement, and the tables have columns BLOB and CLOB.
Thanks in advance,
Jose L
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
