DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)

steven.hicks
DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)

Hi

I have created an expected results file that asserts OK on Windows but fails on UNIX with:

junit.framework.ComparisonFailure: value (table=AUDIT, row=0, col=AUDIT_DATA) expected:<...ices/AuditData.xsd">[
  <audit-detail>
    <description>User Name</description>
    <mime-type>text/xml</mime-type>
    <data>Steve Sidejkick</data>
  </audit-detail>
  <audit-detail>
    <description>User Roles</description>
    <mime-type>text/xml</mime-type>
    <data/>
  </audit-detail>
]
</audit>> but was:<...ices/AuditData.xsd">[
  <audit-detail>
    <description>User Name</description>
    <mime-type>text/xml</mime-type>
    <data>Steve Sidejkick</data>
  </audit-detail>
  <audit-detail>
    <description>User Roles</description>
    <mime-type>text/xml</mime-type>
    <data/>
  </audit-detail>]
</audit>>

Now I have tried saving the file (on my PC) to UNIX format within Eclipse but when I check this into SVN I notice my file is in DOS format again

The expected results file is:
<?xml version='1.0' encoding='UTF-8'?>
<dataset>
  <SYNT_AUDIT AUDIT_ID="6556" AUDIT_DATA="&lt;audit xmlns=&quot;<A HREF="http://">http://www.myco.com/AuditData.xsd&quot;&gt;&#xD;&#xA;  &lt;audit-detail&gt;&#xD;&#xA;    &lt;description&gt;User Name&lt;/description&gt;&#xD;&#xA;    &lt;mime-type&gt;text/xml&lt;/mime-type&gt;&#xD;&#xA;    &lt;data&gt;Steve Sidejkick&lt;/data&gt;&#xD;&#xA;  &lt;/audit-detail&gt;&#xD;&#xA;  &lt;audit-detail&gt;&#xD;&#xA;    &lt;description&gt;User Roles&lt;/description&gt;&#xD;&#xA;    &lt;mime-type&gt;text/xml&lt;/mime-type&gt;&#xD;&#xA;    &lt;data/&gt;&#xD;&#xA;  &lt;/audit-detail&gt;&#xD;&#xA;&lt;/audit&gt;" AR_TIMESTAMP="[NULL]" AR_INSERT_TIMESTAMP="[NULL]"/>

</dataset>



Steve Hicks
BT Innovate & Design |  Customer Innovation Solutions |  Lead Software Engineer
Phone:  +44 (0) 117 3024378
Mobile:  +44 (0) 7720 425253
FAX:      +44 (0) 2920 397035
SMTP:    [hidden email] 
Office:    pp 1/098, Ty Cynnal, Watkiss Way, Cardiff, CF11 0SW

This email contains BT information, which may be privileged or confidential.
It's meant only for the individual(s) or entity named above. If you're not the intended
recipient, note that disclosing, copying, distributing or using this information
is prohibited. If you've received this email in error, please let me know immediately
on the email address above. Thank you.
We monitor our email system, and may record your emails.

British Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no: 1800000

Think before you print. Please consider the environment before printing this email



------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

Re: DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)

Matthias Gommeringer
Hi Steve,

you may be able to solve your problem by setting the SVN property "svn:eol-style" to "native" for this file. See http://svnbook.red-bean.com/en/1.4/svn.advanced.props.file-portability.html

rgds,
matthias


> -----Ursprüngliche Nachricht-----
> Von: <[hidden email]>
> Gesendet: 26.10.09 12:44:11
> An: <[hidden email]>
> Betreff: [dbunit-user] DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)

Hi

> I have created an expected results file that asserts OK on Windows
> but fails on UNIX with:
> junit.framework.ComparisonFailure: value (table=AUDIT, row=0, col=
> AUDIT_DATA) expected:<...ices/AuditData.xsd">[
>  <audit-detail>
>  <description>User Name</description>
>  <mime-type>text/xml</mime-type>
>  <data>Steve Sidejkick</data>
>  </audit-detail>
>  <audit-detail>
>  <description>User Roles</description>
>  <mime-type>text/xml</mime-type>
>  <data/>
>  </audit-detail>
> ]
> </audit>> but was:<...ices/AuditData.xsd">[
>  <audit-detail>
>  <description>User Name</description>
>  <mime-type>text/xml</mime-type>
>  <data>Steve Sidejkick</data>
>  </audit-detail>
>  <audit-detail>
>  <description>User Roles</description>
>  <mime-type>text/xml</mime-type>
>  <data/>
>  </audit-detail>]
> </audit>>
>
> Now I have tried saving the file (on my PC) to UNIX format within
> Eclipse but when I check this into SVN I notice my file is in DOS
> format again
> The expected results file is:
> <?xmlversion='1.0'encoding='UTF-8'?>
> <dataset>
> <SYNT_AUDITAUDIT_ID="6556"AUDIT_DATA="<audit xmlns="http://
> www.myco.com/AuditData.xsd">
 <audit-detail>&#
> xD;
 <description>User Name</description>
 &
> lt;mime-type>text/xml</mime-type>
 <data>
> Steve Sidejkick</data>
 </audit-detail>

> <audit-detail>
 <description>User Roles</
> description>
 <mime-type>text/xml</mime-type>&
> #xD;
 <data/>
 </audit-detail>
</

> audit>"AR_TIMESTAMP="[NULL]"AR_INSERT_TIMESTAMP="[NULL]"/>
> </dataset>
>
> Steve Hicks
> BT Innovate & Design | Customer Innovation Solutions | Lead Software
> Engineer
> Phone: +44 (0) 117 3024378
> Mobile: +44 (0) 7720 425253
> FAX: +44 (0) 2920 397035
> SMTP: [hidden email]
> Office: pp 1/098, Ty Cynnal, Watkiss Way, Cardiff, CF11 0SW
> This email contains BT information, which may be privileged or
> confidential.
> It's meant only for the individual(s) or entity named above. If you'
> re not the intended
> recipient, note that disclosing, copying, distributing or using this
> information
> is prohibited. If you've received this email in error, please let me
> know immediately
> on the email address above. Thank you.
> We monitor our email system, and may record your emails.
> British Telecommunications plc
> Registered office: 81 Newgate Street London EC1A 7AJ
> Registered in England no: 1800000
> Think before you print. Please consider the environment before
> printing this email
> ----------------------------------------------------------------------
> -------- Come build with us! The BlackBerry(R) Developer Conference
> in SF, CA is the only developer event you need to attend this year.
> Jumpstart your developing skills, take BlackBerry mobile applications
> to market and stay ahead of the curve. Join us from November 9 - 12,
> 2009. Register now! http://p.sf.net/sfu/devconference_________________
> ______________________________ dbunit-user mailing list dbunit-user@
> lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/
>
> dbunit-user


______________________________________________________
GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://movieflat.web.de


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

Re: DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)

steven.hicks

 Matthias

Thanks for the suggestion but the SVN property is already set to native (which explains why it set it back to DOS on windows). Still something new I learned!

Regards

Steve

-----Original Message-----
From: Matthias Gommeringer [mailto:[hidden email]]
Sent: 26 October 2009 20:30
To: [hidden email]
Subject: Re: [dbunit-user] DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)

Hi Steve,

you may be able to solve your problem by setting the SVN property "svn:eol-style" to "native" for this file. See http://svnbook.red-bean.com/en/1.4/svn.advanced.props.file-portability.html

rgds,
matthias


> -----Ursprüngliche Nachricht-----
> Von: <[hidden email]>
> Gesendet: 26.10.09 12:44:11
> An: <[hidden email]>
> Betreff: [dbunit-user] DbUnit 2.4.4 - assertEquals for Oracle 10 clob
> works on Windows but not UNIX (our CI environment)

Hi

> I have created an expected results file that asserts OK on Windows but
> fails on UNIX with:
> junit.framework.ComparisonFailure: value (table=AUDIT, row=0, col=
> AUDIT_DATA) expected:<...ices/AuditData.xsd">[
>  <audit-detail>
>  <description>User Name</description>
>  <mime-type>text/xml</mime-type>
>  <data>Steve Sidejkick</data>
>  </audit-detail>
>  <audit-detail>
>  <description>User Roles</description>  
> <mime-type>text/xml</mime-type>  <data/>  </audit-detail> ] </audit>>
> but was:<...ices/AuditData.xsd">[  <audit-detail>  <description>User
> Name</description>  <mime-type>text/xml</mime-type>  <data>Steve
> Sidejkick</data>  </audit-detail>  <audit-detail>  <description>User
> Roles</description>  <mime-type>text/xml</mime-type>  <data/>  
> </audit-detail>] </audit>>
>
> Now I have tried saving the file (on my PC) to UNIX format within
> Eclipse but when I check this into SVN I notice my file is in DOS
> format again The expected results file is:
> <?xmlversion='1.0'encoding='UTF-8'?>
> <dataset>
> <SYNT_AUDITAUDIT_ID="6556"AUDIT_DATA="<audit xmlns="http://
> www.myco.com/AuditData.xsd">
 <audit-detail>&#
> xD;
 <description>User Name</description>
 &
> lt;mime-type>text/xml</mime-type>
 <data>
> Steve Sidejkick</data>
 </audit-detail>

> <audit-detail>
 <description>User Roles</
> description>
 <mime-type>text/xml</mime-type>&
> #xD;
 <data/>
 </audit-detail>
</

> audit>"AR_TIMESTAMP="[NULL]"AR_INSERT_TIMESTAMP="[NULL]"/>
> </dataset>
>
> Steve Hicks
> BT Innovate & Design | Customer Innovation Solutions | Lead Software
> Engineer
> Phone: +44 (0) 117 3024378
> Mobile: +44 (0) 7720 425253
> FAX: +44 (0) 2920 397035
> SMTP: [hidden email]
> Office: pp 1/098, Ty Cynnal, Watkiss Way, Cardiff, CF11 0SW This email
> contains BT information, which may be privileged or confidential.
> It's meant only for the individual(s) or entity named above. If you'
> re not the intended
> recipient, note that disclosing, copying, distributing or using this
> information is prohibited. If you've received this email in error,
> please let me know immediately on the email address above. Thank you.
> We monitor our email system, and may record your emails.
> British Telecommunications plc
> Registered office: 81 Newgate Street London EC1A 7AJ Registered in
> England no: 1800000 Think before you print. Please consider the
> environment before printing this email
> ----------------------------------------------------------------------
> -------- Come build with us! The BlackBerry(R) Developer Conference in
> SF, CA is the only developer event you need to attend this year.
> Jumpstart your developing skills, take BlackBerry mobile applications
> to market and stay ahead of the curve. Join us from November 9 - 12,
> 2009. Register now! http://p.sf.net/sfu/devconference_________________
> ______________________________ dbunit-user mailing list dbunit-user@
> lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/
>
> dbunit-user


______________________________________________________
GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://movieflat.web.de


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

Re: DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)

Matthias Gommeringer
In reply to this post by steven.hicks
Steve,
please also have a look at this one: http://sourceforge.net/tracker/index.php?func=detail&aid=948472&group_id=47439&atid=449491
Do you use the FlatXmlDataSet or the full blown XmlDataSet? Please provide a test case if you're still stuck.
rgds,
matthias

>
>  Matthias
>
> Thanks for the suggestion but the SVN property is already set to native (which explains why it set it back to DOS on windows). Still something new I learned!
>
> Regards
>
> Steve
>
> -----Original Message-----
> From: Matthias Gommeringer [mailto:[hidden email]]
> Sent: 26 October 2009 20:30
> To: [hidden email]
> Subject: Re: [dbunit-user] DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)
>
> Hi Steve,
>
> you may be able to solve your problem by setting the SVN property "svn:eol-style" to "native" for this file. See http://svnbook.red-bean.com/en/1.4/svn.advanced.props.file-portability.html
>
> rgds,
> matthias
>
>
> > -----Ursprüngliche Nachricht-----
> > Von: <[hidden email]>
> > Gesendet: 26.10.09 12:44:11
> > An: <[hidden email]>
> > Betreff: [dbunit-user] DbUnit 2.4.4 - assertEquals for Oracle 10 clob
> > works on Windows but not UNIX (our CI environment)
>
> Hi
> > I have created an expected results file that asserts OK on Windows but
> > fails on UNIX with:
> > junit.framework.ComparisonFailure: value (table=AUDIT, row=0, col=
> > AUDIT_DATA) expected:<...ices/AuditData.xsd">[
> >  <audit-detail>
> >  <description>User Name</description>
> >  <mime-type>text/xml</mime-type>
> >  <data>Steve Sidejkick</data>
> >  </audit-detail>
> >  <audit-detail>
> >  <description>User Roles</description>  
> > <mime-type>text/xml</mime-type>  <data/>  </audit-detail> ] </audit>>
> > but was:<...ices/AuditData.xsd">[  <audit-detail>  <description>User
> > Name</description>  <mime-type>text/xml</mime-type>  <data>Steve
> > Sidejkick</data>  </audit-detail>  <audit-detail>  <description>User
> > Roles</description>  <mime-type>text/xml</mime-type>  <data/>  
> > </audit-detail>] </audit>>
> >
> > Now I have tried saving the file (on my PC) to UNIX format within
> > Eclipse but when I check this into SVN I notice my file is in DOS
> > format again The expected results file is:
> > <?xmlversion='1.0'encoding='UTF-8'?>
> > <dataset>
> > <SYNT_AUDITAUDIT_ID="6556"AUDIT_DATA="<audit xmlns="http://
> > www.myco.com/AuditData.xsd">
>  <audit-detail>&#
> > xD;
>  <description>User Name</description>
>  &
> > lt;mime-type>text/xml</mime-type>
>  <data>
> > Steve Sidejkick</data>
>  </audit-detail>
>
> > <audit-detail>
>  <description>User Roles</
> > description>
>  <mime-type>text/xml</mime-type>&
> > #xD;
>  <data/>
>  </audit-detail>
> </
> > audit>"AR_TIMESTAMP="[NULL]"AR_INSERT_TIMESTAMP="[NULL]"/>
> > </dataset>
> >
> > Steve Hicks
> > BT Innovate & Design | Customer Innovation Solutions | Lead Software
> > Engineer
> > Phone: +44 (0) 117 3024378
> > Mobile: +44 (0) 7720 425253
> > FAX: +44 (0) 2920 397035
> > SMTP: [hidden email]
> > Office: pp 1/098, Ty Cynnal, Watkiss Way, Cardiff, CF11 0SW This email
> > contains BT information, which may be privileged or confidential.
> > It's meant only for the individual(s) or entity named above. If you'
> > re not the intended
> > recipient, note that disclosing, copying, distributing or using this
> > information is prohibited. If you've received this email in error,
> > please let me know immediately on the email address above. Thank you.
> > We monitor our email system, and may record your emails.
> > British Telecommunications plc
> > Registered office: 81 Newgate Street London EC1A 7AJ Registered in
> > England no: 1800000 Think before you print. Please consider the
> > environment before printing this email
> > ----------------------------------------------------------------------
> > -------- Come build with us! The BlackBerry(R) Developer Conference in
> > SF, CA is the only developer event you need to attend this year.
> > Jumpstart your developing skills, take BlackBerry mobile applications
> > to market and stay ahead of the curve. Join us from November 9 - 12,
> > 2009. Register now! http://p.sf.net/sfu/devconference_________________
> > ______________________________ dbunit-user mailing list dbunit-user@
> > lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/
> >
> > dbunit-user
>
>
> ______________________________________________________
> GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://movieflat.web.de
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> dbunit-user mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> dbunit-user mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>


______________________________________________________
GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://movieflat.web.de


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

Re: DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)

Matthias Gommeringer
In reply to this post by steven.hicks
I might have an idea of what happens (but still guessing since I did not try it out).
1. You create the expected result flat XML under windows which is why you have the "&#xD;&#xA;" sequence (CR and LF)
2. This file is checked out as is (CR and LF remain since they are escaped in the flat XML attribute string) on unix and then compared to the results you load from the DB.
3. The results have been stored into the DB already (during test execution) using the unix "LF" only
=> the comparison fails since the comparison is really literally by default

To solve this one of the following may help:
- use the full blown dbunit XML and the put your nested XML into a CDATA section
- create a custom datatype and datatypefactory which is used for the XML columns and which denormalizes or ignores all CRs/LFs (actually this kind of an XmlDataType might be handy for other users as well)
- force the XML inserted into the DB to always use "CR and LF" (don't know whether this is possible)

Good luck ;)

BTW, please share this information with the community using the users mailing list. As long as there is no customer data around this shouldn't be an issue.

Regards,
matthias

> Matthias
>
> re: Values with newlines cannot be compared with assertEquals - ID: 948472
>
> Is this still an open bug? Looking at the change reports this was fixed in release 2.3.0 and I am using 2.4.4
>
> I use FlatXmlDataSet. I wonder if this is an issue on the &#xD (carriage-return) after /audit-detail which seems to be working differently on UNIX and windows.
>
>
> I am not sure how much detail you need for a test case but:
>
> I use Oracle 10.2.0
>
> Table create:
> CREATE TABLE "AUDIT"
>    ( "AUDIT_ID" NUMBER(38,0),
> "PERSONAL_ID" VARCHAR2(64 BYTE),
> "PORTAL_ID" VARCHAR2(28 BYTE),
> "CORRELATION_ID" CHAR(8 BYTE),
> "BUSINESS_ID" VARCHAR2(64 BYTE),
> "TRANSACTION_ID" VARCHAR2(64 BYTE),
> "HOST_NAME" VARCHAR2(64 BYTE) NOT NULL ENABLE,
> "CREATION_TIME" DATE NOT NULL ENABLE,
> "RECORD_TYPE" VARCHAR2(64 BYTE) NOT NULL ENABLE,
> "AUDIT_DATA" CLOB NOT NULL ENABLE,
> "AR_TIMESTAMP" DATE,
> "AR_INSERT_TIMESTAMP" DATE,
> PRIMARY KEY ("AUDIT_ID") )
>
> The working expected results (on windows OK, UNIX fail) is attached
>
>
> I have created an expected results file that asserts OK on Windows but fails on UNIX with:
>
> junit.framework.ComparisonFailure: value (table=AUDIT, row=0, col=AUDIT_DATA) expected:<...ices/AuditData.xsd">[
>   <audit-detail>
>     <description>User Name</description>
>     <mime-type>text/xml</mime-type>
>     <data>Steve Sidejkick</data>
>   </audit-detail>
>   <audit-detail>
>     <description>User Roles</description>
>     <mime-type>text/xml</mime-type>
>     <data/>
>   </audit-detail>
> ]
> </audit>> but was:<...ices/AuditData.xsd">[
>   <audit-detail>
>     <description>User Name</description>
>     <mime-type>text/xml</mime-type>
>     <data>Steve Sidejkick</data>
>   </audit-detail>
>   <audit-detail>
>     <description>User Roles</description>
>     <mime-type>text/xml</mime-type>
>     <data/>
>   </audit-detail>]
> </audit>>
>
>
> -----Original Message-----
> From: Matthias Gommeringer [mailto:[hidden email]]
> Sent: 26 October 2009 22:43
> To: [hidden email]
> Subject: Re: [dbunit-user] DbUnit 2.4.4 - assertEquals for Oracle 10 clob works on Windows but not UNIX (our CI environment)
>
> Steve,
> please also have a look at this one: http://sourceforge.net/tracker/index.php?func=detail&aid=948472&group_id=47439&atid=449491
> Do you use the FlatXmlDataSet or the full blown XmlDataSet? Please provide a test case if you're still stuck.
> rgds,
> matthias
>
> >
> >  Matthias
> >
> > Thanks for the suggestion but the SVN property is already set to native (which explains why it set it back to DOS on windows). Still something new I learned!
> >
> > Regards
> >
> > Steve
> >
> > -----Original Message-----
> > From: Matthias Gommeringer [mailto:[hidden email]]
> > Sent: 26 October 2009 20:30
> > To: [hidden email]
> > Subject: Re: [dbunit-user] DbUnit 2.4.4 - assertEquals for Oracle 10
> > clob works on Windows but not UNIX (our CI environment)
> >
> > Hi Steve,
> >
> > you may be able to solve your problem by setting the SVN property
> > "svn:eol-style" to "native" for this file. See
> > http://svnbook.red-bean.com/en/1.4/svn.advanced.props.file-portability
> > .html
> >
> > rgds,
> > matthias
> >
> >
> > > -----Ursprüngliche Nachricht-----
> > > Von: <[hidden email]>
> > > Gesendet: 26.10.09 12:44:11
> > > An: <[hidden email]>
> > > Betreff: [dbunit-user] DbUnit 2.4.4 - assertEquals for Oracle 10
> > > clob works on Windows but not UNIX (our CI environment)
> >
> > Hi
> > > I have created an expected results file that asserts OK on Windows
> > > but fails on UNIX with:
> > > junit.framework.ComparisonFailure: value (table=AUDIT, row=0, col=
> > > AUDIT_DATA) expected:<...ices/AuditData.xsd">[
> > >  <audit-detail>
> > >  <description>User Name</description>  
> > > <mime-type>text/xml</mime-type>  <data>Steve Sidejkick</data>  
> > > </audit-detail>  <audit-detail>  <description>User
> > > Roles</description> <mime-type>text/xml</mime-type>  <data/>  
> > > </audit-detail> ] </audit>> but was:<...ices/AuditData.xsd">[  
> > > <audit-detail>  <description>User Name</description>  
> > > <mime-type>text/xml</mime-type>  <data>Steve Sidejkick</data>  
> > > </audit-detail>  <audit-detail>  <description>User
> > > Roles</description>  <mime-type>text/xml</mime-type>  <data/>
> > > </audit-detail>] </audit>>
> > >
> > > Now I have tried saving the file (on my PC) to UNIX format within
> > > Eclipse but when I check this into SVN I notice my file is in DOS
> > > format again The expected results file is:
> > > <?xmlversion='1.0'encoding='UTF-8'?>
> > > <dataset>
> > > <SYNT_AUDITAUDIT_ID="6556"AUDIT_DATA="<audit xmlns="http://
> > > www.myco.com/AuditData.xsd">
> >  <audit-detail>&#
> > > xD;
> >  <description>User Name</description>
> >  &
> > > lt;mime-type>text/xml</mime-type>
> >  <data>
> > > Steve Sidejkick</data>
> >  </audit-detail>
> >
> > > <audit-detail>
> >  <description>User Roles</
> > > description>
> >  <mime-type>text/xml</mime-type>&
> > > #xD;
> >  <data/>
> >  </audit-detail>
> > </
> > > audit>"AR_TIMESTAMP="[NULL]"AR_INSERT_TIMESTAMP="[NULL]"/>
> > > </dataset>
> > >
> > > Steve Hicks
> > > BT Innovate & Design | Customer Innovation Solutions | Lead Software
> > > Engineer
> > > Phone: +44 (0) 117 3024378
> > > Mobile: +44 (0) 7720 425253
> > > FAX: +44 (0) 2920 397035
> > > SMTP: [hidden email]
> > > Office: pp 1/098, Ty Cynnal, Watkiss Way, Cardiff, CF11 0SW This
> > > email contains BT information, which may be privileged or confidential.
> > > It's meant only for the individual(s) or entity named above. If you'
> > > re not the intended
> > > recipient, note that disclosing, copying, distributing or using this
> > > information is prohibited. If you've received this email in error,
> > > please let me know immediately on the email address above. Thank you.
> > > We monitor our email system, and may record your emails.
> > > British Telecommunications plc
> > > Registered office: 81 Newgate Street London EC1A 7AJ Registered in
> > > England no: 1800000 Think before you print. Please consider the
> > > environment before printing this email
> > > --------------------------------------------------------------------
> > > --
> > > -------- Come build with us! The BlackBerry(R) Developer Conference
> > > in SF, CA is the only developer event you need to attend this year.
> > > Jumpstart your developing skills, take BlackBerry mobile
> > > applications to market and stay ahead of the curve. Join us from
> > > November 9 - 12, 2009. Register now!
> > > http://p.sf.net/sfu/devconference_________________
> > > ______________________________ dbunit-user mailing list dbunit-user@
> > > lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/
> > >
> > > dbunit-user
> >
> >
> > ______________________________________________________
> > GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT!
> > Jetzt freischalten unter http://movieflat.web.de
> >
> >
> > ----------------------------------------------------------------------
> > -------- Come build with us! The BlackBerry(R) Developer Conference in
> > SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> > http://p.sf.net/sfu/devconference
> > _______________________________________________
> > dbunit-user mailing list
> > [hidden email]
> > https://lists.sourceforge.net/lists/listinfo/dbunit-user
> >
> > ----------------------------------------------------------------------
> > -------- Come build with us! The BlackBerry(R) Developer Conference in
> > SF, CA is the only developer event you need to attend this year.
> > Jumpstart your developing skills, take BlackBerry mobile applications
> > to market and stay ahead of the curve. Join us from November 9 - 12,
> > 2009. Register now!
> > http://p.sf.net/sfu/devconference
> > _______________________________________________
> > dbunit-user mailing list
> > [hidden email]
> > https://lists.sourceforge.net/lists/listinfo/dbunit-user
> >
>
>
> ______________________________________________________
> GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://movieflat.web.de
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> dbunit-user mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>
>


_______________________________________________________________
Neu: WEB.DE DSL bis 50.000 kBit/s und 200,- Euro Startguthaben!
http://produkte.web.de/go/02/


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user