Re: Issues with H2
Re: Issues with H2
- Subject: Re: Issues with H2
- From: Pascal Robert <email@hidden>
- Date: Thu, 22 Apr 2010 13:00:27 -0400
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
>>> 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
>
>
>
--
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