B4J Question [SOLVED] JRDC2 Error

makis_best · May 24, 2020

Hi

I try to access my MSSQL Server with RDC2 and I get the above error.
Any help?

HTTP ERROR 500
Problem accessing /rdc. Reason:

com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@3724b2bb -- timeout at awaitAvailable()

In the config.properties I have:

#DATABASE CONFIGURATION
DriverClass=mssql-jdbc-8.2.2.jre11.jar
JdbcUrl=jdbc:jtds:sqlserver://192.168.1.2;databaseName=XXXXX;user=sa;password=XXXXX;

#Java server port
ServerPort=17178

OliverA · May 24, 2020

You are using the mssql driver (yeah), but you are using a JDBC URL meant for JTDS. See Microsoft's documentation on building a JDBC URL for the MS SQL JDBC driver.

Building the connection URL with the Microsoft JDBC Driver for SQL Server - JDBC Driver for SQL Server

Learn about formatting the connection string used by the Microsoft JDBC Driver for SQL Server. Samples of connection strings are included in the examples section.

docs.microsoft.com

makis_best · May 25, 2020

I am trying from yesterday to make it work but I can't.
I don't know why.
But with jtds-1.3.1.jar I make it run.

Revisable5987 · May 25, 2020

Have you tried removing 'jtds:', its not in the example shown in the link posted by @OliverA?

Connect to the default database on the local computer by using a user name and password:

jdbc:sqlserver://localhost;user=MyUserName;password=*****;

so something like:

JdbcUrl=jdbc:sqlserver://192.168.1.2;databaseName=XXXXX;user=sa;password=XXXXX;

makis_best · May 25, 2020

kgcarpenter said:
Have you tried removing 'jtds:', its not in the example shown in the link posted by @OliverA?

so something like:

Yes I try that way also.

I don't know if my Java version mater. I use Java 8

Revisable5987 · May 25, 2020

So I've looked into it a bit more:
https://docs.microsoft.com/en-us/sq...c-driver-for-sql-server?view=sql-server-ver15
https://docs.microsoft.com/en-us/sq...tanding-java-ee-support?view=sql-server-ver15

1. The driver class name is com.microsoft.sqlserver.jdbc.SQLServerDriver not mssql-jdbc-8.2.2.jre11.jar

2.When you download the driver, there are multiple JAR files. The name of the JAR file indicates the version of Java that it supports.
#AdditionalJar:mssql-jdbc-8.2.2.jre11 would mean Java 11

3. make sure you have

#AdditionalJar:mssql-jdbc-8.2.2.jre11

in your b4j project
and the jar file in your b4j additional libraries folder

OliverA · May 25, 2020

makis_best said:
I don't know if my Java version mater. I use Java 8

Yes , use the Java 8 version. There are several versions in the zip/msi file of the driver download file

makis_best · May 26, 2020

kgcarpenter said:
So I've looked into it a bit more:
https://docs.microsoft.com/en-us/sq...c-driver-for-sql-server?view=sql-server-ver15
https://docs.microsoft.com/en-us/sq...tanding-java-ee-support?view=sql-server-ver15

1. The driver class name is com.microsoft.sqlserver.jdbc.SQLServerDriver not mssql-jdbc-8.2.2.jre11.jar

2.When you download the driver, there are multiple JAR files. The name of the JAR file indicates the version of Java that it supports.
#AdditionalJar:mssql-jdbc-8.2.2.jre11 would mean Java 11

3. make sure you have in your b4j project
and the jar file in your b4j additional libraries folder

I confused... The Driver class name on config.properties file must be com.microsoft.sqlserver.jdbc.SQLServerDriver???
and inside B4J must be like #AdditionalJar: mssql-jdbc-8.2.2.jre8

Revisable5987 · May 26, 2020

makis_best said:
I confused... The Driver class name on config.properties file must be com.microsoft.sqlserver.jdbc.SQLServerDriver???
and inside B4J must be like #AdditionalJar: mssql-jdbc-8.2.2.jre8

Yes

https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/

makis_best · May 26, 2020

OK.... I make it work

1) In my additional library folder i insert the file mssql-jdbc-8.2.2.jre8.jar cuz I am using Java8
2) In JRDC2 main module I add #AdditionalJar: mssql-jdbc-8.2.2.jre8.jar
3) In the config.properties I add
DriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
JdbcUrl=jdbc:sqlserver://192.168.1.2;databaseName=xxxxxxxx;
User=xxxxxxx
Password=xxxxxxx

And it works like a charm....

Thank you all for your help.

B4J Question [SOLVED] JRDC2 Error

makis_best

Well-Known Member

OliverA

Expert

Building the connection URL with the Microsoft JDBC Driver for SQL Server - JDBC Driver for SQL Server

makis_best

Well-Known Member

Revisable5987

Member

makis_best

Well-Known Member

Revisable5987

Member

OliverA

Expert

makis_best

Well-Known Member

Revisable5987

Member

makis_best

Well-Known Member

Similar Threads

B4J Question [SOLVED] JRDC2 Error

Well-Known Member

Expert

Well-Known Member

Member

Well-Known Member

Member

Expert

Well-Known Member

Member

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency