Caused by: org.h2.jdbc.JdbcSQLException: Unknown data type: "T1"; SQL
statement:
SELECT R1.*,
R2.CLASS AS R2_CLASS,
R2.AUDIT_USER_NAME AS R2_AUDIT_USER_NAME,
R2.AUDIT_TIMESTAMP AS R2_AUDIT_TIMESTAMP,
R2.AUDIT_PROCESS_DATE AS R2_AUDIT_PROCESS_DATE,
R3.TEXT AS R3_TEXT,
R3.LETTER AS R3_LETTER,
R3.CODE_AEB43 AS R3_CODE_AEB43,
R3.STATUS AS R3_STATUS
FROM
(
SELECT E.REFERENCE, E.BALANCE_ID, E.CURRENCY,
E.IBAN,
E.ENTITY_CODE, E.BRANCH,
E.PROCESS_DATE, E.VALUE_DATE,
E.GROUP_REFERENCE,
MIN(E.INTERNAL_REFERENCE) AS INTERNAL_REFERENCE, MIN(E.ISIN) AS ISIN,
E.APPLICATION,
E.SIMPLE_PROCESS_DATE, E.TEXT,
E.BANK_ORDER_ID,
E.CANCELLED_ENTRY_ID,
E.AUDITABLE_ID, E.CANCELLED_ID,
MIN(E.ID) AS ID,
MIN(E.ENTRY_CONCEPT_ID) AS ENTRY_CONCEPT_ID,
MIN(E.DOCUMENT_NUMBER) AS
DOCUMENT_NUMBER, SUM(E.AMOUNT) AS
AMOUNT
FROM
(
SELECT
T1.ID,
(CASE WHEN T1.GROUP_REFERENCE
IS NULL THEN 'I' +
CONVERT(VARCHAR,T1.ID) ELSE 'R' + CONVERT(VARCHAR,T1.GROUP_REFERENCE)
END) AS REFERENCE,
T1.BALANCE_ID,
T2.CURRENCY, T3.IBAN,
T3.ENTITY_CODE, T6.BRANCH,
T1.PROCESS_DATE,
T1.VALUE_DATE,
T1.SIMPLE_PROCESS_DATE,
dbo.grouped_text(T1.GROUP_REFERENCE, T1.ENTRY_CONCEPT_ID,
T1.TEXT) AS TEXT,
T1.ENTRY_CONCEPT_ID,
(CASE WHEN T1.GROUP_REFERENCE
IS NULL THEN T1.BANK_ORDER_ID ELSE
NULL END) AS BANK_ORDER_ID,
(CASE WHEN T1.GROUP_REFERENCE
IS NULL THEN T1.CANCELLED_ENTRY_ID
ELSE NULL END) AS CANCELLED_ENTRY_ID,
(CASE WHEN T1.GROUP_REFERENCE
IS NULL THEN T6.AUDITABLE_ID ELSE
NULL END) AS AUDITABLE_ID,
(CASE WHEN T1.GROUP_REFERENCE
IS NULL THEN T4.ID ELSE NULL END)
AS CANCELLED_ID,
T1.DOCUMENT_NUMBER,
T1.AMOUNT,
T1.GROUP_REFERENCE,
T1.INTERNAL_REFERENCE,
T1.ISIN,
T7.APPLICATION
FROM ENTRY as T1
INNER JOIN BALANCE as T2 ON
T1.BALANCE_ID = T2.ID
INNER JOIN ACCOUNT as T3 ON
T2.ACCOUNT_ID = T3.ID
LEFT OUTER JOIN ENTRY as T4
(INDEX IDX_CANCELLED_ENTRY_ID) ON
T1.ID = T4.CANCELLED_ENTRY_ID
LEFT OUTER JOIN ENTRY as T5
(INDEX PK_ENTRY) ON
T1.CANCELLED_ENTRY_ID = T5.ID
LEFT OUTER JOIN BANK_ORDER as
T6 (INDEX PK) ON T1.BANK_ORDER_ID
= T6.ID
LEFT OUTER JOIN AUDITABLE as T7
ON T7.ID = T6.AUDITABLE_ID
WHERE
(
(T1.CANCELLED_ENTRY_ID = NULL) OR
(T1.SIMPLE_PROCESS_DATE >
T5.SIMPLE_PROCESS_DATE)
)
AND
(
(T4.ID = NULL) OR
(T4.SIMPLE_PROCESS_DATE >
T1.SIMPLE_PROCESS_DATE)
)
AND T3.IBAN = ?
AND T1.PROCESS_DATE>= ?
AND T1.PROCESS_DATE<= ?
) as E
GROUP BY
E.REFERENCE, E.BALANCE_ID,
E.CURRENCY, E.IBAN, E.ENTITY_CODE,
E.BRANCH,
E.PROCESS_DATE, E.VALUE_DATE,
E.GROUP_REFERENCE,
E.SIMPLE_PROCESS_DATE,
E.TEXT, E.BANK_ORDER_ID,
E.CANCELLED_ENTRY_ID,
E.AUDITABLE_ID, E.CANCELLED_ID,
E.APPLICATION
) as R1
LEFT OUTER JOIN AUDITABLE as R2 ON R1.AUDITABLE_ID =
R2.ID
LEFT OUTER JOIN ENTRY_CONCEPT as R3 ON
R1.ENTRY_CONCEPT_ID = R3.ID
ORDER BY
R1.PROCESS_DATE asc,
R1.ID asc [50004-154]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.command.Parser.parseColumnWithType(Parser.java:3613)
at org.h2.command.Parser.readFunction(Parser.java:2159)
at org.h2.command.Parser.readTerm(Parser.java:2440)
at org.h2.command.Parser.readFactor(Parser.java:2025)
at org.h2.command.Parser.readSum(Parser.java:2015)
at org.h2.command.Parser.readConcat(Parser.java:1985)
at org.h2.command.Parser.readCondition(Parser.java:1850)
at org.h2.command.Parser.readAnd(Parser.java:1831)
at org.h2.command.Parser.readExpression(Parser.java:1823)
at org.h2.command.Parser.readWhen(Parser.java:2636)
at org.h2.command.Parser.readTerm(Parser.java:2434)
at org.h2.command.Parser.readFactor(Parser.java:2025)
at org.h2.command.Parser.readSum(Parser.java:2012)
at org.h2.command.Parser.readConcat(Parser.java:1985)
at org.h2.command.Parser.readCondition(Parser.java:1850)
at org.h2.command.Parser.readAnd(Parser.java:1831)
at org.h2.command.Parser.readExpression(Parser.java:1823)
at org.h2.command.Parser.readTerm(Parser.java:2522)
at org.h2.command.Parser.readFactor(Parser.java:2025)
at org.h2.command.Parser.readSum(Parser.java:2012)
at org.h2.command.Parser.readConcat(Parser.java:1985)
at org.h2.command.Parser.readCondition(Parser.java:1850)
at org.h2.command.Parser.readAnd(Parser.java:1831)
at org.h2.command.Parser.readExpression(Parser.java:1823)
at org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:
1736)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1768)
at org.h2.command.Parser.parseSelectSub(Parser.java:1663)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1508)
at org.h2.command.Parser.readTableFilter(Parser.java:1011)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1669)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1776)
at org.h2.command.Parser.parseSelectSub(Parser.java:1663)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1508)
at org.h2.command.Parser.readTableFilter(Parser.java:1011)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1669)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1776)
at org.h2.command.Parser.parseSelectSub(Parser.java:1663)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1508)
at org.h2.command.Parser.parseSelect(Parser.java:1496)
at org.h2.command.Parser.parsePrepared(Parser.java:401)
at org.h2.command.Parser.parse(Parser.java:275)
at org.h2.command.Parser.parse(Parser.java:247)
at org.h2.command.Parser.prepare(Parser.java:201)
at org.h2.command.Parser.prepareCommand(Parser.java:214)
at org.h2.engine.Session.prepareLocal(Session.java:426)
at org.h2.engine.Session.prepareCommand(Session.java:374)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:
1100)
at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:
71)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:
608)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:616)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache
$1StmtAcquireTask.run(GooGooStatementCache.java:525)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner
$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
--
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.
