java.lang.NumberFormatException: For input string: "255) CHARSET utf8
BEGIN
DECLARE citizenship VARCHAR(255);
SET citizenship = (
SELECT c.name
FROM countries AS c"
   at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
   at java.lang.Integer.parseInt(Integer.java:458)
   at java.lang.Integer.valueOf(Integer.java:554)
   at com.mysql.jdbc.DatabaseMetaData$TypeDescriptor.<init>(DatabaseMetaData.java:247)
   at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1652)
   at com.mysql.jdbc.DatabaseMetaData.getProcedureOrFunctionColumns(DatabaseMetaData.java:4120)
   at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:4057)
   at org.netbeans.modules.db.metadata.model.jdbc.JDBCProcedure.createProcedureInfo(JDBCProcedure.java:148)
   at org.netbeans.modules.db.metadata.model.jdbc.JDBCProcedure.initReturnValue(JDBCProcedure.java:218)
   at org.netbeans.modules.db.metadata.model.jdbc.JDBCProcedure.getReturnValue(JDBCProcedure.java:118)
   at org.netbeans.modules.db.metadata.model.api.Procedure.getReturnValue(Procedure.java:81)
   at org.netbeans.modules.db.explorer.node.ProcedureNode.updateProperties(ProcedureNode.java:112)
   at org.netbeans.modules.db.explorer.node.ProcedureNode.access$200(ProcedureNode.java:60)
   at org.netbeans.modules.db.explorer.node.ProcedureNode$1.run(ProcedureNode.java:98)
   at org.netbeans.modules.db.explorer.node.ProcedureNode$1.run(ProcedureNode.java:93)
   at org.netbeans.modules.db.metadata.model.JDBCConnMetadataModel.runReadAction(JDBCConnMetadataModel.java:94)
   at org.netbeans.modules.db.metadata.model.api.MetadataModel.runReadAction(MetadataModel.java:89)
   at org.netbeans.modules.db.explorer.node.ProcedureNode.initialize(ProcedureNode.java:92)
   at org.netbeans.api.db.explorer.node.BaseNode.setup(BaseNode.java:203)
   at org.netbeans.modules.db.explorer.node.ProcedureNode.create(ProcedureNode.java:72)
   at org.netbeans.modules.db.explorer.node.ProcedureNodeProvider$1.run(ProcedureNodeProvider.java:113)
   at org.netbeans.modules.db.explorer.node.ProcedureNodeProvider$1.run(ProcedureNodeProvider.java:98)
   at org.netbeans.modules.db.metadata.model.JDBCConnMetadataModel.runReadAction(JDBCConnMetadataModel.java:94)
   at org.netbeans.modules.db.metadata.model.api.MetadataModel.runReadAction(MetadataModel.java:89)
   at org.netbeans.modules.db.explorer.node.ProcedureNodeProvider.initialize(ProcedureNodeProvider.java:97)
   at org.netbeans.api.db.explorer.node.NodeProvider.getNodes(NodeProvider.java:103)
   at org.netbeans.modules.db.explorer.node.NodeRegistry.getNodes(NodeRegistry.java:164)
   at org.netbeans.api.db.explorer.node.ChildNodeFactory.createKeys(ChildNodeFactory.java:104)
   at org.openide.nodes.AsynchChildren.run(AsynchChildren.java:186)
   at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1369)
   at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1907)
Caused: org.openide.util.RequestProcessor$SlowItem: task failed due to: java.lang.NumberFormatException: For input string: "255) CHARSET utf8
BEGIN
DECLARE citizenship VARCHAR(255);
SET citizenship = (
SELECT c.name
FROM countries AS c"
   at org.openide.util.RequestProcessor$Task.schedule(RequestProcessor.java:1407)
   at org.openide.nodes.AsynchChildren.addNotify(AsynchChildren.java:87)
   at org.openide.nodes.Children.callAddNotify(Children.java:550)
   at org.openide.nodes.EntrySupport$Default.getArray(EntrySupport.java:744)
   at org.openide.nodes.EntrySupport$Default.getNodes(EntrySupport.java:166)
   at org.openide.nodes.EntrySupport$Default.getNodes(EntrySupport.java:222)
   at org.openide.nodes.Children.getNodes(Children.java:444)
   at org.openide.nodes.FilterNode$Children$DefaultSupport.updateKeys(FilterNode.java:1690)
   at org.openide.nodes.FilterNode$Children$DefaultSupport.update(FilterNode.java:1677)
   at org.openide.nodes.FilterNode$Children.addNotifyImpl(FilterNode.java:1471)
   at org.openide.nodes.FilterNode$Children.addNotify(FilterNode.java:1464)
   at org.openide.nodes.Children.callAddNotify(Children.java:550)
   at org.openide.nodes.EntrySupport$Default.getArray(EntrySupport.java:744)
   at org.openide.nodes.EntrySupport$Default.getNodes(EntrySupport.java:166)
   at org.openide.nodes.EntrySupport$Default.getNodes(EntrySupport.java:222)
   at org.openide.nodes.EntrySupport$Default.getNodesCount(EntrySupport.java:226)
   at org.openide.nodes.Children.getNodesCount(Children.java:484)
   at org.openide.explorer.view.VisualizerNode.getChildren(VisualizerNode.java:255)
   at org.openide.explorer.view.VisualizerNode.getChildren(VisualizerNode.java:245)
   at org.openide.explorer.view.VisualizerNode.getChildCount(VisualizerNode.java:322)
   at javax.swing.tree.DefaultTreeModel.getChildCount(DefaultTreeModel.java:168)
   at javax.swing.tree.FixedHeightLayoutCache$FHTreeStateNode.expand(FixedHeightLayoutCache.java:1135)
   at javax.swing.tree.FixedHeightLayoutCache.ensurePathIsExpanded(FixedHeightLayoutCache.java:645)
   at javax.swing.tree.FixedHeightLayoutCache.setExpandedState(FixedHeightLayoutCache.java:282)
   at javax.swing.plaf.basic.BasicTreeUI.updateExpandedDescendants(BasicTreeUI.java:1648)
   at javax.swing.plaf.basic.BasicTreeUI$Handler.treeExpanded(BasicTreeUI.java:3721)
   at javax.swing.JTree.fireTreeExpanded(JTree.java:2656)
   at javax.swing.JTree.setExpandedState(JTree.java:3427)
   at javax.swing.JTree.expandPath(JTree.java:2163)
   at javax.swing.plaf.basic.BasicTreeUI.toggleExpandState(BasicTreeUI.java:2209)
   at javax.swing.plaf.basic.BasicTreeUI.handleExpandControlClick(BasicTreeUI.java:2196)
   at javax.swing.plaf.basic.BasicTreeUI.checkForClickInExpandControl(BasicTreeUI.java:2154)
   at javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(BasicTreeUI.java:3516)
   at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressedDND(BasicTreeUI.java:3502)
   at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(BasicTreeUI.java:3461)
   at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
   at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
   at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
   at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
   at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
   at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
   at java.awt.Component.processMouseEvent(Component.java:6260)
   at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
   at java.awt.Component.processEvent(Component.java:6028)
   at java.awt.Container.processEvent(Container.java:2041)
   at java.awt.Component.dispatchEventImpl(Component.java:4630)
   at java.awt.Container.dispatchEventImpl(Container.java:2099)
   at java.awt.Component.dispatchEvent(Component.java:4460)
   at java.awt.LightweightDispatcher.retargetMouseEvent(LightweightDispatcher.java:4574)
   at java.awt.LightweightDispatcher.processMouseEvent(LightweightDispatcher.java:4235)
   at java.awt.LightweightDispatcher.dispatchEvent(LightweightDispatcher.java:4168)
   at java.awt.Container.dispatchEventImpl(Container.java:2085)
   at java.awt.Window.dispatchEventImpl(Window.java:2475)
   at java.awt.Component.dispatchEvent(Component.java:4460)
   at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
   at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:133)
   at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
   at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
   at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
   at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)