Re: Issues with H2
Re: Issues with H2
- Subject: Re: Issues with H2
- From: Lachlan Deck <email@hidden>
- Date: Wed, 21 Apr 2010 13:01:32 +1000
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
>> 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
>
>
>
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