I'm currently examining Pulsar JDBC sinks, as we plan to use a PostgresSQL sink soon. Now, it's mentioned that JDBC sinks support insert/update/delete ops, but
I'm not a Java developer, but a systems administrator, so forgive me for any senseless statement or questions. I suspect the C3P0 connection pooling is not set
I'm making a dynamic query to pass to mysql based on which variables I'm passing are not null. I can build the query without a problem, but I can't understand h
If the preparedStatement sql is fixed, how can I do the insert? table schema create table if not exists ttqs_a (b bit(1)); code try(PreparedStatement ps = conn
e.g, below query: create table t1 ( age int, name varchar(10) ) insert into t1 values(1, 'name'),(2, 'surname') copy select * from t1 into 't1.dat' DELIMITER
I'll definitely need to update this based on feedback so I apologize in advance. The problem I'm trying to solve is roughly this. The graph shows Disk utilizat
I want to read a txt file which has oracle insert statements in java program and execute as a batch, If any of the record gets failed in the batch, How do i get
I have recently updated DBeaver from 7.0.4 to 22.0.1 and encountered this issue. I have tried to add SimbaAthenaJDBC-2.0.27.1001.zip into its
I am trying to access my SQLite database which is in a Java package. When I am giving it's absolute path then it's OK, but when I am putting my db file inside j
I have a short question about pyspark write. read_jdbc = spark.read \ .format("jdbc") \ .option("url", "jdbc:postgresql:dbserver") \ .option("dbtabl
I don't understand why the code doesn't works on Android, it's the same code in Java and it's works on my laptop. I've already search on Google, Stackoverflow,
I am using Intellij for a servlet project and using maven <dependency> <groupId>mysql</groupId> <artifactId>mysql-conn
I am using Intellij for a servlet project and using maven <dependency> <groupId>mysql</groupId> <artifactId>mysql-conn
I'm making an application for a school project, but I'm running into the issue that when I try to run the unit tests that it tries to connect to the database wh
I have configured my Tomcat 9 to keep a database pool using the server.xml in order to have a minimum of 50 connections to my mysql database. When the tomcat st
In my Spring MVC application, I have @Transactional annotated method inside which I make call(select query) to DAO layer inside for loop. If my input list size
I performed login using form based authentication in tomcat(using j_security_check). I have added jdbc realm code in server.xml and also security constrains in
Let's say there is a sequence created on SQL Server: CREATE SEQUENCE dbo.my_seq START WITH 1 INCREMENT BY 1 NO CYCLE; GO And the following Java cod
I am using Android Studio [Android Studio Arctic Fox | 2020.3.1 Patch 1] My room library version is [2.3.0] Used Gradle version [7.0.1] Also added kapt 'org.xer
I have got a problem with database queries, when I try to run them from my groovy script. Sometimes, but very often, I've got an error: com.microsoft.sqlserve