[Hibernate-JIRA] Created: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
10:03 a.m.
org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not
found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:42 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
TJ Moretto commented on HHH-3231:
---------------------------------
For whatever reason I only experience this issue when using an hbm file to map an entity
class. Using the javax.persistence annotations works fine:
@GeneratedValue(strategy=GenerationType.TABLE)
@TableGenerator(name="mytable")
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
Steve Ebersole updated HHH-3231:
--------------------------------
Assignee: Steve Ebersole
Fix Version/s: 3.3.x
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Assignee: Steve Ebersole
Fix For: 3.3.x
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:02 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
Steve Ebersole commented on HHH-3231:
-------------------------------------
This is actually an issue when using any Dialect which reports that it supports "for
update of columns", the Oracle dialects being examples of this.
Emmanuel could say more definitively, but I believe that @TableGenerator does not map to
the enhanced table generator.
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Assignee: Steve Ebersole
Fix For: 3.3.x
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:15 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
Steve Ebersole updated HHH-3231:
--------------------------------
Fix Version/s: 3.4
3.2.x
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Assignee: Steve Ebersole
Fix For: 3.2.x, 3.3.x, 3.4
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:23 a.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
Steve Ebersole resolved HHH-3231.
---------------------------------
Resolution: Fixed
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Assignee: Steve Ebersole
Fix For: 3.2.x, 3.3.x, 3.4
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:50 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
Prakash commented on HHH-3231:
------------------------------
I am still having the same problem with latest build 3.3.1. We are trying to implement
TableGenerator for SQL Server and Oracle both. The configuration works well for SQL
Server, but not for Oracle. Is this issue really fixed?
Exception in thread "main" org.hibernate.MappingException: could not instantiate
id generator
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:98)
at
org.hibernate.mapping.SimpleValue.createIdentifierGenerator(SimpleValue.java:152)
at
org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:192)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
at managers.HibernateManager.createSessionFactory(HibernateManager.java:42)
at hibernate.checkHibernate.<init>(checkHibernate.java:35)
at hibernate.Main.startHibernate(Main.java:80)
at hibernate.Main.main(Main.java:61)
Caused by: java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:94)
... 7 more
Java Result: 1
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Assignee: Steve Ebersole
Fix For: 3.2.x, 3.3.1, 3.4
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:57 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
Király Attila commented on HHH-3231:
------------------------------------
@Prakash
Are you sure that you are using the 3.3.1 version of hibernate core?
Your exception is the same as my was with 3.2.6 (before the fix). The exception says
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
Checking the sourcecode of o.h.id.enhanced.TableGenerator this function name and row
number is correct in 3.2.6 but it has changed in 3.3.1 (configure is between rows 279 -
299 now).
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Assignee: Steve Ebersole
Fix For: 3.2.x, 3.3.1, 3.4
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:04 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
Prakash commented on HHH-3231:
------------------------------
Yes, I downloaded the distribution from
http://sourceforge.net/project/showfiles.php?group_id=40712&package_i...
and change log does mention 3.3.1.GA (2008.09.10)
May be the changes are not available in build available to download?
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Assignee: Steve Ebersole
Fix For: 3.2.x, 3.3.1, 3.4
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:01 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
Prakash commented on HHH-3231:
------------------------------
It was my bad. The project was using wrong library. Sorry about that and thank you for
responding.
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Assignee: Steve Ebersole
Fix For: 3.2.x, 3.3.1, 3.4
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:06 a.m.
New subject: [Hibernate-JIRA] Closed: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
Király Attila closed HHH-3231.
------------------------------
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Assignee: Steve Ebersole
Fix For: 3.2.x, 3.3.1, 3.4
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:03 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3231) org.hibernate.id.enhanced.TableGenerator throws "IllegalArgumentException: alias not found: tbl" under Oracle
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231?page=c...
]
Strong Liu commented on HHH-3231:
---------------------------------
https://jira.jboss.org/browse/JBPAPP-4599
org.hibernate.id.enhanced.TableGenerator throws
"IllegalArgumentException: alias not found: tbl" under Oracle
-------------------------------------------------------------------------------------------------------------
Key: HHH-3231
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3231
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Hibernate 3.2.6GA, Oracle 10g
Reporter: Király Attila
Assignee: Steve Ebersole
Fix For: 3.2.7, 3.3.1, 3.5.0.Beta-1
Attachments: hibernate_etg_ora.zip
org.hibernate.id.enhanced.TableGenerator always throws the following exception if I want
to save a new object to Oracle:
java.lang.IllegalArgumentException: alias not found: tbl
at org.hibernate.sql.ForUpdateFragment.<init>(ForUpdateFragment.java:36)
at org.hibernate.dialect.Dialect.applyLocksToSql(Dialect.java:970)
at org.hibernate.id.enhanced.TableGenerator.configure(TableGenerator.java:194)
at
org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:104)
I attach an example to this case. The example is loosely based on the tutorial example,
that comes with Hibernate. It contains a Person object that is saved to db using the
enhanced.TableGenerator as id generator. To keep the zip small only the jars of jdbc
driver are included, the jars needed from hibernate distribution are listed in
lib/readme.txt.
The zip also contains a modified TableGenerator that works with Oracle. This version was
made by forum user stomp and more information about it can be read here:
http://forum.hibernate.org/viewtopic.php?t=980933
It changes the 194th row of TableGenerator from
this.query = dialect.applyLocksToSql( query, lockMap, CollectionHelper.EMPTY_MAP );
to
this.query = dialect.applyLocksToSql( query, lockMap,
Collections.singletonMap("tbl", new String[] {valueColumnName}) );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5186
days inactive
6021
days old
hibernate-issues@lists.jboss.org
11 comments
5 participants
participants (5)
-
Király Attila (JIRA) -
Prakash (JIRA)
-
Steve Ebersole (JIRA)
-
Strong Liu (JIRA)
-
TJ Moretto (JIRA)