Updating a Long VarChar field

Posted in 2003

Topics: Connectivity: ODBC / JDBC / .NET, Data Types & Schema Design, Java & JDBC Development

Gustavo Brown — Mon, 11 Aug 2003 15:44:55 -0300 — source: Usenet: comp.databases.informix

Hi, I'm having problems to update a LONG VARCHAR field. Suppose I have a table with two fields (the key field named TheKey, and a long varchar field, named LongVarChar) I use this sql sentence for updation: UPDATE TEST SET LongVarChar='Test' but I get the following message: java.sql.SQLException: A blob data type must be supplied within this context. at com/informix/jdbc/IfxSqli.errorDone (IfxSqli.java) at com/informix/jdbc/IfxSqli.receiveError (IfxSqli.java) at com/informix/jdbc/IfxSqli.receiveMessage (IfxSqli.java) ... ... Is there any way to do this update. I have tried to update in a row-by-row basis, and it seems to work, but I want to update all the rows at once. Am I missing something ? Any hints would be appreciated. Regards, G. Brown

↪ replying to Gustavo Brown

Gustavo Brown — Mon, 11 Aug 2003 16:28:04 -0300 — source: Usenet: comp.databases.informix

When I said 'LONG VARCHAR' field I really meant 'TEXT field', i.e. the field I am having trouble to update is a TEXT field. Regards, G.Brown "Gustavo Brown" <alegusTakeOffThisAndThisadinet.com.uy@QuitThisToo.Now> wrote in message news:bh8obm$m9$1@newsreader.mailgate.org... > Hi, > I'm having problems to update a LONG VARCHAR field. > Suppose I have a table with two fields (the key field named TheKey, and a > long varchar field, named LongVarChar) > > I use this sql sentence for updation: UPDATE TEST SET LongVarChar='Test' > but I get the following message: > > java.sql.SQLException: A blob data type must be supplied within this > context. > at com/informix/jdbc/IfxSqli.errorDone (IfxSqli.java) > at com/informix/jdbc/IfxSqli.receiveError (IfxSqli.java) > at com/informix/jdbc/IfxSqli.receiveMessage (IfxSqli.java) > ... > ... > > Is there any way to do this update. I have tried to update in a row-by-row > basis, and it seems to work, but I want to update all the rows at once. > Am I missing something ? Any hints would be appreciated. > > Regards, > G. Brown