| 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

Calling C From Fortran 95; Bjork DJ Set; Z3 Example With Python; Week 1; Useful Guide To Starting With IJulia; UK Election + Media; Review: Reinventing Organizations; Inline Assembly With Julia / LLVM; Against the definition of types; Dumb Crypto Paper; The Search For Quasi-Periodicity...; Is There An Alternative To Processing?; CARDIAC (CARDboard Illustrative Aid to Computation); The Bolivian Case Against Chile At The Hague; Clear, Cogent Economic Arguments For Immigration; A Program To Say If I Am Working; Decent Cards For Ill People; New Photo; Luksic And Barrick Gold; President Bachelet's Speech; Baltimore Primer; libxml2 Parsing Stream; configure.ac Recipe For Library Path; The Davalos Affair For Idiots; Not The Onion: Google Fireside Chat w Kissinger; Bicycle Wheels, Inertia, and Energy; Another Tax Fraud; Google's Borg; A Verion That Redirects To Local HTTP Server; Spanish Accents For Idiots; Aluminium Cans; Advice on Spray Painting; Female View of Online Chat From a Male; UX Reading List; S4 Subgroups - Geometric Interpretation; Fucking Email; The SQM Affair For Idiots; Using Kolmogorov Complexity; Oblique Strategies in bash; Curses Tools; Markov Chain Monte Carlo Without all the Bullshit; Email Para Matias Godoy Mercado; The Penta Affair For Idiots; Example Code To Create numpy Array in C; Good Article on Bias in Graphic Design (NYTimes); Do You Backup github?; Data Mining Books; SimpleDateFormat should be synchronized; British Words; Chinese Govt Intercepts External Web To DDOS github; Numbering Permutations; Teenage Engineering - Low Price Synths; GCHQ Can Do Whatever It Wants; Dublinesque; A Cryptographic SAT Solver; Security Challenges; Word Lists for Crosswords; 3D Printing and Speaker Design; Searchable Snowden Archive; XCode Backdoored; Derived Apps Have Malware (CIA); Rowhammer - Hacking Software Via Hardware (DRAM) Bugs; Immutable SQL Database (Kinda); Tor GPS Tracker; That PyCon Dongle Mess...; ASCII Fluid Dynamics; Brandalism; Table of Shifter, Cassette and Derailleur Compatability; Lenovo Demonstrates How Bad HTTPS Is; Telegraph Owned by HSBC; Smaptop - Sunrise (Music); Equation Group (NSA); UK Torture in NI; And - A Natural Extension To Regexps; This Is The Future Of Religion; The Shazam (Music Matching) Algorithm; Tributes To Lesbian Community From AIDS Survivors; Nice Rust Summary; List of Good Fiction Books; Constructing JSON From Postgres (Part 2); Constructing JSON From Postgres (Part 1); Postgres in Docker; Why Poor Places Are More Diverse; Smart Writing on Graceland; Satire in France; Free Speech in France; MTB Cornering - Where Should We Point Our Thrusters?; Secure Secure Shell; Java Generics over Primitives; 2014 (Charlie Brooker); How I am 7; Neural Nets Applied to Go; Programming, Business, Social Contracts; Distributed Systems for Fun and Profit; XML and Scheme; Internet Radio Stations (Curated List); Solid Data About Placebos; Half of Americans Think Climate Change Is a Sign of the Apocalypse; Saturday Surf Sessions With Juvenile Delinquents; Ssh, tty, stdout and stderr; Feathers falling in a vacuum; Santiago 30m Bike Route

© 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