mysql JDBC tomcat

[tony.chamberlain@xxxxxxxxx]

 

Perhaps there is a mysql group I could ask?  But I will ask here anyway.

Someone is using java and tomcat and mysql.  Accessing mysql on 10.0.0.66
from 10.10.0.2.  They are pingable from each other but go through gateway
10.10.0.30.

And mysql -h 10.0.0.66  
from 10.10.0.2 returns a prompt after a while.

However using jdbc times out even with a timeout of 70000.  Here is the command:


jdbc:mysql://10.0.0.66/dma_oam?useUnicode=true&characterEncoding=Big5&socketTimeout=700000&connectTimeout=700000   id
(id omitted from this message for security reasons)

This is being executed from Java. 

And to repeat, when it was used before there were 1 hop from server machine to host machine (like here):
> traceroute to 10.0.0.50 (10.0.0.50), 30 hops max, 38 byte packets
>  1  10.0.0.50 (10.0.0.50)  1.158 ms  0.198 ms  0.186 ms
but in this case there are two
> traceroute to 10.0.0.66 (10.0.0.66), 30 hops max, 38 byte packets
>  1  10.10.0.30 (10.10.0.30)  20.068 ms  19.775 ms  19.806 ms
>  2  10.0.0.66 (10.0.0.66)  24.404 ms  23.240 ms  23.249 ms


Could this be the reason for the timeout?  Can jdbc not hop?


if you are interested, here is a stack backtrace

java.net.SocketTimeoutException: Read timed out
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:129)
        at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
        at java.io.BufferedInputStream.read1(BufferedInputStream.java:258)
        at java.io.BufferedInputStream.read(BufferedInputStream.java:317)
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1316)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1463)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1854)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
        at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1164)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2087)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2037)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1156)
        at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:2753)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1671)
        at com.mysql.jdbc.Connection.<init>(Connection.java:432)

-- 
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list