Simple distrinct query

marcelk · **Joined:** Thu Aug 07, 2008 3:41 pm **Posts:** 14

I want to do this SQL:

Code:

"select distinct id, firstname, lastname, birthdate from clients"

So I made this up:

Code:

"select distinct id, firstname, lastname, birthdate from Client"

but I get this:

Quote:

java.lang.NumberFormatException: For input string: "firstname"

What am I doing wrong?

dziebol · **Joined:** Tue Sep 27, 2005 2:51 pm **Posts:** 27

marcelk wrote:

I want to do this SQL:

Code:

"select distinct id, firstname, lastname, birthdate from clients"

So I made this up:

Code:

"select distinct id, firstname, lastname, birthdate from Client"

but I get this:

Quote:

java.lang.NumberFormatException: For input string: "firstname"

What am I doing wrong?

try

Code:

Select distinct(id), firstname, lastname, birthdate from Client

Dave

marcelk · **Joined:** Thu Aug 07, 2008 3:41 pm **Posts:** 14

dziebol wrote:

marcelk wrote:

I want to do this SQL:
try

Code:

Select distinct(id), firstname, lastname, birthdate from Client

Dave

That didnt help, same error. Does anyone have an example for me?

dziebol · **Joined:** Tue Sep 27, 2005 2:51 pm **Posts:** 27

marcelk wrote:

dziebol wrote:

marcelk wrote:

I want to do this SQL:
try

Code:

Select distinct(id), firstname, lastname, birthdate from Client

Dave

That didnt help, same error. Does anyone have an example for me?

It would be much easier to aid you if you posted the table format along with the database name being used.

Dave

marcelk · **Joined:** Thu Aug 07, 2008 3:41 pm **Posts:** 14

Table name is CLIENTS

Layout:
ID Number (PRIMARY KEY)
FIRSTNAME Varchar2
LASTNAME Varchar2 64
BIRTHDATE Date 7
CYCLUS_ID Number (FOREIGN KEY AND PART OF PRIMARY KEY)

What I want is to show all clients, not I have duplicates because of the Foreign Key values in Cyclus ID.

nordborg · **Posted:** Tue Aug 12, 2008 4:36 pm

How about?

Code:

select distinct c.id, c.firstname, c.lastname, c.birthdate from Client c

marcelk · **Joined:** Thu Aug 07, 2008 3:41 pm **Posts:** 14

nordborg wrote:

How about?

Code:

select distinct c.id, c.firstname, c.lastname, c.birthdate from Client c

Also tried that, I still get:

Code:

java.lang.NumberFormatException: For input string: "firstname"

Jeeten Potabathni · **Joined:** Thu Jul 17, 2008 2:35 am **Posts:** 5

Hi marcelk

This query is working perfectly fine

Code:

select distinct mod.ID , mod.FIRSTNAME from CLIENTS as mod

This doesn't work at your side then it means you must have not properly mapped the table with class

As you said it is showing

Code:

java.lang.NumberFormatException: For input string: "firstname"

This means
in Database table, the type of firstname is of varchar
and in class the datatype if firstname might be int or long

Just check it out

Hope this helped you

Thank you[/code]

marcelk · **Joined:** Thu Aug 07, 2008 3:41 pm **Posts:** 14

Thanks but, thats not the case.

The problem is that without distinct, it works (FROM Clients).

Why do i get strange results when using distinct?

nordborg · **Posted:** Wed Aug 13, 2008 5:19 am

What is the rest of the stacktrace? Does this happen before or after the query has been executed on the database?