CODEWITHSUNDEEP
sqlhibernatehsqldb
Laurent
Laurent

Reputation: 14401

SQL Warning Code: -1100, SQLState: 02000

I am using HSQLDB (with MVCC support enabled) along with Hibernate. In log files I am getting some warnings:

[WARN i.SqlExceptionHelper] SQL Warning Code: -1100, SQLState: 02000
[WARN i.SqlExceptionHelper] no data

Is there a mean to get a description of the problem based on the Warning code and/or SQLState?

Upvotes: 4

Views: 5029

Answers (1)

Nitin Tripathi
Nitin Tripathi

Reputation: 1254

EDIT1 Please try following link for HSQLDB : the only information available for SQL Warning Code: -1100, SQLState: 02000 is "no data"

# SQL CODE definitions
# no data
1100=02000 no data

ORIGINAL Please following following link and you will be able to look the description against SQLSTATE:

Table 3. Class Code 02: No Data
SQLSTATE Value   
Meaning   SQLCODE Values
02000   One of the following exceptions occurred:
The result of the SELECT INTO statement or the subselect of the INSERT statement was an empty table.
The number of rows identified in the searched UPDATE or DELETE statement was zero.
The position of the cursor referenced in the FETCH statement was after the last row of the result table.
The fetch orientation is invalid.
+100
02001   No additional result sets returned. +387

Upvotes: 4

Related Questions