You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by BEN BOOKEY <br...@hotmail.com> on 2003/08/04 19:40:30 UTC
Toruqe supports BLOB ????
Dear List and Torque Developers,
Not much activity on this list is there?? :)
The http://db.apache.org/torque/dtd/database_3_1.dtd indicates that BLOB
are a valid torque data type.
It possible to save an image to a blob with the current version ? Could
someone give a small example. We have done this using BC4J and with JDBC on
its own, does the current version of torque help me?
Kind regards,
Ben bookey.
----- Original Message -----
From: "Michel Beijlevelt / Lucka" <mb...@lucka.nl>
To: "Apache Torque Users List" <to...@db.apache.org>
Sent: Monday, August 04, 2003 2:42 PM
Subject: Re: different internal variable names
> Howdy,
>
> the opinion about tight or loose coupling is also influenced by the
> frequency of changes in the RDBMS schema.
>
> If my application is - through Torque - tightly coupled with the RDBMS,
> it will almost certainly fail with an exception upon a moderately
> significant change in the RDBMS. Which is good, because it will
> precisely pinpoint the change, and makes 'sure' (well, fairly sure that
> is :-) that my appliction only runs against the RDBMS that is was
> designed for and none other.
>
> But I agree, having the possibility of making Torque more loosely
> coupled from the RDBMS would be a nice feature. It could be implemented
> by allowing specifying aliases for db objects in the XML schema
> definition which does seem to be fairly simple to implement, but maybe a
> more sophisticated abstraction layer isn't that hard to make either.
>
> gr. Michel
>
>
> Manske, Michael wrote:
>
> >hi,
> >
> >i knew that such a discussion would come up and it depends on the point
of
> >view of each indivual user. :)
> >
> >
> >
> >>I don't know, I think I would Torque rather see more tightly coupled
> >>with the RDBMS and dump the XML schema entirely.
> >>
> >>
> >if you have control over database structure and changes of the database
> >structure, then you will
> >perhaps prefer a strict coupling. But if not (like me), you will always
> >prefer loose coupling to be more independent of changes made by another
dev
> >team.
> >
> >
> >
> >>My RDBMS already has a schema, which would be the metadatabase in the
> >>systems tables. So why create another definition in XML of the same
> >>database and tables?
> >>
> >>
> >If you have to support different RDBMS the metadescription in some
"system
> >tables" will get useless.
> >
> >
> >
> >>Torque's capability of abstraction of the RDBMS-specific
> >>isssues comes
> >>in quite handy here. The process could be automated by having Torque
> >>generate the XML definition from a JDBC conncection, and then
> >>generate
> >>the om from that XML, but I haven't tried that yet.
> >>
> >>
> >Thats what i'm talking about, we are working with torque this way because
we
> >have to deal
> >with a couple of already existing databases.
> >And yes, torques abstraction is somewhat of handy - thats why we use it.
:-)
> >
> >Loose coupling means among other things to hide the physical database
> >structure completely from the objects, which have to access the database.
A
> >layer (like torque) will then act as mediator between objects and
database.
> >So if you would have problematic identifiers like "short", you would be
> >easily able to map them to another name, which could then be used in java
> >objects, e.g. map "short" to "short_descr".
> >There is already some kind of support for this but at the moment it isn't
> >suitable at all.
> >
> >I guess torque is so popular because of his abilities to generate more or
> >less useable code and the usage of a xml schema at runtime (respectively
at
> >application startup) would possibly be contradictory to the generator BUT
it
> >would also provide more independency from used database structure.
> >
> >I'm not sure wheter this is a mainly intention of torque but i would be
glad
> >if the devs would expand
> >support for loose coupling (at least for mapping of table/column names to
> >java names) in future versions...
> >
> >regards,
> >Michael
> >
> >PS: pros and cons of loose coupling will always be a matter of opinion
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
AW: Toruqe supports BLOB ????
Posted by Joachim Müller <jo...@wemove.com>.
Hi Ben.
I am a newbie just like you ;-) and went through similar
questions.
when I did my research there was no patched village
available so I did patch it myself. (with help from
he mailing list though ;-)) The patches regarded CLOB handling
and the Date field handling that did not store the
time of a date. As far as I know, both patches are
now in the latest village jar.
I do not need BLOB support with my app, so I did not
look into it. But I guess, if you want to get it fixed
you need to have a look at the source and maybe write
your own BLOB handling. :-(
http://www.mail-archive.com/turbine-torque-user@jakarta.apache.org/msg00545.html
Joachim
> -----Ursprüngliche Nachricht-----
> Von: BEN BOOKEY [mailto:brgbookey@hotmail.com]
> Gesendet: Mittwoch, 6. August 2003 20:16
> An: Apache Torque Users List; joachim@wemove.com
> Betreff: Re: Toruqe supports BLOB ????
>
>
> Hi joachim
>
> Hope you are well, greetings from Darmstadt ! Here are some more newbie
> questions for you !!
>
> I would prefer to have a torque working binary for our web-entry tool that
> supports BLOB. I dont really want to get involved in lots of patches and
> recompilations of source code!! We already have the latest village jar file
> downloaded inside torque lib directory. is this enough or have you editted
> the village source?
>
> regards
>
> Ben
>
> ----- Original Message -----
> From: "Joachim Müller" <jo...@wemove.com>
> To: "Apache Torque Users List" <to...@db.apache.org>
> Sent: Monday, August 04, 2003 7:55 PM
> Subject: AW: Toruqe supports BLOB ????
>
>
> >
> > Hi Ben.
> >
> > I do use CLOBs with oracle but had to apply a patch to
> > do so. I think I read in the mailing list that the current
> > CVS version has this fix already.
> >
> > actually it's in village, not in torque.
> >
> > If you do not have an solution yet, contact me.
> >
> >
> > regards from frankfurt.
> >
> > joachim/wemove
> >
> >
> > > -----Ursprüngliche Nachricht-----
> > > Von: BEN BOOKEY [mailto:brgbookey@hotmail.com]
> > > Gesendet: Montag, 4. August 2003 19:41
> > > An: Apache Torque Users List
> > > Cc: jmcnally@collab.net; bmclaugh@algx.net; frank.kim@clearink.com
> > > Betreff: Toruqe supports BLOB ????
> > >
> > >
> > > Dear List and Torque Developers,
> > >
> > > Not much activity on this list is there?? :)
> > >
> > > The http://db.apache.org/torque/dtd/database_3_1.dtd indicates that
> BLOB
> > > are a valid torque data type.
> > >
> > > It possible to save an image to a blob with the current version ? Could
> > > someone give a small example. We have done this using BC4J and with JDBC
> on
> > > its own, does the current version of torque help me?
> > >
> > > Kind regards,
> > >
> > >
> > > Ben bookey.
> > >
> > >
> > > ----- Original Message -----
> > > From: "Michel Beijlevelt / Lucka" <mb...@lucka.nl>
> > > To: "Apache Torque Users List" <to...@db.apache.org>
> > > Sent: Monday, August 04, 2003 2:42 PM
> > > Subject: Re: different internal variable names
> > >
> > >
> > > > Howdy,
> > > >
> > > > the opinion about tight or loose coupling is also influenced by the
> > > > frequency of changes in the RDBMS schema.
> > > >
> > > > If my application is - through Torque - tightly coupled with the
> RDBMS,
> > > > it will almost certainly fail with an exception upon a moderately
> > > > significant change in the RDBMS. Which is good, because it will
> > > > precisely pinpoint the change, and makes 'sure' (well, fairly sure
> that
> > > > is :-) that my appliction only runs against the RDBMS that is was
> > > > designed for and none other.
> > > >
> > > > But I agree, having the possibility of making Torque more loosely
> > > > coupled from the RDBMS would be a nice feature. It could be
> implemented
> > > > by allowing specifying aliases for db objects in the XML schema
> > > > definition which does seem to be fairly simple to implement, but maybe
> a
> > > > more sophisticated abstraction layer isn't that hard to make either.
> > > >
> > > > gr. Michel
> > > >
> > > >
> > > > Manske, Michael wrote:
> > > >
> > > > >hi,
> > > > >
> > > > >i knew that such a discussion would come up and it depends on the
> point
> > > of
> > > > >view of each indivual user. :)
> > > > >
> > > > >
> > > > >
> > > > >>I don't know, I think I would Torque rather see more tightly coupled
> > > > >>with the RDBMS and dump the XML schema entirely.
> > > > >>
> > > > >>
> > > > >if you have control over database structure and changes of the
> database
> > > > >structure, then you will
> > > > >perhaps prefer a strict coupling. But if not (like me), you will
> always
> > > > >prefer loose coupling to be more independent of changes made by
> another
> > > dev
> > > > >team.
> > > > >
> > > > >
> > > > >
> > > > >>My RDBMS already has a schema, which would be the metadatabase in
> the
> > > > >>systems tables. So why create another definition in XML of the same
> > > > >>database and tables?
> > > > >>
> > > > >>
> > > > >If you have to support different RDBMS the metadescription in some
> > > "system
> > > > >tables" will get useless.
> > > > >
> > > > >
> > > > >
> > > > >>Torque's capability of abstraction of the RDBMS-specific
> > > > >>isssues comes
> > > > >>in quite handy here. The process could be automated by having Torque
> > > > >>generate the XML definition from a JDBC conncection, and then
> > > > >>generate
> > > > >>the om from that XML, but I haven't tried that yet.
> > > > >>
> > > > >>
> > > > >Thats what i'm talking about, we are working with torque this way
> because
> > > we
> > > > >have to deal
> > > > >with a couple of already existing databases.
> > > > >And yes, torques abstraction is somewhat of handy - thats why we use
> it.
> > > :-)
> > > > >
> > > > >Loose coupling means among other things to hide the physical database
> > > > >structure completely from the objects, which have to access the
> database.
> > > A
> > > > >layer (like torque) will then act as mediator between objects and
> > > database.
> > > > >So if you would have problematic identifiers like "short", you would
> be
> > > > >easily able to map them to another name, which could then be used in
> java
> > > > >objects, e.g. map "short" to "short_descr".
> > > > >There is already some kind of support for this but at the moment it
> isn't
> > > > >suitable at all.
> > > > >
> > > > >I guess torque is so popular because of his abilities to generate
> more or
> > > > >less useable code and the usage of a xml schema at runtime
> (respectively
> > > at
> > > > >application startup) would possibly be contradictory to the generator
> BUT
> > > it
> > > > >would also provide more independency from used database structure.
> > > > >
> > > > >I'm not sure wheter this is a mainly intention of torque but i would
> be
> > > glad
> > > > >if the devs would expand
> > > > >support for loose coupling (at least for mapping of table/column
> names to
> > > > >java names) in future versions...
> > > > >
> > > > >regards,
> > > > >Michael
> > > > >
> > > > >PS: pros and cons of loose coupling will always be a matter of
> opinion
> > > > >
> > > >
> > > >
> > > >
> > > > ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > > > For additional commands, e-mail: torque-user-help@db.apache.org
> > > >
> > > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail: torque-user-help@db.apache.org
> > >
> > >
> > >
>
>
Re: Toruqe supports BLOB ????
Posted by BEN BOOKEY <br...@hotmail.com>.
Hi joachim
Hope you are well, greetings from Darmstadt ! Here are some more newbie
questions for you !!
I would prefer to have a torque working binary for our web-entry tool that
supports BLOB. I dont really want to get involved in lots of patches and
recompilations of source code!! We already have the latest village jar file
downloaded inside torque lib directory. is this enough or have you editted
the village source?
regards
Ben
----- Original Message -----
From: "Joachim Müller" <jo...@wemove.com>
To: "Apache Torque Users List" <to...@db.apache.org>
Sent: Monday, August 04, 2003 7:55 PM
Subject: AW: Toruqe supports BLOB ????
>
> Hi Ben.
>
> I do use CLOBs with oracle but had to apply a patch to
> do so. I think I read in the mailing list that the current
> CVS version has this fix already.
>
> actually it's in village, not in torque.
>
> If you do not have an solution yet, contact me.
>
>
> regards from frankfurt.
>
> joachim/wemove
>
>
> > -----Ursprüngliche Nachricht-----
> > Von: BEN BOOKEY [mailto:brgbookey@hotmail.com]
> > Gesendet: Montag, 4. August 2003 19:41
> > An: Apache Torque Users List
> > Cc: jmcnally@collab.net; bmclaugh@algx.net; frank.kim@clearink.com
> > Betreff: Toruqe supports BLOB ????
> >
> >
> > Dear List and Torque Developers,
> >
> > Not much activity on this list is there?? :)
> >
> > The http://db.apache.org/torque/dtd/database_3_1.dtd indicates that
BLOB
> > are a valid torque data type.
> >
> > It possible to save an image to a blob with the current version ? Could
> > someone give a small example. We have done this using BC4J and with JDBC
on
> > its own, does the current version of torque help me?
> >
> > Kind regards,
> >
> >
> > Ben bookey.
> >
> >
> > ----- Original Message -----
> > From: "Michel Beijlevelt / Lucka" <mb...@lucka.nl>
> > To: "Apache Torque Users List" <to...@db.apache.org>
> > Sent: Monday, August 04, 2003 2:42 PM
> > Subject: Re: different internal variable names
> >
> >
> > > Howdy,
> > >
> > > the opinion about tight or loose coupling is also influenced by the
> > > frequency of changes in the RDBMS schema.
> > >
> > > If my application is - through Torque - tightly coupled with the
RDBMS,
> > > it will almost certainly fail with an exception upon a moderately
> > > significant change in the RDBMS. Which is good, because it will
> > > precisely pinpoint the change, and makes 'sure' (well, fairly sure
that
> > > is :-) that my appliction only runs against the RDBMS that is was
> > > designed for and none other.
> > >
> > > But I agree, having the possibility of making Torque more loosely
> > > coupled from the RDBMS would be a nice feature. It could be
implemented
> > > by allowing specifying aliases for db objects in the XML schema
> > > definition which does seem to be fairly simple to implement, but maybe
a
> > > more sophisticated abstraction layer isn't that hard to make either.
> > >
> > > gr. Michel
> > >
> > >
> > > Manske, Michael wrote:
> > >
> > > >hi,
> > > >
> > > >i knew that such a discussion would come up and it depends on the
point
> > of
> > > >view of each indivual user. :)
> > > >
> > > >
> > > >
> > > >>I don't know, I think I would Torque rather see more tightly coupled
> > > >>with the RDBMS and dump the XML schema entirely.
> > > >>
> > > >>
> > > >if you have control over database structure and changes of the
database
> > > >structure, then you will
> > > >perhaps prefer a strict coupling. But if not (like me), you will
always
> > > >prefer loose coupling to be more independent of changes made by
another
> > dev
> > > >team.
> > > >
> > > >
> > > >
> > > >>My RDBMS already has a schema, which would be the metadatabase in
the
> > > >>systems tables. So why create another definition in XML of the same
> > > >>database and tables?
> > > >>
> > > >>
> > > >If you have to support different RDBMS the metadescription in some
> > "system
> > > >tables" will get useless.
> > > >
> > > >
> > > >
> > > >>Torque's capability of abstraction of the RDBMS-specific
> > > >>isssues comes
> > > >>in quite handy here. The process could be automated by having Torque
> > > >>generate the XML definition from a JDBC conncection, and then
> > > >>generate
> > > >>the om from that XML, but I haven't tried that yet.
> > > >>
> > > >>
> > > >Thats what i'm talking about, we are working with torque this way
because
> > we
> > > >have to deal
> > > >with a couple of already existing databases.
> > > >And yes, torques abstraction is somewhat of handy - thats why we use
it.
> > :-)
> > > >
> > > >Loose coupling means among other things to hide the physical database
> > > >structure completely from the objects, which have to access the
database.
> > A
> > > >layer (like torque) will then act as mediator between objects and
> > database.
> > > >So if you would have problematic identifiers like "short", you would
be
> > > >easily able to map them to another name, which could then be used in
java
> > > >objects, e.g. map "short" to "short_descr".
> > > >There is already some kind of support for this but at the moment it
isn't
> > > >suitable at all.
> > > >
> > > >I guess torque is so popular because of his abilities to generate
more or
> > > >less useable code and the usage of a xml schema at runtime
(respectively
> > at
> > > >application startup) would possibly be contradictory to the generator
BUT
> > it
> > > >would also provide more independency from used database structure.
> > > >
> > > >I'm not sure wheter this is a mainly intention of torque but i would
be
> > glad
> > > >if the devs would expand
> > > >support for loose coupling (at least for mapping of table/column
names to
> > > >java names) in future versions...
> > > >
> > > >regards,
> > > >Michael
> > > >
> > > >PS: pros and cons of loose coupling will always be a matter of
opinion
> > > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail: torque-user-help@db.apache.org
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> >
> >
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Toruqe supports BLOB ????
Posted by BEN BOOKEY <br...@hotmail.com>.
----- Original Message -----
From: "Joachim Müller" <jo...@wemove.com>
To: "Apache Torque Users List" <to...@db.apache.org>
Sent: Monday, August 04, 2003 7:55 PM
Subject: AW: Toruqe supports BLOB ????
>
> Hi Ben.
>
> I do use CLOBs with oracle but had to apply a patch to
> do so. I think I read in the mailing list that the current
> CVS version has this fix already.
>
> actually it's in village, not in torque.
>
> If you do not have an solution yet, contact me.
>
>
> regards from frankfurt.
>
> joachim/wemove
>
>
> > -----Ursprüngliche Nachricht-----
> > Von: BEN BOOKEY [mailto:brgbookey@hotmail.com]
> > Gesendet: Montag, 4. August 2003 19:41
> > An: Apache Torque Users List
> > Cc: jmcnally@collab.net; bmclaugh@algx.net; frank.kim@clearink.com
> > Betreff: Toruqe supports BLOB ????
> >
> >
> > Dear List and Torque Developers,
> >
> > Not much activity on this list is there?? :)
> >
> > The http://db.apache.org/torque/dtd/database_3_1.dtd indicates that
BLOB
> > are a valid torque data type.
> >
> > It possible to save an image to a blob with the current version ? Could
> > someone give a small example. We have done this using BC4J and with JDBC
on
> > its own, does the current version of torque help me?
> >
> > Kind regards,
> >
> >
> > Ben bookey.
> >
> >
> > ----- Original Message -----
> > From: "Michel Beijlevelt / Lucka" <mb...@lucka.nl>
> > To: "Apache Torque Users List" <to...@db.apache.org>
> > Sent: Monday, August 04, 2003 2:42 PM
> > Subject: Re: different internal variable names
> >
> >
> > > Howdy,
> > >
> > > the opinion about tight or loose coupling is also influenced by the
> > > frequency of changes in the RDBMS schema.
> > >
> > > If my application is - through Torque - tightly coupled with the
RDBMS,
> > > it will almost certainly fail with an exception upon a moderately
> > > significant change in the RDBMS. Which is good, because it will
> > > precisely pinpoint the change, and makes 'sure' (well, fairly sure
that
> > > is :-) that my appliction only runs against the RDBMS that is was
> > > designed for and none other.
> > >
> > > But I agree, having the possibility of making Torque more loosely
> > > coupled from the RDBMS would be a nice feature. It could be
implemented
> > > by allowing specifying aliases for db objects in the XML schema
> > > definition which does seem to be fairly simple to implement, but maybe
a
> > > more sophisticated abstraction layer isn't that hard to make either.
> > >
> > > gr. Michel
> > >
> > >
> > > Manske, Michael wrote:
> > >
> > > >hi,
> > > >
> > > >i knew that such a discussion would come up and it depends on the
point
> > of
> > > >view of each indivual user. :)
> > > >
> > > >
> > > >
> > > >>I don't know, I think I would Torque rather see more tightly coupled
> > > >>with the RDBMS and dump the XML schema entirely.
> > > >>
> > > >>
> > > >if you have control over database structure and changes of the
database
> > > >structure, then you will
> > > >perhaps prefer a strict coupling. But if not (like me), you will
always
> > > >prefer loose coupling to be more independent of changes made by
another
> > dev
> > > >team.
> > > >
> > > >
> > > >
> > > >>My RDBMS already has a schema, which would be the metadatabase in
the
> > > >>systems tables. So why create another definition in XML of the same
> > > >>database and tables?
> > > >>
> > > >>
> > > >If you have to support different RDBMS the metadescription in some
> > "system
> > > >tables" will get useless.
> > > >
> > > >
> > > >
> > > >>Torque's capability of abstraction of the RDBMS-specific
> > > >>isssues comes
> > > >>in quite handy here. The process could be automated by having Torque
> > > >>generate the XML definition from a JDBC conncection, and then
> > > >>generate
> > > >>the om from that XML, but I haven't tried that yet.
> > > >>
> > > >>
> > > >Thats what i'm talking about, we are working with torque this way
because
> > we
> > > >have to deal
> > > >with a couple of already existing databases.
> > > >And yes, torques abstraction is somewhat of handy - thats why we use
it.
> > :-)
> > > >
> > > >Loose coupling means among other things to hide the physical database
> > > >structure completely from the objects, which have to access the
database.
> > A
> > > >layer (like torque) will then act as mediator between objects and
> > database.
> > > >So if you would have problematic identifiers like "short", you would
be
> > > >easily able to map them to another name, which could then be used in
java
> > > >objects, e.g. map "short" to "short_descr".
> > > >There is already some kind of support for this but at the moment it
isn't
> > > >suitable at all.
> > > >
> > > >I guess torque is so popular because of his abilities to generate
more or
> > > >less useable code and the usage of a xml schema at runtime
(respectively
> > at
> > > >application startup) would possibly be contradictory to the generator
BUT
> > it
> > > >would also provide more independency from used database structure.
> > > >
> > > >I'm not sure wheter this is a mainly intention of torque but i would
be
> > glad
> > > >if the devs would expand
> > > >support for loose coupling (at least for mapping of table/column
names to
> > > >java names) in future versions...
> > > >
> > > >regards,
> > > >Michael
> > > >
> > > >PS: pros and cons of loose coupling will always be a matter of
opinion
> > > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail: torque-user-help@db.apache.org
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> >
> >
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: AW: Toruqe supports BLOB ????
Posted by Martin Poeschl <mp...@marmot.at>.
you can fix this by simply grabbing the latest village jar from
http://www.ibiblio.org/maven/village/jars
martin
Joachim Müller wrote:
>Hi Ben.
>
>I do use CLOBs with oracle but had to apply a patch to
>do so. I think I read in the mailing list that the current
>CVS version has this fix already.
>
>actually it's in village, not in torque.
>
>If you do not have an solution yet, contact me.
>
>
>regards from frankfurt.
>
>joachim/wemove
>
>
>
>
>>-----Ursprüngliche Nachricht-----
>>Von: BEN BOOKEY [mailto:brgbookey@hotmail.com]
>>Gesendet: Montag, 4. August 2003 19:41
>>An: Apache Torque Users List
>>Cc: jmcnally@collab.net; bmclaugh@algx.net; frank.kim@clearink.com
>>Betreff: Toruqe supports BLOB ????
>>
>>
>>Dear List and Torque Developers,
>>
>>Not much activity on this list is there?? :)
>>
>>The http://db.apache.org/torque/dtd/database_3_1.dtd indicates that BLOB
>>are a valid torque data type.
>>
>>It possible to save an image to a blob with the current version ? Could
>>someone give a small example. We have done this using BC4J and with JDBC on
>>its own, does the current version of torque help me?
>>
>>Kind regards,
>>
>>
>>Ben bookey.
>>
>>
>>----- Original Message -----
>>From: "Michel Beijlevelt / Lucka" <mb...@lucka.nl>
>>To: "Apache Torque Users List" <to...@db.apache.org>
>>Sent: Monday, August 04, 2003 2:42 PM
>>Subject: Re: different internal variable names
>>
>>
>>
>>
>>>Howdy,
>>>
>>>the opinion about tight or loose coupling is also influenced by the
>>>frequency of changes in the RDBMS schema.
>>>
>>>If my application is - through Torque - tightly coupled with the RDBMS,
>>>it will almost certainly fail with an exception upon a moderately
>>>significant change in the RDBMS. Which is good, because it will
>>>precisely pinpoint the change, and makes 'sure' (well, fairly sure that
>>>is :-) that my appliction only runs against the RDBMS that is was
>>>designed for and none other.
>>>
>>>But I agree, having the possibility of making Torque more loosely
>>>coupled from the RDBMS would be a nice feature. It could be implemented
>>>by allowing specifying aliases for db objects in the XML schema
>>>definition which does seem to be fairly simple to implement, but maybe a
>>>more sophisticated abstraction layer isn't that hard to make either.
>>>
>>>gr. Michel
>>>
>>>
>>>Manske, Michael wrote:
>>>
>>>
>>>
>>>>hi,
>>>>
>>>>i knew that such a discussion would come up and it depends on the point
>>>>
>>>>
>>of
>>
>>
>>>>view of each indivual user. :)
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>I don't know, I think I would Torque rather see more tightly coupled
>>>>>with the RDBMS and dump the XML schema entirely.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>if you have control over database structure and changes of the database
>>>>structure, then you will
>>>>perhaps prefer a strict coupling. But if not (like me), you will always
>>>>prefer loose coupling to be more independent of changes made by another
>>>>
>>>>
>>dev
>>
>>
>>>>team.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>My RDBMS already has a schema, which would be the metadatabase in the
>>>>>systems tables. So why create another definition in XML of the same
>>>>>database and tables?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>If you have to support different RDBMS the metadescription in some
>>>>
>>>>
>>"system
>>
>>
>>>>tables" will get useless.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Torque's capability of abstraction of the RDBMS-specific
>>>>>isssues comes
>>>>>in quite handy here. The process could be automated by having Torque
>>>>>generate the XML definition from a JDBC conncection, and then
>>>>>generate
>>>>>the om from that XML, but I haven't tried that yet.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>Thats what i'm talking about, we are working with torque this way because
>>>>
>>>>
>>we
>>
>>
>>>>have to deal
>>>>with a couple of already existing databases.
>>>>And yes, torques abstraction is somewhat of handy - thats why we use it.
>>>>
>>>>
>>:-)
>>
>>
>>>>Loose coupling means among other things to hide the physical database
>>>>structure completely from the objects, which have to access the database.
>>>>
>>>>
>>A
>>
>>
>>>>layer (like torque) will then act as mediator between objects and
>>>>
>>>>
>>database.
>>
>>
>>>>So if you would have problematic identifiers like "short", you would be
>>>>easily able to map them to another name, which could then be used in java
>>>>objects, e.g. map "short" to "short_descr".
>>>>There is already some kind of support for this but at the moment it isn't
>>>>suitable at all.
>>>>
>>>>I guess torque is so popular because of his abilities to generate more or
>>>>less useable code and the usage of a xml schema at runtime (respectively
>>>>
>>>>
>>at
>>
>>
>>>>application startup) would possibly be contradictory to the generator BUT
>>>>
>>>>
>>it
>>
>>
>>>>would also provide more independency from used database structure.
>>>>
>>>>I'm not sure wheter this is a mainly intention of torque but i would be
>>>>
>>>>
>>glad
>>
>>
>>>>if the devs would expand
>>>>support for loose coupling (at least for mapping of table/column names to
>>>>java names) in future versions...
>>>>
>>>>regards,
>>>>Michael
>>>>
>>>>PS: pros and cons of loose coupling will always be a matter of opinion
>>>>
>>>>
>>>>
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>For additional commands, e-mail: torque-user-help@db.apache.org
>>>
>>>
>>>
>>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
AW: Toruqe supports BLOB ????
Posted by Joachim Müller <jo...@wemove.com>.
Hi Ben.
I do use CLOBs with oracle but had to apply a patch to
do so. I think I read in the mailing list that the current
CVS version has this fix already.
actually it's in village, not in torque.
If you do not have an solution yet, contact me.
regards from frankfurt.
joachim/wemove
> -----Ursprüngliche Nachricht-----
> Von: BEN BOOKEY [mailto:brgbookey@hotmail.com]
> Gesendet: Montag, 4. August 2003 19:41
> An: Apache Torque Users List
> Cc: jmcnally@collab.net; bmclaugh@algx.net; frank.kim@clearink.com
> Betreff: Toruqe supports BLOB ????
>
>
> Dear List and Torque Developers,
>
> Not much activity on this list is there?? :)
>
> The http://db.apache.org/torque/dtd/database_3_1.dtd indicates that BLOB
> are a valid torque data type.
>
> It possible to save an image to a blob with the current version ? Could
> someone give a small example. We have done this using BC4J and with JDBC on
> its own, does the current version of torque help me?
>
> Kind regards,
>
>
> Ben bookey.
>
>
> ----- Original Message -----
> From: "Michel Beijlevelt / Lucka" <mb...@lucka.nl>
> To: "Apache Torque Users List" <to...@db.apache.org>
> Sent: Monday, August 04, 2003 2:42 PM
> Subject: Re: different internal variable names
>
>
> > Howdy,
> >
> > the opinion about tight or loose coupling is also influenced by the
> > frequency of changes in the RDBMS schema.
> >
> > If my application is - through Torque - tightly coupled with the RDBMS,
> > it will almost certainly fail with an exception upon a moderately
> > significant change in the RDBMS. Which is good, because it will
> > precisely pinpoint the change, and makes 'sure' (well, fairly sure that
> > is :-) that my appliction only runs against the RDBMS that is was
> > designed for and none other.
> >
> > But I agree, having the possibility of making Torque more loosely
> > coupled from the RDBMS would be a nice feature. It could be implemented
> > by allowing specifying aliases for db objects in the XML schema
> > definition which does seem to be fairly simple to implement, but maybe a
> > more sophisticated abstraction layer isn't that hard to make either.
> >
> > gr. Michel
> >
> >
> > Manske, Michael wrote:
> >
> > >hi,
> > >
> > >i knew that such a discussion would come up and it depends on the point
> of
> > >view of each indivual user. :)
> > >
> > >
> > >
> > >>I don't know, I think I would Torque rather see more tightly coupled
> > >>with the RDBMS and dump the XML schema entirely.
> > >>
> > >>
> > >if you have control over database structure and changes of the database
> > >structure, then you will
> > >perhaps prefer a strict coupling. But if not (like me), you will always
> > >prefer loose coupling to be more independent of changes made by another
> dev
> > >team.
> > >
> > >
> > >
> > >>My RDBMS already has a schema, which would be the metadatabase in the
> > >>systems tables. So why create another definition in XML of the same
> > >>database and tables?
> > >>
> > >>
> > >If you have to support different RDBMS the metadescription in some
> "system
> > >tables" will get useless.
> > >
> > >
> > >
> > >>Torque's capability of abstraction of the RDBMS-specific
> > >>isssues comes
> > >>in quite handy here. The process could be automated by having Torque
> > >>generate the XML definition from a JDBC conncection, and then
> > >>generate
> > >>the om from that XML, but I haven't tried that yet.
> > >>
> > >>
> > >Thats what i'm talking about, we are working with torque this way because
> we
> > >have to deal
> > >with a couple of already existing databases.
> > >And yes, torques abstraction is somewhat of handy - thats why we use it.
> :-)
> > >
> > >Loose coupling means among other things to hide the physical database
> > >structure completely from the objects, which have to access the database.
> A
> > >layer (like torque) will then act as mediator between objects and
> database.
> > >So if you would have problematic identifiers like "short", you would be
> > >easily able to map them to another name, which could then be used in java
> > >objects, e.g. map "short" to "short_descr".
> > >There is already some kind of support for this but at the moment it isn't
> > >suitable at all.
> > >
> > >I guess torque is so popular because of his abilities to generate more or
> > >less useable code and the usage of a xml schema at runtime (respectively
> at
> > >application startup) would possibly be contradictory to the generator BUT
> it
> > >would also provide more independency from used database structure.
> > >
> > >I'm not sure wheter this is a mainly intention of torque but i would be
> glad
> > >if the devs would expand
> > >support for loose coupling (at least for mapping of table/column names to
> > >java names) in future versions...
> > >
> > >regards,
> > >Michael
> > >
> > >PS: pros and cons of loose coupling will always be a matter of opinion
> > >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
Re: Toruqe supports BLOB ????
Posted by Bill Leng <wl...@metatomix.com>.
In fact, I was able to save about 2M blob with oracle's thinjdbc driver.
However, I cannot update the blob. That is why I tried datadirect's
driver with witch I can save and update upto about 9M blob. I have not
tried anything bigger than 9M.
Bill
BEN BOOKEY wrote:
> Dear Bill,
>
> We have tested using BC4J which uses Oracle JDBC driver behind the scenes,
> and we saved BLOBS no problem with a size aprox. greater than 15k. !! I am
> a little suprised !!
>
> regards
> Ben
>
>
> ----- Original Message -----
> From: "Bill Leng" <wl...@metatomix.com>
> To: "Apache Torque Users List" <to...@db.apache.org>
> Sent: Monday, August 04, 2003 8:02 PM
> Subject: Re: Toruqe supports BLOB ????
>
>
>
>>Add to Geoff's comment. It is confirmed that it works with datadirect's
>>jdbc driver for Oracle. Oracle's thin jdbc driver does not work.
>>
>>Geoff Fortytwo wrote:
>>
>>
>>>If you're using oracle than it isn't possible to use blobs with torque.
>>>(except possibly if you use a driver that's not from Oracle. but that
>>>isn't confirmed)
>>>
>>>At 10:40 AM 8/4/2003, you wrote:
>>>
>>>
>>>>Dear List and Torque Developers,
>>>>
>>>>Not much activity on this list is there?? :)
>>>>
>>>>The http://db.apache.org/torque/dtd/database_3_1.dtd indicates that
>
> BLOB
>
>>>>are a valid torque data type.
>>>>
>>>>It possible to save an image to a blob with the current version ? Could
>>>>someone give a small example. We have done this using BC4J and with
>>>>JDBC on
>>>>its own, does the current version of torque help me?
>>>>
>>>>Kind regards,
>>>>
>>>>
>>>>Ben bookey.
>>>>
>>>>
>>>>----- Original Message -----
>>>>From: "Michel Beijlevelt / Lucka" <mb...@lucka.nl>
>>>>To: "Apache Torque Users List" <to...@db.apache.org>
>>>>Sent: Monday, August 04, 2003 2:42 PM
>>>>Subject: Re: different internal variable names
>>>>
>>>>
>>>>
>>>>>Howdy,
>>>>>
>>>>>the opinion about tight or loose coupling is also influenced by the
>>>>>frequency of changes in the RDBMS schema.
>>>>>
>>>>>If my application is - through Torque - tightly coupled with the
>
> RDBMS,
>
>>>>>it will almost certainly fail with an exception upon a moderately
>>>>>significant change in the RDBMS. Which is good, because it will
>>>>>precisely pinpoint the change, and makes 'sure' (well, fairly sure
>
> that
>
>>>>>is :-) that my appliction only runs against the RDBMS that is was
>>>>>designed for and none other.
>>>>>
>>>>>But I agree, having the possibility of making Torque more loosely
>>>>>coupled from the RDBMS would be a nice feature. It could be
>
> implemented
>
>>>>>by allowing specifying aliases for db objects in the XML schema
>>>>>definition which does seem to be fairly simple to implement, but
>>>>
>>>>maybe a
>>>>
>>>>>more sophisticated abstraction layer isn't that hard to make either.
>>>>>
>>>>>gr. Michel
>>>>>
>>>>>
>>>>>Manske, Michael wrote:
>>>>>
>>>>>
>>>>>>hi,
>>>>>>
>>>>>>i knew that such a discussion would come up and it depends on the
>>>>
>>>>point
>>>>of
>>>>
>>>>>>view of each indivual user. :)
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>I don't know, I think I would Torque rather see more tightly
>
> coupled
>
>>>>>>>with the RDBMS and dump the XML schema entirely.
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>if you have control over database structure and changes of the
>>>>
>>>>database
>>>>
>>>>>>structure, then you will
>>>>>>perhaps prefer a strict coupling. But if not (like me), you will
>>>>
>>>>always
>>>>
>>>>>>prefer loose coupling to be more independent of changes made by
>>>>
>>>>another
>>>>dev
>>>>
>>>>>>team.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>My RDBMS already has a schema, which would be the metadatabase in
>
> the
>
>>>>>>>systems tables. So why create another definition in XML of the same
>>>>>>>database and tables?
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>If you have to support different RDBMS the metadescription in some
>>>>
>>>>"system
>>>>
>>>>>>tables" will get useless.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Torque's capability of abstraction of the RDBMS-specific
>>>>>>>isssues comes
>>>>>>>in quite handy here. The process could be automated by having
>
> Torque
>
>>>>>>>generate the XML definition from a JDBC conncection, and then
>>>>>>>generate
>>>>>>>the om from that XML, but I haven't tried that yet.
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>Thats what i'm talking about, we are working with torque this way
>>>>
>>>>because
>>>>we
>>>>
>>>>>>have to deal
>>>>>>with a couple of already existing databases.
>>>>>>And yes, torques abstraction is somewhat of handy - thats why we
>>>>
>>>>use it.
>>>>:-)
>>>>
>>>>>>Loose coupling means among other things to hide the physical
>
> database
>
>>>>>>structure completely from the objects, which have to access the
>>>>
>>>>database.
>>>>A
>>>>
>>>>>>layer (like torque) will then act as mediator between objects and
>>>>
>>>>database.
>>>>
>>>>>>So if you would have problematic identifiers like "short", you
>>>>
>>>>would be
>>>>
>>>>>>easily able to map them to another name, which could then be used
>>>>
>>>>in java
>>>>
>>>>>>objects, e.g. map "short" to "short_descr".
>>>>>>There is already some kind of support for this but at the moment it
>>>>
>>>>isn't
>>>>
>>>>>>suitable at all.
>>>>>>
>>>>>>I guess torque is so popular because of his abilities to generate
>>>>
>>>>more or
>>>>
>>>>>>less useable code and the usage of a xml schema at runtime
>>>>
>>>>(respectively
>>>>at
>>>>
>>>>>>application startup) would possibly be contradictory to the
>>>>
>>>>generator BUT
>>>>it
>>>>
>>>>>>would also provide more independency from used database structure.
>>>>>>
>>>>>>I'm not sure wheter this is a mainly intention of torque but i
>>>>
>>>>would be
>>>>glad
>>>>
>>>>>>if the devs would expand
>>>>>>support for loose coupling (at least for mapping of table/column
>>>>
>>>>names to
>>>>
>>>>>>java names) in future versions...
>>>>>>
>>>>>>regards,
>>>>>>Michael
>>>>>>
>>>>>>PS: pros and cons of loose coupling will always be a matter of
>
> opinion
>
>>>>>
>>>>>
>>>>>---------------------------------------------------------------------
>>>>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>>>For additional commands, e-mail: torque-user-help@db.apache.org
>>>>>
>>>>>
>>>>
>>>>
>>>>---------------------------------------------------------------------
>>>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>>For additional commands, e-mail: torque-user-help@db.apache.org
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>--
>>Bill Leng
>>Metatomix, Inc.
>>Tel: (901)261-8911
>>Fax: (901)261-8901
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
--
Bill Leng
Metatomix, Inc.
Tel: (901)261-8911
Fax: (901)261-8901
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Toruqe supports BLOB ????
Posted by BEN BOOKEY <br...@hotmail.com>.
Dear Bill,
We have tested using BC4J which uses Oracle JDBC driver behind the scenes,
and we saved BLOBS no problem with a size aprox. greater than 15k. !! I am
a little suprised !!
regards
Ben
----- Original Message -----
From: "Bill Leng" <wl...@metatomix.com>
To: "Apache Torque Users List" <to...@db.apache.org>
Sent: Monday, August 04, 2003 8:02 PM
Subject: Re: Toruqe supports BLOB ????
> Add to Geoff's comment. It is confirmed that it works with datadirect's
> jdbc driver for Oracle. Oracle's thin jdbc driver does not work.
>
> Geoff Fortytwo wrote:
>
> > If you're using oracle than it isn't possible to use blobs with torque.
> > (except possibly if you use a driver that's not from Oracle. but that
> > isn't confirmed)
> >
> > At 10:40 AM 8/4/2003, you wrote:
> >
> >> Dear List and Torque Developers,
> >>
> >> Not much activity on this list is there?? :)
> >>
> >> The http://db.apache.org/torque/dtd/database_3_1.dtd indicates that
BLOB
> >> are a valid torque data type.
> >>
> >> It possible to save an image to a blob with the current version ? Could
> >> someone give a small example. We have done this using BC4J and with
> >> JDBC on
> >> its own, does the current version of torque help me?
> >>
> >> Kind regards,
> >>
> >>
> >> Ben bookey.
> >>
> >>
> >> ----- Original Message -----
> >> From: "Michel Beijlevelt / Lucka" <mb...@lucka.nl>
> >> To: "Apache Torque Users List" <to...@db.apache.org>
> >> Sent: Monday, August 04, 2003 2:42 PM
> >> Subject: Re: different internal variable names
> >>
> >>
> >> > Howdy,
> >> >
> >> > the opinion about tight or loose coupling is also influenced by the
> >> > frequency of changes in the RDBMS schema.
> >> >
> >> > If my application is - through Torque - tightly coupled with the
RDBMS,
> >> > it will almost certainly fail with an exception upon a moderately
> >> > significant change in the RDBMS. Which is good, because it will
> >> > precisely pinpoint the change, and makes 'sure' (well, fairly sure
that
> >> > is :-) that my appliction only runs against the RDBMS that is was
> >> > designed for and none other.
> >> >
> >> > But I agree, having the possibility of making Torque more loosely
> >> > coupled from the RDBMS would be a nice feature. It could be
implemented
> >> > by allowing specifying aliases for db objects in the XML schema
> >> > definition which does seem to be fairly simple to implement, but
> >> maybe a
> >> > more sophisticated abstraction layer isn't that hard to make either.
> >> >
> >> > gr. Michel
> >> >
> >> >
> >> > Manske, Michael wrote:
> >> >
> >> > >hi,
> >> > >
> >> > >i knew that such a discussion would come up and it depends on the
> >> point
> >> of
> >> > >view of each indivual user. :)
> >> > >
> >> > >
> >> > >
> >> > >>I don't know, I think I would Torque rather see more tightly
coupled
> >> > >>with the RDBMS and dump the XML schema entirely.
> >> > >>
> >> > >>
> >> > >if you have control over database structure and changes of the
> >> database
> >> > >structure, then you will
> >> > >perhaps prefer a strict coupling. But if not (like me), you will
> >> always
> >> > >prefer loose coupling to be more independent of changes made by
> >> another
> >> dev
> >> > >team.
> >> > >
> >> > >
> >> > >
> >> > >>My RDBMS already has a schema, which would be the metadatabase in
the
> >> > >>systems tables. So why create another definition in XML of the same
> >> > >>database and tables?
> >> > >>
> >> > >>
> >> > >If you have to support different RDBMS the metadescription in some
> >> "system
> >> > >tables" will get useless.
> >> > >
> >> > >
> >> > >
> >> > >>Torque's capability of abstraction of the RDBMS-specific
> >> > >>isssues comes
> >> > >>in quite handy here. The process could be automated by having
Torque
> >> > >>generate the XML definition from a JDBC conncection, and then
> >> > >>generate
> >> > >>the om from that XML, but I haven't tried that yet.
> >> > >>
> >> > >>
> >> > >Thats what i'm talking about, we are working with torque this way
> >> because
> >> we
> >> > >have to deal
> >> > >with a couple of already existing databases.
> >> > >And yes, torques abstraction is somewhat of handy - thats why we
> >> use it.
> >> :-)
> >> > >
> >> > >Loose coupling means among other things to hide the physical
database
> >> > >structure completely from the objects, which have to access the
> >> database.
> >> A
> >> > >layer (like torque) will then act as mediator between objects and
> >> database.
> >> > >So if you would have problematic identifiers like "short", you
> >> would be
> >> > >easily able to map them to another name, which could then be used
> >> in java
> >> > >objects, e.g. map "short" to "short_descr".
> >> > >There is already some kind of support for this but at the moment it
> >> isn't
> >> > >suitable at all.
> >> > >
> >> > >I guess torque is so popular because of his abilities to generate
> >> more or
> >> > >less useable code and the usage of a xml schema at runtime
> >> (respectively
> >> at
> >> > >application startup) would possibly be contradictory to the
> >> generator BUT
> >> it
> >> > >would also provide more independency from used database structure.
> >> > >
> >> > >I'm not sure wheter this is a mainly intention of torque but i
> >> would be
> >> glad
> >> > >if the devs would expand
> >> > >support for loose coupling (at least for mapping of table/column
> >> names to
> >> > >java names) in future versions...
> >> > >
> >> > >regards,
> >> > >Michael
> >> > >
> >> > >PS: pros and cons of loose coupling will always be a matter of
opinion
> >> > >
> >> >
> >> >
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >> > For additional commands, e-mail: torque-user-help@db.apache.org
> >> >
> >> >
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >> For additional commands, e-mail: torque-user-help@db.apache.org
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
>
> --
> Bill Leng
> Metatomix, Inc.
> Tel: (901)261-8911
> Fax: (901)261-8901
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Jian Dai <ja...@comcast.net>.
Thanks, Ramesh.
I have that book and it does talk some of torque. But I could not
find the place where it talks about how to configure torque in Struts.
Do you happen to remember in which chapter (or which pages) is this
issue mentioned?
Jack
-----Original Message-----
From: Ramesh Sabeti [mailto:rs@reazon.com]
Sent: Monday, August 04, 2003 5:58 PM
To: 'Apache Torque Users List'
Subject: RE: Configure Torque for Struts
The best reference is "Kick Start Struts" by Turner and Bedell. They
use the older beta version of Torque, but with minor changes we got it
to work.
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 5:54 PM
> To: Apache Torque Users List
> Subject: Configure Torque for Struts
>
> Hi, all:
>
> I am planning to use Torque as data module in
> Struts architecture. Is there anybody who knows
> how to configure torque for struts?
>
> Many thanks for the nice help.
>
> Jack
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Ramesh Sabeti <rs...@reazon.com>.
The best reference is "Kick Start Struts" by Turner and Bedell. They
use the older beta version of Torque, but with minor changes we got it
to work.
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 5:54 PM
> To: Apache Torque Users List
> Subject: Configure Torque for Struts
>
> Hi, all:
>
> I am planning to use Torque as data module in
> Struts architecture. Is there anybody who knows
> how to configure torque for struts?
>
> Many thanks for the nice help.
>
> Jack
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Brian Adams <bi...@satx.rr.com>.
Simple enough thanks!
B
-----Original Message-----
From: Amit Rana [mailto:rana@solis.jp]
Sent: Monday, August 04, 2003 11:25 PM
To: 'Apache Torque Users List'
Subject: RE: Configure Torque for Struts
We initially put it in WEB-INF/conf and recently moved it to a package.
Where ever we put it I think main problem is in passing the file name to
Torque.init method.
We are doing that with an initialization servlet which is loaded on
server startup and initializes Torque (alternatively, you can initialize
Torque when needed).
Simple code to initialize is:
Torque.init(getServletContext_or_request.
getRealPath("WEB-INF/conf/Torque.properties"));
Comments are welcome.
Regards,
Amit.
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Tuesday, August 05, 2003 1:11 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
> ah I see. I had trouble with it and I finally got it running by
dropping
> the file in TOMCAT_HOME.
> I know this is not good but I just left it for now. Thanks for
reminding me
> about that I will put this on my TODO for fixing. I do not know how to
put
> it in the webapp and get it to work.
> Does anyone on the LIST know?
> B
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 11:09 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> Hi, Brian:
>
> Basically, I need to figure out where I can put the Torque.properties
> file in Struts. In your case, after you generate the OM classes and
put
> them into your project, I guess you still need to configure this
property
> file so that your OM classes can realize it during runtime. My
question is
> how you did it
>
> Thanks a lot for nice help.
>
> Jack
>
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Monday, August 04, 2003 8:48 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> Hey Jack, I am not sure what you mean. I am using Torque with Struts
and I
> use a bean class that contains my Business Logic it makes calls to the
> Object Model classes. I keep the entire Torque package in another
area and
> when I gen the OM Classes for my project it creates them in my project
area.
> Does that make sense?
> Brian
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 7:54 PM
> To: Apache Torque Users List
> Subject: Configure Torque for Struts
>
>
> Hi, all:
>
> I am planning to use Torque as data module in
> Struts architecture. Is there anybody who knows
> how to configure torque for struts?
>
> Many thanks for the nice help.
>
> Jack
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Configure Torque for Struts
Posted by Mark Lowe <ma...@talk21.com>.
Hello
I'd be interested if the posting worked for you.
Cheers Mark
On Tuesday, August 5, 2003, at 03:39 PM, Brian Adams wrote:
> Thank you. That is very helpful.
> B
>
>
> --- Jian Dai <ja...@comcast.net> wrote:
>> Hi, Brian
>>
>> I have tried Amit's method. It works. Here is a
>> link of how to create such a servlet in case that
>> you may be interested.
>>
>>
> http://www.mail-archive.com/struts-user@jakarta.apache.org/
> msg72669.html
>>
>> Jack
>>
>> -----Original Message-----
>> From: Brian Adams [mailto:bigb@satx.rr.com]
>> Sent: Monday, August 04, 2003 9:33 PM
>> To: Apache Torque Users List
>> Subject: RE: Configure Torque for Struts
>>
>>
>> I start tomcat with ./bin/catalina run and this is
>> why it works. if I cd
>> into the bin and start catalina then it will not see
>> the Torque.props file.
>> This is one reason why I knew I needed a fix.
>>
>> -----Original Message-----
>> From: Jian Dai [mailto:jack2110@comcast.net]
>> Sent: Monday, August 04, 2003 11:34 PM
>> To: Apache Torque Users List
>> Subject: RE: Configure Torque for Struts
>>
>>
>> I tried to put that file in TOMCAT_HOME. It did not
>> work for me.
>> I am going to try Amit's method later.
>>
>> Thank you guys very much for the nice help.
>>
>> Jack
>>
>> -----Original Message-----
>> From: Amit Rana [mailto:rana@solis.jp]
>> Sent: Monday, August 04, 2003 9:25 PM
>> To: 'Apache Torque Users List'
>> Subject: RE: Configure Torque for Struts
>>
>>
>> We initially put it in WEB-INF/conf and recently
>> moved it to a package.
>> Where ever we put it I think main problem is in
>> passing the file name to
>> Torque.init method.
>>
>> We are doing that with an initialization servlet
>> which is loaded on
>> server startup and initializes Torque
>> (alternatively, you can initialize
>> Torque when needed).
>>
>> Simple code to initialize is:
>> Torque.init(getServletContext_or_request.
>> getRealPath("WEB-INF/conf/Torque.properties"));
>>
>> Comments are welcome.
>>
>> Regards,
>> Amit.
>>
>>> -----Original Message-----
>>> From: Brian Adams [mailto:bigb@satx.rr.com]
>>> Sent: Tuesday, August 05, 2003 1:11 PM
>>> To: Apache Torque Users List
>>> Subject: RE: Configure Torque for Struts
>>>
>>> ah I see. I had trouble with it and I finally got
>> it running by
>> dropping
>>> the file in TOMCAT_HOME.
>>> I know this is not good but I just left it for
>> now. Thanks for
>> reminding me
>>> about that I will put this on my TODO for fixing.
>> I do not know how to
>> put
>>> it in the webapp and get it to work.
>>> Does anyone on the LIST know?
>>> B
>>>
>>> -----Original Message-----
>>> From: Jian Dai [mailto:jack2110@comcast.net]
>>> Sent: Monday, August 04, 2003 11:09 PM
>>> To: Apache Torque Users List
>>> Subject: RE: Configure Torque for Struts
>>>
>>>
>>> Hi, Brian:
>>>
>>> Basically, I need to figure out where I can put
>> the Torque.properties
>>> file in Struts. In your case, after you generate
>> the OM classes and
>> put
>>> them into your project, I guess you still need to
>> configure this
>> property
>>> file so that your OM classes can realize it during
>> runtime. My
>> question is
>>> how you did it
>>>
>>> Thanks a lot for nice help.
>>>
>>> Jack
>>>
>>> -----Original Message-----
>>> From: Brian Adams [mailto:bigb@satx.rr.com]
>>> Sent: Monday, August 04, 2003 8:48 PM
>>> To: Apache Torque Users List
>>> Subject: RE: Configure Torque for Struts
>>>
>>>
>>> Hey Jack, I am not sure what you mean. I am using
>> Torque with Struts
>> and I
>>> use a bean class that contains my Business Logic
>> it makes calls to the
>>> Object Model classes. I keep the entire Torque
>> package in another
>> area and
>>> when I gen the OM Classes for my project it
>> creates them in my project
>> area.
>>> Does that make sense?
>>> Brian
>>>
>>> -----Original Message-----
>>> From: Jian Dai [mailto:jack2110@comcast.net]
>>> Sent: Monday, August 04, 2003 7:54 PM
>>> To: Apache Torque Users List
>>> Subject: Configure Torque for Struts
>>>
>>>
>>> Hi, all:
>>>
>>> I am planning to use Torque as data module in
>>> Struts architecture. Is there anybody who knows
>>> how to configure torque for struts?
>>>
>>> Many thanks for the nice help.
>>>
>>> Jack
>>>
>>>
>>>
>>
> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail:
>> torque-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail:
>> torque-user-help@db.apache.org
>>>
>>>
>>>
>>>
>>
> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail:
>> torque-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail:
>> torque-user-help@db.apache.org
>>>
>>>
>>>
>>>
>>>
>>
> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail:
>> torque-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail:
>> torque-user-help@db.apache.org
>>>
>>>
>>>
>>>
>>
> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail:
>> torque-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail:
>> torque-user-help@db.apache.org
>>
>>
>>
> ---------------------------------------------------------------------
>> To unsubscribe, e-mail:
>> torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail:
>> torque-user-help@db.apache.org
>>
>>
>>
>>
> ---------------------------------------------------------------------
>> To unsubscribe, e-mail:
>> torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail:
>> torque-user-help@db.apache.org
>>
>>
> === message truncated ===
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Brian Adams <ju...@yahoo.com>.
Thank you. That is very helpful.
B
--- Jian Dai <ja...@comcast.net> wrote:
> Hi, Brian
>
> I have tried Amit's method. It works. Here is a
> link of how to create such a servlet in case that
> you may be interested.
>
>
http://www.mail-archive.com/struts-user@jakarta.apache.org/msg72669.html
>
> Jack
>
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Monday, August 04, 2003 9:33 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> I start tomcat with ./bin/catalina run and this is
> why it works. if I cd
> into the bin and start catalina then it will not see
> the Torque.props file.
> This is one reason why I knew I needed a fix.
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 11:34 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> I tried to put that file in TOMCAT_HOME. It did not
> work for me.
> I am going to try Amit's method later.
>
> Thank you guys very much for the nice help.
>
> Jack
>
> -----Original Message-----
> From: Amit Rana [mailto:rana@solis.jp]
> Sent: Monday, August 04, 2003 9:25 PM
> To: 'Apache Torque Users List'
> Subject: RE: Configure Torque for Struts
>
>
> We initially put it in WEB-INF/conf and recently
> moved it to a package.
> Where ever we put it I think main problem is in
> passing the file name to
> Torque.init method.
>
> We are doing that with an initialization servlet
> which is loaded on
> server startup and initializes Torque
> (alternatively, you can initialize
> Torque when needed).
>
> Simple code to initialize is:
> Torque.init(getServletContext_or_request.
> getRealPath("WEB-INF/conf/Torque.properties"));
>
> Comments are welcome.
>
> Regards,
> Amit.
>
> > -----Original Message-----
> > From: Brian Adams [mailto:bigb@satx.rr.com]
> > Sent: Tuesday, August 05, 2003 1:11 PM
> > To: Apache Torque Users List
> > Subject: RE: Configure Torque for Struts
> >
> > ah I see. I had trouble with it and I finally got
> it running by
> dropping
> > the file in TOMCAT_HOME.
> > I know this is not good but I just left it for
> now. Thanks for
> reminding me
> > about that I will put this on my TODO for fixing.
> I do not know how to
> put
> > it in the webapp and get it to work.
> > Does anyone on the LIST know?
> > B
> >
> > -----Original Message-----
> > From: Jian Dai [mailto:jack2110@comcast.net]
> > Sent: Monday, August 04, 2003 11:09 PM
> > To: Apache Torque Users List
> > Subject: RE: Configure Torque for Struts
> >
> >
> > Hi, Brian:
> >
> > Basically, I need to figure out where I can put
> the Torque.properties
> > file in Struts. In your case, after you generate
> the OM classes and
> put
> > them into your project, I guess you still need to
> configure this
> property
> > file so that your OM classes can realize it during
> runtime. My
> question is
> > how you did it
> >
> > Thanks a lot for nice help.
> >
> > Jack
> >
> > -----Original Message-----
> > From: Brian Adams [mailto:bigb@satx.rr.com]
> > Sent: Monday, August 04, 2003 8:48 PM
> > To: Apache Torque Users List
> > Subject: RE: Configure Torque for Struts
> >
> >
> > Hey Jack, I am not sure what you mean. I am using
> Torque with Struts
> and I
> > use a bean class that contains my Business Logic
> it makes calls to the
> > Object Model classes. I keep the entire Torque
> package in another
> area and
> > when I gen the OM Classes for my project it
> creates them in my project
> area.
> > Does that make sense?
> > Brian
> >
> > -----Original Message-----
> > From: Jian Dai [mailto:jack2110@comcast.net]
> > Sent: Monday, August 04, 2003 7:54 PM
> > To: Apache Torque Users List
> > Subject: Configure Torque for Struts
> >
> >
> > Hi, all:
> >
> > I am planning to use Torque as data module in
> > Struts architecture. Is there anybody who knows
> > how to configure torque for struts?
> >
> > Many thanks for the nice help.
> >
> > Jack
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail:
> torque-user-help@db.apache.org
> >
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail:
> torque-user-help@db.apache.org
> >
> >
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail:
> torque-user-help@db.apache.org
> >
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail:
> torque-user-help@db.apache.org
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> torque-user-help@db.apache.org
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> torque-user-help@db.apache.org
>
>
=== message truncated ===
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Jian Dai <ja...@comcast.net>.
Hi, Brian
I have tried Amit's method. It works. Here is a
link of how to create such a servlet in case that
you may be interested.
http://www.mail-archive.com/struts-user@jakarta.apache.org/msg72669.html
Jack
-----Original Message-----
From: Brian Adams [mailto:bigb@satx.rr.com]
Sent: Monday, August 04, 2003 9:33 PM
To: Apache Torque Users List
Subject: RE: Configure Torque for Struts
I start tomcat with ./bin/catalina run and this is why it works. if I cd
into the bin and start catalina then it will not see the Torque.props file.
This is one reason why I knew I needed a fix.
-----Original Message-----
From: Jian Dai [mailto:jack2110@comcast.net]
Sent: Monday, August 04, 2003 11:34 PM
To: Apache Torque Users List
Subject: RE: Configure Torque for Struts
I tried to put that file in TOMCAT_HOME. It did not work for me.
I am going to try Amit's method later.
Thank you guys very much for the nice help.
Jack
-----Original Message-----
From: Amit Rana [mailto:rana@solis.jp]
Sent: Monday, August 04, 2003 9:25 PM
To: 'Apache Torque Users List'
Subject: RE: Configure Torque for Struts
We initially put it in WEB-INF/conf and recently moved it to a package.
Where ever we put it I think main problem is in passing the file name to
Torque.init method.
We are doing that with an initialization servlet which is loaded on
server startup and initializes Torque (alternatively, you can initialize
Torque when needed).
Simple code to initialize is:
Torque.init(getServletContext_or_request.
getRealPath("WEB-INF/conf/Torque.properties"));
Comments are welcome.
Regards,
Amit.
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Tuesday, August 05, 2003 1:11 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
> ah I see. I had trouble with it and I finally got it running by
dropping
> the file in TOMCAT_HOME.
> I know this is not good but I just left it for now. Thanks for
reminding me
> about that I will put this on my TODO for fixing. I do not know how to
put
> it in the webapp and get it to work.
> Does anyone on the LIST know?
> B
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 11:09 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> Hi, Brian:
>
> Basically, I need to figure out where I can put the Torque.properties
> file in Struts. In your case, after you generate the OM classes and
put
> them into your project, I guess you still need to configure this
property
> file so that your OM classes can realize it during runtime. My
question is
> how you did it
>
> Thanks a lot for nice help.
>
> Jack
>
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Monday, August 04, 2003 8:48 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> Hey Jack, I am not sure what you mean. I am using Torque with Struts
and I
> use a bean class that contains my Business Logic it makes calls to the
> Object Model classes. I keep the entire Torque package in another
area and
> when I gen the OM Classes for my project it creates them in my project
area.
> Does that make sense?
> Brian
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 7:54 PM
> To: Apache Torque Users List
> Subject: Configure Torque for Struts
>
>
> Hi, all:
>
> I am planning to use Torque as data module in
> Struts architecture. Is there anybody who knows
> how to configure torque for struts?
>
> Many thanks for the nice help.
>
> Jack
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Brian Adams <bi...@satx.rr.com>.
I start tomcat with ./bin/catalina run and this is why it works. if I cd
into the bin and start catalina then it will not see the Torque.props file.
This is one reason why I knew I needed a fix.
-----Original Message-----
From: Jian Dai [mailto:jack2110@comcast.net]
Sent: Monday, August 04, 2003 11:34 PM
To: Apache Torque Users List
Subject: RE: Configure Torque for Struts
I tried to put that file in TOMCAT_HOME. It did not work for me.
I am going to try Amit's method later.
Thank you guys very much for the nice help.
Jack
-----Original Message-----
From: Amit Rana [mailto:rana@solis.jp]
Sent: Monday, August 04, 2003 9:25 PM
To: 'Apache Torque Users List'
Subject: RE: Configure Torque for Struts
We initially put it in WEB-INF/conf and recently moved it to a package.
Where ever we put it I think main problem is in passing the file name to
Torque.init method.
We are doing that with an initialization servlet which is loaded on
server startup and initializes Torque (alternatively, you can initialize
Torque when needed).
Simple code to initialize is:
Torque.init(getServletContext_or_request.
getRealPath("WEB-INF/conf/Torque.properties"));
Comments are welcome.
Regards,
Amit.
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Tuesday, August 05, 2003 1:11 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
> ah I see. I had trouble with it and I finally got it running by
dropping
> the file in TOMCAT_HOME.
> I know this is not good but I just left it for now. Thanks for
reminding me
> about that I will put this on my TODO for fixing. I do not know how to
put
> it in the webapp and get it to work.
> Does anyone on the LIST know?
> B
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 11:09 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> Hi, Brian:
>
> Basically, I need to figure out where I can put the Torque.properties
> file in Struts. In your case, after you generate the OM classes and
put
> them into your project, I guess you still need to configure this
property
> file so that your OM classes can realize it during runtime. My
question is
> how you did it
>
> Thanks a lot for nice help.
>
> Jack
>
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Monday, August 04, 2003 8:48 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> Hey Jack, I am not sure what you mean. I am using Torque with Struts
and I
> use a bean class that contains my Business Logic it makes calls to the
> Object Model classes. I keep the entire Torque package in another
area and
> when I gen the OM Classes for my project it creates them in my project
area.
> Does that make sense?
> Brian
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 7:54 PM
> To: Apache Torque Users List
> Subject: Configure Torque for Struts
>
>
> Hi, all:
>
> I am planning to use Torque as data module in
> Struts architecture. Is there anybody who knows
> how to configure torque for struts?
>
> Many thanks for the nice help.
>
> Jack
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Jian Dai <ja...@comcast.net>.
I tried to put that file in TOMCAT_HOME. It did not work for me.
I am going to try Amit's method later.
Thank you guys very much for the nice help.
Jack
-----Original Message-----
From: Amit Rana [mailto:rana@solis.jp]
Sent: Monday, August 04, 2003 9:25 PM
To: 'Apache Torque Users List'
Subject: RE: Configure Torque for Struts
We initially put it in WEB-INF/conf and recently moved it to a package.
Where ever we put it I think main problem is in passing the file name to
Torque.init method.
We are doing that with an initialization servlet which is loaded on
server startup and initializes Torque (alternatively, you can initialize
Torque when needed).
Simple code to initialize is:
Torque.init(getServletContext_or_request.
getRealPath("WEB-INF/conf/Torque.properties"));
Comments are welcome.
Regards,
Amit.
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Tuesday, August 05, 2003 1:11 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
> ah I see. I had trouble with it and I finally got it running by
dropping
> the file in TOMCAT_HOME.
> I know this is not good but I just left it for now. Thanks for
reminding me
> about that I will put this on my TODO for fixing. I do not know how to
put
> it in the webapp and get it to work.
> Does anyone on the LIST know?
> B
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 11:09 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> Hi, Brian:
>
> Basically, I need to figure out where I can put the Torque.properties
> file in Struts. In your case, after you generate the OM classes and
put
> them into your project, I guess you still need to configure this
property
> file so that your OM classes can realize it during runtime. My
question is
> how you did it
>
> Thanks a lot for nice help.
>
> Jack
>
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Monday, August 04, 2003 8:48 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> Hey Jack, I am not sure what you mean. I am using Torque with Struts
and I
> use a bean class that contains my Business Logic it makes calls to the
> Object Model classes. I keep the entire Torque package in another
area and
> when I gen the OM Classes for my project it creates them in my project
area.
> Does that make sense?
> Brian
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 7:54 PM
> To: Apache Torque Users List
> Subject: Configure Torque for Struts
>
>
> Hi, all:
>
> I am planning to use Torque as data module in
> Struts architecture. Is there anybody who knows
> how to configure torque for struts?
>
> Many thanks for the nice help.
>
> Jack
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Amit Rana <ra...@solis.jp>.
We initially put it in WEB-INF/conf and recently moved it to a package.
Where ever we put it I think main problem is in passing the file name to
Torque.init method.
We are doing that with an initialization servlet which is loaded on
server startup and initializes Torque (alternatively, you can initialize
Torque when needed).
Simple code to initialize is:
Torque.init(getServletContext_or_request.
getRealPath("WEB-INF/conf/Torque.properties"));
Comments are welcome.
Regards,
Amit.
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Tuesday, August 05, 2003 1:11 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
> ah I see. I had trouble with it and I finally got it running by
dropping
> the file in TOMCAT_HOME.
> I know this is not good but I just left it for now. Thanks for
reminding me
> about that I will put this on my TODO for fixing. I do not know how to
put
> it in the webapp and get it to work.
> Does anyone on the LIST know?
> B
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 11:09 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> Hi, Brian:
>
> Basically, I need to figure out where I can put the Torque.properties
> file in Struts. In your case, after you generate the OM classes and
put
> them into your project, I guess you still need to configure this
property
> file so that your OM classes can realize it during runtime. My
question is
> how you did it
>
> Thanks a lot for nice help.
>
> Jack
>
> -----Original Message-----
> From: Brian Adams [mailto:bigb@satx.rr.com]
> Sent: Monday, August 04, 2003 8:48 PM
> To: Apache Torque Users List
> Subject: RE: Configure Torque for Struts
>
>
> Hey Jack, I am not sure what you mean. I am using Torque with Struts
and I
> use a bean class that contains my Business Logic it makes calls to the
> Object Model classes. I keep the entire Torque package in another
area and
> when I gen the OM Classes for my project it creates them in my project
area.
> Does that make sense?
> Brian
>
> -----Original Message-----
> From: Jian Dai [mailto:jack2110@comcast.net]
> Sent: Monday, August 04, 2003 7:54 PM
> To: Apache Torque Users List
> Subject: Configure Torque for Struts
>
>
> Hi, all:
>
> I am planning to use Torque as data module in
> Struts architecture. Is there anybody who knows
> how to configure torque for struts?
>
> Many thanks for the nice help.
>
> Jack
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Brian Adams <bi...@satx.rr.com>.
ah I see. I had trouble with it and I finally got it running by dropping
the file in TOMCAT_HOME.
I know this is not good but I just left it for now. Thanks for reminding me
about that I will put this on my TODO for fixing. I do not know how to put
it in the webapp and get it to work.
Does anyone on the LIST know?
B
-----Original Message-----
From: Jian Dai [mailto:jack2110@comcast.net]
Sent: Monday, August 04, 2003 11:09 PM
To: Apache Torque Users List
Subject: RE: Configure Torque for Struts
Hi, Brian:
Basically, I need to figure out where I can put the Torque.properties
file in Struts. In your case, after you generate the OM classes and put
them into your project, I guess you still need to configure this property
file so that your OM classes can realize it during runtime. My question is
how you did it
Thanks a lot for nice help.
Jack
-----Original Message-----
From: Brian Adams [mailto:bigb@satx.rr.com]
Sent: Monday, August 04, 2003 8:48 PM
To: Apache Torque Users List
Subject: RE: Configure Torque for Struts
Hey Jack, I am not sure what you mean. I am using Torque with Struts and I
use a bean class that contains my Business Logic it makes calls to the
Object Model classes. I keep the entire Torque package in another area and
when I gen the OM Classes for my project it creates them in my project area.
Does that make sense?
Brian
-----Original Message-----
From: Jian Dai [mailto:jack2110@comcast.net]
Sent: Monday, August 04, 2003 7:54 PM
To: Apache Torque Users List
Subject: Configure Torque for Struts
Hi, all:
I am planning to use Torque as data module in
Struts architecture. Is there anybody who knows
how to configure torque for struts?
Many thanks for the nice help.
Jack
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Jian Dai <ja...@comcast.net>.
Hi, Brian:
Basically, I need to figure out where I can put the Torque.properties
file in Struts. In your case, after you generate the OM classes and put
them into your project, I guess you still need to configure this property
file so that your OM classes can realize it during runtime. My question is
how you did it
Thanks a lot for nice help.
Jack
-----Original Message-----
From: Brian Adams [mailto:bigb@satx.rr.com]
Sent: Monday, August 04, 2003 8:48 PM
To: Apache Torque Users List
Subject: RE: Configure Torque for Struts
Hey Jack, I am not sure what you mean. I am using Torque with Struts and I
use a bean class that contains my Business Logic it makes calls to the
Object Model classes. I keep the entire Torque package in another area and
when I gen the OM Classes for my project it creates them in my project area.
Does that make sense?
Brian
-----Original Message-----
From: Jian Dai [mailto:jack2110@comcast.net]
Sent: Monday, August 04, 2003 7:54 PM
To: Apache Torque Users List
Subject: Configure Torque for Struts
Hi, all:
I am planning to use Torque as data module in
Struts architecture. Is there anybody who knows
how to configure torque for struts?
Many thanks for the nice help.
Jack
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Configure Torque for Struts
Posted by Brian Adams <bi...@satx.rr.com>.
Hey Jack, I am not sure what you mean. I am using Torque with Struts and I
use a bean class that contains my Business Logic it makes calls to the
Object Model classes. I keep the entire Torque package in another area and
when I gen the OM Classes for my project it creates them in my project area.
Does that make sense?
Brian
-----Original Message-----
From: Jian Dai [mailto:jack2110@comcast.net]
Sent: Monday, August 04, 2003 7:54 PM
To: Apache Torque Users List
Subject: Configure Torque for Struts
Hi, all:
I am planning to use Torque as data module in
Struts architecture. Is there anybody who knows
how to configure torque for struts?
Many thanks for the nice help.
Jack
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Configure Torque for Struts
Posted by Jian Dai <ja...@comcast.net>.
Hi, all:
I am planning to use Torque as data module in
Struts architecture. Is there anybody who knows
how to configure torque for struts?
Many thanks for the nice help.
Jack
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Toruqe supports BLOB ????
Posted by "Henning P. Schmiedehausen" <hp...@intermeta.de>.
Bill Leng <wl...@metatomix.com> writes:
>Add to Geoff's comment. It is confirmed that it works with datadirect's
>jdbc driver for Oracle. Oracle's thin jdbc driver does not work.
BLOBs work fine in PostgreSQL and MySQL. CLOBs work fine in
PostgreSQL.
Regards
Henning
--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen INTERMETA GmbH
hps@intermeta.de +49 9131 50 654 0 http://www.intermeta.de/
Java, perl, Solaris, Linux, xSP Consulting, Web Services
freelance consultant -- Jakarta Turbine Development -- hero for hire
"You are being far too rational for this discussion."
--- Scott Robert Ladd in <3F...@coyotegulch.com>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Toruqe supports BLOB ????
Posted by Bill Leng <wl...@metatomix.com>.
Add to Geoff's comment. It is confirmed that it works with datadirect's
jdbc driver for Oracle. Oracle's thin jdbc driver does not work.
Geoff Fortytwo wrote:
> If you're using oracle than it isn't possible to use blobs with torque.
> (except possibly if you use a driver that's not from Oracle. but that
> isn't confirmed)
>
> At 10:40 AM 8/4/2003, you wrote:
>
>> Dear List and Torque Developers,
>>
>> Not much activity on this list is there?? :)
>>
>> The http://db.apache.org/torque/dtd/database_3_1.dtd indicates that BLOB
>> are a valid torque data type.
>>
>> It possible to save an image to a blob with the current version ? Could
>> someone give a small example. We have done this using BC4J and with
>> JDBC on
>> its own, does the current version of torque help me?
>>
>> Kind regards,
>>
>>
>> Ben bookey.
>>
>>
>> ----- Original Message -----
>> From: "Michel Beijlevelt / Lucka" <mb...@lucka.nl>
>> To: "Apache Torque Users List" <to...@db.apache.org>
>> Sent: Monday, August 04, 2003 2:42 PM
>> Subject: Re: different internal variable names
>>
>>
>> > Howdy,
>> >
>> > the opinion about tight or loose coupling is also influenced by the
>> > frequency of changes in the RDBMS schema.
>> >
>> > If my application is - through Torque - tightly coupled with the RDBMS,
>> > it will almost certainly fail with an exception upon a moderately
>> > significant change in the RDBMS. Which is good, because it will
>> > precisely pinpoint the change, and makes 'sure' (well, fairly sure that
>> > is :-) that my appliction only runs against the RDBMS that is was
>> > designed for and none other.
>> >
>> > But I agree, having the possibility of making Torque more loosely
>> > coupled from the RDBMS would be a nice feature. It could be implemented
>> > by allowing specifying aliases for db objects in the XML schema
>> > definition which does seem to be fairly simple to implement, but
>> maybe a
>> > more sophisticated abstraction layer isn't that hard to make either.
>> >
>> > gr. Michel
>> >
>> >
>> > Manske, Michael wrote:
>> >
>> > >hi,
>> > >
>> > >i knew that such a discussion would come up and it depends on the
>> point
>> of
>> > >view of each indivual user. :)
>> > >
>> > >
>> > >
>> > >>I don't know, I think I would Torque rather see more tightly coupled
>> > >>with the RDBMS and dump the XML schema entirely.
>> > >>
>> > >>
>> > >if you have control over database structure and changes of the
>> database
>> > >structure, then you will
>> > >perhaps prefer a strict coupling. But if not (like me), you will
>> always
>> > >prefer loose coupling to be more independent of changes made by
>> another
>> dev
>> > >team.
>> > >
>> > >
>> > >
>> > >>My RDBMS already has a schema, which would be the metadatabase in the
>> > >>systems tables. So why create another definition in XML of the same
>> > >>database and tables?
>> > >>
>> > >>
>> > >If you have to support different RDBMS the metadescription in some
>> "system
>> > >tables" will get useless.
>> > >
>> > >
>> > >
>> > >>Torque's capability of abstraction of the RDBMS-specific
>> > >>isssues comes
>> > >>in quite handy here. The process could be automated by having Torque
>> > >>generate the XML definition from a JDBC conncection, and then
>> > >>generate
>> > >>the om from that XML, but I haven't tried that yet.
>> > >>
>> > >>
>> > >Thats what i'm talking about, we are working with torque this way
>> because
>> we
>> > >have to deal
>> > >with a couple of already existing databases.
>> > >And yes, torques abstraction is somewhat of handy - thats why we
>> use it.
>> :-)
>> > >
>> > >Loose coupling means among other things to hide the physical database
>> > >structure completely from the objects, which have to access the
>> database.
>> A
>> > >layer (like torque) will then act as mediator between objects and
>> database.
>> > >So if you would have problematic identifiers like "short", you
>> would be
>> > >easily able to map them to another name, which could then be used
>> in java
>> > >objects, e.g. map "short" to "short_descr".
>> > >There is already some kind of support for this but at the moment it
>> isn't
>> > >suitable at all.
>> > >
>> > >I guess torque is so popular because of his abilities to generate
>> more or
>> > >less useable code and the usage of a xml schema at runtime
>> (respectively
>> at
>> > >application startup) would possibly be contradictory to the
>> generator BUT
>> it
>> > >would also provide more independency from used database structure.
>> > >
>> > >I'm not sure wheter this is a mainly intention of torque but i
>> would be
>> glad
>> > >if the devs would expand
>> > >support for loose coupling (at least for mapping of table/column
>> names to
>> > >java names) in future versions...
>> > >
>> > >regards,
>> > >Michael
>> > >
>> > >PS: pros and cons of loose coupling will always be a matter of opinion
>> > >
>> >
>> >
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> > For additional commands, e-mail: torque-user-help@db.apache.org
>> >
>> >
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
--
Bill Leng
Metatomix, Inc.
Tel: (901)261-8911
Fax: (901)261-8901
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Toruqe supports BLOB ????
Posted by Geoff Fortytwo <g4...@ign.com>.
If you're using oracle than it isn't possible to use blobs with torque.
(except possibly if you use a driver that's not from Oracle. but that isn't
confirmed)
At 10:40 AM 8/4/2003, you wrote:
>Dear List and Torque Developers,
>
>Not much activity on this list is there?? :)
>
>The http://db.apache.org/torque/dtd/database_3_1.dtd indicates that BLOB
>are a valid torque data type.
>
>It possible to save an image to a blob with the current version ? Could
>someone give a small example. We have done this using BC4J and with JDBC on
>its own, does the current version of torque help me?
>
>Kind regards,
>
>
>Ben bookey.
>
>
>----- Original Message -----
>From: "Michel Beijlevelt / Lucka" <mb...@lucka.nl>
>To: "Apache Torque Users List" <to...@db.apache.org>
>Sent: Monday, August 04, 2003 2:42 PM
>Subject: Re: different internal variable names
>
>
> > Howdy,
> >
> > the opinion about tight or loose coupling is also influenced by the
> > frequency of changes in the RDBMS schema.
> >
> > If my application is - through Torque - tightly coupled with the RDBMS,
> > it will almost certainly fail with an exception upon a moderately
> > significant change in the RDBMS. Which is good, because it will
> > precisely pinpoint the change, and makes 'sure' (well, fairly sure that
> > is :-) that my appliction only runs against the RDBMS that is was
> > designed for and none other.
> >
> > But I agree, having the possibility of making Torque more loosely
> > coupled from the RDBMS would be a nice feature. It could be implemented
> > by allowing specifying aliases for db objects in the XML schema
> > definition which does seem to be fairly simple to implement, but maybe a
> > more sophisticated abstraction layer isn't that hard to make either.
> >
> > gr. Michel
> >
> >
> > Manske, Michael wrote:
> >
> > >hi,
> > >
> > >i knew that such a discussion would come up and it depends on the point
>of
> > >view of each indivual user. :)
> > >
> > >
> > >
> > >>I don't know, I think I would Torque rather see more tightly coupled
> > >>with the RDBMS and dump the XML schema entirely.
> > >>
> > >>
> > >if you have control over database structure and changes of the database
> > >structure, then you will
> > >perhaps prefer a strict coupling. But if not (like me), you will always
> > >prefer loose coupling to be more independent of changes made by another
>dev
> > >team.
> > >
> > >
> > >
> > >>My RDBMS already has a schema, which would be the metadatabase in the
> > >>systems tables. So why create another definition in XML of the same
> > >>database and tables?
> > >>
> > >>
> > >If you have to support different RDBMS the metadescription in some
>"system
> > >tables" will get useless.
> > >
> > >
> > >
> > >>Torque's capability of abstraction of the RDBMS-specific
> > >>isssues comes
> > >>in quite handy here. The process could be automated by having Torque
> > >>generate the XML definition from a JDBC conncection, and then
> > >>generate
> > >>the om from that XML, but I haven't tried that yet.
> > >>
> > >>
> > >Thats what i'm talking about, we are working with torque this way because
>we
> > >have to deal
> > >with a couple of already existing databases.
> > >And yes, torques abstraction is somewhat of handy - thats why we use it.
>:-)
> > >
> > >Loose coupling means among other things to hide the physical database
> > >structure completely from the objects, which have to access the database.
>A
> > >layer (like torque) will then act as mediator between objects and
>database.
> > >So if you would have problematic identifiers like "short", you would be
> > >easily able to map them to another name, which could then be used in java
> > >objects, e.g. map "short" to "short_descr".
> > >There is already some kind of support for this but at the moment it isn't
> > >suitable at all.
> > >
> > >I guess torque is so popular because of his abilities to generate more or
> > >less useable code and the usage of a xml schema at runtime (respectively
>at
> > >application startup) would possibly be contradictory to the generator BUT
>it
> > >would also provide more independency from used database structure.
> > >
> > >I'm not sure wheter this is a mainly intention of torque but i would be
>glad
> > >if the devs would expand
> > >support for loose coupling (at least for mapping of table/column names to
> > >java names) in future versions...
> > >
> > >regards,
> > >Michael
> > >
> > >PS: pros and cons of loose coupling will always be a matter of opinion
> > >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> >
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org