Hi, I am having the following problem with the Hibernate plugin and DB2 when run the wizard "Hibernate Artifact Generation".

Other question I have is where is the "Console Configuration" file located in the workspace?
TIA.

Hibernate version:3.0 alpha 1, 25. January 2005

[Full stack trace of any exception that occurs:
org.hibernate.exception.GenericJDBCException: Reading from database
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:125)
at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:40)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$3.execute(ArtifactGeneratorWizard.java:213)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:76)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.buildConfiguration(ArtifactGeneratorWizard.java:210)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.doFinish(ArtifactGeneratorWizard.java:147)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.access$0(ArtifactGeneratorWizard.java:127)
at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$1.run(ArtifactGeneratorWizard.java:95)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:111)
Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2ResultSet.next(Unknown Source)
at org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:709)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:106)
... 8 more


Name and version of the database you are using:DB2 V8.2

Hi all,

I have figured my problem. The configuration has the following settings:

<property name="hibernate.connection.username">db2admin</property>
<property name="hibernate.connection.password">xxxxx</property>
<property name="hibernate.dialect">org.hibernate.dialect.DB2Dialect</property>
<property name="hibernate.connection.url">jdbc:db2:EMPL</property>
<property name="hibernate.connection.driver_class">com.ibm.db2.jcc.DB2Driver</property>

The following files were imported and added to the build path.
db2java.zip, db2jcc_license_cisuz.jar,db2jcc_license_cu.jar and db2jcc.jar.

When creating the Hibernate Console Configuration the above jars have to be included in the classpath.