I am trying to setup a simple JDBC client to talk with a database in Ballerina. However the "compile" ( VSCode ) error that is shown says: invalid remote method call: expected a client object, but found (ballerinax/java.jdbc:1.7.0:Client|ballerina/sql:1.7.1:Error)(BCE2421) Here is…
I need to convert latin1 charset of a table to utf8. Quoting from mysql docs: The CONVERT TO operation converts column values between the original and named character sets. This is not what you want if you have a column…
I want to control the throughtput of a JDBC source kafka connector. I have a lot of data stored in a PostgreSQL table and I wand to ingest it into a Kafka topic. However I would like to avoid a…
I have a project for sending data from DB2 on an IBM system over to a PostgreSQL server on a RHEL system. I am using a trigger that sends information to a data queue, which then gets read and sent…
I have following class: public class Person { private String firstName; private String lastName; private List<String> habits; } I have Postgres query which returns me following result using inner join from 2 tables name | lastname| habits -------------------------------------- John |…
I am using springboot 2.7.4 when I try to connect to Postgres db on azure I met the error org.postgresql.util.PSQLException: FATAL: FIPS cipher suites are enforced for this >server. Please specify FIPS complying cipher suites in your SSL/TLS settings. How…
Basically, how can I change the following so I don't have multiple question marks?: public static int insert(int id, String name, String address, String phone, int age) throws SQLException { String SQL = "INSERT INTO some_table (ID, Name, Address, Phone_Number,…
I have a series of queries which are now not paralellised, the java code looks something like this: private List<EntityA> cacheA = Lists.newArrayList; private List<EntityB> cacheB = Lists.newArrayList; private List<EntityC> cacheC = Lists.newArrayList; // ... public class Cache { private…
I created a container for an Oracle Express database following these instructions, with the following command: docker run -d -e ORACLE_PWD="root" --name testdb -p 5500:5500 -p 8080:8080 -p 1521:1521 container-registry.oracle.com/database/express:21.3.0-xe What does work I managed to access the database from…
I try to initialise my database in Java by running testdb.sql file private static Connection con; private static void initConenction() throws SQLException{ //Getting the connection String url = "jdbc:mysql://localhost:3306/testDB?allowMultiQueries=true"; final String userName = "root"; final String password = "mypassword"; try…