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
