Oracle: Invalid column type

[jkleiser]

Oracle: Invalid column type

[dchenbecker]

Based on this line:

oracle.jdbc.driver.
OraclePreparedStatement.setObject(OraclePreparedStatement.java:9316)

I have a feeling that we're handing an Object to the driver that doesn't map correctly to the type of the column. For instance, we could be handing a Long to something with type DOUBLE. Normally JDBC drivers attempt to coerce the object based on internal mappings but they don't always match up the same between vendors in my experience. In particular, the fact that "validated" and "superuser" are being defined as NUMBER (because Oracle's JDBC driver doesn't support boolean, http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#34_05) makes me think that we're handing a java Boolean to the driver. I think that this should be a simple fix with an extra case statement in MetaMapper.

[dchenbecker]

OK, preliminary fix to be test in wip-dcb-1.0-oracle-fix. Jon will let me know how it goes.

[dchenbecker]

New fix in1.0.1-SNAPSHOT (eda5e86092fec035b3f6326e05ba75fa1396b4bc). Working on 1.0.1 final release

[dchenbecker]

Fixed in 1.0.1 (3c13b5c09bda27e72a64bf577247424074e129b3) and 1.1-SNAPSHOT (b5d2fe5e75552a99ebc6cda5b5a2d2dc2b0a2f3c)

[github-importer]

Imported from GitHub: http://github.com/dpp/liftweb/issues/37/find

[github-importer]

Imported from Assembla: http://www.assembla.com/spaces/liftweb/tickets/37