Hi. I'd appreciate any quick help please.
I'm trying to connect to a mySQL database on my website. Here's the jSQL function:
[username and password aren't mentioned here of course!]
It used to work when on localhost, but now after a long time of waiting, I get the error:
com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (5,526,600 > 65,535). You can change this value on the server by setting the 'max_allowed_packet' variable.
Please help... what is the problem? The website url and port are just as shown in my browser. How do I find where the query gets stuck???
Thank you so much in advance.
I'm trying to connect to a mySQL database on my website. Here's the jSQL function:
B4X:
sql1.InitializeAsync("sql1", "com.mysql.cj.jdbc.Driver", "jdbc:mysql://amin-azma.com:2083/amin_lims?characterEncoding=utf8&useSSL=false", "username", "password")
It used to work when on localhost, but now after a long time of waiting, I get the error:
com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (5,526,600 > 65,535). You can change this value on the server by setting the 'max_allowed_packet' variable.
Please help... what is the problem? The website url and port are just as shown in my browser. How do I find where the query gets stuck???
Thank you so much in advance.
Last edited: