wfutan Posted January 16, 2020 Share Posted January 16, 2020 Hello all, I always got this kind of error when accessing mysql database: java.sql.SQLSyntaxErrorException: User <username> already has more than 'max_user_connections' active connections... I am still newbie and still using Johnny server, is it typical Johnny characteristics or there might be something else I am missing? Any reply/help would be very appreciated, best regards Link to comment Share on other sites More sharing options...
wolstech Posted January 16, 2020 Share Posted January 16, 2020 There's a limit of 4 concurrent connections at a time. You can try something like this in your connection string to limit them. Also, be sure to explicitly close your connections when finished with them. jdbc:mysql://localhost:3306/database?max-connections=4 Link to comment Share on other sites More sharing options...
wfutan Posted January 17, 2020 Author Share Posted January 17, 2020 oh I see, for Tommy server is there any limit or higher limit? any other solution except coding fix, already tried to close/cleanup connections don't know why still happens. thank you for the reply Link to comment Share on other sites More sharing options...
wolstech Posted January 17, 2020 Share Posted January 17, 2020 Tommy has no limit at this time, but that's subject to change if someone abuses the mysql server. Link to comment Share on other sites More sharing options...
wfutan Posted January 17, 2020 Author Share Posted January 17, 2020 ok thank you. i have just donate with paypal (transaction id 7NX306982J627924V), please move my account to Tommy sir Link to comment Share on other sites More sharing options...
flazepe Posted January 17, 2020 Share Posted January 17, 2020 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
wolstech Posted January 17, 2020 Share Posted January 17, 2020 Krydos has to do this since it has Java enabled. If I move it, the Java will break and I don't know how to fix that. Link to comment Share on other sites More sharing options...
Krydos Posted January 18, 2020 Share Posted January 18, 2020 You're on Tommy now. Thanks for the donation! Link to comment Share on other sites More sharing options...
wfutan Posted January 18, 2020 Author Share Posted January 18, 2020 Thanks for your support Krydos, everything is working well now. No Java Wolstech, just jdbc for connection to mysql database. I will setup paypal monthly donation to support the server. You may closed this topic, Solved! Link to comment Share on other sites More sharing options...
Recommended Posts