Search Results

If you want to use ConnectionPool in a UI app then you should use this library instead of jServer. jServer is not compatible with B4J Packager 11. jConnectionPool library is a subset of jServer...
link: It's here : https://www.b4x.com/android/forum/threads/jrdc2-pool-connection-errors.118495...
link: i have some JRDC2 timeout errors. Start a new thread for this and post (as text, preferably using ...
link: hello @Erel please some more explanation how to use this library. i have some JRDC2 timeout errors....

-allowed-after-resultset-closed.42516/ I have changed all my SQL queries and SQL connection to the Pool from ConnectionPool method. I now run into this problem: Jul 07, 2014 11:03:19 AM com.mchange.v2....WrapperConnectionPoolDataSource.getPooledConnecti on(WrapperConnectionPoolDataSource.java:195) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti on(WrapperConnectionPoolDataSource.java:184) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe...

This is a wrapper for: https://github.com/brettwooldridge/HikariCP It can be used the same way as the ConnectionPool from the jServer library. Below you will find my implementation of using it with MariaDB/MySQL Dim cp As HikariCP cp.Initialize("org.mariadb.jdbc.Driver", "jdbc...("setMaximumPoolSize", Array(4)) jocp.RunMethod("addDataSourceProperty", Array... As SQL = cp.GetConnection Log(conn.ExecQuerySingleResult("SELECT version()"...

Is it possible to use a c3po-config.xml file to configure the connection pooling? I assume it would go in the files folder if it's possible....

out how can i fix it ? this is the code : Sub Process_Globals Public pool As ConnectionPool... Sync Dim sql1 As SQL = pool.GetConnection Dim rs As ResultSet = sql1.ExecQuery("SELECT... Dim sql1 As SQL = pool.GetConnection Dim rs As ResultSet = sql1.ExecQuery("SELECT * FROM... ListCidades() As String Dim sql1 As SQL = pool.GetConnection Dim rs As ResultSet = sql1... sql1 As SQL = pool.GetConnection Dim rs As ResultSet = sql1.ExecQuery("SELECT * FROM clinicas...

the posts, I managed to solve a ConnectionPool issue.... (took another 2 days to discover - my bad) Issue: Updating any record, it was successful until it hit the (pool) maxpoolsize setting (which is hard... after use... sq.Close WRONG WAY: DBUtils.DeleteRecord(DB.pool.GetConnection...)) tbContacts.Refresh The problem here is "DBUtils.DeleteRecord(DB.pool.GetConnection"... the pool: newobj= DB.pool.GetConnection {do your stuff} release it back (free object) when done...

The pool is responsible for maintaining the connections. An alternative for a connections pool... with this statement. No problem to use connection pool for MySQL and set the SingleThreaded to False by default...
link: So the short answer is No. I understand about pooling, just confused after I read the tutorial...
link: No. Just don't use pooling with SQLite. For SQLite, use the InitializeSQLite method to...
link: 't use pooling with SQLite. For SQLite, use the InitializeSQLite method to retrieve your SQL...

(license) The database connection pooling implementation is based on c3p0 (license). B4J Server features... powerful database connections pooling Server can run on Windows, Mac and Linux (including board computers... code in Debug mode the handlers will always run in the main thread. Datebase Connections Pooling... concurrent queries and transactions. The ConnectionPool object handles a pool of database connections. You can then get a connection (SQL object) from the pool, work with it and close it, which...

it again when necessary. Sub Process_Globals Private Pool1 As ConnectionPool Private Pool2 As ConnectionPool Private Tm As Timer Private Qry1,Qry2,ExecQ1,ExecQ2 as SQL end Sub Sub...
link: Why are you getting multiple connections from the pool? Looks wrong. So option B is better. Why...
link: When using the connection pool you should always close a connection when you have finished...
link: When using the connection pool you should always close a connection when you have finished the work....

.CommunicationsException: Communications link failure I know this has to do because i am not using a ConnectionPool... the jDBCSql library, i am able to connect to my remote SQL database, but from time to time...
link: Try this: https://github.com/mini2Dx/android-beans Will probably be easier to switch to a VPS....
link: jConnectionPool: https://www.b4x.com/android/forum/threads/jconnectionpool-connectionpool-extracted-from-jserver...