db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Linehan <lineh...@tcd.ie>
Subject Migrating from MySQL to Apache - having difficulty with Timestamp.
Date Thu, 23 Jan 2014 19:41:34 GMT
Hi all,

I have the following MySQL statement and I wish to insert the same
data into a Derby table.

INSERT INTO analysis VALUES (6,'0000-00-00
00:00:00','RNASeqGene',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)

My Derby table is of the fomat (some columns missing).

========
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
ANALYSIS_ID         |SMALLINT |0   |10  |5     |NULL      |NULL      |NO
CREATED             |TIMESTAMP|9   |10  |29    |NULL      |NULL      |NO
LOGIC_NAME          |VARCHAR  |NULL|NULL|128   |NULL      |256       |NO
DB                  |VARCHAR  |NULL|NULL|120   |NULL      |240       |YES
DB_VERSION          |VARCHAR  |NULL|NULL|40    |NULL      |80        |YES
DB_FILE             |VARCHAR  |NULL|NULL|120   |NULL      |240       |YES
PROGRAM             |VARCHAR  |NULL|NULL|80    |NULL      |160       |YES
================

>From here http://db.apache.org/derby/docs/10.5/ref/rrefsqlj27620.html,
is *_appears_* that
my data is OK, but I get the error
==============
Error: The string representation of a date/time value is out of range.
SQLState:  22007
ErrorCode: 30000
===============

>From Squirrel SQL.

Could anybody kindly point out where I'm going wrong?


TIA and rgs,


Paul...

-- 

linehanp@tcd.ie

Mob: 00 353 86 864 5772

Mime
View raw message