I just had to deal with the same error message, thrown by DriverManager.getConnection(URL,username,password). I even got the same “magic numbers” (4739923 > 1048576); googling for those “magic numbers” will show results from people also getting the error thrown by some DriverManager.getConnection statement. In my case, the error message about packet size was COMPLETELY MISLEADING; I … Read more
enable mssql in php.ini ;extension=php_mssql.dll to extension=php_mssql.dll
Im unsure about mysqlconnection but the sql server counter part uses Connection pooling and does not close when you call close instead it puts it in the connection pool! Edit: Make sure you dispose the Reader, Command, and Connection object! Edit: Solved with the ConnectionString Parameter “Pooling=false” or the static methods MySqlConnection.ClearPool(connection) and MySqlConnection.ClearAllPools()
This may not be answering your question specifically, but it may help others with similar issue caused by different problem In my case the problem was my user is defaulted to a database which is not accessible for any reason (can be renamed, removed, corrupted or …) To solve the issue just follow the following … Read more
This is not the correct way of retrieving a connection. You’re retrieving the connection and assigning it as an instance (or worse, static) variable of the class. Basically, you’re keeping the connection open forever and reusing a single connection for all queries. This may end up in a disaster if the queries are executed by … Read more
If the user name that is in the connection string has access to more then one database you have to specify the database you want the connection string to connect to. If your user has only one database available then you are correct that it doesn’t matter. But it is good practice to put this … Read more
Note: Although the direct answer to ops question, “when can I only create / connect to the database when required and not on every request” is inject it when you need it, simply saying that is not helpful. I’m explaining here how you actually go about that correctly, as there really isn’t a lot of … Read more
Having persistent connections does not imply that all threads use the same connection. It just “says” that you keep the connection open (in contradiction to open a connection each time you need one). Opening a connection is an expensive operation, so – in general – you try to avoid opening connections more often than necessary. … Read more
In heroku website, go to My Apps and select the app on which you have installed ClearDB. On the top corner click on Addons and then select ClearDB MySQL Database. Once there, click on your database and choose the ‘Endpoint Information‘ tab. There you see your username/password. The URL to the database can be acquired … Read more
Database connection pooling is a method used to keep database connections open so they can be reused by others. Typically, opening a database connection is an expensive operation, especially if the database is remote. You have to open up network sessions, authenticate, have authorisation checked, and so on. Pooling keeps the connections active so that, … Read more