From derby-user-return-12126-apmail-db-derby-user-archive=db.apache.org@db.apache.org Mon Jan 18 19:23:35 2010 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 53885 invoked from network); 18 Jan 2010 19:23:35 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 18 Jan 2010 19:23:35 -0000 Received: (qmail 17871 invoked by uid 500); 18 Jan 2010 19:23:35 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 17831 invoked by uid 500); 18 Jan 2010 19:23:34 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 17823 invoked by uid 99); 18 Jan 2010 19:23:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Jan 2010 19:23:34 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of m.v.lunteren@gmail.com designates 209.85.160.56 as permitted sender) Received: from [209.85.160.56] (HELO mail-pw0-f56.google.com) (209.85.160.56) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Jan 2010 19:23:26 +0000 Received: by pwj16 with SMTP id 16so2341377pwj.15 for ; Mon, 18 Jan 2010 11:23:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=Dvtul/49/umG9xqF/49s926u0tncmIedo2FDdEnPRWQ=; b=A0dB3cZUdWyPxzphrQ0v/Q+4oolEZ74mnb4O8MRR9Jr2qUQmycwD4HYRKKxRoTHSeS KlPhnQPXDoDB0gC7d4O9PxN7GUmpLf9RALkObYDrSHtf1WWqHY+aGZbgJOmcG/UrUFfy 2aOT1hMdfi1ad0JxGMHGi8PgPLq3FsBGuNLzA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=cXLdJmIdIrkKsqFuNeP0W2bfSoWbD1sNrE2+CKvsgNSvxgX/jVlnCBvxqJ8oDQ8nay I/wLUIvL0qMO56P2CqakqxljI+g8G2ed7yAgGUkm22B63n9bV5fMTr8zk3AMonYwOBnL TtzFD2F+pdyJcjtS9M0yWaUmeZ1YM9LxcuRKU= MIME-Version: 1.0 Received: by 10.115.87.4 with SMTP id p4mr3016974wal.202.1263842585601; Mon, 18 Jan 2010 11:23:05 -0800 (PST) In-Reply-To: References: Date: Mon, 18 Jan 2010 11:23:05 -0800 Message-ID: Subject: Re: debugging java stored procedures From: Myrna van Lunteren To: Derby Discussion Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org On Mon, Jan 18, 2010 at 10:25 AM, Thomas wrote: > Hi, > > any tipps from anyone which would help to debug java stored procedures? > > Not being able/knowing how to debug the code executed by the database > using the eclipse debugger, I have included System.out.println statements > into the procedures, but have no idea where these end up when running > against a network server on a remote host mode (have checked tomcat logs, > but haven't found anything). > > Thanks > > > > > This will not help much, but did you test it in steps - i.e. first test on your local machine - and with the stored procedure's java code in a class on your local machine rather than a jar in the database? But you've probably already done that? In eclipse you might be able to suspend the run by putting a breakpoint in the source, then 'attaching' to the appropriate suspended thread... The tomcat installation should point you to where it's starting networkserver, and you might be able to add some debugging/tracing properties to a derby.properties file (to be created) in that directory. Helpful derby.properties settings are: derby.infolog.append=true derby.stream.error.logSeverityLevel=0 derby.language.logStatementText=true More detailed errors should then show up in a derby.log file somewhere on the server. There are also tracing properties you can switch on for network server and client - check the manual http://db.apache.org/derby/docs/dev/adminguide/cadminappsclienttracing.html and http://db.apache.org/derby/docs/dev/adminguide/radminconfig.html and http://db.apache.org/derby/docs/dev/adminguide/radminconfigdb2jdrdatracedirectory.html HTH Myrna