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
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 |