Re: using built-in oracle sequences

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

On Fri, 28 May 2004, Erik Wright wrote:

> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/middlegen-user
>
>


-------------------------------------------------------
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