Big problem with DB2 and Clobs...

[Starsky]

Hello everyone!

I am spanish and I am developing an application using DB2 v9 and Java. I´m currently trying new things but I have a problem.

I can easily do INSERTS from my application into the DB (XML, CLOBS, etc.) but I have problems when I execute:

String qDesc="SELECT DESCRIPCION FROM AVION";
                    
                   Statement pst2 = cx.createStatement();    
                   ResultSet rsd=pst2.executeQuery(qDesc);
                   while (rsd.next())
                   {
                        Clob doc = rsd.getClob(1);
                        InputStream strdoc = doc.getAsciiStream();
                        etc...

The error I obtain is the following:


SQL Error com.ibm.db2.jcc .c.SqlException
com.ibm.db2.jcc .c.SqlException
at com.ibm.db2.jcc .c.ec.<init>(ec .java:183)
at com.ibm.db2.jcc .b.d.b(d.java:1 328)
at com.ibm.db2.jcc .c.s.a(s.java:7 48)
at com.ibm.db2.jcc .c.s.U(s.java:1 393)
at com.ibm.db2.jcc .c.wf.getClob(w f.java:914)
at aeronautics.MyC onsults.btnMost rarActionPerfor med(MyConsults
.java:113)
at aeronautics.MyC onsults.access$ 000(MyConsults. java:21)
at aeronautics.MyC onsults$1.actio nPerformed(MyCo nsults.java:
64)
at java.awt.Button .processActionE vent(Unknown Source)
at java.awt.Button .processEvent(U nknown Source)
at java.awt.Compon ent.dispatchEve ntImpl(Unknown Source)
at java.awt.Compon ent.dispatchEve nt(Unknown Source)
at java.awt.EventQ ueue.dispatchEv ent(Unknown Source)
at java.awt.EventD ispatchThread.p umpOneEventForF ilters(Unknown Source)
at java.awt.EventD ispatchThread.p umpEventsForFil ter(Unknown Source)
at java.awt.EventD ispatchThread.p umpEventsForHie rarchy(Unknown Source)
at java.awt.EventD ispatchThread.p umpEvents(Unkno wn Source)
at java.awt.EventD ispatchThread.p umpEvents(Unkno wn Source)
at java.awt.EventD ispatchThread.r un(Unknown Source)


It´s driving me crazy...I´m guessing it´s a driver problem but I´m not sure...

Please, can anyone help me? :)

Oh, by the way, I use netbeans 5.5

Lots of thanks in advance!!!!

Nacho