Hi Derek,
you fix worked!! The schemifier has successfully created a table with
a column of type DOUBLE PRECISION.
JanWillem
On Jul 31, 9:28 am, JanWillem Tulp <janwillem.t...@gmail.com> wrote:
> Thanks, yes, I'll try tomorrow and let you know!
>
> On Jul 29, 12:43 am, Derek Chen-Becker <dchenbec...@gmail.com> wrote:
>
>
>
> > OK, I've pushed 1.0.1-SNAPSHOT to the repo with something that should fix
> > the PostgreSQL stuff. Can you update your POM to 1.0.1-SNAPSHOT and try it?
>
> > Thanks,
>
> > Derek
>
> > On Tue, Jul 28, 2009 at 11:40 AM, JanWillem Tulp
> > <janwillem.t...@gmail.com>wrote:
>
> > > 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
-~----------~----~----~----~------~----~------~--~---
