primary key field null after update

2006-04-05 Thread Guido Beutler
Hi, I am using OJB 1.0.4 inside of jboss 3.2.5. I updated from OJB 1.0.0 to 0.4 . Now I am running is a strange problem which did not occur in 1.0.0. When I update a object the primary key field is null after the store although the update is executed and succeed. The update sql statement is

RE: primary key field null after update

2006-04-05 Thread Manukyan, Sergey
Hi, make sure you have correctly defined the primary keys... Sergey -Original Message- From: Guido Beutler [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 05, 2006 8:42 AM To: ojb-user@db.apache.org Subject: primary key field null after update Hi, I am using OJB 1.0.4 inside of

rownum causes order by trouble

2006-04-04 Thread Bruno CROS
Hi, Inserting a criteria as rownum 2 causes the ORDER BY #n DESC to be ORDER BY #n . DESC has been lost !! Anyone confirm ? Have a workaround ? What's the best way to read only first resultset (or Object) without iterating the whole collection ? I suspect some broker-connections troubles on

ojb dependencies

2006-04-03 Thread Zeiler Christian, Bedag
Hello Where can I find a list of *.jar dependencies of a particular OJB version? Cheers Chris - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

ResultSet.next() failed !!!!

2006-04-03 Thread ABOU LINA
Hi; 1. DB2 / AS400 2. Broker i made a search query that retrieve 5000 records from database DB2/AS400. i use getIteratorQuery , look this code please : 1. getting the broker 2. while (result.hasNext()) { // 5000 records obj = result.next() } 3. close the broker i got the error

OJB DB2 UDB, retrieving DATE ????

2006-03-30 Thread ABOU LINA
Hi; AS400 as server. DB2 UDB as database . in a table we have a record whith the date 2999-12-31. when using ojb to retreive this record, the value of date is returned null. with an sql tool we have be able to get this date with the instruction select char(datetoshow, ISO)... we have also

Re: OJB DB2 UDB, retrieving DATE ????

2006-03-30 Thread Vasily Ivanov
Hi, Try this: ReportQueryByCriteria query = QueryFactory.newReportQuery(YourClass.class, criteria); query.setAttributes(new String[] { char(dateField, 'ISO'), anotherField }); yourPersistenceManager.getBroker().getReportQueryIteratorByQuery(query); I didn't test, but it should work. On

RE : bad sql on n-m relation to subclassed object

2006-03-29 Thread Nicolas DELAHAYE
Hi jakob, I have not left the project because of OJB, of course ;) I have not succeeded to reproduce the behavior explained below. And, I think it is a mistake on our code. Best regards Nicolas DELAHAYE -Message d'origine- De : Jakob Braeuchi [mailto:[EMAIL PROTECTED] Envoyé :

Re: auto delete and foreign keys

2006-03-29 Thread Jean-Yves Sironneau
Hi, The problem was solved by setting the foreign key constraint to DEFERRABLE INITIALLY DEFERRED in postgres. So the check of constraints is done only at the end of the transaction, this way OJB is deleting the objects and then the constraints are enforced. Thanks for your help. Jean-Yves

RE: Order By not working!

2006-03-29 Thread Vagula
Hi, Even after using addOrderByAscending(),addOrderBydesending() the sorting of data is not working. The repository user xml mapping is as follows: class-descriptor class=com.inetpsa.pac.ojb.bean.EntityData table=PACQTENT

Re: auto delete and foreign keys

2006-03-28 Thread Jean-Yves Sironneau
Hi Armin, On 3/27/06, Armin Waibel [EMAIL PROTECTED] wrote: Hi Jean-Yves, Jean-Yves Sironneau wrote: Hello, Yes another question again. I have a class Area that is referencing a class Point, and Area has a foreign key constraint on Point. I'am using ODMG, and i would like OJB to

Re: Reflexive ReportQuery

2006-03-27 Thread Bruno CROS
Auto reply : Final solution done with normal SQL query. Solution includes sub queries attribute as well. ++ On 3/22/06, Bruno CROS [EMAIL PROTECTED] wrote: Hi again, I 'm desesperatly searching how to produce ReportQuery with a reflexive virtual relation. Is it possible to declare

Report query right outer join

2006-03-27 Thread Bruno CROS
Hi, A new challenge : build a left and a right outer join. In fact, i think it's describe as a full outer join in a single reportquery. Does someone think it's possible with OJB or do i go SQL again ? Regards

Re: auto delete and foreign keys

2006-03-27 Thread Armin Waibel
Hi Jean-Yves, Jean-Yves Sironneau wrote: Hello, Yes another question again. I have a class Area that is referencing a class Point, and Area has a foreign key constraint on Point. I'am using ODMG, and i would like OJB to delete the Point when i delete the Area. What happens is that when i

Re: Mapping List's

2006-03-27 Thread Armin Waibel
Hi Markus, Markus Brigl wrote: Hi, I have a problem with the mapping of List's. If I store the list to DB and reload it the order of the objects are casual and not the same as I inserted them in the List. Can I configure the repository file in some way that OBJ stores even the indexes of the

Re: Way to prevent store?

2006-03-27 Thread Armin Waibel
Hi Tino, Tino Schöllhorn wrote: Hi, I have a situation where I want to prevent the creation of an object in the database. Is there a way to prevent the insertion via the callback-methods (beforeInsert) ? Throwing an Exception in these methods doesn't work, because the situation is not

Re: Mapping List's

2006-03-27 Thread Markus Brigl
Hi Armin, it didn't mean the order-by, which does an ordering related to an attribute. What I mean is the insert order in a list; if an object A has index 0 in the list I would expect it has the same index after fetching the list in a different transaction. At example with Hibernate it is

Re: Report query right outer join

2006-03-27 Thread Bruno CROS
Auto-reply : SQL again. On 3/27/06, Bruno CROS [EMAIL PROTECTED] wrote: Hi, A new challenge : build a left and a right outer join. In fact, i think it's describe as a full outer join in a single reportquery. Does someone think it's possible with OJB or do i go SQL again ?

Next Release

2006-03-27 Thread Tino Schöllhorn
Hi, we are currently using OJB 1.0.1 and are thinking about updating to the latest release. When do you think the next version 1.0.5 will be released? With regards Tino - To unsubscribe, e-mail: [EMAIL PROTECTED] For

Way to prevent store?

2006-03-26 Thread Tino Schöllhorn
Hi, I have a situation where I want to prevent the creation of an object in the database. Is there a way to prevent the insertion via the callback-methods (beforeInsert) ? Throwing an Exception in these methods doesn't work, because the situation is not an error and I want to prevent the

Tutorials

2006-03-23 Thread ca . ddy
Hey everybody, are there any Tutorials that you can advice for learning to use the OJB especially in the JSP Context. I want to try to self study using ojb... I am developing on Eclipse Version3 and the Server is a Tomcat V5. Thanks a lot !! Caddy Hint : I know that there are some on the OJB

Re: Tutorials

2006-03-23 Thread Stas Ostapenko
Take a look at this http://apache.org/dist/db/ojb/db-ojb-1.0.4/webapp-sample.jar. This is a good example of using OJB, Struts and JSP all together. On 3/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hey everybody, are there any Tutorials that you can advice for learning to use the OJB

auto delete and foreign keys

2006-03-23 Thread Jean-Yves Sironneau
Hello, Yes another question again. I have a class Area that is referencing a class Point, and Area has a foreign key constraint on Point. I'am using ODMG, and i would like OJB to delete the Point when i delete the Area. What happens is that when i commit a transaction for removing an Area, OJB

Subqueries in ODMG query

2006-03-23 Thread Eric Kelm
Is it possible to use a subquery inside of an ODMG query e.g. select jobs from + JobBO.class.getName(); where employees_idemployee = + employee.getIdEmployee(); idjob like $1 or idtask_code like (select task_codes from + TaskCodeBO.class.getName(); where task_code_name like $2

RE: Subqueries in ODMG query

2006-03-23 Thread Eric Kelm
Sorry mistyped Is it possible to use a subquery inside of an ODMG query e.g. select jobs from + JobBO.class.getName(); where employees_idemployee = + employee.getIdEmployee() + and (idjob like $1 or idtask_code like (select task_codes from + TaskCodeBO.class.getName(); where

Re: Subqueries in ODMG query

2006-03-23 Thread Vasily Ivanov
http://db.apache.org/ojb/docu/guides/query.html#subqueries On 3/24/06, Eric Kelm [EMAIL PROTECTED] wrote: Is it possible to use a subquery inside of an ODMG query e.g. select jobs from + JobBO.class.getName(); where employees_idemployee = + employee.getIdEmployee(); idjob like $1 or

RE: Subqueries in ODMG query

2006-03-23 Thread Eric Kelm
Thanks, but I was looking for something using ODMG-API, not PB-API. I did find this test case and my query looks similar except that I have 2 different object types in my query. /** + * test Subquery + * get all articles with price avg(price) + * PROBLEM: avg(price) is NOT

Re: ODMG locking and read only references

2006-03-22 Thread Jean-Yves Sironneau
It worked with the SVN version of OJB the objects are not materialized so there is no LockNotGrantedException, by weak reference i meant read only reference to an object, and i that case the referencing object is just interested by the fact is has a relation with the referenced object but not with

Re: Misc questions

2006-03-22 Thread Jean-Yves Sironneau
Ok i think i got it, thank you for the explanations. 2006/3/21, Armin Waibel [EMAIL PROTECTED]: Hi Jean-Yves, Jean-Yves Sironneau wrote: Hi, Thanks for your help, it works by locking the object inside a transaction and the setting the referenced object, what confused me is that for

Re: Order By not working!

2006-03-21 Thread Danilo Tommasina
Hi, Criteria.addOrderBy(...) is deprecated, you should use the addOrderByAscending(...) or addOrderByDescending(...) on the QueryByCriteria instance. If this does not work, please provide more information, java version, OJB version, error messages, repository XML definition for the table,

RE: Urgent issue : OJB_HL_SEQ not valid for operation

2006-03-21 Thread Charles Anthony
The AS400 schema/library you are using does not have journalling turned on - but the AS400 JDBC driver needs it turned on. See http://www-03.ibm.com/servers/enable/site/java/jdbc/jdbcfaq.html#B20 In short : for simplicity, you should create the AS400 library using either of theses SQL

Urgent issue : OJB_HL_SEQ not valid for operation

2006-03-21 Thread ABOU LINA
Hi, ojb can't generate a sequence number for insert !!! i got this msg error whene deploying the war under AS400 and Websphere 6.0 : SQL failure while insert object data for class org.apache.ojb.broker.util.sequence.HighLowSequence, PK of the given object is [ tableName=global - default

Re: ODMG locking and read only references

2006-03-21 Thread Armin Waibel
Hi Jean-Yves, Jean-Yves Sironneau wrote: Hello, I would like to know if it's possible using ODMG to set auto-update to false for a reference. Because in the documentation it's supposed to be set to none. But none seem's to be true. Sorry, the ODMG implementation expects these specific

Re: Misc questions

2006-03-21 Thread Armin Waibel
Hi Jean-Yves, Jean-Yves Sironneau wrote: Hi, Thanks for your help, it works by locking the object inside a transaction and the setting the referenced object, what confused me is that for a new object you don't have to be within a transaction for the referenced object to be created, but for an

Join on the same table

2006-03-21 Thread Bruno CROS
Hi all, first, thanks Armin for the patch, i think will wait 1.0.5 if it will be released in the month, because i need CLOB changes too. I'm asking me if it's possible to build an auto join ReportQuery such as : select A0.id, A1.id FROM table1 A1, table1 A2 where A1.joinColumn1 =

Order By not working!

2006-03-20 Thread Vagula
Hi, The following query is not working for wild character search (%, ?, *) criteria.addLike(UPPER(ACRONYM) ,entityAcronym.trim().toUpperCase()); criteria.addOrderBy(entityAcronym); query = new

Re: ODMG and markDelete behaviour

2006-03-17 Thread Armin Waibel
Hi Bruno, I think the bug is due to the flush and markDelete. you are right, the bug is indirectly caused by the TransactionExt.flush() call. In this case OJB reuse all registered object entries but doesn't clear 1:1, 1:n link history. Thus these operations will be called again on next

[DBMS] How to connect to Oracle RAC cluster?

2006-03-16 Thread Geigl Maximilian, R235
Hello, does anyone have experiences in connecting to a Oracle Real Application Cluster (RAC) from OJB. We use Oracle 10g database server and JDBC driver 9.2 or 10. I tried the following URL in the connection descriptor (in one line) dbalias=thin:@(DESCRIPTION = (ADDRESS =

Mandragora make OJB easier

2006-03-16 Thread Alessandro Colantoni
Hi all! mandragora is a very small open source project available at http://mandragora.sourceforge.net With mandragora you are provided with the most common queries you use to build with ojb. How many times you wrote methods to find an object or a collection of objects satisfying some conditions,

quiet setPathOuterJoin(wrongPath)

2006-03-16 Thread Manukyan, Sergey
Folks, Method ReportQueryByCriteria.setPathOuterJoin(someWrongPath) , when invoked with wrong path argument does nothing to notify the caller about an error. IMHO it would be nice to have him throw a runtime exception in that case. Could have saved me half a day of debugging time...

Re: ODMG and markDelete behaviour

2006-03-16 Thread Armin Waibel
Hi Bruno, Bruno CROS wrote: Hi, well, if i do not flush, process can't work. We tried to avoid them, but process seems to not (several circular references as i explained you a few days ago) I didn't get OJB test suite running (without any change of 1.0.4 binary dist). the DB creation step

Re: ojb 1.0.4 and org.apache.ojb.broker.PBFactoryException: There was no 'default-connection'...

2006-03-15 Thread Dino
After some alignments on OJB configuration files and libraries dependencies the problem below seems to be fixed. However another problem arises with the following exception: org.odmg.TransactionNotInProgressException: No external transaction found. I am going to open another thread.

Re: ODMG and markDelete behaviour

2006-03-15 Thread Armin Waibel
Hi Bruno, I setup a similar test in CircularTest#testBidirectionalOneToOneMoveObject() http://svn.apache.org/viewcvs.cgi/db/ojb/branches/OJB_1_0_RELEASE/src/test/org/apache/ojb/odmg/CircularTest.java?rev=386117view=markup The test works like a charm. Compared with your post this test doesn't

Re: ODMG and markDelete behaviour

2006-03-15 Thread Bruno CROS
Hi, well, if i do not flush, process can't work. We tried to avoid them, but process seems to not (several circular references as i explained you a few days ago) I didn't get OJB test suite running (without any change of 1.0.4 binary dist). the DB creation step crashes with an unknown CLOB

Setting Default Class for Collections

2006-03-14 Thread Tino Schöllhorn
Hi, I want to use an own implementation of a java.util.List-Class in my project and I am trying to find the place where to change the default List implementation. I couldn't find it int the OJB.properties file. I am using OJB 1.0.1. With regards Tino

Re: AW: Problem joining two tables with same column name

2006-03-13 Thread Josef Wagner
Hi Jakob, do you think that I have the same problem? It appears only with m-n. ## ### 1. mapping ### ## !-- m - n -- collection-descriptor name=table_n collection-class=org.apache.ojb.broker.util.collections.ManageableArrayList

Re: AW: Problem joining two tables with same column name

2006-03-13 Thread Jakob Braeuchi
hi josef, you should not prefix the attribute with the tablename. crit.addEqualTo(id) is ok, where id is the name of the attribute not the name of the column. hth jakob Josef Wagner schrieb: Hi Jakob, do you think that I have the same problem? It appears only with m-n. ##

AW: AW: Problem joining two tables with same column name

2006-03-13 Thread Josef Wagner
Thanks a lot Jakob! That was the problem -Ursprüngliche Nachricht- Von: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Gesendet: Montag, 13. März 2006 18:09 An: OJB Users List Betreff: Re: AW: Problem joining two tables with same column name hi josef, you should not prefix the attribute

ODMG and markDelete behaviour

2006-03-11 Thread Bruno CROS
Hi Armin, Hi all. Well, with a little confusion, we believed that our bug of complex update was not one. But it remains. I'm suspecting a bug of OJB concerning the transcription of the markDelete in SQL operations. If I have time, I will try to assemble a demonstrative case of test with

Re: bad sql on n-m relation to subclassed object

2006-03-10 Thread Jakob Braeuchi
hi nicolas, please post the relevant parts of the repository.xml and eventually the generated sql. i hope you didn't leave the project because of ojb ;) jakob delahaye.nicolas schrieb: Hi jakob, Thank for your answer. I have see an other strange thing : I have a class B that inherit from

Re: PB behavor of Collection item delete ?

2006-03-09 Thread ABOU LINA
thank first, PersistenceBroker *delete elements* from the database that have been removed from the collection only if i do this : for example : A 1:n B 1. i get A from database using OJB Broker. 2. i delete one element B from A : A.getBCollection().remove(o); in this case yes the PB delete the

Problem with collection using ODMG API

2006-03-09 Thread Eric Kelm
Hi all- I am having a problem with 1:n collection in OJB using ODMG. Say I have a parent object, lets call it Trouble Ticket T with a collection of Ticket Notes N. Lets say that the objects retrieved in list N are n1, n2, n3. I perform a retrieval from the DB on Object T. Now I have T with a

Re: PB behavor of Collection item delete ?

2006-03-09 Thread Armin Waibel
Hi, ABOU LINA wrote: thank first, PersistenceBroker *delete elements* from the database that have been removed from the collection only if i do this : for example : A 1:n B 1. i get A from database using OJB Broker. 2. i delete one element B from A : A.getBCollection().remove(o); in this case

Re: PB behavor of Collection item delete ?

2006-03-09 Thread ABOU LINA
Hi, ok so, i made DAO implementation with OJB PB in a critical project and we are in step of delivring some module of the application (the mainly module now are developped and tested). my question is : 1. what will be the cost of migrating from PB to ODMG. ??? 2. there are some tools making

Re: remove all references.

2006-03-09 Thread Armin Waibel
Hi Vagula, Vagula wrote: Hi All, I have a table A which references tables B C. The auto-retrieve of B C has been set to true. While I retrieve a record from table A can I some how stop the auto-retrieval of B C. Currently it's *not* possible to

Re: Problem with collection using ODMG API

2006-03-09 Thread Armin Waibel
Hi Eric, Eric Kelm wrote: Hi all- I am having a problem with 1:n collection in OJB using ODMG. Say I have a parent object, lets call it Trouble Ticket T with a collection of Ticket Notes N. Lets say that the objects retrieved in list N are n1, n2, n3. I perform a retrieval from the DB on

Change od Schema during Runtime

2006-03-09 Thread Guido Beutler
Hello, I would like to copy complex objects from schema A to schema B. This would run in a managed environment (JBoss EJB Server) The schema is configured at the XML Mapping, can I change this during runtime like 1) read data from schema A 2) change schema 3) store the same objects to schema B

Re: Misc questions

2006-03-09 Thread Jean-Yves Sironneau
I forgot to tell that to raise this issue i have to clear the persistencer cache, otherwise everything seem's to be ok. 2006/3/7, Jean-Yves Sironneau [EMAIL PROTECTED]: Hello, I looked more precisely at my issue regarding foreign keys not being set, so now i'am using official OJB 1.0.4.

Re: Misc questions

2006-03-09 Thread Jean-Yves Sironneau
Hello, I looked more precisely at my issue regarding foreign keys not being set, so now i'am using official OJB 1.0.4. The exact issue is that when i persist a new object (that has not been persisted before), the linked object is persisted and the foreign key is set. But when i retrieve an

Re: bad sql on n-m relation to subclassed object

2006-03-09 Thread Jakob Braeuchi
hi nicolas, we recently fixed a problem concening findObjectByIdentity see 'OJB and the X-Files... :)' in this case the sql looked ok, but the wrong object was materialized. if the problem still persists, could yu please post a testcase so i can try to reproduce it. thanks jakob DELAHAYE

ODMG; SequenceManager

2006-03-09 Thread ABOU LINA
Hi, i have DB2 database; i want to make a sequence on primary key of each table and not a global sequence for all table ??? how can i do it ?? thx

Re: PB behavor of Collection item delete ?

2006-03-09 Thread ABOU LINA
i think the coste of using ODMG is very big only looking how in ODMG we query an object. in ODMG it use OQL (like SQL synthaxis where ) so is very diferent to PB wiche use Criteria to build a condition ! what do you think Mr Armine On 3/9/06, ABOU LINA [EMAIL PROTECTED] wrote: Hi,

Spring Transactions

2006-03-09 Thread Saman Ghodsian
Hi there, I have an implementation of my model with OJB using just PersistenceBroker. Now I'm looking into adding transactional support, looked into ODMG but it seems complex to implement since all my mapping and query is in Broker lingo, so I'm looking at injecting Transaction support for my

Re: Report Query in ORDER BY

2006-03-09 Thread Vasily Ivanov
ok. I have no idea what jira is. Could you give me the link? On 3/10/06, Jakob Braeuchi [EMAIL PROTECTED] wrote: hi vasily, you're right. we do not support ordering by subquery. you can open a feature request on jira. jakob Vasily Ivanov schrieb: Hi Jakob, As I understand, report

Re: Spring Transactions

2006-03-09 Thread Thomas Dudziak
On 3/9/06, Saman Ghodsian [EMAIL PROTECTED] wrote: I have an implementation of my model with OJB using just PersistenceBroker. Now I'm looking into adding transactional support, looked into ODMG but it seems complex to implement since all my mapping and query is in Broker lingo, so I'm

Re: PB behavor of Collection item delete ?

2006-03-09 Thread Armin Waibel
Hi, ABOU LINA wrote: Hi, ok so, i made DAO implementation with OJB PB in a critical project and we are in step of delivring some module of the application (the mainly module now are developped and tested). my question is : 1. what will be the cost of migrating from PB to ODMG. ??? There

Re: ODMG; SequenceManager

2006-03-09 Thread Armin Waibel
Hi, ABOU LINA wrote: Hi, i have DB2 database; i want to make a sequence on primary key of each table and not a global sequence for all table ??? how can i do it ?? I don't know which SequenceManager you use. http://db.apache.org/ojb/docu/guides/sequencemanager.html Most implementations use

Re: Report Query in ORDER BY

2006-03-09 Thread Armin Waibel
Vasily Ivanov wrote: ok. I have no idea what jira is. Could you give me the link? It's the OJB issue tracking http://issues.apache.org/jira/browse/OJB regards, Armin On 3/10/06, Jakob Braeuchi [EMAIL PROTECTED] wrote: hi vasily, you're right. we do not support ordering by subquery. you

Re: PB behavor of Collection item delete ?

2006-03-09 Thread Armin Waibel
ABOU LINA wrote: i think the coste of using ODMG is very big only looking how in ODMG we query an object. in ODMG it use OQL (like SQL synthaxis where ) so is very diferent to PB wiche use Criteria to build a condition ! what do you think Mr Armine As said in my other post, it's

Re: Change od Schema during Runtime

2006-03-09 Thread Armin Waibel
Hi Guido, Guido Beutler wrote: Hello, I would like to copy complex objects from schema A to schema B. I suppose you mean copy data from one DB to another or from table A to table B within the same DB. This would run in a managed environment (JBoss EJB Server) The schema is configured at

Re: Spring Transactions

2006-03-09 Thread Dennis Bekkering
YES you need innoDB, myIsam does not support transactions, i guess you want transactions. regards, Dennis 2006/3/10, Thomas Dudziak [EMAIL PROTECTED]: On 3/9/06, Saman Ghodsian [EMAIL PROTECTED] wrote: I have an implementation of my model with OJB using just PersistenceBroker. Now I'm

Report Query in ORDER BY

2006-03-08 Thread Vasily Ivanov
Hi All, I've got two classes: class Parent: int id String data Collection children class Child: int id String data int parentId Parent parent I need to get collection of parents sorted by the number of children, but I didn't find any way to put Report Query to ORDER BY statement.

Re: NESTED OBJECT 1:n is possible ???

2006-03-08 Thread ABOU LINA
So first thank a lot for your helpful reply , example : Class A { long id; B bObject; } Class B { String name String phone; } In TABLE A : --- BIGINT id; STRING name; STRING phone; in this case we can use nested object in order to encapsulate field name

RE: OJB 1.0.4 Error: Oracle thin driver cannot insert CLOB values with length4000

2006-03-08 Thread Westfall, Eric Curtis
Hello, I added it. I messed up on the title but I think it's still clear ;) https://issues.apache.org/jira/browse/OJB-101 Thanks, Eric -Original Message- From: Thomas Dudziak [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 07, 2006 2:23 AM To: OJB Users List Subject: Re: OJB 1.0.4

Re: Derby configuration

2006-03-08 Thread Sean C. McCarthy
Hi Thomas, Works perfectly, just needed to adjust a couple field types for compatibility between MySQL and Derby and the same build works for both databases. Sean Thomas Dudziak wrote: On 3/6/06, Sean C. McCarthy [EMAIL PROTECTED] wrote: I'm trying to work with Derby, but I'm not

Re: Report Query in ORDER BY

2006-03-08 Thread Jakob Braeuchi
hi vasily, you can use Criteria.PARENT_QUERY_PREFIX to prefix an attribute of the subquery. see QueryTest#testSubQuery3 and testSubQuery4. but i've to admit i nver tried it with addOrderBy(). hth jakob Vasily Ivanov schrieb: Hi All, I've got two classes: class Parent: int id String

Re: Report Query in ORDER BY

2006-03-08 Thread Vasily Ivanov
Hi Jakob, As I understand, report subquery (with Criteria.PARENT_QUERY_PREFIX + id) can be used only in WHERE clause (Criteria class), but not in ORDER BY clause. Have a look: QueryByCriteria.addOrderBy(String, boolean) QueryByCriteria.addOrderBy(FieldHelper)

Sub classes and QueryByCriteria

2006-03-08 Thread Vasily Ivanov
Hi All, Are there any way to ask OJB not to query for subclasses when querying for parent class. For example, I've got: Class1 Class2 extends Class1 Class3 extends Class2 When I want to get the collection of Class1 objects I don't want to get all Class2 and Class3 objects, but OJB does it. I

Re: Sub classes and QueryByCriteria

2006-03-08 Thread Vasily Ivanov
Sorry, I've got it. I've just removed extent-class class-ref=Class2 / from Class1 class-descriptor. :) Thanks. On 3/9/06, Vasily Ivanov [EMAIL PROTECTED] wrote: Hi All, Are there any way to ask OJB not to query for subclasses when querying for parent class. For example, I've got: Class1

remove all references.

2006-03-08 Thread Vagula
Hi All, I have a table A which references tables B C. The auto-retrieve of B C has been set to true. While I retrieve a record from table A can I some how stop the auto-retrieval of B C. Thanks and Regards, Vagula

Re: Derby configuration

2006-03-07 Thread Thomas Dudziak
On 3/6/06, Sean C. McCarthy [EMAIL PROTECTED] wrote: I'm trying to work with Derby, but I'm not sure which DB to use for the torque.database property. Looking at the torque-gen I see there is a cloudscape, is cloudscape the name to set? Any other special configuration needed? Is there any

QueryByCriteria#addGroupBy question

2006-03-07 Thread Hiller, Frank RD-AS2
Hi, I'm using ojb1.0.3 and Oracle 10g. I tried to use QueryByCriteria#addGroupBy but I get the error java.sql.SQLException: ORA-00979: not a GROUP BY expression What's the way to retrieve a collection of objects, filtered with the group by attribute? Thanks, Frank

PB behavor of Collection item delete ?

2006-03-07 Thread ABOU LINA
Hi, in ojb document : --- Say you use the PB to query an object O that has a collection attribute col with five elements a,b,c,d,e. Next you delete Objects d and e from col and store O again with PersistenceBroker.store(O); PB will store the remaining objects

Re: QueryByCriteria#addGroupBy question

2006-03-07 Thread ABOU LINA
Hi, in ojb document : --- Say you use the PB to query an object O that has a collection attribute col with five elements a,b,c,d,e. Next you delete Objects d and e from col and store O again with PersistenceBroker.store(O); PB will store the remaining objects

NESTED OBJECT 1:n is possible ???

2006-03-07 Thread ABOU LINA
How can i use nested object in case of 1:n ?? it s possible in OJB

Re: ODMG ordering with circular pairs

2006-03-07 Thread Bruno CROS
Hi Armin. Hi all. Ok. Well, i discussed about the bug with the developer who found it. After we have inspected the code (really this time) we found the error. There's no more bug about modifying objects after flush. Now, we have established some important rules to code ODMG transactions (never

Re: PB behavor of Collection item delete ?

2006-03-07 Thread Armin Waibel
Hi, ABOU LINA wrote: Hi, in ojb document : --- Say you use the PB to query an object O that has a collection attribute col with five elements a,b,c,d,e. Next you delete Objects d and e from col and store O again with PersistenceBroker.store(O); PB will store

Re: NESTED OBJECT 1:n is possible ???

2006-03-07 Thread Armin Waibel
ABOU LINA wrote: How can i use nested object in case of 1:n ?? it s possible in OJB Sorry, I don't understand your question. In OJB nested objects can be used group and encapsulate fields of persistent objects. http://db.apache.org/ojb/docu/guides/advanced-technique.html#Nested+Objects

Borrow broker from pool failed

2006-03-07 Thread Rick Roman
I have been getting this error message intermittently. Would this message result from running out of connections, like I failed to close the broker in some function? Servlet.service() for servlet action threw exception org.apache.ojb.broker.PBFactoryException: Borrow broker from pool failed,

Re: ODMG ordering with circular pairs

2006-03-07 Thread Bruno CROS
Oups, a type error at the end of my mail. I don't think i will test this deeper, because you warned me about doing this (get object from other broker). That explains the strange behaviour we had. Regards. Sorry for mistake. On 3/7/06, Bruno CROS [EMAIL PROTECTED] wrote: Hi Armin. Hi

RE: OJB and the X-Files... :)

2006-03-06 Thread Christopher Lowe
Great! Thanks Armin and Jakob. Happy user again, Chris :) -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Sunday, March 05, 2006 6:08 AM To: OJB Users List Subject: Re: OJB and the X-Files... :) Hi Chris, it was fixed (by Jakob) in OJB_1_0_RELEASE branch and

EJB3 ?

2006-03-06 Thread Hale India
Hi This mail is just to ask about projects of OJB Team about EJB3. Now specification seems to me completed and stable and some OJB competitors has offer. EJB3 same already to be a standard. This seems to me a critical question about OJB future. Any answer welcome Andre

Re: EJB3 ?

2006-03-06 Thread Dennis Bekkering
OJB runs outside of a container, it is not really comparable. Also ojb criteria api is way better then anything out there. I like to stay far from things like select object(o) from Book o where lower(o.title) like '%java%'. regards, Dennis 2006/3/6, Hale India [EMAIL PROTECTED]: Hi This

Re: ODMG ordering with circular pairs

2006-03-06 Thread Armin Waibel
Hi Bruno, Bruno CROS wrote: Our first problem was, that, after commit, P1 was not referencing M in database. I deduced that after a flush(), new locked objects (before flush) can't reference new ones created before flush too (a second time). Humm, strange... we check all code : No apparent

Derby configuration

2006-03-06 Thread Sean C. McCarthy
Hi, I'm trying to work with Derby, but I'm not sure which DB to use for the torque.database property. Looking at the torque-gen I see there is a cloudscape, is cloudscape the name to set? Any other special configuration needed? Is there any example to follow? Sean C. McCarthy

RE: OJB 1.0.4 Error: Oracle thin driver cannot insert CLOB values with length4000

2006-03-06 Thread Byrne, Ailish M
This issue was related to the fact that we are using XAPool. Here is the explanation from the experts. I've cc'd them in case you have any questions. They patched our OJB 1.0.4 jar as a temporary solution. _ The problem here is the

Re: OJB 1.0.4 Error: Oracle thin driver cannot insert CLOB values with length4000

2006-03-06 Thread Thomas Dudziak
On 3/7/06, Byrne, Ailish M [EMAIL PROTECTED] wrote: This issue was related to the fact that we are using XAPool. Here is the explanation from the experts. I've cc'd them in case you have any questions. They patched our OJB 1.0.4 jar as a temporary solution.

Re: OJB and the X-Files... :)

2006-03-05 Thread Armin Waibel
Hi Chris, it was fixed (by Jakob) in OJB_1_0_RELEASE branch and will be included in OJB 1.0.5. regards, Armin Armin Waibel wrote: Hi Chris, Christopher Lowe wrote: Thanks Armin, Please let us know when it is fixed. When is OJB 1.0.5 scheduled to be released? Hope we can fix it in a

Re: OJB 1.0.4 Error: Oracle thin driver cannot insert CLOB values with length4000

2006-03-05 Thread Armin Waibel
Hi Ailish, please set log-level for PlatformOracle9iImpl to DEBUG (e.g. when using OJB console logging set entry in change entry org.apache.ojb.broker.platforms.PlatformOracle9iImpl.LogLevel=DEBUG). Do you get any notes about connection unwarp problems (... could not unwrap ...). Seems that

ODMG ordering with circular pairs

2006-03-04 Thread Bruno CROS
Hi all, hi Armin, I believe i noted a strange behaviour behaviour of new 1.0.4 ODMG ordering. Consider JIRA OJB-18. Before 1.0.4 , we used the given workaround. This means, that we put some flush() in strategical place to avoid all FK constraints. It worked fine. Now, with the OJB

<    7   8   9   10   11   12   13   14   15   16   >