MySQL: PacketTooBigException

Discussion in 'Plugin Development' started by Baba43, Apr 8, 2013.

Thread Status:
Not open for further replies.
  1. Offline

    Baba43

    Hello,

    I have written a Plugin for my friend like I always do but it does not seem to work with his mysql-server. His server is hosted by nitrado and he has other plugins running that are also using a mysql-connection so I think that I am doing something wrong.

    Code:
    23:11:52 [SCHWERWIEGEND] com.mysql.jdbc.PacketTooBigException: Packet for query
    is too large (3158578 > 1048576). You can change this value on the server by set
    ting the max_allowed_packet' variable.
    23:11:52 [SCHWERWIEGEND]        at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.jav
    a:624)
    23:11:52 [SCHWERWIEGEND]        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.ja
    va:1090)
    23:11:52 [SCHWERWIEGEND]        at com.mysql.jdbc.ConnectionImpl.coreConnect(Con
    nectionImpl.java:2338)
    23:11:52 [SCHWERWIEGEND]        at com.mysql.jdbc.ConnectionImpl.connectOneTryOn
    ly(ConnectionImpl.java:2371)
    23:11:52 [SCHWERWIEGEND]        at com.mysql.jdbc.ConnectionImpl.createNewIO(Con
    nectionImpl.java:2163)
    23:11:52 [SCHWERWIEGEND]        at com.mysql.jdbc.ConnectionImpl.<init>(Connecti
    onImpl.java:794)
    23:11:52 [SCHWERWIEGEND]        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Co
    nnection.java:47)
    23:11:52 [SCHWERWIEGEND]        at sun.reflect.NativeConstructorAccessorImpl.new
    Instance0(Native Method)
    23:11:52 [SCHWERWIEGEND]        at sun.reflect.NativeConstructorAccessorImpl.new
    Instance(Unknown Source)
    23:11:52 [SCHWERWIEGEND]        at sun.reflect.DelegatingConstructorAccessorImpl
    .newInstance(Unknown Source)
    23:11:52 [SCHWERWIEGEND]        at java.lang.reflect.Constructor.newInstance(Unk
    nown Source)
    23:11:52 [SCHWERWIEGEND]        at com.mysql.jdbc.Util.handleNewInstance(Util.ja
    va:407)
    23:11:52 [WARNUNG] [CommandBook] Failed to load warps: plugins\CommandBook\homes
    .csv (Das System kann die angegebene Datei nicht finden)
    23:11:52 [SCHWERWIEGEND]        at com.mysql.jdbc.ConnectionImpl.getInstance(Con
    nectionImpl.java:378)
    23:11:52 [SCHWERWIEGEND]        at com.mysql.jdbc.NonRegisteringDriver.connect(N
    onRegisteringDriver.java:305)
    23:11:52 [SCHWERWIEGEND]        at java.sql.DriverManager.getConnection(Unknown
    Source)
    23:11:52 [SCHWERWIEGEND]        at java.sql.DriverManager.getConnection(Unknown
    Source)
    23:11:52 [SCHWERWIEGEND]        at de.baba43.util.database.mysql.MySQLConnection
    .connect(MySQLConnection.java:39)
    23:11:52 [SCHWERWIEGEND]        at de.baba43.util.database.multitasking.AsynchMy
    SQLTask.run(AsynchMySQLTask.java:28)
    Code:
    public void connect() throws ClassNotFoundException, SQLException {
    Class.forName("com.mysql.jdbc.Driver");
    connectionString = "jdbc:mysql://" + config.Address + ":" + config.Port + "/" + config.Database + "?" + "user=" + config.User;
    if(config.Password != null && !config.Password.equals(""))
    connectionString += "&" + "password=" + config.Password;
    conn = DriverManager.getConnection(connectionString);
     
    log.log("SQLConnection", "ConnectionString: " + connectionString);
    }
    Hopefully some can help me.
    Thanks.
     
  2. Offline

    Rprrr

    Have you tried?
     
  3. Offline

    Baba43

    Yes I tried that you need a superuser to run such commands.
     
Thread Status:
Not open for further replies.

Share This Page