利用者向け情報

開発者向け情報

[s2openjpa]/trunk/s2openjpa/src/test/resources/data/demo.trace.db

Parent Directory Parent Directory | Revision Log Revision Log


Revision 46 - (show annotations)
Sat Jun 7 22:39:54 2008 JST (4 years, 11 months ago) by da-yoshi
File size: 5105 byte(s)
テストケース追加
1 06-07 15:25:45 jdbc[2]: SQLException
2 org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります INSERT INTO NORMAL(ID,NAME,AMOUNT,START_DATE,CREATED_AT,LOCK_VERSION) VALUES
3 (1,'名前1',12300,PARSEDATETIME('2005-03-02','yyyy-MM-dd'),PARSEDATETIME('2006-05-02 22:34:25','yyyy-MM-dd HH:mm:ss'),0),
4 (2,'名前2',22340,PARSEDATETIME('2003-05-30','yyyy-MM-dd'),PARSEDATETIME('2007-10-21 05:39:55','yyyy-MM-dd HH:mm:ss'),0)
5 CREATE[*] SEQUENCE SEQ_NOMAL START WITH 3
6 Syntax error in SQL statement INSERT INTO NORMAL(ID,NAME,AMOUNT,START_DATE,CREATED_AT,LOCK_VERSION) VALUES
7 (1,'名前1',12300,PARSEDATETIME('2005-03-02','yyyy-MM-dd'),PARSEDATETIME('2006-05-02 22:34:25','yyyy-MM-dd HH:mm:ss'),0),
8 (2,'名前2',22340,PARSEDATETIME('2003-05-30','yyyy-MM-dd'),PARSEDATETIME('2007-10-21 05:39:55','yyyy-MM-dd HH:mm:ss'),0)
9 CREATE[*] SEQUENCE SEQ_NOMAL START WITH 3; SQL statement:
10 INSERT INTO NORMAL(ID,NAME,AMOUNT,START_DATE,CREATED_AT,LOCK_VERSION) VALUES
11 (1,'名前1',12300,PARSEDATETIME('2005-03-02','yyyy-MM-dd'),PARSEDATETIME('2006-05-02 22:34:25','yyyy-MM-dd HH:mm:ss'),0),
12 (2,'名前2',22340,PARSEDATETIME('2003-05-30','yyyy-MM-dd'),PARSEDATETIME('2007-10-21 05:39:55','yyyy-MM-dd HH:mm:ss'),0)
13 CREATE SEQUENCE SEQ_NOMAL START WITH 3 [42000-67]
14 at org.h2.message.Message.getSQLException(Message.java:89)
15 at org.h2.message.Message.getSQLException(Message.java:93)
16 at org.h2.message.Message.getSQLException(Message.java:71)
17 at org.h2.message.Message.getSyntaxError(Message.java:98)
18 at org.h2.command.Parser.getSyntaxError(Parser.java:446)
19 at org.h2.command.Parser.prepareCommand(Parser.java:226)
20 at org.h2.engine.Session.prepareLocal(Session.java:215)
21 at org.h2.engine.Session.prepareCommand(Session.java:197)
22 at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1009)
23 at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:141)
24 at org.h2.server.web.WebThread.getResult(WebThread.java:1559)
25 at org.h2.server.web.WebThread.query(WebThread.java:1129)
26 at org.h2.server.web.WebThread.process(WebThread.java:387)
27 at org.h2.server.web.WebThread.processRequest(WebThread.java:143)
28 at org.h2.server.web.WebThread.run(WebThread.java:170)
29 06-07 16:39:24 jdbc[2]: SQLException
30 org.h2.jdbc.JdbcSQLException: 不明なデータ型: )
31 Unknown data type: ); SQL statement:
32 CREATE TABLE EMBEDDEDSAMPLE (
33 PK1 INTEGER
34 ,PK2 DATE
35 ,NAME
36 ) [50004-67]
37 at org.h2.message.Message.getSQLException(Message.java:89)
38 at org.h2.message.Message.getSQLException(Message.java:93)
39 at org.h2.message.Message.getSQLException(Message.java:71)
40 at org.h2.command.Parser.parseColumn(Parser.java:3098)
41 at org.h2.command.Parser.parseColumnForTable(Parser.java:2995)
42 at org.h2.command.Parser.parseCreateTable(Parser.java:4344)
43 at org.h2.command.Parser.parseCreate(Parser.java:3202)
44 at org.h2.command.Parser.parsePrepared(Parser.java:299)
45 at org.h2.command.Parser.parse(Parser.java:266)
46 at org.h2.command.Parser.parse(Parser.java:238)
47 at org.h2.command.Parser.prepareCommand(Parser.java:210)
48 at org.h2.engine.Session.prepareLocal(Session.java:215)
49 at org.h2.engine.Session.prepareCommand(Session.java:197)
50 at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1009)
51 at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:141)
52 at org.h2.server.web.WebThread.getResult(WebThread.java:1559)
53 at org.h2.server.web.WebThread.query(WebThread.java:1129)
54 at org.h2.server.web.WebThread.process(WebThread.java:387)
55 at org.h2.server.web.WebThread.processRequest(WebThread.java:143)
56 at org.h2.server.web.WebThread.run(WebThread.java:170)
57 06-07 16:39:24 jdbc[2]: SQLException
58 org.h2.jdbc.JdbcSQLException: テーブル EMBEDDEDSAMPLE が見つかりません
59 Table EMBEDDEDSAMPLE not found; SQL statement:
60 INSERT INTO EMBEDDEDSAMPLE(PK1,PK2,NAME) VALUES
61 (1,PARSEDATETIME('2008-01-03', 'yyyy-MM-dd'),'名前1'),
62 (2,PARSEDATETIME('2006-03-30', 'yyyy-MM-dd'),'名前2') [42102-67]
63 at org.h2.message.Message.getSQLException(Message.java:89)
64 at org.h2.message.Message.getSQLException(Message.java:93)
65 at org.h2.message.Message.getSQLException(Message.java:71)
66 at org.h2.command.Parser.readTableOrView(Parser.java:3993)
67 at org.h2.command.Parser.readTableOrView(Parser.java:3973)
68 at org.h2.command.Parser.parseInsert(Parser.java:798)
69 at org.h2.command.Parser.parsePrepared(Parser.java:344)
70 at org.h2.command.Parser.parse(Parser.java:266)
71 at org.h2.command.Parser.parse(Parser.java:238)
72 at org.h2.command.Parser.prepareCommand(Parser.java:210)
73 at org.h2.engine.Session.prepareLocal(Session.java:215)
74 at org.h2.engine.Session.prepareCommand(Session.java:197)
75 at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1009)
76 at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:141)
77 at org.h2.server.web.WebThread.getResult(WebThread.java:1559)
78 at org.h2.server.web.WebThread.query(WebThread.java:1129)
79 at org.h2.server.web.WebThread.process(WebThread.java:387)
80 at org.h2.server.web.WebThread.processRequest(WebThread.java:143)
81 at org.h2.server.web.WebThread.run(WebThread.java:170)

Repository Top
ViewVC Help  
ViewVC logotype
Powered by ViewVC