BTW, ignore the bean suffix settings, those are whatever you want them
to be and the defaults are fine.
-----Original Message-----
From: Rod Macpherson
Sent: Wednesday, May 21, 2003 10:35 AM
To: middlegen-***@lists.sourceforge.net
Subject: RE: [Middlegen-user] Middlegen and JBoss
I think you should start from scratch with a minimalist build.xml that
just has the middlegen and xdoclet stuff for cmp beans. Add a few tables
to your own list and make sure you can build and deploy the beans.
Here is my oracle.xml which is external for convenience. If you want you
can plunk this right in the ANT script.
<property name="database.driver.file"
value="/oracle/jdbc/lib/classes12.jar"/>
<property name="database.driver.classpath"
value="/oracle/jdbc/lib/classes12.jar"/>
<property name="database.driver"
value="oracle.jdbc.driver.OracleDriver"/>
<property name="database.url"
value="jdbc:oracle:thin:@yourhost:1521:myschema"/>
<property name="database.userid" value="myschema"/>
<property name="database.password" value="mypassword"/>
<property name="database.schema" value="myschema"/>
<property name="jboss.datasource.mapping" value="Oracle9i"/>
<property name="database.catalog" value=""/>
The oracle.xml gets included along with the table list as you know.
Everthing in ANT uses network paths (forward slash):
-----------------------------------
<!DOCTYPE project [
<!ENTITY database SYSTEM "file:./config/oracle.xml">
<!ENTITY tables SYSTEM "file:./config/tables.xml">
]>
-----------------------------------
Now you have to generate the beans as follows:
-----------------------------------
<target name="generate-beans">
<taskdef name="middlegen" classname="middlegen.MiddlegenTask"
classpathref="classpath"/>
<middlegen
appname="whadeva" prefsdir="config" gui="false"
databaseurl="${database.url}" datasourceJNDIName="OracleDS"
driver="${database.driver}"
username="${database.userid}" password="${database.password}"
schema="${database.schema}" initialContextFactory="nop"
providerURL="nop"
<!-- Include table list -->
&tables;
<cmp20
destination="${build.source}" package="${package}"
interfacepackage="${package}" localsuffix="LocalBean"
beansuffix="EBBean"
localhomesuffix="EBLHome"
pkclass="false" viewtype="local" mergeDir="./velocity"
readonly="false" fkcmp="false" guid="false"
<jboss/>
</cmp20>
</middlegen>
</target>
-----------------------------------
That is it for middlegen. Now we have to run Xdoclet and we are done
with the excepton of the compile, jar, clean and other run-of-the-mill
tasks:
-----------------------------------
<target name="generate-interface">
<taskdef name="ejbdoclet"
classname="xdoclet.modules.ejb.EjbDocletTask" classpathref="classpath"/>
<ejbdoclet destdir="${build.source}" mergedir="${config}"
excludedtags="@version,@author" ejbspec="2.0">
<fileset dir="${build.source}">
<include name="**/entity/**/*EBBean.java" />
</fileset>
<localinterface pattern="{0}LocalBean"/>
<localhomeinterface pattern="{0}LocalHome"/>
<deploymentdescriptor xmlencoding="ISO-8859-1"
destdir="${build.entity.meta}" validatexml="true"/>
<jboss
version="3.0"
xmlencoding="ISO-8859-1"
destdir="${build.entity.meta}"
validatexml="true"
datasource="java:/OracleDSX"
datasourcemapping="Oracle9i" />
</ejbdoclet>
</target>
-----------------------------------
That's about it. I would create your own ANT script and just take it one
step at a time with a few tables, in particular the tables that are
causing you errors. Then you can trace back the column from the table to
the deployment descriptor and then to the bean itself.
Rod
-----Original Message-----
From: Dos Santos [mailto:***@yahoo.com]
Sent: Wednesday, May 21, 2003 10:03 AM
To: middlegen-***@lists.sourceforge.net
Subject: RE: [Middlegen-user] Middlegen and JBoss
I'm getting it on several tables. What have you done
to resolve this?
Post by D***@nascopgh.comI've had the problem as well w/ Middlegen and MSSQL
Server 2000. I don't
think it's anything in particular to do w/ the
combination of them.
Are you getting this on just one table, or a bunch?
Dave
05/20/2003 08:38 PM
Please respond to middlegen-user
Subject: RE: [Middlegen-user]
Middlegen and JBoss
I'm trying to use the sample and I'm using MSSQL
Server 2000.
I truly appreciate your interest in my problem.
Post by Rod MacphersonI would definitely ditch the M2M stuff in this
case.
Post by Rod MacphersonStart out with a
simple flat list of tables and get that working
first. Did you right
your own ANT script or are you trying to use the
sample? What database
are you using?
-----Original Message-----
Sent: Tuesday, May 20, 2003 2:56 PM
Subject: RE: [Middlegen-user] Middlegen and JBoss
Hi Dave, could you give me an example of this
section
of the build.xml file?
By the way I didn't have a datasource for my
database
but now I do and I still get an error message when
I
Post by Rod Macpherson"CMP field for key not found"
Has anybody encountered this problem before?
I'm getting desperate I've done everything I can
think
of and everything you've suggested and nothing has
worked. :'(
Post by D***@nascopgh.comI think what he's saying is have a separate
middlegen task for each "set"
of tables, and then one middlegen section for
the
Post by Rod MacphersonPost by D***@nascopgh.comjoin tables.
I'm finding myself taking a similar approach
with
Post by Rod MacphersonPost by D***@nascopgh.comtables for which I don't
want the relationships expressed in the EJB's or descriptors
themselves. I have sets of tables w/ one-to-one or one-to-many
relationships defined in
each set, and use CMR to manage those objects.
But
Post by Rod MacphersonPost by D***@nascopgh.comany more complicated
relationships, I deal w/ manually.
You can make the relationship tables CMP beans,
but
Post by D***@nascopgh.comdon't make them part
of any CMR. Then just have a session bean which
gets
Post by D***@nascopgh.comthe join EJBs and
uses them to look up other entities.
Is that what you meant, Rod?
Dave
05/20/2003 05:21 PM
Please respond to middlegen-user
Subject: RE: [Middlegen-user]
Middlegen and JBoss
So, I should generate entity beans for many2many relationship
tables? However not CMP but BMP?
Post by Rod MacphersonI believe you do need the generate flag to be
true.
Post by Rod MacphersonI typically update
left and right tables and then the intersect
table representing the
manage
Post by D***@nascopgh.comPost by Rod Macphersonor even access the
many-to-many relations through CMP and this
makes
Post by D***@nascopgh.comPost by Rod Macphersonthe middlegen process
a lot simpler. As it stands you will have to
establish and maintain such
relationships separately in your ANT script
rather
Post by D***@nascopgh.comPost by Rod Macphersonthan use a flat table
list. I went down the same path long ago and
punted
Post by Rod Macphersonon modeling
many-to-many in CMP and it has not been a
problem.
Post by D***@nascopgh.comPost by Rod Macpherson-----Original Message-----
Sent: Tuesday, May 20, 2003 9:41 AM
Subject: RE: [Middlegen-user] Middlegen and
JBoss
Post by D***@nascopgh.comPost by Rod MacphersonThe answer to your first question is yes.
Do you know if the generate attribute for the
jointable element should be false? My
many2many
Post by Rod Macphersonrelationships are
representing the PKs for the
Post by D***@nascopgh.comPost by Rod Macphersonparticipating
tables.
Thanks so much for your help.
Post by Rod MacphersonWhen you say running JBoss with middlegen
generated
Post by Rod Macphersonjar files you mean
deploying the jarred results of
Middlegen/Xdoclet,
Post by Rod MacphersonPost by Rod Macphersonright? Make sure your
JCA connector is pointing to the same
database
(if
Post by Rod MacphersonPost by D***@nascopgh.comyou
Post by Rod MacphersonPost by Rod Macphersonare using oracle)
should reference the same database as the
included
Post by Rod MacphersonPost by Rod Macphersondatabase properties
used by middlegen.
-----Original Message-----
From: Dos Santos
Sent: Tuesday, May 20, 2003 8:56 AM
Subject: [Middlegen-user] Middlegen and
JBoss
CMP
=== message truncated ===
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com
-------------------------------------------------------
This SF.net email is sponsored by: ObjectStore.
If flattening out C++ or Java code to make your application fit in a
relational database is painful, don't do it! Check out ObjectStore. Now
part of Progress Software. http://www.objectstore.net/sourceforge
_______________________________________________
middlegen-user mailing list middlegen-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/middlegen-user
-------------------------------------------------------
This SF.net email is sponsored by: ObjectStore.
If flattening out C++ or Java code to make your application fit in a
relational database is painful, don't do it! Check out ObjectStore. Now
part of Progress Software. http://www.objectstore.net/sourceforge
_______________________________________________
middlegen-user mailing list middlegen-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/middlegen-user