Cayenne > user > May 2011

Help! I am at a loss to figure out how to get past this one. The same code works perfectly fine when I test it against a MySQL database. I tried using the line containing the DB2Adapter statement but ...

Hi, I need to create a query to select certain objects with a condition like so: SELECT*FROM tableWHERE(col/16)=10; Column 'col' is defined as integer but the expression (col / 16) yields a floating ...

Hi, I am using a simple SQLTemplate select query but it fails because of special charachters : SELECT * FROM SDEPTHR INNER JOIN THRESH ON SDEPTHR.DEPTHRID=THRESH.THRESHID WHERE SDEPTHR.JOBNAME = ...

Hi, I'm using stable cayenne 3.0.1. Following the tutorial in vertical inheritance i've been unable to make vertical inheritance work. I've modified the tutorial app adding a Programmar as Child of ...

Hi all, I am referring to FAQ "Setting Database Connection" here: https://cwiki.apache.org/CAY/setting-database-connection.html Firstly, in 3.1 the SharedConfiguration no longer exists, so we have to ...

Currently I'm using CreateIfNoSchemaStrategy and it seems to work quite well for the database platforms I'm targeting. My question is, is there any way or examples somewhere to update the schema if ...

I have an object called event that contains eventMenu as an array of objects. event is a table in my database and eventMenu is a table. Each of the objects are working fine for inserts and ...

Hi In my application I start embedded derby and jetty http server (as a servlet container). Then the cayenne runtime is initiated (for both 1tier and ROP). When the application shuts down I reverse ...

Hey all, how do I do create "group by" or "sum" queries with Cayenne? Is an IndirectQuery/SQLTemplate the best way to do it? Cheers Christian

I have placed the cayenne.xml file in WEB-INF directory, also in classes directory under WEB-INF and even added a parameter to my web.xml file to : <filter <filter-name CayenneFilter</filter-name ...

I hope you don't mind me posting this here as hopefully this helps somebody else trying to deploy a web app under tomcat 6.0.32 using DB2 Version 7. (I know it's old but I had no choice) I was ...

I am trying to find an example of using an order by on a cayenne query. I was hoping to have it sort the information using the database versus locally which cayenne seems to support either. My ...

Hey guys-- In a clustered cayenne environment (I'm using the JMS event bridge), do all nodes receive all cayenne events (talking preInsert, postUpdate, etc etc). Only some of them? None of them? I ...

At work, I'm starting a new application with cayenne 3.0.1. We're using Ingres which has a read lock for tables during select queries. To make matters more complicated, I need to do inserts to a ...

I've got a Cayenne 1.1 application that has been running fine for years. Today we hit a strange error, a Numeric Overflow on a relationship list fetch. I've looked through the tables involved ...

I thought I understood what was going on with Cayenne but alas it seems to be a misconception on my part! I have a web application I am building. The database code had methods to insert, update, and ...

Hi, sometimes Cayenne generates SQL like: ... FROM schema.table WHERE... and sometimes it generates: ... FROM table WHERE... I would like to make sure its only using the second one. How can I achieve ...

Hi, I would like to ask you guys where do you see 3.1 now? M2 is 2 months out and I would like to ask where do you see the first RC (months/year)? I couldn't find a roadmap and I'm working on a ...

Hey all, i have NULL in the database (MySQL). If I select it, it will return endTime=Thu Jan 01 00:00:00 CET 1970 This is taken from the values map in the CayenneDataObject M2 Line 193 - 195. public ...

Hello. We are using 3.1M2 in jetty 7.3.0. For production I want to turn off the logging done by CommonsJdbcEventLogger. I got this to work with earlier versions of cayenne and a different servlet ...

I am trying to execute a where clause that includes calling a database function, in this case SHA2 for mysql. My code looks like the following: HashMap<String,String parameters = new ...

Hello all, I have a table with 3 foreign keys that are also the composite primary key. On cayenne modeler the primary key generation is Default but even so during the commit phase Cayenne tries to ...

Hello Cayenne support Here is my code where I am trying to update a table by using EJB Query language. The parameter I pass for the subquery is an object. EJBQLQuery updateQueryDoc = new EJBQLQuery( ...

Hi, We have created a new template pojo.vm in order to generate the pojos automatically, using the cayenne cgen goal of the cayenne maven plugin. It is more or less working but we developed it on our ...