In Progress

MySQL/JDBC Problems

We use a MySQL connector (version 5.0.8) to connect from the JVM (on a local Windows 7 machine) to a remote MySQL Server (MySQL version is [url removed, login to view], the server is Ubuntu [url removed, login to view]).

We run the following basic code:

--------------------------------------------------

[url removed, login to view]("[url removed, login to view]").newInstance();

Connection conn = [url removed, login to view]("jdbc:mysql://***ip***/webdb", "root", "***password***);

try {

Statement st = [url removed, login to view]();

ResultSet rs = [url removed, login to view]("SELECT varchar_field_name FROM table_name"); // Should return about 9000 short results...

} finally {

[url removed, login to view]();

}

--------------------------------------------------

Yet for some reason, it gets stuck with the following stack trace:

at [url removed, login to view](Native Method)

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

- locked <0x00000000eb9eae20> (a [url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

- locked <0x00000000eb86a720> (a [url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

- locked <0x00000000eb86a720> (a [url removed, login to view])

- locked <0x00000000ebab4a68> (a [url removed, login to view])

at [url removed, login to view]([url removed, login to view])

And after a while we get a timeout. When we run the same code connecting to a localhost MySQL server, everything works fine.

We need someone who understands MySQL that can help us solve this issue.

Tom

Skills: Java, MySQL

See more: locked , get ubuntu version, driver select, java jdbc, mysql select statement, connecting timeout, trace stack, run ubuntu, mysql remote connection, basic ubuntu server, java problems, connection mysql, native mysql, mysql connect net, connect timeout, remote mysql connection, windows localhost, remote connection mysql, server mysql, method statement, windows locked, timeout, mysql statement, trace java, java native

About the Employer:
( 15 reviews ) Kefar Sava, Israel

Project ID: #2549875

17 freelancers are bidding on average $97 for this job

dobreiiita

Hi, I am JAVA expert and can surely help you here, Thanks

$100 USD in 1 day
(159 Reviews)
6.3
poornachand

Please check PM.

$50 USD in 2 days
(26 Reviews)
5.1
gafmxq

I can fix it for you very quickly because I encounter this problem before.

$60 USD in 1 day
(10 Reviews)
4.4
Loque

hi, i am interested in this project. please look for my pm

$100 USD in 1 day
(16 Reviews)
4.3
johnykoshy

I am an experienced Java/J2EE developer with experience in MYSQL database. I can fix this problem. Please check PM for more details.

$50 USD in 1 day
(5 Reviews)
4.0
armandogomes

Please check pmb :)

$200 USD in 7 days
(2 Reviews)
3.6
garhwalsatyapal

ready to work with you

$100 USD in 0 days
(3 Reviews)
3.5
gmAmaradasa

Hi mate kindly check your inbox...thank you

$75 USD in 1 day
(5 Reviews)
3.6
vm1988

Hi, I have Java and MySQL experience. Please check your PM for a possible solution.

$50 USD in 1 day
(3 Reviews)
3.0
utd2009

Hello Sir, I'm a MS graduate in CS from UT Dallas. I am currently working as a Java web developer. I also have a team who can solve this problem. We can definitely help u. Please allow us to help u. Thanks, utd More

$75 USD in 0 days
(3 Reviews)
2.7
santoshsoftware

Dear Customer, I am Oracle Certified Professional Java SE 6 Programmer and Oracle Certified Expert SQL Programmer. I can fix this problem.

$30 USD in 1 day
(1 Review)
2.3
rbollu

hi i have more than 10 years of experience on middleware development(specially on MySQl (7 yrs exp)). so i can easily fix your problem in one day itself expecting your bid thanks rbollu

$100 USD in 1 day
(0 Reviews)
0.0
shanki161

Hello Sir, We are having knowledge of MYSQL and the versions you have mentioned we have already worked on those. We need a bit more information to resolve [url removed, login to view] PMB so that we can [url removed, login to view] will solve this More

$100 USD in 2 days
(0 Reviews)
0.0
wcmanathunga

I am java expert sir. i can do this work for you. I am 5 years experienced java developer. i think i can sort out this situation. please check PMB.

$30 USD in 2 days
(0 Reviews)
0.0
mayurbd

I have already facing problem, but that is solving now a days. and working fine. Only operation on data base create that call object then working fine.

$200 USD in 1 day
(0 Reviews)
0.0
xjx922

I know the root cause.

$75 USD in 5 days
(0 Reviews)
0.0
surinder88

An OCPJP SE-6 Programmer here. Kindly check your PMB for more details. Thanks & Regards.

$250 USD in 3 days
(0 Reviews)
0.0