Hi again, > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Ravi > Deshmukh > Sent: 31. august 2002 17:11 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Fwd: Re: [Middlegen-user] Can't get it working. > > > Aslak, I got your email, but before that I had sent the one below > - I got past the metadata > problem. > > I tried to use the pkgen feature with the vendorseq option, but > it gave errors stating the pktable > had to be specified. I thought this would not be required if > using the database's automatic > sequence generation (SQL Server IDENTITY). Also it did not > generate the create methods in which > the primary key column is absent. I noticed it is putting in a > "todo" comment that this needs to > be done. Am I too early, is it not implemented yet ? >
As Eivind said, not implemented yet. Just pass null if you use pkgen. > I'm also getting an error on weblogic ejbc - something about > Local and LocalHome interfaces being > exposed in remote interface methods (as arguments to create it > looks like). But I'll work on that That's actually related to this bug: http://sourceforge.net/tracker/index.php?func=detail&aid=596249&group_id=360 44&atid=415990 Until it's fixed, you should always specify viewtype="local" > a bit more - it may be because I've specified view="both" and > also checked the local/remote > checkboxes in the gui. > > One question - I haven't understood why we need the xxCMP objects > - why not just use the Entity > Bean ? > It's XDoclet that generates the xxCMP Bean subclasses. IIRC it is because XDoclet also supports BMP and EJB 1.1. This subclass implements the required abstract methods if they aren't implemented in the Bean class. You can consider it an implementation detail and ignore it completely. Don't forget to tell us when you get the struts sample up and running on JBoss! :-) Cheers, Aslak > Ravi > > > --- Ravi Deshmukh <[EMAIL PROTECTED]> wrote: > > Date: Sat, 31 Aug 2002 04:20:15 -0700 (PDT) > > From: Ravi Deshmukh <[EMAIL PROTECTED]> > > Subject: Re: [Middlegen-user] Can't get it working. > > To: Eivind Waaler <[EMAIL PROTECTED]> > > CC: [EMAIL PROTECTED] > > > > It's working !! Eivind, thanks to your pointer to > MiddlegenPopulator. It is calling: > > getMetaData().getTables(_catalog, _schema, null, _types); > > > > The javadoc for getTables method in the DatabaseMetaData interface says: > > Parameters: > > catalog - a catalog name; "" retrieves those without a catalog; > null means drop catalog name > > from > > the selection criteria > > schemaPattern - a schema name pattern; "" retrieves those > without a schema > > tableNamePattern - a table name pattern > > types - a list of table types to include; null returns all types > > > > Sybase's jConnect implementation needed null for catalog and > schemaPattern. I couldn't figure > > out > > how to pass a null value in the database config file elements: > > > > <property name="database.schema" value=""/> > > <property name="database.catalog" value=""/> > > > > However, after reading how Ant processes Tasks, I realized that > if I removed the "schema" > > element > > from the middlegen task parameters in build.xml, Ant would not > call setSchema. Looking at the > > MiddlegenTask class, this would leave the String _schema as > null. The "catalog" element was > > already not being used in build.xml, so I didn't have to do > anything there. > > > > Perhaps it would be appropriate to have a note somewhere about > excluding elements for which you > > want null values, unless there's a way to specify null as the > value in the config file ? > > > > Anyway, I was delighted to see it running! I got a nice ER > diagram and was able to set options > > in > > the GUI, generate the bean classes, and then off it went > generating everything else! Wonderful! > > > > I'm now playing around with specifying local/remote/both, and > the Weblogic pkgen features, and > > will also try out the HTML pages for bean testing! > > > > Thanks again guys, > > Ravi > > > > --- Eivind Waaler <[EMAIL PROTECTED]> wrote: > > > Hi Ravi, > > > > > > From the errors you get it sounds like the JDBC driver is not working > > > properly. But if you've been using the exact same driver and > settings with > > > Middlegen 1.0.. Are you using the same driver/connection settings with > > > your appserver? Is it working there? If so make sure you db > url etc. are > > > the same as in the working one. > > > > > > I don't have any sybase db/driver to test out myself. Maybe > someone else > > > here has Sybase working with Middlegen? > > > > > > If the driver/connection is verified to be working, I guess there is a > > > problem with MiddlegenPopulator. > > > > > > Aslak might have some more ideas about this? > > > > > > .eivind > > > > > > On Fri, 30 Aug 2002, Ravi Deshmukh wrote: > > > > > > > Hi Eivind, > > > > > > > > OK, I tried it out, but it looks like it can't correctly > find the database on the server. > > I'm > > > > working with Sybase 11 on Linux. The older Middlegen 1.0 > was able to connect, extract > > > metadata, > > > > and build the beans. With the new version, if I specify a > table name, I get the following > > > error: > > > > > > > > middlegen: > > > > [middlegen] Database URL:jdbc:sybase:Tds:linux:7100/court > > > > > > > > BUILD FAILED > > > > file:C:/middlegen/samples/build.xml:134: > middlegen.MiddlegenException: The datab > > > > ase doesn't have any table named pbcattbl. Please make > sure the table exists. A > > > > lso note that some databases are case sensitive. > > > > > > > > If I don't specify any table names, I get this error: > > > > > > > > middlegen: > > > > [middlegen] Database URL:jdbc:sybase:Tds:linux:7100/court > > > > [middlegen] No <table> elements specified. Reading all > tables. This might take a > > > > while... > > > > > > > > BUILD FAILED > > > > file:C:/middlegen/samples/build.xml:135: > middlegen.MiddlegenException: Middlegen > > > > successfully connected to the database, but couldn't find > any tables. Perhaps t > > > > he specified schema or catalog is wrong? -Or maybe there > aren't any tables in th > > > > e database at all? > > > > > > > > > > > > I also tried it with the JDBC/ODBC bridge driver against an > MS SQL Server database on my > > local > > > > machine, but got the same errors. > > > > > > > > For Sybase I'm using the jConnect driver. I created a > sybase.xml file in \config\database > > > with > > > > the following entries: > > > > > > > > <property name="database.driver.file" > value="${lib.dir}/jconn2.jar"/> > > > > <property name="database.driver.classpath" > value="${database.driver.file}"/> > > > > <property name="database.driver" > value="com.sybase.jdbc2.jdbc.SybDriver"/> > > > > <property name="database.url" > > value="jdbc:sybase:Tds:linux:7100/court"/> > > > > <property name="database.userid" value="sa"/> > > > > <property name="database.password" value=""/> > > > > <property name="database.schema" value=""/> > > > > <property name="database.catalog" value=""/> > > > > > > > > For jConnect the database url syntax is: > > > > jdbc:sybase:Tds:<server>:<port>/<database> > > > > > > > > My server is named linux, and my database is named court, so: > > > > jdbc:sybase:Tds:linux:7100/court > > > > > > > > I used the exact same syntax with Middlegen 1.0 (where it worked). > > > > > > > > In the middlegen section of build.xml, jndi properties are > also passed - I thought these > > might > > > > override the jdbc url so I took them out, but no change. > > > > > > > > Is there a problem using the "/" in the database url? Is > there any other section in > > build.xml > > > or > > > > somewhere else that I need to change ? > > > > > > > > Thanks for your help, > > > > Ravi > > > > > > > > --- Eivind Waaler <[EMAIL PROTECTED]> wrote: > > > > > Hi Ravi, I'll try to answer your questions below. > > > > > > > > > > .eivind > > > > > > > > > > On Thu, 29 Aug 2002, Ravi Deshmukh wrote: > > > > > > > > > > > Hi Aslak, > > > > > > > > > > > > With middlegen I'm a user, not a developer. > Nonetheless, based on your reply I did the > > > > > following: > > > > > > > > > > > > - Installed WinCVS > > > > > > - Downloaded the middlegen CVS - note: middlegen CVS > page says specify the "modulename" > > > but I > > > > > > couldn't find the value anywhere. I guessed and used > "middlegen" > > > > > > - Installed Ant 1.5 > > > > > > - Ran Ant against build.xml, got a docs, lib, and samples dir > > > > > > - Unlike v1.0 there is no build.bat file. There is one > set of jars in \lib, and a > > > different > > > > > set > > > > > > in \samples\lib. Which jars are required in the cp to > run middlegen ? Or let's just > > say, > > > how > > > > > do I > > > > > > run middlegen ? > > > > > > > > > > No jars are required in the CP to run middlegen. The > build.xml script > > > > > starts by setting up classpath. In fact try to make sure > your CP is empty > > > > > before running it. > > > > > > > > > > To build middlegen, make sure you have ant in your path. > Simply type 'ant' > > > > > in the middlegen basedir. > > > > > > > > > > To build the samples, use 'ant' in the samples dir. > > > > > > > > > > > - Installed maven to generate docs. Maven version is > maven-1.0-beta-6. On executing > > > "maven > > > > > xdoc" > > > > > > it generates a bunch of errors looking for jar files in > MAVEN_HOME\repository\XXX\jars > > > where > > > > > XXX > > > > > > is ant, velocity, log4j, junit, and > commons-collections. I found the jar files in > > > > > MAVEN_HOME\lib > > > > > > and copied them. I found velocity in > middlegen\samples\lib and copied it. Running it > > > again > > > > > > produced NoClassDefFoundError on: > org/apache/tools/dvsl/DVSL. This class is not in any > > of > > > the > > > > > > Maven jars - where do I get it ? > > > > > > > > > > Maven is supposed to download all the files it need from a central > > > > > repository. Please refer to the maven docs to read about > this. Of course > > > > > this requires you to be online the first time you run maven. > > > > > > > > > > I would recommend building maven from cvs, as you will > see quite clear how > > > > > maven works (maven is build using maven). > > > > > > > > > > > > > > > > > I also saw your posting on the users mailing list > saying that a new release should be > > out > > > soon > > > > > - > > > > > > any idea on the date ? Also from the mails it appears > some people have got it working - > > > what > > > > > am I > > > > > > doing wrong ? > > > > > > > > > > Hope you get a bit further. Let us know.. :) > > > > > > > > > > > > > > > > > I don't want to be a pest, but I really like this stuff > and would love to get it > > working. > > > > > > > > > > > > Thanks, > > > > > > Ravi > > > > > > > > > > > > > > > > > > __________________________________________________ > > > > > > Do You Yahoo!? > > > > > > Yahoo! Finance - Get real-time stock quotes > > > > > > http://finance.yahoo.com > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > > This sf.net email is sponsored by: OSDN - Tired of that same old > > > > > > cell phone? Get a new here for FREE! > > > > > > https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 > > > > > > _______________________________________________ > > > > > > middlegen-user mailing list > > > > > > [EMAIL PROTECTED] > > > > > > https://lists.sourceforge.net/lists/listinfo/middlegen-user > > > > > > > > > > > > > > > > > > > > > > > __________________________________________________ > > > > Do You Yahoo!? > > > > Yahoo! Finance - Get real-time stock quotes > > > > http://finance.yahoo.com > > > > > > > > > > > > ------------------------------------------------------- > > > > This sf.net email is sponsored by: OSDN - Tired of that same old > > > > cell phone? Get a new here for FREE! > > > > https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 > > > > _______________________________________________ > > > > middlegen-user mailing list > > > > [EMAIL PROTECTED] > > > > https://lists.sourceforge.net/lists/listinfo/middlegen-user > > > > > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Finance - Get real-time stock quotes > > http://finance.yahoo.com > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > > > ------------------------------------------------------- > This sf.net email is sponsored by: OSDN - Tired of that same old > cell phone? Get a new here for FREE! > https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 > _______________________________________________ > middlegen-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/middlegen-user ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
