From torque-user-return-7005-apmail-db-torque-user-archive=db.apache.org@db.apache.org Fri May 05 07:58:49 2006 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 61408 invoked from network); 5 May 2006 07:58:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 May 2006 07:58:49 -0000 Received: (qmail 35587 invoked by uid 500); 5 May 2006 07:58:44 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 35382 invoked by uid 500); 5 May 2006 07:58:42 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 35370 invoked by uid 99); 5 May 2006 07:58:42 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 May 2006 00:58:42 -0700 X-ASF-Spam-Status: No, hits=0.6 required=10.0 tests=HTML_00_10,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of cheprod@gmail.com designates 66.249.82.196 as permitted sender) Received: from [66.249.82.196] (HELO wx-out-0102.google.com) (66.249.82.196) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 May 2006 00:58:40 -0700 Received: by wx-out-0102.google.com with SMTP id t13so461552wxc for ; Fri, 05 May 2006 00:58:19 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=iZNOuR4jlZ1LPNAAFySguXvIw9YYIDBdtN9A1IEQPrjyiJQ294VGiSL0IXTikkYM8ssD+hA7sPyYMRQhQtk+FZ5NqxixFVaAZm+dZ/Ni2/aoUtN163p4gmNLft9i7o8p83fAlRvslO91vT8qAZoxsv1xTVZrxmCR5DoJm4xY8rE= Received: by 10.70.94.2 with SMTP id r2mr730353wxb; Fri, 05 May 2006 00:58:19 -0700 (PDT) Received: by 10.70.110.15 with HTTP; Fri, 5 May 2006 00:58:19 -0700 (PDT) Message-ID: <887839280605050058w1267058ay6780bdac6bf4e388@mail.gmail.com> Date: Fri, 5 May 2006 09:58:19 +0200 From: Thib To: turbine-user@jakarta.apache.org, torque-user@db.apache.org Subject: Using Torque and Turbine with Oracle 9i database MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10146_29613349.1146815899819" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_10146_29613349.1146815899819 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, I'm new using Turbine and Torque and I enjoyed using it. I work with tdk-2.= 2, Turbine 2.2 and Torque 3.0 under Linux (Red Hat AS 3.0). I migrated my database from Oracle 8i to Oracle 9i, and I try to use the Oracle 9i jdbc for Torque connections. Each time the database throw an error, the active connection between Torque and Oracle shutdown. I patched the Oracle 8i jdbc helped by the Oracle website instructions but = I have new problems. For example, the connection between Toraque and Oracle are never closed. So when the maximum number of connection allowed by Oracl= e are reached, it become impossible to establish new connection to the database (So, new user can't login on the website). Moreover, if the database restart, I need to reload my application to restablish the connection with the database. Did you succeed using Torque 3.0 and Turbine with Oracle 9i under Linux ? Is it necessary to migrate to a more recent version of Torque ? Is it diffcult to do it in a few time ? 1 day or 1 week ? Need I to modify the source code ? Thanks for your responses ;) Best regards, Thibaud ------=_Part_10146_29613349.1146815899819--