Re: JDBC Connection Issue

From:

=?ISO-8859-1?Q?Arne_Vajh=F8j?= <arne@vajhoej.dk>

Newsgroups:

comp.lang.java.programmer

Date:

Wed, 10 Mar 2010 21:45:47 -0500

Message-ID:

<4b985956$0$283$14726298@news.sunsite.dk>

On 09-03-2010 23:44, jross wrote:

I'm running a simple perl script that checks if port 3306(mysql) is open
or not and display's either PASSED or FAILED

Perl Code: http://pastebin.org/108205

This small script seems to be working fine, but when I put into place
our java applications that are using mysql though the jdbc driver
started to crash (The services crash over night after a jboss restart).

I started to do some testing and made a small java class to replicate
what our java apps are doing

Java Code: http://pastebin.org/108202

Running both these scripts at the some time seemed to be ok, but after a
while the jdbc driver was complaining about

"Server configuration denies access to data source"

Are you sure that you always get the connections closed ?

The perl script is closing the socket correctly, but I'm not sure if the
jdbc driver is closing the sockets correctly??

It could be something in the java code. I did have java complaining
about the stack size saying "increase stack size with ulimit -s ". I
increased the stack size and got an error which was logged, I have
attached the log to this email.

What I'm using:

JDBC Driver: mysql-connector-java-2.0.14-bin.jar
JAVA: j2sdk1.4.2_10
Perl: v5.10.0
OS: Fedora Core 4

The log files says:

Java VM: Java HotSpot(TM) Client VM (1.3.1_18-b01 mixed mode)

Arne