Problem with the MySQL driver

Posted on December 14, 2016 at 5:02am

Hello,

I have just started using iReport. I want to use MySQL as my data source. Please guide me through it.

Thank you.

Here is the snippet of the error.

Exception

Message:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.

Level:

SEVERE

Stack Trace:

Communications link failure Last packet sent to the server was 0 ms ago.

sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

java.lang.reflect.Constructor.newInstance(Constructor.java:526)

com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)

com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)

com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)

com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

java.lang.reflect.Constructor.newInstance(Constructor.java:526)

com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)

com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:140)

com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:449)

com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335)

com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43)

com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290)

javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)

javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)

javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)

javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)

javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)

java.awt.Component.processMouseEvent(Component.java:6505)

javax.swing.JComponent.processMouseEvent(JComponent.java:3320)

java.awt.Component.processEvent(Component.java:6270)

java.awt.Container.processEvent(Container.java:2229)

java.awt.Component.dispatchEventImpl(Component.java:4861)

java.awt.Container.dispatchEventImpl(Container.java:2287)

java.awt.Component.dispatchEvent(Component.java:4687)

java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)

java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)

java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)

java.awt.Container.dispatchEventImpl(Container.java:2273)

java.awt.Window.dispatchEventImpl(Window.java:2719)

java.awt.Component.dispatchEvent(Component.java:4687)

java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)

java.awt.EventQueue.access$200(EventQueue.java:103)

java.awt.EventQueue$3.run(EventQueue.java:694)

java.awt.EventQueue$3.run(EventQueue.java:692)

java.security.AccessController.doPrivileged(Native Method)

java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)

java.awt.EventQueue$4.run(EventQueue.java:708)

java.awt.EventQueue$4.run(EventQueue.java:706)

java.security.AccessController.doPrivileged(Native Method)

java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

java.awt.EventQueue.dispatchEvent(EventQueue.java:705)

org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)

java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:154)

java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)

java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)

java.security.AccessController.doPrivileged(Native Method)

java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)

java.awt.Dialog.show(Dialog.java:1082)

java.awt.Component.show(Component.java:1651)

java.awt.Component.setVisible(Component.java:1603)

java.awt.Window.setVisible(Window.java:1014)

java.awt.Dialog.setVisible(Dialog.java:1005)

com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jButtonModifyParameterActionPerformed(ConnectionsDialog.java:540)

com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jTableParametersMouseClicked(ConnectionsDialog.java:461)

com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.access$300(ConnectionsDialog.java:47)

com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog$6.mouseClicked(ConnectionsDialog.java:202)

java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:270)

java.awt.Component.processMouseEvent(Component.java:6508)

javax.swing.JComponent.processMouseEvent(JComponent.java:3320)

java.awt.Component.processEvent(Component.java:6270)

java.awt.Container.processEvent(Container.java:2229)

java.awt.Component.dispatchEventImpl(Component.java:4861)

java.awt.Container.dispatchEventImpl(Container.java:2287)

java.awt.Component.dispatchEvent(Component.java:4687)

java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)

java.awt.LightweightDispatcher.processMouseEvent(Container.java:4501)

java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)

java.awt.Container.dispatchEventImpl(Container.java:2273)

java.awt.Window.dispatchEventImpl(Window.java:2719)

java.awt.Component.dispatchEvent(Component.java:4687)

java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)

java.awt.EventQueue.access$200(EventQueue.java:103)

java.awt.EventQueue$3.run(EventQueue.java:694)

java.awt.EventQueue$3.run(EventQueue.java:692)

java.security.AccessController.doPrivileged(Native Method)

java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)

java.awt.EventQueue$4.run(EventQueue.java:708)

java.awt.EventQueue$4.run(EventQueue.java:706)

java.security.AccessController.doPrivileged(Native Method)

java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

java.awt.EventQueue.dispatchEvent(EventQueue.java:705)

org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)

java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:154)

java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)

java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)

java.security.AccessController.doPrivileged(Native Method)

java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)

java.awt.Dialog.show(Dialog.java:1082)

java.awt.Component.show(Component.java:1651)

java.awt.Component.setVisible(Component.java:1603)

java.awt.Window.setVisible(Window.java:1014)

java.awt.Dialog.setVisible(Dialog.java:1005)

com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:651)

com.jaspersoft.ireport.designer.menu.DatasourcesAction.performAction(DatasourcesAction.java:46)

org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118)

org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77)

org.openide.util.actions.CallableSystemAction.actionPerformed(CallableSystemAction.java:114)

javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)

javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)

javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)

javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)

javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)

java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)

java.awt.Component.processMouseEvent(Component.java:6505)

javax.swing.JComponent.processMouseEvent(JComponent.java:3320)

org.openide.awt.ToolbarButton.processMouseEvent(ToolbarButton.java:61)

java.awt.Component.processEvent(Component.java:6270)

java.awt.Container.processEvent(Container.java:2229)

java.awt.Component.dispatchEventImpl(Component.java:4861)

java.awt.Container.dispatchEventImpl(Container.java:2287)

java.awt.Component.dispatchEvent(Component.java:4687)

java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)

java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)

java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)

java.awt.Container.dispatchEventImpl(Container.java:2273)

java.awt.Window.dispatchEventImpl(Window.java:2719)

java.awt.Component.dispatchEvent(Component.java:4687)

java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)

java.awt.EventQueue.access$200(EventQueue.java:103)

java.awt.EventQueue$3.run(EventQueue.java:694)

java.awt.EventQueue$3.run(EventQueue.java:692)

java.security.AccessController.doPrivileged(Native Method)

java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)

java.awt.EventQueue$4.run(EventQueue.java:708)

java.awt.EventQueue$4.run(EventQueue.java:706)

java.security.AccessController.doPrivileged(Native Method)

java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

java.awt.EventQueue.dispatchEvent(EventQueue.java:705)

org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)

java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)

java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)

java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

Connection refused: connect

java.net.DualStackPlainSocketImpl.connect0(Native Method)

java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)

java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)

java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)

java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)

java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)

java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

java.net.Socket.connect(Socket.java:579)

java.net.Socket.connect(Socket.java:528)

java.net.Socket.<init>(Socket.java:425)

java.net.Socket.<init>(Socket.java:241)

com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)

com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)

com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)