Re: Blobs in the DataContext

2010-05-28 Thread MGargano
Hi Tore, I finally got around to looking at your code in the jira attachments. It looks like it will need a little bit of updating to get it 3.0 ready, but at the end of the day it still pulls the whole thing into memory at some point. I might ping you over the next week, if you don'

Re: [OT] WWDC?

2010-05-27 Thread MGargano
I will. I'm sure the WO people will be collecting somewhere as well. -Mike From: Andrus Adamchik To: user@cayenne.apache.org Date: 05/27/2010 03:11 AM Subject: [OT] WWDC? Anybody will be at WWDC this year (June 7..11, San Francisco http://developer.apple.com/wwdc/ ) ? We can organize a

Re: Blobs in the DataContext

2010-05-24 Thread MGargano
Hi Andrew, These be flame war words. :-p Actually, I would normally totally agree with both your and Aristedes' recommendations, unfortunately the architecture I inherited for this product bills the BLOBs in the DB as a sort of "feature" that I don't see changing anytime soon. Curre

Blobs in the DataContext

2010-05-21 Thread MGargano
Hi, I'm using cayenne to store large files in BLOBs as a process runs. The first step of the process is storing large files (~ 600MB) and they are ending up in the DB just fine, then we run some tasks and get some output files, and then store the large output files (~ 500MB) to the DB.

Re: A few more issues: BLOBs and Oracle sequences

2010-05-11 Thread MGargano
I think that was it. Thanks guys. -Mike From: Michael Gentry To: user@cayenne.apache.org Date: 05/11/2010 12:04 PM Subject: Re: A few more issues: BLOBs and Oracle sequences The sequence cache between the database and Cayenne must match. When you created the sequence in Oracle you gave an

Re: A few more issues: BLOBs and Oracle sequences

2010-05-11 Thread MGargano
I'm not trying to recommit dirty objects, this is on a complete second run of the process which is what is so confusing to me. It's like the object got commited, but the sequence didn't. I have the sequence cache set to 20 on the DB, but cache PK size set to 0 in cayenne modeler. I don't know

A few more issues: BLOBs and Oracle sequences

2010-05-11 Thread MGargano
Hi everyone, Thanks for all the help so far. Cayenne is pretty sweet, but I've got a few more questions/problems. I'm trying to get this thing out the door and I'm running into the following two problems 1) I'm using an Oracle 11g backend, have my sequences all set (with caching

Re: commit on a table with no PK

2010-05-10 Thread MGargano
understood. makes sense. i just figured since i was doing inserts only i could get away with it, since the modeler was only giving warnings. thanks. -mike From: Michael Gentry To: user@cayenne.apache.org Date: 05/10/2010 04:30 PM Subject: Re: commit on a table with no PK If you don't h

Re: commit on a table with no PK

2010-05-10 Thread MGargano
it can't be the data because it's not necessarily unique. so cayenne always needs at least surrogate key? oh, pooh. :-/ -Mike From: Michael Gentry To: user@cayenne.apache.org Date: 05/10/2010 04:16 PM Subject: Re: commit on a table with no PK You need a key of some kind ... Is your ke

commit on a table with no PK

2010-05-10 Thread MGargano
Hi all, I'm creating a new object for a table with no PK. The object's properties are properly set, but when I do the commit I get this org.apache.cayenne.CayenneRuntimeException: [v.3.0RC2 Jan 30 2010 16:41:40] Temporary ID hasn't been replaced on commit: {; new; [outputFileNa

Reverse engineering existing tables... selectively

2010-05-05 Thread MGargano
Hey everybody, When I try to reverse engineer an existing table, I want to only reverse eng. a few of the tables that are related to each other. The problem is that they are named differently. When I put something like this in... "ETL_BATCH" OR "ETL_BATCH_CONFIG" OR "ETL_PARA

servlet filter and the Configuration

2010-04-30 Thread MGargano
Okay, So I think I've made some progress since my question yesterday. I have a bean in Spring that is a ConfigurationFactory. It returns a singleton and the dataSource can be obtained from that. Now I just need to get that configuration loaded on web startup. I guess I need to write

Spring + Cayenne

2010-04-29 Thread MGargano
Is anyone else configuring their data sources through Spring? How does one go about doing this? I was trying something, but it just keeps picking up the driver.xml file that cayenne modeler created. Plus I keep getting this nifty MalformedObjectNameException complaining about a nonprintable

Re: jdbc connection

2010-04-06 Thread MGargano
Out of mostly curiosity... What could the other contexts possibly be? I see BaseContext, which is there for specific implementations to inherit from, and CayenneContext, which I don't really understand. Would like an XMLContext or BinaryFileContext be examples of contexts in the future? -Mike

Re: jdbc connection

2010-04-05 Thread MGargano
Thanks guys. Will it always be safe to cast BaseContext.getThreadObjectContext() to DataContext? -Mike From: Michael Gentry To: user@cayenne.apache.org Date: 04/05/2010 04:46 PM Subject: Re: jdbc connection dataContext.getParentDataDomain().getNode("foo").getDataSource().getConnection()

jdbc connection

2010-04-05 Thread MGargano
What's the best way to get a direct handle to a jdbc connection in your underlying pool. It looked like getting it straight from DataNode was the way to go, but then how do I get to my DataNode? :) Thanks. -Mike

Cayenne pattern quesiton

2010-03-30 Thread MGargano
When using Cayenne are DAO's still the pattern used for findAll, findByProperty, and findById query methods or is there some better way to do this in Cayenne? For example in the pet store project I see DAO's being implemented, but I know that example was taken from other projects that use DAO'

Re: Switching databases

2010-03-24 Thread MGargano
Thanks everyone. This is definitely making me feel more comfortable with Cayenne as an ORM choice. For #2 (PK Generation) below, does that mean I have to roll my own generator? Is there more detailed documentation on that (don't see it on the website)? Thanks again. -Mike From: Andrus Ad

Switching databases

2010-03-23 Thread MGargano
Hi, I'm looking into using Cayenne as a backend ORM technology replacing hibernate. Currently our product supports multiple DBMSes (SQL Server, Oracle, DB2) depending on what the client already has installed. In hibernate when switching between oracle and sql server, for example, is j