Category "jdbc"

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

JAVA/MSSQL: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed

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

Single Large Transaction VS Multiple Small Transaction

I am designing a system where users can select/ insert/update/ delete multiple rows of multiple tables multiple times (n times in a loop based on some logic, th

Why is reading a JDBC ResultSet by position faster than by name and how much faster?

Announcing Hibernate 6 the Hibernate team claims that by switching from read-by-name to read-by-position in JDBC ResultSet they gain a performance benefit. Hig

org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0

i'm this following error when i submit for copying data here is the code.. public String deleteExistingRecordWeekWise(String monthOrWeek) throws ApplicationExc

Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] for XAMPP and Eclipse IDE

I am using XAMPP server and Eclipse IDE for running a hibernate program. But I am getting the following error: **Apr 21, 2017 12:46:38 PM org.hibernate.Vers

SQL Anywhere Error - 210: User 'another user' has the row in 'tablexyz' locked

I have multiple Java process which launches serially one by one. This process does job of loading data into tablexyz and then tablefinal. After first process fi

Returning ResultSet without close?

I would like to have a database connection managing class which I can use for simple SQL commands like SELECT, INSERT etc. by simple calling something like this

Google Apps Script JDBC ResultSet to Array

Is there a better way of retrieving the results from a ResultSet? Calling getString() on each value is very slow. It takes up to 2.5 seconds to put about 400 r

which jdbc (connector/j) to install for mac os

I'm trying to download jdbc connector, but I cannot find mac os from the selection options from the link below: https://dev.mysql.com/downloads/connector/j/ W