jdbc

  1. ghale

    B4J Question [SOLVED] How to enable Jaybird library

    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...
  2. Alexander Stolte

    B4J Question jRDC2 PostgreSQL how to call procedures

    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...
  3. M

    Android Question JDBC run a MSSQL stored procedure with in & out params

    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"...
  4. 3

    Italian connessione jdbc con host

    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 =...
  5. 3

    Android Question error with #AdditionalJar

    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
  6. 3

    Android Question jdbc Question with B4A 3.20

    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?
  7. R

    Android Question Problem with JdbcResultSet

    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"...
  8. G

    Android Question JDBC MySQL

    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 & ",'" &...
  9. J

    B4J Library jJasperReports Library

    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 All jars need to be...
  10. KMatle

    Other Updates for sqlite-jdbc

    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...
  11. C

    Android Question MSSQL-JDBC Minimalistic Example

    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...
Top