Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
|
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 13th, 2005, 02:49 AM
Registered User
 
Join Date: Mar 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to Stephen Lam
Default Read First!! I need you o help :-)

Dear all,

How are you. I have problem cannot solve.
Please help me to solve the problem. :-)

I capture the error message here.

What is
localhost:3306 port running??
I mySQL database is set to 3306.



SecureConnectionServerMain.connect(): {user=projava, password=sasquatch}
Trying to connect to: rmi://localhost:1099/SecureDriver
Security manager set to java.rmi.RMISecurityManager@121f1d
java.sql.SQLException: Communication failure during handshake. Is there a server
 running on localhost:3306?
        at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:275)
        at org.gjt.mm.mysql.Connection.<init>(Connection.java :230)
        at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
        at java.sql.DriverManager.getConnection(DriverManager .java:512)
        at java.sql.DriverManager.getConnection(DriverManager .java:171)
        at com.isnetworks.crypto.database.server.SimpleDataso urceManager$Datasou
rce.getConnection(SimpleDatasourceManager.java:124 )
        at com.isnetworks.crypto.database.server.SimpleDataso urceManager.getConn
ection(SimpleDatasourceManager.java:47)
        at com.isnetworks.crypto.database.server.SecureConnec tionServerImpl.getC
onnection(SecureConnectionServerImpl.java:74)
        at com.isnetworks.crypto.database.server.SecureConnec tionServerImpl.getC
onnection(SecureConnectionServerImpl.java:58)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at sun.rmi.server.UnicastServerRef.dispatch(UnicastSe rverRef.java:261)
        at sun.rmi.transport.Transport$1.run(Transport.java:1 48)
        at java.security.AccessController.doPrivileged(Native Method)
        at sun.rmi.transport.Transport.serviceCall(Transport. java:144)
        at sun.rmi.transport.tcp.TCPTransport.handleMessages( TCPTransport.java:4
60)
        at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er.run(TCPTransport
.java:701)
        at java.lang.Thread.run(Thread.java:534)


Stephen
 
Old April 15th, 2005, 10:12 AM
Friend of Wrox
 
Join Date: Dec 2003
Posts: 488
Thanks: 0
Thanked 3 Times in 3 Posts
Default

It looks like the error is here:
> Trying to connect to: rmi://localhost:1099/SecureDriver

Which looks (to me)like the code is asking it to connect to the wrong port (i.e. 1099). A rather bad error message there.

Have a look in your code for something like:
private String URL = "jdbc:mysql://localhost:1099/my_db";

and change the 1099 to 3306

Any good?


--
Don't Stand on your head - you'll get footprints in your hair
                                           http://charlieharvey.org.uk
                                              http://charlieharvey.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Read Only Form Is not Read only lryckman Access VBA 3 June 12th, 2007 06:30 AM
How to Read Barcode??? rajithtk .NET Framework 2.0 0 December 16th, 2006 01:53 AM
What to Read Next ralphtrent BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 1 July 17th, 2004 01:53 AM
Read first!!!Please help me!!!Thank you!!! wood000 Wrox Book Feedback 1 June 24th, 2004 09:22 AM
Detecting Read-Only rgerald Access VBA 6 October 30th, 2003 04:51 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.