Brandon,
Attached are the essential parts of the necessary files.
Regards,
Niall
-----------------------------------------------------------------
Project A sql-map-config.xml
<sqlMapConfig>
<settings
cacheModelsEnabled="true"
enhancementEnabled="true"
maxSessions="64"
maxTransactions="8"
maxRequests="128"
useStatementNamespaces="true"/>
<!--
<transactionManager type="EXTERNAL">
<dataSource type="JNDI">
<property name="DataSource" value="jdbc/ejb/SPS"/>
</dataSource>
</transactionManager>
-->
<transactionManager type="JDBC" >
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
<property name="JDBC.ConnectionURL"
value="jdbc:oracle:thin:@10.0.97.62:1521:TERRA"/>
<property name="JDBC.Username" value="SPS_DEV"/>
<property name="JDBC.Password" value="SPS_DEV"/>
<property name="JDBC.DefaultAutoCommit" value="true" />
<property name="Pool.MaximumActiveConnections" value="10"/>
<property name="Pool.MaximumIdleConnections" value="5"/>
<property name="Pool.MaximumCheckoutTime" value="120000"/>
<property name="Pool.TimeToWait" value="500"/>
<property name="Pool.PingQuery" value="select * from TDSP_NOTES_SAMPLE"/>
<property name="Pool.PingEnabled" value="false"/>
<property name="Pool.PingConnectionsOlderThan" value="1"/>
<property name="Pool.PingConnectionsNotUsedFor" value="1"/>
</dataSource>
</transactionManager>
<sqlMap resource="ie/gov/agriculture/sps/app/dao/xml/EntCustLinkData.xml"/>
<sqlMap resource="ie/gov/agriculture/sps/app/dao/xml/FarmerDetailsData.xml"/>
<sqlMap resource="ie/gov/agriculture/sps/app/dao/xml/CodeTable.xml"/>
<sqlMap
resource="ie/gov/agriculture/sps/app/dao/xml/ScannedDocumentSummaryData.xml"/>
<sqlMap resource="ie/gov/agriculture/sps/app/dao/xml/NotesData.xml"/>
<sqlMap resource="ie/gov/agriculture/sps/app/dao/xml/CommonageAllocData.xml"/>
.....
.....
</sqlMapConfig>
Project A dao.xml
<daoConfig>
<!-- iBatis DAO configuration file -->
<context>
<!-- Static content -->
<transactionManager type="SQLMAP">
<property
name="SqlMapConfigResource"
value=" ie/gov/agriculture/sps/app/dao/xml/@SQL_CONFIG_MAP@"/
<mailto:ie/gov/agriculture/sps/app/dao/xml/@SQL_CONFIG_MAP@> >
</transactionManager>
<dao interface="ie.gov.agriculture.sps.app.dao.PrePrintDetailsDAO"
implementation="ie.gov.agriculture.sps.app.dao.impl.PrePrintDetailsSQLMapDAO"/>
<dao interface="ie.gov.agriculture.sps.app.dao.ApplicationDAO"
implementation="ie.gov.agriculture.sps.app.dao.impl.ApplicationSQLMapDAO"/>
<dao interface="ie.gov.agriculture.sps.app.dao.EntCustLinkDAO"
implementation="ie.gov.agriculture.sps.app.dao.impl.EntCustLinkSQLMapDAO"/>
<dao interface="ie.gov.agriculture.sps.app.dao.StopsDAO"
implementation="ie.gov.agriculture.sps.app.dao.impl.StopsSQLMapDAO"/>
<dao interface="ie.gov.agriculture.sps.app.dao.FarmerSearchDAO"
implementation="ie.gov.agriculture.sps.app.dao.impl.FarmerSearchJDBCDAO"/>
<dao interface="ie.gov.agriculture.sps.app.dao.CodeDAO"
implementation="ie.gov.agriculture.sps.app.dao.impl.CodeTableDAO"/>
<dao interface="ie.gov.agriculture.sps.app.dao.ScannedDocumentSummaryDAO"
implementation="ie.gov.agriculture.sps.app.dao.impl.ScannedDocumentSummarySQLMapDAO"/>
<dao interface="ie.gov.agriculture.sps.app.dao.ScannedDocumentImagesDAO"
implementation="ie.gov.agriculture.sps.app.dao.impl.ScannedDocumentImageSQLMAPDAO"/>
<!--
<dao interface="ie.gov.agriculture.sps.app.dao.Audit"
implementation="ie.gov.agriculture.sps.app.dao.impl.AuditDAO"/>-->
<dao interface="ie.gov.agriculture.sps.app.dao.CommonageAllocDAO"
implementation="ie.gov.agriculture.sps.app.dao.impl.CommonageAllocSQLMapDAO"/>
....
....
</context>
<context>
<!-- Static content -->
<transactionManager type="SQLMAP">
<property
name="SqlMapConfigResource"
value="
<mailto:ie/gov/agriculture/sps/app/dao/xml/@SQL_CONFIG_MAP_IFORIS@>
ie/gov/agriculture/sps/app/dao/xml/@SQL_CONFIG_MAP_IFORIS@"/>
</transactionManager>
<dao interface="ie.gov.agriculture.sps.app.dao.IForisDAO"
implementation="ie.gov.agriculture.sps.app.dao.impl.IForisSQLMapDAO"/>
</context>
</daoConfig>
Project B sql-map-config.xml
<sqlMapConfig>
<settings
cacheModelsEnabled="true"
enhancementEnabled="true"
maxSessions="64"
maxTransactions="8"
maxRequests="128"
useStatementNamespaces="true"/>
<!--
<transactionManager type="EXTERNAL">
<dataSource type="JNDI">
<property name="DataSource" value="jdbc/ejb/SPS"/>
</dataSource>
</transactionManager>
-->
<transactionManager type="JDBC" >
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
<property name="JDBC.ConnectionURL"
value="jdbc:oracle:thin:@10.0.97.62:1521:TERRA"/>
<property name="JDBC.Username" value="SPS_DEV"/>
<property name="JDBC.Password" value="SPS_DEV"/>
<property name="JDBC.DefaultAutoCommit" value="true" />
<property name="Pool.MaximumActiveConnections" value="10"/>
<property name="Pool.MaximumIdleConnections" value="5"/>
<property name="Pool.MaximumCheckoutTime" value="120000"/>
<property name="Pool.TimeToWait" value="500"/>
<property name="Pool.PingQuery" value="select * from TDSP_NOTES_SAMPLE"/>
<property name="Pool.PingEnabled" value="false"/>
<property name="Pool.PingConnectionsOlderThan" value="1"/>
<property name="Pool.PingConnectionsNotUsedFor" value="1"/>
</dataSource>
</transactionManager>
<sqlMap resource="ie/gov/agriculture/spsinet/app/dao/xml/SavedDraftData.xml"/>
</sqlMapConfig>
Project B dao.xml
<daoConfig>
<!-- iBatis DAO configuration file -->
<context>
<!-- Static content -->
<transactionManager type="SQLMAP">
<property
name="SqlMapConfigResource"
value=" ie/gov/agriculture/spsinet/app/dao/xml/@SQL_CONFIG_MAP@"/
<mailto:ie/gov/agriculture/spsinet/app/dao/xml/@SQL_CONFIG_MAP@> >
</transactionManager>
<dao interface="ie.gov.agriculture.spsinet.app.dao.SampleDraftSaveDAO"
implementation="ie.gov.agriculture.spsinet.app.dao.impl.SampleDraftSaveSQLMapDAO"/>
<dao interface="ie.gov.agriculture.spsinet.app.dao.SavedDraftJDBCDAO"
implementation="ie.gov.agriculture.spsinet.app.dao.impl.SavedDraftJDBCSQLMapDAO"/>
<dao interface="ie.gov.agriculture.spsinet.app.dao.AgentSearchDAO"
implementation="ie.gov.agriculture.spsinet.app.dao.impl.AgentSearchJDBCDAO"/>
</context>
</daoConfig>
---------------------------------------------------------------------------------------------------------------
Supporting Code
The following code is the code that is failing to commit. The DAOConfig in
question below is
coming from Project A so is therefore associtaed with dao.xml from that project
above.
DaoManager manager = null;
try
{
manager = DAOConfig.getDaomanager();
/* Insert a record on the Application Table */
dao = (ApplicationDAO) manager.getDao(ApplicationDAO.class);
manager.startTransaction();
//various inserts
manager.commitTransaction();
}
catch (Exception e)
{
throw new SPSBusinessException(e);
}
finally
{
if (manager != null)
{
manager.endTransaction();
}
}
-----Original Message-----
From: Brandon Goodin [mailto:[EMAIL PROTECTED]
Sent: 12 December 2006 15:40
To: [email protected]
Subject: Re: Problem committing records using IBATIS in embedded jar file
Please post your dao.xml and sqlmap-config.xml from ProjectA and ProjectB.
Also, post any supporting code that is failing to commit (code that loads the
dao.xml, code that loads sqlmapconfig.xml, code that starts and commits the
transaction, etc....). This will help us to see what you are doing and will
likely get you an answer that is not a guess.
Brandon
On 12/12/06, Ross, Niall < [EMAIL PROTECTED]> wrote:
Hi,
I am having the following problem and I was wondering had anyone encountered
this type of thing before
or could someone possibly lend a hand with a solution.
Ok here's the setup:
Project A uses ibatis to control all transaction management functionality
needed.
Project B also uses ibatis but also includes Project A in the form of a jar.
We are currently developing in Project B and wish to prevent duplication of
code so we
want to re-use the DB related calls from Project A within Project B through the
Project A jar.
With me so far???
When we execute code from Project A that alters a table in some way we use the
DAOManager to
start, end and commit the transactions. This is working in Project A.
The problem occurs when trying to execute this same code through the jar file
from within Project B
as when we the execute the code the transaction does not get committed at all.
It will however be committed
when I physically shutdown my local appserver.
It seems to me that there is some sort of IBATIS config conflict problem when
trying to execute transaction management
in the way described above.
Does anyone have any suggestions?
Regards,
Niall
****************************************************************************
*************** Department of Agriculture and Food ******************
The information contained in this email and in any attachments is
confidential and is designated solely for the attention and use of
the intended recipient(s). This information may be subject to legal
and professional privilege. If you are not an intended recipient of
this email, you must not use, disclose, copy, distribute or retain
this message or any part of it. If you have received this email in
error, please notify the sender immediately and delete all copies
of this email from your computer system(s).
****************************************************************************
****************************************************************************
**************** An Roinn Talmha+AO0-ochta Agus Bia *******************
T+AOE an t-eolais san r+AO0-omhphost seo, agus in aon ceangl+AOE-in leis,
faoi phribhl+AOk-id agus faoi r+APo-n agus le h-aghaigh an seola+AO0 amh+AOE-in.
D+IBk-fh+AOk-adfadh +AOE-bhar an seoladh seo bheith faoi phribhl+AOk-id
profisi+APo-nta n+APM dl+AO0-thi+APo-il. Mura tusa an seola+AO0 a bh+AO0
beartaithe
leis an r+AO0-omhphost seo a fh+AOE-il, t+AOE cosc air, n+APM aon chuid de,
a +APo-s+AOE-id, a ch+APM-ipe+AOE-l, n+APM a scaoileadh. M+AOE th+AOE-inig
s+AOk chugat de
bharr dearmad, t+AOk-igh i dteagmh+AOE-il leis an seolt+APM-ir agus scrios an
t-+AOE-bhar +APM do r+AO0-omhaire le do thoil.
****************************************************************************
****************************************************************************
*************** Department of Agriculture and Food ******************
The information contained in this email and in any attachments is
confidential and is designated solely for the attention and use of
the intended recipient(s). This information may be subject to legal
and professional privilege. If you are not an intended recipient of
this email, you must not use, disclose, copy, distribute or retain
this message or any part of it. If you have received this email in
error, please notify the sender immediately and delete all copies
of this email from your 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éid agus faoi rún agus le h-aghaigh an seolaí amháin.
D’fhéadfadh ábhar an seoladh seo bheith faoi phribhléid
profisiúnta nó dlíthiúil. Mura tusa an seolaí a bhí beartaithe
leis an ríomhphost seo a fháil, tá cosc air, nó aon chuid de,
a úsáid, a chóipeál, nó a scaoileadh. Má tháinig sé chugat de
bharr dearmad, téigh i dteagmháil leis an seoltóir agus scrios an
t-ábhar ó do ríomhaire le do thoil.
****************************************************************************
