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:[EMAIL PROTECTED]
Sent: Wednesday, October 12, 2005 2:28 AM
To: [email protected]
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:[EMAIL PROTECTED]
Sent: Tuesday, October 11, 2005 11:44 AM
To: [email protected]
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)
