> I was hoping to have a solution that would work on both Bootique and > non-Bootique apps :-)
In which case you need the least common denominator for DS configuration, which is Cayenne. So do the opposite of what was initially suggested - keep the DataNode in Cayenne project and remove if from config.yml. Then your Cayenne configuration will be used and properties will be respected. Andrus > On Jun 12, 2017, at 6:40 PM, Pascal Robert <[email protected]> wrote: > > >> Le 12 juin 2017 à 11:36, Andrus Adamchik <[email protected]> a écrit : >> >> Hi Pascal, >> >> Your example is a Bootique app. So it will have its connection info in >> config.yml, and you don't need the properties. If you use your model in >> another app that is not a Bootuque app, then the -D properties will work. >> >> Or did I misunderstand your use case? > > I was hoping to have a solution that would work on both Bootique and > non-Bootique apps :-) > >> >> Andrus >> >> >>> On Jun 12, 2017, at 5:31 PM, Pascal Robert <[email protected]> wrote: >>> >>> Tried that, no luck (at least with the Bootique app): >>> >>> java >>> -Dcayenne.jdbc.url="jdbc:mysql://xx.xx.xx.xx:3306/filemaker?connectTimeout=0&autoReconnect=true" >>> -jar RevendeursWeb-1.0.jar --config=config.yml —server >>> >>> Still connect to the URL defined in the model. >>> >>>> Le 12 juin 2017 à 09:32, Nikita Timofeev <[email protected]> a >>>> écrit : >>>> >>>> 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 >>> >> >
