|
»
»
»
DBUnit and DB2
|
View:
New views
6 Messages
—
Rating Filter:
Alert me
|
 |
DBUnit and DB2
by Keith Bennett
::
Rate this Message:
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@... https://lists.sourceforge.net/lists/listinfo/dbunit-user |
|
|
Re: DBUnit and DB2
by mmistroni
::
Rate this Message:
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@...> wrote: Hi, I am new to this list and don't have a lot of experience with ------------------------------------------------------------------------- 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@... https://lists.sourceforge.net/lists/listinfo/dbunit-user |
|
|
Re: DBUnit and DB2
by Keith Bennett
::
Rate this Message:
I was missing a configuration item in my Maven plugin configuration.
It is working now. Thanks, Marco. On 6/2/08, Marco Mistroni <mmistroni@...> 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@...> 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@... > > 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@... > 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@... https://lists.sourceforge.net/lists/listinfo/dbunit-user |
|
|
Re: DBUnit and DB2
by Bjorn Beskow
::
Rate this Message:
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
|
|
|
Re: DBUnit and DB2
by Keith Bennett
::
Rate this Message:
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@...> 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@...> 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@...> >>> 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@... >>> > 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@... >>> 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@... >> 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@... > 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@... https://lists.sourceforge.net/lists/listinfo/dbunit-user |
|
|
Re: DBUnit and DB2
by Bjorn Beskow
::
Rate this Message:
I was missing the <schema> parameter. Now it works like a charm. Thanks!
/Bjorn
|
| Free Forum Powered by Nabble | Forum Help |