Android Question jRDC2 MSSQL connection problem

Daica

Active Member
Licensed User
Hello everyone, I hope you are doing good today.

I have a B4J Server running on Server A with Port 17178 allowed in the firewall and router.
I have Server B running the MS-SQL server, with port 1433 allowed in the firewall.

I cannot get a successful connection using jRDC2. I am always getting:
RemoteServer is running
Error fetching connection.

I am using the mssql-jdbc-10.2.1.jre11 jar file and here is my config.properties file

Bash:
#DATABASE CONFIGURATION
DriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
JdbcUrl=jdbc:jtds:sqlserver://192.168.3.12/Test?characterEncoding=utf8
User=MyUser
Password=MyPassword
#Java server port
ServerPort=17178

I made sure to include the jar in my B4J Project:
B4X:
#AdditionalJar: mssql-jdbc-10.2.1.jre11

Here is the full log:
B4X:
2022-05-24 13:11:31.581:INFO::main: Logging initialized @133ms to org.eclipse.jetty.util.log.StdErrLog
May 24, 2022 1:11:31 PM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
May 24, 2022 1:11:31 PM com.mchange.v2.c3p0.C3P0Registry
INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
2022-05-24 13:11:31.847:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+13
2022-05-24 13:11:31.868:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2022-05-24 13:11:31.868:INFO:oejs.session:main: No SessionScavenger set, using defaults
2022-05-24 13:11:31.870:INFO:oejs.session:main: node0 Scavenging every 600000ms
2022-05-24 13:11:31.873:INFO:oejsh.ContextHandler:main: Started [email protected]{/,file:///C:/B4J/Projects/jRDC/Objects/www,AVAILABLE}
2022-05-24 13:11:31.874:INFO:oejs.AbstractNCSARequestLog:main: Opened C:\B4J\Projects\jRDC\Objects\logs\b4j-2022_05_24.request.log
2022-05-24 13:11:31.886:INFO:oejs.AbstractConnector:main: Started [email protected]{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2022-05-24 13:11:31.886:INFO:oejs.Server:main: Started @441ms
jRDC is running (version = 2.23)
May 24, 2022 1:11:34 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 2rxegfao1wlvoih7bbd1h|75329a49, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.microsoft.sqlserver.jdbc.SQLServerDriver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 2rxegfao1wlvoih7bbd1h|75329a49, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:jtds:sqlserver://192.168.3.12/Test?characterEncoding=utf8, maxAdministrativeTaskTime -> 0, maxConnectionAge ->...
May 24, 2022 1:12:04 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com[email protected]3a5a4678 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
    at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
May 24, 2022 1:12:04 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com[email protected]550e6499 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
    at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
May 24, 2022 1:12:04 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, [email protected] is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
May 24, 2022 1:12:04 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, [email protected] is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
May 24, 2022 1:12:04 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com[email protected]7117189e -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
    at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
May 24, 2022 1:12:04 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, [email protected] is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

TCP is enabled in the Sql Server Configuration Manager:
1653423146915.png
 

Daica

Active Member
Licensed User
This is now solved.

Solved by using mssql-jdbc-9.2.0.jre11 instead.
SQL Server 2008 R2 for anyone wondering.
 
Last edited:
Upvote 0
Solution
Top