RE: Blob : using Blob with Oracle / SqlServer - MSDE / HsqlDB

2005-05-18 Thread Jacques Desmazieres
Thanks, I have investigated deeper, and actually the probleme comes from a middleware layer we had to develop in order to be able to use the Odbc bridge with OJB (this driver is no more supported since 1.0.1 as OJB does not respect the constraint of accessing the result set columns in the same ord

Re: Closing DB connections

2005-05-18 Thread =?ISO-8859-1?Q?Martin_Kal=E9n?=
Branko Matijasevic wrote: I am creating OJB connections dynamically based on user input: This is not very easily done in OJB 1.0.x. The handling of this has been refactored for OJB 1.1 and I doubt any major improvents are likely to be back-ported to the maintenance branch. There is a technology pre

Re: Executing plain SQL UPDATE statments in PB transactions

2005-05-18 Thread Martin Kalén
wilson lists wrote: I need to run a plain SQL Update inside a PersistenceBroker transaction. The DBMS is Oracle 8. Trimming your example a bit: broker = PersistenceBrokerFactory.createPersistenceBroker(pbKey); broker.beginTransaction(); conn = broker.serviceCo

Re: OJB cache :: Best Practise

2005-05-18 Thread Martin Kalén
Nils Liebelt wrote: Having some trouble with the OJB caching. I use the default implementation which should give a global cache for all Brokers. My Business objects have a store() method that inserts/updates this object towards the db and removes this object from the cache with the removeFromCach

Re: P6Spy config

2005-05-18 Thread Martin Kalén
Charles Anthony wrote: Just a note on p6spy which may, or may not, be relevant : I've often had problems with processes finding the p6spy.properties file - it always seems to work for me if the file is in the "current" directory when the process starts. So, for tomcat, for example, it seems to read

Re: Oracle9i BLOB w/ JNDI datasource on WebLogic

2005-05-18 Thread Martin Kalén
Bobby Lawrence wrote: Nevermind on any of this... I have found the solutioneither upgrade to >= OJB 1.0.2, or use WLOracle9i platform. Hi Bobby, since I have been working a bit in this area I do actually mind - even if it now works for you. :) I am interested in feedback from users running OJB

Re: identity column

2005-05-18 Thread Martin Kalén
Vagula wrote: I have an identity column in my database. Lets day for example in Activity table we have identity column act_code. What are the steps I should be following? Do you want to: a) just map ACTIVITY.ACT_CODE as primary key in OJB? b) use database sequenc

Re: OJB-JDO why sequence increment in retrieve

2005-05-18 Thread Martin Kalén
Alessandro Vincelli wrote: I have tried, but I have had great problems. Tomcat always says: Message: Scheduler with name 'Cocoon' already exists. This is only the effect of a previous error. Cocoon has the following web.xml configuration: 1 This means that Tomcat will load Cocoon at Tomcat start (

Re: bidirectional 1:1 mapping not working with OJB?

2005-05-18 Thread Martin Kalén
Torsten Liermann wrote: I need a bi-directional mapping between 'Project' <-> 'ProjectTeam'. OJB set the relation form 'Project' to 'ProjectTeam' nice, but the link from 'ProjectTeam' to 'Project' was not updated. What is wrong? Thanks for help. Tell us a bit more about your use-case, specifical

Re: how to clear a jdbc connection descriptor and associated connections?

2005-05-18 Thread Martin Kalén
Adam Jenkins wrote: I have a test case where, in the setUp method, I create a hypersonic database (random dbalias), run the table set up scripts, run my tests (using dbunit) then, in the tearDown method I swap out the descriptor and delete the database in preparation for the next test. I'm having a

Re: Future of OJB?

2005-05-18 Thread Martin Kalén
Cesar Leite wrote: the project OJB will be interrupted? I certainly do not hope so! In that case, they forgot to tell me. ;) Cheers, Martin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTEC

Re: Out of Memory on Large ResultSets/Needed: SetFetchSize Method

2005-05-18 Thread Martin Kalén
Andreas Bohnert wrote: I have just run several tests with different hints. It works very well, however, if I don't set a hint, no cursors are used, even with getIteratorByQuery! Good to hear that it's working well! But maybe that's not too bad. If you enable cursors on iterators by default, MySq

Collection Query

2005-05-18 Thread Kirill Petrov
Hello everybody, I have an object model in which there are two objects: Model and Reactant. This is basically n to m relationship. Model can have a number of Reactants. Reactants can be in a number of Models. In Java this is emplemented by a Collection property in Model class. I want to construc

Closing DB connections

2005-05-18 Thread Branko Matijasevic
Hi, I am creating OJB connections dynamically based on user input: m_connDesc = new JdbcConnectionDescriptor(); // set the user's conn. parameters, and then... MetadataManager.getInstance().connectionRepository().addDescriptor(m_con nDesc); PersistenceBroker broker = PersistenceBrokerFactory.cr

Re: Using user defined Collections

2005-05-18 Thread Thomas Dudziak
On 5/18/05, Lemke, Wesley <[EMAIL PROTECTED]> wrote: > I am still getting this error: > > [5/18/05 9:57:20:166 CDT] 74345b16 SystemOut O [PersistentField] > ERROR: while set field: > [try to set 'object value' in 'target object' > target obj class: com.lmig.pm.affinity.model.client.account.Acc

RE: Using user defined Collections

2005-05-18 Thread Steve_Clark
According to the error message, OJB is trying to set a field whose type is DatedList ("target field type") with a value which is a RemovalAwareCollection ("object value class"). This is probably because you aren't setting collection-class in the collection-descriptor. In 1.0.2, AFAIK RemovalA

Executing plain SQL UPDATE statments in PB transactions

2005-05-18 Thread wilson lists
Hi, I am sorry if this is a trivial question, but I was unable to find an answer in OJB documentation or other Internet sources. I need to run a plain SQL Update inside a PersistenceBroker transaction. The DBMS is Oracle 8. My solution is: //--

RE: Using user defined Collections

2005-05-18 Thread Lemke, Wesley
I am still getting this error: [5/18/05 9:57:20:166 CDT] 74345b16 SystemOut O [PersistentField] ERROR: while set field: [try to set 'object value' in 'target object' target obj class: com.lmig.pm.affinity.model.client.account.AccountTeam target field name: accountManagers target field type: c

RE: Blob : using Blob with Oracle / SqlServer - MSDE / HsqlDB

2005-05-18 Thread Jacques Desmazieres
Thanks for your help, > Hsqldb can deal with binary data, though from what I gather from the > doc, it does not understand the BLOB/CLOB datatypes but rather uses > LONGVARBINARY and LONGVARCHAR. However the hsqldb jdbc driver seems to > implement the Blob-handling API so you should be safe using

Re: Blob : using Blob with Oracle / SqlServer - MSDE / HsqlDB

2005-05-18 Thread Thomas Dudziak
On 5/18/05, Jacques Desmazieres <[EMAIL PROTECTED]> wrote: > We have an application running OJB on Oracle 8i / 9i, HsqlDB and MSDE. As we > add functionalities we now have to include large binary object (actually to > store pdf content). > > My problem, is that I do not want to have mapping files

Blob : using Blob with Oracle / SqlServer - MSDE / HsqlDB

2005-05-18 Thread Jacques Desmazieres
Hi, We have an application running OJB on Oracle 8i / 9i, HsqlDB and MSDE. As we add functionalities we now have to include large binary object (actually to store pdf content). My problem, is that I do not want to have mapping files depending on the database. The application is working for Oracl