Hibernate Tools Ant error- Could not instantiate dialect

bruce2 · **Joined:** Tue Aug 16, 2005 1:27 pm **Posts:** 7

Trying to migrate from hibernate2 / middlegen to hibernate3.0.5 and hibernate tools (3.0.0.alpha4)

Build.xml contains:

Code:

   <target name="compile-hibernate" 
         description="generate .hbm, hibernate.cfg.xml, and POJOs for hibernate">
      <taskdef 
         name="hibernatetool"
           classname="org.hibernate.tool.ant.HibernateToolTask"
            classpathref="myclasspath" />
        <hibernatetool destdir="${src}">
            <classpath refid="myclasspath"/>
            <jdbcconfiguration 
               propertyFile="j2ee/hibernate.properties"
               />
            <cfg2hbm/>
            <hbm2java/>
        </hibernatetool> 
   </target>

j2ee/hibernate.properties contains:

Code:

hibernate.dialect org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class org.postgresql.Driver
hibernate.connection.url jdbc:postgresql:dbname
hibernate.connection.username user
hibernate.connection.password password
hibernate.query.substitutions yes 'Y', no 'N'

ant -verbose produces the following error:

If I remove the <classpath> line from build.xml, then I get this error instead:

I'm pretty sure the <classpath> tag is right; how do I solve teh "could not instantiate Dialect" error?

bruce2 · **Joined:** Tue Aug 16, 2005 1:27 pm **Posts:** 7

More information: When I build hibernate-tools from CVS, and use the classpath, I get the following error:

bruce2 · **Joined:** Tue Aug 16, 2005 1:27 pm **Posts:** 7

more info still: Changing JDBCReader.java around line 100 to read:

Code:

            String fkCatalog = exportedKeyRs.getString("FK_TABLE_CAT");
            String fkSchema = exportedKeyRs.getString("FKTABLE_SCHEMA");
            String fkTableName = exportedKeyRs.getString("FKTABLE_NAME");
            String fkColumnName = exportedKeyRs.getString("FKCOLUMN_NAME");
            String pkColumnName = exportedKeyRs.getString("PKCOLUMN_NAME");
            String fkName = exportedKeyRs.getString("FK_NAME");
            short keySeq = exportedKeyRs.getShort("KEY_SEQ");
            

Seems to partly fix the problem (note the column names are slightly different). I'm using postgresql 8.0.3.

Now I get this error:

bruce2 · **Joined:** Tue Aug 16, 2005 1:27 pm **Posts:** 7

Upgrading to hibernate-3.1 (from CVS) fixed the problem; now I have the org.apache.velocity.tools.generic.log.CommonsLogLogSystem problem (which I suppose there's an answer for somewhere else in teh forum).

bruce2 · **Joined:** Tue Aug 16, 2005 1:27 pm **Posts:** 7

Adding velocity-tools-generic-1.1.jar and jtidy-r8-21122004.jar to the classpath makes it work (or at least, it now runs without throwing exceptions; I haven't inspected the output).
.

I had to change JDBCReader.java as described above; how do I report this as a bug?

max · **Posted:** Tue Aug 16, 2005 3:13 pm

seems like postgressql is not jdbc compliant.

From jdbc doc:

* <LI><B>FKTABLE_CAT</B> String => foreign key table catalog (may be <code>null</code>)
* being exported (may be <code>null</code>)

So, FK_TABLE_CAT is wrong and should probably be reported to postgres...

but searching for this I found: http://gborg.postgresql.org/pipermail/p ... 00061.html

which seem to indicate it is fixed in latest version.