db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Luca Ciocci <l.cio...@askweb.it>
Subject Re: Error on order by (Criteria.addAscendingOrderByColumn)
Date Mon, 25 Sep 2006 10:58:47 GMT
This was a very simple problem to resolve but I was looking in the wrong
place (i was looking for a bug, but It's not and was my fault)!!! I
started a project with torque 3.1 then upgrade to torque 3.2 and I
didn't rebuilt the project-schema.xml. I was very stupid and did not
validate xml schema, so i miss to write the name attribute in database
node.


With torque 3.1 the schema was:

<database defaultIdMethod="idbroker" >
    <table name="mytable">
        <column name="myid" primaryKey="true" required="true"
type="INTEGER"/>
        <column name="myname" size="255" type="VARCHAR"/>
   ......
   .....

With torque 3.2 the name attribute is mandatory so the schema is:

<database defaultIdMethod="idbroker" name="mydatabasename" >
    <table name="mytable">
        <column name="myid" primaryKey="true" required="true"
type="INTEGER"/>
        <column name="myname" size="255" type="VARCHAR"/>
   ......
   .....

If you miss the attribute name in all the TableMap file autogenerated by
Torque the database name is "default" and seem to works great except
order by method of Criteria object.

The problem is solved!

Bye!


Il giorno gio, 14/09/2006 alle 17.29 +0200, Luca Ciocci ha scritto:
> Hello,
> I use Torque 3.2 in a large web project (I'm not new to Torque 3.x), and
> I have some trouble ordering result with addAscendingOrderByColumn (or
> addDescendingOrderByColumn) of Criteria object. I've got an exception
> like this:
> 
> java.lang.NullPointerException
> 	at org.apache.torque.util.SQLBuilder.processOrderBy(SQLBuilder.java:506)
> 	at org.apache.torque.util.SQLBuilder.buildQueryClause(SQLBuilder.java:314)
> 	at org.apache.torque.util.BasePeer.createQuery(BasePeer.java:676)
> 	at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:725)
> 	...
> 
> This error happens ONLY when in order by method put a varchar column, if
> I use (for example) a integer it works perfectly.
> 
> My project use Tomcat 5.5.9 + MySQL 4.1 and JDBC MySQL Connector3.0.16
> (I've tried also the newer version, but the problem persists).
> 
> Can anyone help me?
> 
> Thanks, Luca.
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
-- 
ASK Web Division
Ing. Luca Ciocci
mailto: l.ciocci@askweb.it
Tel. +39 059 271417


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message