You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by John McNally <jm...@collab.net> on 2001/10/24 18:06:04 UTC
Re: Torque 1.0 sequence problem
Is torque1.0 the standalone version or the version bundled with
turbine2.x? You may have some problems with "native" in the 2.x tree.
It should be working in standalone version.
john mcnally
Ilia Iourovitski wrote:
>
> Hi,
>
> I'm trying to force Torque to use sequence with Oracle.
> If I set idMethod="native" for table, Torque is trying to get new id
> executing
> select null.next from dual?
> I set
> <database defaultIdMethod="native">.
> Any suggestion?
>
> Thanks,
>
> Ilia
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: Torque 1.0 sequence problem
Posted by David Sean Taylor <da...@bluesunrise.com>.
> -----Original Message-----
> From: jmcnally [mailto:jmcnally]On Behalf Of John McNally
> Sent: Sunday, October 28, 2001 10:37 PM
> To: turbine-user@jakarta.apache.org
> Subject: Re: Torque 1.0 sequence problem
>
>
> what db is this? Which adapter takes a fully qualified column name as
> the information required to get a value for an
> autoincremented column?
Cloudscape - http://www.cloudscape.com/
Yes, it uses the schema, table and column name to call an SQL-J method in a
select statement.
Im not quite sure how to specify 'schemas' in Torque XML - could use some
help there....
If the schema isn't specified (which is always the case now), I use the
default Cloudscape schema, which is usually 'APP'
> Also why do this at line 118 instead of in the block of code just
> previous where the other setSequenceInfo/setPrimaryKeyInfo methods are
> being generated?
>
I think its necessary at line 118 since we need to know the fully qualified
identifier (schema, table, column) of the autoincrement column.
Here's the basic 'SQL':
select distinct ConnectionInfo.lastAutoincrementValue('SchemaName',
'TableName', 'ColumnName') From TableName
I don't really like the select distinct statement, wish I could get it to
work with Torque and a call if possible
> john mcnally
>
> David Sean Taylor wrote:
> >
> > > I'm using torque-1.0.jar from jakarta-turbine-torque cvs.
> > > The problem is that idMethod sequence is depreciated. In case of
> > > idMethod=native, nobody set pkInfo field in TableMap class.
> > > In case of Oracle it should be set with table name.
> >
> > Im having this same problem with a database that works with
> auto-increment
> > fields: the 'pkInfo' is null when passed to the adapter's
> getIDMethodSQL()
> > method.
> >
> > In my test schema, dbMethod='native' and my template's
> db.props setting has
> > AUTOINCREMENT = IDENTITY
> >
> > The problem can be hacked by adding the line below to the
> doBuild() method
> > of the generated *MapBuilder.java files:
> >
> > public void doBuild() ...
> >
> > tMap.setSequenceInfo( insert HARD-CODED key
> information here ); // added
> > this line
> >
> > or better yet a patch to MapBuilder.vm in order to set the
> 'pkInfo' inserted
> > above line 118:
> >
> > tMap.setSequenceInfo( get$(tfc)_$(cfc)() );
> >
> > Ive written an adapter for Cloudscape. Its not tested
> thoroughly, tested
> > with a few projects: jetspeed, jetspeed-db-psml and a
> 'torque-unplugged'
> > (torque without turbine) project. Is there some kind of cts or
> > junit-test-suite for new adapters that i don't know about?
> >
> > thanks,
> >
> > david
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> turbine-user-help@jakarta.apache.org
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Torque 1.0 sequence problem
Posted by John McNally <jm...@collab.net>.
what db is this? Which adapter takes a fully qualified column name as
the information required to get a value for an autoincremented column?
Also why do this at line 118 instead of in the block of code just
previous where the other setSequenceInfo/setPrimaryKeyInfo methods are
being generated?
john mcnally
David Sean Taylor wrote:
>
> > I'm using torque-1.0.jar from jakarta-turbine-torque cvs.
> > The problem is that idMethod sequence is depreciated. In case of
> > idMethod=native, nobody set pkInfo field in TableMap class.
> > In case of Oracle it should be set with table name.
>
> Im having this same problem with a database that works with auto-increment
> fields: the 'pkInfo' is null when passed to the adapter's getIDMethodSQL()
> method.
>
> In my test schema, dbMethod='native' and my template's db.props setting has
> AUTOINCREMENT = IDENTITY
>
> The problem can be hacked by adding the line below to the doBuild() method
> of the generated *MapBuilder.java files:
>
> public void doBuild() ...
>
> tMap.setSequenceInfo( insert HARD-CODED key information here ); // added
> this line
>
> or better yet a patch to MapBuilder.vm in order to set the 'pkInfo' inserted
> above line 118:
>
> tMap.setSequenceInfo( get$(tfc)_$(cfc)() );
>
> Ive written an adapter for Cloudscape. Its not tested thoroughly, tested
> with a few projects: jetspeed, jetspeed-db-psml and a 'torque-unplugged'
> (torque without turbine) project. Is there some kind of cts or
> junit-test-suite for new adapters that i don't know about?
>
> thanks,
>
> david
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Torque 1.0 sequence problem
Posted by Jason van Zyl <jv...@zenplex.com>.
On 10/28/01 10:48 PM, "David Sean Taylor" <da...@bluesunrise.com> wrote:
>> I made some additions today that will allow torque to run by
>> itself and I
>> will continue to work on the test bed because I don't want to release
>> another TDK or Turbine until torque is in a better, well tested state.
>
> Hi Jason,
>
> Glad to hear you have a test bed in the works, test-first!
> Do you have any use for Cloudscape support? - I'll send you the source,
> there isn't much too it really.
That would be great, the more adapters the better.
> I already have Torque working without Turbine no problem, you just need:
> velocity, commons-collections, commons-utils, village.
You can do it through TurbineConfig, or with a little wrapper class but I'm
adding proper support so it can be embedded a lot easier. Proper logging
configuration, being able to specify an applicationRoot. I'm hoping the
examples as part of the test bed will show people how to fully use Torque.
As I just mentioned in IRC I'm hoping that by next Monday the test bed will
be nearly complete and the following Monday release a beta.
> David
>
>> -----Original Message-----
>> From: Jason van Zyl [mailto:jvanzyl@zenplex.com]
>> Sent: Sunday, October 28, 2001 7:26 PM
>> To: turbine-user@jakarta.apache.org
>> Subject: Re: Torque 1.0 sequence problem
>>
>>
>> On 10/28/01 9:09 PM, "David Sean Taylor"
>> <da...@bluesunrise.com> wrote:
>>
>>>> I'm using torque-1.0.jar from jakarta-turbine-torque cvs.
>>>> The problem is that idMethod sequence is depreciated. In case of
>>>> idMethod=native, nobody set pkInfo field in TableMap class.
>>>> In case of Oracle it should be set with table name.
>>>
>>> Im having this same problem with a database that works with
>> auto-increment
>>> fields: the 'pkInfo' is null when passed to the adapter's
>> getIDMethodSQL()
>>> method.
>>>
>>> In my test schema, dbMethod='native' and my template's
>> db.props setting has
>>> AUTOINCREMENT = IDENTITY
>>>
>>> The problem can be hacked by adding the line below to the
>> doBuild() method
>>> of the generated *MapBuilder.java files:
>>>
>>> public void doBuild() ...
>>>
>>> tMap.setSequenceInfo( insert HARD-CODED key information
>> here ); // added
>>> this line
>>>
>>>
>>> or better yet a patch to MapBuilder.vm in order to set the
>> 'pkInfo' inserted
>>> above line 118:
>>>
>>> tMap.setSequenceInfo( get$(tfc)_$(cfc)() );
>>>
>>>
>>> Ive written an adapter for Cloudscape. Its not tested
>> thoroughly, tested
>>> with a few projects: jetspeed, jetspeed-db-psml and a
>> 'torque-unplugged'
>>> (torque without turbine) project. Is there some kind of cts or
>>> junit-test-suite for new adapters that i don't know about?
>>
>> I just started a real testbed for torque and it can include
>> tests for the
>> adapters though there's nothing there yet. Right now it
>> simply generates SQL
>> from a datamodel descriptor, generates the OM and compiles
>> the generated
>> classes.
>>
>> I have a task in the TDK that I'm going to move into torque
>> that will insert
>> SQL files taking multiple databases into consideration. So
>> tomorrow night
>> I'll add that task in there so I'll be able to generate the
>> SQL and OM from
>> the datamodel descriptor, insert the SQL and run torque in
>> stand-alone mode.
>>
>> I made some additions today that will allow torque to run by
>> itself and I
>> will continue to work on the test bed because I don't want to release
>> another TDK or Turbine until torque is in a better, well tested state.
>>
>>> thanks,
>>>
>>> david
>>>
>>>
>>>
>>>
>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail:
>> turbine-user-help@jakarta.apache.org
>>
>> --
>>
>> jvz.
>>
>> Jason van Zyl
>>
>> http://tambora.zenplex.org
>> http://jakarta.apache.org/turbine
>> http://jakarta.apache.org/velocity
>> http://jakarta.apache.org/alexandria
>> http://jakarta.apache.org/commons
>>
>>
>>
>> --
>> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
--
jvz.
Jason van Zyl
http://tambora.zenplex.org
http://jakarta.apache.org/turbine
http://jakarta.apache.org/velocity
http://jakarta.apache.org/alexandria
http://jakarta.apache.org/commons
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Torque 1.0 sequence problem
Posted by David Sean Taylor <da...@bluesunrise.com>.
> I made some additions today that will allow torque to run by
> itself and I
> will continue to work on the test bed because I don't want to release
> another TDK or Turbine until torque is in a better, well tested state.
Hi Jason,
Glad to hear you have a test bed in the works, test-first!
Do you have any use for Cloudscape support? - I'll send you the source,
there isn't much too it really.
I already have Torque working without Turbine no problem, you just need:
velocity, commons-collections, commons-utils, village.
David
> -----Original Message-----
> From: Jason van Zyl [mailto:jvanzyl@zenplex.com]
> Sent: Sunday, October 28, 2001 7:26 PM
> To: turbine-user@jakarta.apache.org
> Subject: Re: Torque 1.0 sequence problem
>
>
> On 10/28/01 9:09 PM, "David Sean Taylor"
> <da...@bluesunrise.com> wrote:
>
> >> I'm using torque-1.0.jar from jakarta-turbine-torque cvs.
> >> The problem is that idMethod sequence is depreciated. In case of
> >> idMethod=native, nobody set pkInfo field in TableMap class.
> >> In case of Oracle it should be set with table name.
> >
> > Im having this same problem with a database that works with
> auto-increment
> > fields: the 'pkInfo' is null when passed to the adapter's
> getIDMethodSQL()
> > method.
> >
> > In my test schema, dbMethod='native' and my template's
> db.props setting has
> > AUTOINCREMENT = IDENTITY
> >
> > The problem can be hacked by adding the line below to the
> doBuild() method
> > of the generated *MapBuilder.java files:
> >
> > public void doBuild() ...
> >
> > tMap.setSequenceInfo( insert HARD-CODED key information
> here ); // added
> > this line
> >
> >
> > or better yet a patch to MapBuilder.vm in order to set the
> 'pkInfo' inserted
> > above line 118:
> >
> > tMap.setSequenceInfo( get$(tfc)_$(cfc)() );
> >
> >
> > Ive written an adapter for Cloudscape. Its not tested
> thoroughly, tested
> > with a few projects: jetspeed, jetspeed-db-psml and a
> 'torque-unplugged'
> > (torque without turbine) project. Is there some kind of cts or
> > junit-test-suite for new adapters that i don't know about?
>
> I just started a real testbed for torque and it can include
> tests for the
> adapters though there's nothing there yet. Right now it
> simply generates SQL
> from a datamodel descriptor, generates the OM and compiles
> the generated
> classes.
>
> I have a task in the TDK that I'm going to move into torque
> that will insert
> SQL files taking multiple databases into consideration. So
> tomorrow night
> I'll add that task in there so I'll be able to generate the
> SQL and OM from
> the datamodel descriptor, insert the SQL and run torque in
> stand-alone mode.
>
> I made some additions today that will allow torque to run by
> itself and I
> will continue to work on the test bed because I don't want to release
> another TDK or Turbine until torque is in a better, well tested state.
>
> > thanks,
> >
> > david
> >
> >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> turbine-user-help@jakarta.apache.org
>
> --
>
> jvz.
>
> Jason van Zyl
>
> http://tambora.zenplex.org
> http://jakarta.apache.org/turbine
> http://jakarta.apache.org/velocity
> http://jakarta.apache.org/alexandria
> http://jakarta.apache.org/commons
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Torque 1.0 sequence problem
Posted by Jason van Zyl <jv...@zenplex.com>.
On 10/28/01 9:09 PM, "David Sean Taylor" <da...@bluesunrise.com> wrote:
>> I'm using torque-1.0.jar from jakarta-turbine-torque cvs.
>> The problem is that idMethod sequence is depreciated. In case of
>> idMethod=native, nobody set pkInfo field in TableMap class.
>> In case of Oracle it should be set with table name.
>
> Im having this same problem with a database that works with auto-increment
> fields: the 'pkInfo' is null when passed to the adapter's getIDMethodSQL()
> method.
>
> In my test schema, dbMethod='native' and my template's db.props setting has
> AUTOINCREMENT = IDENTITY
>
> The problem can be hacked by adding the line below to the doBuild() method
> of the generated *MapBuilder.java files:
>
> public void doBuild() ...
>
> tMap.setSequenceInfo( insert HARD-CODED key information here ); // added
> this line
>
>
> or better yet a patch to MapBuilder.vm in order to set the 'pkInfo' inserted
> above line 118:
>
> tMap.setSequenceInfo( get$(tfc)_$(cfc)() );
>
>
> Ive written an adapter for Cloudscape. Its not tested thoroughly, tested
> with a few projects: jetspeed, jetspeed-db-psml and a 'torque-unplugged'
> (torque without turbine) project. Is there some kind of cts or
> junit-test-suite for new adapters that i don't know about?
I just started a real testbed for torque and it can include tests for the
adapters though there's nothing there yet. Right now it simply generates SQL
from a datamodel descriptor, generates the OM and compiles the generated
classes.
I have a task in the TDK that I'm going to move into torque that will insert
SQL files taking multiple databases into consideration. So tomorrow night
I'll add that task in there so I'll be able to generate the SQL and OM from
the datamodel descriptor, insert the SQL and run torque in stand-alone mode.
I made some additions today that will allow torque to run by itself and I
will continue to work on the test bed because I don't want to release
another TDK or Turbine until torque is in a better, well tested state.
> thanks,
>
> david
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
--
jvz.
Jason van Zyl
http://tambora.zenplex.org
http://jakarta.apache.org/turbine
http://jakarta.apache.org/velocity
http://jakarta.apache.org/alexandria
http://jakarta.apache.org/commons
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Torque 1.0 sequence problem
Posted by David Sean Taylor <da...@bluesunrise.com>.
> I'm using torque-1.0.jar from jakarta-turbine-torque cvs.
> The problem is that idMethod sequence is depreciated. In case of
> idMethod=native, nobody set pkInfo field in TableMap class.
> In case of Oracle it should be set with table name.
Im having this same problem with a database that works with auto-increment
fields: the 'pkInfo' is null when passed to the adapter's getIDMethodSQL()
method.
In my test schema, dbMethod='native' and my template's db.props setting has
AUTOINCREMENT = IDENTITY
The problem can be hacked by adding the line below to the doBuild() method
of the generated *MapBuilder.java files:
public void doBuild() ...
tMap.setSequenceInfo( insert HARD-CODED key information here ); // added
this line
or better yet a patch to MapBuilder.vm in order to set the 'pkInfo' inserted
above line 118:
tMap.setSequenceInfo( get$(tfc)_$(cfc)() );
Ive written an adapter for Cloudscape. Its not tested thoroughly, tested
with a few projects: jetspeed, jetspeed-db-psml and a 'torque-unplugged'
(torque without turbine) project. Is there some kind of cts or
junit-test-suite for new adapters that i don't know about?
thanks,
david
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: Torque 1.0 sequence problem
Posted by Ilia Iourovitski <ii...@ydyn.com>.
I'm using torque-1.0.jar from jakarta-turbine-torque cvs.
The problem is that idMethod sequence is depreciated. In case of
idMethod=native, nobody set pkInfo field in TableMap class.
In case of Oracle it should be set with table name.
Thanks,
Ilia
-----Original Message-----
From: jmcnally [mailto:jmcnally]On Behalf Of John McNally
Sent: Wednesday, October 24, 2001 9:06 AM
To: turbine-user@jakarta.apache.org
Subject: Re: Torque 1.0 sequence problem
Is torque1.0 the standalone version or the version bundled with
turbine2.x? You may have some problems with "native" in the 2.x tree.
It should be working in standalone version.
john mcnally
Ilia Iourovitski wrote:
>
> Hi,
>
> I'm trying to force Torque to use sequence with Oracle.
> If I set idMethod="native" for table, Torque is trying to get new id
> executing
> select null.next from dual?
> I set
> <database defaultIdMethod="native">.
> Any suggestion?
>
> Thanks,
>
> Ilia
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org