Return-Path: Delivered-To: apmail-hadoop-pig-dev-archive@www.apache.org Received: (qmail 94256 invoked from network); 4 Aug 2010 08:28:41 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 4 Aug 2010 08:28:41 -0000 Received: (qmail 57171 invoked by uid 500); 4 Aug 2010 08:28:41 -0000 Delivered-To: apmail-hadoop-pig-dev-archive@hadoop.apache.org Received: (qmail 56970 invoked by uid 500); 4 Aug 2010 08:28:39 -0000 Mailing-List: contact pig-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: pig-dev@hadoop.apache.org Delivered-To: mailing list pig-dev@hadoop.apache.org Received: (qmail 56962 invoked by uid 99); 4 Aug 2010 08:28:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Aug 2010 08:28:38 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Aug 2010 08:28:38 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o748SHrp025884 for ; Wed, 4 Aug 2010 08:28:18 GMT Message-ID: <4152784.154271280910497967.JavaMail.jira@thor> Date: Wed, 4 Aug 2010 04:28:17 -0400 (EDT) From: "Ankur (JIRA)" To: pig-dev@hadoop.apache.org Subject: [jira] Updated: (PIG-1229) allow pig to write output into a JDBC db In-Reply-To: <1669209229.117171265616209690.JavaMail.jira@brutus.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/PIG-1229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankur updated PIG-1229: ----------------------- Attachment: jira-1229-final.test-fix.patch Aaron, Autocommit() was not the issue. It was the usage of "jdbc:hsqldb:file:" url in the STORE function that was the problem. Replacing it with "jdbc:hsqldb:hsql://localhost/dbname" solved the issue. Attaching the updated patch with the test case modification. Really appreciate your help here. Thanks a lot :-) > allow pig to write output into a JDBC db > ---------------------------------------- > > Key: PIG-1229 > URL: https://issues.apache.org/jira/browse/PIG-1229 > Project: Pig > Issue Type: New Feature > Components: impl > Reporter: Ian Holsman > Assignee: Ankur > Priority: Minor > Fix For: 0.8.0 > > Attachments: jira-1229-final.patch, jira-1229-final.test-fix.patch, jira-1229-v2.patch, jira-1229-v3.patch, pig-1229.2.patch, pig-1229.patch > > > UDF to store data into a DB -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.