Discussion:
[Middlegen-user] How to specify database.catalog?
Wei Jin
2004-10-04 18:04:13 UTC
Permalink
Hi Everyone,

Could anyone tell me how to specify database.catalog in middlegen ant task?
I only want to generate code for a limited number of table under the schema,
it takes too long to generate all of them.

Thanks,

Wei
Eivind Waaler
2004-10-04 19:28:24 UTC
Permalink
This might be an obvious answer, but there is a catalog attribute:

<middlegen
appname="name"
...
catalog="catalog"
Have you tried this? Or is the problem something else?

There has been some errors reported with catalog on different jdbc
drivers, not sure what they were. Let us know if it's not working.

.eivind
Post by Wei Jin
Hi Everyone,
Could anyone tell me how to specify database.catalog in middlegen ant task?
I only want to generate code for a limited number of table under the schema,
it takes too long to generate all of them.
Thanks,
Wei
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user
Wei Jin
2004-10-05 11:50:31 UTC
Permalink
The problem was I didn't find a way to define a catalog in Oracle9i, it
seems Oracle catalog is used for backup. Now I am specifying table names in
middlegen ant task, this allow me to generate for only those tables needed.

Thanks for your reply,

Wei

-----Original Message-----
From: middlegen-user-***@lists.sourceforge.net
[mailto:middlegen-user-***@lists.sourceforge.net] On Behalf Of Eivind
Waaler
Sent: October 4, 2004 5:23 PM
To: middlegen-***@lists.sourceforge.net
Subject: Re: [Middlegen-user] How to specify database.catalog?

This might be an obvious answer, but there is a catalog attribute:

<middlegen
appname="name"
...
catalog="catalog"
Have you tried this? Or is the problem something else?

There has been some errors reported with catalog on different jdbc drivers,
not sure what they were. Let us know if it's not working.

.eivind
Post by Wei Jin
Hi Everyone,
Could anyone tell me how to specify database.catalog in middlegen ant
task?
Post by Wei Jin
I only want to generate code for a limited number of table under the
schema, it takes too long to generate all of them.
Thanks,
Wei
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on
ITManagersJournal Use IT products in your business? Tell us what you
think of them. Give us Your Opinions, Get Free ThinkGeek Gift
Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use
IT products in your business? Tell us what you think of them. Give us Your
Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
Darren Hartford
2004-10-05 17:02:52 UTC
Permalink
I've also seen scenarios with schema:
<middlegen
schema="dbo"

This has worked with MS SQL boxes. For Oracle, I have working version that is something like the following (8i or 9i box):

databaseurl="jdbc:oracle:thin:@//mydbhost:1526:DBNAME"

DBNAME may also be the Catalog, can't remember I'm not an Oracle guru - get it to work, worry about the terminology later ;-)

p.s. naming the tables was my work around for MS SQL boxes until I learned about 'schema' tag, so something there....

-D
Post by Wei Jin
-----Original Message-----
Sent: Tuesday, October 05, 2004 9:45 AM
Subject: RE: [Middlegen-user] How to specify database.catalog?
The problem was I didn't find a way to define a catalog in
Oracle9i, it
seems Oracle catalog is used for backup. Now I am specifying
table names in
middlegen ant task, this allow me to generate for only those
tables needed.
Thanks for your reply,
Wei
-----Original Message-----
Of Eivind
Waaler
Sent: October 4, 2004 5:23 PM
Subject: Re: [Middlegen-user] How to specify database.catalog?
<middlegen
appname="name"
...
catalog="catalog"
Have you tried this? Or is the problem something else?
There has been some errors reported with catalog on different
jdbc drivers,
not sure what they were. Let us know if it's not working.
.eivind
Post by Wei Jin
Hi Everyone,
Could anyone tell me how to specify database.catalog in
middlegen ant
task?
Post by Wei Jin
I only want to generate code for a limited number of table
under the
Post by Wei Jin
schema, it takes too long to generate all of them.
Thanks,
Wei
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on
ITManagersJournal Use IT products in your business? Tell us
what you
Post by Wei Jin
think of them. Give us Your Opinions, Get Free ThinkGeek Gift
Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on
ITManagersJournal Use
IT products in your business? Tell us what you think of them.
Give us Your
Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on
ITManagersJournal
Use IT products in your business? Tell us what you think of
them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to
find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user
Loading...