ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin" <brandon.goo...@gmail.com>
Subject Re: Problem committing records using IBATIS in embedded jar file
Date Wed, 13 Dec 2006 16:07:52 GMT
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 <Niall.Ross@agriculture.gov.ie> 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/@SQL_CONFIG_MAP@%22/>
> >
>   </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/@SQL_CONFIG_MAP_IFORIS@%22/>
> >
>   </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/@SQL_CONFIG_MAP@%22/>
> >
>   </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:brandon.goodin@gmail.com]
> *Sent:* 12 December 2006 15:40
> *To:* user-java@ibatis.apache.org
> *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 <Niall.Ross@agriculture.gov.ie> 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.
>
>
> ****************************************************************************
>
>
>

Mime
View raw message