So what's wroing with:
create table unique_names (id identity, name varchar not null unique)
You can even make the a column of type varchar the primary key. I did.
On Mon, Oct 22, 2012 at 7:18 PM, Brent Ellwein <[email protected]>
wrote:
Hello,
>
> I am trying to have a unique String column for my H2 database
> implementation. As this is not natively supported, I'm walking around in
> the weeds a little bit, and store the hash of the string in an indexed
> column in the table. For insert, I have a two-part check.
>
> 1) see if a row exists with the String value using an SQL select
> statement, if so return the generated ID for the already existing row.
> 2) insert the new row and then return the resulting generated ID.
>
> This seems to work fine with a combination of a select statement and a
> followup insert statement. BUT what I would like to do is write a stored
> procedure which does it all at once and then returns the id value quickly.
> I was able to write this function. However, I cannot seem to cache the
> prepared statement in my function call, and thus generate the statement for
> each call. The end result is that the stored procedure executes more
> slowly than running several calls through a client with cached stored
> procedures.
>
> Thus my question is, is there a way to cache a prepared statement from
> within a stored procedure? Is there a better approach to the problem which
> I have not yet thought of?
>
> Thanks you for your input.
> --Brent
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/h2-database/-/P4Pa9RQ1EgMJ.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
--
Vasile Rotaru
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
