| Andrew Cooke | Contents | Latest | RSS | Twitter | Previous | Next

C[omp]ute

Welcome to my blog, which was once a mailing list of the same name and is still generated by mail. Please reply via the "comment" links.

Always interested in offers/projects/new ideas. Eclectic experience in fields like: numerical computing; Python web; Java enterprise; functional languages; GPGPU; SQL databases; etc. Based in Santiago, Chile; telecommute worldwide. CV; email.

Personal Projects

Lepl parser for Python.

Colorless Green.

Photography around Santiago.

SVG experiment.

Professional Portfolio

Calibration of seismometers.

Data access via web services.

Cache rewrite.

Extending OpenSSH.

C-ORM: docs, API.

Last 100 entries

Payroll Service Quotes for Cat Soft LLC; (Beating Dead Horse) StackOverflow; Current State of Justice in China; Now Is Cat Soft LLC's Chance To Save Up To 32% On Mail; Axiom of Determinacy; Ewww; Fee Chaos Book; Course on Differential Geometry; Increase Efficiency with GPS Vehicle Tracking for Cat Soft LLC; Okay, but...; Sparse Matrices, Deep Learning; Sounds Bad; Applebaum Rape; Tomato Chutney v4; Have to add...; Culturally Liberal and Nothing More; Weird Finite / Infinite Result; Your diamond is a beaten up mess; Maths Books; Good Bike Route from Providencia / Las Condes to Panul\; Iain Pears (Author of Complex Plots); Plum Jam; Excellent; More Recently; For a moment I forgot StackOverflow sucked; A Few Weeks On...; Chilean Book Recommendations; How To Write Shared Libraries; Jenny Erpenbeck (Author); Dijkstra, Coins, Tables; Python libraries error on OpenSuse; Deserving Trump; And Smugness; McCloskey Economics Trilogy; cmocka - Mocks for C; Concept Creep (Americans); Futhark - OpenCL Language; Moved / Gone; Fan and USB issues; Burgers in Santiago; The Origin of Icosahedral Symmetry in Viruses; autoenum on PyPI; Jars Explains; Tomato Chutney v3; REST; US Elections and Gender: 24 Point Swing; PPPoE on OpenSuse Leap 42.1; SuperMicro X10SDV-TLN4F/F with Opensuse Leap 42.1; Big Data AI Could Be Very Bad Indeed....; Cornering; Postcapitalism (Paul Mason); Black Science Fiction; Git is not a CDN; Mining of Massive Data Sets; Rachel Kaadzi Ghansah; How great republics meet their end; Raspberry, Strawberry and Banana Jam; Interesting Dead Areas of Math; Later Taste; For Sale; Death By Bean; It's Good!; Tomato Chutney v2; Time ATAC MX 2 Pedals - First Impressions; Online Chilean Crafts; Intellectual Variety; Taste + Texture; Time Invariance and Gauge Symmetry; Jodorowsky; Tomato Chutney; Analysis of Support for Trump; Indian SF; TP-Link TL-WR841N DNS TCP Bug; TP-Link TL-WR841N as Wireless Bridge; Sending Email On Time; Maybe run a command; Sterile Neutrinos; Strawberry and Banana Jam; The Best Of All Possible Worlds; Kenzaburo Oe: The Changeling; Peach Jam; Taste Test; Strawberry and Raspberry Jam; flac to mp3 on OpenSuse 42.1; Also, Sebald; Kenzaburo Oe Interview; Otake (Kitani Minoru) move Black 121; Is free speech in British universities under threat?; I am actually good at computers; Was This Mansplaining?; WebFaction / LetsEncrypt / General Disappointment; Sensible Philosophy of Science; George Ellis; Misplaced Intuition and Online Communities; More Reading About Japan; Visibilty / Public Comments / Domestic Violence; Ferias de Santiago; More (Clearly Deliberate); Deleted Obit Post; And then a 50 yo male posts this...; We Have Both Kinds Of Contributors

© 2006-2015 Andrew Cooke (site) / post authors (content).

iBatis Error with Recursive Generics

From: "andrew cooke" <andrew@...>

Date: Wed, 3 Sep 2008 13:10:01 -0400 (CLT)

I have a base class for ORM that looks something like this:

public class Keyed<KeyType extends Comparable<KeyType>>
implements Comparable<Keyed<KeyType>>
{
  private KeyType key;
  protected final void setKey(final KeyType key) {...}
  ...
}

For some reason, iBatis does not like this, even thought it was fine (as
far as I can tell) with an earlier version that was also generic (but did
not include the recursive Comparable declaration).

The error when you try to map (sublasses of) this is given below (in full
for Google).

I tried tracking what was causing this, and it seems that the type handler
is not inferred correctly while reading the configuration.  Rather than
digging further I found a simple workaround - specify the type handler by
hand.

So my maps now look like:

<sqlMap namespace="entity">
  <resultMap id="entity-result" class="...Entity">
    <result property="key" column="entity_id"
     typeHandler="com.ibatis.sqlmap.engine.type.StringTypeHandler"/>
    <result property="title" column="title"/>
    <result property="description" column="description"/>
    ...
  </resultMap>
  ...
</sqlMap>

Note the explicit typeHandler.

Andrew


03-Sep-2008 13:06:32 com.isti.kpidb.KpiDb getEntities
SEVERE: Failed to read Entities
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in maps/entity.xml.
--- The error occurred while applying a result map.
--- Check the entity.entity-result.
--- Check the result mapping for the 'key' property.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler could
be found to map the property 'key' to the column 'entity_id'.  One or both
of the types, or the combination of types is not supported.
	at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:204)
	at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
	at
com.ibatis.sqlmap.engine.mapping.statement.CachingStatement.executeQueryForList(CachingStatement.java:97)
	at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
	at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
	at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
	at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
	at com.isti.kpidb.KpiDb.queryForList(KpiDb.java:331)
	at com.isti.kpidb.KpiDb.queryForList(KpiDb.java:311)
	at com.isti.kpidb.KpiDb.getEntities(KpiDb.java:102)
	at com.isti.kpidb.demo.ListEntities.execute(ListEntities.java:23)
	at com.isti.kpidb.demo.Demo.processInput(Demo.java:125)
	at com.isti.kpidb.demo.Demo.mainLoop(Demo.java:84)
	at com.isti.kpidb.demo.Demo.<init>(Demo.java:58)
	at com.isti.kpidb.demo.Demo.main(Demo.java:183)
Caused by: com.ibatis.sqlmap.client.SqlMapException: No type handler could
be found to map the property 'key' to the column 'entity_id'.  One or both
of the types, or the combination of types is not supported.
	at
com.ibatis.sqlmap.engine.mapping.result.ResultMap.getPrimitiveResultMappingValue(ResultMap.java:613)
	at
com.ibatis.sqlmap.engine.mapping.result.ResultMap.getResults(ResultMap.java:345)
	at
com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:384)
	at
com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:300)
	at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:189)
	at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
	at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
	... 14 more

Probably due to Erasure

From: "andrew cooke" <andrew@...>

Date: Mon, 8 Sep 2008 19:36:57 -0400 (CLT)

I just realised what is causing this while looking through Wadler's book
to see if I could find something else (this is on p122).

The erased type for Keyed<KeyType extends Comparable<KeyType>>
 is going to be Comparable, rather than Object.  It would probably work OK
with Keyed<KeyType extends Object & Comparable<KeyType>>

Andrew

Confirmation - Type Erasure, not Recursion

From: "andrew cooke" <andrew@...>

Date: Thu, 11 Sep 2008 11:19:48 -0400 (CLT)

Just to confirm, the issue was type erasure, not the recursive generic
declaration.

Everything works fine (without explicit type handlers) if I use
  Keyed<KeyType extends Object & Comparable<KeyType>>
(with the leading "Object &")

Andrew

Still Not Simple

From: "andrew cooke" <andrew@...>

Date: Mon, 6 Oct 2008 15:43:49 -0400 (CLT)

It's not that simple, because iBatis will see a "Object" and use whatever
type it feels like.  This may not be consistent with the actual
implementation.

For example, I have a generic base class that has a "key" attribute.  When
used with Oracle, the integer key value was being set as a BigDecimal.  I
then got a class cast exception at some random moment when code that
compiled fine with <Integer> tried to access the BigDecimal key.

So the moral of the story is: either avoid generics, or give explicit type
handlers.  Since I like my Java code as it is, I'm going with the type
handlers for now.

Andrew

Comment on this post