Re: JDO

Hi, Robert. Be aware that Sun just built a reference implementation to show off the functionality. They access a filesystem, which has no indexes for optimized queries except the filename. They simply hit their goal (it works), and had no ambitions to overfulfil it. Hiran - Original Message

long transactions

Hi Thomas, A while ago, you mentioned that although long transactions are not currently supported, there are a few possible approaches: >If you want to use the ODMG in your SessionBean scenario you have to > implement your own simple long transaction mechanism. > (In the OTM package we will have

Re: Generate table definitions?

http://db.apache.org/ojb/platforms.html http://db.apache.org/torque Gabriel Bauman wrote: Hi there! I'm sure this has been asked many times here, but I'm wondering what the steps are to generate SQL tables from my repository.xml files. I've been puzzling over Torque for a few hours now. I'm mi

Re: Design Questions

Hi Lucy, Lucy Zhao wrote: I am new to OJB and my previouse experience with TopLink 3 years ago was quite bad. Basically I'm worried about the performance and the flxibility of an Object relational mapping tool. In my application, 80% of transaction are "Select" queries while the rest are "create,

Re: Generate table definitions?

I just figured it out myself. It works and its pretty slick. If you want I can put the steps in an email and send it your way. Someone really needs to help project out with something like a getting started guide. Just let me know if you still need assistance, Jeff On Tuesday 25 February 200

More on bug when PK field name != column name

I traced my problem further and found (I think) another place where getAttributeName is being used incorrectly. Inside PersistenceBrokerImpl.getMtoNQuery are the following lines: for (int i = 0; i < itemClassFks.length; i++) { criteria.addEqualToColumn( cod.getIndirectionTable() + "."

Bug in PersistenceBroker.getCount() ?

I just changed my database schema such that one of my tables now has a primary key field whose name is different than the column name in the database. Things worked OK in general until I referenced the table from another table via an M:N association. I then got an SQL exception complaining that I

Intersection queries and subquery attributes

Hello, Is it possible in OJB to do these two things? 1. Create a Query representing the intersection of two other Queries (intersection to be executed in the database) 2. Use Criteria.addEqualToField() within a subquery where the named field actually comes from an object in a parent or grandpare

Generate table definitions?

Hi there! I'm sure this has been asked many times here, but I'm wondering what the steps are to generate SQL tables from my repository.xml files. I've been puzzling over Torque for a few hours now. I'm missing something somewhere. Any help or pointers to relevant documentation would be apprecia

Design Questions

I am new to OJB and my previouse experience with TopLink 3 years ago was quite bad. Basically I'm worried about the performance and the flxibility of an Object relational mapping tool. In my application, 80% of transaction are "Select" queries while the rest are "create, delete and updates". So I p

Re: JDO

point taken. Fair enough :-) On Tuesday, Feb 25, 2003, at 15:25 US/Eastern, Thomas Mahler wrote: Hi again Robert, Robert S. Sfeir wrote: On Tuesday, Feb 25, 2003, at 14:59 US/Eastern, Thomas Mahler wrote: SO any queries that do a (non-primary key based) criteria lookup, will result in loading

Re: OJB-0.9.9 + MySQL ODMG Startup Problem

That did the trick, fellas. Thanks so much. Now to dig back in ^_^ -- Thomas Brian Holdren, Systems Programmer Health Design Plus "It's not what you know that is important, it's knowing how to find what you don't know.' - To

RE: auditing mapped classes

I think ideally this fits as low on the persistence mechanism as possible (i.e., the DB). However, the thought of implementing this as a web of triggers, when I have a nice Object layer directly above, just seems silly. I impetus behind this is that I am writing a thin interface layer over (and h

Re: OJB-0.9.9 + MySQL ODMG Startup Problem

Hi, known bug in 0.9.9 - Original Message - From: "Armin Waibel" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 8:57 PM Subject: Re: OMDG Tutorial2 won't run as written > Hi Joerg, > > I have checked in a fix for tutorial2. Please replace th

RE: OJB-0.9.9 + MySQL ODMG Startup Problem

I got mine working by opening database with 'jcd-alias' instead of databaseName: db.open(, Database.OPEN_READ_WRITE) where is defined in repository_database.xml. Zhangling Ren -Original Message- From: Thomas B. Holdren [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 11:51

Re: JDO

Hi again Robert, Robert S. Sfeir wrote: On Tuesday, Feb 25, 2003, at 14:59 US/Eastern, Thomas Mahler wrote: SO any queries that do a (non-primary key based) criteria lookup, will result in loading the complete extent (all instances of a given class) into memory an then filter all matching insta

RE: JDO

Wouldn't put this on Sun. Sounds more like an artificat of using the RI implementation to provide API support until a native solution is developed. > -Original Message- > From: Robert S. Sfeir [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 25, 2003 3:10 PM > To: OJB Users List > Sub

Re: auditing mapped classes

Hi STeven, Ebersole, Steven wrote: I'll take silence as a no... In my case silence just means "tom did not find the time to answer yet... or even worse he did miss the original posting..." |-Original Message- |From: Ebersole, Steven [mailto:[EMAIL PROTECTED] |Sent: Monday, Fe

Re: JDO

On Tuesday, Feb 25, 2003, at 14:59 US/Eastern, Thomas Mahler wrote: SO any queries that do a (non-primary key based) criteria lookup, will result in loading the complete extent (all instances of a given class) into memory an then filter all matching instances. This is even worse than an full tab

Re: JDO

Hi Hiran, Hiran Chaudhuri wrote: Hi, Thomas. New to OBJ, I'm trying to decide whether to use it within my project as persistence layer or not. I have concerns since I read on http://db.apache.org/ojb/features.html that OQL support is incomplete, also there are some flaws in transaction handling.

Re: easy 1-1, 1-m association and inheritance

Feel free to post it to the list! We will review it! thanks, Thomas TINE Houari (OBJECTIVA) wrote: Hi, No it's a personnal work. I finish tests and I propose it to anyone... Houari -Message d'origine- De : Rice Yeh [mailto:[EMAIL PROTECTED] Envoyé : lundi 24 février 2003 12:46 À : OJB

Re: some OJB proxy questions

Hi Maarten, AFAIK this is not possible today. But I think it's a feature request that could be beneficial for several users. I also believe that is not that difficult to implement. It won't make it into 1.0, but we can place it on the post 1.0 roadmap. For the time being you could try to use in

OJB-0.9.9 + MySQL ODMG Startup Problem

Greetings, I'm trying to do my first OJB project, and I'm not getting very far. I was able to get tutorial1 to work, and I was able to use the Persistence Broker functionality in my own test app just fine by basically copying tutorial1 code into a test app and modifying it a bit. So PB API wo

Re: Query returning denormalised view

John -- Use this constructor when you create your query object: QueryByCriteria(Class,Criteria,boolean) Passing true for the 3rd argument causes the generated sql to include the DISTINCT keyword. Ron Gallagher Atlanta, GA [EMAIL PROTECTED] > > From: O'Reilly John <[EMAIL PROTECTED]> > Date:

Re: Can PersistenceBroker report queries be used within ODMG?

Hi Mark, Mark Neighbors wrote: I see the new support for projectionAttributes in oql-ojb.g that generates pb report queries. Got an example to work. I see OQLQueryImpl.execute calling performLockingIfRequired but only for collection queries. Is there a way to coordinate report queries with odmg

Query returning denormalised view

Hi, I'm having a problem whereby a query that involves searching for values in a contained collection returns the same number of objects as the collection. Take, for example the case of a member object that has a collection of addresses. If I do the following query. crit.addLike("upper(name)", "

RE: auditing mapped classes

I'll take silence as a no... |-Original Message- |From: Ebersole, Steven [mailto:[EMAIL PROTECTED] |Sent: Monday, February 24, 2003 10:35 AM |To: OJB Users List (E-mail) |Subject: auditing mapped classes | | |I was wondering if OJB has built-in support for

Deleting objects in a collection

Hi, I'm trying to delete objects from a collection, it seems to workin the code, but when I look in the database the object is still there. This is what I do: First I add en element to the collection and save all the objects, by putting a lock on ALL. At this point the application and the data

M:N mappings and User defined collections

I'm trying something similar as defined in: http://db.apache.org/ojb/tutorial3.html#Support%20for%20non-decomposed%20m:n %20mappings Support for non-decomposed m:n mappings, but using a user-defined collection instead java.util.Collection as in the example with Persons and Projects. My test examp

RE: How to use multiple aliases for one class/table in query

and of course... this way it becomes an OR relation between the keywords... i want the issues that have all three keywords... not just one of them, thats why the multiple aliases are needed Roger Janssen mailto:[EMAIL PROTECTED] iBanx B.V http://www.ibanx.n

RE: How to use multiple aliases for one class/table in query

Well, that would mean that for 1 and the same keyword record (used in this join) the field VALUE would have to hold all these three values at the same time... that can't be Roger Janssen mailto:[EMAIL PROTECTED] iBanx B.V http://www.ibanx.nl

RE: How to use multiple aliases for one class/table in query

Why would it not use an IN clause? SELECT DISTINCT * FROM ISSUE A0 INNER JOIN KEYWORD A1 ON A0.ID=A1.OID WHERE A1.VALUE IN ('OJB', 'join', 'alias') Wally -Original Message- From: Janssen, Roger [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:55 AM To: OJB Users List (E-m

How to use multiple aliases for one class/table in query

Hi, I posed this question earlier but i haven't seen any response yet. I'll try it again, a bit different this time. Suppose i have an application registering issues, and in which i can assign keywords to issues. The keywords are stored in a different table (with a fk-relation to the related is

Re: JDO

Hi, Thomas. New to OBJ, I'm trying to decide whether to use it within my project as persistence layer or not. I have concerns since I read on http://db.apache.org/ojb/features.html that OQL support is incomplete, also there are some flaws in transaction handling. Now the bad question: Do you esti

Question re prefetched relationsbips

Hi Does anyone know if prefetched relationships can reach more than one "layer" of references/collections from an class being queried? E.g. If I have a class A that I an querying and it has a 1:m relationship with some class B, with the relationship defined by the name "allb", and then each B has

Re: PersistenceBrokerFactoryIF.instantiate(): strange behavior

Hi Joerg, there is a known bug in 0.9.9 to patch this see http://archives.apache.org/eyebrowse/[EMAIL PROTECTED] pache.org&msgNo=5507 or try to use db.open("default#userName#password", Database.OPEN_READ_WRITE); regards, Armin - Original Message - From: "Joerg Lensing" <[EMAIL PROTECT

query formulation question

I'm wondering how to formulate a query. I'm sure this is s FAQ, but I can't find the answer... Looking at the "Mapping M:N associations" section of the "Advanced O/R" doc, I have a situation which is analogous to the Person, Project, PersonProject example of decomposition into two 1:N associat

some OJB proxy questions

Hi, I have a couple of questions about the proxies. 1. I want to use dynamic proxies, but these proxies may not use the PersistenceBroker for querying the database. Instead, they must get the real object through an API I defined myself. The idea is to return object from my object model to clie

Re: How to map embedded value object?

Hi Thomas, Thank you for your answer. But I continue my question. Is it possible to have this embbeded value to refer back the master object. For example, B (as the Address class) is the embeded object of A (Party class as example). But B has a field referring to A. Is this kind of mapping poss

PersistenceBrokerFactoryIF.instantiate(): strange behavior

Hi all, look at this: Database db = impl.newDatabase(); try { --->> db.open("default", Database.OPEN_READ_WRITE); int i = 1; } catch (ODMGException ex) { ex.printStackTrace();

Re: How do I dynamically create a new persistent object/table?

Oh PLEASE keep it, but how about doing this way: On db.open() when you parse the XML document to verify it's structure and relationship mapping to the beans, do a check to see if the table exists. If it doesn't exist build it. Once it's built keep the information in a cached file somewhere an

RE: easy 1-1, 1-m association and inheritance

Hi, No it's a personnal work. I finish tests and I propose it to anyone... Houari -Message d'origine- De :Rice Yeh [mailto:[EMAIL PROTECTED] Envoyé :lundi 24 février 2003 12:46 À : OJB Users List Objet : Re: easy 1-1, 1-m association and inheritance Hi, Have this m

RE: API ODMG or PersistenceBroker

Hi Ferran, > -Original Message- > > Hi all, > what are you using the API ODMG or API > PersistenceBroker?? i try the API ODMG and i need a joins but I am pretty new to OJB, too. This is one of the most frequent questions. If you get access to the mail archive (which is currently

Autoincrement

Hey Guys, I have an existing MySql table that i would like to manipulate with OJB. This table has an autoincrement integer row that has the role of primary key. What measures should I take to use this in OJB? I don't want OJB to generate this primary key. This is, i think, what happens when i d

RE: ClassCastException persisting Date field

John You may need to use a FieldConversion on the relevant field(s)/columns(s) e.g Mark -Original Message- From: O'Reilly John [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:38 AM To: 'OJB Users List' Subject: ClassCastException persisting Date field Hi, Is the

ClassCastException persisting Date field

Hi, Is there any known issue with persisting Date's using OJB. I have defined the field as follows: The code that sets the date is as follows: Calendar today = Calendar.getInstance() ; today.set(Calendar.DAY_OF_MONTH, 28 ); today.set(Calendar.MONTH, 8 ); today.

API ODMG or PersistenceBroker

Hi all, what are you using the API ODMG or API PersistenceBroker?? i try the API ODMG and i need a joins but i don't know how use joins in API ODMG, its possible joins in API ODMG?? thanks in advanced Ferran Parra Departament de Noves Tecnologies MUBIMEDIA S.L. -- [EMAIL

RE: Cannot access mailing list archive/documentation problem

Hi, all, I guess I have solved the problem by myself. If I try to access mail archive form http://db.apache.org/mail.html then it is Ok. The list name is [EMAIL PROTECTED] However, if i go inside the ojb page and use the url "Mailing lists" (on the left hand side) to access the archive, [EMAIL P

RE: Report queries on extents

Jakob I have a test case to show my problem public void testReportQuery() { testDeleteContractVersionEffectiveness(); createTestData(); Query query = QueryFactory.newReportQuery(Version.class, new String[]{"PK","contract.PK","contract.contractValue1"}, null, f

RE: QueryBySQL and update statement (Additional information)

Hi, all, I have some extra information. The target database is MSSQL. I found that if I run the update statment in a query analyser and then go back to my application to try again, the update statement will be fired. It seems strange to me. Is it an expected behaviour? Regard, Anthony -Or

QueryBySQL and update statement

Hi, all, I am using 0.9.8. I try to use QueryBySQL to apply an "update" clause on a few thousand records. I did not apply pb.getCollectionByQuery() on this sql object because it will fire "no resultset returned" error. Fair enough. So I did a pb.getCount(query_by_sql) instead. As far as I can see

Cannot access mailing list archive/documentation problem

Hi, all 1) When I try to access the mailing list archive shown in http://db.apache.org/ojb/mail-lists.html I encoutnered the following errors Error occurred Required parameter "listId" or "listName" is missing or invalid Is everything OK with this? 2) When i try to read http://db.apac