Re: Issues with H2
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 =
>>> ""; 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 = ""; 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
>>
>>
>>
>
> with regards,
> --
>
> Lachlan Deck
>
>
>
--
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/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
Re: Issues with H2
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 =
>> ""; 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 = ""; 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
>
>
>
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
Re: Issues with H2
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 =
> ""; 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 = ""; 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
Issues with H2
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 =
""; 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 = ""; 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
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/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
