Hi.
I have a (probably stupid) mistake with the forge 2 create entities from tables utility.
First, i run this command:
{code:modifiedtitle=true|jivemacro_uid=_14038174907093710|class=jive_text_macro
jive_macro_code _jivemacro_uid_14038174907093710}
[myProject]$ jpa-generate-entities-from-tables --jdbcUrl
jdbc:oracle:thin:myhost:1521:myDataBase
--userName myUsername --userPassword ***** --driverLocation
C:\the\path\of\lib\ojdbc6-11.2.0.3.jar
{code}
So, after that, in the console appears the options of what dialect i want to use (i prefer
this way, because a NEVER remember the correct name) something like this:
{code:modifiedtitle=true|jivemacro_uid=_14038177804365613|class=jive_text_macro
jive_macro_code _jivemacro_uid_14038177804365613}
[0] - MySQL5 : org.hibernate.dialect.MySQL5Dialect
[1] - MySQL5 with InnoDB : org.hibernate.dialect.MySQL5InnoDBDialect
[2] - MySQL with MyISAM : org.hibernate.dialect.MySQLMyISAMDialect
[3] - Oracle (any version) : org.hibernate.dialect.OracleDialect
[4] - Oracle 9i : org.hibernate.dialect.Oracle9iDialect
[5] - Oracle 10g : org.hibernate.dialect.Oracle10gDialect
[6] - Oracle 11g : org.hibernate.dialect.Oracle10gDialect
[7] - DB2 : org.hibernate.dialect.DB2Dialect
[8] - DB2 AS/400 : org.hibernate.dialect.DB2400Dialect
[9] - DB2 OS390 : org.hibernate.dialect.DB2390Dialect
[10] - PostgreSQL : org.hibernate.dialect.PostgreSQLDialect
[11] - Microsoft SQL Server 2000 : org.hibernate.dialect.SQLServerDialect
[12] - Microsoft SQL Server 2005 : org.hibernate.dialect.SQLServer2005Dialect
[13] - Microsoft SQL Server 2008 : org.hibernate.dialect.SQLServer2008Dialect
[14] - SAP DB : org.hibernate.dialect.SAPDBDialect
[15] - Informix : org.hibernate.dialect.InformixDialect
[16] - HypersonicSQL : org.hibernate.dialect.HSQLDialect
[17] - H2 Database : org.hibernate.dialect.H2Dialect
[18] - Ingres : org.hibernate.dialect.IngresDialect
[19] - Progress : org.hibernate.dialect.ProgressDialect
[20] - Mckoi SQL : org.hibernate.dialect.MckoiDialect
[21] - Interbase : org.hibernate.dialect.InterbaseDialect
[22] - Pointbase : org.hibernate.dialect.PointbaseDialect
[23] - FrontBase : org.hibernate.dialect.FrontbaseDialect
[24] - Firebird : org.hibernate.dialect.FirebirdDialect
[25] - Sybase : org.hibernate.dialect.SybaseASE15Dialect
[26] - Sybase Anywhere : org.hibernate.dialect.SybaseAnywhereDialect
Hibernate Dialect (The Hibernate dialect to use): [0-26] 6
Hibernate Dialect (The Hibernate dialect to use): [0-26] 6
{code}
Ok, everything seems correct; BUT when i proceed to exec the command, forge begins to make
the files that represents the classes, suddenly, the next error appears:
{quote:modifiedtitle=true|class=jive_text_macro jive_macro_quote}
org.hibernate.cfg.JDBCBinderException: Duplicate class name
'org.hibernateTesting.model.NrcAdopcion' generated for
'org.hibernate.mapping.Table(PREFIX.TABLE)'. Same name where generated for
'org.hibernate.mapping.Table(PREFIX.TABLE)'
{quote}
For some reasons that aren't important here i have duplicate table names in different
schemas and the data base user can see all schemas, so i read about that error, and it
suppose
that the hibernate.revenge.xml file can handle that situations. So i wrote the file, and
is very small:
{code:modifiedtitle=true|jivemacro_uid=_14038183131019382|class=jive_text_macro
jive_macro_code _jivemacro_uid_14038183131019382}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering
SYSTEM "http://hibernate.sourceforge.net/hibernate-reverse-engineering.dtd"
>
<hibernate-reverse-engineering>
<table-filter match-name="PREFIX.*" exclude="true" />
</hibernate-reverse-engineering>
{code}
I put the file here:
myProject
|
src
|_main
| |_java
| |_resources
| | |_hibernate.revenge.xml <---HERE!
| |_webapp
|
|_test
And well, my question is .... if i have to put the file in other place. I know it looks
like the question is for hibernate forum, but i don't know if forge is using hibernate
utilities in some way.
Thanks in advance.
Posted by forums
Original post:
https://community.jboss.org/message/879552#879552