8 Replies Latest reply on Oct 1, 2016 2:59 PM by ymazar

TableGenerator is not backward compatible when upgrading from JBoss 4.2.3 to Wildfly 9.0.1

ymazar Sep 21, 2016 6:02 PM

I am trying to upgrade an EJB project that we have from JBoss 4.2.3 to Wildfly 9.0.1

All our entities are inheriting from a supper class named RootEntity which has the Id property as you can see below:

@Id

@Column(name = COLUMN_ID)

@GeneratedValue(strategy = GenerationType.TABLE, generator = GENERATOR)

@TableGenerator(name = GENERATOR, table = GENERATED_IDS_TABLE_NAME, schema = "Common")

protected long id;

This setting works fine on 4.2.3 (Hibernate creates a row for each entity type in the Id generation table), but when I upgraded to 9.0.1 I got "cannot read or init hi value".

I have spent few days trying to work around this issue - I tried to create a persistence.xml file with the following property

as mentioned in this thread, but this didn't help - I got an "unknown error" and I wasn't able to get this working. I even tried to specify the names of the key and value columns in the @TableGenerator attribute but It still didn't solve the issue

I am trying to come up with an elegant solution that will allow me to do the migration without significant code/db schema changes (While maintaining backward compatibility) and I would appreciate any advice you can give me on this.

Thanks,

Yoni

1. Re: TableGenerator is not backward compatible when upgrading from JBoss 4.2.3 to Wildfly 9.0.1

smarlow Sep 22, 2016 12:29 PM (in response to ymazar)

Perhaps you could try again with the latest WildFly release (10.1.0). I'm more interested in problems with the latest Hibernate (5.0.x) version, so it would help me to help you, if your using the latest WildFly as well. You don't have to migrate your entire application, just enough to verify if the same problem occurs or not with WildFly 10.1.0.

Scott
Actions
2. Re: TableGenerator is not backward compatible when upgrading from JBoss 4.2.3 to Wildfly 9.0.1

ymazar Sep 22, 2016 4:54 PM (in response to smarlow)

Hi Scott,

I really appreciate your help with this!

As you suggested, I upgraded to Wildfly 10.1.
Initially (No persistence.xml), as with 9.0.1 I got an error "[TableGenerator] (EJB default - 2) HHH000351: Could not read or init a hi value"
I added a persistence.xml file with hibernate.id.new_generator_mappings=false and when I tried to save an entity I got many warnings "HHH90000015: Found use of deprecated [org.hibernate.id.MultipleHiLoPerTableGenerator] table-based id generator; use org.hibernate.id.enhanced.TableGenerator instead. See Hibernate Domain Model Mapping Guide for details." followed by a failure
22 23:44:48,527 ERROR [invocation] (EJB default - 1) WFLYEJB0034: EJB Invocation failed on component KMModifierBean...
22 23:44:48,628 ERROR [RuntimeExceptionInterceptor] (EJB default - 1) javax.ejb.EJBTransactionRolledbackException: WFLYEJB0457: Unexpected Error

Any idea on how I can tackle this?

Thanks a lot

Yoni
Actions
3. Re: TableGenerator is not backward compatible when upgrading from JBoss 4.2.3 to Wildfly 9.0.1

smarlow Sep 23, 2016 10:00 AM (in response to ymazar)

I wonder if its a problem with the table name case. What is the SQL Exception that is shown with the "Could not read or init a hi value" error?
Actions
4. Re: TableGenerator is not backward compatible when upgrading from JBoss 4.2.3 to Wildfly 9.0.1

ymazar Sep 23, 2016 5:46 PM (in response to smarlow)

Hi Scott,

I will check this first thing tomorrow morning. One question though - if I understand correctly, using the new generator system is not backward compatible, in my I need to assume that there are existing data in the database and in the Ids table - so it seems that I have to switch back to legacy generator right?

In that case the 'hi value' error is not relevant and I'm getting the 'Unexpected error'

Yoni
Actions
5. Re: TableGenerator is not backward compatible when upgrading from JBoss 4.2.3 to Wildfly 9.0.1

smarlow Sep 27, 2016 3:20 PM (in response to ymazar)

Hi Yoni,

I think that the exception that your getting is in response to a JDBC exception being thrown and caught by Hibernate. When you look into the cause of a problem, you typically want to look at the first exception that is thrown, closest to the code that is handling the exception that your trying to understand.

Scott
Actions
6. Re: TableGenerator is not backward compatible when upgrading from JBoss 4.2.3 to Wildfly 9.0.1

ymazar Sep 28, 2016 1:22 AM (in response to smarlow)

Thanks Scott.

I assume that this is the case, but I wasn't able to lay the finger on the root cause (Or what have changed to cause it)

Thanks for your help

Yoni
Actions
7. Re: TableGenerator is not backward compatible when upgrading from JBoss 4.2.3 to Wildfly 9.0.1

smarlow Sep 28, 2016 4:56 PM (in response to ymazar)

Could you post the entire exception call stack here, including the exceptions that are below the "WFLYEJB0457: Unexpected Error".
Actions
8. Re: TableGenerator is not backward compatible when upgrading from JBoss 4.2.3 to Wildfly 9.0.1

ymazar Oct 1, 2016 2:59 PM (in response to smarlow)

Hi Scott,

Unfortunately, the stack trace wasn't specified on that error, but I could indeed see the warnings telling me that the deprecated generator was in fact used. In the end we decided to postpone this task so I believe that the root cause of this issue will remain unknown. Thanks for your help!

Yoni
Actions

Go to original post