Android Question error while trying to test jtds-1.3.1

Makumbi · May 9, 2020

iam trying to test whether the server for jdbc2 sqlserver is ok but iam getting this error

please help i have seen erel's example but it talks about mysql please is there a step by step configuration from iis so that i can make my project run thanks

Bladimir Silva Toro · May 9, 2020

Hi @Makumbi

The following link shows the steps to connect to SQL Server using jRDC2.

Link: https://www.b4x.com/android/forum/t...-android-to-ms-sql-server-using-jrdc2.114856/

Makumbi · May 10, 2020

Bladimir Silva Toro said:
Hi @Makumbi

The following link shows the steps to connect to SQL Server using jRDC2.

Link: https://www.b4x.com/android/forum/t...-android-to-ms-sql-server-using-jrdc2.114856/

iam currently getting this error

B4X:

Waiting for debugger to connect...
Program started.
2020-05-10 15:01:00.596:INFO::main: Logging initialized @4641ms to org.eclipse.jetty.util.log.StdErrLog
May 10, 2020 3:01:01 PM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
May 10, 2020 3:01:02 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]
2020-05-10 15:01:02.970:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_211-b12
2020-05-10 15:01:03.497:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2020-05-10 15:01:03.498:INFO:oejs.session:main: No SessionScavenger set, using defaults
2020-05-10 15:01:03.508:INFO:oejs.session:main: node0 Scavenging every 660000ms
2020-05-10 15:01:03.565:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@80503{/,file:///D:/jbcdsql/jRDC%20SQL%20Server(1)/jRDC/Objects/www,AVAILABLE}
2020-05-10 15:01:03.594:INFO:oejs.AbstractNCSARequestLog:main: Opened D:\jbcdsql\jRDC SQL Server(1)\jRDC\Objects\logs\b4j-2020_05_10.request.log
2020-05-10 15:01:03.711:INFO:oejs.AbstractConnector:main: Started ServerConnector@1134983{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2020-05-10 15:01:03.713:INFO:oejs.Server:main: Started @7801ms
Emulated network latency: 100ms
jRDC is running (version = 2.22)
May 10, 2020 3:01:18 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 -> 1hge9jra91ylq9aogwyyvj|1f2a7d5, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> net.sourceforge.jtds.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge9jra91ylq9aogwyyvj|1f2a7d5, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:jtds:sqlserver://192.168.43.215/TestSQLServer, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, max...
May 10, 2020 3:02:19 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@12e4917 -- 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: Network error IOException: Connection refused: connect
    at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)

i have used this in my connection

B4X:

#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.

#DATABASE CONFIGURATION
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://192.168.43.215/TestSQLServer
User=sa
Password=123
#Java server port
ServerPort=17178

#SQL COMMANDS
sql.select_employees=SELECT id,name,salary FROM Employees WHERE id >= ?;

OliverA · May 10, 2020

The jTDS is an old, not really up to date way of accessing DB’s such as MSSQL. It’s primarily used on Android due to Android’s inability to work with the newer MS developed JDBC drivers. It is those newer drivers that you should be using, especially when connections to anything past 2012 SQL server. Right now the message says that the connection string you are using is not correct. Be it incorrect DB name, user name, password, maybe no SSL connection, etc. Instead of working on a solution for this driver, I would first Seith to the latest driver from MS

Bladimir Silva Toro · May 10, 2020

Check the remote connection of your SQL Server. Go to the SQL Configuration Manager and verify that the TCP / IP protocol is enabled on port 1433

Follow the steps that are the following link: https://www.c-sharpcorner.com/artic...express-on-lan-for-c-sharp-connection-string/

Albert Kallal · May 11, 2020

Makumbi said:
iam trying to test whether the server for jdbc2 sqlserver is ok but iam getting this error

please help i have seen erel's example but it talks about mysql please is there a step by step configuration from iis so that i can make my project run thanks

A few things:
These days with "requiring" the sql server browser service to be running? Well, then on the computer where sql server is running, then each instance of SQL server running gets a automatic port assigned. The browser service THEN translates that to the standard port number (1433).

Also, in the connection string? You do not include the sql instance as part of the server:
eg: NOT
dbc:jtds:sqlserver://192.168.0.120/SQLEXPRESS;DatabaseName=CUSTOMERS (wrong!!!!)

You use:

B4X:

jdbc:jtds:sqlserver://192.168.0.120;Instance=SQLEXPRESS;DatabaseName=CUSTOMERS

Note how the "instance" is to be specified separate from the server name.

I have a working sample in this thread here:

How to Connect to MS-SQL Server 2016 in B4A

Hi to all , Please let someone explain to me with an example, and without referring to other links, the method of connecting to a database MS SQL server that is on my computer (local) I was confused by the traffic between these links. (I was read many link in this forum about this item and test...

www.b4x.com

In above, I have a connection builder where you enter server, database, instance, User and pass.

So, it has this setup screen:

If above don't work, then your code will not work either. My sample (unfortunately) does not include/have port number option.
(maybe I'll add that).

so, make sure SQL browser service is running (that what translates the IP address to the actual IP address and port number that sql server now uses for the instance).

And I wish the suggestions here to try/use the Microsoft drivers would work? But I not been able to use them, but the JTS driver works fine.

This can be confusing, since the Microsoft driver DOES use the sql "instance" in the server name (or IP) part, but the JTS does not!!
(you specify the instance separate from the server name (IP) address.

Regards,
Albert D. Kallal
Edmonton, Alberta Canada

OliverA · May 11, 2020

Albert Kallal said:
And I wish the suggestions here to try/use the Microsoft drivers would work? But I not been able to use them, but the JTS driver works fine.

As I stated before, Microsoft Drivers will not work on Android. This is mostly due to the fact that these drivers are targeted towards modern JDK8 and upwards. Since the original poster is using B4J, they should really be using the appropriate driver (targeting the appropriate JDK and the appropriate 32/64 bit platform)

Albert Kallal · May 11, 2020

OliverA said:
As I stated before, Microsoft Drivers will not work on Android. This is mostly due to the fact that these drivers are targeted towards modern JDK8 and upwards. Since the original poster is using B4J, they should really be using the appropriate driver (targeting the appropriate JDK and the appropriate 32/64 bit platform)

Yes makes sense.

I did play for (chew up) a few hours trying to get the Microsoft drivers to work. Some googling resulted in some posts + discussions. It seems to fail due to the first "whack" at the server and attempts to use SSL connection. And there are options in the connection string to disable SSL, but they don't seem to work. So, it centers around the "original" handshake kind of issue. So, it starts to connect, but chokes on connecting. There are some discussions around TLS or some such - apparently some have managed to make them work.

I think MS drivers would be better, but I could not get around the SSL handshake issue - that's where the "issue" was. I suspect also that the driver was never intended for Android also crops up. I'll re-visit this issue some day, but the JTS driver been working for me rather well anyway.

R
Albert

OliverA · May 11, 2020

Albert Kallal said:
I'll re-visit this issue some day

Unless something changes in the underlying Java implementation in Android, this will be a futile endeavor (wasted some time on this too).

Android Question error while trying to test jtds-1.3.1

Makumbi

Well-Known Member

Attachments

Bladimir Silva Toro

Active Member

Makumbi

Well-Known Member

OliverA

Expert

Bladimir Silva Toro

Active Member

Albert Kallal

Active Member

How to Connect to MS-SQL Server 2016 in B4A

OliverA

Expert

Albert Kallal

Active Member

OliverA

Expert

Android Question error while trying to test jtds-1.3.1

Well-Known Member

Attachments

Active Member

Well-Known Member

Expert

Active Member

Active Member

Expert

Active Member

Expert

Privacy & Transparency

Privacy & Transparency