I see Project A loads two different SQL Map configs with an odd @...@
syntax. You only posted 1 of them for Project A. Please post the other as
well. Also, what version of iBATIS are you using?
Brandon
On 12/13/06, Ross, Niall <[EMAIL PROTECTED]> wrote:
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@"/<ie/gov/agriculture/sps/app/dao/xml/@[EMAIL
PROTECTED]/>
>
</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="ie/gov/agriculture/sps/app/dao/xml/@SQL_CONFIG_MAP_IFORIS@"/<ie/gov/agriculture/sps/app/dao/xml/@[EMAIL
PROTECTED]/>
>
</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@"/<ie/gov/agriculture/spsinet/app/dao/xml/@[EMAIL
PROTECTED]/>
>
</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.
****************************************************************************
