Can't Generate hibernate files from as/400

Joris · **Joined:** Tue Mar 01, 2005 9:42 am **Posts:** 2

Hi,
I am trying to generate hibernate files from an as400 library with middlegenIDE (eclipse plugin), but when i want to generate these files i get the next error message:

BUILD FAILED: D:\testApps\middlegenAs400Test\src\java\middlegen-build.xml:91: middlegen.MiddlegenException: The database doesn't have any table named ORDER. Please make sure the table exists. Also note that some databases are case sensitive.
Found the following tables:

----

ORDER is a SQL-file:table.

Subset of my middlegen-build.xml:

Code:

<project name="Middlegen Hibernate" default="compile" basedir=".">
   <property file="./build.properties"/>
   <property name="hibernate.cascade"    value="all" />
   <property name="package"              value="nl.kvk.commons.data" />
   <property name="gen.xdoclet-tag"      value="false" />
   <property name="gui"                  value="true" />
   <property name="jdbc.jar"             value="D:\VVK\myProjects\VVKCoaching\Coaching JTOpen\lib\jtopen\jt400.jar" />
   <property name="database.driver"      value="com.ibm.as400.access.AS400JDBCDriver" />
   <property name="lib.dir"              value="/c:/java/eclipse301/plugins/net.sf.middlegen_2.1.0/lib/" />
   <property name="database.url"         value="jdbc:as400://10.0.2.12" />
   <property name="database.userid"      value="username" />
   <property name="database.password"    value="password" />
   <property name="database.schema"      value="DBKJHALIB" />
   <property name="database.catalog"     value="" />
   <property name="dest.dir"             value="src/java" />
|
|
 <table name="ORDER" />
|
</project>

is this the right way to access a table on the as/400?
Can somebody help me?

Best regards

ravalox · **Joined:** Thu Jan 22, 2004 2:42 pm **Posts:** 24

I have done this before, I'll have to wait until I get home and look at my home computer's filesystem to be sure what library I used, in the meantime a lesson I learned doing this is that in dealing with an AS400 and hibernate you must set your isolation level to 0. It slows performance but it was the only thing we could do.

Joris · **Joined:** Tue Mar 01, 2005 9:42 am **Posts:** 2

ok,
good luck and I hope that you have the solution.
best regards
Joris

berentzen · **Posted:** Tue Mar 08, 2005 10:46 am

I've done this as an ant task. There the problem was the "catalog" property of the middlegen task. Don't use this property. Even if U use it the way U did with value blank, the middlegen will exit with the known error. Just omit the property.

C U
berentzen

ratnesh_22 · **Joined:** Fri May 02, 2008 4:11 am **Posts:** 3

I have scribled my experience here.

http://rmwebcafe.blogspot.com/

Cheers!
Ratnesh

ratnesh_22 · **Joined:** Fri May 02, 2008 4:11 am **Posts:** 3

I have scribled my experience here.

http://rmwebcafe.blogspot.com/

Cheers!
Ratnesh