This discussion is archived
1 Reply Latest reply: Feb 3, 2011 2:59 AM by 718433 RSS

i am trying to connect jbdc to mysql database but i get this  a mysql error

835956 Newbie
Currently Being Moderated
og4j:ERROR Failed to excute sql
java.sql.SQLException: Must specify port after ':' in connection string
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
     at com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:171)
     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2116)
     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
     at java.lang.reflect.Constructor.newInstance(Unknown Source)
     at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
     at java.sql.DriverManager.getConnection(Unknown Source)
     at java.sql.DriverManager.getConnection(Unknown Source)
     at org.apache.log4j.jdbc.JDBCAppender.getConnection(Unknown Source)
     at org.apache.log4j.jdbc.JDBCAppender.execute(Unknown Source)
     at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(Unknown Source)
     at org.apache.log4j.jdbc.JDBCAppender.append(Unknown Source)
     at org.apache.log4j.AppenderSkeleton.doAppend(Unknown Source)
     at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(Unknown Source)
     at org.apache.log4j.Category.callAppenders(Unknown Source)
     at org.apache.log4j.Category.forcedLog(Unknown Source)
     at org.apache.log4j.Category.log(Unknown Source)
     at com.wowza.wms.logging.WMSLogger.log(Unknown Source)
     at com.wowza.wms.logging.WMSLogger.info(Unknown Source)
     at com.mycompany.wms.module.MyServerListener.onServerConfigLoaded(MyServerListener.java:9)
     at com.wowza.wms.server.Server.notifyConfigLoaded(Unknown Source)
     at com.wowza.wms.server.Server.start(Unknown Source)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     at com.wowza.wms.bootstrap.Bootstrap.startServer(Bootstrap.java:249)
     at com.wowza.wms.bootstrap.Bootstrap.main(Bootstrap.java:48

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points