cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Configuring SSL
Date Wed, 18 Jun 2008 15:31:02 GMT
The DataSourceFactory interface changed between Cayenne releases. Make  
sure you implement the version of the interface matching Cayenne  
version that you are using.

Andrus



On Jun 18, 2008, at 5:01 PM, Elena Doyle wrote:
> 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:andrus@objectstyle.org]
> Sent: 18 June 2008 13:13
> To: user@cayenne.apache.org
> 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:andrus@objectstyle.org]
>> Sent: 16 June 2008 16:55
>> To: user@cayenne.apache.org
>> 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
>>
>>
>
>


Mime
View raw message