Is something up with applying By to a MappedBoolean?

[E. Biggs]

When I try to apply By to a MappedBoolean like so:

Table.findAll(By(Table.booleanField, false)); derby is unhappy and
bombs out on some sql with this kind of where clause:

WHERE Table.booleanfield = ?

Is this a bug or am I doing something wrong? I'm using 1.1-SNAPSHOT

[Timothy Perrett]

Is there an exception? If so could you post the entire trace?

Cheers, Tim

[E. Biggs]

here's my derby log:

Cannot find the network server class,
org.apache.derby.impl.drda.NetworkServerControlImpl. Your class path
should contain derbynet.jar.
----------------------------------------------------------------
2009-06-03 02:18:26.023 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby -
10.4.2.0 - (689064): instance a816c00e-0121-a3e9-03ce-000000c22fe0
on database directory /Users/ebiggs/Documents/workspace/maps/
lift_example

Database Class Loader started - derby.database.classpath=''
2009-06-03 02:18:27.693 GMT Thread[Thread-14,5,main] (XID = 437),
(SESSIONID = 0), (DATABASE = lift_example), (DRDAID = null), Cleanup
action starting
2009-06-03 02:18:27.693 GMT Thread[Thread-14,5,main] (XID = 437),
(SESSIONID = 0), (DATABASE = lift_example), (DRDAID = null), Failed
Statement is: SELECT DISTINCT Property.id, Property.propertygroup,
Property.streetnumber, Property.street, Property.unit, Property.city,
Property.state, Property.zip, Property.price, Property.dom,
Property.beds, Property.baths, Property.lotsize, Property.sqft,
Property.status, Property.orgprice, Property.proptype,
Property.numpricechanges, Property.spop, Property.dollarstosqft,
Property.yearbuilt, Property.date_c, Property.geocodesuccess,
Property.lat, Property.long_c, Property.geocodeattempted FROM
Property WHERE geocodeattempted = ?
java.lang.NullPointerException
at java.io.StringReader.<init>(StringReader.java:33)
at org.apache.derby.impl.services.uuid.BasicUUID.<init>(Unknown
Source)
at org.apache.derby.impl.services.uuid.BasicUUIDFactory.recreateUUID
(Unknown Source)
at
org.apache.derby.impl.sql.catalog.SYSCONGLOMERATESRowFactory.buildDescriptor
(Unknown Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getDescriptorViaIndexMinion
(Unknown Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getDescriptorViaIndex
(Unknown Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getConglomerateDescriptorsScan
(Unknown Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.finishTableDescriptor
(Unknown Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getTableDescriptorIndex1Scan
(Unknown Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getUncachedTableDescriptor
(Unknown Source)
at org.apache.derby.impl.sql.catalog.NameTDCacheable.setIdentity
(Unknown Source)
at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getTableDescriptor
(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getTableDescriptor
(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor
(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables
(Unknown Source)
at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables
(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables
(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown
Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown
Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement
(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement
(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement
(Unknown Source)
at net.liftweb.mapper.DB$$anonfun$prepareStatement$1.apply(DB.scala:
278)
at net.liftweb.mapper.DB$$anonfun$prepareStatement$1.apply(DB.scala:
277)
at net.liftweb.util.TimeHelpers$class.calcTime(TimeHelpers.scala:241)
at net.liftweb.util.Helpers$.calcTime(Helpers.scala:29)
at net.liftweb.mapper.DB$.prepareStatement(DB.scala:277)
at net.liftweb.mapper.MetaMapper$$anonfun$findMapFieldDb$1.apply
(MetaMapper.scala:306)
at net.liftweb.mapper.MetaMapper$$anonfun$findMapFieldDb$1.apply
(MetaMapper.scala:298)
at net.liftweb.mapper.DB$.use(DB.scala:305)
at net.liftweb.mapper.MetaMapper$class.findMapFieldDb
(MetaMapper.scala:297)
at com.yo.model.Property$.findMapFieldDb(Property.scala:5)
at net.liftweb.mapper.MetaMapper$class.findMapDb(MetaMapper.scala:
293)
at com.yo.model.Property$.findMapDb(Property.scala:5)
at net.liftweb.mapper.MetaMapper$class.findAll(MetaMapper.scala:259)
at com.yo.model.Property$.findAll(Property.scala:5)
at com.yo.controller.Geocoder$.beginGoogleGeocoding(Geocoder.scala:
33)
at com.yo.controller.Geocoder$.beginGeocoding(Geocoder.scala:29)
at com.yo.controller.Geocoder$$anonfun$act$1$$anonfun$apply$1.apply
(Geocoder.scala:23)
at com.yo.controller.Geocoder$$anonfun$act$1$$anonfun$apply$1.apply
(Geocoder.scala:21)
at scala.actors.Reaction.run(Reaction.scala:78)
at scala.actors.Scheduler$$anon$2.run(Scheduler.scala:77)
at scala.actors.FJTaskRunner.scanWhileIdling(Unknown Source)
at scala.actors.FJTaskRunner.run(Unknown Source)
Cleanup action completed

[E. Biggs]

Any Ideas? I've tried distilling this down to just a most basic
example:


object BoolTest extends BoolTest with KeyedMetaMapper[Long, BoolTest]
{
override def dbTableName = "BoolTest"
override def fieldOrder = id :: testField :: Nil
}

class BoolTest extends KeyedMapper[Long, BoolTest] {
def getSingleton = BoolTest
def primaryKeyField = id

object id extends MappedLongIndex(this)

object testField extends MappedBoolean(this)
}


And I still get:
2009-06-15 10:06:44.163 GMT Thread[Thread-14,5,main] (XID = 489),

(SESSIONID = 0), (DATABASE = lift_example), (DRDAID = null), Failed

Statement is: SELECT DISTINCT BoolTest.id, BoolTest.testfield FROM
BoolTest WHERE testfield = ?

When I do:

val abc = BoolTest.findAll(By(BoolTest.testField, true))

on start up.


Any ideas? Or should I report a bug or what?

[E. Biggs]

an indication at this point that somebody cares about this besides me
would be like gold....

At this point, I'm assuming it's a bug and am fumbling through the
mapping code which is taking me a bit of time to understand....

[David Pollak]

Please open a ticket at http://github.com/dpp/liftweb/issues

I know Derek has closed a fair number of related tickets.  Also, please make sure you're using 1.1-SNAPSHOT

--
Lift, the simply functional web framework http://liftweb.net
Beginning Scala http://www.apress.com/book/view/1430219890
Follow me: http://twitter.com/dpp
Git some: http://github.com/dpp

[Derek Chen-Becker]

I was starting to look at this (and the MappedStringIndex issue) but I'm swamped with my day job right now. Please open an issue and I'll look at it hopefully in the next week or two.

Derek