database views not getting reverse engineered

hari_sujathan · **Joined:** Thu Feb 10, 2005 12:23 pm **Posts:** 21

hi,
I am not seeing database views while reverse engineering from informix database 9.0 .

this is hibernate.reveng.xml

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd" >

<hibernate-reverse-engineering>
   <table-filter match-name=".*"/>  
</hibernate-reverse-engineering>

All table related POJOs, mapping files are getting generated perfectly. Wanted the views also to be reverse engineered.

this is similar issue:
http://opensource.atlassian.com/project ... se/HBX-113 , http://forum.hibernate.org/viewtopic.ph ... 78#2394678

Thanks in Advance,
Hari Sujathan

hari_sujathan · **Joined:** Thu Feb 10, 2005 12:23 pm **Posts:** 21

Version of hibernate tools being used is 3.2.2 beta1.
Here is how I proceeded:
1. created empty project an created a configuration givin the db parameters.
2. Refreshed the configuration in hibernate perspective
3. opened code generation dialog-> refreshed the db objects -> include all.
The tables got picked up but db views did not get picked up.

hibernate.cfg.xml generated was having DB2Dialect instead of InformixDialect . will it make a difference?

Thanks,
Hari

max · **Posted:** Tue Sep 09, 2008 10:48 am

we pick up all tables and views as reported by jdbc metadata.

if the driver reports something different we wont find it.

hari_sujathan · **Joined:** Thu Feb 10, 2005 12:23 pm **Posts:** 21

hi,
used correct informix jar, and it worked.(used a 604 KB- 617,610 bytes jar instead of 590 kb- 604,048 one).

Is informix fast database or MySQL.?

Informix driver seems to throw whole lot of errors. Eg: for boolean - StringIndexOutofBoundsException, Transaction not supportedException etc..

Warm Cegards.
Hari.