Re: ERMovies example with other database

[Paul Hoadley]

Hi André,

On 25 Sep 2017, at 5:28 am, André Rothe  wrote:

> Are there any properties I can set in the Properties file? There is a 
> webobjectsexamples.ERMoviesLogic.useEmbeddedH2Database=true within the 
> properties file of ERMovies, which I set to false. But is it better to 
> declare the credentials within that property file instead direct within the 
> model? How are the names of the database source properties there?

I haven’t looked at that particular example app in some time, but yes there are 
properties you can use to set up the database connection dictionary, and you 
shouldn’t need to touch the model. Look at the “Global Connection Properties” 
at the bottom of this page:

https://wiki.wocommunity.org/display/documentation/Best+Practices-Properties+Files
 



-- 
Paul Hoadley
https://logicsquad.net/
https://www.linkedin.com/company/logic-squad/




 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: ERMovies example with other database

[Paul Yu]

You can set the database properties in the Properties file.

All of the connection dictionary parameters has a Properties equivalent.

Are you new to WebObjects?

Paul

Sent from my iPhone
Please excuse iOS autocomplete 

> On Sep 24, 2017, at 4:21 PM, Theodore Petrosky  wrote:
> 
> 
> 
> I am confused. I don’t know what you are trying to accomplish. 
> 
> You want an app that does what?
> 
> 
> 
>> On Sep 24, 2017, at 3:58 PM, André Rothe  wrote:
>> 
>> Hm, this podcast doesn't show a solution for my problem. I have setup a 
>> Derby database, which is empty. Now I think, I have to create a new Database 
>> Config on the Movies EOModel within the Entity Modeler? But I don't know, 
>> which properties I have to set.
>> 
>> As prototype I have used EOJDBCDerbyPrototypes, Adaptor JDBC. The URL I have 
>> set (should I delete the parameter create=true? - but I need the create 
>> table script...). Username and password are also okay, as driver I have used 
>> org.apache.derby.jdb.ClientDriver, but the plugin name? There is a framework 
>> called DerbyPlugin, but should I set a specific class name from the 
>> framework?
>> 
>> Are there any properties I can set in the Properties file? There is a 
>> webobjectsexamples.ERMoviesLogic.useEmbeddedH2Database=true within the 
>> properties file of ERMovies, which I set to false. But is it better to 
>> declare the credentials within that property file instead direct within the 
>> model? How are the names of the database source properties there?
>> 
>> Thanks a lot
>> Andre
>> 
>> 
>> Am 2017-09-24 01:16, schrieb Theodore Petrosky:
>>> did you watch David Holt’s ERAttachmet tutorial in the podcasts?
>>> storageType the type of attachment to create, i.e. "s3", "db", or
>>> "file" -- defaults to "db" (or the value of er.attachment.storageType)
 On Sep 23, 2017, at 3:44 PM, André Rothe  wrote:
 Hi,
 The ERMovies example uses per default an H2 database. Which steps are 
 necessary to switch to another database like Derby or MySQL? There are 
 already SQL scripts within the ERMoviesLogic framework, but I don't 
 understand where I have to set the credentials vor the new database.
 Thank you
 Andre
 ___
 Do not post admin requests to the list. They will be ignored.
 Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
 Help/Unsubscribe/Update your Subscription:
 https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com
 This email sent to tedp...@yahoo.com
>>> .
> 
> 
> .
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com
> 
> This email sent to p...@mac.com
 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: ERMovies example with other database

[André Rothe]

Hm, this podcast doesn't show a solution for my problem. I have setup a 
Derby database, which is empty. Now I think, I have to create a new 
Database Config on the Movies EOModel within the Entity Modeler? But I 
don't know, which properties I have to set.


As prototype I have used EOJDBCDerbyPrototypes, Adaptor JDBC. The URL I 
have set (should I delete the parameter create=true? - but I need the 
create table script...). Username and password are also okay, as driver 
I have used org.apache.derby.jdb.ClientDriver, but the plugin name? 
There is a framework called DerbyPlugin, but should I set a specific 
class name from the framework?


Are there any properties I can set in the Properties file? There is a 
webobjectsexamples.ERMoviesLogic.useEmbeddedH2Database=true within the 
properties file of ERMovies, which I set to false. But is it better to 
declare the credentials within that property file instead direct within 
the model? How are the names of the database source properties there?


Thanks a lot
Andre


Am 2017-09-24 01:16, schrieb Theodore Petrosky:

did you watch David Holt’s ERAttachmet tutorial in the podcasts?

storageType the type of attachment to create, i.e. "s3", "db", or
"file" -- defaults to "db" (or the value of er.attachment.storageType)




On Sep 23, 2017, at 3:44 PM, André Rothe  
wrote:


Hi,

The ERMovies example uses per default an H2 database. Which steps are 
necessary to switch to another database like Derby or MySQL? There are 
already SQL scripts within the ERMoviesLogic framework, but I don't 
understand where I have to set the credentials vor the new database.


Thank you
Andre
___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com

This email sent to tedp...@yahoo.com



.

___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: ERMovies example with other database

[Theodore Petrosky]

did you watch David Holt’s ERAttachmet tutorial in the podcasts?

storageType the type of attachment to create, i.e. "s3", "db", or "file" -- 
defaults to "db" (or the value of er.attachment.storageType)




> On Sep 23, 2017, at 3:44 PM, André Rothe  wrote:
> 
> Hi,
> 
> The ERMovies example uses per default an H2 database. Which steps are 
> necessary to switch to another database like Derby or MySQL? There are 
> already SQL scripts within the ERMoviesLogic framework, but I don't 
> understand where I have to set the credentials vor the new database.
> 
> Thank you
> Andre
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com
> 
> This email sent to tedp...@yahoo.com


.
 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

ERMovies example with other database

[André Rothe]

Hi,

The ERMovies example uses per default an H2 database. Which steps are 
necessary to switch to another database like Derby or MySQL? There are 
already SQL scripts within the ERMoviesLogic framework, but I don't 
understand where I have to set the credentials vor the new database.


Thank you
Andre
___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com