Category "jdbc"

What is the difference between jconn4.jar and jconn42.jar?

Basically in the installation SDK of Sybase 16 we have jconn4.jar and jconn42.jar. What is the difference between jconn4.jar and jconn42.jar?

Is it possible to connect to serverless sql pool via azure databricks?

I'm trying to connect to synapse serverless pool via databricks. I need to create synapse views and external tables directly in databricks as part of an existin

Retrieve clob data using apache camel

I am polling clob column using apache camel as below. <route> <from uri="timer://timer1?period=2m" /> <setBody>

Snowflake JDBC database metadata not returning getImportedKeys

I have Java code that extracts metadata from a JDBC connection. One of the calls is to extract the imported keys. The database has the RI created, but is disa

Oracle wallet -(Exception)Invalid number format for port number, while trying to establish JDBC connection

I am trying to make JDBC database call(Using Oracle wallet) using spring boot application but getting below exception. org.springframework.jdbc.CannotGetJdbcCon

Oracle wallet -(Exception)Invalid number format for port number, while trying to establish JDBC connection

I am trying to make JDBC database call(Using Oracle wallet) using spring boot application but getting below exception. org.springframework.jdbc.CannotGetJdbcCon

How to register a JDBC Spark dialect in Python?

I am trying to read from a databricks table. I have used the url from a cluster in the databricks. I am getting this error: java.sql.SQLDataException: [Simba][

Spring boot r2dbc and jdbc Liquibase does not update on application start

I want my application to use r2dbc drive when running and jdbc to handle the database with Liquibase. I have this as a reference. It is possible by adding the c

Spring Boot/Spring Batch: Using and configuring two DataSource via app properties

I'm working with Spring Boot/Spring Batch, and need to provide two jdbc Data Sources. I can't find a way to automatically load the config parameters from my app

Error while parsing, when loading the data from snowflake having array datatype

I am trying to read data from snowflake and load it to other storage location. I am using snowflake jdbc driver 3.12.9 to read the data and jackson library(2.10

Exception in thread "main" com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

Exception in thread "main" com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sent successfully to the server was

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