Hi,
its just as it says: some datasets do not support DISTINCT with some
datatypes. No problem of Torque, but of the database.
I got no clean solution, only if your content is short enough then you can
use VARCHAR instead of whatever datatype you use and it should work then.
Thomas
Primary keys of concerned tables are not text, ntext or image as the Exception
message says...
It's just INTEGERS !
I've avoided the problem with a really bad solution in order to give me more
time to find a good one : deleting doubled item in my result list ...
Frederic.
-Message
Hi Frederic,
It is not the primary keys of the table, it is all columns of the table
that are compared by a DISTINCT. So if any column is a text, ntext or
image, you have a problem.
Just to make sure it is not a JDBC problem: did you try to execute the SQL
statement in a console ? If yes,
Hi Thomas, and thanks for your answer.
First, in my console, the following statement is succesful :
SELECT
DISTINCT (SALARIE.CD) FROM TURBINE_ROLE, SALARIE, TURBINE_USER_GROUP_ROLE WHERE
TURBINE_ROLE.ROLE_NAME NOT IN ('Correspondant') AND SALARIE.
USER_ID=TURBINE_USER_GROUP_ROLE.USER_ID AND
Hi Frederic,
I am 99% sure that the distinct in the statement is not for a single column
in a table, but for the whole bunch of columns where you select from.
Therefore your criteria might not do what you want.
You can also compare the error messages in the console to the torque error
I downloaded Torque 3.1 for Java and successfully generated the classes
(Ant) I require. The issue I'm having
is not being able to find the downloadable source that contains the classes
that are causing errors in WSAD.
Some are:
org.apache.log.Hierarchy
org.apache.jcs.JCS
Take a look at the dependency page for Torque.
http://db.apache.org/torque/dependencies.html
Links are provided to each of the projects that Torque is dependant on.
This course of action is only needed when building Torque with Ant, as
Maven automatically downloads these jars for you.
[EMAIL