Return-Path: Delivered-To: apmail-db-ojb-dev-archive@www.apache.org Received: (qmail 45202 invoked from network); 16 Oct 2006 00:52:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 16 Oct 2006 00:52:33 -0000 Received: (qmail 56569 invoked by uid 500); 16 Oct 2006 00:52:33 -0000 Delivered-To: apmail-db-ojb-dev-archive@db.apache.org Received: (qmail 56525 invoked by uid 500); 16 Oct 2006 00:52:32 -0000 Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "OJB Developers List" Reply-To: "OJB Developers List" Delivered-To: mailing list ojb-dev@db.apache.org Received: (qmail 56504 invoked by uid 500); 16 Oct 2006 00:52:32 -0000 Received: (qmail 56500 invoked by uid 99); 16 Oct 2006 00:52:32 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 15 Oct 2006 17:52:32 -0700 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [140.211.166.113] (HELO eris.apache.org) (140.211.166.113) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 15 Oct 2006 17:52:32 -0700 Received: by eris.apache.org (Postfix, from userid 65534) id 969511A981A; Sun, 15 Oct 2006 17:52:11 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r464343 - /db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformMySQLImpl.java Date: Mon, 16 Oct 2006 00:52:11 -0000 To: ojb-commits@db.apache.org From: arminw@apache.org X-Mailer: svnmailer-1.1.0 Message-Id: <20061016005211.969511A981A@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Author: arminw Date: Sun Oct 15 17:52:09 2006 New Revision: 464343 URL: http://svn.apache.org/viewvc?view=rev&rev=464343 Log: add support for stored procedure based sequence key generation Modified: db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformMySQLImpl.java Modified: db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformMySQLImpl.java URL: http://svn.apache.org/viewvc/db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformMySQLImpl.java?view=diff&rev=464343&r1=464342&r2=464343 ============================================================================== --- db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformMySQLImpl.java (original) +++ db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformMySQLImpl.java Sun Oct 15 17:52:09 2006 @@ -22,6 +22,8 @@ import java.sql.PreparedStatement; import java.sql.SQLException; import java.sql.Types; +import java.sql.CallableStatement; +import java.sql.Connection; import org.apache.ojb.broker.query.LikeCriteria; import org.apache.ojb.broker.metadata.FieldDescriptor; @@ -202,5 +204,22 @@ protected String getQuotedName(String aString) { return '`' + aString + '`'; + } + + public CallableStatement prepareNextValProcedureStatement( + Connection con, String procedureName, String sequenceName) throws PlatformException + { + try + { + String sp = "{call " + procedureName + "(?, ?)}"; + CallableStatement cs = con.prepareCall(sp); + cs.registerOutParameter(1, Types.INTEGER); + cs.setString(2, sequenceName); + return cs; + } + catch (SQLException e) + { + throw new PlatformException(e); + } } } --------------------------------------------------------------------- To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org For additional commands, e-mail: ojb-dev-help@db.apache.org