-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 10 posts ] 
Author Message
 Post subject: trouble with reverse engineering in PostgreSQL
PostPosted: Mon Feb 19, 2007 12:09 am 
Newbie

Joined: Sat Feb 03, 2007 2:58 pm
Posts: 7
Hi,
I have installed PostgreSQL 8.1, Ant 1.6.5, and HibernateTools-3.2.0.beta9a,
but I cant' filter information_schema from my database.

I want to generate .xml and .java files only from opencharge schema,
which has my application tables, but it also generates files from
information_schema.

This is the <hibernatetool> and task I used:

...
<hibernatetool destdir="${build.dir}">

<!-- Configure jdbcconfiguration for re reverse engineering -->
<jdbcconfiguration
revengfile="hibernate.reveng.xml"
propertyfile="hibernate.properties"
packagename="${name}.model.hibernate"
>

</jdbcconfiguration>

!-- Generate hibernate.cfg.xml file -->
<hbm2cfgxml/>

<!-- Generate mapping files -->
<hbm2hbmxml/>

</hibernatetool>
...

And this is hibernate.reveg.xml file which I use in order to filter
the schema information_schema, but it does not work.

<hibernate-reverse-engineering>
<schema-selection
match-schema="opencharge"
match-table=".*"
/>

</hibernate-reverse-engineering>


I also tried with this, but it did not work either:

<hibernate-reverse-engineering>
<table-filter
match-schema="information_schema"
match-name=".*"
exclude="true"
/>
</hibernate-reverse-engineering>


Thanks in advance for your help
emmie


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 19, 2007 3:11 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
what does "it does not work" mean when you explicitly tell which schema it should read ?

does it read more than you expect or nothing at all ?

if the latter (nothing at all) make sure the casing is correct for your db.

_________________
Max
Don't forget to rate


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 19, 2007 10:59 pm 
Newbie

Joined: Sat Feb 03, 2007 2:58 pm
Posts: 7
Thanks max,
"it does not work" means that it reads more than I expect.
In fact, I test it in MySQL and it workS fine, e. i., it does not read
the tables specified in that filter.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Feb 20, 2007 3:51 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
hmm...i think you might bumped into our schema-selection bug (http://opensource.atlassian.com/project ... se/HBX-866)

if you can't get to the cvs version then try and set hibernate.default_schema

_________________
Max
Don't forget to rate


Top
 Profile  
 
 Post subject:
PostPosted: Tue Feb 20, 2007 8:41 am 
Newbie

Joined: Sat Feb 03, 2007 2:58 pm
Posts: 7
Thanks max, will try this.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Feb 27, 2007 7:58 am 
Beginner
Beginner

Joined: Thu Aug 03, 2006 3:43 am
Posts: 45
the jira site doesn't work ...

neither dose this link: http://opensource.atlassian.com/project ... se/HBX-866


Top
 Profile  
 
 Post subject:
PostPosted: Tue Feb 27, 2007 8:14 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
works fine for me

_________________
Max
Don't forget to rate


Top
 Profile  
 
 Post subject:
PostPosted: Wed Feb 28, 2007 6:45 am 
Beginner
Beginner

Joined: Thu Aug 03, 2006 3:43 am
Posts: 45
yeah... my ISP seems to be the problem... I am using a anonymous proxy for now to make it work...


Top
 Profile  
 
 Post subject:
PostPosted: Sat Mar 03, 2007 1:09 am 
Newbie

Joined: Sat Feb 03, 2007 2:58 pm
Posts: 7
Hi max,
I got the revision 11228 from
http://anonsvn.jboss.org/repos/hibernat ... bernateExt,
I compiled the sources, but I still have the same problem. Even more, I
tried all this with oracle and the <schema-selection> tag does not filter
the schema that I want, but it reads all catalog information.

I read in http://opensource.atlassian.com/project ... ge=history
that this problems were fixed in the revision 10640 (Am I right?)

Evidently, there is something that I don't do right, but I can't see what it
is.

Best regards,
emmie.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 19, 2007 11:05 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
look in our unittests for schemafilter and see if you can figure out why that passes for me but apparently doesn't work for you.

_________________
Max
Don't forget to rate


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 10 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.