tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Serge Knystautas <>
Subject Re: SQL INSERT
Date Mon, 25 Aug 2003 13:19:20 GMT
p@zdzior wrote:
>    <sql:transaction dataSource="${test}">
>       <sql:update var="InsertDriver">
>                                    VALUES (?,?)
>         <sql:param value="${Customer.phone_no}"/>
>         <sql:param value="SINGLE"/>
>       </sql:update>
>     </sql:transaction>
> The REQUEST_OFFER table has an ID field which is autincrement unique key.
> Is it possible to obtain the value of this filed just after insert using JSTL?
> Something like getGeneratedKeys() java methd.
> Or if it is impossible to do using JSTL how to do it using java scriptlet?

The JSTL SQL tags just run SQL statements... there's nothing fancy going 
on here.  Usually there's a database function you can call, select 
SELECT last_id() or something like that, to retrieve the ID of the most 
recently auto-incremented key value.

You'll want this second SQL statement to happen in the connection, but 
since you're using the sql:transaction tag, that will already happen.

Serge Knystautas
Lokitech >> software . strategy . design >>
p. 301.656.5501

View raw message