Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 25192 invoked from network); 19 May 2009 08:26:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 19 May 2009 08:26:07 -0000 Received: (qmail 63326 invoked by uid 500); 19 May 2009 08:26:07 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 63293 invoked by uid 500); 19 May 2009 08:26:06 -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 63283 invoked by uid 99); 19 May 2009 08:26:06 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 May 2009 08:26:06 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [212.77.161.253] (HELO bronski.r-kom.de) (212.77.161.253) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 May 2009 08:25:55 +0000 Received: from mail.systech-eu.com (mail.sy-wiretech.com [212.77.176.227] (may be forged)) by bronski.r-kom.de (8.14.3/8.14.3) with SMTP id n4J8PUID028971 for ; Tue, 19 May 2009 10:25:33 +0200 Received: from rbg1e01.SYtech ([172.18.3.40]) by eSafe SMTP Relay 1241096274; Tue, 19 May 2009 10:03:20 +0200 Received: from bra1e01.SYtech ([129.103.38.28]) by rbg1e01.SYtech with Microsoft SMTPSVC(5.0.2195.6713); Tue, 19 May 2009 10:25:30 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: RE: Problems while switching torque from mysql to oracle Date: Tue, 19 May 2009 10:25:29 +0200 Message-ID: <6657C3B2619A894889300870F6C1F58B022B107D@bra1e01.sytech> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Problems while switching torque from mysql to oracle Thread-Index: AcnXyPR75/L+VI/VRCi6Ny2U4GGW1wAkRk9g From: "Bullwinkel Axel" To: "Apache Torque Users List" X-OriginalArrivalTime: 19 May 2009 08:25:30.0535 (UTC) FILETIME=[5F111B70:01C9D85B] X-ESAFE-STATUS: Mail clean X-ESAFE-DETAILS: X-Virus-Checked: Checked by ClamAV on apache.org Hi Thomas, it works so far and I am able to login to swamp. Thank you for the quick support. But now I am facing the next problem: When I try to start a new workflow in swamp I get the error message: java.sql.SQLException: ORA-00923: Schl=FCsselwort FROM nicht an erwartete= r Stelle gefunden Could you give me a hint where I have to search for the cause? Is this a = problem with torque or with swamp? Are there sql statements passed direct= ly from swamp to the db or are all the sql statement generated in torque? All the best, Axel! Fax: =20 mailto: axel.bullwinkel@systech-eu.com -----Original Message----- From: Thomas Fischer [mailto:fischer@seitenbau.net]=20 Sent: Montag, 18. Mai 2009 16:57 To: Apache Torque Users List Subject: RE: Problems while switching torque from mysql to oracle > That line looks like this: > torque.dsfactory.swamp.pool.validationQuery=3DSELECT 1 This will not work with oracle. Please change it to torque.dsfactory.swamp.pool.validationQuery=3Dselect 1 from dual Thomas --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org