> OK, jag forstar precis, tack sa mycket.
>
> Please write in English!
>
>
Sorry, my fault...

One more time:

>Is there any way to have username/password in encrypted form in the
datasources.xml file?

I think, yes.

  <data-source
      class="com.evermind.sql.DriverManagerDataSource"
      name="Oracle"
      schema="database-schemas/oracle.xml"
      location="jdbc/OracleCoreDS"
      xa-location="jdbc/xa/OracleXADS"
      ejb-location="jdbc/OracleDS"
      connection-driver="oracle.jdbc.driver.OracleDriver"
      username="myuser"
      password="mypass"
      url="jdbc:oracle:thin:@oracleurl:1521:orcl"
      inactivity-timeout="30"
   />


You can inherit com.evermind.sql.DriverManagerDataSource and overlap his
getConnection() method like this:

package test;
public class MyDriverManagerDataSource
{
 protected String decriptPassword(String password)
 {
   // TO DO: decript and return decripted password
 }
 java.sql.Connection getConnection(String username, String password)
 {
  String realpass = decriptPassword(password);
  return super.getConnection(username, realpass);
 }
}

Put your test.MyDriverManagerDataSource to orion classpath. Change
data-sources.xml:

  <data-source
      class="test.MyDriverManagerDataSource" <!-- class changed! -->
      name="Oracle"
      schema="database-schemas/oracle.xml"
      location="jdbc/OracleCoreDS"
      xa-location="jdbc/xa/OracleXADS"
      ejb-location="jdbc/OracleDS"
      connection-driver="oracle.jdbc.driver.OracleDriver"
      username="myuser"
      password="ErwERQ2r&@rw"   <!-- password encripted! -->
      url="jdbc:oracle:thin:@oracleurl:1521:orcl"
      inactivity-timeout="30"
   />



Reply via email to