[Hh#86293] Please Help

[HelioHost]

here i can't change the max_user_connection.

here i don't have any .cnf files. please tell how to Increase the

max_user_connections in here.

please let me know quickly!

[wolstech]

Put simply, you can't.

 

If your software needs more than the limit we allow (I believe 4), you'll need to rewrite your code or find different software. There is no reason that software should ever need more than 4 open connections at one time anyway. When people hit this limit, it's usually due to poorly written code that isn't closing its connections when it's done with them.

[HelioHost]

i am using java 3 tire application . in the code part i can't close the

connection.

do you have any ideas.

 

On Tue, Aug 15, 2017 at 2:08 AM, Heliohost Support

wrote:

 

> Put simply, you can't.

>

> If your software needs more than the limit we allow (I believe 4), you'll

> need to rewrite your code or find different software. There is no reason

> that software should ever need more than 4 open connections at one time

> anyway. When people hit this limit, it's usually due to poorly written code

> that isn't closing its connections when it's done with them.

>

>

> You may view the status of your ticket by visiting:

>

> https://www.helionet.org/index/index.php?showtopic)264

>

> Thank you,

> Heliohost support

> https://www.heliohost.org/

> https://www.helionet.org/

>

>

[Krydos]

Here is how you can close mysql connections in java:

 

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

 

rs.close();

ps.close();

conn.close();