Re: Memory Usage Problem with Tomcat

2012-03-15 Thread Andrus Adamchik
On Mar 15, 2012, at 3:21 PM, Joe Baldwin wrote: > 1. what is nominal behavior for Cayenne 3.0.1 - wrt the EventManager Dispatch > Thread? Should there be 5 of them normally or should there only be one. 5 dispatch threads is the default. So this is correct and means that you only have 1 Cayenn

Re: Memory Usage Problem with Tomcat

2012-03-15 Thread Joe Baldwin
Andrus, Thomas spoke of some fixes for the classloader (among a great many other issues) in Tomcat 7, so I installed it (which is not nearly as straighforward as Tomcat 6 BTW), and guess what ... it only has the 5 instances of the EventManger. So here is my question list: 1. what is nominal be

Re: Howto Include Time/Date Functions in Query Expressions

2012-03-15 Thread Michael Gentry
If the view is backing to 50m records, then it would still have to do a full table scan without indexes. On Thu, Mar 15, 2012 at 12:42 PM, Mike Kienenberger wrote: > In this particular case, since the view is just doing data conversion, > I don't think you'd even need indexes, would you? > > On T

Re: Howto Include Time/Date Functions in Query Expressions

2012-03-15 Thread Mike Kienenberger
In this particular case, since the view is just doing data conversion, I don't think you'd even need indexes, would you? On Thu, Mar 15, 2012 at 12:35 PM, Michael Gentry wrote: > Hi Emerson, > > I'm pretty sure a view will make no difference.  The best way to > improve performance is to have prop

Re: Howto Include Time/Date Functions in Query Expressions

2012-03-15 Thread Michael Gentry
Hi Emerson, I'm pretty sure a view will make no difference. The best way to improve performance is to have proper indexes (which a view could also utilize). We have a similar-sized database and query times went from over 1 minute to a few milliseconds once we added an appropriate index. mrg O

Re: Myslq-Adapter

2012-03-15 Thread Sheldon
Thank you Andrus, I don't found this instruction. Sheldon -- View this message in context: http://cayenne.195.n3.nabble.com/Myslq-Adapter-tp3828735p3829244.html Sent from the Cayenne - User mailing list archive at Nabble.com.

Re: Myslq-Adapter

2012-03-15 Thread Andrus Adamchik
Try this Cayenne Guide: http://people.apache.org/~aadamchik/misc/cayenne-guide-03152012.pdf It has a lot of blanks, but the DI related stiff is described in some detail. (Note that all the property names there correspond to the trunk build, and will not work with M3, but the general advice is f

Re: Howto Include Time/Date Functions in Query Expressions

2012-03-15 Thread Mike Kienenberger
I am not an expert in this area. I suspect it depends on your database and environment. My guess is that a view that only added those three columns would have very little impact on performance. The primary difference is that you've moved the conversion of those items from the application to the

Re: Howto Include Time/Date Functions in Query Expressions

2012-03-15 Thread Emerson Castañeda
Hi Mike My context: I am handling a table with 50 millions of rows and its size is increasing up every day some thousands. So, my question goes around performance of the view's solution that you propose. Do you think view performance will be better than using SQLTemplate queries? Thanks EMERS

Re: Myslq-Adapter

2012-03-15 Thread Sheldon
Sorry Andrus, but I don't really understand DI and I don't found good explanations of it. Can you give me some advice or good links? thanks Sheldon -- View this message in context: http://cayenne.195.n3.nabble.com/Myslq-Adapter-tp3828735p3829085.html Sent from the Cayenne - User mailing list arc

Re: Howto Include Time/Date Functions in Query Expressions

2012-03-15 Thread Emerson Castañeda
Hi, Thank you so much Andrus I have implemented a solution using SQLTemplate, I think as you said, It's the best bet. A great solution, even better once I have been discovering stuff as: the #bind and #result directives, and the possibility of DataRow treatment in order to build structure flexib

Re: Myslq-Adapter

2012-03-15 Thread Andrus Adamchik
It is provided by Cayenne via injection. You can inject it in your provider. Check org.apache.cayenne.configuration.server.DataDomainProvider, it has this line: @Inject protected JdbcEventLogger jdbcEventLogger; Andrus On Mar 15, 2012, at 10:43 AM, Sheldon wrote: > You are right Andrus

Re: Myslq-Adapter

2012-03-15 Thread Sheldon
You are right Andrus, the JdbcEventLogger of the adapter is null. How can I initialize the Logger? Sheldon -- View this message in context: http://cayenne.195.n3.nabble.com/Myslq-Adapter-tp3828735p3828969.html Sent from the Cayenne - User mailing list archive at Nabble.com.

Re: Myslq-Adapter

2012-03-15 Thread Andrus Adamchik
Sheldon is building Cayenne config in the code, bypassing XML model. On Mar 15, 2012, at 10:25 AM, Wernke zur Borg wrote: > > Hi, > > after a lot of trouble like yours I found that the easiest way is to set > the DbAdapter class in the modeler. There is an extra tab "Adapter" on > the DataN

Re: Myslq-Adapter

2012-03-15 Thread Wernke zur Borg
Hi, after a lot of trouble like yours I found that the easiest way is to set the DbAdapter class in the modeler. There is an extra tab "Adapter" on the DataNode configuration. You don't need to do anything in your source code (except defining your Adapter class). Wernke On 2012-03-15 14:19,

Re: Howto Include Time/Date Functions in Query Expressions

2012-03-15 Thread Mike Kienenberger
Depending on your database and usage, another option is to set up a view and let the database create derived columns for these, then you can treat them as regular Cayenne data object fields. 2012/3/14 Emerson Castañeda : > HI everyone > > I have a table with a timestamp field, so  I'm thinking abo

Re: Myslq-Adapter

2012-03-15 Thread Andrus Adamchik
NPE is for JdbcEventLogger in the DataNode, not related to adapter. check DataDomainProvider.createAndInitDataDomain for how the DataNode is created. Specifically JdbcEventLogger is set explicitly: dataNode.setJdbcEventLogger(jdbcEventLogger); Andrus On Mar 15, 2012, at 9:19 AM, Sheldon wrote:

Myslq-Adapter

2012-03-15 Thread Sheldon
Hello, how can I create a custom Mysql adapter? I use cayenne 3.1M3. I've tried: 1) DataNode node = new DataNode(...); dataNode.setAdapter(new MySQLAdapter()); 2) Provider adapterProvider = new Provider() { public DbAdapter get() throws ConfigurationException {

Re: Schema generation with Ant

2012-03-15 Thread Michael Gentry
Hi Joerg, The PostgresAdapter is definitely part of the snapshot: $ jar tvf ~/.m2/repository/org/apache/cayenne/cayenne-server/3.1M4-SNAPSHOT/cayenne-server-3.1M4-SNAPSHOT.jar | grep PostgresAdapter 8090 Fri Feb 24 09:01:24 EST 2012 org/apache/cayenne/dba/postgres/PostgresAdapter.class The on

AW: Schema generation with Ant

2012-03-15 Thread Schönfisch , Jörg
Hi Michael, I found the Ant debug settings :) This seems to be the relevant part of the exception: Caused by: java.lang.ClassNotFoundException: org.apache.cayenne.dba.postgres.PostgresAdapter at java.net.URLClassLoader$1.run(URLClassLoader.java:202) at java.security.AccessContro