Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of manjula.kutty@gmail.com
 designates 64.233.184.199 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding;
        b=CI2qRavcdziP3S0Pj1turzgs9p3rx8vjOO7LPfM0z83L3thwXkBIiJCULZzCp4NS70UD2hhVvnZDiv4M69SSHY+LztNYVzMd4bQ8ny2EZjWtNeLtH85C6KuHd0+galQL/SBVwAUe6FCVuh48zkwy5htQaGw8as6uAwzYfyYk6A0=
Message-ID: <4405DD78.60705@gmail.com>
Date: Wed, 01 Mar 2006 09:44:24 -0800
From: Manjula G Kutty <manjula.kutty@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.7.5) Gecko/20041217
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: SQL Exception
References: <20060301052659.17875.qmail@web8412.mail.in.yahoo.com>
In-Reply-To: <20060301052659.17875.qmail@web8412.mail.in.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

meenakshi selvi wrote:

> hi all,
> i have created a table in derby as follow
>
> create table sp_ss_ex_contact(
> email       varchar(200)  primary key,
>    first_name  varchar(50) not null    ,
>    middle_name varchar(50)             ,
>    last_name   varchar(50) not null    ,
>    telephone   varchar(20 )            ,
>    address     varchar(250)            ,
>    state       char   (1  ) not null   ,
>    last_update timestamp not null
> );
>  
> if any of the rows in the columns middle name,telephone and address is 
> null,i t throws the following exception,
>
> SQL Exception: An attempt was made to get a data value of type 
> 'VARCHAR' from a
> data value of type 'null'.
>         at 
> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>         at 
> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>         at 
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source
> )
>         at 
> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown So
> urce)
>         at 
> org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown So
> urce)
>         at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(
> Unknown Source)
>         at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.setObject(Unknown S
> ource)
>  
>
> please help me.
>
> ------------------------------------------------------------------------
> Jiyo cricket on Yahoo! India cricket 
> <http://us.rd.yahoo.com/mail/in/mailcricket/*http://in.sports.yahoo.com/cricket/>
> Yahoo! Messenger Mobile 
> <http://us.rd.yahoo.com/mail/in/mailmobilemessenger/*http://in.mobile.yahoo.com/new/messenger/> 
> Stay in touch with your buddies all the time. 

Hi Meenakshi,
Did you get the exception through ij or through your application 
program? I tried with same schema as yours and everything went well. 
Here is what I did

ij> connect 'jdbc:derby:testdb;create=true';
ij> create table sp_ss_ex_contact(
email       varchar(200)  primary key,
   first_name  varchar(50) not null    ,
   middle_name varchar(50)             ,
   last_name   varchar(50) not null    ,
   telephone   varchar(20 )            ,
   address     varchar(250)            ,
   state       char   (1  ) not null   ,
   last_update timestamp not null
);
0 rows inserted/updated/deleted
ij> insert into sp_ss_ex_contact 
values('manjula@domain.com','manjula',null,'kutty
',null,null,'a',CURRENT_TIMESTAMP);
1 row inserted/updated/deleted
ij> select * from sp_ss_ex_contact;
EMAIL
                                                |FIRST_NAME
                   |MIDDLE_NAME                                       
|LAST_NAME
                                         |TELEPHONE           |ADDRESS

                               |&|LAST_UPDATE
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------
manjula@domain.com
                                                |manjula
                   |NULL                                              |kutty
                                         |NULL                |NULL

                               |a|2006-03-01 09:42:03.703

1 row selected


Can you sent me your reproduction script/program?

Thanks
Manjula