Re: [GENERAL] 7.3 Prepared statements

Barry Lind wrote:

> The implementation in the current driver is such that you need to
> enable the use of server side prepare on a statement by statement
> basis (default is not to use it). So you should only enable if for
> those statements for which it will work. To illustrate the problem
> here is an example:
>
> pstat = conn.prepareStatement("insert into foo values (?); update bar
> set y = ?;);
>
> When run in server prepared mode this will issue the following
> statements to the server:
>
> prepare abc(int, int) as insert into foo values ($1); update bar set y
> = ($2);
>
> which will fail since the prepare statement is ended by the first
> semicolon. So this would be an example of a JDBC prepared statement
> that works fine currently but would fail when used with server side
> prepared statements.

Is the driver's mode set using a URL argument or an API call? I thought
I saw mention of a URL argument. Is the API call something that
persists between connection uses? We use a connection pool and I want
to get the right semantics for the use of this feature.

Personally, I'd prefer that the server scan for a non-quoted semicolon
and revert to non-prepared' operation. The cost of the extra scan is
likely to be minimal and would allow those folks who use a connection
pool to use this feature and have it work when it can and not interfere
when it might. I am guessing that you may have already parsed the
statement looking for ?'s

If so, wouldn't the supression of the 'prepare' be relatively
straight-forward?

Charlie

--

Charles H. Woloszynski

ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015

tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com