problem with column type numeric

Article View: borland.public.jbuilder.database

Article #326

Back to borland.public.jbuilder.database Previous Next

#326

From: apostolish
Date: Wed, 21 May 2008 08:38

14 lines
1492 bytes

Hello,
I'm using JBuilder X (JDK 1.4.2) and SQL Server 2005 (SP2). I connect to a 
database using JDBC Driver (sqljdbc.jar).
l execute for example a quey 'select * from table' and i have a column with 
type 'numeric' in the 'table'.
My problem it appears when in one or more rows , this column has the value 
<null> then  the execution of the query fails.
When there is none row which this column has value  <null> then i have no 
any problem.
I didn't have this problem when i was working with SQL Server 2000 and the 
jdbc driver for this.

Thanks in advance
Hatziyannis Apostolis

Technical Details

Message-ID: <4833df75@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.isoc.lu!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1073da,81a8992917456152,start
X-Google-Attributes: gid1073da,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "apostolish" <apostolish@gmail.gr>
Newsgroups: borland.public.jbuilder.database
Subject: problem with column type numeric
Date: Wed, 21 May 2008 11:38:56 +0300
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 193.92.253.233
Message-ID: <4833df75@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1211359093 193.92.253.233 (21 May 2008 01:38:13 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.isoc.lu!newsgroups.borland.com!not-for-mail