examples-trunk/datasource-ciphered-password/README.html - tomee-site-pub - Git at Google

 <!DOCTYPE html>
 <html lang="en">
   <head>

     <meta charset="UTF-8">
       <title>DataSource Ciphered Password</title>
     <meta name="description" content="Apache TomEE">
     <meta name="author" content="Apache TomEE">
     <meta name="google-translate-customization" content="f36a520c08f4c9-0a04e86a9c075ce9-g265f3196f697cf8f-10">
     <meta http-equiv="Pragma" content="no-cache">
     <meta http-equiv="Expires" content="0">
     <meta http-equiv="Cache-Control" content="no-store, no-cache, must-revalidate, max-age=0">

     <!-- Le HTML5 shim, for IE6-8 support of HTML elements -->
     <!--[if lt IE 9]>
       <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
     <![endif]-->

     <!-- Le styles -->
     <link href="./../../resources/css/bootstrap.css" rel="stylesheet">
     <link href="./../../resources/css/prettify.css" rel="stylesheet">
     <!--link href="./../../resources/css/bootstrap-mods.css" rel="stylesheet"-->
     <link href="./../../resources/css/main.css" rel="stylesheet">
     <link href="./../../resources/font-awesome-4.6.3/css/font-awesome.min.css" rel="stylesheet">

     <script type="text/javascript">
         var t = encodeURIComponent(document.title.replace(/^\s+|\s+$/g,""));
         var u = encodeURIComponent(""+document.URL);

       function fbshare () {
           window.open(
                   "http://www.facebook.com/sharer/sharer.php?u="+u,
                   'Share on Facebook',
                   'width=640,height=426');
       };
       function gpshare () {
           window.open(
                   "https://plus.google.com/share?url="+u,
                   'Share on Google+',
                   'width=584,height=385');
       };
       function twshare () {
           window.open(
                   "https://twitter.com/intent/tweet?url="+u+"&text="+t,
                   'Share on Twitter',
                   'width=800,height=526');
       };
       function pinshare () {
           window.open("//www.pinterest.com/pin/create/button/?url="+u+"&media=http%3A%2F%2Ftomee.apache.org%2Fresources%2Fimages%2Ffeather-logo.png&description="+t,
                   'Share on Pinterest',
                   'width=800,height=526');
       };
     </script>

     <!-- Le fav and touch icons -->
     <link rel="shortcut icon" href="./../../favicon.ico">
     <link rel="apple-touch-icon" href="./../../resources/images/apple-touch-icon.png">
     <link rel="apple-touch-icon" sizes="72x72" href="./../../resources/images/apple-touch-icon-72x72.png">
     <link rel="apple-touch-icon" sizes="114x114" href="./../../resources/images/apple-touch-icon-114x114.png">

     <script src="./../../resources/js/prettify.js" type="text/javascript"></script>
     <script src="./../../resources/js/jquery-latest.js"></script>
     <script src="http://platform.twitter.com/widgets.js" type="text/javascript"></script>
     <script src="./../../resources/js/common.js"></script>
     <script src="./../../resources/js/prettyprint.js"></script>
     <!--script src="//assets.pinterest.com/js/pinit.js" type="text/javascript" async></script//-->

     <script type="text/javascript">

       var _gaq = _gaq || [];
       _gaq.push(['_setAccount', 'UA-2717626-1']);
       _gaq.push(['_setDomainName', 'apache.org']);
       _gaq.push(['_trackPageview']);

       (function() {
         var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
         ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
         var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
       })();

     </script>
   </head>

   <body>

     <div class="topbar" data-dropdown="dropdown">
       <div class="fill">
         <div class="container">
           <a class="brand" href="./../../index.html">Apache TomEE</a>
           <ul class="nav">
               <li class="dropdown">
                   <a class="dropdown-toggle" data-toggle="dropdown" href="#">
                   Apache
                       <b class="caret"></b>
                   </a>
                   <ul class="dropdown-menu">
                      <!-- <li><a href="./../../misc/whoweare.html">Who we are?</a></li> -->
                      <!-- <li><a href="./../../misc/heritage.html">Heritage</a></li> -->
                      <li><a href="http://www.apache.org">Apache Home</a></li>
                      <!-- <li><a href="./../../misc/resources.html">Resources</a></li> -->
                      <li><a href="./../../misc/contact.html">Contact</a></li>
                      <li><a href="./../../misc/legal.html">Legal</a></li>
                      <li><a href="http://www.apache.org/foundation/sponsorship.html">Sponsorship</a></li>
                      <li><a href="http://www.apache.org/foundation/thanks.html">Thanks</a></li>
                      <li class="divider"/>
                      <li><a href="http://www.apache.org/security">Security</a></li>
                   </ul>
               </li>
               <li><a href="./../../index.html">Home</a></li>
               <li><a href="./../../downloads.html">Downloads</a></li>
               <li><a href="./../../documentation.html">Documentation</a></li>
               <li><a href="./../../examples-trunk/index.html">Examples</a></li>
               <li><a href="./../../support.html">Support</a></li>
               <li><a href="./../../contribute.html">Contribute</a></li>
               <li><a href="./../../security/index.html">Security</a></li>
           </ul>

             <!-- Google CSE Search Box Begins  -->
             <FORM class="pull-right" id="searchbox_010475492895890475512:_t4iqjrgx90" action="http://www.google.com/cse">
                 <INPUT type="hidden" name="cx" value="010475492895890475512:_t4iqjrgx90">
                 <INPUT type="hidden" name="cof" value="FORID:0">
                 <INPUT size="18" width="130" style="width:130px" name="q" type="text" placeholder="Search">
             </FORM>
             <!--<SCRIPT type="text/javascript" src="http://www.google.com/coop/cse/brand?form=searchbox_010475492895890475512:_t4iqjrgx90"></SCRIPT>-->
             <!-- Google CSE Search Box Ends -->
         </div>
       </div>
     </div>

     <div class="container">


 <div class="row">
     <div class="span8">
         <small><a href="./../../index.html">Home</a>&nbsp;&raquo&nbsp;<a href="./../../examples-trunk/">Examples Trunk</a>&nbsp;&raquo&nbsp;<a href="./../../examples-trunk/datasource-ciphered-password/">Datasource Ciphered Password</a></small><br>
     </div>
     <div class="span8">
     </div>
 </div>
 &nbsp;
 <div class="page-header">
 <h1>DataSource Ciphered Password

     <div style="float: right; position: relative; bottom: -10px; ">
 	<div id="google_translate_element"></div><script type="text/javascript">
 function googleTranslateElementInit() {
   new google.translate.TranslateElement({pageLanguage: 'en', layout: google.translate.TranslateElement.InlineLayout.SIMPLE}, 'google_translate_element');
 }
 </script><script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>
         <a onclick="javascript:gpshare()" class="gp-share sprite" title="Share on Google+">share [gp]</a>
         <a onclick="javascript:fbshare()" class="fb-share sprite" title="Share on Facebook">share [fb]</a>
         <a onclick="javascript:twshare()" class="tw-share sprite" title="Share on Twitter">share [tw]</a>
         <a onclick="javascript:pinshare()" class="pin-share sprite" title="Share on Pinterest">share [pin]</a>
         <a data-toggle="modal" href="#edit" class="edit-page" title="Contribute to this Page">contribute</a>
     </div>
 </h1>
 </div>

 <h1>Datasource Ciphered Password example</h1>

 <p>This example shows how to use a ciphered password with an OpenEJB datasource.</p>

 <p>It shows how to implement its own encryption too.</p>

 <h1>Configuration</h1>

 <p>The configuration is simply a datasource configuration with an additionnal parameter
 "PasswordCipher" to specify the encryption to use.</p>

 <p>Example using Static3DES encryption:</p>

 <pre><code>    properties.setProperty("ProtectedDatasource", "new://Resource?type=DataSource");
     properties.setProperty("ProtectedDatasource.JdbcDriver", "org.hsqldb.jdbcDriver");
     properties.setProperty("ProtectedDatasource.JdbcUrl", "jdbc:hsqldb:mem:protected");
     properties.setProperty("ProtectedDatasource.UserName", "user");
     // the plain text password is "YouLLN3v3rFindM3"
     properties.setProperty("ProtectedDatasource.Password", "fEroTNXjaL5SOTyRQ92x3DNVS/ksbtgs");
     properties.setProperty("ProtectedDatasource.PasswordCipher", "Static3DES");
     properties.setProperty("ProtectedDatasource.JtaManaged", "true");
 </code></pre>

 <h1>Using its own implementation</h1>

 <p>The example implement a reverse encryption which simply reverse the password to encrypt/decrypt.</p>

 <p>The implementation is done with commons-lang library:</p>

 <pre><code>public static class ReverseEncryption implements PasswordCipher {
     @Override public char[] encrypt(String plainPassword) {
         return StringUtils.reverse(plainPassword).toCharArray();
     }

     @Override public String decrypt(char[] encryptedPassword) {
         return new String(encrypt(new String(encryptedPassword)));
     }
 }
 </code></pre>

 <p>To be functional it needs the file <code>META-INF/org.apache.openejb.resource.jdbc.PasswordCipher/reverse</code>.</p>

 <p>The file name (reverse) define  the encryption name to use for the PasswordCipher parameter.</p>

 <p>This file simply contains the implementation class of the encryption.</p>

 <p>Then you simply declare this encryption for your datasource:</p>

 <pre><code>    properties.setProperty("ProtectedDatasource", "new://Resource?type=DataSource");
     properties.setProperty("ProtectedDatasource.JdbcDriver", "org.hsqldb.jdbcDriver");
     properties.setProperty("ProtectedDatasource.JdbcUrl", "jdbc:hsqldb:mem:protected");
     properties.setProperty("ProtectedDatasource.UserName", USER);
     properties.setProperty("ProtectedDatasource.Password", "3MdniFr3v3NLLuoY");
     properties.setProperty("ProtectedDatasource.PasswordCipher", "reverse");
     properties.setProperty("ProtectedDatasource.JtaManaged", "true");
 </code></pre>

 <h1>Documentation</h1>

 <p>For more information please see the <a href="http://tomee.apache.org/3.0/datasource-password-encryption.html">documentation</a></p>

 <h1>Full Test Source</h1>

 <pre><code>package org.superbiz;

 import org.apache.commons.lang.StringUtils;
 import org.apache.openejb.resource.jdbc.PasswordCipher;
 import org.junit.BeforeClass;
 import org.junit.Test;

 import javax.annotation.Resource;
 import javax.ejb.embeddable.EJBContainer;
 import javax.naming.Context;
 import javax.sql.DataSource;
 import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.Statement;
 import java.util.Properties;

 import static junit.framework.Assert.assertNotNull;

 public class DataSourceCipheredExampleTest {
     private static final String USER = DataSourceCipheredExampleTest.class.getSimpleName().toUpperCase();
     private static final String PASSWORD = "YouLLN3v3rFindM3";
     private static final String DATASOURCE_URL = "jdbc:hsqldb:mem:protected";

     @Resource
     private DataSource dataSource;

     @BeforeClass
     public static void addDatabaseUserWithPassword() throws Exception {
         Class.forName("org.hsqldb.jdbcDriver");
         Connection conn = DriverManager.getConnection(DATASOURCE_URL, "sa", "");
         conn.setAutoCommit(true);
         Statement st = conn.createStatement();
         st.executeUpdate("CREATE USER " + USER + " PASSWORD '" + PASSWORD + "';");
         st.close();
         conn.commit();
         conn.close();
     }

     @Test
     public void accessDatasource() throws Exception {
         // define the datasource
         Properties properties = new Properties();
         properties.setProperty("ProtectedDatasource", "new://Resource?type=DataSource");
         properties.setProperty("ProtectedDatasource.JdbcDriver", "org.hsqldb.jdbcDriver");
         properties.setProperty("ProtectedDatasource.JdbcUrl", DATASOURCE_URL);
         properties.setProperty("ProtectedDatasource.UserName", USER);
         properties.setProperty("ProtectedDatasource.Password", "fEroTNXjaL5SOTyRQ92x3DNVS/ksbtgs");
         properties.setProperty("ProtectedDatasource.PasswordCipher", "Static3DES");
         properties.setProperty("ProtectedDatasource.JtaManaged", "true");

         // start the context and makes junit test injections
         EJBContainer container = EJBContainer.createEJBContainer(properties);
         Context context = container.getContext();
         context.bind("inject", this);

         // test the datasource
         assertNotNull(dataSource);
         assertNotNull(dataSource.getConnection());

         // closing the context
         container.close();
     }

     @Test
     public void accessDatasourceWithMyImplementation() throws Exception {
         // define the datasource
         Properties properties = new Properties();
         properties.setProperty("ProtectedDatasource", "new://Resource?type=DataSource");
         properties.setProperty("ProtectedDatasource.JdbcDriver", "org.hsqldb.jdbcDriver");
         properties.setProperty("ProtectedDatasource.JdbcUrl", "jdbc:hsqldb:mem:protected");
         properties.setProperty("ProtectedDatasource.UserName", USER);
         properties.setProperty("ProtectedDatasource.Password", "3MdniFr3v3NLLuoY");
         properties.setProperty("ProtectedDatasource.PasswordCipher", "reverse");
         properties.setProperty("ProtectedDatasource.JtaManaged", "true");

         // start the context and makes junit test injections
         EJBContainer container = EJBContainer.createEJBContainer(properties);
         Context context = container.getContext();
         context.bind("inject", this);

         // test the datasource
         assertNotNull(dataSource);
         assertNotNull(dataSource.getConnection());

         // closing the context
         container.close();
     }

     public static class ReverseEncryption implements PasswordCipher {
         @Override
         public char[] encrypt(String plainPassword) {
             return StringUtils.reverse(plainPassword).toCharArray();
         }

         @Override
         public String decrypt(char[] encryptedPassword) {
             return new String(encrypt(new String(encryptedPassword)));
         }
     }
 }
 </code></pre>

 <h1>Running</h1>

 <pre><code>-------------------------------------------------------
  T E S T S
 -------------------------------------------------------
 Running org.superbiz.DataSourceCipheredExampleTest
 Apache OpenEJB 4.0.0-beta-1    build: 20111002-04:06
 http://tomee.apache.org/
 INFO - openejb.home = /Users/dblevins/examples/datasource-ciphered-password
 INFO - openejb.base = /Users/dblevins/examples/datasource-ciphered-password
 INFO - Using 'javax.ejb.embeddable.EJBContainer=true'
 INFO - Configuring Service(id=Default Security Service, type=SecurityService, provider-id=Default Security Service)
 INFO - Configuring Service(id=Default Transaction Manager, type=TransactionManager, provider-id=Default Transaction Manager)
 INFO - Configuring Service(id=ProtectedDatasource, type=Resource, provider-id=Default JDBC Database)
 INFO - Found EjbModule in classpath: /Users/dblevins/examples/datasource-ciphered-password/target/test-classes
 INFO - Beginning load: /Users/dblevins/examples/datasource-ciphered-password/target/test-classes
 INFO - Configuring enterprise application: /Users/dblevins/examples/datasource-ciphered-password
 WARN - Method 'lookup' is not available for 'javax.annotation.Resource'. Probably using an older Runtime.
 INFO - Configuring Service(id=Default Managed Container, type=Container, provider-id=Default Managed Container)
 INFO - Auto-creating a container for bean datasource-ciphered-password.Comp: Container(type=MANAGED, id=Default Managed Container)
 INFO - Auto-linking resource-ref 'java:comp/env/org.superbiz.DataSourceCipheredExampleTest/dataSource' in bean datasource-ciphered-password.Comp to Resource(id=ProtectedDatasource)
 INFO - Auto-linking resource-ref 'java:comp/env/org.superbiz.DataSourceCipheredExampleTest/dataSource' in bean org.superbiz.DataSourceCipheredExampleTest to Resource(id=ProtectedDatasource)
 INFO - Enterprise application "/Users/dblevins/examples/datasource-ciphered-password" loaded.
 INFO - Assembling app: /Users/dblevins/examples/datasource-ciphered-password
 INFO - Jndi(name="java:global/datasource-ciphered-password/datasource-ciphered-password.Comp!org.apache.openejb.BeanContext$Comp")
 INFO - Jndi(name="java:global/datasource-ciphered-password/datasource-ciphered-password.Comp")
 INFO - Jndi(name="java:global/EjbModule86823325/org.superbiz.DataSourceCipheredExampleTest!org.superbiz.DataSourceCipheredExampleTest")
 INFO - Jndi(name="java:global/EjbModule86823325/org.superbiz.DataSourceCipheredExampleTest")
 INFO - Created Ejb(deployment-id=datasource-ciphered-password.Comp, ejb-name=datasource-ciphered-password.Comp, container=Default Managed Container)
 INFO - Created Ejb(deployment-id=org.superbiz.DataSourceCipheredExampleTest, ejb-name=org.superbiz.DataSourceCipheredExampleTest, container=Default Managed Container)
 INFO - Started Ejb(deployment-id=datasource-ciphered-password.Comp, ejb-name=datasource-ciphered-password.Comp, container=Default Managed Container)
 INFO - Started Ejb(deployment-id=org.superbiz.DataSourceCipheredExampleTest, ejb-name=org.superbiz.DataSourceCipheredExampleTest, container=Default Managed Container)
 INFO - Deployed Application(path=/Users/dblevins/examples/datasource-ciphered-password)
 INFO - EJBContainer already initialized.  Call ejbContainer.close() to allow reinitialization
 Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.331 sec

 Results :

 Tests run: 2, Failures: 0, Errors: 0, Skipped: 0
 </code></pre>


 <div class="page-header">&nbsp;</div>
 <h4>APIs Used</h4>
 <ul><li><a href="http://docs.oracle.com/javaee/6/api/javax/annotation/Resource.html">javax.annotation.Resource</a></li>
 <li><a href="http://docs.oracle.com/javaee/6/api/javax/ejb/embeddable/EJBContainer.html">javax.ejb.embeddable.EJBContainer</a></li>
 <li><a href="http://docs.oracle.com/javaee/6/api/javax/naming/Context.html">javax.naming.Context</a></li>
 <li><a href="http://docs.oracle.com/javaee/6/api/javax/sql/DataSource.html">javax.sql.DataSource</a></li>
 </ul>

 <h3>Source</h3>
   <ul>
       <li>Apache <a href="http://svn.apache.org/repos/asf/tomee/tomee/trunk/examples/datasource-ciphered-password">datasource-ciphered-password</a></li>
       <li>Github <a href="https://github.com/apache/tomee/tree/trunk/examples/datasource-ciphered-password">datasource-ciphered-password</a></li>
   </ul>
 <pre>
 svn co http://svn.apache.org/repos/asf/tomee/tomee/trunk/examples/datasource-ciphered-password
 cd datasource-ciphered-password
 mvn clean install
 </pre>


         <div id="edit" class="modal hide fade in" style="display: none; ">
             <div class="modal-header">
                 <a class="close" data-dismiss="modal">x</a>

                 <h3>Thank you for contributing to the documentation!</h3>
             </div>
             <div class="modal-body">
                 <h4>Any help with the documentation is greatly appreciated.</h4>
                 <p>All edits are reviewed before going live, so feel free to do much more than fix typos or links.  If you see a page that could benefit from an entire rewrite, we'd be thrilled to review it.  Don't be surprised if we like it so much we ask you for help with other pages :)</p>
                 <small>NOTICE: unless indicated otherwise on the pages in question, all editable content available from apache.org is presumed to be licensed under the Apache License (AL) version 2.0 and hence all submissions to apache.org treated as formal Contributions under the license terms.</small>
                 <!--[if gt IE 6]>
                 <h4>Internet Explorer Users</h4>
                 <p>If you are not an Apache committer, click the Yes link and enter a <i>anonymous</i> for the username and leave the password empty</p>
                 <![endif]-->

             </div>
             <div class="modal-footer">
                 Do you have an Apache ID?
                 <a href="javascript:void(location.href='https://cms.apache.org/redirect?uri='+escape(location.href))" class="btn">Yes</a>
                 <a href="javascript:void(location.href='https://anonymous:@cms.apache.org/redirect?uri='+escape(location.href))" class="btn">No</a>
             </div>
         </div>
         <script src="./../../resources/js/bootstrap-modal.js"></script>

         <footer>
             <p>Copyright &copy; 1999-2016 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.
                 Apache TomEE, TomEE, Apache, the Apache feather logo, and the Apache TomEE project logo are trademarks of The Apache Software Foundation.
                 All other marks mentioned may be trademarks or registered trademarks of their respective owners.</p>
         </footer>

     </div> <!-- /container -->

     <!-- Javascript
     ================================================== -->
     <!-- Placed at the end of the document so the pages load faster -->
     <script src="./../../resources/js/bootstrap-dropdown.js"></script>

   </body>
 </html>
	<!DOCTYPE html>
	<html lang="en">
	<head>

	<meta charset="UTF-8">
	<title>DataSource Ciphered Password</title>
	<meta name="description" content="Apache TomEE">
	<meta name="author" content="Apache TomEE">
	<meta name="google-translate-customization" content="f36a520c08f4c9-0a04e86a9c075ce9-g265f3196f697cf8f-10">
	<meta http-equiv="Pragma" content="no-cache">
	<meta http-equiv="Expires" content="0">
	<meta http-equiv="Cache-Control" content="no-store, no-cache, must-revalidate, max-age=0">

	<!-- Le HTML5 shim, for IE6-8 support of HTML elements -->
	<!--[if lt IE 9]>
	<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
	<![endif]-->

	<!-- Le styles -->
	<link href="./../../resources/css/bootstrap.css" rel="stylesheet">
	<link href="./../../resources/css/prettify.css" rel="stylesheet">
	<!--link href="./../../resources/css/bootstrap-mods.css" rel="stylesheet"-->
	<link href="./../../resources/css/main.css" rel="stylesheet">
	<link href="./../../resources/font-awesome-4.6.3/css/font-awesome.min.css" rel="stylesheet">

	<script type="text/javascript">
	var t = encodeURIComponent(document.title.replace(/^\s+\|\s+$/g,""));
	var u = encodeURIComponent(""+document.URL);

	function fbshare () {
	window.open(
	"http://www.facebook.com/sharer/sharer.php?u="+u,
	'Share on Facebook',
	'width=640,height=426');
	};
	function gpshare () {
	window.open(
	"https://plus.google.com/share?url="+u,
	'Share on Google+',
	'width=584,height=385');
	};
	function twshare () {
	window.open(
	"https://twitter.com/intent/tweet?url="+u+"&text="+t,
	'Share on Twitter',
	'width=800,height=526');
	};
	function pinshare () {
	window.open("//www.pinterest.com/pin/create/button/?url="+u+"&media=http%3A%2F%2Ftomee.apache.org%2Fresources%2Fimages%2Ffeather-logo.png&description="+t,
	'Share on Pinterest',
	'width=800,height=526');
	};
	</script>

	<!-- Le fav and touch icons -->
	<link rel="shortcut icon" href="./../../favicon.ico">
	<link rel="apple-touch-icon" href="./../../resources/images/apple-touch-icon.png">
	<link rel="apple-touch-icon" sizes="72x72" href="./../../resources/images/apple-touch-icon-72x72.png">
	<link rel="apple-touch-icon" sizes="114x114" href="./../../resources/images/apple-touch-icon-114x114.png">

	<script src="./../../resources/js/prettify.js" type="text/javascript"></script>
	<script src="./../../resources/js/jquery-latest.js"></script>
	<script src="http://platform.twitter.com/widgets.js" type="text/javascript"></script>
	<script src="./../../resources/js/common.js"></script>
	<script src="./../../resources/js/prettyprint.js"></script>
	<!--script src="//assets.pinterest.com/js/pinit.js" type="text/javascript" async></script//-->

	<script type="text/javascript">

	var _gaq = _gaq \|\| [];
	_gaq.push(['_setAccount', 'UA-2717626-1']);
	_gaq.push(['_setDomainName', 'apache.org']);
	_gaq.push(['_trackPageview']);

	(function() {
	var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
	ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
	var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
	})();

	</script>
	</head>

	<body>

	<div class="topbar" data-dropdown="dropdown">
	<div class="fill">
	<div class="container">
	<a class="brand" href="./../../index.html">Apache TomEE</a>
	<ul class="nav">
	<li class="dropdown">
	<a class="dropdown-toggle" data-toggle="dropdown" href="#">
	Apache
	<b class="caret"></b>
	</a>
	<ul class="dropdown-menu">
	<!-- <li><a href="./../../misc/whoweare.html">Who we are?</a></li> -->
	<!-- <li><a href="./../../misc/heritage.html">Heritage</a></li> -->
	<li><a href="http://www.apache.org">Apache Home</a></li>
	<!-- <li><a href="./../../misc/resources.html">Resources</a></li> -->
	<li><a href="./../../misc/contact.html">Contact</a></li>
	<li><a href="./../../misc/legal.html">Legal</a></li>
	<li><a href="http://www.apache.org/foundation/sponsorship.html">Sponsorship</a></li>
	<li><a href="http://www.apache.org/foundation/thanks.html">Thanks</a></li>
	<li class="divider"/>
	<li><a href="http://www.apache.org/security">Security</a></li>
	</ul>
	</li>
	<li><a href="./../../index.html">Home</a></li>
	<li><a href="./../../downloads.html">Downloads</a></li>
	<li><a href="./../../documentation.html">Documentation</a></li>
	<li><a href="./../../examples-trunk/index.html">Examples</a></li>
	<li><a href="./../../support.html">Support</a></li>
	<li><a href="./../../contribute.html">Contribute</a></li>
	<li><a href="./../../security/index.html">Security</a></li>
	</ul>

	<!-- Google CSE Search Box Begins -->
	<FORM class="pull-right" id="searchbox_010475492895890475512:_t4iqjrgx90" action="http://www.google.com/cse">
	<INPUT type="hidden" name="cx" value="010475492895890475512:_t4iqjrgx90">
	<INPUT type="hidden" name="cof" value="FORID:0">
	<INPUT size="18" width="130" style="width:130px" name="q" type="text" placeholder="Search">
	</FORM>
	<!--<SCRIPT type="text/javascript" src="http://www.google.com/coop/cse/brand?form=searchbox_010475492895890475512:_t4iqjrgx90"></SCRIPT>-->
	<!-- Google CSE Search Box Ends -->
	</div>
	</div>
	</div>

	<div class="container">


	<div class="row">
	<div class="span8">
	<small><a href="./../../index.html">Home</a> &raquo <a href="./../../examples-trunk/">Examples Trunk</a> &raquo <a href="./../../examples-trunk/datasource-ciphered-password/">Datasource Ciphered Password</a></small><br>
	</div>
	<div class="span8">
	</div>
	</div>

	<div class="page-header">
	<h1>DataSource Ciphered Password

	<div style="float: right; position: relative; bottom: -10px; ">
	<div id="google_translate_element"></div><script type="text/javascript">
	function googleTranslateElementInit() {
	new google.translate.TranslateElement({pageLanguage: 'en', layout: google.translate.TranslateElement.InlineLayout.SIMPLE}, 'google_translate_element');
	}
	</script><script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>
	<a onclick="javascript:gpshare()" class="gp-share sprite" title="Share on Google+">share [gp]</a>
	<a onclick="javascript:fbshare()" class="fb-share sprite" title="Share on Facebook">share [fb]</a>
	<a onclick="javascript:twshare()" class="tw-share sprite" title="Share on Twitter">share [tw]</a>
	<a onclick="javascript:pinshare()" class="pin-share sprite" title="Share on Pinterest">share [pin]</a>
	<a data-toggle="modal" href="#edit" class="edit-page" title="Contribute to this Page">contribute</a>
	</div>
	</h1>
	</div>

	<h1>Datasource Ciphered Password example</h1>

	<p>This example shows how to use a ciphered password with an OpenEJB datasource.</p>

	<p>It shows how to implement its own encryption too.</p>

	<h1>Configuration</h1>

	<p>The configuration is simply a datasource configuration with an additionnal parameter
	"PasswordCipher" to specify the encryption to use.</p>

	<p>Example using Static3DES encryption:</p>

	<pre><code> properties.setProperty("ProtectedDatasource", "new://Resource?type=DataSource");
	properties.setProperty("ProtectedDatasource.JdbcDriver", "org.hsqldb.jdbcDriver");
	properties.setProperty("ProtectedDatasource.JdbcUrl", "jdbc:hsqldb:mem:protected");
	properties.setProperty("ProtectedDatasource.UserName", "user");
	// the plain text password is "YouLLN3v3rFindM3"
	properties.setProperty("ProtectedDatasource.Password", "fEroTNXjaL5SOTyRQ92x3DNVS/ksbtgs");
	properties.setProperty("ProtectedDatasource.PasswordCipher", "Static3DES");
	properties.setProperty("ProtectedDatasource.JtaManaged", "true");
	</code></pre>

	<h1>Using its own implementation</h1>

	<p>The example implement a reverse encryption which simply reverse the password to encrypt/decrypt.</p>

	<p>The implementation is done with commons-lang library:</p>

	<pre><code>public static class ReverseEncryption implements PasswordCipher {
	@Override public char[] encrypt(String plainPassword) {
	return StringUtils.reverse(plainPassword).toCharArray();
	}

	@Override public String decrypt(char[] encryptedPassword) {
	return new String(encrypt(new String(encryptedPassword)));
	}
	}
	</code></pre>

	<p>To be functional it needs the file <code>META-INF/org.apache.openejb.resource.jdbc.PasswordCipher/reverse</code>.</p>

	<p>The file name (reverse) define the encryption name to use for the PasswordCipher parameter.</p>

	<p>This file simply contains the implementation class of the encryption.</p>

	<p>Then you simply declare this encryption for your datasource:</p>

	<pre><code> properties.setProperty("ProtectedDatasource", "new://Resource?type=DataSource");
	properties.setProperty("ProtectedDatasource.JdbcDriver", "org.hsqldb.jdbcDriver");
	properties.setProperty("ProtectedDatasource.JdbcUrl", "jdbc:hsqldb:mem:protected");
	properties.setProperty("ProtectedDatasource.UserName", USER);
	properties.setProperty("ProtectedDatasource.Password", "3MdniFr3v3NLLuoY");
	properties.setProperty("ProtectedDatasource.PasswordCipher", "reverse");
	properties.setProperty("ProtectedDatasource.JtaManaged", "true");
	</code></pre>

	<h1>Documentation</h1>

	<p>For more information please see the <a href="http://tomee.apache.org/3.0/datasource-password-encryption.html">documentation</a></p>

	<h1>Full Test Source</h1>

	<pre><code>package org.superbiz;

	import org.apache.commons.lang.StringUtils;
	import org.apache.openejb.resource.jdbc.PasswordCipher;
	import org.junit.BeforeClass;
	import org.junit.Test;

	import javax.annotation.Resource;
	import javax.ejb.embeddable.EJBContainer;
	import javax.naming.Context;
	import javax.sql.DataSource;
	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.Statement;
	import java.util.Properties;

	import static junit.framework.Assert.assertNotNull;

	public class DataSourceCipheredExampleTest {
	private static final String USER = DataSourceCipheredExampleTest.class.getSimpleName().toUpperCase();
	private static final String PASSWORD = "YouLLN3v3rFindM3";
	private static final String DATASOURCE_URL = "jdbc:hsqldb:mem:protected";

	@Resource
	private DataSource dataSource;

	@BeforeClass
	public static void addDatabaseUserWithPassword() throws Exception {
	Class.forName("org.hsqldb.jdbcDriver");
	Connection conn = DriverManager.getConnection(DATASOURCE_URL, "sa", "");
	conn.setAutoCommit(true);
	Statement st = conn.createStatement();
	st.executeUpdate("CREATE USER " + USER + " PASSWORD '" + PASSWORD + "';");
	st.close();
	conn.commit();
	conn.close();
	}

	@Test
	public void accessDatasource() throws Exception {
	// define the datasource
	Properties properties = new Properties();
	properties.setProperty("ProtectedDatasource", "new://Resource?type=DataSource");
	properties.setProperty("ProtectedDatasource.JdbcDriver", "org.hsqldb.jdbcDriver");
	properties.setProperty("ProtectedDatasource.JdbcUrl", DATASOURCE_URL);
	properties.setProperty("ProtectedDatasource.UserName", USER);
	properties.setProperty("ProtectedDatasource.Password", "fEroTNXjaL5SOTyRQ92x3DNVS/ksbtgs");
	properties.setProperty("ProtectedDatasource.PasswordCipher", "Static3DES");
	properties.setProperty("ProtectedDatasource.JtaManaged", "true");

	// start the context and makes junit test injections
	EJBContainer container = EJBContainer.createEJBContainer(properties);
	Context context = container.getContext();
	context.bind("inject", this);

	// test the datasource
	assertNotNull(dataSource);
	assertNotNull(dataSource.getConnection());

	// closing the context
	container.close();
	}

	@Test
	public void accessDatasourceWithMyImplementation() throws Exception {
	// define the datasource
	Properties properties = new Properties();
	properties.setProperty("ProtectedDatasource", "new://Resource?type=DataSource");
	properties.setProperty("ProtectedDatasource.JdbcDriver", "org.hsqldb.jdbcDriver");
	properties.setProperty("ProtectedDatasource.JdbcUrl", "jdbc:hsqldb:mem:protected");
	properties.setProperty("ProtectedDatasource.UserName", USER);
	properties.setProperty("ProtectedDatasource.Password", "3MdniFr3v3NLLuoY");
	properties.setProperty("ProtectedDatasource.PasswordCipher", "reverse");
	properties.setProperty("ProtectedDatasource.JtaManaged", "true");

	// start the context and makes junit test injections
	EJBContainer container = EJBContainer.createEJBContainer(properties);
	Context context = container.getContext();
	context.bind("inject", this);

	// test the datasource
	assertNotNull(dataSource);
	assertNotNull(dataSource.getConnection());

	// closing the context
	container.close();
	}

	public static class ReverseEncryption implements PasswordCipher {
	@Override
	public char[] encrypt(String plainPassword) {
	return StringUtils.reverse(plainPassword).toCharArray();
	}

	@Override
	public String decrypt(char[] encryptedPassword) {
	return new String(encrypt(new String(encryptedPassword)));
	}
	}
	}
	</code></pre>

	<h1>Running</h1>

	<pre><code>-------------------------------------------------------
	T E S T S
	-------------------------------------------------------
	Running org.superbiz.DataSourceCipheredExampleTest
	Apache OpenEJB 4.0.0-beta-1 build: 20111002-04:06
	http://tomee.apache.org/
	INFO - openejb.home = /Users/dblevins/examples/datasource-ciphered-password
	INFO - openejb.base = /Users/dblevins/examples/datasource-ciphered-password
	INFO - Using 'javax.ejb.embeddable.EJBContainer=true'
	INFO - Configuring Service(id=Default Security Service, type=SecurityService, provider-id=Default Security Service)
	INFO - Configuring Service(id=Default Transaction Manager, type=TransactionManager, provider-id=Default Transaction Manager)
	INFO - Configuring Service(id=ProtectedDatasource, type=Resource, provider-id=Default JDBC Database)
	INFO - Found EjbModule in classpath: /Users/dblevins/examples/datasource-ciphered-password/target/test-classes
	INFO - Beginning load: /Users/dblevins/examples/datasource-ciphered-password/target/test-classes
	INFO - Configuring enterprise application: /Users/dblevins/examples/datasource-ciphered-password
	WARN - Method 'lookup' is not available for 'javax.annotation.Resource'. Probably using an older Runtime.
	INFO - Configuring Service(id=Default Managed Container, type=Container, provider-id=Default Managed Container)
	INFO - Auto-creating a container for bean datasource-ciphered-password.Comp: Container(type=MANAGED, id=Default Managed Container)
	INFO - Auto-linking resource-ref 'java:comp/env/org.superbiz.DataSourceCipheredExampleTest/dataSource' in bean datasource-ciphered-password.Comp to Resource(id=ProtectedDatasource)
	INFO - Auto-linking resource-ref 'java:comp/env/org.superbiz.DataSourceCipheredExampleTest/dataSource' in bean org.superbiz.DataSourceCipheredExampleTest to Resource(id=ProtectedDatasource)
	INFO - Enterprise application "/Users/dblevins/examples/datasource-ciphered-password" loaded.
	INFO - Assembling app: /Users/dblevins/examples/datasource-ciphered-password
	INFO - Jndi(name="java:global/datasource-ciphered-password/datasource-ciphered-password.Comp!org.apache.openejb.BeanContext$Comp")
	INFO - Jndi(name="java:global/datasource-ciphered-password/datasource-ciphered-password.Comp")
	INFO - Jndi(name="java:global/EjbModule86823325/org.superbiz.DataSourceCipheredExampleTest!org.superbiz.DataSourceCipheredExampleTest")
	INFO - Jndi(name="java:global/EjbModule86823325/org.superbiz.DataSourceCipheredExampleTest")
	INFO - Created Ejb(deployment-id=datasource-ciphered-password.Comp, ejb-name=datasource-ciphered-password.Comp, container=Default Managed Container)
	INFO - Created Ejb(deployment-id=org.superbiz.DataSourceCipheredExampleTest, ejb-name=org.superbiz.DataSourceCipheredExampleTest, container=Default Managed Container)
	INFO - Started Ejb(deployment-id=datasource-ciphered-password.Comp, ejb-name=datasource-ciphered-password.Comp, container=Default Managed Container)
	INFO - Started Ejb(deployment-id=org.superbiz.DataSourceCipheredExampleTest, ejb-name=org.superbiz.DataSourceCipheredExampleTest, container=Default Managed Container)
	INFO - Deployed Application(path=/Users/dblevins/examples/datasource-ciphered-password)
	INFO - EJBContainer already initialized. Call ejbContainer.close() to allow reinitialization
	Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.331 sec

	Results :

	Tests run: 2, Failures: 0, Errors: 0, Skipped: 0
	</code></pre>


	<div class="page-header"> </div>
	<h4>APIs Used</h4>
	<ul><li><a href="http://docs.oracle.com/javaee/6/api/javax/annotation/Resource.html">javax.annotation.Resource</a></li>
	<li><a href="http://docs.oracle.com/javaee/6/api/javax/ejb/embeddable/EJBContainer.html">javax.ejb.embeddable.EJBContainer</a></li>
	<li><a href="http://docs.oracle.com/javaee/6/api/javax/naming/Context.html">javax.naming.Context</a></li>
	<li><a href="http://docs.oracle.com/javaee/6/api/javax/sql/DataSource.html">javax.sql.DataSource</a></li>
	</ul>

	<h3>Source</h3>
	<ul>
	<li>Apache <a href="http://svn.apache.org/repos/asf/tomee/tomee/trunk/examples/datasource-ciphered-password">datasource-ciphered-password</a></li>
	<li>Github <a href="https://github.com/apache/tomee/tree/trunk/examples/datasource-ciphered-password">datasource-ciphered-password</a></li>
	</ul>
	<pre>
	svn co http://svn.apache.org/repos/asf/tomee/tomee/trunk/examples/datasource-ciphered-password
	cd datasource-ciphered-password
	mvn clean install
	</pre>


	<div id="edit" class="modal hide fade in" style="display: none; ">
	<div class="modal-header">
	<a class="close" data-dismiss="modal">x</a>

	<h3>Thank you for contributing to the documentation!</h3>
	</div>
	<div class="modal-body">
	<h4>Any help with the documentation is greatly appreciated.</h4>
	<p>All edits are reviewed before going live, so feel free to do much more than fix typos or links. If you see a page that could benefit from an entire rewrite, we'd be thrilled to review it. Don't be surprised if we like it so much we ask you for help with other pages :)</p>
	<small>NOTICE: unless indicated otherwise on the pages in question, all editable content available from apache.org is presumed to be licensed under the Apache License (AL) version 2.0 and hence all submissions to apache.org treated as formal Contributions under the license terms.</small>
	<!--[if gt IE 6]>
	<h4>Internet Explorer Users</h4>
	<p>If you are not an Apache committer, click the Yes link and enter a <i>anonymous</i> for the username and leave the password empty</p>
	<![endif]-->

	</div>
	<div class="modal-footer">
	Do you have an Apache ID?
	<a href="javascript:void(location.href='https://cms.apache.org/redirect?uri='+escape(location.href))" class="btn">Yes</a>
	<a href="javascript:void(location.href='https://anonymous:@cms.apache.org/redirect?uri='+escape(location.href))" class="btn">No</a>
	</div>
	</div>
	<script src="./../../resources/js/bootstrap-modal.js"></script>

	<footer>
	<p>Copyright © 1999-2016 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.
	Apache TomEE, TomEE, Apache, the Apache feather logo, and the Apache TomEE project logo are trademarks of The Apache Software Foundation.
	All other marks mentioned may be trademarks or registered trademarks of their respective owners.</p>
	</footer>

	</div> <!-- /container -->

	<!-- Javascript
	================================================== -->
	<!-- Placed at the end of the document so the pages load faster -->
	<script src="./../../resources/js/bootstrap-dropdown.js"></script>

	</body>
	</html>