java – could not extract ResultSet in hibernate

java – could not extract ResultSet in hibernate

The @JoinColumn annotation specifies the name of the column being used as the foreign key on the targeted entity.

On the Product class above, the name of the join column is set to ID_CATALOG.

@ManyToOne
@JoinColumn(name=ID_CATALOG)
private Catalog catalog;

However, the foreign key on the Product table is called catalog_id

`catalog_id` int(11) DEFAULT NULL,

Youll need to change either the column name on the table or the name youre using in the @JoinColumn so that they match. See http://docs.jboss.org/hibernate/annotations/3.5/reference/en/html/entity.html#entity-mapping-association

Another potential cause, for other people coming across the same error message is that this error will occur if you are accessing a table in a different schema from the one you have authenticated with.

In this case you would need to add the schema name to your entity entry:

@Table(name= catalog, schema = targetSchemaName)

java – could not extract ResultSet in hibernate

I had the same issue, when I tried to update a row:

@Query(value = UPDATE data SET value = asdf, nativeQuery = true)
void setValue();

My Problem was that I forgot to add the @Modifying annotation:

@Modifying    
@Query(value = UPDATE data SET value = asdf, nativeQuery = true)
void setValue();