Hi,
I just tried to run the todo app.
(http://liftweb.net/docs/getting_started/mod_master.html) against our
Oracle (10something) database. The two tables got created like this:
INFO - CREATE TABLE users (id ROWID , firstname VARCHAR(32) , lastname
VARCHAR(32) , email VARCHAR(48) , locale VARCHAR(16) , timezone
VARCHAR(32) , password_pw VARCHAR(48) , password_slt VARCHAR(20) ,
textarea VARCHAR(2048) , validated NUMBER , uniqueid VARCHAR(32) ,
superuser NUMBER)
INFO - ALTER TABLE users ADD CONSTRAINT users_PK PRIMARY KEY(id)
INFO - CREATE TABLE todo (id ROWID , desc_c VARCHAR(128) , done NUMBER ,
owner NUMBER , priority NUMBER)
INFO - ALTER TABLE todo ADD CONSTRAINT todo_PK PRIMARY KEY(id)
INFO - CREATE INDEX users_email ON users ( email )
INFO - CREATE INDEX users_uniqueid ON users ( uniqueid )
INFO - CREATE INDEX todo_owner ON todo ( owner )
I then used Oracle's SQLDeveloper to confirm that the tables had been
created and had the right columns. However, when I tried to "Sign Up" in
the todo app., I got this nasty stuff right in the browser (nothing in
the log):
Exception occured while processing /user_mgt/sign_up
Message: java.sql.SQLException: Invalid column type
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:9262)
oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8843)
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:9316)
net.liftweb.mapper.MetaMapper$$anonfun$12$$anonfun$prepStat$1$1.apply(MetaMapper.scala:622)
net.liftweb.mapper.MetaMapper$$anonfun$12$$anonfun$prepStat$1$1.apply(MetaMapper.scala:616)
scala.Iterator$class.foreach(Iterator.scala:414)
scala.Iterator$$anon$14.foreach(Iterator.scala:265)
scala.Iterable$class.foreach(Iterable.scala:256)
scala.collection.mutable.HashMap.foreach(HashMap.scala:33)
net.liftweb.mapper.MetaMapper$$anonfun$12.prepStat$1(MetaMapper.scala:616)
net.liftweb.mapper.MetaMapper$$anonfun$12$$anonfun$19.apply(MetaMapper.scala:659)
net.liftweb.mapper.MetaMapper$$anonfun$12$$anonfun$19.apply(MetaMapper.scala:659)
net.liftweb.mapper.DB$$anonfun$prepareStatement$2.apply(DB.scala:292)
net.liftweb.mapper.DB$$anonfun$prepareStatement$2.apply(DB.scala:288)
net.liftweb.util.TimeHelpers$class.calcTime(TimeHelpers.scala:241)
net.liftweb.util.Helpers$.calcTime(Helpers.scala:29)
net.liftweb.mapper.DB$.prepareStatement(DB.scala:288)
net.liftweb.mapper.MetaMapper$$anonfun$12.apply(MetaMapper.scala:658)
net.liftweb.mapper.MetaMapper$$anonfun$12.apply(MetaMapper.scala:578)
net.liftweb.mapper.DB$.use(DB.scala:305)
net.liftweb.mapper.MetaMapper$class.save(MetaMapper.scala:577)
com.liftworkshop.model.User$$$M$5d72f813.save(User.scala:9)
com.liftworkshop.model.User$$$A$5d72f813.save()
com.liftworkshop.model.User$.save()
net.liftweb.mapper.Mapper$$anonfun$save$1.apply(Mapper.scala:84)
net.liftweb.mapper.Mapper$$anonfun$save$1.apply(Mapper.scala:84)
net.liftweb.util.ThreadGlobal.doWith(ThreadGlobal.scala:65)
net.liftweb.mapper.Safe$.runSafe(Safe.scala:44)
net.liftweb.mapper.Mapper$class.runSafe(Mapper.scala:50)
com.liftworkshop.model.User$$M$7ee2c84f.runSafe(User.scala:24)
com.liftworkshop.model.User$$A$7ee2c84f.runSafe()
com.liftworkshop.model.User.runSafe()
net.liftweb.mapper.Mapper$class.save(Mapper.scala:83)
com.liftworkshop.model.User$$M$7ee2c84f.save(User.scala:24)
com.liftworkshop.model.User$$A$7ee2c84f.save()
com.liftworkshop.model.User.save()
net.liftweb.mapper.MetaMegaProtoUser$class.testSignup$1(ProtoUser.scala:343)
net.liftweb.mapper.MetaMegaProtoUser$$anonfun$innerSignup$1$1.apply(ProtoUser.scala:360)
net.liftweb.mapper.MetaMegaProtoUser$$anonfun$innerSignup$1$1.apply(ProtoUser.scala:360)
net.liftweb.http.S$NFuncHolder$$anonfun$apply$46.apply(S.scala:941)
net.liftweb.http.S$NFuncHolder$$anonfun$apply$46.apply(S.scala:941)
scala.List.map(List.scala:805)
net.liftweb.http.S$NFuncHolder.apply(S.scala:941)
net.liftweb.http.LiftSession$$anonfun$buildFunc$1$2.apply(LiftSession.scala:307)
net.liftweb.http.LiftSession$$anonfun$5$$anonfun$apply$19.apply(LiftSession.scala:322)
net.liftweb.http.LiftSession$$anonfun$5$$anonfun$apply$19.apply(LiftSession.scala:322)
scala.List.map(List.scala:805)
net.liftweb.http.LiftSession$$anonfun$5.apply(LiftSession.scala:322)
net.liftweb.http.LiftSession$$anonfun$5.apply(LiftSession.sc