Re: Issues with H2
Re: Issues with H2
- Subject: Re: Issues with H2
- From: Lachlan Deck <email@hidden>
- Date: Wed, 21 Apr 2010 11:16:42 +1000
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
> email@hidden
>
> WOWODC 2010 : August 27th-29th, Montreal. wowodc.com
>
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
with regards,
--
Lachlan Deck
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden