Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "OJB Developers List" <ojb-dev@db.apache.org>
Message-ID: <1447450460.1121415190296.JavaMail.jira@ajax.apache.org>
Date: Fri, 15 Jul 2005 10:13:10 +0200 (CEST)
From: "Armin Waibel (JIRA)" <jira@apache.org>
To: ojb-dev@db.apache.org
Subject: [jira] Assigned: (OJB-59) Incorrect identity management in
 SequenceManagerNativeImpl because of wrong plate-forme settings
In-Reply-To: <208887624.1121249590604.JavaMail.jira@ajax.apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

     [ http://issues.apache.org/jira/browse/OJB-59?page=3Dall ]

Armin Waibel reassigned OJB-59:
-------------------------------

    Assign To: Armin Waibel

> Incorrect identity management in SequenceManagerNativeImpl because of wro=
ng plate-forme settings
> -------------------------------------------------------------------------=
-----------------------
>
>          Key: OJB-59
>          URL: http://issues.apache.org/jira/browse/OJB-59
>      Project: OJB
>         Type: Bug
>   Components: PB-API
>     Versions: 1.0.3
>  Environment: Sybase
>     Reporter: St=C3=A9pane Routhiau
>     Assignee: Armin Waibel
>     Priority: Critical

>
> The request for getting the last insert identity is wrong on Sybase ASE, =
it shoud be the same as MsSQLServer. We tested the following code, that
> work. Thanks to include it in the next releases.
> Best regards=20
> Stephane Routhiau
> --------------------------
> public class PlatformSybaseASEImpl extends PlatformSybaseImpl {
>     public String getLastInsertIdentityQuery(String tableName)
>     {
>         // the function is used by the
>         // org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl
>         // this call must be made before commit the insert cammand, so yo=
u
>         // must turn off autocommit by setting the useAutoCommit=3D"1" or=
 useAutoCommit=3D"2"
>         return "SELECT @@IDENTITY AS id FROM " + tableName;
>     }=20
> }

--=20
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org