This looks like an issue with PostgreSQLDriver. The type should be "DOUBLE PRECISION". What version of Lift are you using? Let me know and I'll put a fix in the proper place.
Derek On Sun, Jul 26, 2009 at 5:59 AM, JanWillem Tulp <janwillem.t...@gmail.com>wrote: > > Still looking to find a solution for this, or at least what causes > this behavior. I am looking at the Liftweb source code, and see in the > BaseMetaMapper trait a function called buildMapper that does some > pattern matching on SQL column types (colType). Just for my > understanding, why is there a match for almost any of the basic SQL > types, but not for Types.DOUBLE? > > Has anyone else run into this problem? > > On Jul 26, 1:34 am, JanWillem Tulp <janwillem.t...@gmail.com> wrote: > > Hi all, > > > > I'm not sure that I am missing something here, but the Schemifier > > cannot create a table for a model class that contains an object that > > extends from MappedDouble. > > > > This is the Lift code: > > > > class MeasureValue extends LongKeyedMapper[MeasureValue] with IdPK { > > def getSingleton = MeasureValue > > > > object value extends MappedDouble(this) > > object measure extends MappedLongForeignKey(this, Measure) > > > > } > > > > object MeasureValue extends MeasureValue with LongKeyedMetaMapper > > [MeasureValue] > > > > I added MeasureValue to the Schemifier so that it will create a table > > when boot is executed. However, this is the stacktrace I get when I > > start the application: > > > > main INFO lift - CREATE TABLE measurevalue (measure BIGINT , value > > DOUBLE , id BIGSERIAL) > > main ERROR lift - Failed to Boot > > org.postgresql.util.PSQLException: ERROR: type "double" does not exist > > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse > > (QueryExecutorImpl.java:1592) > > at org.postgresql.core.v3.QueryExecutorImpl.processResults > > (QueryExecutorImpl.java:1327) > > at org.postgresql.core.v3.QueryExecutorImpl.execute > > (QueryExecutorImpl.java:192) > > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute > > (AbstractJdbc2Statement.java:451) > > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags > > (AbstractJdbc2Statement.java:336) > > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute > > (AbstractJdbc2Statement.java:328) > > at net.liftweb.mapper.Schemifier$.net$liftweb$mapper$Schemifier$ > > $maybeWrite(Schemifier.scala:150) > > at net.liftweb.mapper.Schemifier$.net$liftweb$mapper$Schemifier$ > > $ensureTable(Schemifier.scala:160) > > at > net.liftweb.mapper.Schemifier$$anonfun$schemify$1$$anonfun$1.apply > > (Schemifier.scala:60) > > at > net.liftweb.mapper.Schemifier$$anonfun$schemify$1$$anonfun$1.apply > > (Schemifier.scala:60) > > at scala.List.foldLeft(List.scala:1066) > > at net.liftweb.mapper.Schemifier$$anonfun$schemify$1.apply > > (Schemifier.scala:60) > > at net.liftweb.mapper.Schemifier$$anonfun$schemify$1.apply > > (Schemifier.scala:54) > > at net.liftweb.mapper.DB$.use(DB.scala:305) > > at net.liftweb.mapper.Schemifier$.schemify(Schemifier.scala:53) > > at net.liftweb.mapper.Schemifier$.schemify(Schemifier.scala:36) > > at bootstrap.liftweb.Boot.boot(Boot.scala:26) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke > > (NativeMethodAccessorImpl.java:39) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke > > (DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:597) > > at net.liftweb.util.ClassHelpers$$anonfun$createInvoker$1.apply > > (ClassHelpers.scala:392) > > at net.liftweb.util.ClassHelpers$$anonfun$createInvoker$1.apply > > (ClassHelpers.scala:390) > > at net.liftweb.http.DefaultBootstrap$$anonfun$boot$1.apply > > (LiftRules.scala:909) > > at net.liftweb.http.DefaultBootstrap$$anonfun$boot$1.apply > > (LiftRules.scala:909) > > at net.liftweb.util.Full.map(Box.scala:330) > > at net.liftweb.http.DefaultBootstrap$.boot(LiftRules.scala:909) > > at net.liftweb.http.LiftFilter.bootLift(LiftServlet.scala:573) > > at net.liftweb.http.LiftFilter.init(LiftServlet.scala:548) > > at org.apache.catalina.core.ApplicationFilterConfig.getFilter > > (ApplicationFilterConfig.java:275) > > at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef > > (ApplicationFilterConfig.java:397) > > at org.apache.catalina.core.ApplicationFilterConfig.<init> > > (ApplicationFilterConfig.java:108) > > at org.apache.catalina.core.StandardContext.filterStart > > (StandardContext.java:3800) > > at org.apache.catalina.core.StandardContext.start > > (StandardContext.java:4450) > > at org.apache.catalina.core.ContainerBase.addChildInternal > > (ContainerBase.java:791) > > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java: > > 771) > > at > org.apache.catalina.core.StandardHost.addChild(StandardHost.java: > > 526) > > at org.apache.catalina.startup.HostConfig.deployDirectory > > (HostConfig.java:987) > > at org.apache.catalina.startup.HostConfig.deployDirectories > > (HostConfig.java:909) > > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java: > > 495) > > at > org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206) > > at org.apache.catalina.startup.HostConfig.lifecycleEvent > > (HostConfig.java:314) > > at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent > > (LifecycleSupport.java:119) > > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java: > > 1053) > > at > org.apache.catalina.core.StandardHost.start(StandardHost.java:722) > > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java: > > 1045) > > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java: > > 443) > > at org.apache.catalina.core.StandardService.start > > (StandardService.java:516) > > at > org.apache.catalina.core.StandardServer.start(StandardServer.java: > > 710) > > at org.apache.catalina.startup.Catalina.start(Catalina.java:583) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke > > (NativeMethodAccessorImpl.java:39) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke > > (DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:597) > > at > org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) > > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) > > > > I assume this is may be a JDBC problem perhaps? The name 'value' is > > not one of the reserved keywords in DB.scala (and I already checked if > > changing it to some arbitrary name would solve this problem). > > > > Software used: > > - PostgreSQL 8.4-701.jdbc4 for both database server and JDBC driver > > - Java jdk1.6.0_06 > > - Scala 2.7.5 > > - Liftweb 1.0 > > > > Any ideas? > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---