Hi Pascal,
Yes you can setup DataSource via PropertyDataSourceFactory[1] that can
read all information from runtime properties.
All you need is to provide those properties via env variables or
directly in your code like this (this code for the latest 4.0
version):
ServerRuntime cayenneRuntime = ServerRuntime.builder()
.addConfig("cayenne-project.xml")
.addModule(binder -> {
ServerModule.contributeProperties(binder)
.put("cayenne.jdbc.driver", "com.mysql.Driver")
.put("cayenne.jdbc.url", "jdbc:mysql://127.0.0.1:3306/");
})
.build();
[1]
http://cayenne.apache.org/docs/4.0/api/org/apache/cayenne/configuration/server/PropertyDataSourceFactory.html
On Mon, Jun 12, 2017 at 3:59 PM, Pascal Robert <[email protected]> wrote:
>
>> Le 9 juin 2017 à 11:37, Andrus Adamchik <[email protected]> a écrit :
>>
>> The easiest thing is to remove the DataNode from CayenneModel completely,
>> and use Bootique connections locally, in production and in other
>> environments.
>
> And can I set the connection information in another way for non-Bootique apps?
>
>> Andrus
>>
>>> On Jun 9, 2017, at 6:14 PM, Pascal Robert <[email protected]> wrote:
>>>
>>> Hi,
>>>
>>> I’m deploying my first Bootique app, which use Cayenne. In my config.yml
>>> file, I set the datasource like this:
>>>
>>> jdbc:
>>> mysql:
>>> driverClassName: com.mysql.jdbc.Driver
>>> url:
>>> "jdbc:mysql://10.6.xx.xx:3306/filemaker?connectTimeout=0&autoReconnect=true"
>>> initialSize: 1
>>> username: xxxxx
>>> password: xxxxx
>>>
>>> cayenne:
>>> datasource: mysql
>>>
>>> But when I make a request to the app, it tries to connect to the server
>>> defined in the data model, not from the configuration file.
>>>
>>> INFO [2017-06-09 15:08:32,255] bootique-http-36
>>> o.a.c.c.XMLDataChannelDescriptorLoader: Loading XML configuration resource
>>> from jar:file:/opt/bin/RevendeursWeb-1.0.jar!/cayenne-filemaker.xml
>>> INFO [2017-06-09 15:08:32,278] bootique-http-36
>>> o.a.c.c.XMLDataChannelDescriptorLoader: Loading XML DataMap resource from
>>> jar:file:/opt/bin/RevendeursWeb-1.0.jar!/mysql.map.xml
>>> INFO [2017-06-09 15:08:32,332] bootique-http-36
>>> o.a.c.c.XMLDataChannelDescriptorLoader: Loading XML DataMap resource from
>>> jar:file:/opt/bin/RevendeursWeb-1.0.jar!/revendeurs.map.xml
>>> INFO [2017-06-09 15:08:32,338] bootique-http-36
>>> o.a.c.c.XMLDataChannelDescriptorLoader: Loading XML DataMap resource from
>>> jar:file:/opt/bin/RevendeursWeb-1.0.jar!/utilisateurs.map.xml
>>>
>>> INFO [2017-06-09 15:08:32,366] bootique-http-36 o.a.c.d.DriverDataSource:
>>> Connecting to 'jdbc:mysql://legestionnaire.druide:3306/filemaker' as
>>> 'filemaker'
>>> INFO [2017-06-09 15:08:32,413] bootique-http-36 o.a.c.d.DriverDataSource:
>>> *** Connecting: FAILURE.
>>>
>>> What’s the trick?
>>
>
--
Best regards,
Nikita Timofeev
