Hi Derek, I am using liftweb version 1.0
Thanks! On Jul 27, 10:27 pm, Derek Chen-Becker <dchenbec...@gmail.com> wrote: > 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 -~----------~----~----~----~------~----~------~--~---