Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@geronimo.apache.org
Message-ID: <30972205.84301275306881650.JavaMail.jira@thor>
Date: Mon, 31 May 2010 07:54:41 -0400 (EDT)
From: =?utf-8?Q?J=C3=BCrgen_Weber_=28JIRA=29?= <jira@apache.org>
To: dev@geronimo.apache.org
Subject: [jira] Commented: (GERONIMO-5183) Support DB2 static SQLJ
In-Reply-To: <420731494.264921268657907211.JavaMail.jira@brutus.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/GERONIMO-5183?page=3Dcom.atlass=
ian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1=
2873627#action_12873627 ]=20

J=C3=BCrgen Weber commented on GERONIMO-5183:
----------------------------------------

A work-around is to use the wrapped connection (as suggested as Approach II=
I in the IBM document cited above):

org.tranql.connector.jdbc.ConnectionHandle ch =3D (org.tranql.connector.jdb=
c.ConnectionHandle)connection;
org.tranql.connector.ManagedConnectionHandle association =3D ch.getAssociat=
ion();
connection =3D (Connection)association.getPhysicalConnection();


> Support DB2 static SQLJ
> -----------------------
>
>                 Key: GERONIMO-5183
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-5183
>             Project: Geronimo
>          Issue Type: Improvement
>      Security Level: public(Regular issues)=20
>          Components: databases
>    Affects Versions: 2.2
>            Reporter: J=C3=BCrgen Weber
>            Priority: Critical
>
> Currently Geronimo does not support applications that use statically boun=
d SQL via DB2 SQLJ.=20
> If you run Geronimo with the setting=20
> JAVA_OPTS=3D"-Ddb2.jcc.sqljUncustomizedWarningOrException=3D2"
> that forces an Exception when an uncustomized SQLJ application is run
> you get=20
> java.sql.SQLException: Profile is not customized,  ProfileName :=20
> sqlj.CS_SJProfile0
> =09sqlj.runtime.error.RuntimeErrors.raise_UNCUSTOMIZED(RuntimeErrors.java=
:87)
> This is even thrown when the profile is indeed customized, so it looks li=
ke the Geronimo DB2 connection wrapper does not support SQLJ.
> This document describes what an app server has to implement to support SQ=
LJ:
> http://www-01.ibm.com/support/docview.wss?&uid=3Dswg27017902
> SQLJ samples for Java are included with DB2 Express-C
> DB2-Express-C/db2/V9.5/samples/java/sqlj

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.