Re: setArray()

From: "Andrew Lazarus" <drlaz(at)attglobal(dot)net>
To: <pgsql-jdbc(at)postgresql(dot)org>
Cc: "Conor Beverland" <cb801(at)doc(dot)ic(dot)ac(dot)uk>
Subject: Re: setArray()
Date: 2004-01-13 14:52:44
Message-ID: 013c01c3d9e4$e6d119a0$847ba8c0@ANDYXP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I have the same issue, but my Array is much smaller. As you see downthread,
there is no practical way to use setArray().

As for speed: Are you using a StringBuffer allocated sufficiently large to
begin with, not a String? (My last line is

return new String(sbuffer);

HTH.

----- Original Message -----
From: "Conor Beverland" <cb801(at)doc(dot)ic(dot)ac(dot)uk>
To: <pgsql-jdbc(at)postgresql(dot)org>
Sent: Monday, January 12, 2004 6:40 AM
Subject: [JDBC] setArray()

> Hi,
>
> I'd like to insert a large array of integers into the database (15000)
> However I can't seem to get PreparedStatement.setArray() to work.
>
> I saw a patch in the archives regarding this but I'm not in control of
> the java installation which I'm using.
>
> I'm currently converting my array into a string before inserting it
> and using setString()... However this is *very* slow!
>
> Any advice would be much appreciated,
> Conor
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match

In response to

  • setArray() at 2004-01-12 14:40:55 from Conor Beverland

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-01-13 23:28:18 Re: "Best" Pre-compiled driver for PostgreSQL 7.2.2 ?
Previous Message Anderson dos Santos 2004-01-13 12:39:55 to leave