This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 98890 - Exception about port arise by attempt to bind to MySQL
Summary: Exception about port arise by attempt to bind to MySQL
Status: CLOSED FIXED
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P2 blocker (vote)
Assignee: John Baker
URL:
Keywords:
Depends on: 89532
Blocks:
  Show dependency tree
 
Reported: 2007-03-25 14:53 UTC by Roman Mostyka
Modified: 2007-04-17 12:19 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Mostyka 2007-03-25 14:53:44 UTC 
1. Add MySQL connection without port.
2. Connect. Everything is fine, it is possible to connect to MySQL, because
default port is used.
3. Create Visual Web Application.
4. Add 'Table' component ti the page.
5. Try to bind it to DB by click-click.

Result: Exception arises and table isn't bound:
"java.lang.RuntimeException: java.sql.SQLException: Must specify port after ':'
in connection string
	at
com.sun.data.provider.impl.CachedRowSetDataProvider.getMetaData(CachedRowSetDataProvider.java:1387)
	at
com.sun.data.provider.impl.CachedRowSetDataProvider.getFieldKeys(CachedRowSetDataProvider.java:507)
	at com.sun.webui.jsf.component.TableDesignInfo.linkBeans(TableDesignInfo.java:176)
	at
org.netbeans.modules.visualweb.insync.models.FacesModel.linkBeans(FacesModel.java:1151)
	at
org.netbeans.modules.visualweb.designer.jsf.FacesDndSupport.processLinks(FacesDndSupport.java:958)
	at
org.netbeans.modules.visualweb.designer.jsf.FacesDndSupport.importBean(FacesDndSupport.java:526)
	at
org.netbeans.modules.visualweb.designer.jsf.FacesDndSupport.importData(FacesDndSupport.java:324)
	at
org.netbeans.modules.visualweb.designer.jsf.FacesDndSupport.importData(FacesDndSupport.java:3455)
	at
org.netbeans.modules.visualweb.designer.jsf.DndSupport.importData(DndSupport.java:503)
	at
org.netbeans.modules.visualweb.designer.jsf.HtmlDomProviderImpl.importData(HtmlDomProviderImpl.java:1016)
	at org.netbeans.modules.visualweb.designer.WebForm.importData(WebForm.java:2088)
	at
org.netbeans.modules.visualweb.designer.DndHandler.importDataDelayed(DndHandler.java:423)
	at
org.netbeans.modules.visualweb.designer.DndHandler.access$000(DndHandler.java:67)
[catch] at
org.netbeans.modules.visualweb.designer.DndHandler$1.run(DndHandler.java:323)
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
	at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
	at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by: java.sql.SQLException: Must specify port after ':' in connection string
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
	at
com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:164)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2620)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	at
org.netbeans.modules.visualweb.dataconnectivity.sql.DesignTimeDataSource.getConnection(DesignTimeDataSource.java:239)
	at
org.netbeans.modules.visualweb.dataconnectivity.sql.DesignTimeDataSource.getConnection(DesignTimeDataSource.java:214)
	at com.sun.sql.rowset.CachedRowSetXImpl.getConnection(Unknown Source)
	at com.sun.sql.rowset.CachedRowSetXImpl.getMetaData(Unknown Source)
	at
com.sun.data.provider.impl.CachedRowSetDataProvider.getMetaData(CachedRowSetDataProvider.java:1385)
	... 20 more".
Comment 1 Roman Mostyka 2007-03-25 14:57:33 UTC 
The same if port is specified for connection.
Comment 2 John Baker 2007-03-25 21:20:55 UTC 
I believe this is the same as 89532
Comment 3 John Baker 2007-03-30 03:23:52 UTC 
There is some exception in dataconnectivity.
Once getConnection uses netbeans getConnection then we'll see if this error
still occurs
Comment 4 John Baker 2007-04-10 22:45:34 UTC 
fixed
Comment 5 Roman Mostyka 2007-04-17 12:15:49 UTC 
Verified with build 200704170100.