All Questions
3,721
questions
0
votes
0
answers
36
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....
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
0
answers
35
views
oracle throws exception with message "Caused by: oracle.jdbc.OracleDatabaseException: ORA-06503: PL/SQL: Function returned without value"
I have code that call Oracle funqtion:
public Map<String, Object> canRefuse(int val) {
SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(jdbcTemplate)
.withSchemaName("...
0
votes
0
answers
39
views
How to execute SQL statements against on premise Oracle DB in AWS Glue
I am trying to update a table in my Oracle DB using AWS Glue. I know that PySpark is not really meant for updating tables or inserting. More for reading. Though, I am trying to update all rows for a ...
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("...
0
votes
1
answer
63
views
org.hibernate.exception.JDBCConnectionException: Unable to open JDBC Connection
I have a java application that accesses several services. They've always worked correctly, and then all of a sudden I get the following error when trying to run one of them:
org.hibernate.exception....
-1
votes
1
answer
62
views
Spring Boot JDBCCALL for a query with a function
I'd like to call this function using Spring boot and be able to display the data that is stored in an object. I've tried several times but without any progress or results.
The function returns an ...
0
votes
1
answer
46
views
DatabaseChangeListener not showing event changes
I am implementing DCN to get notifications for records being inserted into a table. When I try inserting records, either within the application or with external scripts, it does not show the events in ...
0
votes
1
answer
46
views
Oracle SQL Query to role up to the reporting manager id based on the role level and update in the column
I am trying to create a query to get the reporting manager of each employee. but we should only consider the reporting manager for that employee if the manager role level is 13.
If the employee is ...
0
votes
0
answers
24
views
How can I create table on remote database along with constraints(not null, default and primary key) using jdbc in pyspark?
I was able to create table by using the below code but unable to find the solution with constraints.
df.write \
.option("createTableColumnTypes", "id INT, name VARCHAR(29)") \
...
0
votes
2
answers
57
views
Why would a Tomcat 8.5 Connection Pool with Oracle have unused open (Dead?) connections?
I have a Grails 2.5 application that is deployed to Tomcat 8.5 application server where one customer is reporting that they are running out of connections in the connection pool. As part of the ...
1
vote
1
answer
59
views
Java application RAC- aware
Is it necessary from a developer POV to know that application is hosted on RAC oracle database? Do we need to add any additional mechanism for making Java application RAC-aware? Can application ...
0
votes
0
answers
19
views
Read data from Oracle with pySpark. Error: exit code 143
I have a table in Oracle, it contains 1000 colums. I try to copy this table to HDFS with pySpark. But it faild with error: **Container marked as failed. Exit code is 143**. Then i limit columns to ...
0
votes
1
answer
30
views
Is there a way to use UPDATEXML inside a query using jdbc connected to a Oracle DB?
I have a SQL query, like so:
UPDATE warehouses SET warehouse_spec =
UPDATEXML(warehouse_spec,
'/Warehouse/Docks/text()',4)
WHERE warehouse_name = 'San Francisco';
(Taken directly from ...
0
votes
1
answer
39
views
Reliable way to detect an INTEGER column using JDBC (Oracle 19c)
In my Oracle 19c environment, the JDBC driver returns java.sql.Types.NUMERIC as the column type for a column which was created as INTEGER. The JDBC metadata indicates a precision of 38 and scale 0.
Is ...