Re: DBUnit and DB2

Keith Bennett wrote:

Bjorn,

I have the following dbunit plugin configuration specified.  We are
running DB2 on z/OS.  I have created both a mysql and db2 profile, so
you'll have to replace the property references below with values of
your own.  Below the configuration I've included the values I'm using
where I think it might be helpful to you.  The others will be specific
to your application.  Let me know if this helps you or not.

Keith

<configuration>
  <driver>${jdbc.driver_class}</driver>
  <username>${jdbc.username}</username>
  <password>${jdbc.password}</password>
  <url>${jdbc.url}</url>
  <src>src/test/resources/dbSeedFile.xml</src>
  <type>${dbunit.operation.type}</type>
  <format>flat</format>
  <schema>${dbunit.schema}</schema>
  <dataTypeFactoryName>${dbunit.dataTypeFactoryName}</dataTypeFactoryName>
</configuration>

${dbunit.dataTypeFactoryName} = org.dbunit.ext.db2.Db2DataTypeFactory
${dbunit.operation.type} = INSERT




On Tue, Jun 24, 2008 at 6:34 AM, Bjorn Beskow <b.beskow@swipnet.se> wrote:
>
> Hi Keith,
>
> I have the same problem, trying to run a CLEAN_INSERT operation against a
> DB2 db. Which configuration item in the Maven plugin did you change, to
> remedy the problem?
>
> I'm very grateful for any tips!
>
> Regards
> /Björn
>
>
> Keith Bennett wrote:
>>
>> I was missing a configuration item in my Maven plugin configuration.
>> It is working now.  Thanks, Marco.
>>
>> On 6/2/08, Marco Mistroni <mmistroni@gmail.com> wrote:
>>> hi
>>>  can you post stack trace as well as the code?
>>>
>>> rgds
>>>  marco
>>>
>>>
>>>
>>>
>>> On Mon, Jun 2, 2008 at 9:50 PM, Keith Bennett <forthwind@gmail.com>
>>> wrote:
>>> >
>>> > Hi, I am new to this list and don't have a lot of experience with
>>> > DBUnit.  I am trying to use DBUnit to insert rows into reference
>>> > tables in DB2 and am getting the following error:
>>> >
>>> > [ERROR] BUILD ERROR
>>> > [INFO]
>>> ------------------------------------------------------------------------
>>> > [INFO] Error executing database operation: CLEAN_INSERT
>>> >
>>> > Embedded error: PLAN_TABLE
>>> >
>>> > Has anyone seen this error with DB2?  We've been using MySQL as our
>>> > development database until now and have had no problems using DBUnit
>>> > with MySQL.  Any help or explanation as to what is going on would be
>>> > greatly appreciated.
>>> >
>>> >
>>> -------------------------------------------------------------------------
>>> > This SF.net email is sponsored by: Microsoft
>>> > Defy all challenges. Microsoft(R) Visual Studio 2008.
>>> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>>> > _______________________________________________
>>> > dbunit-user mailing list
>>> > dbunit-user@lists.sourceforge.net
>>> > https://lists.sourceforge.net/lists/listinfo/dbunit-user
>>> >
>>>
>>>
>>> -------------------------------------------------------------------------
>>> This SF.net email is sponsored by: Microsoft
>>> Defy all challenges. Microsoft(R) Visual Studio 2008.
>>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>>> _______________________________________________
>>> dbunit-user mailing list
>>> dbunit-user@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>>>
>>>
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Microsoft
>> Defy all challenges. Microsoft(R) Visual Studio 2008.
>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>> _______________________________________________
>> dbunit-user mailing list
>> dbunit-user@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>>
>>
>
> --
> View this message in context: http://www.nabble.com/DBUnit-and-DB2-tp17610509p18089098.html
> Sent from the DBUnit - Users mailing list archive at Nabble.com.
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> dbunit-user mailing list
> dbunit-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
dbunit-user mailing list
dbunit-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbunit-user