title: JDBC Client Encryption Type Setup
body: <p>I'm trying to force my client application to connect to an encrypted Oracle 11g server using AES256 instead of RC4_256. We have been notified that the RC4_256 encryption type will be disabled "soon".</p>
  
  <p>We are using the latest 11g drivers with c3p0 as our connection pool. Below is the bean config.</p>
  
  <pre><code>&lt;bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"&gt;
      &lt;property name="driverClass" value="oracle.jdbc.OracleDriver"/&gt;
      &lt;property name="jdbcUrl" value="${jdbc.url}"/&gt;
      &lt;!-- other pool properties --&gt;
      &lt;property name="properties"&gt;
          &lt;props&gt;
              &lt;prop key="user"&gt;${jdbc.username}&lt;/prop&gt;
              &lt;prop key="password"&gt;${jdbc.password}&lt;/prop&gt;
  
                              &lt;!-- this is one set of many I've tried --&gt;
              &lt;prop key="oracle.net.encryption_client"&gt;REQUIRED&lt;/prop&gt;
              &lt;prop key="oracle.net.encryption_types_client"&gt;( AES256 )&lt;/prop&gt;
          &lt;/props&gt;
      &lt;/property&gt;
  &lt;/bean&gt;
  </code></pre>
  
  <p>I've tried many permutations using oracle.net.encryption_types_client, and oracle.net.encryption_client, CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL, CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES. I've named them as is in the Oracle docs, as Java properties, etc.</p>
  
  <p>I haven't been able to get it to connect using anything but RC4_256.</p>
  
  <p>I'm using the following query on the database server to see how my client is connecting. The Network_Service_Banner from the v$session_connect_info table shows how it's connecting. Here is the current message I'm getting </p>
  
  <blockquote>
    <p>Oracle Advanced Security: RC4_256 encryption service adapter for
    Solaris: Version 11.2.0.3.0 - Prod</p>
  </blockquote>
  
  <pre><code>select s.username,s.machine,s.program,S.LOGON_TIME,s1.* 
  from v$session s, v$session_connect_info s1 
  where s.sid = s1.sid and s.username in ('MYAPP') and s.machine = 'MY-PC'
  order by S.LOGON_TIME DESC, s.sid
  </code></pre>
  
  <p>Any help would be appreciated as I'm wrapped around the axle at this point.</p>