I have been using Version 1.2.128.
The following error occurred.
org.h2.jdbc.JdbcSQLException: データ変換中にエラーが発生しました "1970-01-01"
Data conversion error converting "1970-01-01"; SQL statement:
select
SMS_SID
from
SML_SMEIS
where
SMS_JKBN = 9 [90021-128]
at org.h2.message.Message.getSQLException(Message.java:110)
at org.h2.value.Value.convertTo(Value.java:784)
at org.h2.expression.Comparison.getValue(Comparison.java:248)
at org.h2.expression.Expression.getBooleanValue(Expression.java:
188)
at org.h2.command.dml.Select.queryFlat(Select.java:493)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:558)
at org.h2.command.dml.Query.query(Query.java:243)
at org.h2.command.CommandContainer.query(CommandContainer.java:81)
at org.h2.command.Command.executeQuery(Command.java:132)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:
98)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:
92)
SMS_SID, SMS_JKBN is Integer.
How to convert date type error why?
Schema is created in the following statement.
create table SML_SMEIS
(
USR_SID integer not null,
SMS_SID integer not null,
SMS_SDATE timestamp,
SMS_TITLE varchar(50),
SMS_MARK integer,
SMS_BODY varchar(1000),
SMS_JKBN integer,
SMS_AUID integer not null,
SMS_ADATE timestamp not null,
SMS_EUID integer not null,
SMS_EDATE timestamp not null,
primary key (SMS_SID)
) ;
Version 1.1 * DB is created.
Currently being converted. (Extension ". h2.db")
JAVA: 1.6.0_18
Thanks
--
HK
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
