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

[Larry Hamel]

thanks, Ken, for both your informative posts.  we use mysql on a couple projects currently running on solaris, but they may go to linux next.

larry

At 12:59 AM 4/1/2003, you wrote:
>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 (<http://www.minq.se>www.minq.se) and encountered similar problems.
> 
>Ken Chow
> 
> 
>