Re: Configuring SSL

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Jun 16 2008 - 10:57:07 EDT

  • Next message: Elena Doyle: "RE: Configuring SSL"

    Hi Elena,

    IIRC, Oracle is the only database that wouldn't allow user properties
    to be appended to the DB URL (the approach I am using in similar
    situations for all other DB's). Unless the parenthesis notation allows
    to pass this property somehow (?), you have two choices:

    1. ("easy") Switch to JNDI DataSource factory, and configure your
    Oracle driver at the web container level, which hopefully provides a
    way to set properties:

    http://cayenne.apache.org/doc/using-jndi.html

    2. ("harder") Write a custom DataSourceFactory. I mentioned this
    approach answering an unrelated question in a recent thread:

      http://markmail.org/message/ndv6534d2edj43rv

    One possible strategy for a custom implementation is a factory that
    instantiates a commons-dbcp BasicDataSource based on some properties
    file:

      http://commons.apache.org/dbcp/apidocs/org/apache/commons/dbcp/BasicDataSource.html

    Andrus

    On Jun 16, 2008, at 12:51 PM, Elena Doyle wrote:

    > Hi Tore,
    >
    > I am using oracle jdbc driver.
    > The documentation tells me to do this:
    >
    > String url = "jdbc:oracle:thin..DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)
    > (HOST=servername)(PORT=2484))
    > (CONNECT_DATA=(SERVICE_NAME=servicename)))");
    > Properties props = new Properties();
    > props.setProperty("user", "scott");
    > props.setProperty("password", "tiger");
    > props.setProperty("oracle.net.ssl_cipher_suites",
    > "(SSL_DH_anon_WITH_3DES_EDE_CBC_SHA, SSL_DH_anon_WITH_RC4_128_MD5,
    > SSL_DH_anon_WITH_DES_CBC_SHA)"};
    > Connection conn=DriverManager.getConnection(url,props);
    >
    > The cayenne configuration file DomainNode.driver is like this:
    >
    > <?xml version="1.0" encoding="utf-8"?>
    > <driver project-version="2.0" class="oracle.jdbc.driver.OracleDriver">
    > <url value="jdbc:oracle:thin..DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)
    > (HOST=myhostname)(PORT= 1521))
    > (CONNECT_DATA=(SERVICE_NAME=myservicename)))"/>
    > <connectionPool min="1" max="1" />
    > <login userName="scott" password="tiger"/>
    > </driver>
    >
    > What I am struggling is how I add property
    > oracle.net.ssl_cipher_suites to the configuration file?
    >
    > Manay thanks
    >
    > Elena
    >
    >
    >
    >
    >
    > -----Original Message-----
    > From: Tore Halset [mailto:halse..vv.ntnu.no]
    > Sent: 14 June 2008 22:30
    > To: use..ayenne.apache.org
    > Subject: Re: Configuring SSL
    >
    >
    > On 13. juni. 2008, at 17.33, Elena Doyle wrote:
    >
    >> How can I configure SSL in DomeinNode.driver.xml. Can somebody give
    >> me
    >> an example.
    >
    > Do you mean SSL connection between your cayenne based application
    > and the database? If so, this is a
    > jdbc setup issue. Please take a look at your jdbc documentation.
    > What sort of database are you
    > using?
    >
    > Regards,
    > - Tore.
    >



    This archive was generated by hypermail 2.0.0 : Mon Jun 16 2008 - 10:57:42 EDT