Andrus,
Thank you.
I have instantiated BasicDataSource but there does not seem to be a method
available to set
properties! The only thing I can see is addConnectionProperty(String name,
String value)
I used that but now I am left with one an error:
"The type OracleSSLDataSourceFactory must implement the inherited abstract
method
DataSourceFactory.getDataSource(String, Level)???"
Please help if you can
I do:
import javax.sql.DataSource;
import org.apache.commons.dbcp.*;
import org.apache.cayenne.conf.*;
public class OracleSSLDataSourceFactory implements DataSourceFactory {
protected Configuration parentConfiguration;
public void initializeWithParentConfiguration(Configuration
parentConfiguration) {
this.parentConfiguration = parentConfiguration;
}
public DataSource getDataSource(String location) throws Exception{
String url =
"jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=servername)(PORT=2484))
(CONNECT_DATA=(SERVICE_NAME=servicename)))";
BasicDataSource ds= new BasicDataSource();
ds.setUrl(url);
ds.addConnectionProperty("user", "user");
ds.addConnectionProperty("password", "password");
ds.addConnectionProperty("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)");
return ds;
}
}
-----Original Message-----
From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
Sent: 18 June 2008 13:13
To: [email protected]
Subject: Re: Configuring SSL
No, it is a part of Apache commons-dbcp library:
http://commons.apache.org/dbcp
Andrus
On Jun 18, 2008, at 3:06 PM, Elena Doyle wrote:
> Andrus,
>
> What is DBCP BasicDataSource, please? Is it part of your framework?
>
> Elena
>
> -----Original Message-----
> From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
> Sent: 16 June 2008 16:55
> To: [email protected]
> Subject: Re: Configuring SSL
>
> Hi Elena,
>
> Here is a (badly written) factory for DBCP:
>
> https://svn.apache.org/repos/asf/cayenne/main/trunk/framework/cayenne-
> jdk1.5-unpublished/src/main/ja
> va/org/apache/cayenne/conf/DBCPDataSourceFactory.java
>
> You can use a similar approach to properties loading, but then instead
> of doing what we did with DBCPDataSourceProperties/
> DBCPDataSourceBuilder helper classes, do
> this:
>
> 1. Load a properties file (that will have to include the URL, user
> name, password, and any of your custom settings) to a
> java.util.Properties object.
> 2. instantiate DBCP BasicDataSource, and call its set* methods to
> populate the properties.
>
> Andrus
>
> On Jun 16, 2008, at 6:39 PM, Elena Doyle wrote:
>
>> Andrus,
>>
>> Many thanks for this. Due to bussiness needs I need to write a custom
>> one. As I am mostly a database and PL/SQL person, is the source code
>> of the standard Cayenne data factory available anywhere. I could not
>> find it in the repository.
>>
>> Many thanks
>>
>> Elena
>
>
