ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean-Francois Poilpret" <jfpoilp...@hcm.vnn.vn>
Subject RE: Junit / Ibatis Configuration Problem
Date Wed, 12 Oct 2005 00:00:21 GMT
Hi Niels,

I think the following line in  your XML is responsible:

		user_id = #userId"

I'm not sure all parsers would accept a quote between 2 tags?

Cheers

	Jean-Francois

-----Original Message-----
From: Voorhoeve, Niels {PBG} [mailto:niels.voorhoeve@pepsi.com] 
Sent: Wednesday, October 12, 2005 2:28 AM
To: user-java@ibatis.apache.org
Subject: RE: Junit / Ibatis Configuration Problem

It seems the issue is my <dynamic> tag in the <select> element.  Anyone have
an idea why the following is unacceptable?
I have version 2.1.5.  As far as I can tell it conforms.

Thanks,
Niels
    <select id="getPurchaseHeader" parameterClass="PurchaseHeader"
        	resultMap="PurchaseHeader-result" >
        
            select
                order_no  ,
                status_code  ,
                order_date  ,
                user_id  ,
                user_name  ,
                charge_to_corp  ,
                franchise_location  ,
                corp_location  ,
                order_type  ,
                supplier_no  ,
                pa_code  ,
                fob_point  ,
                ship_via  ,
                payment_terms_code  ,
                project_number  ,
                backhaul_flag  ,
                advance_ship_notice  ,
                attention  ,
                phone  ,
                check_no  ,
                check_date  ,
                total_paid_check  ,
                total_paid_order  ,
                freight_amount  ,
                ap_attachments  ,
                ap_separate_check  ,
                no_of_payments  ,
                payment_cycle  ,
                first_due_date  ,
                orig_po_no  ,
                sup_ref_no  ,
                sup_ref_date  ,
                tax_code  ,
                gl_tax_no  ,
                orig_due_date  ,
                rev_due_date  ,
                begin_pay_terms_date  ,
                longest_lead_time  ,
                tax_rate  ,
                no_of_receipts  ,
                no_of_validation  ,
                total_order_amount  ,
                prev_check_no  ,
                bank_id  ,
                prev_bank_id  ,
                mg_tracking_no  ,
                accounting_period  ,
                charge_to_id  ,
                charge_to_name  ,
                cate_onestep_flag  ,
                processing_corp  ,
                check_descr_code  ,
                check_descr  ,
                freight_taxable_flag  ,
                change_no  ,
                record_date  ,
                last_act_date  ,
                supplier_location_no  ,
                closed_date  ,
                loc_id  ,
                purch_tax_ent_id  ,
                po_multi_chrgto_flg  ,
                po_adnd_flg  ,
                po_bkord_flg  ,
                po_bkord_orig_no  ,
                po_bkord_prnt_no  ,
                po_orig_user_id  ,
                po_paybill_flg  ,
                po_frght_tax_amt  ,
                po_splr_tax_amt  ,
                supplier_shipfrom_location_no  ,
                row_last_updt_user_id  ,
                splr_invoice_dte  ,
                po_canc_reas_cde  ,
                po_rcvd_full_flg  ,
                po_bkord_remain_qty  ,
                purch_rqstr_loc_id  ,
                po_frght_tax_lvl_1_amt  ,
                po_frght_tax_lvl_2_amt  ,
                po_frght_tax_lvl_1_txbl_flg  ,
                po_frght_tax_lvl_2_txbl_flg  ,
                crcy_cde  ,
                crcy_rate 
            from
                PURCHASE_HEADER
 	<dynamic prepend="where">
        	<isNotEmpty prepend="and" property="orderNo">
        		order_no = #orderNo#
        	</isNotEmpty>
        	<isNotEmpty prepend="and" property="userId">
        		user_id = #userId"
       		</isNotEmpty>
       		<isNotEmpty prepend="and" property="userName">
                user_name = #userName#
        	</isNotEmpty>
        	<isNotEmpty prepend="and" property="supplierNo">
        		supplier_no = #supplierNo#
        	</isNotEmpty>
       </dynamic>
        
    </select> 

-----Original Message-----
From: Voorhoeve, Niels {PBG} [mailto:niels.voorhoeve@pepsi.com] 
Sent: Tuesday, October 11, 2005 11:44 AM
To: user-java@ibatis.apache.org
Subject: Junit / Ibatis Configuration Problem

Hi,

I'm having trouble using junit to test my ibatis setup.  I am able to run
'static void main' tests within Eclipse with no problem.  However when I run
the same test within Junit it fails.  It seems that Ibatis has trouble
parsing the configuration files when run via Junit and generates tons of
Xpath-related exceptions.  It makes no difference whether I run the Junit
tests via Eclipse or Ant on the command line.  I tried moving all the test,
configuration files and ibatis-related java files to the same package and
that did not help.  Has anyone dealt with this issue before?  

Thanks,
Niels




$ ant test
Buildfile: build.xml

test:
    [junit] Testsuite: com.pbg.aps.model.junit.ModelIBatisTestSuite
    [junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 1.047 sec
    [junit] ------------- Standard Output ---------------
    [junit] 2005-10-11 11:19:49,250 [main] ERROR
com.pbg.aps.model.junit.TestDbConfig - failed to load SqlMapClient
    [junit] com.ibatis.common.exception.NestedRuntimeException: Error
occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.
Ca
use: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath
'/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException: E
rror parsing XML.  Cause:
com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath
'/sqlMap/select'.  Cause: java.util.NoSuchElementExc
eption
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.exception.NestedRuntimeException:
Error parsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementExcept
ion
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.xml.NodeletException: Error parsing
XML.  Cause: com.ibatis.common.exception.NestedRuntimeException: Error pa
rsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementException
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.exception.NestedRuntimeException:
Error parsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementExcept
ion
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.exception.NestedRuntimeException:
Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.N
odeletException: Error parsing XML.  Cause:
com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath
'/sqlMap/select'.  Cause: java.uti
l.NoSuchElementException
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.exception.NestedRuntimeException:
Error parsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementExcept
ion
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.xml.NodeletException: Error parsing
XML.  Cause: com.ibatis.common.exception.NestedRuntimeException: Error pa
rsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementException
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.exception.NestedRuntimeException:
Error parsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementExcept
ion
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.xml.NodeletException: Error parsing
XML.  Cause: com.ibatis.common.exception.NestedRuntimeException: Error pa
rsing XPath '/sqlMapConfig/sqlMap'.  Cause:
com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause:
com.ibatis.common.exception.NestedRunti
meException: Error parsing XPath '/sqlMap/select'.  Cause:
java.util.NoSuchElementException
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.exception.NestedRuntimeException:
Error parsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementExcept
ion
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.xml.NodeletException: Error parsing
XML.  Cause: com.ibatis.common.exception.NestedRuntimeException: Error pa
rsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementException
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.exception.NestedRuntimeException:
Error parsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementExcept
ion
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.exception.NestedRuntimeException:
Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.N
odeletException: Error parsing XML.  Cause:
com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath
'/sqlMap/select'.  Cause: java.uti
l.NoSuchElementException
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.exception.NestedRuntimeException:
Error parsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementExcept
ion
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.xml.NodeletException: Error parsing
XML.  Cause: com.ibatis.common.exception.NestedRuntimeException: Error pa
rsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementException
    [junit] Caused by: java.util.NoSuchElementException
    [junit] Caused by: com.ibatis.common.exception.NestedRuntimeException:
Error parsing XPath '/sqlMap/select'.  Cause: java.util.NoSuchElementExcept
ion
    [junit] Caused by: java.util.NoSuchElementException
    [junit]     at
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigPa
rser.java:81)
    [junit]     at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientB
uilder.java:62)
    [junit]     at
com.pbg.aps.dbconfig.SqlMapManager.init(SqlMapManager.java:36)
    [junit]     at
com.pbg.aps.dbconfig.SqlMapManager.getClient(SqlMapManager.java:53)
    [junit]     at
com.pbg.aps.model.junit.TestDbConfig.testGetClient(TestDbConfig.java:30)
    [junit]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
    [junit]     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
    [junit]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
    [junit]     at java.lang.reflect.Method.invoke(Method.java:324)
    [junit]     at junit.framework.TestCase.runTest(TestCase.java:154)





Mime
View raw message