1 Reply Latest reply: Feb 3, 2011 4:59 AM by 718433 RSS

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

    835956
      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