PK and FK columns are intentionally not mapped as ObjAttributes. An FK is
redundant (you already have a mapped relationship for that), and PK is presumed
to be of no consequence in the object model, so it is hidden inside ObjectId of
each persistent object. For meaningful PKs, you can create Obj
Cayenne DbAttribute types are all taken from JDBC spec. Nominally PG 'text'
maps to JDBC 'CLOB', and 'varchar(n)' to VARCHAR. However PG promises no
performance differences between 'text' and 'varchar(n)'. So certainly you can
map 'text' as either.
On the other hand, (and this was on MySQL, not
I am with the guy who says "Secondly, I'm not 100% sure that this is a good
idea." :)
On Oct 31, 2012, at 3:09 PM, Michael Gentry wrote:
> This cropped up on the Tapestry list earlier about injecting Tapestry
> symbols into new Cayenne objects:
>
> http://markmail.org/thread/xvb56u5nsxazeyc7
>
I'm converting from MS SQL Server to PostgreSQL, switching from VARCHAR
in SQL Server to TEXT (or CITEXT depending) in PG. I'm converting the
software from MS AccessVB to Java/Cayenne and am wondering if there is a
preference for CLOB over VARCHAR(n) when hand generating the DBEntity
attributes
This cropped up on the Tapestry list earlier about injecting Tapestry
symbols into new Cayenne objects:
http://markmail.org/thread/xvb56u5nsxazeyc7
Thought I'd cross post it here for Bjello in case anyone has better
ideas than what was suggested.
Thanks,
mrg
Hi,
yeah, I need to find some spare time to review it.
Andrus
On Oct 31, 2012, at 12:59 PM, Felipe Martín Santos wrote:
> Good Morning Andrus!!
>
> I've reopened the thread
> https://issues.apache.org/jira/browse/CAY-1751because now the problem
> is when I try to get one record (inserted
> pr
Good Morning Andrus!!
I've reopened the thread
https://issues.apache.org/jira/browse/CAY-1751because now the problem
is when I try to get one record (inserted
previously)... I test and is in
database.
Perhaps this is a foreign key (unique) bug??
Thank you for your answer.
Best Regards!!
201
