Oninit cdi / Archive
Talk to an expert →

java.sql.SQLException: Blob not found

Posted in 2010

Topics: Connectivity: ODBC / JDBC / .NET, Java & JDBC Development

Renteria Pierola Jose — — source: IIUG Forums & Mailing Lists

Hi, I have a problem with a java application that uses blob fields, I am using Informix JDBC Driver 2.21 and 2.24 with IBM IDS 10, I set the following parameters in the DataSource: URL ------ jdbc:informix-sqli://172.16.40.40:8888/pruebablob:informixserver=prueba;LOBCACHE =-1;JDBCTEMP=/tmp;ifxJDBCTEMP=/tmp;FREECLOBWITHRS=true -------------- freeclobwithrs = true user = SolWeb lobcache =- 1 ifxjdbctemp = / tmp jdbctemp = / tmp But nothing is coming out the same error. Someone could help me or give some idea Best Regards José Luis Rentería Piérola División de Arquitectura - INSI SUNAT Phone : (51-1) 411-2230 / Anexo 28329 Mobile : (51-1) 9-9753-5496 EMail : jrenteri@sunat.gob.pe Web-Page : http://www.sunat.gob.pe

↪ replying to Renteria Pierola Jose
Frank Langelage — — source: IIUG Forums & Mailing Lists

The problem description is not sufficient for me. What do you mean with "not found" and "nothing is coming out"? Exceptions? NULL result for the blob column although the row retrieved has a filled blob field in the database? It might be helpful to use a more recent JDBC driver like 3.50.JC5 (with 3.50.JC6 I have problems). Regards, Frank On 05.05.10 16:53, Renteria Pierola Jose Luis wrote: > Hi, > > I have a problem with a java application that uses blob fields, I am using > Informix JDBC Driver 2.21 and 2.24 with IBM IDS 10, I set the following > parameters in the DataSource: > > URL > ------ > > jdbc:informix-sqli://172.16.40.40:8888/pruebablob:informixserver=prueba;LOBCACHE =-1;JDBCTEMP=/tmp;ifxJDBCTEMP=/tmp;FREECLOBWITHRS=true > > -------------- > freeclobwithrs = true > user = SolWeb > lobcache =- 1 > ifxjdbctemp = / tmp > jdbctemp = / tmp > > But nothing is coming out the same error. > > Someone could help me or give some idea > > Best Regards > > José Luis Rentería Piérola > > División de Arquitectura - INSI > > SUNAT > > Phone : (51-1) 411-2230 / Anexo 28329 > > Mobile : (51-1) 9-9753-5496 > > EMail : jrenteri@sunat.gob.pe > > Web-Page : http://www.sunat.gob.pe > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > >

Glossary