pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aaron Kimball (JIRA)" <j...@apache.org>
Subject [jira] Commented: (PIG-1229) allow pig to write output into a JDBC db
Date Wed, 04 Aug 2010 07:32:18 GMT

    [ https://issues.apache.org/jira/browse/PIG-1229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12895171#action_12895171

Aaron Kimball commented on PIG-1229:

I'm pretty confused by what you mean here. HSQLDB is fully SQL-92 compliant and provides ACID
transactional semantics. If you execute a {{CREATE TABLE}} statement in a {{Statement}} or
{{PreparedStatement}} created in a given {{Connection}} and then call {{Connection.commit()}},
this commit statement will either throw a {{SQLException}} indicating failure, or return silently,
indicating that the results have been made durable and are visible to all subsequent transactions
of concurrent clients.

This version of HSQLDB has been available for several years at this point. It is quite stable.
If sleeping for a random timeout interval fixes your issue, then you have most likely misconfigured
something. You might want to double-check; have you called {{Connection.setAutoCommit()}}?
If this is configured to false, do you call {{commit()}} after making an update?

Note that if you are using separate processes to connect to HSQLDB, then you should start
a single {{Server}} instance that should connect to the underlying database resource with
{{file:}} or {{mem:}} to operate on a file-backed or memory-backed database, but the child
processes should then connect to the server using {{jdbc:hsqldb:hsql://<server>:<port>/<dbname>}}
so they actually serialize through the server. Concurrent clients in separate processes should
not access the same database via {{jdbc:hsqldb:file://}} resources.

> 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.

View raw message