db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From meenakshi selvi <meena_32...@yahoo.co.in>
Subject SQL Exception
Date Wed, 01 Mar 2006 05:26:59 GMT
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,it 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
        at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown So
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(
Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setObject(Unknown S
please help me.

 Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.
View raw message