<transactionManag= er=20 type=3D"JDBC" >
  <dataSource=20 type=3D"SIMPLE">
   <property name=3D"JDBC.Driver"= =20 value=3D"oracle.jdbc.driver.OracleDriver"/>
   <pro= perty=20 name=3D"JDBC.ConnectionURL"=20 value=3D"jdbc:oracle:thin:@10.0.97.70:1522:UAT"/>
   &= lt;property=20 name=3D"JDBC.Username"=20 value=3D"SPS_AHCSMIG_CONNECT"/>
   <property=20 name=3D"JDBC.Password"=20 value=3D"SPS_AHCSMIG_CONNECT"/>
   <property=20 name=3D"JDBC.DefaultAutoCommit" value=3D"true"=20 />
   <property name=3D"Pool.MaximumActiveConnectio= ns"=20 value=3D"10"/>
   <property=20 name=3D"Pool.MaximumIdleConnections"=20 value=3D"5"/>
   <property name=3D"Pool.MaximumChec= koutTime"=20 value=3D"120000"/>
   <property name=3D"Pool.TimeTo= Wait"=20 value=3D"500"/>
   <property name=3D"Pool.PingQuery= "=20 value=3D"select * from TDIF_NOTES"/>
   <property=20 name=3D"Pool.PingEnabled" value=3D"false"/>
   <pro= perty=20 name=3D"Pool.PingConnectionsOlderThan"=20 value=3D"1"/>
   <property=20 name=3D"Pool.PingConnectionsNotUsedFor"=20 value=3D"1"/>
  </dataSource>
</transacti= onManager>

<sqlMap=20 resource=3D"ie/gov/agriculture/sps/app/dao/xml/IForisData.xml"/><= /DIV>

</sqlMapConfig>

-----Original Message-----
From: Brandon Goodin=20 [mailto:brandon.goodin@gmail.com]
Sent: 13 December 2006=20 16:08
To: user-java@ibatis.apache.org
Subject: Re: Pr= oblem=20 committing records using IBATIS in embedded jar file

= I see=20 Project A loads two different SQL Map configs with an odd @...@ syntax. Y= ou=20 only posted 1 of them for Project A. Please post the other as well. Also,= what=20 version of iBATIS are you using?

Brandon

On 12/13/06, R= oss,=20 Niall <Niall.Ross@agriculture.gov.= ie>=20 wrote:

Brandon,

&n= bsp;

Attached are the= essential=20 parts of the necessary files.

&n= bsp;

Regards,

Niall

--------------------------------------------------------------= ---

&n= bsp;

Proje= ct A=20 sql-map-config.xml

&n= bsp;

<sqlMapConfig>
=20 <settings
  cacheModelsEnabled=3D"true"
  = enhancementEnabled=3D"true"
  maxSessions=3D"64"
&nbs= p;maxTransactions=3D"8"
  maxRequests=3D"128"
  u= seStatementNamespaces=3D"true"/>=20


<transactionManager type=3D"JDBC"=20 >
  <dataSource=20 type=3D"SIMPLE">
   <property name=3D"JDBC.Driv= er"=20 value=3D"oracle.jdbc.driver.OracleDriver"/>
   <= ;property=20 name=3D"JDBC.ConnectionURL"=20 value=3D"jdbc:oracle:thin:@10.0.97.62:1521:TERRA"/>
  &= nbsp;<property=20 name=3D"JDBC.Username" value=3D"SPS_DEV"/>
   <= property=20 name=3D"JDBC.Password" value=3D"SPS_DEV"/>
   <= property=20 name=3D"JDBC.DefaultAutoCommit" value=3D"true"=20 />
   <property name=3D"Pool.MaximumActiveConne= ctions"=20 value=3D"10"/>
   <property=20 name=3D"Pool.MaximumIdleConnections"=20 value=3D"5"/>
   <property=20 name=3D"Pool.MaximumCheckoutTime"=20 value=3D"120000"/>
   <property name=3D"Pool.Ti= meToWait"=20 value=3D"500"/>
   <property name=3D"Pool.PingQ= uery"=20 value=3D"select * from=20 TDSP_NOTES_SAMPLE"/>
   <property=20 name=3D"Pool.PingEnabled" value=3D"false"/>
   <= ;property=20 name=3D"Pool.PingConnectionsOlderThan"=20 value=3D"1"/>
   <property=20 name=3D"Pool.PingConnectionsNotUsedFor"=20 value=3D"1"/>
  </dataSource>
</trans= actionManager>

<sqlMap= =20 resource=3D"ie/gov/agriculture/sps/app/dao/xml/EntCustLinkData.xml"/>= ;
<sqlMap=20 resource=3D"ie/gov/agriculture/sps/app/dao/xml/FarmerDetailsData.xml"/&= gt;
<sqlMap=20 resource=3D"ie/gov/agriculture/sps/app/dao/xml/CodeTable.xml"/>=20
<sqlMap=20 resource=3D"ie/gov/agriculture/sps/app/dao/xml/ScannedDocumentSummaryDa= ta.xml"/>
<sqlMap=20 resource=3D"ie/gov/agriculture/sps/app/dao/xml/NotesData.xml"/>
&= nbsp;<sqlMap=20 resource=3D"ie/gov/agriculture/sps/app/dao/xml/CommonageAllocData.xml"/= >
.....
.....

</sqlMapConf= ig>

&n= bsp;

Proje= ct A=20 dao.xml

&n= bsp;

<daoConfig>

<context>
     <= !--=20 Static content -->
  <transactionManager=20 type=3D"SQLMAP">
   <property=20
    name=3D"SqlMapConfigResource"
&nbs= p;  value=3D"ie/gov/agriculture/sps/app/dao/xml/@SQL_CONFIG_MAP@"/=20 >
  </transactionManager>
&nbs= p;<dao=20 interface=3D"ie.gov.agriculture.sps.app.dao.PrePrintDetailsDAO"=20
   implementation=3D"ie.gov.agriculture.sps.app.dao.= impl.PrePrintDetailsSQLMapDAO"/>
  <dao=20 interface=3D"ie.gov.agriculture.sps.app.dao.ApplicationDAO"=20
   implementation=3D"ie.gov.agriculture.sps.app.dao.= impl.ApplicationSQLMapDAO"/>
  <dao=20 interface=3D"ie.gov.agriculture.sps.app.dao.EntCustLinkDAO"=20
   implementation=3D"ie.gov.agriculture.sps.app.dao.= impl.EntCustLinkSQLMapDAO"/>
  <dao=20 interface=3D"ie.gov.agriculture.sps.app.dao.StopsDAO"=20
   implementation=3D"ie.gov.agriculture.sps.app.dao.= impl.StopsSQLMapDAO"/>
  <dao=20 interface=3D"ie.gov.agriculture.sps.app.dao.FarmerSearchDAO"=20
   implementation=3D"ie.gov.agriculture.sps.app.dao.= impl.FarmerSearchJDBCDAO"/>
  <dao=20 interface=3D"ie.gov.agriculture.sps.app.dao.CodeDAO"=20
   implementation=3D"ie.gov.agriculture.sps.app.dao.= impl.CodeTableDAO"/>
  <dao=20 interface=3D"ie.gov.agriculture.sps.app.dao.ScannedDocumentSummaryDAO"= =20
   implementation=3D"ie.gov.agriculture.sps.app.dao.= impl.ScannedDocumentSummarySQLMapDAO"/>
  <dao=20 interface=3D"ie.gov.agriculture.sps.app.dao.ScannedDocumentImagesDAO"=20
   implementation=3D"ie.gov.agriculture.sps.app.dao.= impl.ScannedDocumentImageSQLMAPDAO"/>
  =20
  <dao=20 interface=3D"ie.gov.agriculture.sps.app.dao.CommonageAllocDAO"=20
   implementation=3D"ie.gov.agriculture.sps.app.dao.= impl.CommonageAllocSQLMapDAO"/>
      <= BR>  ....
  ....
</context>

   <context>
  =20   
  <transactionManager=20 type=3D"SQLMAP">
   <property=20
    name=3D"SqlMapConfigResource"
&nbs= p;  value=3D" ie/gov/agriculture/sps/app/dao/xml/@SQL_CONFIG_MAP_IFORIS@"/>
  </transactionManager>

&= nbsp; <dao=20 interface=3D"ie.gov.agriculture.sps.app.dao.IForisDAO"=20
   implementation=3D"ie.gov.agriculture.sps.app.dao.= impl.IForisSQLMapDAO"/>
</context>

</daoConfig>

Proje= ct B=20 sql-map-config.xml

&n= bsp;

<sqlMapConfig>
=20 <settings
  cacheModelsEnabled=3D"true"
  = enhancementEnabled=3D"true"
  maxSessions=3D"64"
&nbs= p;maxTransactions=3D"8"
  maxRequests=3D"128"
  u= seStatementNamespaces=3D"true"/>=20


<transactionManager type=3D"JDBC"=20 >
  <dataSource=20 type=3D"SIMPLE">
   <property name=3D"JDBC.Driv= er"=20 value=3D"oracle.jdbc.driver.OracleDriver"/>
   <= ;property=20 name=3D"JDBC.ConnectionURL"=20 value=3D"jdbc:oracle:thin:@10.0.97.62:1521:TERRA"/>
  &= nbsp;<property=20 name=3D"JDBC.Username" value=3D"SPS_DEV"/>
   <= property=20 name=3D"JDBC.Password" value=3D"SPS_DEV"/>
   <= property=20 name=3D"JDBC.DefaultAutoCommit" value=3D"true"=20 />
   <property name=3D"Pool.MaximumActiveConne= ctions"=20 value=3D"10"/>
   <property=20 name=3D"Pool.MaximumIdleConnections"=20 value=3D"5"/>
   <property=20 name=3D"Pool.MaximumCheckoutTime"=20 value=3D"120000"/>
   <property name=3D"Pool.Ti= meToWait"=20 value=3D"500"/>
   <property name=3D"Pool.PingQ= uery"=20 value=3D"select * from=20 TDSP_NOTES_SAMPLE"/>
   <property=20 name=3D"Pool.PingEnabled" value=3D"false"/>
   <= ;property=20 name=3D"Pool.PingConnectionsOlderThan"=20 value=3D"1"/>
   <property=20 name=3D"Pool.PingConnectionsNotUsedFor"=20 value=3D"1"/>
  </dataSource>
</trans= actionManager>

<sqlMap= =20 resource=3D"ie/gov/agriculture/spsinet/app/dao/xml/SavedDraftData.xml"/= >

</sqlMapConfig>

Project B dao.xml

<daoConfig>

<context>
     <= !--=20 Static content -->
  <transactionManager=20 type=3D"SQLMAP">
   <property=20
    name=3D"SqlMapConfigResource"
&nbs= p;  value=3D"ie/gov/agriculture/spsinet/app/dao/xml/@SQL_CONFIG_MAP@= "/=20 >
  </transactionManager>

=   <dao=20 interface=3D"ie.gov.agriculture.spsinet.app.dao.SampleDraftSaveDAO"=20
   implementation=3D"ie.gov.agriculture.spsinet.app.= dao.impl.SampleDraftSaveSQLMapDAO"/>
  <dao= =20 interface=3D"ie.gov.agriculture.spsinet.app.dao.SavedDraftJDBCDAO"=20
   implementation=3D"ie.gov.agriculture.spsinet.app.= dao.impl.SavedDraftJDBCSQLMapDAO"/>
  <dao=20 interface=3D"ie.gov.agriculture.spsinet.app.dao.AgentSearchDAO"=20
   implementation=3D"ie.gov.agriculture.spsinet.app.= dao.impl.AgentSearchJDBCDAO"/>


</context>
</daoConfig>

&n= bsp;

--------------------------------------------------------------= -------------------------------------------------

Suppo= rting=20 Code

The following co= de is the=20 code that is failing to commit. The DAOConfig in question below is=20

coming from Proj= ect A so is=20 therefore associtaed with dao.xml from that project=20 above.

&n= bsp;

DaoManager= manager =3D=20 null;
       =20
       =20 try
       =20 {
           = =20 manager =3D=20 DAOConfig.getDaomanager();
       = ;    =20 /* Insert a record on the Application Table=20 */
           = ; dao=20 =3D (ApplicationDAO)=20 manager.getDao(ApplicationDAO.class);
     =       =20
           = =20 manager.startTransaction();
      &nbs= p;     //various=20 inserts

          &n= bsp; manager.commitTransaction();

  &nbs= p; =20 }
        catch (Exception=20 e)
       =20 {
           = =20 throw new=20 SPSBusinessException(e);
       = =20 }
       =20 finally
       =20 {
           = if=20 (manager !=3D=20 null)
          &n= bsp;=20 {
           =     =20
           &= nbsp;   =20 manager.endTransaction();
       =     =20 }
        }

&n= bsp;

&n= bsp;

&n= bsp;

-----Original Message-----
From= :=20 Brandon Goodin [mailto:brandon.goodin@gmail.com]
Sent: 12 Decemb= er 2006=20 15:40
To: user-java@ibatis.apache.org
Subject: Re: = Problem=20 committing records using IBATIS in embedded jar file

Please post your dao.xml and sqlmap-config.xml from Project= A=20 and ProjectB. Also, post any supporting code that is failing to commi= t=20 (code that loads the dao.xml, code that loads sqlmapconfig.xml, code = that=20 starts and commits the transaction, etc....). This will help us to se= e=20 what you are doing and will likely get you an answer that is not a gu= ess.=20

Brandon

On 12/12/06, Ross,=20 Niall <Niall.Ross@agriculture.gov.ie> wrote:=20
Hi,

I=20 am having the following problem and I was wondering had anyone=20 encountered this type of thing before
or could someone possibly = lend=20 a hand with a solution.

Ok here's the setup:

Project = A=20 uses ibatis to control all transaction management functionality nee= ded.=20
Project B also uses ibatis but also includes Project A in the f= orm=20 of a jar.

We are currently developing in Project B and wish = to=20 prevent duplication of code so we
want to re-use the DB related = calls=20 from Project A within Project B through the Project A jar.
With= me=20 so far???

When we execute code from Project A that alters a = table=20 in some way we use the DAOManager to
start, end and commit the=20 transactions. This is working in Project A.

The problem occu= rs=20 when trying to execute this same code through the jar file from wit= hin=20 Project B
as when we the execute the code the transaction does = not=20 get committed at all. It will however be committed
when I physic= ally=20 shutdown my local appserver.

It seems to me that there is so= me=20 sort of IBATIS config conflict problem when trying to execute=20 transaction management
in the way described above.

Does= =20 anyone have any=20 suggestions?

Regards,
Niall

**************= **************************************************************
*********= ******  Department=20 of Agriculture and Food ******************

The information= =20 contained in this email and in any attachments is
confidential a= nd is=20 designated solely for the attention and use of
the intended=20 recipient(s). This information may be subject to legal
and=20 professional privilege.  If you are not an intended recip= ient=20 of
this email, you must not use, disclose, copy, distribute or= =20 retain
this message or any part of it. If you have received this= =20 email in
error, please notify the sender immediately and delete = all=20 copies
of this email from your computer system(s).=20
***************************************************************= *************

**************************************************= **************************
****************  An=20 Roinn Talmha+AO0-ochta Agus Bia  *******************=20

T+AOE an t-eolais san r+AO0-omhphost seo, agus in aon=20 ceangl+AOE-in leis,
faoi phribhl+AOk-id agus faoi r+APo-n agus l= e=20 h-aghaigh an seola+AO0 amh+AOE-in.
D+IBk-fh+AOk-adfadh +AOE-bhar= an=20 seoladh seo bheith faoi phribhl+AOk-id
profisi+APo-nta n+APM=20 dl+AO0-thi+APo-il. Mura tusa an seola+AO0 a bh+AO0 beartaithe
le= is an=20 r+AO0-omhphost seo a fh+AOE-il, t+AOE cosc air, n+APM aon chuid de,=
a=20 +APo-s+AOE-id, a ch+APM-ipe+AOE-l, n+APM a scaoileadh.  M= +AOE=20 th+AOE-inig s+AOk chugat de
bharr dearmad, t+AOk-igh i=20 dteagmh+AOE-il leis an seolt+APM-ir agus scrios an
t-+AOE-bhar += APM=20 do r+AO0-omhaire le do=20 thoil.
*********************************************************= *******************

**********************************************= ******************************=20

*************** Department of Agricul= ture=20 and Food ******************

The information contained in this ema= il and=20 in any attachments is

confidential and is designated solely= for=20 the attention and use of

the intended recipient(s). This infor= mation=20 may be subject to legal

and professional privilege. If you ar= e not=20 an intended recipient of

this email, you must not use, disclos= e,=20 copy, distribute or retain

this message or any part of it. If yo= u have=20 received this email in

error, please notify the sender immed= iately=20 and delete all copies

of this email from your computer=20 system(s).

**********************************************= ******************************=20

**********************************************= ******************************=20

**************** An Roinn Talmha=EDoc= hta Agus=20 Bia *******************

T=E1 an t-eolais san r=EDomhphost seo= , agus in=20 aon ceangl=E1in leis,

faoi phribhl=E9id agus faoi r=FAn agu= s le=20 h-aghaigh an seola=ED amh=E1in.

D'fh=E9adfadh =E1bhar an seoladh seo = bheith faoi=20 phribhl=E9id

profisi=FAnta n=F3 dl=EDthi=FAil. Mur= a tusa an=20 seola=ED a bh=ED beartaithe

leis an r=EDomhphost seo a fh=E1il, t= =E1 cosc air,=20 n=F3 aon chuid de,

a =FAs=E1id, a ch=F3ipe=E1l, n=F3 a s= caoileadh. M=E1=20 th=E1inig s=E9 chugat de

bharr dearmad, t=E9igh i dteagmh=E1il= leis an=20 seolt=F3ir agus scrios an

t-=E1bhar =F3 do r=EDomhaire le do th= oil.=20

**********************************************= ******************************

*********************= *******************************************************

*************** Depa= rtment of Agriculture and Food ******************

The information conta= ined in this email and in any attachments is

confidential and is d= esignated solely for the attention and use of

the intended recipien= t(s). This information may be subject to legal

and professional priv= ilege. If you are not an intended recipient of

this email, you must = not use, disclose, copy, distribute or retain

this message or any p= art of it. If you have received this email in

error, please notify = the sender immediately and delete all copies

of this email from yo= ur computer system(s).

*********************= *******************************************************

**************** An = Roinn Talmhaíochta Agus Bia *******************

Tá an t-eolais= san ríomhphost seo, agus in aon ceangláin leis,

faoi phribhléi= d agus faoi rún agus le h-aghaigh an seolaí amháin.

D’fhéadf= adh ábhar an seoladh seo bheith faoi phribhléid

profisiúnta n&= oacute; dlíthiúil. Mura tusa an seolaí a bhí be= artaithe

leis an ríomhp= host seo a fháil, tá cosc air, nó aon chuid de,

a úsáid= , a chóipeál, nó a scaoileadh. Má tháin= ig sé chugat de

bharr dearmad, t&eacu= te;igh i dteagmháil leis an seoltóir agus scrios an

t-ábhar &oacut= e; do ríomhaire le do thoil.

*********************= *******************************************************

------_=_NextPart_001_01C71ED3.9E8CDB34--