The code in 1.1-SNAPSHOT already uses sequences for Oracle. Here's the
relevant code:
override def primaryKeySetup(tableName : String, columnName : String) :
List[String] = {
/*
* This trigger and sequence setup is taken from
http://www.databaseanswers.org/sql_scripts/ora_sequence.htm
*/
super.primaryKeySetup(tableName, columnName) :::
List("CREATE SEQUENCE " + tableName + "_sequence START WITH 1 INCREMENT
BY 1",
"CREATE OR REPLACE TRIGGER " + tableName + "_trigger BEFORE INSERT
ON " + tableName + " " +
"FOR EACH ROW " +
"WHEN (new." + columnName + " is null) " +
"BEGIN " +
"SELECT " + tableName + "_sequence.nextval INTO :new." + columnName
+ " FROM DUAL; " +
"END;")
}
Are you running into an issue with it?
Derek
On Tue, Nov 10, 2009 at 1:46 AM, aw <anth...@whitford.com> wrote:
>
> For Oracle database tables, one typically creates a Sequence to
> provide primary key values. For example:
>
> create table WIDGET (
> id Number(8,0) not null,
> name varchar2(50) not null,
> ...
> constraint WIDGET_PK primary key (id),
> ...
> )
> create sequence WIDGET_ID_SEQ
>
> When creating records using Mapper, is there a convenient way to get
> Mapper to automatically leverage the corresponding sequence to
> populate the id column?
>
> (Why Oracle doesn't do this automatically in 2009 like SQL Server,
> Sybase, and other database systems, is beyond me...)
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Lift" group.
To post to this group, send email to liftweb@googlegroups.com
To unsubscribe from this group, send email to
liftweb+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/liftweb?hl=en
-~----------~----~----~----~------~----~------~--~---
