File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Derby runs in windows machine and try to connect from linux is slow Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Derby runs in windows machine and try to connect from linux is slow" Watch "Derby runs in windows machine and try to connect from linux is slow" New topic
Author

Derby runs in windows machine and try to connect from linux is slow

ansar Iqbal
Greenhorn

Joined: Aug 31, 2012
Posts: 1
Hi,

I am new bie to Apache Derby, i have been asked to test the performance of Derby database with 1000 concurrent Threads, In each thread open a connection do one insert, select, update quries on one table.

I implemented the simulation code and tested in my local machine (Windows 7) where i am running my Derby database in networking mode.

Even i tested the same from another Windows 7 machine (Only Java Client, DB is running in my Machine only) from my LAN.

When i am testing above simulation from Ubuntu System, i am facing lot of issues. For opening each connection it is taking 5xxx milliseconds, where as in other scenaios it is 2xx milliseconds.

If i am simulating upto 1000 threads means the time also increasing to get each connection. Typically it is above 60000 milliseconds.

I observed that from wireshark is listing the follwoing error in case of Ubuntu system.

Protocol : ICMP

Info : Destination unreachable (Port unreachable).

Surprisingly when i installed kaspersky in ubuntu machine i am not getting this error. I am able to get connection with in 3xx milliseconds like that.

I tried with implementing the Connection Pool (Tomcat pool, DBCP, C3p0) also.

In any case with out antivirus in ubuntu machine it is taking too much time to get the connection and i am seeing the above error in Wireshark.

Please help me in this what could be catch here ?


Thanks in Advance.


Regards
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Derby runs in windows machine and try to connect from linux is slow
 
Similar Threads
Connection Pooling help needed
Communications link failure with MySQL
Connection Pooling help needed
JDBC Coonection Pooling in a multithreaded Web application
Tomcat 6 creating Swing GUI under Windows 7 64bit