From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Hannu Krosing <hannu(at)2ndquadrant(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: What do people use for connection pooling with PostgreSQL JDBC |
Date: | 2009-04-07 13:39:07 |
Message-ID: | 491f66a50904070639g6fe91d6dxa0f856e42e5cccce@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Tue, Apr 7, 2009 at 9:23 AM, Hannu Krosing <hannu(at)2ndquadrant(dot)com> wrote:
> On Tue, 2009-04-07 at 06:24 -0400, Dave Cramer wrote:
> >
> >
> > On Tue, Apr 7, 2009 at 4:35 AM, Hannu Krosing <hannu(at)2ndquadrant(dot)com>
> > wrote:
> > On Mon, 2009-04-06 at 07:43 -0400, Dave Cramer wrote:
> > > huh ? What makes you think it doesn't deal with arrays ?
> >
> >
> > I have a sample function, whit takes an array argument
> >
> > CREATE OR REPLACE FUNCTION arraySum(
> > multiplier bigint,
> > valuelist bigint[],
> > OUT result int
> > ) AS
> > $$
> > BEGIN
> > result = 0;
> > FOR idx IN array_lower(valuelist,
> > 1)..array_upper(valuelist, 1) LOOP
> > result = result + multiplier * valuelist[idx];
> > END LOOP;
> > RETURN;
> > END;
> > $$ LANGUAGE plpgsql SECURITY DEFINER;
> >
> >
> > When I call this function directly via JDBC or using proxool I
> > get a
> > result, when doing it via c3p0 or dbcp I get an exception -
> >
> > Long[] array = { 1L, 2L };
> > PreparedStatement ps = conn.prepareStatement(
> > "SELECT * FROM arraySum(?, ?)");
> > ps.setLong(1, 3L);
> > ps.setArray(2, conn.createArrayOf("bigint", array));
> > ps.execute();
> >
> > OK, createArrayOf is a relatively new method. So .... you have a few
> > ways around this.
> >
> > 1) don't use it, create your own arrays.
> > 2) fix the dbcp code
> > 3) complain to dbcp people
>
> It's both dbcp and c3po.
>
> I understand that dbcp and c3po work on some other databases jdbc
> drivers, so maybe I could also do
>
> 4) fix jdbc code to provide required createArrayOf support
>
> no ?
>
Well, the newer drivers support createArray, so perhaps you need a newer
driver ?
As well as showing us the exception.
>
> >
> --
> Hannu Krosing http://www.2ndQuadrant.com
> PostgreSQL Scalability and Availability
> Services, Consulting and Training
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2009-04-07 13:40:55 | Re: What do people use for connection pooling with PostgreSQL JDBC |
Previous Message | Brad Milne | 2009-04-07 13:31:11 | BLOB help - yes I've read around! |