ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher.Mathru...@sybase.com
Subject RE: Need Help with JNDI Connection
Date Mon, 17 Apr 2006 17:17:03 GMT

<br><font size=2 face="sans-serif">If you are going to have multiple data
sources then you need to place them in separate config files. Then that
also means you are going to need to think about distributed transactions
and an external transaction manager.</font>
<br><font size=2 face="sans-serif"><br>
Chris Mathrusse<br>
christopher.mathrusse@sybase.com<br>
Sybase, Inc<br>
One Sybase Drive<br>
Dublin, CA 94568<br>
(925) 236-5553</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>&quot;Ali, Mohammed
\(Liquidity
&amp; Risk Technology\)&quot; &lt;Mohammed_Ali@ml.com&gt;</b> </font>
<p><font size=1 face="sans-serif">04/17/2006 09:59 AM</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
user-java@ibatis.apache.org</font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td valign=top><font size=1 face="sans-serif">&lt;user-java@ibatis.apache.org&gt;</font>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td valign=top><font size=1 face="sans-serif">RE: Need Help with JNDI Connection</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2 color=blue face="Arial">All Thank You,</font>
<br><font size=2 color=blue face="Arial">Your suggestion worked. Just curios
for multiple datasources, do I need separate config files or add Datasource
in the one file ?</font>
<br><font size=3>&nbsp;</font>
<p><font size=2 color=#008080>&lt;</font><font size=2 color=#3f7f7f>transactionManager
</font><font size=2 color=#7f007f>type</font><font size=2>=</font><font
size=2 color=#2a00ff>&quot;JDBC&quot;
</font><font size=2 color=#008080>&gt;</font>
<p><font size=2 color=#008080>&lt;</font><font size=2 color=#3f7f7f>dataSource
</font><font size=2 color=#7f007f>type</font><font size=2>=</font><font
size=2 color=#2a00ff>&quot;JNDI&quot;</font><font size=2 color=#008080>&gt;</font>
<p><font size=2 color=#008080>&lt;</font><font size=2 color=#3f7f7f>property
</font><font size=2 color=#7f007f>name</font><font size=2>=</font><font
size=2 color=#2a00ff>&quot;DataSource&quot;
</font><font size=2 color=#7f007f>value</font><font size=2>=</font><font
size=2 color=#2a00ff>&quot;jdbc/cams_dev&quot;</font><font size=2 color=#008080>/&gt;</font>
<p><font size=2 color=#008080>&lt;/</font><font size=2 color=#3f7f7f>dataSource</font><font
size=2 color=#008080>&gt;</font>
<p><font size=2 color=#008080>&lt;/</font><font size=2 color=#3f7f7f>transactionManager</font><font
size=2 color=#008080>&gt;</font>
<p><font size=2 color=blue face="Arial">Thanks,</font><font size=3>
</font><font size=2 color=blue face="Arial"><br>
Ali</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
(201) 671-5499</font><font size=3> </font>
<p><font size=2 face="Tahoma">-----Original Message-----<b><br>
From:</b> Christopher.Mathrusse@sybase.com [mailto:Christopher.Mathrusse@sybase.com]
<b><br>
Sent:</b> Monday, April 17, 2006 12:56 PM<b><br>
To:</b> user-java@ibatis.apache.org<b><br>
Subject:</b> Re: Need Help with JNDI Connection<br>
</font>
<br><font size=2 face="sans-serif"><br>
I believe your JNDI reference should read either as:</font><font size=3>
</font>
<p><font size=2 color=#008080 face="Courier New">&lt;</font><font
size=2 color=#3f7f7f face="Courier New">property</font><font size=3>
</font><font size=2 color=#7f007f face="Courier New">name</font><font
size=2 face="Courier New">=</font><font size=2 color=#2a00ff face="Courier New">&quot;cams&quot;</font><font
size=3>
</font><font size=2 color=#7f007f face="Courier New">value</font><font
size=2 face="Courier New">=</font><font size=2 color=#2a00ff face="Courier New">&quot;java:comp/env/jdbc/cams_dev&quot;</font><font
size=2 color=#008080 face="Courier New">/&gt;</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><br>
or</font><font size=3> <br>
</font><font size=2 color=#008080 face="Courier New"><br>
&lt;</font><font size=2 color=#3f7f7f face="Courier New">property</font><font
size=3>
</font><font size=2 color=#7f007f face="Courier New">name</font><font
size=2 face="Courier New">=</font><font size=2 color=#2a00ff face="Courier New">&quot;cams&quot;</font><font
size=3>
</font><font size=2 color=#7f007f face="Courier New">value</font><font
size=2 face="Courier New">=</font><font size=2 color=#2a00ff face="Courier New">&quot;jdbc/cams_dev&quot;</font><font
size=2 color=#008080 face="Courier New">/&gt;</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><br>
The correct one depends upon your context.</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
<br>
Chris Mathrusse<br>
christopher.mathrusse@sybase.com<br>
Sybase, Inc<br>
One Sybase Drive<br>
Dublin, CA 94568<br>
(925) 236-5553</font><font size=3> <br>
<br>
</font>
<table width=100%>
<tr valign=top>
<td width=68%><font size=1 face="sans-serif"><b>&quot;Ali, Mohammed
\(Liquidity
&amp; Risk Technology\)&quot; &lt;Mohammed_Ali@ml.com&gt;</b> </font>
<p><font size=1 face="sans-serif">04/17/2006 09:07 AM</font><font size=3>
</font>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
user-java@ibatis.apache.org</font></div></table>
<p>
<td width=31%>
<br>
<table width=100%>
<tr>
<td width=19%>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td width=80% valign=top><font size=1 face="sans-serif">&lt;user-java@ibatis.apache.org&gt;</font><font
size=3>
</font>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td valign=top><font size=1 face="sans-serif">Need Help with JNDI Connection</font></table>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=49%>
<td width=50%></table>
<br></table>
<br><font size=3><br>
<br>
</font><font size=2 face="Arial"><br>
Hi,</font><font size=3> </font><font size=2 face="Arial"><br>
Please help me with this error.</font><font size=3> </font>
<p><font size=2 face="Arial"><b><u>SqlMapConfig.xml</u></b></font><font
size=3>
</font><font size=2 color=#008080 face="Courier New"><br>
&lt;</font><font size=2 color=#3f7f7f face="Courier New">transactionManager</font><font
size=3>
</font><font size=2 color=#7f007f face="Courier New">type</font><font
size=2 face="Courier New">=</font><font size=2 color=#2a00ff face="Courier New">&quot;JDBC&quot;</font><font
size=3>
</font><font size=2 color=#008080 face="Courier New">&gt;</font><font
size=3>
</font><font size=2 color=#008080 face="Courier New"><br>
&lt;</font><font size=2 color=#3f7f7f face="Courier New">dataSource</font><font
size=3>
</font><font size=2 color=#7f007f face="Courier New">type</font><font
size=2 face="Courier New">=</font><font size=2 color=#2a00ff face="Courier New">&quot;JNDI&quot;</font><font
size=2 color=#008080 face="Courier New">&gt;</font><font size=3>
</font><font size=2 color=#008080 face="Courier New"><br>
&lt;</font><font size=2 color=#3f7f7f face="Courier New">property</font><font
size=3>
</font><font size=2 color=#7f007f face="Courier New">name</font><font
size=2 face="Courier New">=</font><font size=2 color=#2a00ff face="Courier New">&quot;cams&quot;</font><font
size=3>
</font><font size=2 color=#7f007f face="Courier New">value</font><font
size=2 face="Courier New">=</font><font size=2 color=#2a00ff face="Courier New">&quot;java:jdbc/cams_dev&quot;</font><font
size=2 color=#008080 face="Courier New">/&gt;</font><font size=3>
</font><font size=2 color=#008080 face="Courier New"><br>
&lt;/</font><font size=2 color=#3f7f7f face="Courier New">dataSource</font><font
size=2 color=#008080 face="Courier New">&gt;</font><font size=3>
</font><font size=2 color=#008080 face="Courier New"><br>
&lt;/</font><font size=2 color=#3f7f7f face="Courier New">transactionManager</font><font
size=2 color=#008080 face="Courier New">&gt;</font><font size=3>
</font>
<p><font size=2 face="Arial">I have connection pooling datasource set on
the test server in WSAD v5.1.2. Datasource connects for sure.</font><font size=3>
</font>
<p><font size=2 face="Arial">When using SqlMapClient I get this error.
Looks like JDBC connection is nor working ?</font><font size=3> </font><font
size=2 color=red face="Arial"><br>
com.ibatis.common.jdbc.exception.NestedSQLException: Could not start transaction.
&nbsp;Cause: com.ibatis.sqlmap.engine.transaction.TransactionException:
JdbcTransaction initialization failed. &nbsp;DataSource was null.</font><font
size=3>
</font>
<p><font size=2 color=red face="Arial">Caused by: com.ibatis.sqlmap.engine.transaction.TransactionException:
JdbcTransaction initialization failed. &nbsp;DataSource was null.</font><font
size=3>
</font>
<p><font size=2 face="Arial">Thanks,</font><font size=3> </font><font
size=2 face="Arial"><br>
Ali</font><font size=3> </font><font size=2 face="Arial"><br>
(201) 671-5499</font><font size=3> </font>
<p>
<hr><font size=3><br>
If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain
or redistribute it. </font><a href=http://www.ml.com/email_terms/><font size=3
color=blue><u>Click
here </u></font></a><font size=3>for important additional terms relating
to this e-mail. &nbsp; &nbsp; </font><a href=http://www.ml.com/email_terms/><font
size=3 color=blue><u>http://www.ml.com/email_terms/</u></font></a><font
size=3>
<br>
</font>
<hr>
<p>

Mime
View raw message