Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [java]

Use ONLY if Java is directly relevant to the question and likely to be the source of your problem, not just because you're using a Java library to connect to a database. Java is an object-oriented language and runtime environment. Java programs can run unchanged on most platforms in a Virtual Machine called the JVM. If you have a general programming question about Java, please ask it on Stack Overflow instead.

Filter by
Sorted by
Tagged with
0 votes
2 answers
50 views

Failed to link the C library against JNA, Cannot open shared object file

I am having issues with installing Cassandra 4.0 and 4.1 on my rhel 8 server. I've tried using java 11 openjdk and Corretto 11 openjdk. When I start Cassandra I would receive: Native LibraryLinux.java ...
jexport's user avatar
0 votes
0 answers
60 views

JDBC using DataSource, DB2 and Kerberos

I am trying to set up a JDBC using DataSource interface, DB2 database and Kerberos for authentication. I am using IBMs documentation which refers in Kerberos security with no user ID or password link ...
bagb's user avatar
  • 1
1 vote
1 answer
51 views

Apache Cassandra node restarts randomly

I have a cluster of 11 nodes, Apache Cassandra version 3.11.4, where certain nodes are restarted at random times. Nodes characteristics: CPU(s): 32 Model name: Intel(R) Xeon(R) Silver 4110 CPU @ 2....
Midas Salimgali's user avatar
0 votes
1 answer
327 views

Oracle DB - can it run without JDK, JRE that is installed together with?

Our client is scanning for outdated JDKs or JREs and found those in Oracle DB instance files, installed files. Is it safe for Oracle DB to remove JDK, JRE? Name="Java(TM) SE Runtime Environment&...
Jakub P's user avatar
  • 157
0 votes
0 answers
43 views

Java Inheritance - Hibernate6 + JPA - How to prevent selecting all child tables when joining on parent?

I'm working on a Java application that uses Hibernate6 + JPA. I have classes like class Thing { Parent parent } class Parent { } class ChildA extends Parent { } class ChildB ...
frobot's user avatar
  • 9
1 vote
0 answers
31 views

Possible explanation for why "SELECT" query executed from JDBC returning just the first row in the table

I installed OracleDB(XE - free version) and I tried to use it in Java. I have this code: static final String DB_URL = "jdbc:oracle:thin:@localhost:1521/XE"; static final String ...
Bogdan Floareș's user avatar
0 votes
0 answers
71 views

Oracle database connection performance dropped to bottom, causing severe performance issues in web application and scheduler job failures

We have some batch scripts as task scheduler jobs, which are running good from few years. These jobs connects to DB and will do multiple inserts and update operations using sqlplus, sqlldr and java ...
user avatar
0 votes
0 answers
573 views

SQL*Net message from client too important

It is not easy to describe my problem but I will try. We noticed a slow processing problem with the database when migrating an application from a current VM named VM1 (RedHat 7.9, Java 8, Tomcat, ...
user avatar
1 vote
0 answers
314 views

Use 2 columns of a table as foreign key in an other table to avoid circular-reference

I have two tables: ObjectContainer containerID INT NOT NULL PRIMARY KEY mainObjectID INT NOT NULL FOREIGN KEY REFERENCES Object (objectID) Object objectID INT NOT ...
Xudla's user avatar
  • 11
0 votes
1 answer
1k views

Java PostgreSQL library seems to convert dates to local time zone automatically

PostgreSQL 14.6 Ubuntu 22.04 I am using postgresql-42.5.4.jar which I downloaded from pgJDBC. I use this library to get data from a database and display it on a website running locally. The web server ...
Zephyrus's user avatar
  • 301
2 votes
2 answers
648 views

Why does Cassandra lose data when there is an outage on one node with RF=2?

Cassandra works in docker containers. Cassandra version: 3.11.10. Cassandra-driver-core: 3.10.2. Cassandra restart policy: unless-stopped. Cassandra cluster: 3 nodes. Keyspace replication factor: {'...
Konrad Bączyński's user avatar
0 votes
1 answer
228 views

Can I copy a newer Java JRE over the existing one in Oracle Client 19.16?

A server I manage has Oracle Client 19.16 with Java JRE 1.8_331 installed. Can I just copy a newer version of the Java JRE, like 1.8_351 over the old one without having any negative effect on Oracle ...
js1983's user avatar
  • 103
-1 votes
1 answer
1k views

PostgreSQL claims my query has violated unique key constraint on id [closed]

I'm struggling with an error, and I think it has to do with PostgreSQL. I'm trying to insert values in a database created 3-4years ago. The java program use Hibernate and lombok. The original program ...
Yannick Mussche's user avatar
2 votes
1 answer
1k views

Optimize the number of connections of the connection pool and MySQL

We are using Oracle Cloud's Ampere A1 instance consisting of 4 OCPUs (equivalent to 4 vCPUs) and 24GB of usable memory on Oracle Linux 7.9. On the server is running an java game server and a web ...
Tần Quảng's user avatar
0 votes
0 answers
117 views

Get index of JSON data in PostgreSQL

I have the next JSON structure in my PosgreSQL: [ { "name": "Ryzen 9", "path": "fitnessappmaven\\src\\main\\java\\com\\klaro\\fitnessappmaven\\tempWorkoutIcons\\...
Robin Gergelyfi's user avatar
0 votes
1 answer
616 views

Update specified data in PostgreSQL/ JSON based on 2 conditions

I searched a lot to find solution and I found something similar but unfortunately I couldn't apply it to my case, maybe because I am yet new to Postgres. The link to this similar issue is here: Update ...
Robin Gergelyfi's user avatar
4 votes
1 answer
4k views

nodetool with Java 8u331 returns "URISyntaxException: 'Malformed IPv6 address at index 7: rmi://[127.0.0.1]:7199'"

Why does running nodetool return the following exception? nodetool: Failed to connect to '127.0.0.1:7199' - \ URISyntaxException: 'Malformed IPv6 address at index 7: rmi://[127.0.0.1]:7199'. This ...
Erick Ramirez's user avatar
0 votes
1 answer
286 views

Oracle 21c XE, need install/enable JServer JAVA Virtual Machine, but ORA-00904

In Oracle 21c XE, I need install/add JServer JAVA Virtual Machine. When I try to install it, there is a problem, exactly ORA-00904: "PSU_VER": invalid identifier. SQL> @?/javavm/install/...
genderbee's user avatar
  • 191
0 votes
1 answer
61 views

NDB Cluster Read and Write Process multiple Access

When using the MySQL NDB Cluster distributed database, the following general problem has arisen: To insert a new Record / Row, the last row in the database should be read, see if it is compatible with ...
programmer_13's user avatar
1 vote
1 answer
654 views

Run MSSQL stored procedures containing SSIS packages using Windows Authentication from another computer

I am new to MSSQL. I have a question about executing MSSQL Stored Procedure. Let me briefly talk about my development environment first: PC400 (Computer/Server A), where SQL Server 2012 is installed ...
garethlam's user avatar
1 vote
0 answers
412 views

SSL connection error when connecting to MySQL, using JDBC

The problem that we are facing is well documented in https://stackoverflow.com/questions/34189756/warning-about-ssl-connection-when-connecting-to-mysql-database. We started facing this issue upon ...
Sandeep's user avatar
  • 265
0 votes
1 answer
73 views

why does external java function terminate recursive cte?

I made a peculiar observation regarding external functions written in java which I hope someone can shed a light on. I tried it with several functions, but I'll use one of them as an example here: ...
Lennart - Slava Ukraini's user avatar
1 vote
2 answers
3k views

I cannot create a table in mysql

create table Statistics_tbl with ( SELECT Todo_tbl.person, SUM(Todo_tbl.duration) FROM Todo_tbl JOIN Statistics_tbl on Todo_tbl.person = Statistics_tbl.person GROUP BY person; ); The issue is that ...
Hanna Frankowska's user avatar
1 vote
1 answer
123 views

How can I join two tables in mysql, so that whenever I add data to table 1, table 2 updates as well?

This is the code creating my first table create table Todo_tbl ( id INT auto_increment, person VARCHAR(45) , task VARCHAR(45) , duration INT(4), deadline_day VARCHAR(2), deadline_month VARCHAR(2), ...
Hanna Frankowska's user avatar
0 votes
1 answer
3k views

How to automatically update table, whenever data added to another table?

I have created two tables in MySQL. One (Todo_tbl) holds the data while the other (Statistics_tbl) hold the sums one of the variables from Todo_tbl. Following the definitions of these tables: create ...
Hanna Frankowska's user avatar
0 votes
0 answers
1k views

How to load Java in Oracle Database using SQL Developer?

I'm running Oracle 19. I would like to load some Java classes using SQL Developer, but the option is greyed out. Is there any necessary grants to do that? Or is there any other way to do it via SQL ...
user32026's user avatar
  • 141
0 votes
1 answer
100 views

When should I use Index on PostgreSQL? [closed]

In my Java (Spring Boot app), I have the following entity definition which has a relationship with Company entity via companyUuid property. I will also let users to search by name field. We do not ...
Henry's user avatar
  • 1
0 votes
1 answer
604 views

how do I copy oracle java stored procs from one database to another?

I have an oracle database with some java stored procs. I am creating a dockerized version of the database for our developers to use. I can use oracle sql developer to copy all normal pl/sql procs to ...
George's user avatar
  • 127
-1 votes
1 answer
370 views

I want to drop existing table space and add the freed space to the new table space in oracle

I want to drop existing table space and add the freed space to the new table space in oracle. I am trying drop an existing tablespace on oracle db, and then use the freed space for a new table space. ...
kbj's user avatar
  • 1
0 votes
0 answers
31 views

Optimal way of running hundreds of thousands of DDL/DML statements MySQL

I have about 500k DDL/DML statements that need to be run against a MySQL 5.7 INNODB RDS instance from scratch. A significant portion of these are created table statements. I'm currently employing a ...
user avatar
0 votes
0 answers
54 views

SQL connections to java applications

I have an MSSQLServer2000 database that seems to have been working just fine until today. The DB connects to a java application on a remote server that passes the database data (login credentials, ...
mcv110's user avatar
  • 75
1 vote
0 answers
373 views

Error occurred in Spring boot + Gradle + Oracle jdbc + jsp project

I'm doing Spring boot project, and I'm trying to add dependencies which are ojdbc8 and tomcat-embed-jasper. ojdbc8 library is for connecting Oracle database by using Hikari, and tomcat-embed-jasper is ...
generator's user avatar
1 vote
1 answer
4k views

Can Microsoft JDBC Driver 4.0 connect to SQL Server 2019 and perform DML without issue?

The SQL version compatibility BOL article advises that the minimum compatible JDBC driver version for SQL Server 2019 is 7.4. Can an older JDBC driver still connect to SQL Server 2019? Or can only the ...
Pixelated's user avatar
  • 1,434
0 votes
1 answer
213 views

What is the format of EXTERNAL NAME argument?

When a Java class cl with a method mth resides in a package pck, what should I put into the EXTERNAL NAME clause of CREATE PROCEDURE? I tried CREATE PROCEDURE mth (arg1 INTEGER) LANGUAGE JAVA EXTERNAL ...
Gandon Jank's user avatar
2 votes
1 answer
6k views

How to configure TCPS in JDBC thin client for oracle

An Java Application running with JDBC thin wtih TCP connection, Now require is to convert in TCPS for encryption transmission from application to database. String url = "jdbc:oracle:thin:@(...
Nullpointer's user avatar
0 votes
1 answer
576 views

Queries of MySQL from Java are executed serially from multiple threads

I have REST API developed in spring + java and hosted on Tomcat server. I have a MySQL database where i store all my data. API makes just simple select from db as descripted below. I failed ...
Dawid Bielarski's user avatar
0 votes
1 answer
64 views

does using optimizer_mode=first_rows_n for application that using Oracle database is a best practice?

So I'm working in application that involving display of data in table/grid. And the grid will invoke paging query to oracle. So does by tuning my application to get the best query cost with ...
Gusti Andika's user avatar
0 votes
0 answers
49 views

Update table_name set column1 from where column2 (column2 mutiple diffirent value)?

Hi I'm working with this Query to update all the row in the table using a String of multiple values. I'm trying some Query but i get an error the error is "Truncated incorrect DOUBLE value" this is ...
Kinsee 's user avatar
2 votes
1 answer
698 views

How to determine if Oracle Java classes are being used

Oracle EE 12.1.0.2 As part of a general clean up of a legacy application prior to a migration I'm trying to determine what objects are actually in use. There are some 230 JAVA class objects in my ...
Evelyn Dibben's user avatar
0 votes
1 answer
694 views

Install Oracle Weblogic: Unsupported major.minor version 52.0 [closed]

I tried to install Oracle Weblogic on Redhat Linux 8 using command java -jar fmw_12.2.1.4.0_wls_quick.jar but got an error: Unsupported major.minor version 52.0 Java version java version "1.7....
soulivong's user avatar
0 votes
1 answer
335 views

how to get data from two tables in mysql query with where Pk of one table is set as foreign key on PK column for other table?

The query I am using to retrieve data is as "select sum(totalbill) as tbdb, sum(discinamount) as tddb, sum (billafterdisc) as tbaddb," + " sum(totalqt) as tqdb," + " sum(payed) as tpdb," + " sum(...
user191895's user avatar
0 votes
1 answer
247 views

Use quoted schema in an insert statement executed thorough PreparedStatement in Java

I created an unquoted table my_table under a quoted schema "Quoted_User". When executing the statement INSERT INTO "Quoted_User".my_table (custom_id) VALUES (DEFAULT) using the Intellij Oracle ...
Mattia Moretta's user avatar
-1 votes
1 answer
533 views

pg replication connection not returns wal events to java code client , it hangs some times

Describe the issue We are facing issue of pg replication slot not listen database wal events. Once pg database restarted and we attach Driver Version: 42.2.6 Java Version: JDK1.8 OS Version: Window ...
vaibhav.patil's user avatar
2 votes
2 answers
3k views

Does oracle client 12c requires Java on windows

if I install Oracle 12c client on window server, does it get Java installed? can we install oracle driver/client without Java?
rmdussa's user avatar
  • 183
1 vote
1 answer
394 views

Oracle save mandarin characters with we8iso8859p1

Im trying to save Mandarin characters into Oracle instance database 11g. Field datatype - NVARCHAR2 ; NLS_LANG - AMERICAN_AMERICA.WE8ISO8859P1 If I change NLS_LANG, it will affect other data already ...
surm's user avatar
  • 11
-2 votes
1 answer
41 views

Should I use the LIKE predicate or fetch all rows and process them on the client?

I am optimizing my application, while this task, I find one query which is fetching data from database using like . and database rows are around 10000. So is this a good way to use like in query or I ...
Dupinder Singh's user avatar
1 vote
1 answer
188 views

Troubleshooting oracle database errors from cloud application

I am trying to troubleshoot an issue that presents as different database errors such as, ORA-01000: maximum open cursors exceeded or Unable to create DB Connection. I have reviewed the PLSQL to ...
Gloria Santin's user avatar
0 votes
1 answer
2k views

How to determine/set the Java classpath for an Oracle DB?

l am trying to make use of some proprietary Oracle Java classes/methods using an Oracle provided virtual machine (E-Business Suite Vision, Oracle 12.2.28) On my test server I define a function: [...
Elliot's user avatar
  • 101
0 votes
0 answers
735 views

SQLServer JDBC Driver]Object has been closed

I had few queries in code which were running in loop. They all were wrapped inside a code function. There were frequent deadlock with the queries. Because I do not understand the logic too well, I was ...
CFML_Developer's user avatar
1 vote
1 answer
823 views

Which java JDK is compatible with oracle instant client 10g

I'm an intern stuck trying to retrieve data from Oracle 8i (a database that is as as I am) The problem: I need to write a java script that pulls data from Oracle 8i into a newer server. The last ...
Nicolasome's user avatar

1
2 3 4 5