Bug #5493 Connection fails on Mac OSX

• Submitted: 9 Sep 2004 15:06
• Modified: 26 Nov 2004 22:03
• Reporter: [ name withheld ]
• Status: Closed
• Category: Connector / J
• Severity: S1 (Critical)
• Version: 3.1.4
• OS: MacOS (Mac OS X 10.3.5)
• Assigned to: Matthew Lord
• CPU Architecture: Any

[9 Sep 2004 15:06] [ name withheld ]

Description:
"Unexpected end of input stream" IO exception is thrown upon trying to connect to a mysql 
server running on a Linux AS 3.0 using Mac OS X as the client OS. This is the traceback:

Communication link failure: java.io.IOException, underlying cause: Unexpected end of input 
stream

** BEGIN NESTED EXCEPTION ** 

java.io.IOException
MESSAGE: Unexpected end of input stream

STACKTRACE:

java.io.IOException: Unexpected end of input stream
        at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:339)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:782)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1585)
        at com.mysql.jdbc.Connection.<init>(Connection.java:524)
        at com.mysql.jdbc.Driver.connect(Driver.java:359)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at Select.main(Select.java:11)

** END NESTED EXCEPTION **

java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: 
Unexpected end of input stream

** BEGIN NESTED EXCEPTION ** 

java.io.IOException
MESSAGE: Unexpected end of input stream

STACKTRACE:

java.io.IOException: Unexpected end of input stream
        at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:339)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:782)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1585)
        at com.mysql.jdbc.Connection.<init>(Connection.java:524)
        at com.mysql.jdbc.Driver.connect(Driver.java:359)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at Select.main(Select.java:11)

** END NESTED EXCEPTION **

        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:876)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1585)
        at com.mysql.jdbc.Connection.<init>(Connection.java:524)
        at com.mysql.jdbc.Driver.connect(Driver.java:359)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at Select.main(Select.java:11)

How to repeat:
How to reproduce: Simply try to obtain a connection using e.g.:

        public static void main(String argv[]) {
                try {
                        Class.forName("com.mysql.jdbc.Driver");
                        String url = "jdbc:mysql://<ip>/<database>";
                        Connection con = DriverManager.getConnection(url, uname, password);
                        System.out.println(con.getWarnings());
                        con.close();
                }
                catch( Exception e ) {
                        System.out.println(e.getMessage());
                        e.printStackTrace();
                }
        }

[21 Oct 2004 19:58] Matthew Lord

Hi,

Thank you for your bug report!

I am going to test this connecting to RH AS 3 on an x86 machine.  Please let me know
if mysqld is running on a different architecture.

Best Regards

[21 Oct 2004 20:00] Matthew Lord

Hi,

Could you also provide us with the version of mysqld that you are connecting to?  I assume it's
4.1.x, I will test against 4.1.6 in the meantime.

Thanks!

[21 Oct 2004 21:35] Matthew Lord

Hi, 

I was unable to get the exact same environment working but I was able to successfuly connect to 
a RH 9 machine, running 4.1.6-gamma.

Client machine:
Darwin silverbullet 7.5.0 Darwin Kernel Version 7.5.0: Thu Aug  5 19:26:16 PDT 2004; root:xnu/
xnu-517.7.21.obj~3/RELEASE_PPC  Power Macintosh powerpc

Server machine:
Linux booty 2.4.21 #12 SMP Thu Aug 14 00:49:40 EDT 2003 i686 i686 i386 GNU/Linux

[25 Nov 2004 16:44] [ name withheld ]

The new Connector/J 3.0.16 fixes the connection problem for me.

[26 Nov 2004 22:03] Matthew Lord

This appears to have been fixed in 3.0.16.

[5 Feb 2008 22:25] rema vinjamuri

Hi 

I have SQLDeveloper and want to use mysql in it too.. but it gives the following error :

"""""
oracle.jdeveloper.cm.CMException: Unable to find driver: com.mysql.jdbc.Driver
	at oracle.dbtools.raptor.conntypes.RaptorConnectionWrapper.createConnection(RaptorConnectionWrapper.java:175)
	at oracle.dbtools.raptor.conntypes.RaptorConnectionWrapper.getJdbcConnection(RaptorConnectionWrapper.java:202)
	at oracle.dbtools.raptor.conntypes.RaptorConnectionWrapper.getPresentation(RaptorConnectionWrapper.java:68)
	at oracle.dbtools.raptor.utils.Connections$ConnectionInfo.createConnection(Connections.java:1004)
	at oracle.dbtools.raptor.utils.Connections$ConnectionInfo$ConnectRunnable.doWork(Connections.java:876)
	at oracle.ide.dialogs.ProgressRunnable.run(ProgressRunnable.java:159)
	at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:553)
	at java.lang.Thread.run(Thread.java:613)
""""

Please let me know which is the file i need to download. 
I have mac OS X

Thanks,
Rema
[e-mail]