All Questions
532 questions
0
votes
1
answer
61
views
java.sql.SQLException: while preparing SQL
I have this method in java:
@Retry
@SqlQuery("""
WITH IdsGrouped AS (
SELECT /* comment */
record_key,
max(...
- 61
0
votes
0
answers
12
views
Error Code: 3780. Referencing column '%s' and referenced column '%s' in foreign key constraint 'travela_payment_ibfk_2' are incompatible [duplicate]
I have created database for hotel booking website. I have created travela_payment table to keep track of user's transactions. I have added foreign keys for user_id but unable to add for hotel_name and ...
- 544
0
votes
0
answers
23
views
Dapper Update syntax error not triggering catch block
In the following update function, there is a syntax error in the parameter naming. I know what's wrong, so can correct it, however when the code is run, my application just hangs on the ExecuteAsync ...
- 7
0
votes
1
answer
52
views
How can I handle null value in this kind of situation in PL/SQL?
I wrote code to get a batting average and on-base percentage. Problem is, whenever I skipped to insert a value, since it's a null value I only get an error message and the code returns nothing.
What I ...
- 3
3
votes
2
answers
174
views
Why does my SQL scalar function sometimes throws "Subquery returned more than 1 value. This is not permitted..."
I am directly calling user defined function in my database. Problem is the function seems to randomly return correct value or throw an error Subquery returned more than 1 value. This is not permitted ...
- 43
0
votes
0
answers
28
views
An unhandled exception occurred while processing the request. How to cast object of type system.double to system.single? [duplicate]
I have encountered this error when I try to create new product. When I click the create button, this is what it shows.
This is my table in my database.
Although the data I entered when I was trying ...
- 11
5
votes
1
answer
4k
views
IllegalSelectQueryException and InvalidDataAccessApiUsageException
I use Query annotation for my project. While I call query, I get IllegalSelectQueryException. I want to update status column which is on Reservation table with WHERE the PNR number exists.
@Repository
...
- 97
0
votes
2
answers
38
views
Why is the condition used for the trigger never satisfied on PostgreSQL?
I am trying to create simple trigger to ensure the "from" or "to" (database usernames) is equal to current_user, then can delete the record. But its always raises an exception.
...
- 53
0
votes
1
answer
82
views
Exception when SQL query has multiple word string to W10 desktop search index
I've gobbled together a basic Powershell script to query W10's Windows Desktop Search (WDS) index. Here is the relevant bits,
$query = "
SELECT System.DateModified, System.ItemPathDisplay
...
- 547
0
votes
1
answer
304
views
DB2 FUNCTION EXCEPTION
I'm converting Oracle plsql function into DB2 plsql function.Below I mentioned the structure of Oracle and DB2 query.
CREATE FUNCTION FUNCTION_NAME (IN PARAMETER1 DATATYPE)
Return ...
1
vote
1
answer
34
views
Merge columns of distinct SQL queries
I have three distinct SQL queries which need to be merged.(shown here are just two).
I tried to put one query in the FROM Clause in parenthesis example given.
I am trying to list user with last date ...
1
vote
0
answers
282
views
Exception in component tDBOutput_1 (InsigniaImages) java.sql.SQLException: Invalid column type: sqlType=2003
I have 2 columns in my source Access DB, Column 1 has serial number and column 2 has images attached. I got a java script which works fine when the first row has image attached as part of the second ...
- 11
0
votes
0
answers
80
views
How to create a stored procedure in postgreSQL to insert new rows whilst handling errors and exceptions?
I have a 'PLAYER' table in my database with the following schema:
CREATE TABLE IF NOT EXISTS local."Player"
(
"Player_ID" integer NOT NULL,
"Club_ID" integer NOT ...
- 1
0
votes
1
answer
708
views
Postgres RAISE EXCEPTION does not abort function execution
I wrote the below function:
CREATE OR REPLACE FUNCTION process_init_transfer(
holder_email TEXT,
order_key BIGINT, ticket_key BIGINT,
email_address TEXT,
first_name TEXT, last_name TEXT
) ...
- 2,216
1
vote
1
answer
755
views
Foreign key is null while using Hibernate One to One mapping
I'm trying to work with hibernate and I have a class question and a class answer, and there's One To One relation between them, the code is successfully running but the foreign key is null, I don't ...
