All Questions
10,779
questions
0
votes
0
answers
33
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....
- 363
-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 ) ; ...
- 247
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 ...
- 1
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 (...
- 1
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 ...
- 513
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<...
- 1
0
votes
0
answers
25
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 ...
- 639
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 ...
- 1,750
-2
votes
2
answers
90
views
statement.executeUpdate() can't be used to insert multiple records in Oracle [closed]
With below code I am able to insert multiple Records in H2 Database.
But with Oracle this doesn't work.
Is there any other way to use normal SQL to INSERT multiple statements like that.
//INSERT ...
- 1,019
1
vote
2
answers
61
views
When is the JDBC connection pool created
I am creating a oracle.ucp.jdbc.PoolDataSource datasource bean using jdbc
PoolDataSource pds = PoolDataSourceFactory.getPoolDataSource();
//other pds properties
pds.setSQLForValidateConnection("...
- 9,109