Search Results

This is a port of B4J jSQL library. The SQL type was renamed to JdbcSQL and ResultSet was renamed to JdbcResultSet, this allows using it together with the SQL library. SQL library - local SQLite databases. JdbcSQL - Any remote SQL database with a supported JDBC driver. MySQL and MS SQL.... As explained in the jSQL tutorial, you need to copy the jdbc jar to the additional libraries folder... updating the app. - Server and client performance issues - The Jdbc drivers are not optimized for...

. Disclaimer: This code with some minor changes may also work in B4A. MySQL and MSSQL connectors definitely do work in B4A but I'm not sure about the PostgreSQL, MariaDB and Oracle connectors. Please check...
link: can you please share your northwind db, perhaps its the most up to date. Hello @Mashiane, please l...
link: Hi Peter, can you please share your northwind db, perhaps its the most up to date. Thanks. I'...
link: Hi Peter, can you please share your northwind db, perhaps its the most up to date. Thanks....

Not quite understand what changes should be made if I want to connect to a MSSQL #AdditionalJar: jtds-1.3.1 Public mysql As JdbcSQL Private driver As String = "com.mysql.jdbc.Driver" <- what to change?? Private jdbcUrl As String = &quot;jdbc:mssql://192.168.0.6/test" Private Username As String = "username" Private Password As String = "password"...

Hi All, My B4A app uses JdbcSQL to talk to a MySQL database on my local RPI server and performs... ** main$ResumableSub_Activity_Createresume (java line: 401) com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not...
link: is that you should switch to SQL.InitializeAsync as you don't want to do any network stuff...
link: Thanks Erel, This has allowed me to run the app in release mode. For my education, what causes thi...
link: Try this: Workaround the NetworkOnMainThread exception Maybe this is the real error and it is caug...

possible errors ? I am using JdbcSQL to connect to remote MySQL database Here is the code I used to do... As String Private mysql As JdbcSQL End Sub Sub Upload_Click Dim Batch As List Batch...
link: The connection may be already broken. I think better make a new connection and close after using it...
link: The connection may be already broken. I think better make a new connection and close after using it ...
link: the previous initialization. In the same activity, before calling this routine, I am connecting to MySQL...

Hi, As said in the title, I am using jdbcSQL to connect to a MySQL server ver 8.0.30 I understand... a different database, but residing on the same server. This app does not use jdbcSQl instead it uses...
link: running I uninstalled MySql server ver 8 and went back to MySQL server ver 5. I am sure...
link: I am using jdbcsql with a mysql 5.1.43 server in an B4A app with no problems. I already...
link: I am using jdbcsql with a mysql 5.1.43 server in an B4A app with no problems. I already...

Activity_Resume End Sub Sub Activity_Pause (UserClosed As Boolean) End Sub Sub Button1_Click Dim sql As JdbcSQL Dim jsql As JdbcResultSet sql.Initialize2("com.mysql.jdbc.Driver", &quot;jdbc:mysql://sql2.freesqldatabase.com:3306/databasename","user","password") jsql=sql.ExecQuery("select ragsoc from aappuntamento ") Do While jsql.NextRow Log(jsql.GetString... mode it doesn't work? what's the error? com.mysql.jdbc.exceptions.jdbc4...

Hi I read allot inside the forum about how to connect jdbcSQL with Sql server but I can't understand it. All info are split in several post confusing very much specially newbies like me. There are no complete tutorial - example saying from start to end how to do it? Thank you....
link: May I suggest you to start a new thread? Eventually sporting a link to the current one, if you find that your problem is related. Thi...
link: mode. The Online Database is MSSqlServer using JdbcSQL and the local database on the device is SQLlite...

Hi all, I used sample code to connect JdbcSQL from the link JdbcSQL forum link The ExecQueryAsync...) End Try CloseConnection End If Return Success End Sub java.sql.SQLException: Could...
link: -system-variable-tx-read-only Which database are you using and which Jdbc driver? Thank you for the lead...
link: database are you using and which Jdbc driver?...
link: ("mysql", driver, jdbcUrl, Username, Password) Wait For MySQL_Ready (Success As Boolean...

My first time at trying to connect to a MySQL database and I am trying this example: https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/ And I keep getting...
link: Thank you, In my mind, you have come a long way toward saving world poverty and maybe suffering. S...
link: why! this is due to every other case when you connect to SQL server I can think of - from...
link: But with jdbc, you ONLY are to enter the server name without the SQL instance, and the instance...