unable to connect to Mysql server using myeclipse 8.5(trial)

This topic contains 2 replies, has 2 voices, and was last updated by Profile photo of support-shalini support-shalini 7 years, 4 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #309254 Reply
    Profile photo of viren1984
    viren1984
    Member

    ————————————ISSUE————————————–
    I have recently installed Myeclipse 8.5 (trial).

    I am trying to connect to Mysql server(5.1) using Mysql connector(mysql-connector-java-5.1.12-bin) in my newly installed MyEclipse8.5 neither inbuilt derby server is connecting.
    and additional to it i am unalbe to connect to derby server as well.
    previously i was using Myeclipse 6.0 on same PC and was able to connect to both of server.

    following is the error displayed:

    error while performing databse login with the mysql driver:communications link faliour .the last packer sent successfully to the server was0 miliseconds ago.
    the driver has not received any packer from server
    “.

    Kindly note the i am able to connect to Mysql Server using same driver in myeclipse 6.0

    .—————–INSTALLATION DETAILS———————————

    *** Date:
    Monday, June 21, 2010 10:09:22 PM PDT

    ** System properties:
    OS=WindowsXP
    OS version=5.1.0
    Java version=1.6.0_13

    *** MyEclipse details:
    MyEclipse Enterprise Workbench
    Version: 8.5
    Build id: 8.5-20100319

    *** Eclipse details:
    MyEclipse Enterprise Workbench

    Version: 8.5
    Build id: 8.5-20100319

    Eclipse startup command=-os
    win32
    -ws
    win32
    -arch
    x86
    -showsplash
    -launcher
    G:\myeclipse8.5\myeclipse.exe
    -name
    Myeclipse
    –launcher.library
    G:\myeclipse8.5\../common/plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.0.200.v20090519\eclipse_1206.dll
    -startup
    G:\myeclipse8.5\../common/plugins/org.eclipse.equinox.launcher_1.0.201.R35x_v20090715.jar
    -install
    G:/myeclipse8.5
    -configuration
    configuration
    -vm
    G:/common/binary/com.sun.java.jdk.win32.x86_1.6.0.013/jre/bin/client/jvm.dll

    ———————ERROR LOG———————————-
    !ENTRY com.genuitec.eclipse.core.common 1 0 2010-06-21 16:32:27.375
    !MESSAGE ClasspathContainer requery for classpath-string: com.genuitec.eclipse.j2eedt.core

    !ENTRY com.genuitec.eclipse.core.common 1 0 2010-06-21 16:32:27.640
    !MESSAGE ClasspathContainer requery for classpath-string: com.genuitec.eclipse.j2eedt.core

    !ENTRY org.maven.ide.eclipse 4 0 2010-06-21 16:32:44.734
    !MESSAGE Unable to update index for central|http://repo1.maven.org/maven2
    !STACK 0
    java.io.IOException: Wagon exception connecting to Repository[d9d714e11cb097b3ffcec91cccc65d3e|http://repo1.maven.org/maven2/.index]
    at org.sonatype.nexus.index.updater.DefaultIndexUpdater$WagonFetcher.connect(DefaultIndexUpdater.java:651)
    at org.sonatype.nexus.index.updater.DefaultIndexUpdater.fetchAndUpdateIndex(DefaultIndexUpdater.java:120)
    at org.maven.ide.eclipse.internal.index.NexusIndexManager.updateRemoteIndex(NexusIndexManager.java:1060)
    at org.maven.ide.eclipse.internal.index.NexusIndexManager.updateIndex(NexusIndexManager.java:1013)
    at org.maven.ide.eclipse.internal.index.NexusIndexManager$1.run(NexusIndexManager.java:624)
    at org.maven.ide.eclipse.internal.index.IndexUpdaterJob.run(IndexUpdaterJob.java:71)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

    !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2010-06-21 16:35:03.234
    !MESSAGE Error while performing database login with the MySql driver
    !STACK 0
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2260)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:357)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
    at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:48)
    at java.lang.Thread.run(Thread.java:619)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
    … 12 more
    Caused by: java.net.ConnectException: Connection refused: connect
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
    at java.net.Socket.connect(Socket.java:519)
    at java.net.Socket.connect(Socket.java:469)
    at java.net.Socket.<init>(Socket.java:366)
    at java.net.Socket.<init>(Socket.java:209)
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:293)
    … 13 more

    !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2010-06-21 16:36:39.234
    !MESSAGE Error while performing database login with the MyEclipse Derby driver
    !STACK 0
    java.sql.SQLTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
    at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
    at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
    at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
    at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:48)
    at java.lang.Thread.run(Thread.java:619)
    Caused by: org.apache.derby.client.am.DisconnectException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
    at org.apache.derby.client.net.NetAgent.<init>(Unknown Source)
    at org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source)
    at org.apache.derby.client.am.Connection.<init>(Unknown Source)
    at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
    at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
    at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown Source)
    … 4 more
    Caused by: java.net.ConnectException: Connection refused: connect
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
    at java.net.Socket.connect(Socket.java:519)
    at java.net.Socket.connect(Socket.java:469)
    at java.net.Socket.<init>(Socket.java:366)
    at java.net.Socket.<init>(Socket.java:180)
    at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    … 10 more
    !SESSION 2010-06-21 17:03:51.546 ———————————————–
    eclipse.buildId=unknown
    java.version=1.6.0_13
    java.vendor=Sun Microsystems Inc.
    BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
    Command-line arguments: -os win32 -ws win32 -arch x86

    !ENTRY org.eclipse.jface 2 0 2010-06-21 17:04:15.484
    !MESSAGE Keybinding conflicts occurred. They may interfere with normal accelerator operation.
    !SUBENTRY 1 org.eclipse.jface 2 0 2010-06-21 17:04:15.484
    !MESSAGE A conflict occurred for SHIFT+DEL:
    Binding(SHIFT+DEL,
    ParameterizedCommand(Command(org.eclipse.datatools.sqltools.result.removeAllInstances,Remove All Visible Results,
    ,
    Category(org.eclipse.datatools.sqltools.result.category,SQL Results View,null,true),
    ,
    ,,true),null),
    org.eclipse.ui.defaultAcceleratorConfiguration,
    org.eclipse.ui.contexts.window,,,system)
    Binding(SHIFT+DEL,
    ParameterizedCommand(Command(org.eclipse.ui.edit.cut,Cut,
    Cut the selection to the clipboard,
    Category(org.eclipse.ui.category.edit,Edit,null,true),
    org.eclipse.ui.internal.handlers.WidgetMethodHandler@ce5536,
    ,,true),null),
    org.eclipse.ui.defaultAcceleratorConfiguration,
    org.eclipse.ui.contexts.dialogAndWindow,,,system)
    Binding(SHIFT+DEL,
    ParameterizedCommand(Command(org.topcased.modeler.deleteModelObject,Delete From Model,
    Allows the user to delete the selected graph element and its associated model element in a Topcased editor.,
    Category(org.eclipse.ui.category.edit,Edit,null,true),
    ,
    ,,true),null),
    org.eclipse.ui.defaultAcceleratorConfiguration,
    org.eclipse.ui.contexts.window,,,system)

    !ENTRY org.maven.ide.eclipse 4 0 2010-06-21 17:04:41.703
    !MESSAGE Unable to update index for central|http://repo1.maven.org/maven2
    !STACK 0
    java.io.IOException: Wagon exception connecting to Repository[d9d714e11cb097b3ffcec91cccc65d3e|http://repo1.maven.org/maven2/.index]
    at org.sonatype.nexus.index.updater.DefaultIndexUpdater$WagonFetcher.connect(DefaultIndexUpdater.java:651)
    at org.sonatype.nexus.index.updater.DefaultIndexUpdater.fetchAndUpdateIndex(DefaultIndexUpdater.java:120)
    at org.maven.ide.eclipse.internal.index.NexusIndexManager.updateRemoteIndex(NexusIndexManager.java:1060)
    at org.maven.ide.eclipse.internal.index.NexusIndexManager.updateIndex(NexusIndexManager.java:1013)
    at org.maven.ide.eclipse.internal.index.NexusIndexManager$1.run(NexusIndexManager.java:624)
    at org.maven.ide.eclipse.internal.index.IndexUpdaterJob.run(IndexUpdaterJob.java:71)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

    #309256 Reply
    Profile photo of viren1984
    viren1984
    Member

    Kindly help me Sir.Thanking you

    #309473 Reply

    viren1984,

    installed MyEclipse8.5 neither inbuilt derby server is connecting.
    and additional to it i am unalbe to connect to derby server as well.

    In either cases, please make sure that the mysql server/service and myeclipse derby are started.
    The “Communications link failure ” and “Connection refused: connect. ” are caused when you try to access the data base when servers are not running.
    Let me know if that helps.

Viewing 3 posts - 1 through 3 (of 3 total)
Reply To: unable to connect to Mysql server using myeclipse 8.5(trial)