db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jürgen Hoffmann ...@byteaction.de>
Subject AW: Torque Problem
Date Mon, 31 Mar 2003 07:39:49 GMT
Hi Donald,
 
I am using eclipse 2.1 as my ide and use jpda to step trace any bugs in
my webapps with torque/turbine. First thing. If I am creating a complex
query that uses joins or distincts, criteria is very error prone. 
In these cases I am using Torques Ability to use "self-written" sql.
This is done by using the following syntax.
 
BasePeer.executeQuery(<sql>);
http://db.apache.org/torque/apidocs/org/apache/torque/util/BasePeer.html
#executeQuery(java.lang.String)
 
This returns you a List with com.workingdogs.village.Record Objects,
which you can then map to your objects using:
 
YourGeneratedPeerClass.populateObjects(ListOfVillageRecords)
 
Please remember that this mapping only works if you have all necessary
columns in your SELECT Statement and they are in the correct order.
 
Otherwise you can iterate over the Record Objects using:
 
 
for (Iterator iter = RecordList.iterator(); iter.hasNext();)
{
    Record element = (Record)iter.next();
    int column = 1;
    String firstName = element.getValue(column).asString(); // only as
an example
    int column = 2;
    String lastName = element.getValue(column).asString(); // only as an
example
    .
    .
    .
}
 
HTH 
 
 

Kind regards


Jürgen Hoffmann
ByteACTION GmbH

cert. Perl Programmer
cert. Linux System Administrator
cert. Java Programmer



-----Ursprüngliche Nachricht-----
Von: Donald Rosengartner [mailto:DROSENGARTNER@kc.rr.com] 
Gesendet: Sonntag, 30. März 2003 06:55
An: jh@byteaction.de
Betreff: Torque Problem


First, your English is very good. Did you study in America previously? I
lived in Tuebingen, Germany in 1992-3 while My ex-wife studied there. I
wish my German was half what your english appears to be. Anyway, please
consider the following question. I've seen many postings on the torque
newslist for this problem, but nothing that resembles a solution. After
seeing your posting dated 2-15-03, I believe you might have enough
expertise to handle this.. if you're willing.
 
Database is MySql. Torque vs. torque-3.0-rc2
My tables are CUSTOMER, LOCATION, CATEGORY.
My criteria object is being built like this:
 
locationCrit.add(LocationPeer.FK_STATE, stateCode);
locationCrit.add(CategoryMinorPeer.CATEGORY_NAME,(Object)(CategoryMinorP
eer.CATEGORY_NAME + " LIKE '" + minorCategory + "'"),Criteria.CUSTOM);
locationCrit.addJoin(CategoryMinorPeer.FKCUSTOMER_ID,CustomerPeer.CUSTOM
ER_ID);
locationCrit.addJoin(LocationPeer.FKCUSTOMER_ID,CustomerPeer.CUSTOMER_ID
);
 
locationCrit.addOrderByColumn(CustomerPeer.CUSTOMER_NAME);
locationCrit.addGroupByColumn(CustomerPeer.PAID_AD);
locationCrit.setDistinct();
List marinas = (List) CustomerPeer.doSelect(companyCrit);
 
***************
Problem(1): if OrderBy,GroupBy are used together the whole thing fails;
The database is never hit, and the sql does not get written to the
Tomcat console. As a workaround, I'm considering a
Collections.sort(listname) with no luck so far. Have you attempted
anything like this? I believe the Customer object is mapped somehow to
the two joined tables allowing the customer.getCategory() method. Is
this perhaps interferring with the sort of Customer?
 
(2) On the distinct portion, the sql is being created as if intended:
select distinct(col1,col2,col3,col4,col5,...) from ...
instead of:
select distinct(col1) col2, col3, col4 ... from ...
 
(3) What are the import statements on your extended BasePeer that
enables logging for your debugging? Or is this capability enabled
through some properties setting in your torque setup?
 
Do you have an IDE for step tracing your code? My brother is a linux
administrator and recommended Eclipse from IBM. I'm using Win2K and had
problems running both Sun1 and  JBuilder. I installed Eclipse, but still
getting familiar with it. Only thing I can say is that it's super fast
compared to Sun/JB. Thanks in advance for considering my issues with
torque.
 
God Bless,
Don Rosengartner


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message