assuming COL2 is numeric:
ORDER BY COL1, coalesce (COL2,0)
which translates to
criteria.addAscendingOrderByColumn(COL1);
criteria.addAscendingOrderByColumn("coalesce (COL2,0)");
I can't remember whether I had to patch Torque to accept the above
character string.
"Garret O'Kelly" <[EMAIL P
barak wrote:
Hi all,
Is there a way to configure torque so the method "retrieveByPK" in the
peers will return null instead of an exception if no row matched the
primary key?
Why don't you write your own retrieveByPK method in the class that
extends the peer class?
Unfortunately, the peer cl
Matthias Klein wrote:
How can I implement something like ON DELETE CASCADE with Torque?
Like: let's say table BOOK references table AUTHOR through a relation WROTE.
Now let's say I have BOOK_ID 1 and AUTHOR_ID 1 and AUTHOR_ID 2 (because the
book was written by 2 authors).
Then I have the followi
Andras Balogh wrote:
I think you can use it like this:
criteria.add(TransaktionPeer.METHOD, (Object) "T.METHOD =
TRANSAKTION.METHOD",Criteria.CUSTOM);
Thank you, this works!
Another question: I have built part of my WHERE Criteria elsewhere in
the program and am just passing on the Criteria objec
x27;t quite understand how to use it.
I think this case:
WHERE TABLE_1.COL_A = TABLE_2.COL_B
can be handled by:
crit.addJoin(Table1Peer.ColA,Table2Peer.ColB)
or this is not the join condition between the tables?
Also you may try to use Criteria.CUSTOM for the first case or maybe i
misunderstood
Hello,
I have been using Torque for quite some time now and am probably
overlooking something:
I would like to produce something like:
WHERE TABLE_1.COL_A = TABLE_1.COL_B
or
WHERE TABLE_1.COL_A = TABLE_2.COL_B
(in a multi-table join)
But as far as I can see all Criteria.and(...) methods just take
Kintzel Levente wrote:
This is important for a multilanguage application. Example: For a
"link" on a linkpage I have a description in more than one language
and the url. I want to store the description in several languages in
such a way to be easy to maintain. Some design patterns for this
Hello Alex,
Alex Hepp wrote:
thanks all,
but that can become a quite difficult thing, when i want to produce an
efficient and correct statement...
is the following example statement possible with torque then? :
Yes, both examples are possible to configure with Torque. Just as you
did it using Cr
Hallo Alex,
Alex Hepp wrote:
what i want now is this:
SELECT * FROM movii_user where (FIRST_NAME LIKE "%hello%" or LAST_NAME
LIKE "%hello%" OR EMAIL LIKE "%hello%" or LOGIN_NAME="%hello%") AND
IS_DELETED=0;
**CODE
Criteria crit = new Criteria();
Hi Sarav,
Saravana Krishnan wrote:
My other doubt is, if it's a 1:1 relation between 2 tables, why not
simply merge them? What's the point in having 2 tables with 1:1
relations.
I can think of two examples:
1) You might have two entities that require address data. You don't want
to dupicate the ad
Hello Thomas,
Thomas Fischer wrote:
However, I would _NOT_ use reserved words as table or column names if I
were you. I would be surprised if the sql scripts are the only difficulty
you run into. For example, my guess is that you cannot do selects on tables
which names are reserved words.
You can,
Richard Bayet wrote:
Richard Bayet wrote:
But I might be wrong, I know I had to extend the Criteria class to
code a "not in" operator. I got the idea from either the dev or user
mailing-list.
I'm a bit puzzled, Richard: there is a Criteria.addNotIn(...) method.
Here it is.
http://nagoya.apache.or
Matt Hughes wrote:
Alik Kurdjukov wrote:
I found that autoincrement flag on the column is ignored in PostgreSQL
backend.
While it doesn't use SERIAL, it has the same effect. The idMethod has to
be set to native for this to work (I believe).
Yes, I am using defaultIdMethod="native"
--
Regards/
Hello Alik,
Alik Kurdjukov wrote:
I found that autoincrement flag on the column is ignored in PostgreSQL
backend. So I created a patch. Here's new columns.vm I created for
PostgreSQL.
I don't understand that. I've been using Torque 3.1 with PostgreSQL and
autoincrement for months - it works fine
Hello Eduardo,
From the torque.jar file, it's possible to see that the generator uses
vm files to create the external documents. What exact format are those
vm files in? Is there any documentation on how I can extend, or create a
new vm file?
They are Velocity files (http://jakarta.apache.org/veloc
Hello,
Leandro lira wrote:
I would like to know if there are some free software that generate the visual entity-relatioships diagrams (or UML diagrams) from the XML database schema defined by US for torque.
http://druid.sourceforge.net/
--
Regards/Gruß,
Tarlika Elisabeth Schmitz
---
Hallo Henning,
Henning P. Schmiedehausen wrote:
Well, it might be a good idea to add a "lastState" property to the
generated peer classes...
What exactly do you mean by "lastState" property?
Do you mean a shadow object that allows youto fall back to the last
saved state?
Correct me if I am wrong
Hello Michael,
[EMAIL PROTECTED] wrote:
'm having a problem using Torque-generated classes within a transaction.
Now, if I'm running in a transaction and the transaction rolls back due to
some application exception, once the user resolves the problem and attempts
to re-insert the Person instance, i
using those values with the SharedPoolDataSourceFactory.
Perhaps your version of the dbcp is older than the one we are using and
doesn't support these settings? We are using commons-dbcp-1.2.1.jar -
perhaps you could get a newer one and see if that works.
Ian
On Sep 24, 2004, at 3:48 PM, T
Hello Ian,
Ian Ragsdale wrote:
We recently had a similar problem. Here's what we did, which appeared
to alleviate the problem without addressing the underlying connection leak:
# don't wait indefinitely for a connection
torque.dsfactory.scimitar.pool.maxWait = 5000
# allow up to 25 connections i
Hello Martin,
[EMAIL PROTECTED] wrote:
I'm using the doSelectJoinXXX methods generated by Torque. However I need to use them
with a Connection object. To my surprise,
it seems that these variants of the methods do not exists Am I mistaken and there
is a way to make Torque generate them? Also,
Ben Bookey wrote:
Dear List,
This is outside of the torque realm, but it will take me too long
to write to another forum with the same level of database expertise.
Good idea. Better waste our time rather than yours.
--
Tarlika Elisabeth Schmitz
-
Hello,
I am using Torque 3.1 with PostgreSQL 7.4.
I noticed that the generated ORDER BY clause is always case insensitive.
Regardless of Criteria.setIgnoreCase(), for Strings the ORDER BY clause
always uses UPPER(). I had a look at
BasePeer.processOrderBy(), which always calls
db.ignoreCaseInOrd
Hello,
In PostGreSQL NULL values sort last. The following SQL statement will
sort them at the top:
SELECT * FROM ORDER BY IS NOT NULL, ORDER BY ASC
or alternatively
SELECT * FROM ORDER BY COALASCE(,0) ASC
In this example NULLs are mapped to zero, i.e. one would choose the
lowest possible value
Hello Artur,
Artur Z wrote:
Did you defined the foreign key relationship beetwen Author and
Book in your schema file?
If yes, there should be protected method in BaseAuthorPeer
doSelectJoinBooks() (or something like that). Write this method as
public in AuthorPeer
and than you can use it.
yes,
Hello Artur,
Artur Z wrote:
please help - I have a performance problem
the question is:
how to query author table to get in return list of authors with already
initialized books collections
You will indeed run into severe performance problems if you don't use
the doSelectJoinXXX methods, which re
Hello,
I searched the archive to find out whether there are any issues with
PostgreSQL BLOBs but most of the recent postings seem to be Oracle
specific; so excuse the rather unspecific question:
Does anybody have any experience with using Torque/PostgreSQL/BLOBs? I
need to store small jpg files
Hello,
I just noticed the inheritance element in the schema-reference. I
somehow failed to find more information on this feature; there are only
question marks instead of attribute descriptions. Could anyone give me a
brief explanation what this is about?
--
Best Regards/Gruß,
Tarlika Elisabeth
d, too, at the beginning, only I had missed the
runtime download. ;-)
--- T E Schmitz <[EMAIL PROTECTED]> wrote:
Hello Nate,
If you downloaded the generator torque-gen-3.1.zip (
as opposed to
torque-3.1.zip , which is the runtime), you will
find
build-torque.xml in \torque-3.1\src\gen
I'm pretty sure you downloaded only the runtime and not the generator -
see my previous posting. build-torque.xml is definitely in my
torque-gen-3.1.zip (created Sep 2003).
Nathaniel Reed wrote:
Unfortunately, there is nothing new here with respect
to the problem I have described. Section 1.1 o
Hello Nate,
If you downloaded the generator torque-gen-3.1.zip ( as opposed to
torque-3.1.zip , which is the runtime), you will find
build-torque.xml in \torque-3.1\src\generator, which is what you use for
building your app with Ant.
Regards,
Tarlika
Nathaniel Reed wrote:
I have tried both
Torque.shutdown();
try
{
Torque.init(config);
}
catch (Exception e)
{
...
}
Regards/Gruß,
Tarlika Elisabeth Schmitz
-Original Message-
From: T E Schmitz [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 11. August 2004 09:57
To: [EMAIL PROTECTED]
Subject: Re: Specify hostname upon DB conne
nged since the version I use and my
modifications to Torque.java are either not needed or not compatible
with the latest code, I am willing to send my Torque.java if you are
interested.
Guy
On Thu, 2004-08-05 at 11:07, T E Schmitz wrote:
Hello,
I would like to be able to specify the host (not just
dbn
Hello Guy,
Thank you for posting your solution,
I am using Torque 3.1 and I just had a look at Torque.java. I didn't
spot any re-entrancy problems there.
We really just need this feature during the test phase. I have only one
login at application start and from then on the application accesses the
Hello,
I would like to be able to specify the host (not just
dbname/user/pasword) in a login dialog. I can't see how that could be
done other than maybe via Torque.getConfiguration(), where I guess I'd
find the URL.
Any suggestions?
--
Regards/Gruß,
Tarlika Elisabeth Schmitz
---
Artur Z wrote:
Company company = new Company();
Address address = new Address();
company.setAddress(address);
company.save(conn); // I'd like that this saves also address but it does
not
//but the most important thing is that when I call:
address.save(conn);
//an exception will be thrown - before
Hello Artur,
Artur Z wrote:
I tried to use torque onDelete attribute on MSSQL but it did't wokred
db was throwing an exception about constraint violation
maybe I did something wrong
This sounds more like a problem with your schema.
What do you want to do onDelete? onDelete=none or onDelete=cascade?
Hello,
I forgot to mention:
T E Schmitz wrote:
b) I am using the LEFT/RIGHT/INNER Join patch by Thomas Fischer--
The use of OUTER JOINs required a change to row2Object(...). Previously,
it was not possible for the FK object to be null. But with OUTER JOINs
that has to be taken into
Hello Artur,
Artur Z wrote:
torque allows setting onDelete attribute in foreign keys relations
but does not generate any java code to perfrorm deleting (it delegates this to db)
That's correct: this setting simply generates the SQL which determenis
whether the DELETE [or UPDATE] are cascaded.
I d
Hello Artur,
Artur Z wrote:
the following command in MSSQL restores database from file:
RESTORE DATABASE database_name FROM DISK = 'backup.bak'
but when i invoke it as query using torque server says that operation can not be
performed because I'm logged in
it means that I will never be able to do
Hello Artur,
Scott Eade wrote:
Artur Z wrote:
sorry for topic but I simply need to know some opinions:
lately I've started using torque and it works fine
has anybody any expirence/knowledge about these two tools to compare
them ?
hibernate looks "more alive and supported"
"which is better???"
Sea
Hello Guy
Guy Galil wrote:
I tried appending 'useSSL=true' to the database url in Torque.properties -
torque.dsfactory.default.connection.url =
jdbc:mysql://localhost:3306/TURBINE?useSSL=true
but it was ignored.
I don't think that this is a Torque problem. Coincidentally, I have just
set up a sec
Hello,
I am not quite sure why criteria / doSelect should return a result while
criteria / doDolete doesn't for the same values.
But bear in mind that for doDelete and doUpdate "no hits" is not an
error. Therefore no exception is thrown. In fact, you don't get any
feedback at all. This in itsel
Hello Guillaume,
Lederrey Guillaume wrote:
Further to our discussion about a Torque/Swing framework I happened upon
an article about building GUIs from BusinessObjects:
http://www.javaworld.com/javaworld/jw-01-2004/jw-0102-toolbox_p.html
You got my head buzzing all weekend. Yes, you are absolutely
Hello Guillaume and Gerhard,
Further to our discussion about a Torque/Swing framework I happened upon
an article about building GUIs from BusinessObjects:
http://www.javaworld.com/javaworld/jw-01-2004/jw-0102-toolbox_p.html
It addresses the problems which the getter and setter method approach
p
Hello Guillaume and Gerhard,
Gerhard Otte wrote:
From your question i think yor are looking for something like those
data bound controls in the Windows/Visual Basic/etc. world, where
every keystroke is reflected from the control to a table column in the
database.
One thing i learned from using torq
Hello Guillaume ,
-BEGIN PGP SIGNED MESSAGE-
I have found Torque recently, and it is really helpfull to handle my
databases connections ! I am developping a database oriented application in
Java/Swing. What I am missing is a simple way to connect my Torque objects to
my Swing forms.
For starters, look at Velocity.log for clues.
Regards,
Tarlika Elisabeth Schmitz
Cameron Hickey wrote:
file from an existing database I need to use, I tried using the main ant
task to generate the OM classes. Everything actually worked until I
compiled the project and discovered that the Base clas
Not via any of the built-in options. But it is easy enough to patch the
Velocity templates: you could filter out the tables you want to generate
sources for in the templates\om\Control.vm file.
Regards,
Tarlika Elisabeth Schmitz
[EMAIL PROTECTED] wrote:
Hi-
Is it possible to limit the tables whi
Hello,
This is potentially a daft question, so feel free to shoot me down in
flames ;-)
I noticed the alias attribute for the table element. I applied it to one
of my tables but for the life of me I can't figure out what it does. Can
anyone explain?
--
Regards,
Tarlika Elisabeth Schmitz
---
Hi Sergi,
In all likelihood all that you'll need to do to get the generation
working is modify the templates. I had to do this for Postgresql and it
really isn't difficult. The Velocity templates (.vm files) are easy
enough to read (if need be have a look at
http://jakarta.apache.org/velocity)
Try DbVisualizer (free version) www.minq.se/products/dbvis/index.html.
It does not give you a graphical representation from the xml schema but
once the DB tables are created you can use it to "explore" the database,
visualize relationships and run SQL commands.
Regards,
Tarlika Elisabeth Schmit
It is also possible to control Torque's log4j output via your
application's log4j.properties file. I have set up log4j logging for my
application and in my properties file I set the categories:
#category settings
log4j.category.util=WARN
log4j.category.org.apache=WARN
log4j.category.org.apache.t
d pretty well.
David
-Original Message-----
From: T E Schmitz <[EMAIL PROTECTED]>
To: Apache Torque Users List <[EMAIL PROTECTED]>
Date: Sun, 02 May 2004 17:43:21 +0100
Subject: left outer join
I have 3 tables SECTION and BRAND and MODEL. SECTION is related to
BRAND and to MODEL via t
Hello,
I just hit upon a problem with Postgresql columns of type bool.
Torque generates invalid SQL for bool comparisons:
generates : WHERE xyz=0
needs to be : WHERE xyz=FALSE (or WHERE xyz='0')
The fault is in the adapter. I amended the adapter as follows and it
works fine now:
public String
_NAME.substring(Brand.BRAND_NAME.indexOf("."));
Regards,
Kostya
T E Schmitz wrote:
Hello,
I have a table which references the same table twice. In SQL, I would
express the SELECT (inner join) using an alias :
SELECT
SECTION.SECTION_PK,
SECTION.SECTION_NAME,
SECTION.BRAND_1_FK,
SECTION.BRAND_2_FK,
b
Have you set your schema to use defaultJavaType="object" ?
Do you use Integer objects or int? If you use int your FK will assume an
integer value the default value being 0 (zero). Only if you use objects
as opposed to primitive values will you be able to set any column to null.
As the DB can di
Hello,
I have a table which references the same table twice. In SQL, I would
express the SELECT (inner join) using an alias :
SELECT
SECTION.SECTION_PK,
SECTION.SECTION_NAME,
SECTION.BRAND_1_FK,
SECTION.BRAND_2_FK,
b1.BRAND_PK,
b1.BRAND_NAME,
b2.BRAND_PK,
b2.BRAND_NAME
FROM SECTION, BRAND as b1
f you dont read till
the last line.
-Original Message-----
From: T E Schmitz <[EMAIL PROTECTED]>
To: Apache Torque Users List <[EMAIL PROTECTED]>
Date: Sun, 02 May 2004 17:43:21 +0100
Subject: left outer join
Hello,
I have 3 tables SECTION and BRAND and MODEL. SECTION is related
Hello,
I have 3 tables SECTION and BRAND and MODEL. SECTION is related to BRAND
and to MODEL via two foreign keys. I would like to select ALL SECTIONs
whether the FKs are null or not and fetch the BRAND and MODEL attributes
in one SQL statement. In other words I need a double outer join:
SELEC
,
Tarlika Elisabeth Schmitz
Dave Newton wrote:
On Fri, 2004-04-23 at 11:22, T E Schmitz wrote:
Is there any means of doing a SELECT for UPDATE, ie to lock a record in
a transaction?
Can you just do the entire operation in a transaction using the Torque
transaction methods?
http://db.apache.org
Hello,
Is there any means of doing a SELECT for UPDATE, ie to lock a record in
a transaction?
I mark every record with a 'LastUpdated' timestamp in order to be able
to check whether it has been updated in the meantime in another session.
Before any UPDATE or DELETE I re-read the record and com
Thank you for your ideas, Brent. I saved it away for the next project.
Regards,
Tarlika Elisabeth Schmitz
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Print Torque's build.xml off and have a good read. Things became much
clearer fo me then. The create-db target drops all tables and creates a
new empty db.
You will also find the "jdbc" target, which generates an xml schema from
your existing db.
Regards,
Tarlika Elisabeth Schmitz
Grey.Lee w
Beware, there are a couple of other things you might have to change. Off
the top of my head a couple of points:
1) I had to make a couple of minor changes to the PostgreSQL SQL
generating templates.
2) I am using the latest versions of commons-dbcp-1.1.jar and
commons-pool-1.1.jar rather than
Hello Lee,
Grey.Lee wrote:
The thing I'm finding puzzling is, given how long since a new release,
why don't the docs match the download? The tutorial refers to
build-torque.xml, but I don't even have that file in the download. I
Did you download both torque-gen-3.1.zip and torque-3.1.zip? The
Hello,
Just to prevent other people from falling into the same trap, here's
what caused the TIMESTAMP comparison to fail:
When updating the record I had provided the setter method setTimestamp
in BaseXxx.java with a java.util.Date. This was with hindsight maybe
rather stupid but I did that beca
Hello Daniel, Thank you for your suggestion, this will do the trick for me.
Further to yesterday's posting, I would like to add some more details to
highlight the problem:
If the record was previously inserted via Torque, doDelete's TIMESTAMP
comparison will work and therefore delete the record. I
Hello,
I created a table with a required TIMESTAMP attribute.
I selected a perviously created record via torque, then attempted DELETE
with doDelete (obj).
doDelete does not delete the record as the following WHERE clause
returns no results:
whereClause=BRAND_NAME='Olympus' AND TIMESTAMP={ts '2
Hello,
I just went through the mailing list archive and there was an unresolved
thread back in February regarding the IDBroker warning.
"IDBroker is being used with db '', which does not support
transactions. IDBroker attempts to use transactions to limit the
possibility of duplicate key gene
Thank you Scott,
That's what I eventually figured ...
Regards,
Tarlika
Scott Eade wrote:
See http://jakarta.apache.org/commons/dbcp/configuration.html for
information about configuring Jakarta Commons DBCP.
Scott
-
To unsubsc
ive has been renamed:
defaultMaxActive ==> maxActive
I'm just guessing but in any case removing the above properties from
Torque.properties got rid of the errors.
Regards,
Tarlika Elisabeth Schmitz
T E Schmitz wrote:
Hello,
Torque.init causes the foll
Hello,
Torque.init causes the following errors:
ERROR [org.apache.torque.dsfactory.AbstractDataSourceFactory] -
(setProperty) Property: logInterval value: 0 is not supported by
DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource
ERROR [org.apache.torque.dsfactory.AbstractDataSo
I found the following error message in velocity.log:
[error] Error in evaluation of == expression. Both arguments must be of
the same Class. Currently left = class java.lang.Boolean, right = class
java.lang.String. om/MapBuilder.vm [line 28, column 28] (ASTEQNode)
I changed line 28 to test for a b
Hello,
The SQL generated for PostgreSQL using defaultIdMethod "native" causes a
problem with PostGreSQL 7.2.1 (Debian Linux):
For each autoIncrement primary key a CREATE SEQUENCE statement is
generated followed by the CREATE TABLE statement. The latter fails
because this version of PostgreSQL
75 matches
Mail list logo
