Problems with MappedStringIndex (Derby / H2)

[tjweir]

Problems with MappedStringIndex (Derby / H2)

Lighthouse #26: http://liftweb.lighthouseapp.com/projects/26102/tickets/26

[tjweir]

I posted this to the mailing list back in december. Posting again so it's preserved :)

I tested this with Scala 2.7.3 and the Lift 1.0 release.
Recently I wanted to have a Mapper with a String uuid as primary key. I found out that MappedStringIndex does that. It didn't work though.

Using it with with a derby driver threw this exception:

Caused by: java.sql.SQLException: 'ID' cannot be a column of a

primary key or unique key because it can contain null values.

The create table looked here like it generated the id itself, so the lift generated id isn't saved in the db.

Using the H2 driver:
CREATE TABLE myuuidmapper (id VARCHAR(64)) INSERT INTO myuuidmapper () VALUES ()

This means the table has been created but the lift-generated id was not saved in the database.

I attached an example project. Boot.scala is configured to use the Derby driver. If requested I can provide an example for H2.

[dchenbecker]

This is in progress, and dependent on issue #231 making it into trunk. We'll have to discuss whether we want to back-port some of the related code into the 1.0 line.

[dchenbecker]

This works now in 1.1-SNAPSHOT by modifying the MyUuidMapper class to change:

object id extends MappedStringIndex(this, 64)

to

object id extends MappedStringIndex(this, 64) {
  override def dbNotNull_? = true
  override def dbAutogenerated_? = false
}

[github-importer]

Imported from GitHub: http://github.com/dpp/liftweb/issues/13/find

[github-importer]

Imported from Assembla: http://www.assembla.com/spaces/liftweb/tickets/13