java.sql.SQLException: Bigger type length than Maximum

[rce...@my-dejanews.com]

hi,

sorry for reposting that subject, but my problem is slithly different and
can't be solved by the given answers.

i am fetching a query into a result-set and writing the result record by
record into a file. there comes a record where this error-message
":java.sql.SQLException: Bigger type length than Maximum" appears. when i
change the query, so that only the problematic record alone is fetched, the
error-message doesnt appear and the record is written into the file.

anyone got any learnings to share?

TIA,
robert.

following: code-extract and error-message

1. java-code
while(next)
{
System.out.println(count);
for (i=1;i<=columns;i++)
{
Object o = null;
System.out.println(i);
o = resultSet.getObject(i);
if (o != null)
{

System.out.println(resultSet.getObject(i).toString().substring(0,10));

dataStream.writeBytes(resultSet.getObject(i).toString());
dataStream.flush();
}
}
count++;
System.out.println(resultSet.getWarnings());
try {
next = resultSet.next();
} catch (SQLException se) {
System.out.println("1:"+se);
next=resultSet.next();
}

}

2. error-message
java.sql.SQLException: Bigger type length than Maximum
java.sql.SQLException: Protocol violation
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:378)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:637)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1206)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:709)
at oracle.jdbc.driver.OracleResultSet.next(OracleResultSet.java:95)
at JDBCAdapter.dumpQueryToFile(JDBCAdapter.java:362)
at JDBCAdapter.dumpVectors(JDBCAdapter.java:406)
at JCDClientExport$1.actionPerformed(JCDClientExport.java:184)
at
com.sun.java.swing.AbstractButton.fireActionPerformed(AbstractButton.java:860)
at
com.sun.java.swing.AbstractButton$ForwardActionEvents.actionPerformed(Abstract
Button.java:895)
at
com.sun.java.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.j
ava:338)
at
com.sun.java.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:230)
at
com.sun.java.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonLis
tener.java:156)
at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:235)
at java.awt.Component.processMouseEvent(Component.java:2284)
at java.awt.Component.processEvent(Component.java:2129)
at java.awt.Container.processEvent(Container.java:894)
at java.awt.Component.dispatchEventImpl(Component.java:1764)
at java.awt.Container.dispatchEventImpl(Container.java:939)
at java.awt.Component.dispatchEvent(Component.java:1704)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:1548)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:1457)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:1392)
at java.awt.Container.dispatchEventImpl(Container.java:926)
at java.awt.Window.dispatchEventImpl(Window.java:443)
at java.awt.Component.dispatchEvent(Component.java:1704)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:63)

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading

[John R. Howey]

As I've said in previous posts (which may have expired), this is a bug in the
Oracle thin driver. It has been reported to Oracle. I got around this problem
by retrieving the data (VARCHAR2(2000), LONGs in my case) in < 500 byte
chunks and then appending them on the client...
I also seem to remember reading something about a trailing single quote (') in the

data causing this.
Oracle has fixed this in their upcoming release...