0 Replies Latest reply on Apr 4, 2002 3:02 AM by georges

    Bad network transfer rate with JDBC why?

    georges

      Hi !

      I have written an Web-Application that uses JBoss&Tomcat.
      I use Entity Beans for the DB-access. I have tested it local and it takes about 21s for inserting about 700 records. I use DB2 as DB. It doesn't differ if I use the
      net or app-Driver (local) the result is the same. But if I connect to a DB on an other PC in the LAN (Fast Ethernet) it takes abou 200s???? Why?, the network monitor doesn't shows any high traffic. If I use the DB2-Connect on the loacal machine to connect the DB on the other machine it works in 25s. This is okay. I guess
      that there are some parameters (packet-lenght MTU) or something to configure in JDBC or in JBoss. Are there any experiences??? My jboss.jcml is lke this


      COM.ibm.db2.jdbc.net.DB2Driver



      DB2
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:db2:192.168.0.1:6789/XIFS1DBX
      db2inst1
      db2inst1


      Thanks Dan