Re: DBCPDataSourceFactory

[dollj]

Thanks again Mike

I don't manually configure or bind the DataSourceFactory to the 
serverRuntime, but instead allow it to pull it in from the cayenne.xml 
file.
Ok, you mentioned this before and I see in the Modeler where this can be 
specified.

I take it then that MyDataSourceFactory  just needs the one method you show 
below, getDataSource().
This where I then create the DBCP Data Source and just return it.

I'll have a go at it and see.

Thanks, regards
Jurgen



-----Original Message----- 
From: Mike Kienenberger
Sent: Wednesday, March 12, 2014 6:41 PM
To: user@cayenne.apache.org
Subject: Re: DBCPDataSourceFactory

I'm not an expert on this, but I'd set those values when I created the
Data Source.   For my DataSourceFactory, this happens in
getDataSource().  I don't manually configure or bind the
DataSourceFactory to the serverRuntime, but instead allow it to pull
it in from the cayenne.xml file.


   public DataSource getDataSource(DataNodeDescriptor nodeDescriptor)
throws Exception {

[...]

           return new PoolManager(
                   jdbcDriver,
                   dataSourceUrl,
                   minConnections,
                   maxConnections,
                   userName,
                   password,
                   jdbcEventLogger);


On Wed, Mar 12, 2014 at 12:08 PM,  <do...@xsinet.co.za> wrote:
Thanks Mike

Do I setup the BasicDataSource in the module I pass to ServerRuntime ?

I've got:

           String  iniFile = .....;
           MyDataSourceModule  module = new MyDataSourceModule(iniFile);
            server = new ServerRuntime( "cayenne-Vision.xml", module );

Do I then in MyDataSourceModule do something like:

@Override
public void configure( Binder binder )

{
     BasicDataSource ds = new BasicDataSource();
     ds.setUsername("scott");
     ds.setPassword("tiger");

     // .... set other options etc.

     binder.bind( BasicDataSource.class ).toInstance( ds );
}

So the question is if I manually configure a DBCP Data Source how do I 
pass
then pass on to Cayenne ?

Thanks, regards
Jurgen




-----Original Message----- From: Mike Kienenberger
Sent: Wednesday, March 12, 2014 5:02 PM
To: user@cayenne.apache.org
Subject: Re: DBCPDataSourceFactory


According to this

http://svn.apache.org/viewvc/commons/proper/dbcp/trunk/doc/BasicDataSourceExample.java?view=markup

BasicDataSource ds = new BasicDataSource();
ds.setUsername("scott");
ds.setPassword("tiger");



On Wed, Mar 12, 2014 at 5:01 AM,  <do...@xsinet.co.za> wrote:

Hi All

I've successfully configured and used DBCP as a Data Source Factory  :-)

Does anybody know how to provide the username and password besides 
through
the properties file ?

Thanks,
Jurgen