| Bug #25787 | getObject on a java.util.Date returns java.langString (Linux) | ||
|---|---|---|---|
| Submitted: | 23 Jan 2007 15:24 | Modified: | 27 Feb 2007 13:50 |
| Reporter: | A M | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / J | Severity: | S2 (Serious) |
| Version: | Kernel: 2.6.16.21-0.25-bigsmp | OS: | Linux (Suse Linux ) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | jdbc, linux | ||
[23 Jan 2007 18:12]
Mark Matthews
If you want to store something date-time like, you should be using either java.sql.Date or java.sql.Timestamp. If you're trying to serialize an object, the underlying column needs to be a BINARY type ([var]binary or some sort of blob). Since you didn't post your schema, we can't tell if what you're doing should even work at all. Please post the schema of the table you're using.
[23 Jan 2007 18:42]
A M
The field which I'm referring to is a BLOB field.
CREATE TABLE 'TABLE1' ('ROW_ID' INT NOT NULL AUTO_INCREMENT PRIMARY_KEY, 'MY_OBJECT_FIELD'BLOB NULL) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
[13 Feb 2007 20:25]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/19797
[22 Feb 2007 14:24]
MC Brown
A note has been added to the 5.0.5 changelog.
[27 Feb 2007 13:50]
MC Brown
Confirmed in 5.0.5 changelog.
Description: When I store ajava.util.Date object via JDBC using setObject() method and then try to retrieve it using getObject() method, I get back a java.lang.String Object and not java.util.Date Object as I expected. How to repeat: // Store the date object PreparedStatement ps = conn.prepareStatement("INSERT INTO ... "); ps.setObject(1, new Date()); ps.execute(); // Get the date object PreparedStatement ps = conn.prepareStatement("SELECT * FROM ... "); ResultSet res = ps.executeQuery(); if (res.next) res.getObject("MY_OBJECT_FIELD");