Hi,
I've just installed the latest 3.1 runtime assemblies for a project, but the DB2 driver seems to generate wrong queries for every query:
SELECT
"LPLA_1"."KENTEKEN" AS "Kenteken",
"LPLA_1"."NUMMER_LM" AS "NummerLm"
FROM ""SchemaName""."OBJECTEN" "LPLA_1"
WHERE (
(
(
(
(
(
(
"LPLA_1"."DATUM_WIJZIGING" > ?)
OR
(
(
"LPLA_1"."DATUM_WIJZIGING" = ?)
AND
(
"LPLA_1"."TIJD_WIJZIGING" >= ?)
)
)
)
AND
(
"LPLA_1"."DATUM_WIJZIGING" <= ?)
)
)
)
)
resulting in:
WARN:
IBM.Data.DB2.DB2Exception (0x80004005): ERROR [42601] [IBM][DB2/AIX64] SQL0104N An unexpected token """" was found following "" AS "NummerLm" FROM". Expected tokens may include: "<space>". SQLSTATE=42601
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows)
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method)
at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior)
at IBM.Data.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior behavior)
at HibernatingRhinos.Profiler.Appender.ProfiledDataAccess.ProfiledCommand.ExecuteDbDataReader(CommandBehavior behavior)
It seems like the Schema part of the table specification is wrapped in too many quotes, could I be doing something wrong?
Thanks,
Wiebe