Category "jdbc"

NullPointerException in Apache Kylin when using JDBC

I use Kylin from Docker: https://kylin.apache.org/docs/install/kylin_docker.html I downloaded sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz to SQOOP_HOME directory. When

Apache Pulsar JDBC sink: differentiation between insert/update/delete

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

Hibernate - C3P0 JDBC connection pooling

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

How can I handle a search by a dynamic set of variables in JDBC?

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

how to insert value for bit column of postgresql with jdbc

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

MonetDB: jdbc based queries return -1 as affected rows often even though the query was successful

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

What could cause a sqlite application to slow down over time with high load?

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

JDBC Batch insert exception handling to know the particular failed record

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

Dbeaver 7.0.4 No suitable driver found for jdbc:awsathena://AwsRegion=us-east-1; [duplicate]

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

SQL error coming while trying to access SQLite.db

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

How to create a CSV file with PySpark?

I have a short question about pyspark write. read_jdbc = spark.read \ .format("jdbc") \ .option("url", "jdbc:postgresql:dbserver") \ .option("dbtabl

Error of connection jdbc postgreSQL Android Studio - Failed resolution of: Ljava/lang/management/ManagementFactory;

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,

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver even after using the mySql Maven Dependency on Intellij

I am using Intellij for a servlet project and using maven <dependency> <groupId>mysql</groupId> <artifactId>mysql-conn

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver even after using the mySql Maven Dependency on Intellij

I am using Intellij for a servlet project and using maven <dependency> <groupId>mysql</groupId> <artifactId>mysql-conn

how to prevent jdbc from trying to connect to a mysql database during unit testing

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

Why my Tomcat 9 does not keep the jdbc connections open as it is specified in minIdle?

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

select query inside loop - Database connections in JPA

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

Form based Authentication in Tomcat

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

Why is SQL Server sequence jumping by two when fetched from Java code?

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

Caused by: java.lang.Exception: No native library is found for os.name=Mac and os.arch=aarch64. path=/org/sqlite/native/Mac/aarch64

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