Patches item #1086590, was opened at 2004-12-16 19:27
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376687&aid=1086590&group_id=22866

Category: JBossCMP
Group: v3.2
Status: Open
Resolution: None
Priority: 5
Submitted By: Pekka Vainio (pvainio)
Assigned to: Nobody/Anonymous (nobody)
Summary: Delete relations in blocks if needed

Initial Comment:
Solution to bug 1062429
(http://sourceforge.net/tracker/index.php?func=detail&aid=1062429&group_id=22866&atid=376685
).

This patch will add configuration parameter
delete-relations-max to jbosscmp-jdbc.xml.  If
specified this parameter will limit number of relations
to be removed in one sql-statement.  If limit is
exceeded multiple delete statements will be executed.

At least Sybase has problems with too many parameters
in statements.  Accoording to the bug Oracle and SQL
server is affected too.

Affected files:
jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
 - set limit for Sybase
jboss/src/main/org/jboss/ejb/plugins/cmp/jdbc/metadata/JDBCTypeMappingMetaData.java
 - limit configuration
jboss/src/main/org/jboss/ejb/plugins/cmp/jdbc/JDBCDeleteRelationsCommand.java
 - delete in blocks if limit specified and exceeded

Since I have no real knowledge of JBoss internals I
hope jbosscmp-jdbc is the right place for this
configuration.  Parameter name could be more
informative, but I could not figure out what could be
short and informative name for it.



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376687&aid=1086590&group_id=22866


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to