All Questions
10,778
questions
-1
votes
0
answers
22
views
Operation timed out when call JDBC driver from Oracle java stored procedure
I use oracle java stored procedure to read data from MS SQL Server and Advantage Database Server
via JDBC driver.
There are net.sourceforge.jtds.jdbc.Driver for MS SQL and com.extendedsystems.jdbc....
-1
votes
0
answers
11
views
Generate non-id value from sequence
I have an entity with two fields which both use the same sequence, but when debugging I see that only the id field value is being generated:
@Table(name = "MY_TABLE")
public class MyEntity {
...
0
votes
0
answers
38
views
Call PL/SQL from JDBC has different behaviour with OracleConnection and Connection
I need to change package variable using JDBC and get new value back.
Oracle package:
create or replace package test_pkg
as
test_num number := 10;
end;
When I do it via java.sql....
-2
votes
0
answers
62
views
Error Msg = ORA-06550: PLS-00306: wrong number or types of arguments in call to Stored procedure' ORA-06550: line 1, column 7:
I have below java code trying to call stored procedure. which is throwing
Caused by: Error : 6550, Position : 6, Sql = BEGIN JCPRMS.JCP_STORE_LIQUIDATION_PROCESS.JCP_STORE_LIQ_MW_TO_RMS(:1 , :2 ) ; ...
0
votes
1
answer
44
views
Executing an Oracle function which returns Cursor in JDBC
I have here an Oracle DataWarehouse and have to execute the following function:
function getUserSelection(
p_userID in number,
p_userDate in date,
p_userCompany in string,
p_mode in number ...
0
votes
1
answer
32
views
Java using OJDBC8 driver are dropping decimal values when inserting into column defined as NUMBER in Oracle(19c) [closed]
Java8 using OJDBC8 driver are dropping decimal values when inserting into column defined as NUMBER.
This does not occur when using OJDBC7.jar. The client is using Oracle 19c database which requires ...
-1
votes
0
answers
43
views
Quarkus jdbc pooling enabled causing high number of Oracle sessions
we have a Quarkus REST application configured with an Oracle database and pooling enabled and max-size of 10. But when we put the application under load with a lot of GET requests, the number of ...
0
votes
0
answers
53
views
How to use binding variables in an Oracle query? [duplicate]
I have an Oracle query written using binding variables:
SELECT
t.id ID,
t.name NAME,
sum(CASE WHEN t.BE_VALIDTO IS NULL AND t.DATE >= :StartDate AND t.DATE <= :EndDate and t.TYPE in (...
0
votes
1
answer
72
views
ORA-02020: too many database links in use
I have been working on a oracle database query that uses more than 4 database links and I keep getting this error ORA-02020: too many database links in use.
I cannot change the limit and tried using ...
1
vote
1
answer
50
views
Ordinal enum mapping with Hibernate 6.5
I'm upgrading Hibernate from 6.1.7 to 6.5.2, there are many enum columns in my entities marked with
@Enumerated(EnumType.ORDINAL). My codebase has to run against both Oracle and SQL Server.
The ...
0
votes
0
answers
65
views
ORA-29532: Java call terminated by uncaught Java exception: javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure
I am getting ORA-29532: Java call terminated by uncaught Java exception: javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure exception when I try to run java class from PL SQL....
0
votes
2
answers
51
views
Spring Data JDBC @Query method returning null when filtering on varchar2 column in Oracle DB
I am trying to setup connections to query a ready only database using Spring Data JDBC. My interface looks something like the following
@Repository
interface BaseRepository extends CrudRepository<...
0
votes
0
answers
26
views
How to solve Aurora assertion failure Error
I am getting:
ERROR: ORA-29516: Aurora assertion failure: Assertion failure at joez.c:6725
jit-to-interpreter trampoline botch: invoker-index 8634 too large for com/glob/asd/FinalTest
While my code ...
0
votes
0
answers
27
views
How to find out which column is failing if type is number and it exceeds the length in JPA insert operation
I am trying to insert a record in a Oracle 11g table which have around 100 columns.
repository.saveAndFlush(nextObj);
When i am inserting JPA is throwing exception like below, it not telling me ...
0
votes
0
answers
46
views
Loading Java Application into Oracle Database with dependencies
Basic Info: I've created an java application that is an OPC UA client with the help of Eclipse milo packages (org.eclipse.milo.opcua.sdk and org.eclipse.milo.opcua.sdk.stack.core).
The project is a ...