From konkodi221@rediffmail.com Tue Feb 7 10:43:47 2006 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8065A9DC84B for ; Tue, 7 Feb 2006 06:43:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10002-04 for ; Tue, 7 Feb 2006 06:43:47 -0400 (AST) X-Greylist: delayed 00:06:39.150452 by SQLgrey- Received: from rediffmail.com (unknown [203.199.83.28]) by postgresql.org (Postfix) with SMTP id A1FC39DC83C for ; Tue, 7 Feb 2006 06:43:42 -0400 (AST) Received: (qmail 1692 invoked by uid 510); 7 Feb 2006 10:36:41 -0000 Date: 7 Feb 2006 10:36:41 -0000 Message-ID: <20060207103641.1691.qmail@webmail18.rediffmail.com> Received: from unknown (220.227.202.145) by rediffmail.com via HTTP; 07 feb 2006 10:36:38 -0000 MIME-Version: 1.0 From: "padmanabha konkodi" Reply-To: "padmanabha konkodi" To: pgsql-sql@postgresql.org Subject: passing array to database function Content-type: multipart/alternative; boundary="Next_1139308598---0-203.199.83.28-1603" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.414 required=5 tests=[AWL=0.224, DNS_FROM_RFC_ABUSE=0.479, HTML_IMAGE_ONLY_08=2.435, HTML_MESSAGE=0.001, HTML_SHORT_LINK_IMG_1=0.275, MSGID_FROM_MTA_HEADER=0] X-Spam-Score: 3.414 X-Spam-Level: *** X-Archive-Number: 200602/56 X-Sequence-Number: 24066 This is a multipart mime message --Next_1139308598---0-203.199.83.28-1603 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline =C2=A0hi everybody,=0A=0Ai want to pass Integer array to database function= from java precompiled statement. =0A=0Ajava gives java.sql.Array interface= but i dont know which implementing class i have to use in postgre=0A=0Areg= ards=0Aptrashantha.k.p=0A=0A=0A --Next_1139308598---0-203.199.83.28-1603 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

=0A =C2=A0hi everybody,
=0A
=0Ai want to pass Integer array to dat= abase function from java precompiled statement.
=0A
=0Ajava gives ja= va.sql.Array interface but i dont know which implementing class i have to u= se in postgre
=0A
=0Aregards
=0Aptrashantha.k.p
=0A
=0A
= =0A=0A

=0A

=0A=0A --Next_1139308598---0-203.199.83.28-1603-- From dev@archonet.com Tue Feb 7 10:53:03 2006 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7DCD59DC84B for ; Tue, 7 Feb 2006 06:53:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11828-04 for ; Tue, 7 Feb 2006 06:53:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 7C3509DC83C for ; Tue, 7 Feb 2006 06:53:01 -0400 (AST) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id D8DFE40BAFF; Tue, 7 Feb 2006 10:52:58 +0000 (GMT) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id B11A515EA4; Tue, 7 Feb 2006 10:52:58 +0000 (GMT) Message-ID: <43E87C0A.9030304@archonet.com> Date: Tue, 07 Feb 2006 10:52:58 +0000 From: Richard Huxton User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: padmanabha konkodi Cc: pgsql-sql@postgresql.org Subject: Re: passing array to database function References: <20060207103641.1691.qmail@webmail18.rediffmail.com> In-Reply-To: <20060207103641.1691.qmail@webmail18.rediffmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.116 required=5 tests=[AWL=0.116] X-Spam-Score: 0.116 X-Spam-Level: X-Archive-Number: 200602/57 X-Sequence-Number: 24067 padmanabha konkodi wrote: > =C2 hi everybody, >=20 > i want to pass Integer array to database function from java > precompiled statement. >=20 > java gives java.sql.Array interface but i dont know which > implementing class i have to use in postgre I don't really "do" java, but have you tried an array of integers for=20 your PostgreSQL function? What happened? --=20 Richard Huxton Archonet Ltd From achill@matrix.gatewaynet.com Tue Feb 7 11:08:38 2006 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5C8239DC887 for ; Tue, 7 Feb 2006 07:08:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12060-09 for ; Tue, 7 Feb 2006 07:08:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id 7A32F9DC84B for ; Tue, 7 Feb 2006 07:08:34 -0400 (AST) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id k17CBXOp006460; Tue, 7 Feb 2006 14:11:33 +0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id k17CBXig006456; Tue, 7 Feb 2006 14:11:33 +0200 Date: Tue, 7 Feb 2006 14:11:33 +0200 (EET) From: Achilleus Mantzios To: Richard Huxton cc: padmanabha konkodi , Subject: Re: passing array to database function In-Reply-To: <43E87C0A.9030304@archonet.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.107 required=5 tests=[AWL=0.107] X-Spam-Score: 0.107 X-Spam-Level: X-Archive-Number: 200602/58 X-Sequence-Number: 24068 O Richard Huxton έγραψε στις Feb 7, 2006 : > padmanabha konkodi wrote: > > Β hi everybody, > > > > i want to pass Integer array to database function from java > > precompiled statement. > > > > java gives java.sql.Array interface but i dont know which > > implementing class i have to use in postgre > > I don't really "do" java, but have you tried an array of integers for > your PostgreSQL function? What happened? The correct list is -jdbc. Theoritically you would have to write your own implementation of java.sql.Array. Practically build a String with the contents you want e.g. '{1,2,3,4}' for a int[] array, and your done. > > -- -Achilleus