<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0" xmlns:blogChannel="http://backend.userland.com/blogChannelModule" >
  <channel>
  <title>vi b(l)og rock!!!</title>
  <link>https://viblogrock.blog.shinobi.jp/</link>
  <atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="https://viblogrock.blog.shinobi.jp/RSS/" />
  <description>備忘録</description>
  <lastBuildDate>Sun, 02 Jan 2011 14:48:25 GMT</lastBuildDate>
  <language>ja</language>
  <copyright>© Ninja Tools Inc.</copyright>
  <atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" />

    <item>
    <title>ブログ移行しました。</title>
    <description>
    <![CDATA[<a href="http://viblogrock.blogspot.com/">http://viblogrock.blogspot.com/</a><a href="http://viblogrock.wordpress.com/"><br />
</a><br />
こちらに移行しました。<br type="_moz" />]]>
    </description>
    <category>未選択</category>
    <link>https://viblogrock.blog.shinobi.jp/%E6%9C%AA%E9%81%B8%E6%8A%9E/%E3%83%96%E3%83%AD%E3%82%B0%E7%A7%BB%E8%A1%8C%E3%81%97%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82</link>
    <pubDate>Sun, 02 Jan 2011 14:48:35 GMT</pubDate>
    <guid isPermaLink="false">viblogrock.blog.shinobi.jp://entry/66</guid>
  </item>
    <item>
    <title>JSONIC 1.2 RESTServlet on Tomcat で文字化け</title>
    <description>
    <![CDATA[原因は、この辺でしたが、JSONIC 1.1 の　WebServiceServletでは問題なかったので、<br />
わからんかった。<br />
<br />
<h2><a name="TomcatUseBodyEncodingForURI">TomcatでGETの文字化け</a></h2>
<p>Tomcat5以上を使っているときに、GETが文字化けすることがあります。 そのような場合には、server.xmlのConnectorタグに次の指定を追加します。</p>
<pre>
&lt;Connector ... useBodyEncodingForURI=&quot;true&quot;/&gt; 
</pre>
<h2><a name="TomcatURIEncoding">TomcatでリクエストURLの文字化け</a></h2>
<p>Tomcatを使っているときに、リクエストURL(パス)が文字化けすることがあります。 そのような場合には、server.xmlのConnectorタグに次の指定を追加します。 UTF-8の部分は、encodingfilterの設定にあわせてください。</p>
<pre>
&lt;Connector ... URIEncoding=&quot;UTF-8&quot;/&gt; 
</pre>
<br />
<br />]]>
    </description>
    <category>Java</category>
    <link>https://viblogrock.blog.shinobi.jp/java/jsonic%201.2%20restservlet%20on%20tomcat%20%E3%81%A7%E6%96%87%E5%AD%97%E5%8C%96%E3%81%91</link>
    <pubDate>Fri, 05 Nov 2010 04:41:28 GMT</pubDate>
    <guid isPermaLink="false">viblogrock.blog.shinobi.jp://entry/65</guid>
  </item>
    <item>
    <title>Maven Additional Plugin</title>
    <description>
    <![CDATA[http://webcache.googleusercontent.com/search?q=cache:CliYVCEcGRkJ:d.hatena.ne.jp/tomo_snowbug/20090309/1236614940+WTP%E3%80%80m2eclipse%E3%80%800.10&amp;cd=1&amp;hl=ja&amp;ct=clnk&amp;gl=jp&amp;lr=lang_ja&amp;client=firefox-a からパクリ<br />
<br />
Plugin<a class="keyword" href="http://d.hatena.ne.jp/keyword/%A5%A4%A5%F3%A5%B9%A5%C8%A1%BC%A5%EB">インストール</a>後、プロジェクトごとにこの<a class="keyword" href="http://d.hatena.ne.jp/keyword/%A5%D7%A5%E9%A5%B0%A5%A4%A5%F3">プラグイン</a>の機能を有効化するかどうかを、「PackageExplorer」のプロジェクトを右クリックして、Propertiesから設定するのですが、この設定が「<a class="keyword" href="http://d.hatena.ne.jp/keyword/J2EE">J2EE</a>の<a class="keyword" href="http://d.hatena.ne.jp/keyword/%A5%D1%A1%BC%A5%B9%A5%DA%A5%AF%A5%C6%A5%A3%A5%D6">パースペクティブ</a>のProjectビュー」でプロジェクトのPropertiesからだと表示されないのでした。<a class="keyword" href="http://d.hatena.ne.jp/keyword/J2EE">J2EE</a>の<a class="keyword" href="http://d.hatena.ne.jp/keyword/%A5%D1%A1%BC%A5%B9%A5%DA%A5%AF%A5%C6%A5%A3%A5%D6">パースペクティブ</a>と<a class="keyword" href="http://d.hatena.ne.jp/keyword/Java">Java</a>の<a class="keyword" href="http://d.hatena.ne.jp/keyword/%A5%D1%A1%BC%A5%B9%A5%DA%A5%AF%A5%C6%A5%A3%A5%D6">パースペクティブ</a>で違いがあると気づけておらず。。。<br />
<br type="_moz" />]]>
    </description>
    <category>eclipse</category>
    <link>https://viblogrock.blog.shinobi.jp/eclipse/maven%20additional%20plugin</link>
    <pubDate>Tue, 17 Aug 2010 02:54:34 GMT</pubDate>
    <guid isPermaLink="false">viblogrock.blog.shinobi.jp://entry/64</guid>
  </item>
    <item>
    <title>Eclipse Web Tools PlatformとMavenの統合</title>
    <description>
    <![CDATA[&nbsp;http://japan.internet.com/column/developer/20080520/26.html からパクリ
<h2>はじめに</h2>
Eclipse Web Tools Platform（WTP）とM2Eclipse（M2）は別々のプロジェクトです。両者はいずれも、Eclipseを使って開発をする際に価値の高い機 能を提供します。WTPはWebおよびJava EEアプリケーション開発用のEclipseプラットフォームを機能拡張するツールセットで、一方のM2は、このIDEとMavenを密に統合します。こ の2つを同じプロジェクトで利用すると絶大な効果が得られますが、残念ながらまだ、WTPとM2を追加設定なしで統合することはできません。今回の記事で はこれについて取り上げます。<br />
<br />
この記事では、WTPとM2の統合ソリューションを使用して基本的なWebアプリケーションを開発していきます。プロジェクトのセットアップから配備ま での一連の構築手順を紹介するので、EclipseベースのJava Web開発を効率化するための参考にしていただけると幸いです。<br /><a href="https://viblogrock.blog.shinobi.jp/eclipse/eclipse%20web%20tools%20platform%E3%81%A8maven%E3%81%AE%E7%B5%B1%E5%90%88" target="_blank">つづきはこちら</a>]]>
    </description>
    <category>eclipse</category>
    <link>https://viblogrock.blog.shinobi.jp/eclipse/eclipse%20web%20tools%20platform%E3%81%A8maven%E3%81%AE%E7%B5%B1%E5%90%88</link>
    <pubDate>Tue, 17 Aug 2010 01:31:10 GMT</pubDate>
    <guid isPermaLink="false">viblogrock.blog.shinobi.jp://entry/63</guid>
  </item>
    <item>
    <title>[oracle] oracle client をコピーする（CDなくしたときとかに）</title>
    <description>
    <![CDATA[<ol>
    <li>orantを探し、コピーする</li>
    <li>regeditで<code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">　HKEY_LOCAL_MACHINE&yen;SYSTEM&yen;CurrentControlSet&yen;Services</code>に移動し、<code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">Oracle</code><em><code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">HOME_NAME</code></em><code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">TNSListener</code>レジストリ・エントリをコピーする<br />
    <code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">HKEY_CLASSES_ROOT</code>に移動します<br />
    次で始まるキーをコピーします
    <ul>
        <li>ORAMMCPMON10</li>
        <li>ORCLSSO</li>
        <li>OraOLEDB.ErrorLookup</li>
        <li>OraOLEDB.OracleOracleInProcServer.XOraServer</li>
    </ul>
    </li>
    <li><code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">HKEY_LOCAL_MACHINE&yen;SOFTWARE</code>に移動します<br />
    <code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">ORACLE</code>&nbsp;<code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">Group</code>キーをコピーします</li>
    <li>Oracle Services for Microsoft Transaction Serverをインストールしている場合、<br />
    <code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">HKEY_LOCAL_MACHINE&yen;SYSTEM&yen;CurrentControlSet&yen;Services&yen;Eventlog&yen;<br />
    Application</code>に移動します<br />
    <code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">Oracle Services for Microsoft Transaction Server</code>キーをコピーします</li>
    <li><code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">HKEY_CURRENT_USER&yen;Software</code>に移動します<br />
    <code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">Microsoft&yen;Windows&yen;CurrentVersion&yen;Explorer&yen;MenuOrder&yen;Start Menu&yen;<br />
    Programs</code>の下にある<code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">Oracle-</code><em><code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">HOME_NAME</code></em>エントリなど、すべての<code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">Oracle</code>キーをコピーします</li>
    <li>PATH環境変数のパスの更新<br />
    <code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">PATH</code>変数に<em><code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">ORACLE_BASE</code></em><code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">&yen;</code><em><code style="font-family: monospace; font-size: 1em; color: rgb(51, 102, 153); ">ORACLE_HOME</code></em>を含むOracleエントリをコピーします</li>
</ol>
<br />
これでできるかも]]>
    </description>
    <category>Oracle</category>
    <link>https://viblogrock.blog.shinobi.jp/oracle/-oracle-%20oracle%20client%20%E3%82%92%E3%82%B3%E3%83%94%E3%83%BC%E3%81%99%E3%82%8B%EF%BC%88cd%E3%81%AA%E3%81%8F%E3%81%97%E3%81%9F%E3%81%A8%E3%81%8D%E3%81%A8%E3%81%8B%E3%81%AB%EF%BC%89</link>
    <pubDate>Tue, 27 Jul 2010 01:49:11 GMT</pubDate>
    <guid isPermaLink="false">viblogrock.blog.shinobi.jp://entry/62</guid>
  </item>
    <item>
    <title>Watchtower Library on Mac in Japanese</title>
    <description>
    <![CDATA[<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Hiragino Kaku Gothic ProN'">これで<span style="font: 12.0px Arial">Mac</span>で<span style="font: 12.0px Arial">WTLib</span>が直接？起動できます。</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Arial; min-height: 14.0px">&nbsp;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Arial">&nbsp;<a href="http://watchtowerlibraryformac.info/">watchtowerlibraryformac.info/</a></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Arial; min-height: 14.0px">&nbsp;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Arial; min-height: 14.0px">&nbsp;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Hiragino Kaku Gothic ProN'">ですが、日本語が入力できないので、<span style="font: 12.0px Arial">kinput2 &amp; canna </span>をインストールする</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Hiragino Kaku Gothic ProN'; min-height: 18.0px">&nbsp;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Arial"><span style="font: 12.0px 'Hiragino Kaku Gothic ProN'">インストール</span><span style="font: 12.0px Verdana">(Canna</span><span style="font: 12.0px 'Hiragino Kaku Gothic ProN'">も同時にインストールされる</span><span style="font: 12.0px Verdana">) <br />
</span>$ sudo port -d install kinput2</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Arial"><span style="font: 12.0px Verdana">Canna</span><span style="font: 12.0px 'Hiragino Kaku Gothic ProN'">サーバの起動設定</span><span style="font: 12.0px Verdana"> <br />
</span>$ sudo launchctl load -w /opt/local/etc/LaunchDaemons/org.macports.canna/org.macports.canna.plist&nbsp;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier"><span style="font: 12.0px 'Lucida Grande'"><br />
</span><span style="font: 12.0px Verdana">X11</span><span style="font: 12.0px 'Hiragino Kaku Gothic ProN'">の設定 &nbsp;</span>/.MacOSX/environment.plist <span style="font: 12.0px 'Hiragino Kaku Gothic ProN'">を作る</span><span style="font: 12.0px 'Lucida Grande'"><br />
</span>$ mkdir .MacOSX</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">$ vi ~/.MacOSX/environment.plist</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp;&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp;&lt;!DOCTYPE plist PUBLIC &quot;-//Apple Computer//DTD PLIST 1.0//EN&quot; &nbsp;&quot;http://www.apple.com/DTDs/PropertyList-1.0.dtd&quot;&gt;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp;&lt;plist version=&quot;1.0&quot;&gt;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp;&lt;dict&gt;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp;&lt;key&gt;LANG&lt;/key&gt;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp;&lt;string&gt;ja_JP.UTF-8&lt;/string&gt;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp;&lt;key&gt;XMODIFIERS&lt;/key&gt;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp;&lt;string&gt;@im=kinput2&lt;/string&gt;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp;&lt;/dict&gt;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp;&lt;/plist&gt;<br />
<span style="font: 12.0px 'Lucida Grande'"><br />
</span><span style="font: 12.0px Verdana">kinput2 </span><span style="font: 12.0px 'Hiragino Kaku Gothic ProN'">の自動起動</span><span style="font: 12.0px 'Lucida Grande'"><br />
</span>$ cd /usr/X11/lib/X11/xinit/<br />
$ cp xinitrc ^/xinitrc<br />
<span style="font: 12.0px 'Lucida Grande'"><br />
</span><span style="font: 12.0px 'Hiragino Kaku Gothic ProN'"># stsart some programs の下に以下の４行を追加</span></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">kinput2=/usr/X11R6/bin/kinput2</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">if [ -x $kinput2 ]; then</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">&nbsp; &nbsp; $kinput2 &amp;</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier">fi</p>
<div>&nbsp;</div>]]>
    </description>
    <category>備忘録</category>
    <link>https://viblogrock.blog.shinobi.jp/%E5%82%99%E5%BF%98%E9%8C%B2/watchtower%20library%20on%20mac%20in%20japanese</link>
    <pubDate>Fri, 23 Jul 2010 13:38:52 GMT</pubDate>
    <guid isPermaLink="false">viblogrock.blog.shinobi.jp://entry/61</guid>
  </item>
    <item>
    <title>[GlassFish][OpenSSO]　設定続き　PolicyAgent</title>
    <description>
    <![CDATA[PolicyAgentを設定して、webへのアクセスをOpenSSOに流します。<br />
<br />
まず、password file を要求されるので、作成しておきます。<br />
ex)　C:\passwd.txt<br />
<br />
\web_agents\sjsws_agent へ移動して、agentadmin --install を実行します。<br />
<a href="http://blogs.sun.com/hanaki/entry/ssoadm_%E3%82%B3%E3%83%9E%E3%83%B3%E3%83%89%E3%82%92%E4%BD%BF%E3%81%A3%E3%81%A6%E3%83%9D%E3%83%AA%E3%82%B7%E3%83%BC%E3%82%A8%E3%83%BC%E3%82%B8%E3%82%A7%E3%83%B3%E3%83%88_3_0_%E3%81%AE%E3%83%97%E3%83%AD%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92">ここ</a>を参考に<br />
<br />
<pre>
OpenSSO server URL : http://FQDN:8080/opensso
</pre>
Agent URL : http://FQDN:80<br />
<br />
設定が完了すると、http://FQDN:80へのアクセスを<br />
http://FQDN:8080/openssoに転送する？ようになります。<br />
<br />
ためしに、http://FQDN:80にアクセスすると、「ページ読み込みエラー」になります。<br />
OpenSSO側に設定が必要です。<br />
<br />
OpenSSOの設定ページを開き、「アクセス制御」タブをクリック、<br />
「/ （最上位のレルム）」をクリック。<br />
「エージェント」タブをクリック。<br />
「web」タブが選択されていることを確認し、エージェントの新規ボタンをクリック。<br />
agentaadmin で設定した内容と同じ設定を行う。<br />
<br />
続いて、ポリシーの設定を行います。<br />
OpenSSOの設定ページを開き、「アクセス制御」タブをクリック、<br />
「/ （最上位のレルム）」をクリック。<br />
「ポリシー」タブをクリック。<br />
「新規ポリシー」ボタンをクリック。<br />
<br />
ルール、対象を設定します。<br />
設定するルールはこんな感じ。<br />
<pre>
ルール：
 サービスタイプ：URL ポリシーエージェント
 リソース名：http://FQDN:80/*
 アクション： GET 許可  POST 許可
対象： OpenSSO アイデンティティー対象
　　　 選択したユーザー：amadmin のみ
条件：なし
応答プロバイダ：なし

これで、http://FQDN:80/にアクセスすると、OpenSSOに未ログイン時は、ログインページに
ログイン済み時は、対象のページに遷移する。
ちなみに、ページに遷移できるユーザはamadminのみ
</pre>
<br />
<br />
<br type="_moz" />]]>
    </description>
    <category>未選択</category>
    <link>https://viblogrock.blog.shinobi.jp/%E6%9C%AA%E9%81%B8%E6%8A%9E/-glassfish--opensso-%E3%80%80%E8%A8%AD%E5%AE%9A%E7%B6%9A%E3%81%8D%E3%80%80policyagent</link>
    <pubDate>Wed, 18 Feb 2009 05:21:07 GMT</pubDate>
    <guid isPermaLink="false">viblogrock.blog.shinobi.jp://entry/60</guid>
  </item>
    <item>
    <title>[GlassFish][SSO] OpenSSO の適用なんか</title>
    <description>
    <![CDATA[GlassFishをインストールします。<br />
http://sdc.sun.co.jp/java/series/glassfish/200803.html<br />
<br />
Sun Java System Web Serverをインストールします。<br />
sjsws-7_0u4-windows-i586.zip　を解凍してインストール。<br />
<br />
OpenSSOをインストールします。<br />
opensso_enterprise_80.zip　を解凍。<br />
<br />
自ホストでOpenSSOを実行する場合、FQDNでアクセスできることを確認しておきます。<br />
http://wikis.sun.com/pages/viewpage.action?pageId=32604295<br />
<br />
GlassFishにOpenSSOのwarをdeployします。<br />
\opensso\deployable-war\opensso.war　を \glassfish\domains\domain1\autodeploy などにコピー。<br />
<br />
openssoにアクセスします。<br />
http://ホスト名（FQDN）:8080/opensso<br />
<br />
設定画面が表示されます。<br />
デフォルト設定画面でパスワードを設定すると、設定完了です。<br />
<br />
ログイン画面から、amadmin/先ほど指定したパスワード　でログインできます。<br />
<br />
続く。。。<br type="_moz" />]]>
    </description>
    <category>未選択</category>
    <link>https://viblogrock.blog.shinobi.jp/%E6%9C%AA%E9%81%B8%E6%8A%9E/-glassfish--sso-%20opensso%20%E3%81%AE%E9%81%A9%E7%94%A8%E3%81%AA%E3%82%93%E3%81%8B</link>
    <pubDate>Wed, 18 Feb 2009 02:59:19 GMT</pubDate>
    <guid isPermaLink="false">viblogrock.blog.shinobi.jp://entry/59</guid>
  </item>
    <item>
    <title>[glassFish][SSO]　OpenSSO</title>
    <description>
    <![CDATA[OpenSSOを<a href="https://opensso.dev.java.net/public/use/index.html">ダウンロード</a><br />
<a href="http://download.java.net/general/opensso/stable/openssov1-build5/opensso_express_20080804.zip">opensso_express_20080804.zip</a>　の方です。<br />
<br />
glassfishでウェブアプリを配備<br />
./opensso/deployable-war/opensso.war<br />
<br />
後は<a href="http://sdc.sun.co.jp/javasystem/techtopics/identity/200707.html">ここ</a>を参考に設定する。<br />
<br />
<br type="_moz" />]]>
    </description>
    <category>未選択</category>
    <link>https://viblogrock.blog.shinobi.jp/%E6%9C%AA%E9%81%B8%E6%8A%9E/-glassfish--sso-%E3%80%80opensso</link>
    <pubDate>Mon, 16 Feb 2009 06:12:29 GMT</pubDate>
    <guid isPermaLink="false">viblogrock.blog.shinobi.jp://entry/58</guid>
  </item>
    <item>
    <title>[Tomccat][SSO]　Jossoデータベース管理化</title>
    <description>
    <![CDATA[基本的には<a href="http://www.josso.org/confluence/display/JOSSO1/Database+Setup">これ</a>にならって修正する。<br />
<br />
<br />
webapp/xxxに以下のようなcontext.xmlを置く。<br />
<br />
&lt;Context docbase=&quot;josso&quot; path=&quot;josso&quot; reloadable=&quot;true&quot;&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Resource<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name=&quot;jdbc/josso&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; auth=&quot;Container&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; type=&quot;javax.sql.DataSource&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; username=&quot;root&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; password=&quot;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; driverClassName=&quot;org.gjt.mm.mysql.Driver&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; url=&quot;jdbc:mysql://localhost/josso&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; maxActive=&quot;4&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; maxWait=&quot;5000&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; maxIdle=&quot;2&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /&gt;<br />
&lt;/Context&gt;<br />
<br />
<br />
<br />
<br />
gateway install --persintence db でインストールしなかった場合は、josso-gateway-stores.xmlを以下のように修正する。<br />
<br />
<br />
<br />
&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;<br />
<br />
&lt;!--<br />
&nbsp; ~ JOSSO: Java Open Single Sign-On<br />
&nbsp; ~<br />
&nbsp; ~ Copyright 2004-2009, Atricore, Inc.<br />
&nbsp; ~<br />
&nbsp; ~ This is free software; you can redistribute it and/or modify it<br />
&nbsp; ~ under the terms of the GNU Lesser General Public License as<br />
&nbsp; ~ published by the Free Software Foundation; either version 2.1 of<br />
&nbsp; ~ the License, or (at your option) any later version.<br />
&nbsp; ~<br />
&nbsp; ~ This software is distributed in the hope that it will be useful,<br />
&nbsp; ~ but WITHOUT ANY WARRANTY; without even the implied warranty of<br />
&nbsp; ~ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU<br />
&nbsp; ~ Lesser General Public License for more details.<br />
&nbsp; ~<br />
&nbsp; ~ You should have received a copy of the GNU Lesser General Public<br />
&nbsp; ~ License along with this software; if not, write to the Free<br />
&nbsp; ~ Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA<br />
&nbsp; ~ 02110-1301 USA, or see the FSF site: http://www.fsf.org.<br />
&nbsp; ~<br />
&nbsp; --&gt;<br />
&lt;s:beans xmlns:s=&quot;http://www.springframework.org/schema/beans&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:db-istore=&quot;urn:org:josso:db:identitystore&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:memory-istore=&quot;urn:org:josso:memory:identitystore&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:db-sstore=&quot;urn:org:josso:db:sessionstore&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:memory-sstore=&quot;urn:org:josso:memory:sessionstore&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:db-astore=&quot;urn:org:josso:db:assertionstore&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:memory-astore=&quot;urn:org:josso:memory:assertionstore&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xsi:schemaLocation=&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; urn:org:josso:db:identitystore http://www.josso.org/schema/josso-db-identitystore.xsd<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; urn:org:josso:memory:identitystore http://www.josso.org/schema/josso-memory-identitystore.xsd<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; urn:org:josso:db:sessionstore http://www.josso.org/schema/josso-db-sessionstore.xsd<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; urn:org:josso:memory:sessionstore http://www.josso.org/schema/josso-memory-sessionstore.xsd<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; urn:org:josso:db:assertionstore http://www.josso.org/schema/josso-db-assertionstore.xsd<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; urn:org:josso:memory:assertionstore http://www.josso.org/schema/josso-memory-assertionstore.xsd<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;<br />
<br />
&nbsp;&nbsp;&nbsp; &lt;!-- ===================================================================== --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!-- JOSSO Identity Store, the id is very important because it is&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!-- referenced by the session manager and who knows where else&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!-- ===================================================================== --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!--<br />
&nbsp;&nbsp;&nbsp; &lt;db-istore:datasource-store id=&quot;josso-identity-store&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dsJndiName=&quot;java:/DefaultDS&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; userQueryString=&quot;SELECT NAME FROM JOSSO_USER WHERE LOGIN = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rolesQueryString=&quot;SELECT ROLE FROM JOSSO_USER_ROLE WHERE LOGIN = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; credentialsQueryString=&quot;SELECT LOGIN AS USERNAME, PASSWORD FROM JOSSO_USER WHERE LOGIN = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; userPropertiesQueryString=&quot;SELECT NAME, VALUE FROM JOSSO_USER_PROPERTY WHERE LOGIN = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; resetCredentialDml=&quot;UPDATE JOSSO_USER SET PASSWORD = ? WHERE LOGIN = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; relayCredentialQueryString=&quot;SELECT LOGIN FROM JOSSO_USER WHERE #?# = ?;&quot; /&gt;<br />
&nbsp;&nbsp;&nbsp; --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;db-istore:jdbc-store<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id=&quot;josso-identity-store&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; driverName=&quot;com.mysql.jdbc.Driver&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connectionURL=&quot;jdbc:mysql://localhost:3306/josso&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connectionName=&quot;root&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connectionPassword=&quot;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; userQueryString=&quot;SELECT LOGIN AS NAME FROM JOSSO_USER WHERE LOGIN = ?&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rolesQueryString=&quot;SELECT NAME AS ROLE FROM JOSSO_USER_ROLE WHERE LOGIN = ?&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; credentialsQueryString=&quot;SELECT LOGIN AS USERNAME, PASSWORD FROM JOSSO_USER WHERE LOGIN = ?&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; userPropertiesQueryString=&quot;SELECT NAME, VALUE FROM JOSSO_USER_PROPERTY WHERE LOGIN = ?&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; resetCredentialDml=&quot;UPDATE JOSSO_USER SET PASSWORD = ? WHERE LOGIN = ?&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; relayCredentialQueryString=&quot;SELECT LOGIN FROM JOSSO_USER WHERE #?# = ?&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!--<br />
&nbsp;&nbsp;&nbsp; &lt;db-istore:jdbc-store<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id=&quot;josso-identity-store&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; driverName=&quot;org.hsqldb.jdbcDriver&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connectionURL=&quot;jdbc:hsqldb:mem:jossodb&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connectionName=&quot;sa&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connectionPassword=&quot;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; userQueryString=&quot;SELECT NAME FROM JOSSO_USER WHERE LOGIN = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rolesQueryString=&quot;SELECT ROLE FROM JOSSO_USER_ROLE WHERE LOGIN = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; credentialsQueryString=&quot;SELECT LOGIN AS USERNAME, PASSWORD FROM JOSSO_USER WHERE LOGIN = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; userPropertiesQueryString=&quot;SELECT NAME, VALUE FROM JOSSO_USER_PROPERTY WHERE LOGIN = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; resetCredentialDml=&quot;UPDATE JOSSO_USER SET PASSWORD = ? WHERE LOGIN = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; relayCredentialQueryString=&quot;SELECT LOGIN FROM JOSSO_USER WHERE #?# = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /&gt;<br />
&nbsp;&nbsp;&nbsp; --&gt;<br />
<br />
&nbsp;&nbsp;&nbsp; &lt;!--<br />
&nbsp;&nbsp;&nbsp; &lt;memory-istore:memory-store id=&quot;josso-identity-store&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; credentialsFileName=&quot;josso-credentials.xml&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; usersFileName=&quot;josso-users.xml&quot; s:scope=&quot;singleton&quot; /&gt;<br />
&nbsp;&nbsp;&nbsp; --&gt;<br />
<br />
<br />
&nbsp;&nbsp;&nbsp; &lt;!-- ===================================================================== --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!-- JOSSO Session Store, the id is very important because it is&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!-- referenced by the session manager and who knows where else&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!-- ===================================================================== --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;memory-sstore:memory-store id=&quot;josso-session-store&quot;/&gt;<br />
<br />
&nbsp;&nbsp;&nbsp; &lt;!-- Chagne the store implementation if you want to use DB Assertion stores (useful for clustesr and failover) --&gt;<br />
<br />
&nbsp;&nbsp;&nbsp; &lt;!--<br />
&nbsp;&nbsp;&nbsp; &lt;db-sstore:jdbc-store<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id=&quot;josso-session-store&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; driverName=&quot;org.hsqldb.jdbcDriver&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connectionURL=&quot;jdbc:hsqldb:mem:jossodb&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connectionName=&quot;sa&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connectionPassword=&quot;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadQuery=&quot;SELECT SESSION_ID, USERNAME, CREATION_TIME, LAST_ACCESS_TIME, ACCESS_COUNT, MAX_INACTIVE_INTERVAL, VALID FROM JOSSO_SESSION WHERE SESSION_ID = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadAllQuery=&quot;SELECT SESSION_ID, USERNAME, CREATION_TIME, LAST_ACCESS_TIME, ACCESS_COUNT, MAX_INACTIVE_INTERVAL, VALID FROM JOSSO_SESSION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; insertDml=&quot;INSERT INTO JOSSO_SESSION VALUES (?, ?, ?, ?, ?, ?, ?);&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateDml=&quot;UPDATE JOSSO_SESSION SET USERNAME = ?, CREATION_TIME = ?, LAST_ACCESS_TIME = ?, ACCESS_COUNT = ?, MAX_INACTIVE_INTERVAL = ?, VALID = ? WHERE SESSION_ID = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sizeQuery=&quot;SELECT COUNT(1) FROM JOSSO_SESSION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keysQuery=&quot;SELECT SESSION_ID FROM JOSSO_SESSION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadByUserNameQuery=&quot;SELECT SESSION_ID, USERNAME, CREATION_TIME, LAST_ACCESS_TIME, ACCESS_COUNT, MAX_INACTIVE_INTERVAL, VALID FROM JOSSO_SESSION WHERE USERNAME = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadByValidQuery=&quot;SELECT SESSION_ID, USERNAME, CREATION_TIME, LAST_ACCESS_TIME, ACCESS_COUNT, MAX_INACTIVE_INTERVAL, VALID FROM JOSSO_SESSION WHERE VALID = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadByLastAccessTimeQuery=&quot;SELECT SESSION_ID, USERNAME, CREATION_TIME, LAST_ACCESS_TIME, ACCESS_COUNT, MAX_INACTIVE_INTERVAL, VALID FROM JOSSO_SESSION WHERE LAST_ACCESS_TIME = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; deleteDml=&quot;DELETE FROM JOSSO_SESSION WHERE SESSION_ID = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; deleteAllDml=&quot;DELETE FROM JOSSO_SESSION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /&gt;<br />
<br />
&nbsp;&nbsp;&nbsp; --&gt;<br />
<br />
&nbsp;&nbsp;&nbsp; &lt;!--<br />
&nbsp;&nbsp;&nbsp; &lt;db-sstore:datasource-store<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id=&quot;josso-session-store&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dsJndiName=&quot;java:/DefaultDS&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadQuery=&quot;SELECT SESSION_ID, USERNAME, CREATION_TIME, LAST_ACCESS_TIME, ACCESS_COUNT, MAX_INACTIVE_INTERVAL, VALID FROM JOSSO_SESSION WHERE SESSION_ID = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadAllQuery=&quot;SELECT SESSION_ID, USERNAME, CREATION_TIME, LAST_ACCESS_TIME, ACCESS_COUNT, MAX_INACTIVE_INTERVAL, VALID FROM JOSSO_SESSION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; insertDml=&quot;INSERT INTO JOSSO_SESSION VALUES (?, ?, ?, ?, ?, ?, ?);&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateDml=&quot;UPDATE JOSSO_SESSION SET USERNAME = ?, CREATION_TIME = ?, LAST_ACCESS_TIME = ?, ACCESS_COUNT = ?, MAX_INACTIVE_INTERVAL = ?, VALID = ? WHERE SESSION_ID = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sizeQuery=&quot;SELECT COUNT(1) FROM JOSSO_SESSION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keysQuery=&quot;SELECT SESSION_ID FROM JOSSO_SESSION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadByUserNameQuery=&quot;SELECT SESSION_ID, USERNAME, CREATION_TIME, LAST_ACCESS_TIME, ACCESS_COUNT, MAX_INACTIVE_INTERVAL, VALID FROM JOSSO_SESSION WHERE USERNAME = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadByValidQuery=&quot;SELECT SESSION_ID, USERNAME, CREATION_TIME, LAST_ACCESS_TIME, ACCESS_COUNT, MAX_INACTIVE_INTERVAL, VALID FROM JOSSO_SESSION WHERE VALID = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadByLastAccessTimeQuery=&quot;SELECT SESSION_ID, USERNAME, CREATION_TIME, LAST_ACCESS_TIME, ACCESS_COUNT, MAX_INACTIVE_INTERVAL, VALID FROM JOSSO_SESSION WHERE LAST_ACCESS_TIME = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; deleteDml=&quot;DELETE FROM JOSSO_SESSION WHERE SESSION_ID = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; deleteAllDml=&quot;DELETE FROM JOSSO_SESSION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp; --&gt;<br />
<br />
&nbsp;&nbsp;&nbsp; &lt;!-- ===================================================================== --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!-- JOSSO Assertion Store, the id is very important because it is&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!-- referenced by the assertion manager and who knows where elese&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!-- ===================================================================== --&gt;<br />
<br />
&nbsp;&nbsp;&nbsp; &lt;!-- Chagne the store implementation if you want to use DB Assertion stores (useful for clustesr and failover) --&gt;<br />
<br />
&nbsp;&nbsp;&nbsp; &lt;memory-astore:memory-store id=&quot;josso-assertion-store&quot;/&gt;<br />
&nbsp;&nbsp;&nbsp; &lt;!--<br />
&nbsp;&nbsp;&nbsp; &lt;db-astore:datasource-store<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id=&quot;josso-assertion-store&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dsJndiName=&quot;java:/DefaultDS&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sizeQuery=&quot;SELECT COUNT(1) FROM JOSSO_ASSERTION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keysQuery=&quot;SELECT ASSERTION_ID FROM JOSSO_ASSERTION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadAllQuery=&quot;SELECT ASSERTION_ID, SECURITY_DOMAIN_NAME, SSO_SESSION_ID, CREATION_TIME, VALID FROM JOSSO_ASSERTION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; loadQuery=&quot;SELECT ASSERTION_ID, SECURITY_DOMAIN_NAME, SSO_SESSION_ID, CREATION_TIME, VALID FROM JOSSO_ASSERTION WHERE ASSERTION_ID = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; deleteAllDml=&quot;DELETE FROM JOSSO_ASSERTION;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; deleteDml=&quot;DELETE FROM JOSSO_ASSERTION WHERE ASSERTION_ID = ?;&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; insertDml=&quot;INSERT INTO JOSSO_ASSERTION VALUES (?, ?, ?, ?, ?);&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /&gt;<br />
&nbsp;&nbsp;&nbsp; --&gt;<br />
<br />
&lt;/s:beans&gt;<br />]]>
    </description>
    <category>未選択</category>
    <link>https://viblogrock.blog.shinobi.jp/%E6%9C%AA%E9%81%B8%E6%8A%9E/-tomccat--sso-%E3%80%80josso%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E7%AE%A1%E7%90%86%E5%8C%96</link>
    <pubDate>Mon, 16 Feb 2009 04:38:06 GMT</pubDate>
    <guid isPermaLink="false">viblogrock.blog.shinobi.jp://entry/57</guid>
  </item>

    </channel>
</rss>