Oppolzer - Informatik / Blog

unknown wrote:

I agree with Bernd, this should be fixed in your code.

The previous JDBC driver (com.ibm.db2.jdbc.app.DB2Driver) used to
allow this (back in the DB2 8.2 timeframe), but the universal JDBC
driver (com.ibm.db2.jcc.DB2Driver) fixed this.


On Tue, Jan 13, 2015 at 8:49 AM, unknown wrote:
> We currently have a java application running on AIX, which connects to our
> DB2/ZOS (V10) database, using DB2/Connect V10.5.
>
> The SQL query within the Java App, has a semi-colon coded at the end as an
> end of statement. This works fine when connecting to DB2/ZOS.
>
> However, when we attempt to have the app connect to a DB2/LUW (V10.5)
> database (on AIX), the app then fails with an SQLCODE -104 due to the
> semi-colon (If I remove the semi-colon, the app runs successfully against
> LUW)....
>
> Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -104,
> SQLSTATE: 42601, SQLERRMC: ;;LE_TYPE DESC
> WITH UR;END-OF-STATEMENT
>
> Is there a config setting in either DB2/Connect, Java, or LUW, that will
> allow LUW to accept the semi-colon (or to strip it before LUW gets it)?
>
> Thanks!
> T.M.
> DB2 Mainframe Dinosaur
>
> -----End Original Message-----