Hi all,

 

Consider the following:-

 

create table person (

  id varchar(20) not null,

  name varchar(100) not null

);

 

create table car (

  id varchar(20) not null,

  person_id varchar(20) not null,

  model varchar(100) not null,

  plat_no varchar(100) not null

);

 

Then, use JDBC to execute the following Select query:-

 

select

p.name,

c.model,

c.plat_no

from person p

left join car c on (p.id = c.person_id);

 

 

From the ResultSet, get the ResultSetMetaData and inspect each column’s isNullable() value, which is always = 1 (always nullable).  It returns correct nullable meta value if no left join is in used.  I suspect this should be a bug?

 

Thanks.

 

Best Regards,

 

Chua Chee Seng

Java Architect

Sun Certified Enterprise Architect for JEE 5 cum ACE for Flex 3 with AIR

Research & Development Devision

M: +60 12 3840727

 

KZEN Solutions Bhd

Suite B-07-07 & B-07-08,

7th Floor, Block B,

Plaza Mont’ Kiara,

No. 2, Jalan Kiara,

50480 Kuala Lumpur,

Malaysia

T: +603 6201 0242

F: +603 6203 5037

W: www.kzensolutions.com

E: cheeseng@kzensolutions.com