Hi,
The error code "PWS0006" / "-239" is not from H2, so it has to be from
AS/400. Is there some more thread dump you could post? There should be the
root cause as well, from the AS/400 JDBC driver.
Regards,
Thomas
On Wednesday, May 2, 2012, Francesc Monge Tapies wrote:
> 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]<javascript:;>
> .
> To unsubscribe from this group, send email to
> [email protected] <javascript:;>.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
--
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.
