Re: Issues with H2

2010-04-22 Thread Pascal Robert 
No luck with Movies.URL or the in-mem db, I still have that one connection that 
switch to the different URL. I did a grep on all index.eomodeld and Properties 
files in the workspace and I didn't have any where the URL is set to the build 
frameworks :-/  I also tried to set the URL to a different path, no luck.

 Hi Pascal,
 
 I seem to recall Ravi adjusting some properties recently in Wonder also - so 
 you might want to try setting Movies.URL=jdbc...etc in case this is 
 overriding your settings. The global setting should have won though.
 
 On 21/04/2010, at 11:16 AM, Lachlan Deck wrote:
 
 On 20/04/2010, at 7:58 PM, Pascal Robert wrote:
 
 Ok, it look like my issues with migrations for ERMoviesLogic are because of 
 JDBC URL switching!  When the ERAttachment, ERAttachmentData and ERTag 
 tables are created, my connection dictionary is :
 
 avr. 20 05:47:23 Movies[62935] DEBUG NSLog  -  connecting with dictionary: 
 {plugin = H2PlugIn; username = ; driver = org.h2.Driver; password = 
 password deleted for log; URL = jdbc:h2:/Resources/Movies; }
 
 But when it creates the MovieTag table, it's switching to another URL!
 
 avr. 20 05:47:24 Movies[62935] DEBUG NSLog  -  connecting with dictionary: 
 {plugin = H2PlugIn; username = ; driver = org.h2.Driver; LC_ALL = 
 iso_1; password = password deleted for log; databaseEncoding = ISO 
 Latin-1; URL = 
 jdbc:h2:file:/Users/probert/Tools/Src/Wonder/Wonder/Frameworks/BusinessLogic/ERMoviesLogic/build/ERMoviesLogic.framework/Resources/Movies;
  }
 
 That is weird, and I'm using global properties :
 
 dbConnectUserGLOBAL=
 dbConnectPasswordGLOBAL=
 dbConnectDriverGLOBAL=org.h2.Driver
 dbConnectPluginGLOBAL=H2PlugIn
 dbConnectURLGLOBAL=jdbc:h2:/Resources/Movies
 
 Haven't tried with those models but you should only need:
 dbConnectUserGLOBAL=
 dbConnectPasswordGLOBAL=
 dbConnectURLGLOBAL=jdbc:h2:/Resources/Movies
 
 # handled by h2 plugin
 ##dbConnectDriverGLOBAL=org.h2.Driver
 ##dbConnectPluginGLOBAL=H2PlugIn
 
 You can try just using in-mem db also just to make sure you've got no errors.
 dbConnectURLGLOBAL=jdbc:h2:mem:Movies
 
 
 And I don't have this problem with MySQL, which make it even worse. In 
 fact, in MySQL no MovieTag is created at all. Anyone here tried to add 
 ERTaggable stuff in a H2 db?
 
 --
 
 Pascal Robert
 prob...@macti.ca
 
 WOWODC 2010 : August 27th-29th, Montreal. wowodc.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:
 http://lists.apple.com/mailman/options/webobjects-dev/lachlan.deck%40gmail.com
 
 This email sent to lachlan.d...@gmail.com
 
 with regards,
 --
 
 Lachlan Deck
 
 
 
 
 with regards,
 --
 
 Lachlan Deck
 
 
 

--

Pascal Robert
prob...@macti.ca

WOWODC 2010 : August 27th-29th, Montreal. wowodc.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:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

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

Issues with H2

2010-04-20 Thread Pascal Robert 
Ok, it look like my issues with migrations for ERMoviesLogic are because of 
JDBC URL switching!  When the ERAttachment, ERAttachmentData and ERTag tables 
are created, my connection dictionary is :

avr. 20 05:47:23 Movies[62935] DEBUG NSLog  -  connecting with dictionary: 
{plugin = H2PlugIn; username = ; driver = org.h2.Driver; password = 
password deleted for log; URL = jdbc:h2:/Resources/Movies; }

But when it creates the MovieTag table, it's switching to another URL!

avr. 20 05:47:24 Movies[62935] DEBUG NSLog  -  connecting with dictionary: 
{plugin = H2PlugIn; username = ; driver = org.h2.Driver; LC_ALL = 
iso_1; password = password deleted for log; databaseEncoding = ISO 
Latin-1; URL = 
jdbc:h2:file:/Users/probert/Tools/Src/Wonder/Wonder/Frameworks/BusinessLogic/ERMoviesLogic/build/ERMoviesLogic.framework/Resources/Movies;
 }

That is weird, and I'm using global properties :

dbConnectUserGLOBAL=
dbConnectPasswordGLOBAL=
dbConnectDriverGLOBAL=org.h2.Driver
dbConnectPluginGLOBAL=H2PlugIn
dbConnectURLGLOBAL=jdbc:h2:/Resources/Movies

And I don't have this problem with MySQL, which make it even worse. In fact, in 
MySQL no MovieTag is created at all. Anyone here tried to add ERTaggable stuff 
in a H2 db?

--

Pascal Robert
prob...@macti.ca

WOWODC 2010 : August 27th-29th, Montreal. wowodc.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:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

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

Re: Issues with H2

2010-04-20 Thread Lachlan Deck 
On 20/04/2010, at 7:58 PM, Pascal Robert wrote:

 Ok, it look like my issues with migrations for ERMoviesLogic are because of 
 JDBC URL switching!  When the ERAttachment, ERAttachmentData and ERTag tables 
 are created, my connection dictionary is :
 
 avr. 20 05:47:23 Movies[62935] DEBUG NSLog  -  connecting with dictionary: 
 {plugin = H2PlugIn; username = ; driver = org.h2.Driver; password = 
 password deleted for log; URL = jdbc:h2:/Resources/Movies; }
 
 But when it creates the MovieTag table, it's switching to another URL!
 
 avr. 20 05:47:24 Movies[62935] DEBUG NSLog  -  connecting with dictionary: 
 {plugin = H2PlugIn; username = ; driver = org.h2.Driver; LC_ALL = 
 iso_1; password = password deleted for log; databaseEncoding = ISO 
 Latin-1; URL = 
 jdbc:h2:file:/Users/probert/Tools/Src/Wonder/Wonder/Frameworks/BusinessLogic/ERMoviesLogic/build/ERMoviesLogic.framework/Resources/Movies;
  }
 
 That is weird, and I'm using global properties :
 
 dbConnectUserGLOBAL=
 dbConnectPasswordGLOBAL=
 dbConnectDriverGLOBAL=org.h2.Driver
 dbConnectPluginGLOBAL=H2PlugIn
 dbConnectURLGLOBAL=jdbc:h2:/Resources/Movies

Haven't tried with those models but you should only need:
dbConnectUserGLOBAL=
dbConnectPasswordGLOBAL=
dbConnectURLGLOBAL=jdbc:h2:/Resources/Movies

# handled by h2 plugin
##dbConnectDriverGLOBAL=org.h2.Driver
##dbConnectPluginGLOBAL=H2PlugIn

You can try just using in-mem db also just to make sure you've got no errors.
dbConnectURLGLOBAL=jdbc:h2:mem:Movies

 
 And I don't have this problem with MySQL, which make it even worse. In fact, 
 in MySQL no MovieTag is created at all. Anyone here tried to add ERTaggable 
 stuff in a H2 db?
 
 --
 
 Pascal Robert
 prob...@macti.ca
 
 WOWODC 2010 : August 27th-29th, Montreal. wowodc.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:
 http://lists.apple.com/mailman/options/webobjects-dev/lachlan.deck%40gmail.com
 
 This email sent to lachlan.d...@gmail.com

with regards,
--

Lachlan Deck



 ___
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:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

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

Re: Issues with H2

2010-04-20 Thread Lachlan Deck 
Hi Pascal,

I seem to recall Ravi adjusting some properties recently in Wonder also - so 
you might want to try setting Movies.URL=jdbc...etc in case this is overriding 
your settings. The global setting should have won though.

On 21/04/2010, at 11:16 AM, Lachlan Deck wrote:

 On 20/04/2010, at 7:58 PM, Pascal Robert wrote:
 
 Ok, it look like my issues with migrations for ERMoviesLogic are because of 
 JDBC URL switching!  When the ERAttachment, ERAttachmentData and ERTag 
 tables are created, my connection dictionary is :
 
 avr. 20 05:47:23 Movies[62935] DEBUG NSLog  -  connecting with dictionary: 
 {plugin = H2PlugIn; username = ; driver = org.h2.Driver; password = 
 password deleted for log; URL = jdbc:h2:/Resources/Movies; }
 
 But when it creates the MovieTag table, it's switching to another URL!
 
 avr. 20 05:47:24 Movies[62935] DEBUG NSLog  -  connecting with dictionary: 
 {plugin = H2PlugIn; username = ; driver = org.h2.Driver; LC_ALL = 
 iso_1; password = password deleted for log; databaseEncoding = ISO 
 Latin-1; URL = 
 jdbc:h2:file:/Users/probert/Tools/Src/Wonder/Wonder/Frameworks/BusinessLogic/ERMoviesLogic/build/ERMoviesLogic.framework/Resources/Movies;
  }
 
 That is weird, and I'm using global properties :
 
 dbConnectUserGLOBAL=
 dbConnectPasswordGLOBAL=
 dbConnectDriverGLOBAL=org.h2.Driver
 dbConnectPluginGLOBAL=H2PlugIn
 dbConnectURLGLOBAL=jdbc:h2:/Resources/Movies
 
 Haven't tried with those models but you should only need:
 dbConnectUserGLOBAL=
 dbConnectPasswordGLOBAL=
 dbConnectURLGLOBAL=jdbc:h2:/Resources/Movies
 
 # handled by h2 plugin
 ##dbConnectDriverGLOBAL=org.h2.Driver
 ##dbConnectPluginGLOBAL=H2PlugIn
 
 You can try just using in-mem db also just to make sure you've got no errors.
 dbConnectURLGLOBAL=jdbc:h2:mem:Movies
 
 
 And I don't have this problem with MySQL, which make it even worse. In fact, 
 in MySQL no MovieTag is created at all. Anyone here tried to add ERTaggable 
 stuff in a H2 db?
 
 --
 
 Pascal Robert
 prob...@macti.ca
 
 WOWODC 2010 : August 27th-29th, Montreal. wowodc.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:
 http://lists.apple.com/mailman/options/webobjects-dev/lachlan.deck%40gmail.com
 
 This email sent to lachlan.d...@gmail.com
 
 with regards,
 --
 
 Lachlan Deck
 
 
 

with regards,
--

Lachlan Deck



 ___
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:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

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