This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

big problem with database connection

Posted by Chin Loong on January 20, 2002 at 5:10 PM

hey guys,

anybody could help me to diagnose this problem? i'm using a kind of connection pooling program, quite simple one that reuse connections to databse. i think it's DBConnection Broker or something like. the thing is, now i migrated my database from mySQL to MS access, and connections gets very slow after the second getConnection() call. after i change the variable of MIN and MAX connections both to 1, it becomes better, but now it will get slow, not after the second time, but probably after around 20 times of getConnection() call.

now, i can't think of the problem. i freed the connection after every usage (before another getConnection() call), but it still gets slow after like 3 minutes of using. it's *extremely* slow. every database call will take like 10 seconds to finish, and my update buttons (which will execute the database queries and/or updates) will stay pressed for the time period when this database calling is done. and i can't do anything else, even closing the application.

what could be wrong? :(

• big problem with database connection Matt Gerrans January 21, 2002 at 10:13 PM (2)
  • huge huge database problem Chin Loong January 22, 2002 at 10:13 AM (1)
    • still hasn't been solved Chin Loong January 23, 2002 at 7:41 PM (0)