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:1328)
at com.ibm.db2.jcc.c.s.a(s.java:748)
at com.ibm.db2.jcc.c.s.U(s.java:1393)
at com.ibm.db2.jcc.c.wf.getClob(wf.java:914)
at aeronautics.MyConsults.btnMostrarActionPerformed(M yConsults
.java:113)
at aeronautics.MyConsults.access$000(MyConsults.java: 21)
at aeronautics.MyConsults$1.actionPerformed(MyConsult s.java:
64)
at java.awt.Button.processActionEvent(Unknown Source)
at java.awt.Button.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilter s(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(U nknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(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