Very new at Cayenne. Trying to extract the DBEntities and OBJEntities
from a PG database as shown in the tutorial. All tables in the selected
schema are extracted but the resultant DB and OBJ entities don't match
each other WRT the number of attributes. I'm still looking for a pattern
but it se
> all of the "special" PG data types like CITEXT are listed as "Other". I
> assume I should select something other than that, right?
Yeah.. And I guess we may need to add CITEXT to Cayenne PG adapter so that it
is reverse engineered as VARCHAR or CLOB or something.
On Oct 30, 2012, at 8:06 PM,
Using 3.1B1. But your second question made me look in Modeler and all of
the "special" PG data types like CITEXT are listed as "Other". I assume
I should select something other than that, right? I'll give it a try and
see what happens.
Thanx...
On 10/30/2012 11:42 AM, Andrus Adamchik wrote:
So what version of Cayenne are you using (I'd recommend 3.1B1)?
Also what type do you select for CTEXT columns in Cayenne model? Should be
something like VARCHAR?
Andrus
On Oct 30, 2012, at 7:06 PM, Garth Keesler wrote:
>
> Thanx for the reply. The problem I seem to be having is that the
>
Thanx for the reply. The problem I seem to be having is that the
schema-generated persistent classes have errors whenever one of the
CITEXT attributes is mentioned. Following is a sample of the code which
is causing errors.
public void setInvoicenbr($importUtils.formatJavaType(${attr.Type})
I don't have much recent firsthand PG experience, but reading citext docs, it
looks like exactly what you need.
So when comparisons are done in SQL it should work (at least it works for me on
MySQL with similar DB-side settings). On the other hand if you are using
in-memory filtering with expr
> -- why don't we provide a way to restrict the columns while fetching the data?
> Ex: object having set of columns from which want fetch the data for only few
> columns...using the object entity.
ORM (Cayenne including) is based on the idea of object identity. In other words
each persistent Ja
I'm converting an MS Access ADP project to Java/Postgresql/Cayenne (my
first and mostly for the fun of it) and am trying to figure out how to
best match the case insensitive string usage that is in SQL Server. I
created the PG database using CITEXT only where actually necessary but
it doesn't s
Thanks for the solution.
But I don't want to write the sql query in the java code.
Is there any way to achieve this?
-- why don't we provide a way to restrict the columns while fetching the data?
Ex: object having set of columns from which want fetch the data for only few
columns...using the obj
// Extract is the obj-entity you have for the T_QC_EXTRACT db-entity
SQLTemplate query = new SQLTemplate(Extract.class, "SELECT DISTINCT
STORY_ID FROM T_QC_EXTRACT WHERE EXECUTION_STATUS IN ('PASSED','BLOCKED')");
SQLResult resultDescriptor = new SQLResult();
resultDescriptor.addColumnResult("STOR
Hi,
I have a table T_QC_EXTRACT with many columns, few of them are STORY_ID,
EXECUTION_STATUS.
I want to fetch the distinct STORY_ID based on EXECUTION_STATUS IN
('PASSED','BLOCKED');
SELECT DISTINCT STORY_ID FROM T_QC_EXTRACT WHERE EXECUTION_STATUS IN
('PASSED','BLOCKED');
Please suggest a
11 matches
Mail list logo
