dbunit-developer

[dbunit-developer] Builder

[Roberto Lo G. <rlo...@gm...>]

Here is an usage example for the dataset builder

DataSet dataSet = new DataSetBuilder()
.table("first")
.cols("id","username","password","display")
 .row(1, "rlogiacco", "rlogiacco", "Roberto Lo Giacco")
.row(2, "asd", "asd")
 .row(3, "asd", "asd", "asd")
.table("second")
 .cols("id","display","name","surname","email")
.row()
 .row();

Using varargs we can consider missing columns as null but unless we make the
interface less fluent we have no idea of the column type or at least we have
to guess the type through the Java type used to valorize it.

I see no need to describe relationships and constraints, do I miss
something?

[dbunit-developer] [ dbunit-Bugs-3046689 ] HSQLDB catalog multiple schemas

[SourceForge.net <no...@so...>]

Bugs item #3046689, was opened at 2010-08-16 18:58
Message generated for change (Comment added) made by chikkubhai
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: None
Status: Open
Resolution: None
Priority: 9
Private: No
Submitted By: wecansolveit.org (chikkubhai)
Assigned to: matthias g (gommma)
Summary: HSQLDB catalog multiple schemas

Initial Comment:
If HsqlDB had multiple schemas as 
Catalogs
  !- PUBLIC
     !- Schemas
        !- SCHEMA1
        !- SCHEMA2
        ... 

QueryDataSet partialDataSet = new QueryDataSet(getDatabaseConnection(SCHEMA_NAME));
partialDataSet.addTable(TABLE_NAME, (" SELECT * FROM SCHEMA1.TABLE1");
FlatXmlDataSet.write(partialDataSet, new FileOutputStream(TABLE1.xml")

exports as

<?xml version='1.0' encoding='UTF-8'?>
<dataset>
  <TABLE1 COL1="1" ...>
</dataset>

Where is the schema information here??? No wonder, the following fails:

IDatabaseConnection connection = getDatabaseConnection("SCHEMA1");
DatabaseOperation.CLEAN_INSERT.execute(connection, IDataSet dataSet);

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

>Comment By: wecansolveit.org (chikkubhai)
Date: 2010-09-21 17:07

Message:
The solution to this problem is two ways: 
one is to add the schema to the dataset itself and db2 seems to have some
strange issues which were resolved as per :
https://sourceforge.net/tracker/index.php?func=detail&aid=2838922&group_id=47439&atid=449491

connection.getConfig().setProperty(DatabaseConfig.FEATURE_QUALIFIED_TABLE_NAMES,
true);
		
		// FIX for error: java.lang.IllegalStateException: Did not find column
'ACCOUNT_ID_I' for <schema.table> 'REFERENCE_DATA.VW_REF_ACCOUNT' in
catalog 'NYTXDI01' because names do not exactly match.
		//
http://sourceforge.net/tracker/index.php?func=detail&aid=2838922&group_id=47439&atid=449491
		connection.getConfig().setProperty(DatabaseConfig.PROPERTY_METADATA_HANDLER,
new Db2MetadataHandler());
connection.getConfig().setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY,
new Db2DataTypeFactory());
connection.getConfig().setProperty(DatabaseConfig.PROPERTY_TABLE_TYPE,
	            new String[] {"TABLE", "ALIAS"});

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

Comment By: wecansolveit.org (chikkubhai)
Date: 2010-09-21 14:44

Message:
Is there no solution to this yet? What is the workaround for using hsqldb?

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

Comment By: wecansolveit.org (chikkubhai)
Date: 2010-08-16 18:59

Message:
saying the table does not exist, had to include patch works in classes like
operation.AbstractOperation.getOperationMetaData(IDatabaseConnection,
ITableMetaData) and so on.. to check 

ITableMetaData tableMetaData= null;
        if(((IDataTypeFactory)(connection.getConfig().getProperty(
        		DatabaseConfig.PROPERTY_DATATYPE_FACTORY))) instanceof
HsqldbDataTypeFactory
        		&& connection.getSchema() != null) {
(databaseConfig.getProperty(DatabaseConfig.FEATURE_QUALIFIED_TABLE_NAMES))).booleanValue())
{
        	tableMetaData =
databaseDataSet.getTableMetaData(connection.getSchema().concat("." +
tableName));
        }
        else{
        	tableMetaData = databaseDataSet.getTableMetaData(tableName);
        

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3046689 ] HSQLDB catalog multiple schemas

[SourceForge.net <no...@so...>]

Bugs item #3046689, was opened at 2010-08-16 18:58
Message generated for change (Settings changed) made by chikkubhai
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: None
Status: Open
Resolution: None
>Priority: 9
Private: No
Submitted By: wecansolveit.org (chikkubhai)
Assigned to: matthias g (gommma)
Summary: HSQLDB catalog multiple schemas

Initial Comment:
If HsqlDB had multiple schemas as 
Catalogs
  !- PUBLIC
     !- Schemas
        !- SCHEMA1
        !- SCHEMA2
        ... 

QueryDataSet partialDataSet = new QueryDataSet(getDatabaseConnection(SCHEMA_NAME));
partialDataSet.addTable(TABLE_NAME, (" SELECT * FROM SCHEMA1.TABLE1");
FlatXmlDataSet.write(partialDataSet, new FileOutputStream(TABLE1.xml")

exports as

<?xml version='1.0' encoding='UTF-8'?>
<dataset>
  <TABLE1 COL1="1" ...>
</dataset>

Where is the schema information here??? No wonder, the following fails:

IDatabaseConnection connection = getDatabaseConnection("SCHEMA1");
DatabaseOperation.CLEAN_INSERT.execute(connection, IDataSet dataSet);

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

Comment By: wecansolveit.org (chikkubhai)
Date: 2010-09-21 14:44

Message:
Is there no solution to this yet? What is the workaround for using hsqldb?

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

Comment By: wecansolveit.org (chikkubhai)
Date: 2010-08-16 18:59

Message:
saying the table does not exist, had to include patch works in classes like
operation.AbstractOperation.getOperationMetaData(IDatabaseConnection,
ITableMetaData) and so on.. to check 

ITableMetaData tableMetaData= null;
        if(((IDataTypeFactory)(connection.getConfig().getProperty(
        		DatabaseConfig.PROPERTY_DATATYPE_FACTORY))) instanceof
HsqldbDataTypeFactory
        		&& connection.getSchema() != null) {
(databaseConfig.getProperty(DatabaseConfig.FEATURE_QUALIFIED_TABLE_NAMES))).booleanValue())
{
        	tableMetaData =
databaseDataSet.getTableMetaData(connection.getSchema().concat("." +
tableName));
        }
        else{
        	tableMetaData = databaseDataSet.getTableMetaData(tableName);
        

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3046689 ] HSQLDB catalog multiple schemas

[SourceForge.net <no...@so...>]

Bugs item #3046689, was opened at 2010-08-16 18:58
Message generated for change (Settings changed) made by chikkubhai
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: None
Status: Open
Resolution: None
Priority: 7
Private: No
Submitted By: wecansolveit.org (chikkubhai)
Assigned to: matthias g (gommma)
>Summary: HSQLDB catalog multiple schemas

Initial Comment:
If HsqlDB had multiple schemas as 
Catalogs
  !- PUBLIC
     !- Schemas
        !- SCHEMA1
        !- SCHEMA2
        ... 

QueryDataSet partialDataSet = new QueryDataSet(getDatabaseConnection(SCHEMA_NAME));
partialDataSet.addTable(TABLE_NAME, (" SELECT * FROM SCHEMA1.TABLE1");
FlatXmlDataSet.write(partialDataSet, new FileOutputStream(TABLE1.xml")

exports as

<?xml version='1.0' encoding='UTF-8'?>
<dataset>
  <TABLE1 COL1="1" ...>
</dataset>

Where is the schema information here??? No wonder, the following fails:

IDatabaseConnection connection = getDatabaseConnection("SCHEMA1");
DatabaseOperation.CLEAN_INSERT.execute(connection, IDataSet dataSet);

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

Comment By: wecansolveit.org (chikkubhai)
Date: 2010-09-21 14:44

Message:
Is there no solution to this yet? What is the workaround for using hsqldb?

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

Comment By: wecansolveit.org (chikkubhai)
Date: 2010-08-16 18:59

Message:
saying the table does not exist, had to include patch works in classes like
operation.AbstractOperation.getOperationMetaData(IDatabaseConnection,
ITableMetaData) and so on.. to check 

ITableMetaData tableMetaData= null;
        if(((IDataTypeFactory)(connection.getConfig().getProperty(
        		DatabaseConfig.PROPERTY_DATATYPE_FACTORY))) instanceof
HsqldbDataTypeFactory
        		&& connection.getSchema() != null) {
(databaseConfig.getProperty(DatabaseConfig.FEATURE_QUALIFIED_TABLE_NAMES))).booleanValue())
{
        	tableMetaData =
databaseDataSet.getTableMetaData(connection.getSchema().concat("." +
tableName));
        }
        else{
        	tableMetaData = databaseDataSet.getTableMetaData(tableName);
        

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3046689 ] HSQLDB catalog

[SourceForge.net <no...@so...>]

Bugs item #3046689, was opened at 2010-08-16 18:58
Message generated for change (Settings changed) made by chikkubhai
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: None
Status: Open
Resolution: None
Priority: 7
Private: No
Submitted By: wecansolveit.org (chikkubhai)
Assigned to: matthias g (gommma)
>Summary: HSQLDB catalog

Initial Comment:
If HsqlDB had multiple schemas as 
Catalogs
  !- PUBLIC
     !- Schemas
        !- SCHEMA1
        !- SCHEMA2
        ... 

QueryDataSet partialDataSet = new QueryDataSet(getDatabaseConnection(SCHEMA_NAME));
partialDataSet.addTable(TABLE_NAME, (" SELECT * FROM SCHEMA1.TABLE1");
FlatXmlDataSet.write(partialDataSet, new FileOutputStream(TABLE1.xml")

exports as

<?xml version='1.0' encoding='UTF-8'?>
<dataset>
  <TABLE1 COL1="1" ...>
</dataset>

Where is the schema information here??? No wonder, the following fails:

IDatabaseConnection connection = getDatabaseConnection("SCHEMA1");
DatabaseOperation.CLEAN_INSERT.execute(connection, IDataSet dataSet);

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

Comment By: wecansolveit.org (chikkubhai)
Date: 2010-09-21 14:44

Message:
Is there no solution to this yet? What is the workaround for using hsqldb?

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

Comment By: wecansolveit.org (chikkubhai)
Date: 2010-08-16 18:59

Message:
saying the table does not exist, had to include patch works in classes like
operation.AbstractOperation.getOperationMetaData(IDatabaseConnection,
ITableMetaData) and so on.. to check 

ITableMetaData tableMetaData= null;
        if(((IDataTypeFactory)(connection.getConfig().getProperty(
        		DatabaseConfig.PROPERTY_DATATYPE_FACTORY))) instanceof
HsqldbDataTypeFactory
        		&& connection.getSchema() != null) {
(databaseConfig.getProperty(DatabaseConfig.FEATURE_QUALIFIED_TABLE_NAMES))).booleanValue())
{
        	tableMetaData =
databaseDataSet.getTableMetaData(connection.getSchema().concat("." +
tableName));
        }
        else{
        	tableMetaData = databaseDataSet.getTableMetaData(tableName);
        

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3046689 ] does not support multiple schemas in HSQLDB

[SourceForge.net <no...@so...>]

Bugs item #3046689, was opened at 2010-08-16 18:58
Message generated for change (Comment added) made by chikkubhai
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: None
Status: Open
Resolution: None
Priority: 7
Private: No
Submitted By: wecansolveit.org (chikkubhai)
Assigned to: matthias g (gommma)
Summary: does not support multiple schemas in HSQLDB

Initial Comment:
If HsqlDB had multiple schemas as 
Catalogs
  !- PUBLIC
     !- Schemas
        !- SCHEMA1
        !- SCHEMA2
        ... 

QueryDataSet partialDataSet = new QueryDataSet(getDatabaseConnection(SCHEMA_NAME));
partialDataSet.addTable(TABLE_NAME, (" SELECT * FROM SCHEMA1.TABLE1");
FlatXmlDataSet.write(partialDataSet, new FileOutputStream(TABLE1.xml")

exports as

<?xml version='1.0' encoding='UTF-8'?>
<dataset>
  <TABLE1 COL1="1" ...>
</dataset>

Where is the schema information here??? No wonder, the following fails:

IDatabaseConnection connection = getDatabaseConnection("SCHEMA1");
DatabaseOperation.CLEAN_INSERT.execute(connection, IDataSet dataSet);

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

>Comment By: wecansolveit.org (chikkubhai)
Date: 2010-09-21 14:44

Message:
Is there no solution to this yet? What is the workaround for using hsqldb?

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

Comment By: wecansolveit.org (chikkubhai)
Date: 2010-08-16 18:59

Message:
saying the table does not exist, had to include patch works in classes like
operation.AbstractOperation.getOperationMetaData(IDatabaseConnection,
ITableMetaData) and so on.. to check 

ITableMetaData tableMetaData= null;
        if(((IDataTypeFactory)(connection.getConfig().getProperty(
        		DatabaseConfig.PROPERTY_DATATYPE_FACTORY))) instanceof
HsqldbDataTypeFactory
        		&& connection.getSchema() != null) {
(databaseConfig.getProperty(DatabaseConfig.FEATURE_QUALIFIED_TABLE_NAMES))).booleanValue())
{
        	tableMetaData =
databaseDataSet.getTableMetaData(connection.getSchema().concat("." +
tableName));
        }
        else{
        	tableMetaData = databaseDataSet.getTableMetaData(tableName);
        

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3071408 ] New Handling of Timestamp in 2.4.8 has error with subseconds

[SourceForge.net <no...@so...>]

Bugs item #3071408, was opened at 2010-09-19 19:01
Message generated for change (Tracker Item Submitted) made by chrisphe
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3071408&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: v2.4.*
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Chris Pheby (chrisphe)
Assigned to: matthias g (gommma)
Summary: New Handling of Timestamp in 2.4.8 has error with subseconds

Initial Comment:
When updating the Usertype project (http://usertype.sourceforge.net/) to dbunit 2.4.8, I have found a defect in handling of timestamps.

The change in revision 1131 (bug 2921131) introduces a defect because the handling of zero padding in the millisecond field
differs between SimpleDateFormat and the JDBC escape format for Timestamp.

in SimpleDateFormat .5 gives 005 millis
in JDBC escape format .5 gives 500 millis

In addition, the change in this version removes support for nanosecond precision from the timestamp.

I have included a revised patch which I believe addresses the above problems (including additions to the tests that demonstrate it)
whilst supporting the improvement the original patch aimed to provide (i.e. zone support).

Regards Chris

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3071408&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3071407 ] DBUnit Trunk Does not compile with Java 1.4

[SourceForge.net <no...@so...>]

Bugs item #3071407, was opened at 2010-09-19 18:58
Message generated for change (Settings changed) made by chrisphe
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3071407&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
>Group: v2.4.*
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Chris Pheby (chrisphe)
Assigned to: matthias g (gommma)
Summary: DBUnit Trunk Does not compile with Java 1.4

Initial Comment:
DBUnit pom indicates that Java 1.4 should be used for the build, however a number of files will not compile. I have attached a patch to address this.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3071407&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3071407 ] DBUnit Trunk Does not compile with Java 1.4

[SourceForge.net <no...@so...>]

Bugs item #3071407, was opened at 2010-09-19 18:58
Message generated for change (Tracker Item Submitted) made by chrisphe
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3071407&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Chris Pheby (chrisphe)
Assigned to: matthias g (gommma)
Summary: DBUnit Trunk Does not compile with Java 1.4

Initial Comment:
DBUnit pom indicates that Java 1.4 should be used for the build, however a number of files will not compile. I have attached a patch to address this.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3071407&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3067480 ] Offer configuration of CsvDataSet

[SourceForge.net <no...@so...>]

Bugs item #3067480, was opened at 2010-09-16 09:57
Message generated for change (Tracker Item Submitted) made by 
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3067480&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Feature Request
Group: v2.4.*
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: https://www.google.com/accounts ()
Assigned to: Roberto Lo Giacco (rlogiacco)
Summary: Offer configuration of CsvDataSet

Initial Comment:
New Config-features for CsvDataSet:
- configure csv delimiter (override default ',' to something like ';'), escaping the comma by "" or \, is to cumbersome for filling out csv
- make empty column default to 'null'
- make null case-sensitive (currently NULL fails it expects lower-cased null), this is inconsistent to most db-providers


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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3067480&group_id=47439

[dbunit-developer] DBUnit 2.4.8: Parsing TIMESTAMP with nanoseconds

[Hoffmann, Sven / K. + N. / H. ZI-A. <Sve...@Ku...>]

After updating to DBUnit 2.4.8 I've noticed that nanoseconds of columns of type TIMESTAMP are not parsed as expected.

In the scope of the feature request "Add timezone support for timestamp data type - ID: 2921131" parsing 
of timestamps has changed in a way that nanoseconds are not supported anymore and the following test fails with DBUnit 2.4.8.

@Test
public void testParseTimestampWithNanoseconds() throws DataTypeException {
	final String timestamp = "2010-01-02 10:38:22.123456789";
	Db2DataTypeFactory factory = new Db2DataTypeFactory();
	DataType dataType = factory.createDataType(Types.TIMESTAMP, "TIMESTAMP");
	Object value = dataType.typeCast(timestamp);
	assertEquals(timestamp, value.toString());
}

The timestamp 2010-01-02 10:38:22.123456789 is parsed to 2010-01-03 20:55:58.789. The same test succeeds with DBUnit 2.4.7

As a result nanoseconds have to be replaced by milliseconds in existing datasets. 
Also correct datasets can not be generated using a queryset with SQL like "SELECT CURRENT_TIMESTAMP FROM..."

Is it possible to support nanoseconds in TIMESTAMP columns of datasets.

Thank you,
Sven

Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius, Reiner Heiken, Bruno Mang, Alfred Manke, Christian Marnetté, Mark Reinhardt, Jens Wollesen, Klaus Jaeger (stellv.), Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne

Re: [dbunit-developer] Annotations

[Roberto Lo G. <rlo...@gm...>]

:-D I'm looking for job in NZ!!!

I hope we can find a couple of hours where we are both online then....

On Fri, Sep 3, 2010 at 01:52, John Hurst <joh...@gm...> wrote:

> +1 irc. But ... I am in New Zealand! We're about 12 hours different from
> you. :-(
>
> JH
>
>
> On Fri, Sep 3, 2010 at 11:49 AM, Roberto Lo Giacco <rlo...@gm...>wrote:
>
>>
>>
>> On Thu, Sep 2, 2010 at 21:19, John Hurst <joh...@gm...> wrote:
>>
>>> FWIW, I don't consider the dataset to be metadata for the test. I usually
>>> consider the test data to be the main focus of the test.
>>>
>>> If you like, there are two reasons for inline test data approach:
>>>
>>> 1) Achieve a more tabular representation, which is easier to read.
>>> 2) Get the data into the test, rather than have the data away somewhere
>>> else in a file hidden somewhere. (As for retrieving data via a URL ... ?!!)
>>>
>>
>> I do not dislike inlining test data, I always wish to have strictly
>> related things to be in the same place. If your second point comment goes
>> against the url name I gave to the annotation parameter I thought we always
>> had it as an URL, but it was strictly a file URL... I do not plan to have
>> remote dataset, but I don't see a reason why we shouldn't add such feature
>> as it cames almost for free....
>>
>>
>>> Believe it or not, I have tests that contain no "code needed to perform
>>> the test" -- they contain only setup data and assertion data! These are for
>>> testing non-trivial database views, of which we have quite a number in the
>>> applications I'm working on. I've found the inline data approach beautifully
>>> concise and clear for testing views.
>>>
>>
>> I consider the assertion statements the "code needed to perform the test"
>> while I consider the dataset "the minimum set of datas I need to ensure the
>> method under test works correctly"... I know saying they are metadata is not
>> completely correct and I see the point to have those datas build and checked
>> at compile time... I was trying to define what can be useful as annotation
>> and I ended with what I presented to you... it is under discussion, I'm not
>> vetoing on that. Do someone see any use of what I named InlineDataSet? If
>> not we can drop it and eventually (if any reason will come in the future)
>> add it, or it will just stay out...
>>
>>
>>> However, I'm not trying to argue against other representations (too
>>> much). Many representations should be supported. We certainly use
>>> FlatXmlDataSet plenty too, and it is very useful for many situations. (It's
>>> nice to see that some 3rd party libraries, e.g. Jailer, support export to
>>> DbUnit's FlatXmlDataSet format.)
>>>
>>
>> I agree, moving toward 3.0 doesn't mean we MUST break with past, we should
>> get what worked and redesign what is too old or what is not clean... If we
>> should look for something that have not worked I think our search will end
>> up with an empty result... dbUnit rocks even if its design is very old. This
>> mean the original team did a great work!
>>
>>
>>> Just thoughts, I really need to get coding! I have an all-day soccer
>>> tournament for my son this Saturday. I hope my reward will be Sunday
>>> programming!
>>>
>>
>> Why don't we schedule a coding remote meeting on an irc channel or other
>> communication channel? We could infect each other with ideas....
>>
>>
>>>
>>> JH
>>>
>>> On Fri, Sep 3, 2010 at 12:12 AM, Roberto Lo Giacco <rlo...@gm...>wrote:
>>>
>>>> The test method is not empty, it will contains the code needed to
>>>> perform the test. I can see your point, coding the dataset construction
>>>> allows compilation checks, but don't you consider the dataset metadata for
>>>> the test method? Well I'm not completely sure I consider them metadata by
>>>> myself...
>>>>
>>>> On Thu, Sep 2, 2010 at 13:13, Andres Almiray <aal...@ya...>wrote:
>>>>
>>>>> FWIW the @InlineDataSet looks sily considering that all the code is
>>>>> found in the annotation and the method is empty.
>>>>> Here is where I would prefer a builder or a fluent interface design to
>>>>> put the code where it belongs (the method) while retaining some readability
>>>>> and be expressive.
>>>>> The method could retain a simpler version of @InlineDataSet to mark it
>>>>> as a special DataSet provider.
>>>>>
>>>>> Be careful with annotation driven development, there be dragons ;-)
>>>>>
>>>>> Cheers,
>>>>> Andres
>>>>>
>>>>> ------------------------------
>>>>> *From:* Roberto Lo Giacco <rlo...@gm...>
>>>>> *To:* dbUnit Developers List <dbu...@li...>
>>>>> *Sent:* Thu, September 2, 2010 1:05:05 PM
>>>>> *Subject:* Re: [dbunit-developer] Annotations
>>>>>
>>>>> Some advancement on the topic... I can't stop about this :-)
>>>>>
>>>>> package org.dbunit.annotations;
>>>>>
>>>>> import org.dbunit.DatabaseOperation;
>>>>> import org.dbunit.DataSet.Format;
>>>>> import org.dbunit.annotation.ConnectionDataSet;
>>>>> import org.dbunit.annotation.DataSetFilter;
>>>>> import org.dbunit.annotation.InlineDataSet;
>>>>> import org.dbunit.annotation.TearDownOperation;
>>>>> import org.dbunit.annotation.TearUpOperation;
>>>>> import org.dbunit.annotation.TestConnection;
>>>>> import org.dbunit.annotation.URLDataSet;
>>>>> import org.dbunit.annotation.DataSetFilter.Replace;
>>>>> import org.dbunit.annotation.InlineDataSet.Column;
>>>>> import org.dbunit.annotation.InlineDataSet.Row;
>>>>> import org.dbunit.annotation.InlineDataSet.Table;
>>>>> import org.dbunit.annotation.TestConnection.Type;
>>>>>
>>>>> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
>>>>> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
>>>>> @TearDownOperation(DatabaseOperation.Type.NONE)
>>>>> @TearUpOperation(value=DatabaseOperation.Type.CLEAN_INSERT,
>>>>> transaction=true)
>>>>> public class UsageExample {
>>>>>
>>>>> @URLDataSet(
>>>>>  value={"http://www.dbunit.org/users.xml","file://test/orders.xml"},
>>>>>  format=Format.XML)
>>>>>  public void multipleURLDataSetWithSameFormat() {
>>>>>
>>>>> }
>>>>>
>>>>> @URLDataSet(
>>>>>  value={"http://www.dbunit.org/users.xml","orders.csv"},
>>>>>  format={Format.XML, Format.CSV})
>>>>>  public void multipleURLDataSetWithDifferentFormat() {
>>>>>
>>>>> }
>>>>>  @URLDataSet("http://www.dbunit.org/users.xml")
>>>>>  @DataSetFilter(query="FROM USERS WHERE ID < 5")
>>>>>  public void filteredDataSet() {
>>>>>
>>>>> }
>>>>>  @URLDataSet(value="http://www.dbunit.org/users.xml", streamed=true)
>>>>>  @DataSetFilter(replace=@Replace(orig="<null>", target=Replace.NULL))
>>>>>  public void streamedDataSetWithReplacement() {
>>>>>
>>>>> }
>>>>>
>>>>> @InlineDataSet(tables= {
>>>>>  @Table(name="invoices",
>>>>>  columns={@Column(name="id", type="int"), @Column(name="date",
>>>>> type="timestamp")},
>>>>>  rows={@Row("1, 25/11/1975"),
>>>>>  @Row("2, 25/11/1975"),
>>>>>  @Row("3, 25/11/1975"),
>>>>>  @Row("4, 25/11/1975")
>>>>>  }
>>>>>  ),
>>>>>  @Table(name="invoices2",
>>>>>  columns={@Column(name="id", type="int"), @Column(name="date",
>>>>> type="timestamp")},
>>>>>  rows={@Row("1, 25/11/1975"),
>>>>>  @Row("2, 25/11/1975"),
>>>>>  @Row("3, 25/11/1975"),
>>>>>  @Row("4, 25/11/1975")
>>>>>  }
>>>>>  )
>>>>>  })
>>>>>  public void inlineDataSet() {
>>>>>
>>>>> }
>>>>>  @ConnectionDataSet(value=@TestConnection(url="",type=Type.JNDI))
>>>>>  public void connectionDataSet() {
>>>>>
>>>>> }
>>>>>  @ConnectionDataSet(value=@TestConnection(url="",type=Type.JDBC),
>>>>>  filters=@DataSetFilter(query="SELECT * FROM *"))
>>>>>  @DataSetFilter(query="SELECT * FROM users",
>>>>> replace=@Replace(orig="<null>", target=Replace.NULL))
>>>>>  public void connectionDataSetWithFilter() {
>>>>>
>>>>> }
>>>>> }
>>>>>
>>>>>
>>>>> On Thu, Sep 2, 2010 at 11:04, Roberto Lo Giacco <rlo...@gm...>wrote:
>>>>>
>>>>>> Here is an example of what I was thinking about introducing
>>>>>> annotations in dbUnit...
>>>>>>
>>>>>> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
>>>>>> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
>>>>>> public class UsageExample {
>>>>>>
>>>>>> @MultipleDataSet( { @URLDataSet("http://www.dbunit.org/users.xml"),
>>>>>>  @URLDataSet("file://test/orders.xml") })
>>>>>> public void test1() {
>>>>>>
>>>>>> }
>>>>>>
>>>>>> @FilteredDataSet(value = @URLDataSet("http://www.dbunit.org/users.xml"),
>>>>>> filters = "FROM USERS WHERE ID < 5")
>>>>>>  public void test2() {
>>>>>>
>>>>>> }
>>>>>>
>>>>>> @InlineDataSet(tables= {
>>>>>>  @DataTable(name="invoices",
>>>>>> columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
>>>>>> type="timestamp")},
>>>>>>  rows={@DataRow("1, 25/11/1975"),
>>>>>> @DataRow("2, 25/11/1975"),
>>>>>>  @DataRow("3, 25/11/1975"),
>>>>>> @DataRow("4, 25/11/1975")
>>>>>>  }
>>>>>> ),
>>>>>> @DataTable(name="invoices2",
>>>>>>  columns={@DataColumn(name="id", type="int"),
>>>>>> @DataColumn(name="date", type="timestamp")},
>>>>>> rows={@DataRow("1, 25/11/1975"),
>>>>>>  @DataRow("2, 25/11/1975"),
>>>>>> @DataRow("3, 25/11/1975"),
>>>>>>  @DataRow("4, 25/11/1975")
>>>>>> }
>>>>>> )
>>>>>>  })
>>>>>> public void test3() {
>>>>>>
>>>>>> }
>>>>>> }
>>>>>>
>>>>>>
>>>>>> Obviously names should be changed and many annotations should be
>>>>>> added... I wish to almost replace (if possible) the configuration file with
>>>>>> annotations...
>>>>>>
>>>>>> About having a dataset at class level and one at method level I think
>>>>>> we should apply a default policy of JOIN and let the user decide eventually
>>>>>> to REPLACE or something more complex...
>>>>>>
>>>>>> What do you think about?
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> This SF.net Dev2Dev email is sponsored by:
>>>>>
>>>>> Show off your parallel programming skills.
>>>>> Enter the Intel(R) Threading Challenge 2010.
>>>>> http://p.sf.net/sfu/intel-thread-sfd
>>>>> _______________________________________________
>>>>> dbunit-developer mailing list
>>>>>
>>>>> dbu...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>>>>
>>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> This SF.net Dev2Dev email is sponsored by:
>>>>
>>>> Show off your parallel programming skills.
>>>> Enter the Intel(R) Threading Challenge 2010.
>>>> http://p.sf.net/sfu/intel-thread-sfd
>>>> _______________________________________________
>>>> dbunit-developer mailing list
>>>> dbu...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>>>
>>>>
>>>
>>>
>>> --
>>> Life is interfering with my game
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> This SF.net Dev2Dev email is sponsored by:
>>>
>>> Show off your parallel programming skills.
>>> Enter the Intel(R) Threading Challenge 2010.
>>> http://p.sf.net/sfu/intel-thread-sfd
>>> _______________________________________________
>>> dbunit-developer mailing list
>>> dbu...@li...
>>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>
>
> --
> Life is interfering with my game
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>

Re: [dbunit-developer] Annotations

[John H. <joh...@gm...>]

+1 irc. But ... I am in New Zealand! We're about 12 hours different from
you. :-(

JH

On Fri, Sep 3, 2010 at 11:49 AM, Roberto Lo Giacco <rlo...@gm...>wrote:

>
>
> On Thu, Sep 2, 2010 at 21:19, John Hurst <joh...@gm...> wrote:
>
>> FWIW, I don't consider the dataset to be metadata for the test. I usually
>> consider the test data to be the main focus of the test.
>>
>> If you like, there are two reasons for inline test data approach:
>>
>> 1) Achieve a more tabular representation, which is easier to read.
>> 2) Get the data into the test, rather than have the data away somewhere
>> else in a file hidden somewhere. (As for retrieving data via a URL ... ?!!)
>>
>
> I do not dislike inlining test data, I always wish to have strictly related
> things to be in the same place. If your second point comment goes against
> the url name I gave to the annotation parameter I thought we always had it
> as an URL, but it was strictly a file URL... I do not plan to have remote
> dataset, but I don't see a reason why we shouldn't add such feature as it
> cames almost for free....
>
>
>> Believe it or not, I have tests that contain no "code needed to perform
>> the test" -- they contain only setup data and assertion data! These are for
>> testing non-trivial database views, of which we have quite a number in the
>> applications I'm working on. I've found the inline data approach beautifully
>> concise and clear for testing views.
>>
>
> I consider the assertion statements the "code needed to perform the test"
> while I consider the dataset "the minimum set of datas I need to ensure the
> method under test works correctly"... I know saying they are metadata is not
> completely correct and I see the point to have those datas build and checked
> at compile time... I was trying to define what can be useful as annotation
> and I ended with what I presented to you... it is under discussion, I'm not
> vetoing on that. Do someone see any use of what I named InlineDataSet? If
> not we can drop it and eventually (if any reason will come in the future)
> add it, or it will just stay out...
>
>
>> However, I'm not trying to argue against other representations (too much).
>> Many representations should be supported. We certainly use FlatXmlDataSet
>> plenty too, and it is very useful for many situations. (It's nice to see
>> that some 3rd party libraries, e.g. Jailer, support export to DbUnit's
>> FlatXmlDataSet format.)
>>
>
> I agree, moving toward 3.0 doesn't mean we MUST break with past, we should
> get what worked and redesign what is too old or what is not clean... If we
> should look for something that have not worked I think our search will end
> up with an empty result... dbUnit rocks even if its design is very old. This
> mean the original team did a great work!
>
>
>> Just thoughts, I really need to get coding! I have an all-day soccer
>> tournament for my son this Saturday. I hope my reward will be Sunday
>> programming!
>>
>
> Why don't we schedule a coding remote meeting on an irc channel or other
> communication channel? We could infect each other with ideas....
>
>
>>
>> JH
>>
>> On Fri, Sep 3, 2010 at 12:12 AM, Roberto Lo Giacco <rlo...@gm...>wrote:
>>
>>> The test method is not empty, it will contains the code needed to perform
>>> the test. I can see your point, coding the dataset construction allows
>>> compilation checks, but don't you consider the dataset metadata for the test
>>> method? Well I'm not completely sure I consider them metadata by myself...
>>>
>>> On Thu, Sep 2, 2010 at 13:13, Andres Almiray <aal...@ya...> wrote:
>>>
>>>> FWIW the @InlineDataSet looks sily considering that all the code is
>>>> found in the annotation and the method is empty.
>>>> Here is where I would prefer a builder or a fluent interface design to
>>>> put the code where it belongs (the method) while retaining some readability
>>>> and be expressive.
>>>> The method could retain a simpler version of @InlineDataSet to mark it
>>>> as a special DataSet provider.
>>>>
>>>> Be careful with annotation driven development, there be dragons ;-)
>>>>
>>>> Cheers,
>>>> Andres
>>>>
>>>> ------------------------------
>>>> *From:* Roberto Lo Giacco <rlo...@gm...>
>>>> *To:* dbUnit Developers List <dbu...@li...>
>>>> *Sent:* Thu, September 2, 2010 1:05:05 PM
>>>> *Subject:* Re: [dbunit-developer] Annotations
>>>>
>>>> Some advancement on the topic... I can't stop about this :-)
>>>>
>>>> package org.dbunit.annotations;
>>>>
>>>> import org.dbunit.DatabaseOperation;
>>>> import org.dbunit.DataSet.Format;
>>>> import org.dbunit.annotation.ConnectionDataSet;
>>>> import org.dbunit.annotation.DataSetFilter;
>>>> import org.dbunit.annotation.InlineDataSet;
>>>> import org.dbunit.annotation.TearDownOperation;
>>>> import org.dbunit.annotation.TearUpOperation;
>>>> import org.dbunit.annotation.TestConnection;
>>>> import org.dbunit.annotation.URLDataSet;
>>>> import org.dbunit.annotation.DataSetFilter.Replace;
>>>> import org.dbunit.annotation.InlineDataSet.Column;
>>>> import org.dbunit.annotation.InlineDataSet.Row;
>>>> import org.dbunit.annotation.InlineDataSet.Table;
>>>> import org.dbunit.annotation.TestConnection.Type;
>>>>
>>>> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
>>>> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
>>>> @TearDownOperation(DatabaseOperation.Type.NONE)
>>>> @TearUpOperation(value=DatabaseOperation.Type.CLEAN_INSERT,
>>>> transaction=true)
>>>> public class UsageExample {
>>>>
>>>> @URLDataSet(
>>>>  value={"http://www.dbunit.org/users.xml","file://test/orders.xml"},
>>>>  format=Format.XML)
>>>>  public void multipleURLDataSetWithSameFormat() {
>>>>
>>>> }
>>>>
>>>> @URLDataSet(
>>>>  value={"http://www.dbunit.org/users.xml","orders.csv"},
>>>>  format={Format.XML, Format.CSV})
>>>>  public void multipleURLDataSetWithDifferentFormat() {
>>>>
>>>> }
>>>>  @URLDataSet("http://www.dbunit.org/users.xml")
>>>>  @DataSetFilter(query="FROM USERS WHERE ID < 5")
>>>>  public void filteredDataSet() {
>>>>
>>>> }
>>>>  @URLDataSet(value="http://www.dbunit.org/users.xml", streamed=true)
>>>>  @DataSetFilter(replace=@Replace(orig="<null>", target=Replace.NULL))
>>>>  public void streamedDataSetWithReplacement() {
>>>>
>>>> }
>>>>
>>>> @InlineDataSet(tables= {
>>>>  @Table(name="invoices",
>>>>  columns={@Column(name="id", type="int"), @Column(name="date",
>>>> type="timestamp")},
>>>>  rows={@Row("1, 25/11/1975"),
>>>>  @Row("2, 25/11/1975"),
>>>>  @Row("3, 25/11/1975"),
>>>>  @Row("4, 25/11/1975")
>>>>  }
>>>>  ),
>>>>  @Table(name="invoices2",
>>>>  columns={@Column(name="id", type="int"), @Column(name="date",
>>>> type="timestamp")},
>>>>  rows={@Row("1, 25/11/1975"),
>>>>  @Row("2, 25/11/1975"),
>>>>  @Row("3, 25/11/1975"),
>>>>  @Row("4, 25/11/1975")
>>>>  }
>>>>  )
>>>>  })
>>>>  public void inlineDataSet() {
>>>>
>>>> }
>>>>  @ConnectionDataSet(value=@TestConnection(url="",type=Type.JNDI))
>>>>  public void connectionDataSet() {
>>>>
>>>> }
>>>>  @ConnectionDataSet(value=@TestConnection(url="",type=Type.JDBC),
>>>>  filters=@DataSetFilter(query="SELECT * FROM *"))
>>>>  @DataSetFilter(query="SELECT * FROM users",
>>>> replace=@Replace(orig="<null>", target=Replace.NULL))
>>>>  public void connectionDataSetWithFilter() {
>>>>
>>>> }
>>>> }
>>>>
>>>>
>>>> On Thu, Sep 2, 2010 at 11:04, Roberto Lo Giacco <rlo...@gm...>wrote:
>>>>
>>>>> Here is an example of what I was thinking about introducing annotations
>>>>> in dbUnit...
>>>>>
>>>>> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
>>>>> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
>>>>> public class UsageExample {
>>>>>
>>>>> @MultipleDataSet( { @URLDataSet("http://www.dbunit.org/users.xml"),
>>>>>  @URLDataSet("file://test/orders.xml") })
>>>>> public void test1() {
>>>>>
>>>>> }
>>>>>
>>>>> @FilteredDataSet(value = @URLDataSet("http://www.dbunit.org/users.xml"),
>>>>> filters = "FROM USERS WHERE ID < 5")
>>>>>  public void test2() {
>>>>>
>>>>> }
>>>>>
>>>>> @InlineDataSet(tables= {
>>>>>  @DataTable(name="invoices",
>>>>> columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
>>>>> type="timestamp")},
>>>>>  rows={@DataRow("1, 25/11/1975"),
>>>>> @DataRow("2, 25/11/1975"),
>>>>>  @DataRow("3, 25/11/1975"),
>>>>> @DataRow("4, 25/11/1975")
>>>>>  }
>>>>> ),
>>>>> @DataTable(name="invoices2",
>>>>>  columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
>>>>> type="timestamp")},
>>>>> rows={@DataRow("1, 25/11/1975"),
>>>>>  @DataRow("2, 25/11/1975"),
>>>>> @DataRow("3, 25/11/1975"),
>>>>>  @DataRow("4, 25/11/1975")
>>>>> }
>>>>> )
>>>>>  })
>>>>> public void test3() {
>>>>>
>>>>> }
>>>>> }
>>>>>
>>>>>
>>>>> Obviously names should be changed and many annotations should be
>>>>> added... I wish to almost replace (if possible) the configuration file with
>>>>> annotations...
>>>>>
>>>>> About having a dataset at class level and one at method level I think
>>>>> we should apply a default policy of JOIN and let the user decide eventually
>>>>> to REPLACE or something more complex...
>>>>>
>>>>> What do you think about?
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> This SF.net Dev2Dev email is sponsored by:
>>>>
>>>> Show off your parallel programming skills.
>>>> Enter the Intel(R) Threading Challenge 2010.
>>>> http://p.sf.net/sfu/intel-thread-sfd
>>>> _______________________________________________
>>>> dbunit-developer mailing list
>>>>
>>>> dbu...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>>>
>>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> This SF.net Dev2Dev email is sponsored by:
>>>
>>> Show off your parallel programming skills.
>>> Enter the Intel(R) Threading Challenge 2010.
>>> http://p.sf.net/sfu/intel-thread-sfd
>>> _______________________________________________
>>> dbunit-developer mailing list
>>> dbu...@li...
>>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>>
>>>
>>
>>
>> --
>> Life is interfering with my game
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>


-- 
Life is interfering with my game

Re: [dbunit-developer] Annotations

[Roberto Lo G. <rlo...@gm...>]

On Thu, Sep 2, 2010 at 21:19, John Hurst <joh...@gm...> wrote:

> FWIW, I don't consider the dataset to be metadata for the test. I usually
> consider the test data to be the main focus of the test.
>
> If you like, there are two reasons for inline test data approach:
>
> 1) Achieve a more tabular representation, which is easier to read.
> 2) Get the data into the test, rather than have the data away somewhere
> else in a file hidden somewhere. (As for retrieving data via a URL ... ?!!)
>

I do not dislike inlining test data, I always wish to have strictly related
things to be in the same place. If your second point comment goes against
the url name I gave to the annotation parameter I thought we always had it
as an URL, but it was strictly a file URL... I do not plan to have remote
dataset, but I don't see a reason why we shouldn't add such feature as it
cames almost for free....


> Believe it or not, I have tests that contain no "code needed to perform the
> test" -- they contain only setup data and assertion data! These are for
> testing non-trivial database views, of which we have quite a number in the
> applications I'm working on. I've found the inline data approach beautifully
> concise and clear for testing views.
>

I consider the assertion statements the "code needed to perform the test"
while I consider the dataset "the minimum set of datas I need to ensure the
method under test works correctly"... I know saying they are metadata is not
completely correct and I see the point to have those datas build and checked
at compile time... I was trying to define what can be useful as annotation
and I ended with what I presented to you... it is under discussion, I'm not
vetoing on that. Do someone see any use of what I named InlineDataSet? If
not we can drop it and eventually (if any reason will come in the future)
add it, or it will just stay out...


> However, I'm not trying to argue against other representations (too much).
> Many representations should be supported. We certainly use FlatXmlDataSet
> plenty too, and it is very useful for many situations. (It's nice to see
> that some 3rd party libraries, e.g. Jailer, support export to DbUnit's
> FlatXmlDataSet format.)
>

I agree, moving toward 3.0 doesn't mean we MUST break with past, we should
get what worked and redesign what is too old or what is not clean... If we
should look for something that have not worked I think our search will end
up with an empty result... dbUnit rocks even if its design is very old. This
mean the original team did a great work!


> Just thoughts, I really need to get coding! I have an all-day soccer
> tournament for my son this Saturday. I hope my reward will be Sunday
> programming!
>

Why don't we schedule a coding remote meeting on an irc channel or other
communication channel? We could infect each other with ideas....


>
> JH
>
> On Fri, Sep 3, 2010 at 12:12 AM, Roberto Lo Giacco <rlo...@gm...>wrote:
>
>> The test method is not empty, it will contains the code needed to perform
>> the test. I can see your point, coding the dataset construction allows
>> compilation checks, but don't you consider the dataset metadata for the test
>> method? Well I'm not completely sure I consider them metadata by myself...
>>
>> On Thu, Sep 2, 2010 at 13:13, Andres Almiray <aal...@ya...> wrote:
>>
>>> FWIW the @InlineDataSet looks sily considering that all the code is found
>>> in the annotation and the method is empty.
>>> Here is where I would prefer a builder or a fluent interface design to
>>> put the code where it belongs (the method) while retaining some readability
>>> and be expressive.
>>> The method could retain a simpler version of @InlineDataSet to mark it as
>>> a special DataSet provider.
>>>
>>> Be careful with annotation driven development, there be dragons ;-)
>>>
>>> Cheers,
>>> Andres
>>>
>>> ------------------------------
>>> *From:* Roberto Lo Giacco <rlo...@gm...>
>>> *To:* dbUnit Developers List <dbu...@li...>
>>> *Sent:* Thu, September 2, 2010 1:05:05 PM
>>> *Subject:* Re: [dbunit-developer] Annotations
>>>
>>> Some advancement on the topic... I can't stop about this :-)
>>>
>>> package org.dbunit.annotations;
>>>
>>> import org.dbunit.DatabaseOperation;
>>> import org.dbunit.DataSet.Format;
>>> import org.dbunit.annotation.ConnectionDataSet;
>>> import org.dbunit.annotation.DataSetFilter;
>>> import org.dbunit.annotation.InlineDataSet;
>>> import org.dbunit.annotation.TearDownOperation;
>>> import org.dbunit.annotation.TearUpOperation;
>>> import org.dbunit.annotation.TestConnection;
>>> import org.dbunit.annotation.URLDataSet;
>>> import org.dbunit.annotation.DataSetFilter.Replace;
>>> import org.dbunit.annotation.InlineDataSet.Column;
>>> import org.dbunit.annotation.InlineDataSet.Row;
>>> import org.dbunit.annotation.InlineDataSet.Table;
>>> import org.dbunit.annotation.TestConnection.Type;
>>>
>>> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
>>> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
>>> @TearDownOperation(DatabaseOperation.Type.NONE)
>>> @TearUpOperation(value=DatabaseOperation.Type.CLEAN_INSERT,
>>> transaction=true)
>>> public class UsageExample {
>>>
>>> @URLDataSet(
>>>  value={"http://www.dbunit.org/users.xml","file://test/orders.xml"},
>>>  format=Format.XML)
>>>  public void multipleURLDataSetWithSameFormat() {
>>>
>>> }
>>>
>>> @URLDataSet(
>>>  value={"http://www.dbunit.org/users.xml","orders.csv"},
>>>  format={Format.XML, Format.CSV})
>>>  public void multipleURLDataSetWithDifferentFormat() {
>>>
>>> }
>>>  @URLDataSet("http://www.dbunit.org/users.xml")
>>>  @DataSetFilter(query="FROM USERS WHERE ID < 5")
>>>  public void filteredDataSet() {
>>>
>>> }
>>>  @URLDataSet(value="http://www.dbunit.org/users.xml", streamed=true)
>>>  @DataSetFilter(replace=@Replace(orig="<null>", target=Replace.NULL))
>>>  public void streamedDataSetWithReplacement() {
>>>
>>> }
>>>
>>> @InlineDataSet(tables= {
>>>  @Table(name="invoices",
>>>  columns={@Column(name="id", type="int"), @Column(name="date",
>>> type="timestamp")},
>>>  rows={@Row("1, 25/11/1975"),
>>>  @Row("2, 25/11/1975"),
>>>  @Row("3, 25/11/1975"),
>>>  @Row("4, 25/11/1975")
>>>  }
>>>  ),
>>>  @Table(name="invoices2",
>>>  columns={@Column(name="id", type="int"), @Column(name="date",
>>> type="timestamp")},
>>>  rows={@Row("1, 25/11/1975"),
>>>  @Row("2, 25/11/1975"),
>>>  @Row("3, 25/11/1975"),
>>>  @Row("4, 25/11/1975")
>>>  }
>>>  )
>>>  })
>>>  public void inlineDataSet() {
>>>
>>> }
>>>  @ConnectionDataSet(value=@TestConnection(url="",type=Type.JNDI))
>>>  public void connectionDataSet() {
>>>
>>> }
>>>  @ConnectionDataSet(value=@TestConnection(url="",type=Type.JDBC),
>>>  filters=@DataSetFilter(query="SELECT * FROM *"))
>>>  @DataSetFilter(query="SELECT * FROM users",
>>> replace=@Replace(orig="<null>", target=Replace.NULL))
>>>  public void connectionDataSetWithFilter() {
>>>
>>> }
>>> }
>>>
>>>
>>> On Thu, Sep 2, 2010 at 11:04, Roberto Lo Giacco <rlo...@gm...>wrote:
>>>
>>>> Here is an example of what I was thinking about introducing annotations
>>>> in dbUnit...
>>>>
>>>> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
>>>> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
>>>> public class UsageExample {
>>>>
>>>> @MultipleDataSet( { @URLDataSet("http://www.dbunit.org/users.xml"),
>>>>  @URLDataSet("file://test/orders.xml") })
>>>> public void test1() {
>>>>
>>>> }
>>>>
>>>> @FilteredDataSet(value = @URLDataSet("http://www.dbunit.org/users.xml"),
>>>> filters = "FROM USERS WHERE ID < 5")
>>>>  public void test2() {
>>>>
>>>> }
>>>>
>>>> @InlineDataSet(tables= {
>>>>  @DataTable(name="invoices",
>>>> columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
>>>> type="timestamp")},
>>>>  rows={@DataRow("1, 25/11/1975"),
>>>> @DataRow("2, 25/11/1975"),
>>>>  @DataRow("3, 25/11/1975"),
>>>> @DataRow("4, 25/11/1975")
>>>>  }
>>>> ),
>>>> @DataTable(name="invoices2",
>>>>  columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
>>>> type="timestamp")},
>>>> rows={@DataRow("1, 25/11/1975"),
>>>>  @DataRow("2, 25/11/1975"),
>>>> @DataRow("3, 25/11/1975"),
>>>>  @DataRow("4, 25/11/1975")
>>>> }
>>>> )
>>>>  })
>>>> public void test3() {
>>>>
>>>> }
>>>> }
>>>>
>>>>
>>>> Obviously names should be changed and many annotations should be
>>>> added... I wish to almost replace (if possible) the configuration file with
>>>> annotations...
>>>>
>>>> About having a dataset at class level and one at method level I think we
>>>> should apply a default policy of JOIN and let the user decide eventually to
>>>> REPLACE or something more complex...
>>>>
>>>> What do you think about?
>>>>
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> This SF.net Dev2Dev email is sponsored by:
>>>
>>> Show off your parallel programming skills.
>>> Enter the Intel(R) Threading Challenge 2010.
>>> http://p.sf.net/sfu/intel-thread-sfd
>>> _______________________________________________
>>> dbunit-developer mailing list
>>>
>>> dbu...@li...
>>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>
>
> --
> Life is interfering with my game
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>

Re: [dbunit-developer] Annotations

[John H. <joh...@gm...>]

FWIW, I don't consider the dataset to be metadata for the test. I usually
consider the test data to be the main focus of the test.

If you like, there are two reasons for inline test data approach:

1) Achieve a more tabular representation, which is easier to read.
2) Get the data into the test, rather than have the data away somewhere else
in a file hidden somewhere. (As for retrieving data via a URL ... ?!!)

Believe it or not, I have tests that contain no "code needed to perform the
test" -- they contain only setup data and assertion data! These are for
testing non-trivial database views, of which we have quite a number in the
applications I'm working on. I've found the inline data approach beautifully
concise and clear for testing views.

However, I'm not trying to argue against other representations (too much).
Many representations should be supported. We certainly use FlatXmlDataSet
plenty too, and it is very useful for many situations. (It's nice to see
that some 3rd party libraries, e.g. Jailer, support export to DbUnit's
FlatXmlDataSet format.)

Just thoughts, I really need to get coding! I have an all-day soccer
tournament for my son this Saturday. I hope my reward will be Sunday
programming!

JH

On Fri, Sep 3, 2010 at 12:12 AM, Roberto Lo Giacco <rlo...@gm...>wrote:

> The test method is not empty, it will contains the code needed to perform
> the test. I can see your point, coding the dataset construction allows
> compilation checks, but don't you consider the dataset metadata for the test
> method? Well I'm not completely sure I consider them metadata by myself...
>
> On Thu, Sep 2, 2010 at 13:13, Andres Almiray <aal...@ya...> wrote:
>
>> FWIW the @InlineDataSet looks sily considering that all the code is found
>> in the annotation and the method is empty.
>> Here is where I would prefer a builder or a fluent interface design to put
>> the code where it belongs (the method) while retaining some readability and
>> be expressive.
>> The method could retain a simpler version of @InlineDataSet to mark it as
>> a special DataSet provider.
>>
>> Be careful with annotation driven development, there be dragons ;-)
>>
>> Cheers,
>> Andres
>>
>> ------------------------------
>> *From:* Roberto Lo Giacco <rlo...@gm...>
>> *To:* dbUnit Developers List <dbu...@li...>
>> *Sent:* Thu, September 2, 2010 1:05:05 PM
>> *Subject:* Re: [dbunit-developer] Annotations
>>
>> Some advancement on the topic... I can't stop about this :-)
>>
>> package org.dbunit.annotations;
>>
>> import org.dbunit.DatabaseOperation;
>> import org.dbunit.DataSet.Format;
>> import org.dbunit.annotation.ConnectionDataSet;
>> import org.dbunit.annotation.DataSetFilter;
>> import org.dbunit.annotation.InlineDataSet;
>> import org.dbunit.annotation.TearDownOperation;
>> import org.dbunit.annotation.TearUpOperation;
>> import org.dbunit.annotation.TestConnection;
>> import org.dbunit.annotation.URLDataSet;
>> import org.dbunit.annotation.DataSetFilter.Replace;
>> import org.dbunit.annotation.InlineDataSet.Column;
>> import org.dbunit.annotation.InlineDataSet.Row;
>> import org.dbunit.annotation.InlineDataSet.Table;
>> import org.dbunit.annotation.TestConnection.Type;
>>
>> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
>> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
>> @TearDownOperation(DatabaseOperation.Type.NONE)
>> @TearUpOperation(value=DatabaseOperation.Type.CLEAN_INSERT,
>> transaction=true)
>> public class UsageExample {
>>
>> @URLDataSet(
>>  value={"http://www.dbunit.org/users.xml","file://test/orders.xml"},
>>  format=Format.XML)
>>  public void multipleURLDataSetWithSameFormat() {
>>
>> }
>>
>> @URLDataSet(
>>  value={"http://www.dbunit.org/users.xml","orders.csv"},
>>  format={Format.XML, Format.CSV})
>>  public void multipleURLDataSetWithDifferentFormat() {
>>
>> }
>>  @URLDataSet("http://www.dbunit.org/users.xml")
>>  @DataSetFilter(query="FROM USERS WHERE ID < 5")
>>  public void filteredDataSet() {
>>
>> }
>>  @URLDataSet(value="http://www.dbunit.org/users.xml", streamed=true)
>>  @DataSetFilter(replace=@Replace(orig="<null>", target=Replace.NULL))
>>  public void streamedDataSetWithReplacement() {
>>
>> }
>>
>> @InlineDataSet(tables= {
>>  @Table(name="invoices",
>>  columns={@Column(name="id", type="int"), @Column(name="date",
>> type="timestamp")},
>>  rows={@Row("1, 25/11/1975"),
>>  @Row("2, 25/11/1975"),
>>  @Row("3, 25/11/1975"),
>>  @Row("4, 25/11/1975")
>>  }
>>  ),
>>  @Table(name="invoices2",
>>  columns={@Column(name="id", type="int"), @Column(name="date",
>> type="timestamp")},
>>  rows={@Row("1, 25/11/1975"),
>>  @Row("2, 25/11/1975"),
>>  @Row("3, 25/11/1975"),
>>  @Row("4, 25/11/1975")
>>  }
>>  )
>>  })
>>  public void inlineDataSet() {
>>
>> }
>>  @ConnectionDataSet(value=@TestConnection(url="",type=Type.JNDI))
>>  public void connectionDataSet() {
>>
>> }
>>  @ConnectionDataSet(value=@TestConnection(url="",type=Type.JDBC),
>>  filters=@DataSetFilter(query="SELECT * FROM *"))
>>  @DataSetFilter(query="SELECT * FROM users",
>> replace=@Replace(orig="<null>", target=Replace.NULL))
>>  public void connectionDataSetWithFilter() {
>>
>> }
>> }
>>
>>
>> On Thu, Sep 2, 2010 at 11:04, Roberto Lo Giacco <rlo...@gm...>wrote:
>>
>>> Here is an example of what I was thinking about introducing annotations
>>> in dbUnit...
>>>
>>> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
>>> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
>>> public class UsageExample {
>>>
>>> @MultipleDataSet( { @URLDataSet("http://www.dbunit.org/users.xml"),
>>>  @URLDataSet("file://test/orders.xml") })
>>> public void test1() {
>>>
>>> }
>>>
>>> @FilteredDataSet(value = @URLDataSet("http://www.dbunit.org/users.xml"),
>>> filters = "FROM USERS WHERE ID < 5")
>>>  public void test2() {
>>>
>>> }
>>>
>>> @InlineDataSet(tables= {
>>>  @DataTable(name="invoices",
>>> columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
>>> type="timestamp")},
>>>  rows={@DataRow("1, 25/11/1975"),
>>> @DataRow("2, 25/11/1975"),
>>>  @DataRow("3, 25/11/1975"),
>>> @DataRow("4, 25/11/1975")
>>>  }
>>> ),
>>> @DataTable(name="invoices2",
>>>  columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
>>> type="timestamp")},
>>> rows={@DataRow("1, 25/11/1975"),
>>>  @DataRow("2, 25/11/1975"),
>>> @DataRow("3, 25/11/1975"),
>>>  @DataRow("4, 25/11/1975")
>>> }
>>> )
>>>  })
>>> public void test3() {
>>>
>>> }
>>> }
>>>
>>>
>>> Obviously names should be changed and many annotations should be added...
>>> I wish to almost replace (if possible) the configuration file with
>>> annotations...
>>>
>>> About having a dataset at class level and one at method level I think we
>>> should apply a default policy of JOIN and let the user decide eventually to
>>> REPLACE or something more complex...
>>>
>>> What do you think about?
>>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>>
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>


-- 
Life is interfering with my game

Re: [dbunit-developer] Annotations

[Roberto Lo G. <rlo...@gm...>]

The test method is not empty, it will contains the code needed to perform
the test. I can see your point, coding the dataset construction allows
compilation checks, but don't you consider the dataset metadata for the test
method? Well I'm not completely sure I consider them metadata by myself...

On Thu, Sep 2, 2010 at 13:13, Andres Almiray <aal...@ya...> wrote:

> FWIW the @InlineDataSet looks sily considering that all the code is found
> in the annotation and the method is empty.
> Here is where I would prefer a builder or a fluent interface design to put
> the code where it belongs (the method) while retaining some readability and
> be expressive.
> The method could retain a simpler version of @InlineDataSet to mark it as a
> special DataSet provider.
>
> Be careful with annotation driven development, there be dragons ;-)
>
> Cheers,
> Andres
>
> ------------------------------
> *From:* Roberto Lo Giacco <rlo...@gm...>
> *To:* dbUnit Developers List <dbu...@li...>
> *Sent:* Thu, September 2, 2010 1:05:05 PM
> *Subject:* Re: [dbunit-developer] Annotations
>
> Some advancement on the topic... I can't stop about this :-)
>
> package org.dbunit.annotations;
>
> import org.dbunit.DatabaseOperation;
> import org.dbunit.DataSet.Format;
> import org.dbunit.annotation.ConnectionDataSet;
> import org.dbunit.annotation.DataSetFilter;
> import org.dbunit.annotation.InlineDataSet;
> import org.dbunit.annotation.TearDownOperation;
> import org.dbunit.annotation.TearUpOperation;
> import org.dbunit.annotation.TestConnection;
> import org.dbunit.annotation.URLDataSet;
> import org.dbunit.annotation.DataSetFilter.Replace;
> import org.dbunit.annotation.InlineDataSet.Column;
> import org.dbunit.annotation.InlineDataSet.Row;
> import org.dbunit.annotation.InlineDataSet.Table;
> import org.dbunit.annotation.TestConnection.Type;
>
> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
> @TearDownOperation(DatabaseOperation.Type.NONE)
> @TearUpOperation(value=DatabaseOperation.Type.CLEAN_INSERT,
> transaction=true)
> public class UsageExample {
>
> @URLDataSet(
>  value={"http://www.dbunit.org/users.xml","file://test/orders.xml"},
>  format=Format.XML)
>  public void multipleURLDataSetWithSameFormat() {
>
> }
>
> @URLDataSet(
>  value={"http://www.dbunit.org/users.xml","orders.csv"},
>  format={Format.XML, Format.CSV})
>  public void multipleURLDataSetWithDifferentFormat() {
>
> }
>  @URLDataSet("http://www.dbunit.org/users.xml")
>  @DataSetFilter(query="FROM USERS WHERE ID < 5")
>  public void filteredDataSet() {
>
> }
>  @URLDataSet(value="http://www.dbunit.org/users.xml", streamed=true)
>  @DataSetFilter(replace=@Replace(orig="<null>", target=Replace.NULL))
>  public void streamedDataSetWithReplacement() {
>
> }
>
> @InlineDataSet(tables= {
>  @Table(name="invoices",
>  columns={@Column(name="id", type="int"), @Column(name="date",
> type="timestamp")},
>  rows={@Row("1, 25/11/1975"),
>  @Row("2, 25/11/1975"),
>  @Row("3, 25/11/1975"),
>  @Row("4, 25/11/1975")
>  }
>  ),
>  @Table(name="invoices2",
>  columns={@Column(name="id", type="int"), @Column(name="date",
> type="timestamp")},
>  rows={@Row("1, 25/11/1975"),
>  @Row("2, 25/11/1975"),
>  @Row("3, 25/11/1975"),
>  @Row("4, 25/11/1975")
>  }
>  )
>  })
>  public void inlineDataSet() {
>
> }
>  @ConnectionDataSet(value=@TestConnection(url="",type=Type.JNDI))
>  public void connectionDataSet() {
>
> }
>  @ConnectionDataSet(value=@TestConnection(url="",type=Type.JDBC),
>  filters=@DataSetFilter(query="SELECT * FROM *"))
>  @DataSetFilter(query="SELECT * FROM users",
> replace=@Replace(orig="<null>", target=Replace.NULL))
>  public void connectionDataSetWithFilter() {
>
> }
> }
>
>
> On Thu, Sep 2, 2010 at 11:04, Roberto Lo Giacco <rlo...@gm...>wrote:
>
>> Here is an example of what I was thinking about introducing annotations in
>> dbUnit...
>>
>> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
>> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
>> public class UsageExample {
>>
>> @MultipleDataSet( { @URLDataSet("http://www.dbunit.org/users.xml"),
>>  @URLDataSet("file://test/orders.xml") })
>> public void test1() {
>>
>> }
>>
>> @FilteredDataSet(value = @URLDataSet("http://www.dbunit.org/users.xml"),
>> filters = "FROM USERS WHERE ID < 5")
>>  public void test2() {
>>
>> }
>>
>> @InlineDataSet(tables= {
>>  @DataTable(name="invoices",
>> columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
>> type="timestamp")},
>>  rows={@DataRow("1, 25/11/1975"),
>> @DataRow("2, 25/11/1975"),
>>  @DataRow("3, 25/11/1975"),
>> @DataRow("4, 25/11/1975")
>>  }
>> ),
>> @DataTable(name="invoices2",
>>  columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
>> type="timestamp")},
>> rows={@DataRow("1, 25/11/1975"),
>>  @DataRow("2, 25/11/1975"),
>> @DataRow("3, 25/11/1975"),
>>  @DataRow("4, 25/11/1975")
>> }
>> )
>>  })
>> public void test3() {
>>
>> }
>> }
>>
>>
>> Obviously names should be changed and many annotations should be added...
>> I wish to almost replace (if possible) the configuration file with
>> annotations...
>>
>> About having a dataset at class level and one at method level I think we
>> should apply a default policy of JOIN and let the user decide eventually to
>> REPLACE or something more complex...
>>
>> What do you think about?
>>
>
>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>

Re: [dbunit-developer] Annotations

[Andres A. <aal...@ya...>]

FWIW the @InlineDataSet looks sily considering that all the code is found in the 
annotation and the method is empty.
Here is where I would prefer a builder or a fluent interface design to put the 
code where it belongs (the method) while retaining some readability and be 
expressive.
The method could retain a simpler version of @InlineDataSet to mark it as a 
special DataSet provider.

Be careful with annotation driven development, there be dragons ;-)

Cheers,
Andres



________________________________
From: Roberto Lo Giacco <rlo...@gm...>
To: dbUnit Developers List <dbu...@li...>
Sent: Thu, September 2, 2010 1:05:05 PM
Subject: Re: [dbunit-developer] Annotations

Some advancement on the topic... I can't stop about this :-)

package org.dbunit.annotations;

import org.dbunit.DatabaseOperation;
import org.dbunit.DataSet.Format;
import org.dbunit.annotation.ConnectionDataSet;
import org.dbunit.annotation.DataSetFilter;
import org.dbunit.annotation.InlineDataSet;
import org.dbunit.annotation.TearDownOperation;
import org.dbunit.annotation.TearUpOperation;
import org.dbunit.annotation.TestConnection;
import org.dbunit.annotation.URLDataSet;
import org.dbunit.annotation.DataSetFilter.Replace;
import org.dbunit.annotation.InlineDataSet.Column;
import org.dbunit.annotation.InlineDataSet.Row;
import org.dbunit.annotation.InlineDataSet.Table;
import org.dbunit.annotation.TestConnection.Type;

@TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
@URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
@TearDownOperation(DatabaseOperation.Type.NONE)
@TearUpOperation(value=DatabaseOperation.Type.CLEAN_INSERT, transaction=true)
public class UsageExample {

@URLDataSet(
value={"http://www.dbunit.org/users.xml","file://test/orders.xml"}, 
format=Format.XML)
public void multipleURLDataSetWithSameFormat() {

}

@URLDataSet(
value={"http://www.dbunit.org/users.xml","orders.csv"}, 
format={Format.XML, Format.CSV})
public void multipleURLDataSetWithDifferentFormat() {

}
@URLDataSet("http://www.dbunit.org/users.xml")
@DataSetFilter(query="FROM USERS WHERE ID < 5")
public void filteredDataSet() {

}
@URLDataSet(value="http://www.dbunit.org/users.xml", streamed=true)
@DataSetFilter(replace=@Replace(orig="<null>", target=Replace.NULL))
public void streamedDataSetWithReplacement() {

}

@InlineDataSet(tables= {
@Table(name="invoices", 
columns={@Column(name="id", type="int"), @Column(name="date", 
type="timestamp")}, 
rows={@Row("1, 25/11/1975"),
@Row("2, 25/11/1975"),
@Row("3, 25/11/1975"),
@Row("4, 25/11/1975")
}
),
@Table(name="invoices2", 
columns={@Column(name="id", type="int"), @Column(name="date", 
type="timestamp")}, 
rows={@Row("1, 25/11/1975"),
@Row("2, 25/11/1975"),
@Row("3, 25/11/1975"),
@Row("4, 25/11/1975")
}
)
})
public void inlineDataSet() {

}
@ConnectionDataSet(value=@TestConnection(url="",type=Type.JNDI))
public void connectionDataSet() {

}
@ConnectionDataSet(value=@TestConnection(url="",type=Type.JDBC),
filters=@DataSetFilter(query="SELECT * FROM *"))
@DataSetFilter(query="SELECT * FROM users", replace=@Replace(orig="<null>", 
target=Replace.NULL))
public void connectionDataSetWithFilter() {

}
}


On Thu, Sep 2, 2010 at 11:04, Roberto Lo Giacco <rlo...@gm...> wrote:

Here is an example of what I was thinking about introducing annotations in 
dbUnit...
>
>
>@TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
>@URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
>public class UsageExample {
>
>
>@MultipleDataSet( { @URLDataSet("http://www.dbunit.org/users.xml"),
>@URLDataSet("file://test/orders.xml") })
>public void test1() {
>
>
>}
>
>
>@FilteredDataSet(value = @URLDataSet("http://www.dbunit.org/users.xml"), filters 
>= "FROM USERS WHERE ID < 5")
>public void test2() {
>
>
>}
>
>
>@InlineDataSet(tables= {
>@DataTable(name="invoices", 
>columns={@DataColumn(name="id", type="int"), @DataColumn(name="date", 
>type="timestamp")}, 
>rows={@DataRow("1, 25/11/1975"),
>@DataRow("2, 25/11/1975"),
>@DataRow("3, 25/11/1975"),
>@DataRow("4, 25/11/1975")
>}
>),
>@DataTable(name="invoices2", 
>columns={@DataColumn(name="id", type="int"), @DataColumn(name="date", 
>type="timestamp")}, 
>rows={@DataRow("1, 25/11/1975"),
>@DataRow("2, 25/11/1975"),
>@DataRow("3, 25/11/1975"),
>@DataRow("4, 25/11/1975")
>}
>)
>})
>public void test3() {
>
>
>}
>}
>
>
>
>
>Obviously names should be changed and many annotations should be added... I wish 
>to almost replace (if possible) the configuration file with annotations...
>
>
>About having a dataset at class level and one at method level I think we should 
>apply a default policy of JOIN and let the user decide eventually to REPLACE or 
>something more complex...
>
>
>What do you think about?



      

Re: [dbunit-developer] Annotations

[Roberto Lo G. <rlo...@gm...>]

Some advancement on the topic... I can't stop about this :-)

package org.dbunit.annotations;

import org.dbunit.DatabaseOperation;
import org.dbunit.DataSet.Format;
import org.dbunit.annotation.ConnectionDataSet;
import org.dbunit.annotation.DataSetFilter;
import org.dbunit.annotation.InlineDataSet;
import org.dbunit.annotation.TearDownOperation;
import org.dbunit.annotation.TearUpOperation;
import org.dbunit.annotation.TestConnection;
import org.dbunit.annotation.URLDataSet;
import org.dbunit.annotation.DataSetFilter.Replace;
import org.dbunit.annotation.InlineDataSet.Column;
import org.dbunit.annotation.InlineDataSet.Row;
import org.dbunit.annotation.InlineDataSet.Table;
import org.dbunit.annotation.TestConnection.Type;

@TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
@URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
@TearDownOperation(DatabaseOperation.Type.NONE)
@TearUpOperation(value=DatabaseOperation.Type.CLEAN_INSERT,
transaction=true)
public class UsageExample {

@URLDataSet(
 value={"http://www.dbunit.org/users.xml","file://test/orders.xml"},
 format=Format.XML)
 public void multipleURLDataSetWithSameFormat() {

}

@URLDataSet(
 value={"http://www.dbunit.org/users.xml","orders.csv"},
 format={Format.XML, Format.CSV})
 public void multipleURLDataSetWithDifferentFormat() {

}
 @URLDataSet("http://www.dbunit.org/users.xml")
 @DataSetFilter(query="FROM USERS WHERE ID < 5")
 public void filteredDataSet() {

}
 @URLDataSet(value="http://www.dbunit.org/users.xml", streamed=true)
 @DataSetFilter(replace=@Replace(orig="<null>", target=Replace.NULL))
 public void streamedDataSetWithReplacement() {

}

@InlineDataSet(tables= {
 @Table(name="invoices",
 columns={@Column(name="id", type="int"), @Column(name="date",
type="timestamp")},
 rows={@Row("1, 25/11/1975"),
 @Row("2, 25/11/1975"),
 @Row("3, 25/11/1975"),
 @Row("4, 25/11/1975")
 }
 ),
 @Table(name="invoices2",
 columns={@Column(name="id", type="int"), @Column(name="date",
type="timestamp")},
 rows={@Row("1, 25/11/1975"),
 @Row("2, 25/11/1975"),
 @Row("3, 25/11/1975"),
 @Row("4, 25/11/1975")
 }
 )
 })
 public void inlineDataSet() {

}
 @ConnectionDataSet(value=@TestConnection(url="",type=Type.JNDI))
 public void connectionDataSet() {

}
 @ConnectionDataSet(value=@TestConnection(url="",type=Type.JDBC),
 filters=@DataSetFilter(query="SELECT * FROM *"))
 @DataSetFilter(query="SELECT * FROM users", replace=@Replace(orig="<null>",
target=Replace.NULL))
 public void connectionDataSetWithFilter() {

}
}


On Thu, Sep 2, 2010 at 11:04, Roberto Lo Giacco <rlo...@gm...> wrote:

> Here is an example of what I was thinking about introducing annotations in
> dbUnit...
>
> @TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
> @URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
> public class UsageExample {
>
> @MultipleDataSet( { @URLDataSet("http://www.dbunit.org/users.xml"),
>  @URLDataSet("file://test/orders.xml") })
> public void test1() {
>
> }
>
> @FilteredDataSet(value = @URLDataSet("http://www.dbunit.org/users.xml"),
> filters = "FROM USERS WHERE ID < 5")
>  public void test2() {
>
> }
>
> @InlineDataSet(tables= {
>  @DataTable(name="invoices",
> columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
> type="timestamp")},
>  rows={@DataRow("1, 25/11/1975"),
> @DataRow("2, 25/11/1975"),
>  @DataRow("3, 25/11/1975"),
> @DataRow("4, 25/11/1975")
>  }
> ),
> @DataTable(name="invoices2",
>  columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
> type="timestamp")},
> rows={@DataRow("1, 25/11/1975"),
>  @DataRow("2, 25/11/1975"),
> @DataRow("3, 25/11/1975"),
>  @DataRow("4, 25/11/1975")
> }
> )
>  })
> public void test3() {
>
> }
> }
>
>
> Obviously names should be changed and many annotations should be added... I
> wish to almost replace (if possible) the configuration file with
> annotations...
>
> About having a dataset at class level and one at method level I think we
> should apply a default policy of JOIN and let the user decide eventually to
> REPLACE or something more complex...
>
> What do you think about?
>

Re: [dbunit-developer] dbUnit 2.4.8 (stable) is out!

[Roberto Lo G. <rlo...@gm...>]

My pleasure ;-)

On Thu, Sep 2, 2010 at 05:05, Jeff Jensen <jj...@ap...> wrote:

>  Thanks for getting it out, Roberto!
>
>
>
>
>
> *From:* Roberto Lo Giacco [mailto:rlo...@gm...]
> *Sent:* Wednesday, September 01, 2010 5:49 PM
> *To:* dbUnit Developers List
> *Subject:* [dbunit-developer] dbUnit 2.4.8 (stable) is out!
>
>
>
> The dbUnit team is pleased to announce the dbunit-2.4.8 release!
>
>
>
> For a manual installation, you can download the dbunit-2.4.8 here:
>
> http://sourceforge.net/project/showfiles.php?group_id=47439
>
>
>
> Have fun!
>
>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>

[dbunit-developer] Annotations

[Roberto Lo G. <rlo...@gm...>]

Here is an example of what I was thinking about introducing annotations in
dbUnit...

@TestConnection(url = "jdbc:", type = TestConnection.Type.JDBC)
@URLDataSet(value = "invoice.xml", format = Format.FLAT_XML)
public class UsageExample {

@MultipleDataSet( { @URLDataSet("http://www.dbunit.org/users.xml"),
 @URLDataSet("file://test/orders.xml") })
public void test1() {

}

@FilteredDataSet(value = @URLDataSet("http://www.dbunit.org/users.xml"),
filters = "FROM USERS WHERE ID < 5")
 public void test2() {

}

@InlineDataSet(tables= {
 @DataTable(name="invoices",
columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
type="timestamp")},
 rows={@DataRow("1, 25/11/1975"),
@DataRow("2, 25/11/1975"),
 @DataRow("3, 25/11/1975"),
@DataRow("4, 25/11/1975")
 }
),
@DataTable(name="invoices2",
 columns={@DataColumn(name="id", type="int"), @DataColumn(name="date",
type="timestamp")},
rows={@DataRow("1, 25/11/1975"),
 @DataRow("2, 25/11/1975"),
@DataRow("3, 25/11/1975"),
 @DataRow("4, 25/11/1975")
}
)
 })
public void test3() {

}
}


Obviously names should be changed and many annotations should be added... I
wish to almost replace (if possible) the configuration file with
annotations...

About having a dataset at class level and one at method level I think we
should apply a default policy of JOIN and let the user decide eventually to
REPLACE or something more complex...

What do you think about?

[dbunit-developer] CTX format

[John H. <joh...@gm...>]

Roberto,

Indeed this does look very interesting. I will probably take a longer look
at this soon and perhaps try to code up support for this for DbUnit.

One thing I'd like to know is whether fields can be aligned using this
format. He gives the example:

1|Smythe|Jane
2|Doe|John
3|Mellonhead|Creg

I would rather put this like so:

1|Smythe    |Jane
2|Doe       |John
3|Mellonhead|Creg

(Probably doesn't come out right in non-monospaced font.)

Question is whether CTX requires readers to treat leading/trailing
whitespace as significant, or whether readers can choose to ignore it. I
suppose a DbUnit dataset based on CTX could have an option to control
whether leading/trailing whitespace would be ignored.

I like the ability to put multiple tables in one chunk, and also the ability
to put further metadata. This really gets around the basic limits of CSV
while preserving its strength.

Thanks for the link!

John Hurst

On Thu, Sep 2, 2010 at 7:11 PM, Roberto Lo Giacco <rlo...@gm...>wrote:

> What about CTX (http://www.creativyst.com/Doc/Std/ctx/ctx.htm) as an
> alternative to CSV? I do not even know if it's a standard or if a Java
> access library already exists, but it looks interesting... I think it's
> worth you have a read.
>
>
> On Thu, Sep 2, 2010 at 08:37, Zdeněk Vráblík <zd...@vr...> wrote:
>
>> John,
>>
>> I am not a Iawer too but I have read the development license text and
>> I would say there is clear statement, that unless
>> we start use the db to process business data the license is free.
>>
>> Access to this database should be limited according  this point in dev
>> license "make the programs available in any manner to any third
>> party;"
>>
>> Here is the dev license paragraph:
>> LICENSE RIGHTS
>> We grant you a nonexclusive, nontransferable limited license to use
>> the programs only for the purpose of developing, testing, prototyping
>> and demonstrating your application, and not for any other purpose. If
>> you use the application you develop under this license for any
>> internal data processing or for any commercial or production purposes,
>> or you want to use the programs for any purpose other than as
>> permitted under this agreement, you must obtain a production release
>> version of the program by contacting us or an Oracle reseller to
>> obtain the appropriate license. You acknowledge that we may not
>> produce a production release version of the program and any
>> development efforts undertaken by you are at your own risk. We may
>> audit your use of the programs. Program documentation, if available,
>> may accessed online at
>> http://www.oracle.com/technetwork/documentation/index.html.
>>
>> Ownership and Restrictions We retain all ownership and intellectual
>> property rights in the programs. The programs may be installed on one
>> computer only, and used by one person in the operating environment
>> identified by us. You may make one copy of the programs for backup
>> purposes.
>>
>> You may not:
>> - use the programs for your own internal data processing or for any
>> commercial or production purposes, or use the programs for any purpose
>> except the development of your application;
>> - use the application you develop with the programs for any internal
>> data processing or commercial or production purposes without securing
>> an appropriate license from us;
>> - continue to develop your application after you have used it for any
>> internal data processing, commercial or production purpose without
>> securing an appropriate license from us, or an Oracle reseller;
>> - remove or modify any program markings or any notice of our proprietary
>> rights;
>> - make the programs available in any manner to any third party;
>> - use the programs to provide third party training;
>> - assign this agreement or give or transfer the programs or an
>> interest in them to another individual or entity; - cause or permit
>> reverse engineering (unless required by law for interoperability),
>> disassembly or decompilation of the programs;
>> - disclose results of any program benchmark tests without our prior
>> consent.
>>
>>
>> Full dev license text is here
>> http://www.oracle.com/technetwork/testcontent/standard-license-088383.html
>>
>> Regards,
>> Zdenek
>>
>> On Thu, Sep 2, 2010 at 5:02 AM, John Hurst <joh...@gm...>
>> wrote:
>> > Jeff,
>> > Thanks for your answers. With regard to Oracle are you talking about
>> Oracle
>> > XE (Express Edition)?
>> > This is approximately Oracle 10.2.0.1.
>> > The current 10.2 line is several patch levels beyond that, but that
>> > shouldn't cause any concern for us. Also, as you say, the limited data
>> > space, and also the missing features (no Java procedures in DB, no
>> > partitioning, etc) are not a problem for us.
>> > More of a concern is other, more recent versions of Oracle: 11gR1 and
>> 11gR2.
>> > There is no Express Edition available for these, and no indication that
>> > there will be. I believe that the OTN (Oracle Technology Network)
>> license
>> > ought to permit our use of these products, but I am not a lawyer!
>> > Incidentally, I'm not a DB2 guy either but I do know that DB2 provides a
>> > more-or-less free Express Edition too. So does SQL-Server.
>> > Regards
>> > JH
>> >
>> > On Thu, Sep 2, 2010 at 3:32 PM, Jeff Jensen <jj...@ap...> wrote:
>> >>
>> >> We would get a dedicated VM to install anything we have license to.
>> The
>> >> FOS databases are not a problem of course with no $ required.  Oracle
>> has
>> >> the free developer edition we can use (crippled to 4G data space, but
>> that
>> >> shouldn’t be a problem – I’ve used it before without a problem).
>> There’s a
>> >> decent chance we can use one of our spare MS SQL Server licenses.  Not
>> sure
>> >> about DB2 (haven’t used it in years) – does it have a free developer or
>> FOS
>> >> project license?  Are there others to discuss/research how?
>> >>
>> >>
>> >>
>> >> If everyone prefers to move from SF to Codehaus, then we need to
>> >> investigate grid options they have.  Whether they do or not, a couple
>> of
>> >> options are to still have all CI at my employer or use Codehaus for
>> general
>> >> unit and functional test builds and a second at my employer for the
>> grid
>> >> stuff.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> From: John Hurst [mailto:joh...@gm...]
>> >> Sent: Wednesday, September 01, 2010 4:06 PM
>> >>
>> >> To: dbu...@li...
>> >> Subject: Re: [dbunit-developer] Next step
>> >>
>> >>
>> >>
>> >> I believe the CodeHaus infrastructure is great.
>> >>
>> >>
>> >>
>> >> JIRA and Confluence are far better than the issue tracker and wiki
>> we're
>> >> currently using. (I was looking at the wikidot wiki again yesterday. It
>> seem
>> >> one cannot look at the history of a page? Is that correct???)
>> >>
>> >>
>> >>
>> >> Regarding Git, should we have a vote on this? Who would prefer to go to
>> >> Git? Who would not?
>> >>
>> >>
>> >>
>> >> Again, the advantages of Git include:
>> >>
>> >>   - Lots faster for most common operations
>> >>
>> >>   - Full offline/local repository with history
>> >>
>> >>   - Easy cloning of full repo
>> >>
>> >>   - Private branches, for committers and non-committers alike
>> >>
>> >>
>> >>
>> >> Generally Git is an enabler for open source collaboration. It just
>> makes
>> >> it easier to collaborate.
>> >>
>> >>
>> >>
>> >> For a while I was hesitant because of the tooling. Svn GUI support in
>> IDEs
>> >> etc was way ahead of Git. But IDEA X EAP has pretty good Git support
>> now,
>> >> and SmartGit is also very nice to use. Also, the Git command line using
>> bash
>> >> extensions just rocks. (Though I wish I could train my fingers to stop
>> >> typing "cd" when I mean "git checkout". :-)
>> >>
>> >>
>> >>
>> >> I don't know Bamboo but I imagine it's pretty nice.
>> >>
>> >>
>> >>
>> >> However, our CI requirements are more complex than most projects,
>> because
>> >> of our desire to test against all these databases. Jeff, would the CI
>> >> environment you propose allow for integration testing against many/most
>> of
>> >> our target databases? Alternatively, we could use Bamboo to test on
>> HSQLDB,
>> >> and continue to work towards a Cloud (or other) method to test against
>> real
>> >> databases. Actually I believe Bamboo has some of the strongest Amazon
>> EC2
>> >> integration among CI servers, so that might be worth looking at.
>> >>
>> >>
>> >>
>> >> My thoughts, anyway.
>> >>
>> >>
>> >>
>> >> JH
>> >>
>> >> On Wed, Sep 1, 2010 at 9:17 PM, Roberto Lo Giacco <rlo...@gm...
>> >
>> >> wrote:
>> >>
>> >> Nice to hear that. Do we all agree to the migration or does someone has
>> >> any reason not to?
>> >>
>> >>
>> >>
>> >> On Wed, Sep 1, 2010 at 08:50, Andres Almiray <aal...@ya...>
>> wrote:
>> >>
>> >> I spoke with Ben Walding about submitting to the Codehaus. It might be
>> >> possible to shortcut the waiting time :-)
>> >> Will keep you posted.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> -------------------------------------------
>> >> http://jroller.com/aalmiray
>> >> http://www.linkedin.com/in/aalmiray
>> >> --
>> >> What goes up, must come down. Ask any system administrator.
>> >> There are 10 types of people in the world: Those who understand binary,
>> >> and those who don't.
>> >> To understand recursion, we must first understand recursion.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> ________________________________
>> >>
>> >> From: Roberto Lo Giacco <rlo...@gm...>
>> >>
>> >> To: dbu...@li...
>> >>
>> >> Sent: Wed, September 1, 2010 8:31:07 AM
>> >>
>> >> Subject: Re: [dbunit-developer] Next step
>> >>
>> >>
>> >>
>> >> On Wed, Sep 1, 2010 at 04:08, Jeff Jensen <jj...@ap...> wrote:
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> From: Roberto Lo Giacco [mailto:rlo...@gm...]
>> >> Sent: Tuesday, August 31, 2010 3:35 AM
>> >>
>> >> To: dbu...@li...
>> >> Subject: Re: [dbunit-developer] Next step
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> On Tue, Aug 31, 2010 at 05:02, Jeff Jensen <jj...@ap...> wrote:
>> >>
>> >>
>> >>
>> >> From: Roberto Lo Giacco [mailto:rlo...@gm...]
>> >> Sent: Monday, August 30, 2010 1:18 PM
>> >> To: dbu...@li...
>> >> Subject: Re: [dbunit-developer] Next step
>> >>
>> >>
>> >>
>> >> Hi Jeff, first one to answer, I hope others will follow.
>> >>
>> >> About your questions...
>> >>
>> >> On Mon, Aug 30, 2010 at 14:30, Jeff Jensen <jj...@ap...> wrote:
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>  - need a CI setup; where/how can we do this?
>> >>
>> >>  - perhaps my employer will lend us some server space & time for
>> this...
>> >>
>> >> would you like me to check?
>> >>
>> >>  It would be perfect, but if he wants something back we should discuss
>> the
>> >> request with the community ;-)
>> >>
>> >>  Nothing  - it would be free.  I would set it up and we’d all have
>> >> access.  I’ll “volunteer” and check.  I don’t know of a current
>> alternative
>> >> option.
>> >>
>> >> In this case it will be silly to reject the proposal! ;-) I think a
>> Hudson
>> >> or Continuum installation (or whatever your employeer usually adopt)
>> can be
>> >> perfect... don't you think so?
>> >>
>> >>
>> >>
>> >> Yes I do!  J  It’s a go if we want to host it there.  The only reason I
>> >> pause now is I don’t want to make it happen if we move to Codehaus (as
>> it
>> >> has Bamboo).  Please advise!
>> >>
>> >>
>> >>
>> >> I'm submitting the project for codehaus review right now, it will take
>> >> about two weeks to have an answer, or at least this is what they say on
>> the
>> >> project submission page....
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> However, I'd first like to see the current trunk/2.4.8 released.
>> >>
>> >> I was away from the project for a couple of months but I thought you
>> had
>> >> everything you need and all the information to perform a release on
>> your
>> >> own... does the trunk need something particular I can help with?
>> >>
>> >> You said you want to do all the releases (see previous email
>> >> discussions).  Plus I would need shell access to deploy the site.
>> >>
>> >>
>> >>
>> >> I think I expressed myself wrong. Anyway, I'll try to release in a few
>> >> hours, right after posting my resume around :-)
>> >>
>> >>
>> >>
>> >> K, thanks.  Yes, I’ve done many releases with Maven and would gladly do
>> so
>> >> – just need the shell and file manager privs.
>> >>
>> >>
>> >>
>> >> You got those privs :-)
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> ------------------------------------------------------------------------------
>> >> This SF.net Dev2Dev email is sponsored by:
>> >>
>> >> Show off your parallel programming skills.
>> >> Enter the Intel(R) Threading Challenge 2010.
>> >> http://p.sf.net/sfu/intel-thread-sfd
>> >> _______________________________________________
>> >> dbunit-developer mailing list
>> >> dbu...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> ------------------------------------------------------------------------------
>> >> This SF.net Dev2Dev email is sponsored by:
>> >>
>> >> Show off your parallel programming skills.
>> >> Enter the Intel(R) Threading Challenge 2010.
>> >> http://p.sf.net/sfu/intel-thread-sfd
>> >> _______________________________________________
>> >> dbunit-developer mailing list
>> >> dbu...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>> >>
>> >>
>> >>
>> >>
>> >>
>> ------------------------------------------------------------------------------
>> >> This SF.net Dev2Dev email is sponsored by:
>> >>
>> >> Show off your parallel programming skills.
>> >> Enter the Intel(R) Threading Challenge 2010.
>> >> http://p.sf.net/sfu/intel-thread-sfd
>> >> _______________________________________________
>> >> dbunit-developer mailing list
>> >> dbu...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>> >>
>> >>
>> >> --
>> >> Life is interfering with my game
>> >>
>> >>
>> >>
>> ------------------------------------------------------------------------------
>> >> This SF.net Dev2Dev email is sponsored by:
>> >>
>> >> Show off your parallel programming skills.
>> >> Enter the Intel(R) Threading Challenge 2010.
>> >> http://p.sf.net/sfu/intel-thread-sfd
>> >> _______________________________________________
>> >> dbunit-developer mailing list
>> >> dbu...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>> >>
>> >
>> >
>> >
>> > --
>> > Life is interfering with my game
>> >
>> >
>> ------------------------------------------------------------------------------
>> > This SF.net Dev2Dev email is sponsored by:
>> >
>> > Show off your parallel programming skills.
>> > Enter the Intel(R) Threading Challenge 2010.
>> > http://p.sf.net/sfu/intel-thread-sfd
>> > _______________________________________________
>> > dbunit-developer mailing list
>> > dbu...@li...
>> > https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>> >
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>


-- 
Life is interfering with my game

Re: [dbunit-developer] Next step

[Roberto Lo G. <rlo...@gm...>]

What about CTX (http://www.creativyst.com/Doc/Std/ctx/ctx.htm) as an
alternative to CSV? I do not even know if it's a standard or if a Java
access library already exists, but it looks interesting... I think it's
worth you have a read.

On Thu, Sep 2, 2010 at 08:37, Zdeněk Vráblík <zd...@vr...> wrote:

> John,
>
> I am not a Iawer too but I have read the development license text and
> I would say there is clear statement, that unless
> we start use the db to process business data the license is free.
>
> Access to this database should be limited according  this point in dev
> license "make the programs available in any manner to any third
> party;"
>
> Here is the dev license paragraph:
> LICENSE RIGHTS
> We grant you a nonexclusive, nontransferable limited license to use
> the programs only for the purpose of developing, testing, prototyping
> and demonstrating your application, and not for any other purpose. If
> you use the application you develop under this license for any
> internal data processing or for any commercial or production purposes,
> or you want to use the programs for any purpose other than as
> permitted under this agreement, you must obtain a production release
> version of the program by contacting us or an Oracle reseller to
> obtain the appropriate license. You acknowledge that we may not
> produce a production release version of the program and any
> development efforts undertaken by you are at your own risk. We may
> audit your use of the programs. Program documentation, if available,
> may accessed online at
> http://www.oracle.com/technetwork/documentation/index.html.
>
> Ownership and Restrictions We retain all ownership and intellectual
> property rights in the programs. The programs may be installed on one
> computer only, and used by one person in the operating environment
> identified by us. You may make one copy of the programs for backup
> purposes.
>
> You may not:
> - use the programs for your own internal data processing or for any
> commercial or production purposes, or use the programs for any purpose
> except the development of your application;
> - use the application you develop with the programs for any internal
> data processing or commercial or production purposes without securing
> an appropriate license from us;
> - continue to develop your application after you have used it for any
> internal data processing, commercial or production purpose without
> securing an appropriate license from us, or an Oracle reseller;
> - remove or modify any program markings or any notice of our proprietary
> rights;
> - make the programs available in any manner to any third party;
> - use the programs to provide third party training;
> - assign this agreement or give or transfer the programs or an
> interest in them to another individual or entity; - cause or permit
> reverse engineering (unless required by law for interoperability),
> disassembly or decompilation of the programs;
> - disclose results of any program benchmark tests without our prior
> consent.
>
>
> Full dev license text is here
> http://www.oracle.com/technetwork/testcontent/standard-license-088383.html
>
> Regards,
> Zdenek
>
> On Thu, Sep 2, 2010 at 5:02 AM, John Hurst <joh...@gm...> wrote:
> > Jeff,
> > Thanks for your answers. With regard to Oracle are you talking about
> Oracle
> > XE (Express Edition)?
> > This is approximately Oracle 10.2.0.1.
> > The current 10.2 line is several patch levels beyond that, but that
> > shouldn't cause any concern for us. Also, as you say, the limited data
> > space, and also the missing features (no Java procedures in DB, no
> > partitioning, etc) are not a problem for us.
> > More of a concern is other, more recent versions of Oracle: 11gR1 and
> 11gR2.
> > There is no Express Edition available for these, and no indication that
> > there will be. I believe that the OTN (Oracle Technology Network) license
> > ought to permit our use of these products, but I am not a lawyer!
> > Incidentally, I'm not a DB2 guy either but I do know that DB2 provides a
> > more-or-less free Express Edition too. So does SQL-Server.
> > Regards
> > JH
> >
> > On Thu, Sep 2, 2010 at 3:32 PM, Jeff Jensen <jj...@ap...> wrote:
> >>
> >> We would get a dedicated VM to install anything we have license to.  The
> >> FOS databases are not a problem of course with no $ required.  Oracle
> has
> >> the free developer edition we can use (crippled to 4G data space, but
> that
> >> shouldn’t be a problem – I’ve used it before without a problem).
> There’s a
> >> decent chance we can use one of our spare MS SQL Server licenses.  Not
> sure
> >> about DB2 (haven’t used it in years) – does it have a free developer or
> FOS
> >> project license?  Are there others to discuss/research how?
> >>
> >>
> >>
> >> If everyone prefers to move from SF to Codehaus, then we need to
> >> investigate grid options they have.  Whether they do or not, a couple of
> >> options are to still have all CI at my employer or use Codehaus for
> general
> >> unit and functional test builds and a second at my employer for the grid
> >> stuff.
> >>
> >>
> >>
> >>
> >>
> >> From: John Hurst [mailto:joh...@gm...]
> >> Sent: Wednesday, September 01, 2010 4:06 PM
> >>
> >> To: dbu...@li...
> >> Subject: Re: [dbunit-developer] Next step
> >>
> >>
> >>
> >> I believe the CodeHaus infrastructure is great.
> >>
> >>
> >>
> >> JIRA and Confluence are far better than the issue tracker and wiki we're
> >> currently using. (I was looking at the wikidot wiki again yesterday. It
> seem
> >> one cannot look at the history of a page? Is that correct???)
> >>
> >>
> >>
> >> Regarding Git, should we have a vote on this? Who would prefer to go to
> >> Git? Who would not?
> >>
> >>
> >>
> >> Again, the advantages of Git include:
> >>
> >>   - Lots faster for most common operations
> >>
> >>   - Full offline/local repository with history
> >>
> >>   - Easy cloning of full repo
> >>
> >>   - Private branches, for committers and non-committers alike
> >>
> >>
> >>
> >> Generally Git is an enabler for open source collaboration. It just makes
> >> it easier to collaborate.
> >>
> >>
> >>
> >> For a while I was hesitant because of the tooling. Svn GUI support in
> IDEs
> >> etc was way ahead of Git. But IDEA X EAP has pretty good Git support
> now,
> >> and SmartGit is also very nice to use. Also, the Git command line using
> bash
> >> extensions just rocks. (Though I wish I could train my fingers to stop
> >> typing "cd" when I mean "git checkout". :-)
> >>
> >>
> >>
> >> I don't know Bamboo but I imagine it's pretty nice.
> >>
> >>
> >>
> >> However, our CI requirements are more complex than most projects,
> because
> >> of our desire to test against all these databases. Jeff, would the CI
> >> environment you propose allow for integration testing against many/most
> of
> >> our target databases? Alternatively, we could use Bamboo to test on
> HSQLDB,
> >> and continue to work towards a Cloud (or other) method to test against
> real
> >> databases. Actually I believe Bamboo has some of the strongest Amazon
> EC2
> >> integration among CI servers, so that might be worth looking at.
> >>
> >>
> >>
> >> My thoughts, anyway.
> >>
> >>
> >>
> >> JH
> >>
> >> On Wed, Sep 1, 2010 at 9:17 PM, Roberto Lo Giacco <rlo...@gm...>
> >> wrote:
> >>
> >> Nice to hear that. Do we all agree to the migration or does someone has
> >> any reason not to?
> >>
> >>
> >>
> >> On Wed, Sep 1, 2010 at 08:50, Andres Almiray <aal...@ya...>
> wrote:
> >>
> >> I spoke with Ben Walding about submitting to the Codehaus. It might be
> >> possible to shortcut the waiting time :-)
> >> Will keep you posted.
> >>
> >>
> >>
> >>
> >>
> >> -------------------------------------------
> >> http://jroller.com/aalmiray
> >> http://www.linkedin.com/in/aalmiray
> >> --
> >> What goes up, must come down. Ask any system administrator.
> >> There are 10 types of people in the world: Those who understand binary,
> >> and those who don't.
> >> To understand recursion, we must first understand recursion.
> >>
> >>
> >>
> >>
> >>
> >> ________________________________
> >>
> >> From: Roberto Lo Giacco <rlo...@gm...>
> >>
> >> To: dbu...@li...
> >>
> >> Sent: Wed, September 1, 2010 8:31:07 AM
> >>
> >> Subject: Re: [dbunit-developer] Next step
> >>
> >>
> >>
> >> On Wed, Sep 1, 2010 at 04:08, Jeff Jensen <jj...@ap...> wrote:
> >>
> >>
> >>
> >>
> >>
> >> From: Roberto Lo Giacco [mailto:rlo...@gm...]
> >> Sent: Tuesday, August 31, 2010 3:35 AM
> >>
> >> To: dbu...@li...
> >> Subject: Re: [dbunit-developer] Next step
> >>
> >>
> >>
> >>
> >>
> >> On Tue, Aug 31, 2010 at 05:02, Jeff Jensen <jj...@ap...> wrote:
> >>
> >>
> >>
> >> From: Roberto Lo Giacco [mailto:rlo...@gm...]
> >> Sent: Monday, August 30, 2010 1:18 PM
> >> To: dbu...@li...
> >> Subject: Re: [dbunit-developer] Next step
> >>
> >>
> >>
> >> Hi Jeff, first one to answer, I hope others will follow.
> >>
> >> About your questions...
> >>
> >> On Mon, Aug 30, 2010 at 14:30, Jeff Jensen <jj...@ap...> wrote:
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>  - need a CI setup; where/how can we do this?
> >>
> >>  - perhaps my employer will lend us some server space & time for this...
> >>
> >> would you like me to check?
> >>
> >>  It would be perfect, but if he wants something back we should discuss
> the
> >> request with the community ;-)
> >>
> >>  Nothing  - it would be free.  I would set it up and we’d all have
> >> access.  I’ll “volunteer” and check.  I don’t know of a current
> alternative
> >> option.
> >>
> >> In this case it will be silly to reject the proposal! ;-) I think a
> Hudson
> >> or Continuum installation (or whatever your employeer usually adopt) can
> be
> >> perfect... don't you think so?
> >>
> >>
> >>
> >> Yes I do!  J  It’s a go if we want to host it there.  The only reason I
> >> pause now is I don’t want to make it happen if we move to Codehaus (as
> it
> >> has Bamboo).  Please advise!
> >>
> >>
> >>
> >> I'm submitting the project for codehaus review right now, it will take
> >> about two weeks to have an answer, or at least this is what they say on
> the
> >> project submission page....
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> However, I'd first like to see the current trunk/2.4.8 released.
> >>
> >> I was away from the project for a couple of months but I thought you had
> >> everything you need and all the information to perform a release on your
> >> own... does the trunk need something particular I can help with?
> >>
> >> You said you want to do all the releases (see previous email
> >> discussions).  Plus I would need shell access to deploy the site.
> >>
> >>
> >>
> >> I think I expressed myself wrong. Anyway, I'll try to release in a few
> >> hours, right after posting my resume around :-)
> >>
> >>
> >>
> >> K, thanks.  Yes, I’ve done many releases with Maven and would gladly do
> so
> >> – just need the shell and file manager privs.
> >>
> >>
> >>
> >> You got those privs :-)
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> This SF.net Dev2Dev email is sponsored by:
> >>
> >> Show off your parallel programming skills.
> >> Enter the Intel(R) Threading Challenge 2010.
> >> http://p.sf.net/sfu/intel-thread-sfd
> >> _______________________________________________
> >> dbunit-developer mailing list
> >> dbu...@li...
> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> This SF.net Dev2Dev email is sponsored by:
> >>
> >> Show off your parallel programming skills.
> >> Enter the Intel(R) Threading Challenge 2010.
> >> http://p.sf.net/sfu/intel-thread-sfd
> >> _______________________________________________
> >> dbunit-developer mailing list
> >> dbu...@li...
> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >>
> >>
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> This SF.net Dev2Dev email is sponsored by:
> >>
> >> Show off your parallel programming skills.
> >> Enter the Intel(R) Threading Challenge 2010.
> >> http://p.sf.net/sfu/intel-thread-sfd
> >> _______________________________________________
> >> dbunit-developer mailing list
> >> dbu...@li...
> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >>
> >>
> >> --
> >> Life is interfering with my game
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> This SF.net Dev2Dev email is sponsored by:
> >>
> >> Show off your parallel programming skills.
> >> Enter the Intel(R) Threading Challenge 2010.
> >> http://p.sf.net/sfu/intel-thread-sfd
> >> _______________________________________________
> >> dbunit-developer mailing list
> >> dbu...@li...
> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >>
> >
> >
> >
> > --
> > Life is interfering with my game
> >
> >
> ------------------------------------------------------------------------------
> > This SF.net Dev2Dev email is sponsored by:
> >
> > Show off your parallel programming skills.
> > Enter the Intel(R) Threading Challenge 2010.
> > http://p.sf.net/sfu/intel-thread-sfd
> > _______________________________________________
> > dbunit-developer mailing list
> > dbu...@li...
> > https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >
> >
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>

Re: [dbunit-developer] Next step

[Zdeněk V. <zd...@vr...>]

John,

I am not a Iawer too but I have read the development license text and
I would say there is clear statement, that unless
we start use the db to process business data the license is free.

Access to this database should be limited according  this point in dev
license "make the programs available in any manner to any third
party;"

Here is the dev license paragraph:
LICENSE RIGHTS
We grant you a nonexclusive, nontransferable limited license to use
the programs only for the purpose of developing, testing, prototyping
and demonstrating your application, and not for any other purpose. If
you use the application you develop under this license for any
internal data processing or for any commercial or production purposes,
or you want to use the programs for any purpose other than as
permitted under this agreement, you must obtain a production release
version of the program by contacting us or an Oracle reseller to
obtain the appropriate license. You acknowledge that we may not
produce a production release version of the program and any
development efforts undertaken by you are at your own risk. We may
audit your use of the programs. Program documentation, if available,
may accessed online at
http://www.oracle.com/technetwork/documentation/index.html.

Ownership and Restrictions We retain all ownership and intellectual
property rights in the programs. The programs may be installed on one
computer only, and used by one person in the operating environment
identified by us. You may make one copy of the programs for backup
purposes.

You may not:
- use the programs for your own internal data processing or for any
commercial or production purposes, or use the programs for any purpose
except the development of your application;
- use the application you develop with the programs for any internal
data processing or commercial or production purposes without securing
an appropriate license from us;
- continue to develop your application after you have used it for any
internal data processing, commercial or production purpose without
securing an appropriate license from us, or an Oracle reseller;
- remove or modify any program markings or any notice of our proprietary rights;
- make the programs available in any manner to any third party;
- use the programs to provide third party training;
- assign this agreement or give or transfer the programs or an
interest in them to another individual or entity; - cause or permit
reverse engineering (unless required by law for interoperability),
disassembly or decompilation of the programs;
- disclose results of any program benchmark tests without our prior consent.


Full dev license text is here
http://www.oracle.com/technetwork/testcontent/standard-license-088383.html

Regards,
Zdenek

On Thu, Sep 2, 2010 at 5:02 AM, John Hurst <joh...@gm...> wrote:
> Jeff,
> Thanks for your answers. With regard to Oracle are you talking about Oracle
> XE (Express Edition)?
> This is approximately Oracle 10.2.0.1.
> The current 10.2 line is several patch levels beyond that, but that
> shouldn't cause any concern for us. Also, as you say, the limited data
> space, and also the missing features (no Java procedures in DB, no
> partitioning, etc) are not a problem for us.
> More of a concern is other, more recent versions of Oracle: 11gR1 and 11gR2.
> There is no Express Edition available for these, and no indication that
> there will be. I believe that the OTN (Oracle Technology Network) license
> ought to permit our use of these products, but I am not a lawyer!
> Incidentally, I'm not a DB2 guy either but I do know that DB2 provides a
> more-or-less free Express Edition too. So does SQL-Server.
> Regards
> JH
>
> On Thu, Sep 2, 2010 at 3:32 PM, Jeff Jensen <jj...@ap...> wrote:
>>
>> We would get a dedicated VM to install anything we have license to.  The
>> FOS databases are not a problem of course with no $ required.  Oracle has
>> the free developer edition we can use (crippled to 4G data space, but that
>> shouldn’t be a problem – I’ve used it before without a problem).  There’s a
>> decent chance we can use one of our spare MS SQL Server licenses.  Not sure
>> about DB2 (haven’t used it in years) – does it have a free developer or FOS
>> project license?  Are there others to discuss/research how?
>>
>>
>>
>> If everyone prefers to move from SF to Codehaus, then we need to
>> investigate grid options they have.  Whether they do or not, a couple of
>> options are to still have all CI at my employer or use Codehaus for general
>> unit and functional test builds and a second at my employer for the grid
>> stuff.
>>
>>
>>
>>
>>
>> From: John Hurst [mailto:joh...@gm...]
>> Sent: Wednesday, September 01, 2010 4:06 PM
>>
>> To: dbu...@li...
>> Subject: Re: [dbunit-developer] Next step
>>
>>
>>
>> I believe the CodeHaus infrastructure is great.
>>
>>
>>
>> JIRA and Confluence are far better than the issue tracker and wiki we're
>> currently using. (I was looking at the wikidot wiki again yesterday. It seem
>> one cannot look at the history of a page? Is that correct???)
>>
>>
>>
>> Regarding Git, should we have a vote on this? Who would prefer to go to
>> Git? Who would not?
>>
>>
>>
>> Again, the advantages of Git include:
>>
>>   - Lots faster for most common operations
>>
>>   - Full offline/local repository with history
>>
>>   - Easy cloning of full repo
>>
>>   - Private branches, for committers and non-committers alike
>>
>>
>>
>> Generally Git is an enabler for open source collaboration. It just makes
>> it easier to collaborate.
>>
>>
>>
>> For a while I was hesitant because of the tooling. Svn GUI support in IDEs
>> etc was way ahead of Git. But IDEA X EAP has pretty good Git support now,
>> and SmartGit is also very nice to use. Also, the Git command line using bash
>> extensions just rocks. (Though I wish I could train my fingers to stop
>> typing "cd" when I mean "git checkout". :-)
>>
>>
>>
>> I don't know Bamboo but I imagine it's pretty nice.
>>
>>
>>
>> However, our CI requirements are more complex than most projects, because
>> of our desire to test against all these databases. Jeff, would the CI
>> environment you propose allow for integration testing against many/most of
>> our target databases? Alternatively, we could use Bamboo to test on HSQLDB,
>> and continue to work towards a Cloud (or other) method to test against real
>> databases. Actually I believe Bamboo has some of the strongest Amazon EC2
>> integration among CI servers, so that might be worth looking at.
>>
>>
>>
>> My thoughts, anyway.
>>
>>
>>
>> JH
>>
>> On Wed, Sep 1, 2010 at 9:17 PM, Roberto Lo Giacco <rlo...@gm...>
>> wrote:
>>
>> Nice to hear that. Do we all agree to the migration or does someone has
>> any reason not to?
>>
>>
>>
>> On Wed, Sep 1, 2010 at 08:50, Andres Almiray <aal...@ya...> wrote:
>>
>> I spoke with Ben Walding about submitting to the Codehaus. It might be
>> possible to shortcut the waiting time :-)
>> Will keep you posted.
>>
>>
>>
>>
>>
>> -------------------------------------------
>> http://jroller.com/aalmiray
>> http://www.linkedin.com/in/aalmiray
>> --
>> What goes up, must come down. Ask any system administrator.
>> There are 10 types of people in the world: Those who understand binary,
>> and those who don't.
>> To understand recursion, we must first understand recursion.
>>
>>
>>
>>
>>
>> ________________________________
>>
>> From: Roberto Lo Giacco <rlo...@gm...>
>>
>> To: dbu...@li...
>>
>> Sent: Wed, September 1, 2010 8:31:07 AM
>>
>> Subject: Re: [dbunit-developer] Next step
>>
>>
>>
>> On Wed, Sep 1, 2010 at 04:08, Jeff Jensen <jj...@ap...> wrote:
>>
>>
>>
>>
>>
>> From: Roberto Lo Giacco [mailto:rlo...@gm...]
>> Sent: Tuesday, August 31, 2010 3:35 AM
>>
>> To: dbu...@li...
>> Subject: Re: [dbunit-developer] Next step
>>
>>
>>
>>
>>
>> On Tue, Aug 31, 2010 at 05:02, Jeff Jensen <jj...@ap...> wrote:
>>
>>
>>
>> From: Roberto Lo Giacco [mailto:rlo...@gm...]
>> Sent: Monday, August 30, 2010 1:18 PM
>> To: dbu...@li...
>> Subject: Re: [dbunit-developer] Next step
>>
>>
>>
>> Hi Jeff, first one to answer, I hope others will follow.
>>
>> About your questions...
>>
>> On Mon, Aug 30, 2010 at 14:30, Jeff Jensen <jj...@ap...> wrote:
>>
>>
>>
>>
>>
>>
>>
>>  - need a CI setup; where/how can we do this?
>>
>>  - perhaps my employer will lend us some server space & time for this...
>>
>> would you like me to check?
>>
>>  It would be perfect, but if he wants something back we should discuss the
>> request with the community ;-)
>>
>>  Nothing  - it would be free.  I would set it up and we’d all have
>> access.  I’ll “volunteer” and check.  I don’t know of a current alternative
>> option.
>>
>> In this case it will be silly to reject the proposal! ;-) I think a Hudson
>> or Continuum installation (or whatever your employeer usually adopt) can be
>> perfect... don't you think so?
>>
>>
>>
>> Yes I do!  J  It’s a go if we want to host it there.  The only reason I
>> pause now is I don’t want to make it happen if we move to Codehaus (as it
>> has Bamboo).  Please advise!
>>
>>
>>
>> I'm submitting the project for codehaus review right now, it will take
>> about two weeks to have an answer, or at least this is what they say on the
>> project submission page....
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> However, I'd first like to see the current trunk/2.4.8 released.
>>
>> I was away from the project for a couple of months but I thought you had
>> everything you need and all the information to perform a release on your
>> own... does the trunk need something particular I can help with?
>>
>> You said you want to do all the releases (see previous email
>> discussions).  Plus I would need shell access to deploy the site.
>>
>>
>>
>> I think I expressed myself wrong. Anyway, I'll try to release in a few
>> hours, right after posting my resume around :-)
>>
>>
>>
>> K, thanks.  Yes, I’ve done many releases with Maven and would gladly do so
>> – just need the shell and file manager privs.
>>
>>
>>
>> You got those privs :-)
>>
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>> --
>> Life is interfering with my game
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>
>
>
> --
> Life is interfering with my game
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>

Re: [dbunit-developer] Next step

[Zdeněk V. <zd...@vr...>]

MS SQL has free edition too.
See http://www.microsoft.com/sqlserver/2005/en/us/express.aspx

Regards,
Zdenek

On Thu, Sep 2, 2010 at 7:05 AM, Zdeněk Vráblík <zd...@vr...> wrote:
> Hi Jeff,
>
> Db2 has free version. See http://www-01.ibm.com/software/data/db2/express/
>
> I didn't try use this express version personally. Most of my work is
> with Oracle db.
>
> Regards,
> Zdenek
>
> On Thu, Sep 2, 2010 at 4:32 AM, Jeff Jensen <jj...@ap...> wrote:
>> We would get a dedicated VM to install anything we have license to.  The FOS
>> databases are not a problem of course with no $ required.  Oracle has the
>> free developer edition we can use (crippled to 4G data space, but that
>> shouldn’t be a problem – I’ve used it before without a problem).  There’s a
>> decent chance we can use one of our spare MS SQL Server licenses.  Not sure
>> about DB2 (haven’t used it in years) – does it have a free developer or FOS
>> project license?  Are there others to discuss/research how?
>>
>>
>>
>> If everyone prefers to move from SF to Codehaus, then we need to investigate
>> grid options they have.  Whether they do or not, a couple of options are to
>> still have all CI at my employer or use Codehaus for general unit and
>> functional test builds and a second at my employer for the grid stuff.
>>
>>
>>
>>
>>
>> From: John Hurst [mailto:joh...@gm...]
>> Sent: Wednesday, September 01, 2010 4:06 PM
>> To: dbu...@li...
>> Subject: Re: [dbunit-developer] Next step
>>
>>
>>
>> I believe the CodeHaus infrastructure is great.
>>
>>
>>
>> JIRA and Confluence are far better than the issue tracker and wiki we're
>> currently using. (I was looking at the wikidot wiki again yesterday. It seem
>> one cannot look at the history of a page? Is that correct???)
>>
>>
>>
>> Regarding Git, should we have a vote on this? Who would prefer to go to Git?
>> Who would not?
>>
>>
>>
>> Again, the advantages of Git include:
>>
>>   - Lots faster for most common operations
>>
>>   - Full offline/local repository with history
>>
>>   - Easy cloning of full repo
>>
>>   - Private branches, for committers and non-committers alike
>>
>>
>>
>> Generally Git is an enabler for open source collaboration. It just makes it
>> easier to collaborate.
>>
>>
>>
>> For a while I was hesitant because of the tooling. Svn GUI support in IDEs
>> etc was way ahead of Git. But IDEA X EAP has pretty good Git support now,
>> and SmartGit is also very nice to use. Also, the Git command line using bash
>> extensions just rocks. (Though I wish I could train my fingers to stop
>> typing "cd" when I mean "git checkout". :-)
>>
>>
>>
>> I don't know Bamboo but I imagine it's pretty nice.
>>
>>
>>
>> However, our CI requirements are more complex than most projects, because of
>> our desire to test against all these databases. Jeff, would the CI
>> environment you propose allow for integration testing against many/most of
>> our target databases? Alternatively, we could use Bamboo to test on HSQLDB,
>> and continue to work towards a Cloud (or other) method to test against real
>> databases. Actually I believe Bamboo has some of the strongest Amazon EC2
>> integration among CI servers, so that might be worth looking at.
>>
>>
>>
>> My thoughts, anyway.
>>
>>
>>
>> JH
>>
>> On Wed, Sep 1, 2010 at 9:17 PM, Roberto Lo Giacco <rlo...@gm...>
>> wrote:
>>
>> Nice to hear that. Do we all agree to the migration or does someone has any
>> reason not to?
>>
>>
>>
>> On Wed, Sep 1, 2010 at 08:50, Andres Almiray <aal...@ya...> wrote:
>>
>> I spoke with Ben Walding about submitting to the Codehaus. It might be
>> possible to shortcut the waiting time :-)
>> Will keep you posted.
>>
>>
>>
>>
>>
>> -------------------------------------------
>> http://jroller.com/aalmiray
>> http://www.linkedin.com/in/aalmiray
>> --
>> What goes up, must come down. Ask any system administrator.
>> There are 10 types of people in the world: Those who understand binary, and
>> those who don't.
>> To understand recursion, we must first understand recursion.
>>
>>
>>
>>
>>
>> ________________________________
>>
>> From: Roberto Lo Giacco <rlo...@gm...>
>>
>> To: dbu...@li...
>>
>> Sent: Wed, September 1, 2010 8:31:07 AM
>>
>> Subject: Re: [dbunit-developer] Next step
>>
>>
>>
>> On Wed, Sep 1, 2010 at 04:08, Jeff Jensen <jj...@ap...> wrote:
>>
>>
>>
>>
>>
>> From: Roberto Lo Giacco [mailto:rlo...@gm...]
>> Sent: Tuesday, August 31, 2010 3:35 AM
>>
>> To: dbu...@li...
>> Subject: Re: [dbunit-developer] Next step
>>
>>
>>
>>
>>
>> On Tue, Aug 31, 2010 at 05:02, Jeff Jensen <jj...@ap...> wrote:
>>
>>
>>
>> From: Roberto Lo Giacco [mailto:rlo...@gm...]
>> Sent: Monday, August 30, 2010 1:18 PM
>> To: dbu...@li...
>> Subject: Re: [dbunit-developer] Next step
>>
>>
>>
>> Hi Jeff, first one to answer, I hope others will follow.
>>
>> About your questions...
>>
>> On Mon, Aug 30, 2010 at 14:30, Jeff Jensen <jj...@ap...> wrote:
>>
>>
>>
>>
>>
>>
>>
>>  - need a CI setup; where/how can we do this?
>>
>>  - perhaps my employer will lend us some server space & time for this...
>>
>> would you like me to check?
>>
>>  It would be perfect, but if he wants something back we should discuss the
>> request with the community ;-)
>>
>>  Nothing  - it would be free.  I would set it up and we’d all have access.
>> I’ll “volunteer” and check.  I don’t know of a current alternative option.
>>
>> In this case it will be silly to reject the proposal! ;-) I think a Hudson
>> or Continuum installation (or whatever your employeer usually adopt) can be
>> perfect... don't you think so?
>>
>>
>>
>> Yes I do!  J  It’s a go if we want to host it there.  The only reason I
>> pause now is I don’t want to make it happen if we move to Codehaus (as it
>> has Bamboo).  Please advise!
>>
>>
>>
>> I'm submitting the project for codehaus review right now, it will take about
>> two weeks to have an answer, or at least this is what they say on the
>> project submission page....
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> However, I'd first like to see the current trunk/2.4.8 released.
>>
>> I was away from the project for a couple of months but I thought you had
>> everything you need and all the information to perform a release on your
>> own... does the trunk need something particular I can help with?
>>
>> You said you want to do all the releases (see previous email discussions).
>> Plus I would need shell access to deploy the site.
>>
>>
>>
>> I think I expressed myself wrong. Anyway, I'll try to release in a few
>> hours, right after posting my resume around :-)
>>
>>
>>
>> K, thanks.  Yes, I’ve done many releases with Maven and would gladly do so –
>> just need the shell and file manager privs.
>>
>>
>>
>> You got those privs :-)
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>> --
>> Life is interfering with my game
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>>
>>
>

Re: [dbunit-developer] Next step

[Zdeněk V. <zd...@vr...>]

Hi Jeff,

Db2 has free version. See http://www-01.ibm.com/software/data/db2/express/

I didn't try use this express version personally. Most of my work is
with Oracle db.

Regards,
Zdenek

On Thu, Sep 2, 2010 at 4:32 AM, Jeff Jensen <jj...@ap...> wrote:
> We would get a dedicated VM to install anything we have license to.  The FOS
> databases are not a problem of course with no $ required.  Oracle has the
> free developer edition we can use (crippled to 4G data space, but that
> shouldn’t be a problem – I’ve used it before without a problem).  There’s a
> decent chance we can use one of our spare MS SQL Server licenses.  Not sure
> about DB2 (haven’t used it in years) – does it have a free developer or FOS
> project license?  Are there others to discuss/research how?
>
>
>
> If everyone prefers to move from SF to Codehaus, then we need to investigate
> grid options they have.  Whether they do or not, a couple of options are to
> still have all CI at my employer or use Codehaus for general unit and
> functional test builds and a second at my employer for the grid stuff.
>
>
>
>
>
> From: John Hurst [mailto:joh...@gm...]
> Sent: Wednesday, September 01, 2010 4:06 PM
> To: dbu...@li...
> Subject: Re: [dbunit-developer] Next step
>
>
>
> I believe the CodeHaus infrastructure is great.
>
>
>
> JIRA and Confluence are far better than the issue tracker and wiki we're
> currently using. (I was looking at the wikidot wiki again yesterday. It seem
> one cannot look at the history of a page? Is that correct???)
>
>
>
> Regarding Git, should we have a vote on this? Who would prefer to go to Git?
> Who would not?
>
>
>
> Again, the advantages of Git include:
>
>   - Lots faster for most common operations
>
>   - Full offline/local repository with history
>
>   - Easy cloning of full repo
>
>   - Private branches, for committers and non-committers alike
>
>
>
> Generally Git is an enabler for open source collaboration. It just makes it
> easier to collaborate.
>
>
>
> For a while I was hesitant because of the tooling. Svn GUI support in IDEs
> etc was way ahead of Git. But IDEA X EAP has pretty good Git support now,
> and SmartGit is also very nice to use. Also, the Git command line using bash
> extensions just rocks. (Though I wish I could train my fingers to stop
> typing "cd" when I mean "git checkout". :-)
>
>
>
> I don't know Bamboo but I imagine it's pretty nice.
>
>
>
> However, our CI requirements are more complex than most projects, because of
> our desire to test against all these databases. Jeff, would the CI
> environment you propose allow for integration testing against many/most of
> our target databases? Alternatively, we could use Bamboo to test on HSQLDB,
> and continue to work towards a Cloud (or other) method to test against real
> databases. Actually I believe Bamboo has some of the strongest Amazon EC2
> integration among CI servers, so that might be worth looking at.
>
>
>
> My thoughts, anyway.
>
>
>
> JH
>
> On Wed, Sep 1, 2010 at 9:17 PM, Roberto Lo Giacco <rlo...@gm...>
> wrote:
>
> Nice to hear that. Do we all agree to the migration or does someone has any
> reason not to?
>
>
>
> On Wed, Sep 1, 2010 at 08:50, Andres Almiray <aal...@ya...> wrote:
>
> I spoke with Ben Walding about submitting to the Codehaus. It might be
> possible to shortcut the waiting time :-)
> Will keep you posted.
>
>
>
>
>
> -------------------------------------------
> http://jroller.com/aalmiray
> http://www.linkedin.com/in/aalmiray
> --
> What goes up, must come down. Ask any system administrator.
> There are 10 types of people in the world: Those who understand binary, and
> those who don't.
> To understand recursion, we must first understand recursion.
>
>
>
>
>
> ________________________________
>
> From: Roberto Lo Giacco <rlo...@gm...>
>
> To: dbu...@li...
>
> Sent: Wed, September 1, 2010 8:31:07 AM
>
> Subject: Re: [dbunit-developer] Next step
>
>
>
> On Wed, Sep 1, 2010 at 04:08, Jeff Jensen <jj...@ap...> wrote:
>
>
>
>
>
> From: Roberto Lo Giacco [mailto:rlo...@gm...]
> Sent: Tuesday, August 31, 2010 3:35 AM
>
> To: dbu...@li...
> Subject: Re: [dbunit-developer] Next step
>
>
>
>
>
> On Tue, Aug 31, 2010 at 05:02, Jeff Jensen <jj...@ap...> wrote:
>
>
>
> From: Roberto Lo Giacco [mailto:rlo...@gm...]
> Sent: Monday, August 30, 2010 1:18 PM
> To: dbu...@li...
> Subject: Re: [dbunit-developer] Next step
>
>
>
> Hi Jeff, first one to answer, I hope others will follow.
>
> About your questions...
>
> On Mon, Aug 30, 2010 at 14:30, Jeff Jensen <jj...@ap...> wrote:
>
>
>
>
>
>
>
>  - need a CI setup; where/how can we do this?
>
>  - perhaps my employer will lend us some server space & time for this...
>
> would you like me to check?
>
>  It would be perfect, but if he wants something back we should discuss the
> request with the community ;-)
>
>  Nothing  - it would be free.  I would set it up and we’d all have access.
> I’ll “volunteer” and check.  I don’t know of a current alternative option.
>
> In this case it will be silly to reject the proposal! ;-) I think a Hudson
> or Continuum installation (or whatever your employeer usually adopt) can be
> perfect... don't you think so?
>
>
>
> Yes I do!  J  It’s a go if we want to host it there.  The only reason I
> pause now is I don’t want to make it happen if we move to Codehaus (as it
> has Bamboo).  Please advise!
>
>
>
> I'm submitting the project for codehaus review right now, it will take about
> two weeks to have an answer, or at least this is what they say on the
> project submission page....
>
>
>
>
>
>
>
>
>
> However, I'd first like to see the current trunk/2.4.8 released.
>
> I was away from the project for a couple of months but I thought you had
> everything you need and all the information to perform a release on your
> own... does the trunk need something particular I can help with?
>
> You said you want to do all the releases (see previous email discussions).
> Plus I would need shell access to deploy the site.
>
>
>
> I think I expressed myself wrong. Anyway, I'll try to release in a few
> hours, right after posting my resume around :-)
>
>
>
> K, thanks.  Yes, I’ve done many releases with Maven and would gladly do so –
> just need the shell and file manager privs.
>
>
>
> You got those privs :-)
>
>
>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>
>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>
> --
> Life is interfering with my game
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>