[Opensource] MySQL Connector/J 3.0.6 not compatible with JDK 1.3.1 on Redhat Linux

[Ken Chow]

I ran a problem while converting the Expresso Hypersonic database to MySQL 4.0.6 that 
may be of interest to others using MySQL with Expresso.

On Redhat Linux 8.0, when MySQL Connector/J 3.0.6 is used with JDK 1.3.1 (tried both 1.3.1_06 
and 1.3.1_07), the data returned appears to be encoded incorrectly and I get the error:

2003-03-31 03:18:20,960 ERROR [HttpProcessor[8080][4]] dbobj.DBObject (com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:6227)) - Database exception setting cache size - using zero
java.lang.NumberFormatException:
 at java.lang.Integer.parseInt(Integer.java:430)
 at java.lang.Integer.parseInt(Integer.java:458)
 at com.jcorporate.expresso.core.dbobj.DBObject.getFieldInt(DBObject.java:3375)
 at com.jcorporate.expresso.core.dbobj.DBObject.setCacheSize(DBObject.java:6221)
 at com.jcorporate.expresso.core.dbobj.DBObject.getCacheSize(DBObject.java:2720)
 at com.jcorporate.expresso.core.dbobj.DBObject.isCached(DBObject.java:4656)
 at com.jcorporate.expresso.core.dbobj.DBObject.retrieveFromCache(DBObject.java:5506)
 at com.jcorporate.expresso.core.dbobj.DBObject.find(DBObject.java:2354)
 at com.jcorporate.expresso.core.dbobj.SecuredDBObject.find(SecuredDBObject.java:358)
 at com.myrmex.expresso.core.dbobj.DefaultUserInfo.find(DefaultUserInfo.java:1349)
 at com.jcorporate.expresso.core.security.User.find(User.java:305)
 at com.jcorporate.expresso.core.servlet.CheckLogin.logInAsNone(CheckLogin.java:232)
 at com.jcorporate.expresso.core.servlet.CheckLogin.check(CheckLogin.java:199)
 at com.jcorporate.expresso.core.servlet.CheckLogin.checkLogin(CheckLogin.java:117)
 at org.apache.jsp.frame$jsp._jspService(frame$jsp.java:176)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)

When I used the same MySQL Connector/J 3.0.6 with JDK 1.3.1 on Windows XP, everything
works fine.

To resolve the problem on Redhat Linux 8.0, I had to upgrade to J2SDK 1.4.1_02

Note: I upgraded from jarkarta-tomcat 4.0.6 to 4.1.24 at the same time, but this is
unlikely to be a factor since I also tested MySQL Connector/J 3.0.6 with JDK 1.3.1 
and 1.4.1 using DbVisualizer (www.minq.se) and encountered similar problems.

Ken Chow



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.jcorporate.com/pipermail/opensource/attachments/20030401/601823d0/attachment-0002.htm