Received: from smtp2.jakinternet.co.uk (proxy.jakinternet.co.uk [212.41.43.4]) by hub.org (8.10.1/8.10.1) with ESMTP id e6G8bM059528 for ; Sun, 16 Jul 2000 04:37:22 -0400 (EDT) Received: from smtp.jakinternet.co.uk (smtp.jakinternet.co.uk [212.41.41.61]) by smtp2.jakinternet.co.uk (Postfix) with SMTP id E9636A7765 for ; Sun, 16 Jul 2000 09:36:01 +0100 (BST) Received: from tabatha ([212.41.52.95]) by smtp.jakinternet.co.uk ; Sun, 16 Jul 2000 09:37:01 -0100 Message-ID: <008901bfef01$38c1e460$5f3429d4@retep.org.uk> From: "Peter Mount" To: "Matt Fair" , References: <3970AB0C.9F0DC4D4@netasol.com> Subject: Re: Clob support in jdbc Date: Sun, 16 Jul 2000 09:35:18 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200007/101 I added CLOB/BLOB interface implementations into the JDBC2.0 driver for 7.0 so they should work. Stream support isn't yet available but if you read your stream into a byte[] array, then feed it to PreparedStatement then it will work . JDBC can handle arrays <-> Blobs but not streams yet. Peter -- Peter T Mount peter@retep.org.uk, peter@retepdigital.com, me@petermount.com Homepage: http://www.retep.org.uk Contact details @ http://petermount.com PostgreSQL JDBC: http://www.retep.org.uk/postgres/ Java PDF generator: http://www.retep.org.uk/pdf/ ----- Original Message ----- From: Matt Fair To: Sent: Saturday, July 15, 2000 7:18 PM Subject: [INTERFACES] Clob support in jdbc > Hello, > I need to be able to store product information in a database. The > product information includes descriptions that can be 4000 + > characters. I have tried setAsciiStream() in the jdbc but it is not > supported. It there any way I can store this information? > Thank you, > Matt Fair >