[#DBUTILS-29] [dbutils] Support bean property to SQL IN parameter mapping

Commons DbUtils

[dbutils] Support bean property to SQL IN parameter mapping

Created: 09/Mar/04 11:23 AM Updated: 07/Mar/09 06:09 AM

Return to search

Component/s:

None

Affects Version/s:

1.0

Fix Version/s:

1.2

Time Tracking:

Not Specified

Environment:

« Hide

Operating System: other
Platform: Other

Issue Links:

Duplicate

This issue duplicates:

~~DBUTILS-43~~ an helper set of classes for JDBC processing with prepared statement

This issue is duplicated by:

~~DBUTILS-47~~ Add a StatementFiller to be able to provide a Bean for updates, instead of bean values.

Bugzilla Id:	27531
Resolution Date:	25/Feb/09 10:03 AM

Description

« Hide

This commons-dev message brings up interesting points:
http://www.mail-archive.com/commons-dev@jakarta.apache.org/msg36011.html

Providing a way to map bean properties to SQL IN parameters would round out the
bean functionality. We already have ResultSet columns being transferred to bean
properties; why not transfer the other way as well?

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Henri Yandell made changes - 16/May/06 09:38 AM

Field	Original Value	New Value
issue.field.bugzillaimportkey	27531	12341321

Henri Yandell made changes - 16/May/06 11:29 AM

Key	COM-1169	~~DBUTILS-29~~
Project	Commons [ 12310458 ]	Commons DbUtils [ 12310470 ]
Affects Version/s	1.0 Final [ 12311651 ]
Component/s	DbUtils [ 12311110 ]
Assignee	Jakarta Commons Developers Mailing List [ commons-dev@jakarta.apache.org ]

Henri Yandell made changes - 16/May/06 12:28 PM

Affects Version/s

1.0 Final [ 12311724 ]

Henri Yandell made changes - 04/Nov/06 05:14 AM

Fix Version/s

1.2 [ 12312139 ]

Dan Fabulich made changes - 05/Feb/09 04:15 PM

Link

This issue is duplicated by ~~DBUTILS-47~~ [ ~~DBUTILS-47~~ ]

[ Permlink | « Hide ]

Dan Fabulich added a comment - 05/Feb/09 04:16 PM

~~DBUTILS-47~~ suggests a nice implementation for this using a StatementFiller interface.

Dan Fabulich made changes - 05/Feb/09 04:20 PM

Link

This issue duplicates ~~DBUTILS-43~~ [ ~~DBUTILS-43~~ ]

[ Permlink | « Hide ]

Dan Fabulich added a comment - 05/Feb/09 04:20 PM

~~DBUTILS-43~~ goes further and provides an implementation

Repository	Revision	Date	User	Message
ASF	#742870	Tue Feb 10 07:20:16 UTC 2009	dfabulich	[~~DBUTILS-29~~] Support bean property to SQL IN parameter mapping Defines new fillStatementWithBean functions, and makes fillStatement public
				Files Changed
				MODIFY /commons/sandbox/dbutils/bugfixing/src/java/org/apache/commons/dbutils/QueryRunner.java

Repository	Revision	Date	User	Message
ASF	#747724	Wed Feb 25 10:01:31 UTC 2009	bayard	Merging in Dab Fabulich's work on https://svn.apache.org/repos/asf/commons/sandbox/dbutils/bugfixing from -r741987:747723. Resolving ~~DBUTILS-34~~ - ~~DBUTILS-37~~ - ~~DBUTILS-29~~ - ~~DBUTILS-14~~ - ~~DBUTILS-31~~ - ~~DBUTILS-39~~ - ~~DBUTILS-41~~ - ~~DBUTILS-44~~ - ~~DBUTILS-33~~ - ~~DBUTILS-42~~ - ~~DBUTILS-40~~
				Files Changed
				MODIFY /commons/proper/dbutils/trunk/src/java/org/apache/commons/dbutils/handlers/MapListHandler.java MODIFY /commons/proper/dbutils/trunk/src/java/org/apache/commons/dbutils/BasicRowProcessor.java MODIFY /commons/proper/dbutils/trunk/src/java/org/apache/commons/dbutils/handlers/BeanListHandler.java MODIFY /commons/proper/dbutils/trunk/src/java/org/apache/commons/dbutils/BeanProcessor.java ADD /commons/proper/dbutils/trunk/src/java/org/apache/commons/dbutils/handlers/AbstractListHandler.java (from /commons/sandbox/dbutils/bugfixing/src/java/org/apache/commons/dbutils/handlers/AbstractListHandler.java) MODIFY /commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BaseTestCase.java MODIFY /commons/proper/dbutils/trunk/pom.xml MODIFY /commons/proper/dbutils/trunk/src/java/org/apache/commons/dbutils/handlers/ColumnListHandler.java DEL /commons/proper/dbutils/trunk/src/java/org/apache/commons/dbutils/handlers/GenericListHandler.java ADD /commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/QueryRunnerTest.java (from /commons/sandbox/dbutils/bugfixing/src/test/org/apache/commons/dbutils/QueryRunnerTest.java) MODIFY /commons/proper/dbutils/trunk/src/java/org/apache/commons/dbutils/handlers/ArrayListHandler.java MODIFY /commons/proper/dbutils/trunk/src/java/org/apache/commons/dbutils/QueryRunner.java

[ Permlink | « Hide ]

Henri Yandell added a comment - 25/Feb/09 10:03 AM

svn ci -m "Merging in Dab Fabulich's work on https://svn.apache.org/repos/asf/commons/sandbox/dbutils/bugfixing from -r741987:747723. Resolving ~~DBUTILS-34~~ - ~~DBUTILS-37~~ - ~~DBUTILS-29~~ - ~~DBUTILS-14~~ - ~~DBUTILS-31~~ - ~~DBUTILS-39~~ - ~~DBUTILS-41~~ - ~~DBUTILS-44~~ - ~~DBUTILS-33~~ - ~~DBUTILS-42~~ - ~~DBUTILS-40~~"

Sending pom.xml
Sending src/java/org/apache/commons/dbutils/BasicRowProcessor.java
Sending src/java/org/apache/commons/dbutils/BeanProcessor.java
Sending src/java/org/apache/commons/dbutils/QueryRunner.java
Adding src/java/org/apache/commons/dbutils/handlers/AbstractListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/ArrayListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/BeanListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/ColumnListHandler.java
Deleting src/java/org/apache/commons/dbutils/handlers/GenericListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/MapListHandler.java
Sending src/test/org/apache/commons/dbutils/BaseTestCase.java
Adding src/test/org/apache/commons/dbutils/QueryRunnerTest.java
Transmitting file data .........
Committed revision 747724.

Henri Yandell made changes - 25/Feb/09 10:03 AM

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Dan Fabulich made changes - 07/Mar/09 06:09 AM

Assignee

Dan Fabulich [ dfabulich ]