Re: Prepared statement with function as argument: how to bind values?

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: alexbruy <alexander(dot)bruy(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Prepared statement with function as argument: how to bind values?
Date: 2011-09-23 19:25:19
Message-ID: CAH_hXRacBHtR1bX0_VypvXcgtxKG6OKXkBk0BCKew5NyK=S9Eg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

> As I
> understand, it says about number of columns because there are 5
> columns listed in query and I try to bind value to non existing 6
> column.

As I understand it,

(1) the parameter handling code doesn't know or care you're executing
an insert, so it shouldn't deal in "columns" here, just in parameters
(2) the question marks in 'POINT(?,?)' should not be treated as
parameter markers at all: it should just be a String constant.

Can you show us exactly how you're binding parameters in jdbc?
---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mikko Tiihonen 2011-09-23 21:31:24 Patch for binary receive of basic array types
Previous Message Bodor Andras 2011-09-23 18:46:04 Re: Prepared statement with function as argument: how to bind values?