How to use left outer join / left join in cayenne?

2007-07-08 Thread just_a_kid

Hi,

 Can somebody give me example /teach me how do we perform left outer join
using cayenne?
 I have been doing this using Expression.fromString() but it doesnt work.

 2nd thing , can we perform direct native SQL dialect in cayenne? ( for
example if we want to perform " select * from table_a where rownum <=10 )
and 
 how do we get java.sql.Connection in cayenne? 

  hanks
-- 
View this message in context: 
http://www.nabble.com/How-to-use-left-outer-join---left-join-in-cayenne--tf4046745.html#a11494856
Sent from the Cayenne - Dev mailing list archive at Nabble.com.



Re: Going ahead with M1

2007-07-08 Thread Andrus Adamchik


On Jul 8, 2007, at 5:55 PM, Andrus Adamchik wrote:




1. Once I am done with documentation checkins, I will create a  
release tag in SVN (tonight)


Done:

https://svn.apache.org/repos/asf/cayenne/main/tags/3.0M1/cayenne/


2. I will also post a Maven snapshot of the code in the snapshot repo


Done. The latest Maven snapshots correspond exactly to the release tag.

Andrus


Local docs CSS

2007-07-08 Thread Andrus Adamchik
A question for Ari - is it possible for you or Bruce to help us  
update the release docs CSS [1] to look more like the website?  
Currently it uses small Confluence fonts and is generally not that  
pretty. To see it in action, you can open any HTML page in your local  
checkout of Cayenne under "docs/doc/src/main/resources/doc/ 
Documentation".


No rush to do it for M1, but would be nice to update it at some point.

Thanks
Andrus

[1] https://svn.apache.org/repos/asf/cayenne/main/trunk/docs/doc/src/ 
main/resources/doc/style.css




[JIRA] Created: (CAY-828) Remove DataContextTransactionEventListener, DataObjectTransactionEventListener, DataContextEvent

2007-07-08 Thread Andrus Adamchik (JIRA)
Remove DataContextTransactionEventListener, DataObjectTransactionEventListener, 
DataContextEvent


 Key: CAY-828
 URL: https://issues.apache.org/cayenne/browse/CAY-828
 Project: Cayenne
  Issue Type: Task
  Components: Cayenne Core Library
Affects Versions: 3.0
Reporter: Andrus Adamchik
Assignee: Andrus Adamchik
 Fix For: 3.0


Per CAY-737 we've deprecated the old access.event package. After M1 is posted, 
we should be able to remove it.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



[JIRA] Created: (CAY-827) Flatten and simplify documentation structure generated by maven-cayenne-doc-plugin

2007-07-08 Thread Andrus Adamchik (JIRA)
Flatten and simplify documentation structure generated by 
maven-cayenne-doc-plugin
--

 Key: CAY-827
 URL: https://issues.apache.org/cayenne/browse/CAY-827
 Project: Cayenne
  Issue Type: Task
  Components: Cayenne Documentation
Affects Versions: 3.0
Reporter: Andrus Adamchik
Assignee: Andrus Adamchik
Priority: Minor
 Fix For: 3.0


Docs loaded from wiki to SVN have a nested structure following the page tree 
structure and also use spaces in page names. This makes file management harder, 
but also creates a mismatch in the naming between the SVN docs and the 
autoexported docs.

So I think it would be beneficial to align generated file names with 
auto-export plugin behavior (also since sometimes we need to delete pages by 
hand and it should be nice to have an ability to match the names)

1. No subdirs - everything is flat
2. Images are stored in the dir called "pagename.data"
3. Filenames are converted from page names by lowercasing them and replacing 
the spaces with "-":

   "My Page" -> "my-page.html"


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



[JIRA] Created: (CAY-826) Modeler support for the extra simple property types that Cayenne now supports

2007-07-08 Thread Andrus Adamchik (JIRA)
Modeler support for the extra simple property types that Cayenne now supports
-

 Key: CAY-826
 URL: https://issues.apache.org/cayenne/browse/CAY-826
 Project: Cayenne
  Issue Type: Task
  Components: CayenneModeler GUI
Affects Versions: 3.0
Reporter: Andrus Adamchik
Assignee: Andrus Adamchik
 Fix For: 3.0


Per CAY-645, CAY-647, CAY-648, CAY-650, Cayenne can now persist 
java.util.Calendar, java.math.BigInteger, java.io.Serializable, char[], 
java.lang.Character, java.lang.Character[], java.lang.Byte[]. Need to show 
these types in the Modeler.

Also java.util.Date doesn't seem to be showing. Add this one too


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



Going ahead with M1

2007-07-08 Thread Andrus Adamchik
I think we are in a good shape to post the actual release. I've done  
fairly extensive testing and fixed a number of last minute bugs (see  
my earlier emails). I am wrapping up with documentation work.


Since this is the first release of an unstable branch done using a  
new build system (Maven), I think we may deviate from our earlier  
procedure of doing a coordinated release testing over IRC. I suspect  
the testing can take more time, so we should do it offline.


So I suggest this:

1. Once I am done with documentation checkins, I will create a  
release tag in SVN (tonight)

2. I will also post a Maven snapshot of the code in the snapshot repo
3. Myself and others who volunteer to help should check out the tag  
and try to run unit tests against various DB's (I would also  
encourage build local assemblies and see if they look any good, i.e.  
the Modeler starts, all the jars are in place), etc.
4. Also somebody needs to check the tag code with RAT tool. Any  
volunteers to do that? If not I will do it.
5. Once we hear back from everybody involved, I can post signed  
release artifacts for the vote. I expect this to happen within 4-5 days.


Does this plan look ok?

Andrus


[JIRA] Created: (CAY-825) Support for QueryCacheFactory in the modeler

2007-07-08 Thread Andrus Adamchik (JIRA)
Support for QueryCacheFactory in the modeler


 Key: CAY-825
 URL: https://issues.apache.org/cayenne/browse/CAY-825
 Project: Cayenne
  Issue Type: Task
  Components: Cayenne Core Library, CayenneModeler GUI
Affects Versions: 3.0
Reporter: Andrus Adamchik
Assignee: Andrus Adamchik
 Fix For: 3.0


QueryCacheFactory is a very powerful cache customization mechanism. We need to 
support configuring it in the Modeler.

* For default factory (MapQueryCacheFactory) - support setting 
'cayenne.MapQueryCacheFactory.cacheSize' property; this also requires updating 
DataDomain code to pass configured property to the factory method.
* Allow setting a custom factory  (how do we pass properties? Should we finish 
Modeler Properties feature first?)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.