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