myEclipse读取数据库信息特别慢，求大神帮忙！

[winy_snow]

同学跟我一样的代码，速度就一点问题没有。
我的跟他的相比，每次连接读取数据库信息（mysql）的时候出现了很多状态码，我想着可能是慢的一个原因。

Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:236 com.mysql.jdbc.ByteArrayBuffer.readLenByteArray(0)
Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:200 com.mysql.jdbc.ByteArrayBuffer.readFieldLength()
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:200 com.mysql.jdbc.ByteArrayBuffer.readFieldLength(..) returning 1
Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:128 com.mysql.jdbc.ByteArrayBuffer.getBytes(1)
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:128 com.mysql.jdbc.ByteArrayBuffer.getBytes(..) returning [B@79cf8d60
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:236 com.mysql.jdbc.ByteArrayBuffer.readLenByteArray(..) returning [B@79cf8d60
Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:236 com.mysql.jdbc.ByteArrayBuffer.readLenByteArray(0)

Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:200 com.mysql.jdbc.ByteArrayBuffer.readFieldLength()
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:200 com.mysql.jdbc.ByteArrayBuffer.readFieldLength(..) returning 1
Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:128 com.mysql.jdbc.ByteArrayBuffer.getBytes(1)
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:128 com.mysql.jdbc.ByteArrayBuffer.getBytes(..) returning [B@294ad81a
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:236 com.mysql.jdbc.ByteArrayBuffer.readLenByteArray(..) returning [B@294ad81a
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- MysqlIO.java:1316 com.mysql.jdbc.MysqlIO.nextRow(..) returning [[B@70b1a823
Mon Apr 09 20:40:10 CST 2012 TRACE: --> MysqlIO.java:1316 com.mysql.jdbc.MysqlIO.nextRow([Lcom.mysql.jdbc.Field;@336eb995, 2, false, 1007)

Mon Apr 09 20:40:10 CST 2012 TRACE: --> MysqlIO.java:798 com.mysql.jdbc.MysqlIO.checkErrorPacket()
Mon Apr 09 20:40:10 CST 2012 TRACE: --> MysqlIO.java:2900 com.mysql.jdbc.MysqlIO.checkErrorPacket(-1)
Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:162 com.mysql.jdbc.ByteArrayBuffer.getPosition()
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:162 com.mysql.jdbc.ByteArrayBuffer.getPosition(..) returning 4
Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:115 com.mysql.jdbc.ByteArrayBuffer.getBufLength()

Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:115 com.mysql.jdbc.ByteArrayBuffer.getBufLength(..) returning 4
Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:141 com.mysql.jdbc.ByteArrayBuffer.getBytes(0, 4)
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:141 com.mysql.jdbc.ByteArrayBuffer.getBytes(..) returning [B@1f95cba2
Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:115 com.mysql.jdbc.ByteArrayBuffer.getBufLength()

Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:115 com.mysql.jdbc.ByteArrayBuffer.getBufLength(..) returning 4
Mon Apr 09 20:40:10 CST 2012 TRACE: --> MysqlIO.java:2376 com.mysql.jdbc.MysqlIO.reuseAndReadPacket(Network packet, data follows:

01 31 01 31 . 1 . 1


)
Mon Apr 09 20:40:10 CST 2012 TRACE: --> Buffer.java:238 com.mysql.jdbc.Buffer.setWasMultiPacket(false)
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- Buffer.java:238 com.mysql.jdbc.Buffer.setWasMultiPacket(..) returning null

Mon Apr 09 20:40:10 CST 2012 TRACE: --> MysqlIO.java:1924 com.mysql.jdbc.MysqlIO.readFully(com.mysql.jdbc.util.ReadAheadInputStream@6fc50837, [B@709e8c34, 0, 4)
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- MysqlIO.java:1924 com.mysql.jdbc.MysqlIO.readFully(..) returning 4
Mon Apr 09 20:40:10 CST 2012 TRACE: --> ByteArrayBuffer.java:387 com.mysql.jdbc.ByteArrayBuffer.setPosition(0)
Mon Apr 09 20:40:10 CST 2012 TRACE: <-- ByteArrayBuffer.java:387 com.mysql.jdbc.ByteArrayBuffer.setPosition(..) returning null

[winy_snow]

在线急等！！！求大神……

[winy_snow]

好多好多的状态码，人家0.几s。我要10多s，太愁人了！！！求大神……

[新铺村长]

我也遇到同样的问题啊
同求解啊

[JANESTAR]

我也是遇到这样的问题

[花谢尊前不敢香]

你项目开的太多了，看看sever下面的tomcat是不是有好多项目都在开着。

[winy_snow]

有答案了，是驱动版本太低了~之前用的是3.1.4改成5.0就ok了~

[ah_zqx]

引用 5 楼 fangmingshijie 的回复:

你项目开的太多了，看看sever下面的tomcat是不是有好多项目都在开着。

什么驱动版本，是jdk吗？