You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by "Pugh, Eric" <EP...@MuseumCompany.com> on 2001/10/23 23:23:08 UTC
Question on setting Nulls for Torque OM objects
Hi,
I have a torque generated OM object called Category. It has the method
setCategoryID(int v). What if I want to put a null value into the database?
I don't want to do weird stuff like make 0 mean null.
Is the solution to not use basic datatypes like int? If so, then how can I
make Torque not use basic data types like int, and instead use Integer?
I am writing to MS SQL Server.
Thanks!
Eric
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Question on setting Nulls for Torque OM objects
Posted by Geoff Fortytwo <g4...@snowball.com>.
Could you specify which java files in the tdk which would need to be modified?
At 03:56 PM 10/24/2001 -0700, you wrote:
>you can rewrite the templates to use Integer instead of int. We welcome
>your patches.
>
>john mcnally
>
>"Pugh, Eric" wrote:
> >
> > Hi,
> >
> > I have a torque generated OM object called Category. It has the method
> > setCategoryID(int v). What if I want to put a null value into the
> database?
> > I don't want to do weird stuff like make 0 mean null.
> > Is the solution to not use basic datatypes like int? If so, then how can I
> > make Torque not use basic data types like int, and instead use Integer?
> >
> > I am writing to MS SQL Server.
> >
> > Thanks!
> >
> > Eric
> >
> > ---------------------------------------------------------------------
> > 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
RE: Question on setting Nulls for Torque OM objects
Posted by Ilia Iourovitski <ii...@ydyn.com>.
Hi,
Are there any plans to add javaType attribute to the column attribute of the
database schema xml? It will let user
to specify explicitly the java type of field in the class.
Oracle has NUMBER database type for everything, and in different situations
user would like to bind it to Integer, Double, Float, and primitive types.
Thanks,
Ilia
-----Original Message-----
From: jmcnally [mailto:jmcnally]On Behalf Of John McNally
Sent: Wednesday, October 24, 2001 3:56 PM
To: turbine-user@jakarta.apache.org
Subject: Re: Question on setting Nulls for Torque OM objects
you can rewrite the templates to use Integer instead of int. We welcome
your patches.
john mcnally
"Pugh, Eric" wrote:
>
> Hi,
>
> I have a torque generated OM object called Category. It has the method
> setCategoryID(int v). What if I want to put a null value into the
database?
> I don't want to do weird stuff like make 0 mean null.
> Is the solution to not use basic datatypes like int? If so, then how can
I
> make Torque not use basic data types like int, and instead use Integer?
>
> I am writing to MS SQL Server.
>
> Thanks!
>
> Eric
>
> ---------------------------------------------------------------------
> 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
Re: Question on setting Nulls for Torque OM objects
Posted by John McNally <jm...@collab.net>.
you can rewrite the templates to use Integer instead of int. We welcome
your patches.
john mcnally
"Pugh, Eric" wrote:
>
> Hi,
>
> I have a torque generated OM object called Category. It has the method
> setCategoryID(int v). What if I want to put a null value into the database?
> I don't want to do weird stuff like make 0 mean null.
> Is the solution to not use basic datatypes like int? If so, then how can I
> make Torque not use basic data types like int, and instead use Integer?
>
> I am writing to MS SQL Server.
>
> Thanks!
>
> Eric
>
> ---------------------------------------------------------------------
> 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: Question on setting Nulls for Torque OM objects
Posted by Geoff Fortytwo <g4...@snowball.com>.
I had the same problem. The only solution that currently exists in Torque
is to change the type from "INTEGER" to "NUMERIC" in the torque schema
file. You'll have to use the java type BigDecimal instead of int. It's not
convenient or efficient, but it's the only option currently available if
you want to set the column to null.
At 05:23 PM 10/23/2001 -0400, you wrote:
>Hi,
>
>I have a torque generated OM object called Category. It has the method
>setCategoryID(int v). What if I want to put a null value into the database?
>I don't want to do weird stuff like make 0 mean null.
>Is the solution to not use basic datatypes like int? If so, then how can I
>make Torque not use basic data types like int, and instead use Integer?
>
>I am writing to MS SQL Server.
>
>Thanks!
>
>Eric
>
>---------------------------------------------------------------------
>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
Re: Torque 1.0 sequence problem
Posted by John McNally <jm...@collab.net>.
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
Torque 1.0 sequence problem
Posted by Ilia Iourovitski <ii...@ydyn.com>.
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