driver question

[Scott Purcell]

Hello
I am using org.gjt.mm.mysql.Driver to connect a web-app to a mysql database. I ran into an
error, I could use some help with.
 
I have a database that has a timestamp field
CREATE TABLE FOO (
       create_date TIMESTAMP,
       approved_date TIMESTAMP,
) TYPE=InnoDB;
 
Now when I insert into foo, I insert the create_date of course when new foo records are
inserted. But I do not insert anything for the approved_date, because the foo is not
known yet. Anyway what I found was a problem. When using the driver, and I say select *
from foo, I get the following error, which makes sense, because it says it cannot convert
00000000000000 which is null of course. 
 
So is this a driver problem, or just the way the driver handles the data? Any ideas how to
get around this?
 
 
Thanks,
Scott
 
 
 
java.sql.SQLException: Cannot convert value '00000000000000' from column 12 to T
IMESTAMP.
        at com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:5294)
        at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:2217)
        at com.mysql.jdbc.ResultSet.getString(ResultSet.java:2132)
        at com.skp.sql.Row.<init>(Row.java:27)
        at com.skp.sql.DBConn.getRows(DBConn.java:255)
        at com.skp.sql.DBConn.getRows(DBConn.java:220)
        at com.skp.bean.AssetBean.ShowAllAssets(AssetBean.java:30)
        at com.skp.bean.AssetBean.<init>(AssetBean.java:19)
        at com.skp.taglib.displayAssetTag.doStartTag(displayAssetTag.java:43)
        at org.apache.jsp.manageAssets_jsp._jspx_meth_menu_displayAssets_0(manag
eAssets_jsp.java:243)
        at org.apache.jsp.manageAssets_jsp._jspService(manageAssets_jsp.java:170
)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:162)