[Middlegen-user] using built-in oracle sequences

Discussion:

Erik Wright

2004-05-28 17:09:09 UTC

Hello,

We're new to middlegen, but pretty happy with it.

We're using the head of the sourceforge tree ("2.1") on Windows and
Linux, and we're a bit confused about how the oracle sequence stuff is
supposed to work.

There are two options, as I see it: using the 'oracleSequence' subtask
and using the 'weblogic' subtask with pkgen="VENDOR_SEQ" (we're
deploying to Weblogic).

I've seen in this list that the second choice is preferred, as that
makes better use of the builtin WL CMP stuff. But I'm not quite sure how
it should work, since it only allows you to specify one sequence name
for all of your tables, and (naturally, I think) we want to use a
separate sequence for each table.

The oracleSequence subtask seems a bit smarter - it uses
<TABLE_NAME>_SEQ as the sequence name. But we had other troubles with
that. The OracleSequenceSessionBean generated is abstract(?!) and can't
be deployed. Is there a reason for that? Is there something big missing
that we need to fill in afterwards? Or is this just a bug. If it's a
bug, I'm happy to fix the template and submit a patch on Jira (we
already submitted another small patch yesterday for another bug).

For now I guess we'll patch Middlegen and use the oracleSequence task -
but if anyone has insight on how to make the weblogic VENDOR_SEQ stuff
work we'd appreciate it.

Thanks,

Erik

Eivind Waaler

2004-05-29 12:48:04 UTC

Permalink

Hi Erik,

There might well be some bugs with the Oracle sequence generation. It
hasn't been changed for a long time. I just did some fixes and patches to
this, so there might be some problems.

If you submit patches that would be very appreciated :) Not using Oracle
myself, so if you come up with something that works I'll add it in..

Cheers
.eivind

Post by Erik Wright
Hello,
We're new to middlegen, but pretty happy with it.
We're using the head of the sourceforge tree ("2.1") on Windows and
Linux, and we're a bit confused about how the oracle sequence stuff is
supposed to work.
There are two options, as I see it: using the 'oracleSequence' subtask
and using the 'weblogic' subtask with pkgen="VENDOR_SEQ" (we're
deploying to Weblogic).
I've seen in this list that the second choice is preferred, as that
makes better use of the builtin WL CMP stuff. But I'm not quite sure how
it should work, since it only allows you to specify one sequence name
for all of your tables, and (naturally, I think) we want to use a
separate sequence for each table.
The oracleSequence subtask seems a bit smarter - it uses
<TABLE_NAME>_SEQ as the sequence name. But we had other troubles with
that. The OracleSequenceSessionBean generated is abstract(?!) and can't
be deployed. Is there a reason for that? Is there something big missing
that we need to fill in afterwards? Or is this just a bug. If it's a
bug, I'm happy to fix the template and submit a patch on Jira (we
already submitted another small patch yesterday for another bug).
For now I guess we'll patch Middlegen and use the oracleSequence task -
but if anyone has insight on how to make the weblogic VENDOR_SEQ stuff
work we'd appreciate it.
Thanks,
Erik
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user

Erik Wright

2004-05-31 12:47:01 UTC

Permalink

Great Eivind,

I just wanted to be sure we weren't missing something.

Thanks for this great tool :)

-Erik

Post by Eivind Waaler
Hi Erik,
There might well be some bugs with the Oracle sequence generation. It
hasn't been changed for a long time. I just did some fixes and patches to
this, so there might be some problems.
If you submit patches that would be very appreciated :) Not using Oracle
myself, so if you come up with something that works I'll add it in..
Cheers
.eivind

-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user