Hi All
 
I'm trying the below query which seems to always execute fine while in the SAP SQL studio.
 
SELECT fg.faq_group_description, 
  fq.question,  
  fq.faq_question_number
FROM faq_group fg,  
  faq_question fq  
WHERE fq.faq_group_number (+) = fg.faq_group_number
AND     fg.faq_group_number = 305
 
However the problem comes in, in my Java program (which uses the latest JDBC driver to connect), under a condition that there are no questions for the FAQ Group
 
(i.e. some example of a result is shown below when this happens)
 
(varchar)    (Long)    (Integer)
ABC        ?            ?
 
If there is a null in a "Long" field (field of unlimited acsii values), then the JDBCDriver seems to throw some kind of NullPointer exception because its created a java.io.Reader to read something thats not there!!  This seems to be a bug in the driver.  I can catch the Exception and assume the data is null, but it seems strange it only happens on Longs. 
 
I was wondering if anyone has heard of this bug and knows when/if it might be fixed?
 
Kind Regards
Bruce
 
 
 
 

Reply via email to