Hi:
I am getting an error when the length of parameter OriginalTableString
goes above 255 (aprox) characters:
org.h2.jdbc.JdbcSQLException: [PWS0006] El valor para el parámetro no
es válido.; SQL statement:
CREATE LINKED TABLE IF NOT EXISTS itemsLNK
('com.ibm.as400.access.AS400JDBCDriver', 'jdbc:as400://10.xx.xx.xx/
QGPL', 'xxxx', 'xxxx','(select
HMITNO,HMSTYN,HMFTIX,HMOPTX,HMOPTY,HMOPTZ,MMITDS,HMTY15 from
m3edbDEV.mitmah JOIN m3edbDEV.mitmas ON HMCONO=mmCONO AND
HMITNO=MMITNO where HMCONO=10 AND HMITNO in (SELECT OIITNO FROM
M3EDBDEV.OASITN JOIN DBEDBDEV.ZSAMRH ON OICONO=ZHCONO AND
OIASCD=ZHASCD))') READONLY [-239-165]
Is this 255 a restriction on H2, or on the AS400 DB2 side which I am
connecting to?
Thanks and regards
at org.h2.message.DbException.addSQL(DbException.java:124)
at org.h2.command.Command.executeUpdate(Command.java:234)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
at com.dbaeu.memDB.tools.database.H2MemView.<init>(H2MemView.java:86)
at
com.dbaeu.apps.optimum.OptimumTest1.initapplication(OptimumTest1.java:
124)
at com.dbaeu.apps.optimum.OptimumTest1.start(OptimumTest1.java:206)
at com.sun.javafx.application.LauncherImpl$5.run(Unknown Source)
at com.sun.javafx.application.PlatformImpl$4.run(Unknown Source)
at com.sun.javafx.application.PlatformImpl$3.run(Unknown Source)
at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
at com.sun.glass.ui.win.WinApplication.access$100(Unknown Source)
at com.sun.glass.ui.win.WinApplication$2$1.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
--
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.
