protocol violation

[sarantin]

Hello everybody,

I am having the following message "SQL Exception: Protocol Violation"
when I am trying to retrieve many rows from a database (5000 or more).
I am using JBoss 3.0.3 and I am trying to connect to an Oracle 8.1.7
database through the "classes12.zip" jdbc driver.
Does anybody have an idea of what is wrong?

Thanks

Christos

[pilhuhn]

IIrc this comes from retrieving more than 255 rows at a time.
set the page-size value in standardjbosscmp-jdbc.xml to <=255.

[sarantin]

Thanks for the quick reply,
I tried it without succes!

I forgot to mentioned that I am not using any entity beans (only session beans) and I am accessing the database through sql queries or
stored procedures!

Any other idea?

Christos

[raja05]

IIRC There was soem issue with the JDBC Libraries (classesxxx.zip) and oracle 8.1.6 version. Try the latest version of the JDBC Jar files and give it a try.

[sarantin]

Hi,

I tried different jdbc drivers (classes111, classes12 and classes14) but
still the same message appears.
The Jboss server is running to a Unix machine.
When I try it from a Jboss running to Windows (2000) (accessing the same db), no such message appears.
Therefore, I am pretty sure that is a a matter of JBoss configuration!
Any clue?

Christos