Re: Ponder: Error on login attempt

On Dec 7, 2012, at 10:34 AM, James Cicenia wrote:

> Well... adding that got what you feared:
> 
> com.webobjects.eoaccess.EOGeneralAdaptorException: Circular relationships found for ("ERAttachment", "ERAttachmentData", "ERCloudFilesAttachment", "ERDatabaseAttachment", "ERFileAttachment", "ERS3Attachment", "AccountHistory", "AccountType", "Company", "CurrentAccount", "Person")
> 
> So are you saying that the "P" in Ponder stands for postgres ?


None of those EOs are from ponder :-)

I generally develop with H2, which also can't do FK constraints, just so I remain database agnostic.  For the record, I dislike MySQL because:

* No deferred FK constraints.
* Not UTF8 by default
* Case insensitive queries by default
* Poorly supported admin tools on mac. I would call it active hostility. (http://bugs.mysql.com/bug.php?id=47070)

That doesn't mean I've ruled out ever using it again. I just prefer to stay away from it. Those first three reasons can create significant headaches that are really hard to work around.  The tool support issue is just icing on the cake.


> Kind of a big deal to switch databases as I have zero postgres experiences.


The postgres "gotchas" that I know of are: 

1) they changed their bytea output at version 9. You need to make sure to set that correctly before you can use blob columns. (http://wiki.wocommunity.org/display/documentation/PostgresqlPlugin+Framework)

2) there's something wonky with the intBoolean prototype in ERPrototypes. I forget the exact problem. Nobody fixes it because it might break things for people using an older version of PG. Use flag (my preference) or boolean instead.

3) You need to set your time zone before the postgresql jdbc driver loads. See the link above for more info. (I already do this in my R2D2W application template. You might have noticed it.)

4) You have to build PG from source to enable SSL. There could be a good reason for that, but this is a nuisance when you need SSL.

That said, I can understand wanting to use MySQL if you plan to deploy on Amazon, since they have a database service based on it.  I keep hoping one day they'll add Postgresql so it's not such a DIY thing.

Ramsey

> 
> James
> 
> 
> On Dec 7, 2012, at 11:18 AM, Ramsey Gurley <[email protected]> wrote:
> 
>> com.webobjects.eoaccess.ERXEntityDependencyOrderingDelegate.active=true
>

------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d

_______________________________________________
Wonder-disc mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wonder-disc