Re: JDBC Statement Timeout

2014-10-13 Thread Emanuele Maiarelli
http://cayenne.195.n3.nabble.com/query-timeout-needed-td1070.html The link explains the solution for cayenne 1.2. You can try with cayenne 3.1 being aware that packages named org.objectstyle.* have been renamed as org.apache.* 2014-10-13 4:50 GMT+02:00 Malcolm Edgar : > Hi All, > > I am havin

Re: [ANN] Cayenne 3.1 final release

2014-09-30 Thread Emanuele Maiarelli
Congratulations to cayenne commiters! DI is very handy when you have to alter ServerRuntime behaviour, we have an application already using 3.1 with DI to implement multitenancy (chaging postgres schema depending on authenticated user). We are also using cayenne DI to manage other dependency inje

Cayenne 3.1 ROP and Multitenancy

2014-06-25 Thread Emanuele Maiarelli
I'm wondering if it is possibile to specify the ServerRuntime to ROPHessianServlet injecting a MapLoader that 'moves' DbEntity on different database schema depending by ClientChannel authenticated user. Any idea? Regards EM

A note on postgres multitenat implementation with 1 schema per tenant

2013-11-10 Thread Emanuele Maiarelli
I was doing some tests on multitenancy implementations using cayenee 3.1 beta 2 and postgres , using 1 schema per tenant. I instancend one ServerRuntime per tennant this way: public static ServerRuntime createServerRuntime(final String tenantSchema) { ServerRuntime runtime = new Serve

Re: Migrating web application from 3.0 to 3.1

2013-11-07 Thread Emanuele Maiarelli
h it > in a static variable or do anything you like. > > > > On Wed, Nov 6, 2013 at 4:47 PM, Emanuele Maiarelli < > maiarelli.emanu...@gmail.com> wrote: > > > We have a web multi tenant application developed with cayenne 3.0. > > > > Tenants are implemente

Migrating web application from 3.0 to 3.1

2013-11-06 Thread Emanuele Maiarelli
We have a web multi tenant application developed with cayenne 3.0. Tenants are implemented in a single database, so there's a 'tenantId' on most of database tables. With cayenne we implemented the tenancy, 'injecting' the property, either on SelectQuery and new entities, using a custom automated

Re: Swing / Data views

2013-05-31 Thread Emanuele Maiarelli
I suggest to use a "fresh" context for every form you gonna instance, that will avoid leaving uncommitted objects around in one single context. You can eventually avoid reflection , since every cayenne objects have static string fields containing method names, that can be readen/written using read

Re: Swing / Data views

2013-05-31 Thread Emanuele Maiarelli
I wrote a mini framework working with netbeans app framework for databinding. Il giorno 31/mag/2013 17:20, "Chris Walters" ha scritto: > I have a need to bind some Cayenne data objects to Swing components in a > Netbeans platform-based app. Google tells me there used to be something > called Dat

Re: Possible bug in cayene 3.0.2 to set relationships???

2012-10-23 Thread Emanuele Maiarelli
Did you specify the primary key generation strategy? As far as i remember i had similar errors on oracle dued to not having specified the sequence name(and cached size) On Tue, 23 Oct 2012 13:57:50 +0200, Felipe Martín Santos wrote: > Sorry but doesn' work :-( > > MY RELATIONSHIPS: > >

Re: A small update

2012-10-05 Thread Emanuele Maiarelli
Now works perfectly even on cayenne 3.0.2 2012/10/5 Andrus Adamchik > Cool. Let us know how that worked. And we are planning on some permanent > changes to solve this problem universally: > > http://cayenne.markmail.org/thread/icr7seqazgsdtewc > > On Oct 5, 2012, at 5:29 PM,

Re: A small update

2012-10-05 Thread Emanuele Maiarelli
tween numeric type and a bigint. Thank you for the hint Andrus, Regards, Emanuele 2012/10/5 Emanuele Maiarelli > indeed i just noticed that tables having this kind of problem have PKs > declared as numeric(38,0), this is something that postgress supports as > oracle like types, but u

Re: A small update

2012-10-05 Thread Emanuele Maiarelli
UMERIC ambiguity issue. > > Andrus > > On Oct 5, 2012, at 5:04 PM, Emanuele Maiarelli < > maiarelli.emanu...@gmail.com> wrote: > > > Problem persists after upgrading to cayenne 3.1B1. > > > > org.apache.cayenne.CayenneRuntimeException: [v.3.1B1

Re: A small update

2012-10-05 Thread Emanuele Maiarelli
. (e.g. Integer vs. BigDecimal or > something). We had those issues before. If you run this in debugger and > poke inside ObjectId for Comuni, you will see whether this is the case. > > Now how to fix it… first thing to try is to upgrade a step further to > Cayenne 3.1B1, as it

Re: Deleting n:m relationships

2012-08-01 Thread Emanuele Maiarelli
forgot to disable html formatting of email client, and it have been formatted badly :) List toDelete=new ArrayList(); toDelete.addAll(_forecastItem.getForecastContendingLineItemArray()); for(ForecastContendingLineItem temp : toDelete) { _forecastItem.removeFromForecastContending

Re: Deleting n:m relationships

2012-08-01 Thread Emanuele Maiarelli
Also try to replace // Delete any condending ads for(ForecastContendingLineItem temp : _forecastItem.getForecastContendingLineItemArray()) { _forecastItem.removeFromForecastContendingLineItemArray(temp); } with List toDelete=new ArrayList(); toDelete.addAll(_forecastItem.getForecastCon

Re: Deleting n:m relationships

2012-08-01 Thread Emanuele Maiarelli
you should create ForecastContendingLineItem from a contex using context.newObject(ForecastContendingLineItem.class); On Wed, 1 Aug 2012 13:08:36 +0200, Tobias Wolff wrote: > Hi again, > > so, I now tried this: > > // Delete any condending ads > for(ForecastContendingLineItem temp : > _

Re: Cayenne 3.0.2 rop and reflection.

2012-06-08 Thread Emanuele Maiarelli
> > hai provato a attivare il log di Cayenne e vedere che query vengono > eseguite ( e se vengo eseguite ) ? > > Marco > > Il 08/06/2012 00:07, Emanuele Maiarelli ha scritto: > >> I'm trying to move an application built around cayenne 2.0.4 to 3.0.2 and im facing an

Cayenne 3.0.2 rop and reflection.

2012-06-07 Thread Emanuele Maiarelli
I'm trying to move an application built around cayenne 2.0.4 to 3.0.2 and im facing an odd problem. I've some objects with 1 to n relation, that calls to a generic method getTo...() via reflection, that returns null, even if the underlaying database holds the correct reference. So i tested

Re: problem with ROP query performance

2011-10-26 Thread Emanuele Maiarelli
What version is affected by this? On Wed, 26 Oct 2011 22:22:36 +0300, Andrus Adamchik wrote: Yeah sounds odd. It fetches paintings of that artist. Maybe we can jira that and take a closer look? On a side note, I noticed that due to the weak references used in the DataContext to store committed o

data synch problem with cayenne 2.0.4.

2010-03-17 Thread Emanuele Maiarelli
I found a data synchronization issue with cayenne 2.0.4 The system consist in many swing applications interfacing with cayenne using ROPs. Plus a series of servelts that exposes data as XML or webservices. I found that an xml servlet was exposing a previous image of data, I verified that da

R: Cayenne and GWT

2010-03-10 Thread Emanuele Maiarelli
e widgets embedded? Why I like GWT is that I don't need to study yet another script language. Hope that appearance of fast, light, powerful and free widget library "for everyone" is only a matter of time.. 2010/3/9 Emanuele Maiarelli > Nice work, i did something like that in the

R: Cayenne and GWT

2010-03-09 Thread Emanuele Maiarelli
Nice work, i did something like that in the past, but i used json serialization, and skipped GTW, cause GTW widgets are very poor, unless you plug Ext GW, but Ext libs are performace killers (I tried em on both IE and Mozilla but they never run smooth as u expect). I'm hoping in javaFX, where port

Re: out of memory using ResultIterator

2009-12-24 Thread Emanuele Maiarelli
pretty involved, however if you are doing a one-off thing, it is doable. Also I would recommend to switch to Cayenne 3.0 at least temporarily to confirm that the fix I described is indeed working for you. There may be some other things at play here. Who knows. Andrus On Dec 24, 2009, at 10:

Re: out of memory using ResultIterator

2009-12-24 Thread Emanuele Maiarelli
in Cayenne 3.0 (which is now in beta): query.setStatementFetchSize(1000); This propagates the fetch size setting to the JDBC statement, reducing the driver memory footprint. Andrus On Dec 24, 2009, at 9:43 AM, Emanuele Maiarelli wrote: im using cayenne 2.0.4, and i need to fetch an huge

out of memory using ResultIterator

2009-12-23 Thread Emanuele Maiarelli
im using cayenne 2.0.4, and i need to fetch an huge ammout of data, i did that way: public static StringBuffer traceProts; static { traceProts = new StringBuffer(); traceProts.append("SELECT "); traceProts.append("PROTOCOLLI.* "); traceProts.append("FROM PROTOCO

Postgress autogenerated keys.

2009-10-28 Thread Emanuele Maiarelli
I'm using cayenne 3 with postgresql 8.2.14, for instance i've a table structured like that CREATE TABLE documenti ( doc_pk bigserial NOT NULL, doc_desc character varying(255), doc_mine character varying(255), doc_prot_fk bigint, doc_self_fk bigint, doc_prot_nr bigint, doc_folder_fk bigint

Re: cayenne tomcat memory management

2009-10-22 Thread Emanuele Maiarelli
Thanks for the advice Andrus Adamchik ha scritto: On Oct 22, 2009, at 3:09 PM, Emanuele Maiarelli wrote: leaks are produced by frequent context reload, issued by netbeans redeploying webapplication in tomcat, but im looking more closely Ok you didn't mention that in the original me

Re: cayenne tomcat memory management

2009-10-22 Thread Emanuele Maiarelli
cache. Are you using it? Anyways, the best option will be to try profiling your application to see what produces leaks. Here's an example of getThreadObjectContext(): http://cayenne.apache.org/doc/web-applications.html Hope that helps, 2009/10/17 Emanuele Maiarelli I'm using cayenn

cayenne tomcat memory management

2009-10-17 Thread Emanuele Maiarelli
I'm using cayenne 3 with tomcat, and im getting context by this way .. DataContext dc= ServletUtil.getSessionContext(sess) ... using httpsessioncontext. To ensure session to be closed i implemented logout from session by calling ... <%session.invalidate();%> ... But after many sessions op

Re: question about 3.0

2009-10-05 Thread Emanuele Maiarelli
n about 30 minutes. Robert On Oct 5, 2009, at 10/512:16 PM , Emanuele Maiarelli wrote: Robert Zeigler ha scritto: it will give to code a bad impact, i mean a application written with 2.0.4 will have to face many methods deprecation or missing? I would give 3.0 a try. I'm using it in several pro

Re: question about 3.0

2009-10-05 Thread Emanuele Maiarelli
Robert Zeigler ha scritto: it will give to code a bad impact, i mean a application written with 2.0.4 will have to face many methods deprecation or missing? I would give 3.0 a try. I'm using it in several production systems with no issues. Robert On Oct 5, 2009, at 10/511:41 AM , Ema

question about 3.0

2009-10-05 Thread Emanuele Maiarelli
I'm using cayenne 2.0.4 with ROP and a swing application, and everything working fine. I built a framework ontop of cayenne libs for managing prefetching and concurrent updates. I read that incoming cayene 3.0 will enanche ROP performances. Do you think i can try cayenne 3.0 or should be bet

Re: Modification and deletion of data objects

2009-07-22 Thread Emanuele Maiarelli
concrete classes for entities. It's been awhile since I looked at them, so I don't know if they're suitable for public consumption. On Wed, Jul 22, 2009 at 2:36 PM, Emanuele Maiarelli wrote: > Hi agree with Mike, unless you have previous designed objects, i'd take > DataObj

Re: Modification and deletion of data objects

2009-07-22 Thread Emanuele Maiarelli
Hi agree with Mike, unless you have previous designed objects, i'd take DataObjects as business objects. If u get previous designed objects u could work on the package 'entities' implementing methods do adapt DataObjects to your needs. IDEs (at least NetBeans) got refactoring services that can

Re: Different DataContext

2009-07-22 Thread Emanuele Maiarelli
and i will look into localObjects solution, this might lead to less concurrency problems... Da: Emanuele Maiarelli A: user@cayenne.apache.org; rein...@gmail.com Inviato: Mercoledì 22 luglio 2009, 15:56:59 Oggetto: Re: Different DataContext You welcome

Re: Different DataContext

2009-07-22 Thread Emanuele Maiarelli
You welcome Reinout, I'm not familiar with Apache Wicket, and honeslty i'd like frameworks will handle all ThreadLocal/contexts issues... and in the case of Wicket im not sure if there's a better way than the one i suggested Da: Reinout van Schouwen

Re: Different DataContext

2009-07-22 Thread Emanuele Maiarelli
the same context between Wicket and your Singleton. I hope this will solve, Da: Reinout van Schouwen A: user@cayenne.apache.org Inviato: Mercoledì 22 luglio 2009, 13:32:29 Oggetto: Re: Different DataContext Hello Emanuele, Thanks for your reply. 2009/7/22 Ema

Re: Different DataContext

2009-07-22 Thread Emanuele Maiarelli
Hi Reinout, i'm not an apache Wicket expert, but the Exception its obiusvly casted by the fact that ur application is casting objects into different DataContexts. What happen if u steps into final Person auxiliary = ObjectFactory.getInstance().createPerson(); auxiliary.set

Re: updating...

2009-07-22 Thread Emanuele Maiarelli
this.datacontext.commitChanges(); is correct I fear u didn't create the object that you are populating, into datacontext. Check ur this.getPerfil(objid), the object that you are updating must be created into context or by a query SelectQuery q=new SelectQuery(this.queryClass); List data = ctx.per

Re: Cayenne 2.0.4 ROP

2009-07-17 Thread Emanuele Maiarelli
a better way to detect relationships than reflection on the method sigs - access Cayenne metadata available from EntityResolver: EntityResolver resolver = context.getEntityResolver(); ObjEntity entity = resolver.lookupObjEntity(queryClass); Andrus On Jul 14, 2009, at 8:41 PM, Emanuele Maiarelli

Re: Cayenne 2.0.4 ROP

2009-07-14 Thread Emanuele Maiarelli
Seems like i solved by problems of relationships update, using this static method public static void setupPrefetch(SelectQuery q, Class queryClass) { Method[] mts=queryClass.getMethods(); for (int i=0;i A: user@cayenne.apache.org Inviato: Martedì 14 luglio 2009, 16:39:10 Ogget

Cayenne 2.0.4 ROP

2009-07-14 Thread Emanuele Maiarelli
Hello, I'm working on an java swing application, using ROP (configuration is: Tomcat 6, Cayenne 2.0.4 with mysql). Since now everything worked perfectly, the swing application ( and all javabeans, that i created) works as expected. When i started plugging more that one client to the