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

Reply via email to