jdbc

Hi everybody! This thread is supposed to get all SQLite JDBC library version links together so as to find and download them easier. As a heavy B4J+SQLite user, I'm always looking forward to have new JDBC versions. All information contained herein has been taken from Mr. Taro L. Saito (xerial)...

Hello people, I'm trying to figure out how to add jaybird library to a test project I'm doing because I want to connect to a Firebird database. So, from Firebird JDBC Driver page I've downloaded "Jaybird-3.0.6-JDK_1.8.zip" file and I've decompressed it. I copied "jaybird-3.0.6.jar" file into a...

Hello, how can i call procedures in jRDC2 on PostgreSQL? I call it so: CALL myprocdeure(?,?) but jRDC2 says: org.postgresql.util.PSQLException: ERROR: procedure sdbspget_checkuser(character varying, character varying, character varying, character varying) does not exist Hinweis: No procedure...

Hello, I am stuck with JDBC and MSSQL. I have successfully connected using JDBC like so: Sub Process_Globals Public msSQL As JdbcSQL Private driver As String = "net.sourceforge.jtds.jdbc.Driver" Private jdbcUrl As String = "jdbc:jtds:sqlserver://192.168.100.212/OPENXMLTesting"...

buongiorno a tutti, è da un po che tento di collegarmi al mio sqlserver ma non riesco in nessun modo. Public mysql As JdbcSQL Private driver As String = "com.mysql.jdbc.Driver" 'Private jdbcUrl As String = "jdbc:mysql://192.168.0.2:1433/SQLTutorial" Private jdbcUrl As String =...

i have this error in my B4A application #AdditionalJar: mysql-connector-java-3.0.17-ga-bin.jar Parsing code. Error Error parsing program. Error description: Attribute not supported: additionaljar Occurred on line: 14 #AdditionalJar: mysql-connector-java-3.0.17-ga-bin.jar

so, if I did not understand, I who have B4A can not use the JDBC library to access a db on Serer Mysql? or didn't I understand correctly?

I have a problem with this code: Dim sql1 As JdbcSQL Dim ObjetoSql As Object Dim recipes As List Dim sql As String Try sql1.Close sql1.InitializeAsync("Connect", "net.sourceforge.jtds.jdbc.Driver"...

Is there any way to validate that an INSERT query was succesfull on a remote MySQL database? Other than to then run another query to retrieve the recordset created? e.g. sSQL="INSERT INTO statements_collected(ID, Client, DeviceID) VALUES(" & Crsr.getint("ID") & "," & Main.iUserID & ",'" &...

Hi. I want to share this jJasperReports library with the community. It needs several libraries to work. I provided a link: download ---More libraries needed (missing from the first link): download You also need to download databases jdbc drivers: sql jdts, mysql and oracle New Link (All jar...

Check for updates here: https://bitbucket.org/xerial/sqlite-jdbc/downloads/ Newest version (18.8.2018): sqlite-jdbc-3.23.1 Just copy the newest version to the AdditionalJar folder and delete the old one. Set the reference in "#Region Project Attributes" #Region Project Attributes...

Ok... I am trying to get B4A to connect to an in-house MSSQL server (2014) using a direct JDBC connection. However, things are a bit confusing for an outsider new to B4A and I keep getting "unknown error (14) Can't open database" in the log. This server is running other in-house databases so...