Oninit cdi / Archive
Talk to an expert →

Re: Support for text datatype in java/jdbc

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues, Java & JDBC Development, Versions, Editions & End-of-Life

Sujit.Pal@bankofamerica.com — — source: Informix-list mailing list archive (1991-1998)

Red There is an example (or wheel, if you will) to handle blobs in the Informix ByExample site. Go to www.informix.com, click on Informix ByExample and then click on Java/JDBC (I think, but its fairly easy to find). HTH Sujit Red Valsen <red_valsen@yahoo.com> on 12/07/99 08:42:53 AM Please respond to Red Valsen <red_valsen@yahoo.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Support for text datatype in java/jdbc We are developing a web application (like everyone else) on Solaris 2.6/x86 using IDS 7.30 (unlike everybody else) and java with jdbc. Now we're running into the nitty-gritty of implementation details -- like how to support text datatypes. Is there a special java/jdbc method or type for use of Informix's text datatype? There are severe SQL limitations in using this type, some of which are overcome in esql/c with its loc_t variable type. Is there something analagous to this in java/jdbc? Or, if somebody else has already tread this rut, would you care to share your wheel so we don't have to re-invent it?

↪ replying to Sujit.Pal@bankofamerica.com
Red Valsen — — source: Informix-list mailing list archive (1991-1998)

The example at the byExample site, under JDBC/Other JDBC Examples/"Displaying Byte Images" does indeed have an example in which a column of type text is selected -- but the problem is with update and insert. There are no examples of this, nor any indication of how to go about solving this problem. I would suspect that an esql/c routine is required. Sujit.Pal@bankofamerica.com wrote: > Red > > There is an example (or wheel, if you will) to handle blobs in the Informix > ByExample site. Go to www.informix.com, click on Informix ByExample and then > click on Java/JDBC (I think, but its fairly easy to find). > > HTH > Sujit > > Red Valsen <red_valsen@yahoo.com> on 12/07/99 08:42:53 AM > > Please respond to Red Valsen <red_valsen@yahoo.com> > > To: informix-list@iiug.org > cc: (bcc: Sujit Pal) > Subject: Support for text datatype in java/jdbc > > We are developing a web application (like everyone else) on Solaris > 2.6/x86 using IDS 7.30 (unlike everybody else) and java with jdbc. Now > we're running into the nitty-gritty of implementation details -- like > how to support text datatypes. > > Is there a special java/jdbc method or type for use of Informix's text > datatype? There are severe SQL limitations in using this type, some of > which are overcome in > esql/c with its loc_t variable type. Is there something analagous to > this in java/jdbc? Or, if somebody else has already tread this rut, > would you care to share your wheel so we don't have to re-invent it?

↪ replying to Sujit.Pal@bankofamerica.com
ckakunje@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

I am using Informix JDBC Driver to connect to Informix server 7.31. When I try to select a Binary Blob Field (BYTE Data type ) I get the following error. and the Informix server crashes!! I cannot imagine why the server should crash? Please let me know if any solution. Thank you. Chida 09:54:08 On-Line Mode 09:54:08 Checkpoint Completed: duration was 0 seconds. 10:10:07 Assert Failed: No Exception Handler 10:10:07 Informix Dynamic Server Version 7.31.UC4 10:10:07 Who: Session(34, cnanda@a3c017a, -1, -980423032) Thread(100, sqlexec, c58da500, 1) File: mtex.c Line: 446 10:10:07 Results: Exception Caught. Type: MT_EX_OS, Context: mem 10:10:07 Action: Please notify InformixTechnical Support. 10:10:07 stack trace for pid 20290 written to /tmp/af.44c46cf 10:10:21 See Also: /tmp/af.44c46cf, shmem.44c46cf.0 10:10:42 mtex.c, line 446, thread 100, proc id20290, No Exception Handler. 10:10:47 PANIC: Attempting to bring system down 10:10:47 semctl: errno = 22 In article <82jkk8$a5u$1@news.xmission.com>, Sujit.Pal@bankofamerica.com wrote: > > > Red > > There is an example (or wheel, if you will) to handle blobs in the Informix > ByExample site. Go to www.informix.com, click on Informix ByExample and then > click on Java/JDBC (I think, but its fairly easy to find). > > HTH > Sujit > > Red Valsen <red_valsen@yahoo.com> on 12/07/99 08:42:53 AM > > Please respond to Red Valsen <red_valsen@yahoo.com> > > To: informix-list@iiug.org > cc: (bcc: Sujit Pal) > Subject: Support for text datatype in java/jdbc > > We are developing a web application (like everyone else) on Solaris > 2.6/x86 using IDS 7.30 (unlike everybody else) and java with jdbc. Now > we're running into the nitty-gritty of implementation details -- like > how to support text datatypes. > > Is there a special java/jdbc method or type for use of Informix's text > datatype? There are severe SQL limitations in using this type, some of > which are overcome in > esql/c with its loc_t variable type. Is there something analagous to > this in java/jdbc? Or, if somebody else has already tread this rut, > would you care to share your wheel so we don't have to re-invent it? > > Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary