Oracle's CLOB

2003-06-03 Thread Samuel Kerrien
Hi, I'm wandering what is the current state of LOB support in OJB. Here is what I've found on the OJB web site ... a bit thin. http://db.apache.org/ojb/howto-use-lobs.html If anybody have an idea about or some useful URL ... it would be great ! Thanks in advance. Samuel --

Elegant way of getting one connection per user?

2003-06-03 Thread Chris Halverson
I'm starting a new project w/ OJB and the business requirements state that everybody has to log into the Oracle instance with their own username and password that has been setup in Oracle (Oracle security, not a table that has un/pw, but actual Oracle users). In a previous project that had to do

Re: Limited collection returned

2003-06-03 Thread Jin Bal
Thanks for the detailed insight! OJB172 was the bug I saw on the dev list# I'll get back to about the eager-release when I get home. Interestingly I've just realised that this bug began manifesting itself after I attempted to port my setup to jboss 3.x from tomcat 4.x I did attempt to back out

Re: Inheritance issue

2003-06-03 Thread Thomas Mahler
Hi Alen, You have to tell OJB that there is an inheritance hierarchy. You do it by defining extents. There is an example for this in repository_junit.xml. Have a look at definitions for classes Article, BookArticle, CdArticle. cheers, Thomas Alen Ribic wrote: Hi all I have a bit of a problem

Re: Limited collection returned

2003-06-03 Thread Thomas Mahler
Hi Gary, Gary Richards wrote: Hi everyone, snip RsIterator problem I have noticed that the message given by this exception ex (which is not logged, only gets caught) is Operation not allowed after ResultSet closed. This certainly suggests that something has closed the ResultSet before the

RE: Limited collection returned

2003-06-03 Thread McCaffrey, John G.
Thanks for your investigation Gary. This is exactly what I was suspecting (RSIterator not iterating), now I guess the thing is to figure out how the result set got closed. I am not sure why there seem to be only a few people having this problem, it seems like such basic functionality that there

Re: Inheritance issue

2003-06-03 Thread Alen Ribic
thanks - Original Message - From: Thomas Mahler [EMAIL PROTECTED] To: OJB Users List [EMAIL PROTECTED] Sent: Monday, June 02, 2003 4:38 PM Subject: Re: Inheritance issue Hi Alen, You have to tell OJB that there is an inheritance hierarchy. You do it by defining extents. There is an

Re: Elegant way of getting one connection per user?

2003-06-03 Thread Chris Halverson
Thomas Mahler [EMAIL PROTECTED] writes: Runtime says and create the properties on the fly. Is there a better, more accepted way? Not that I know of. :-( That's what I thought :( This is really the lamest excuse I ever heared for not using a single application user account! Why don't the

RE: Limited collection returned

2003-06-03 Thread McCaffrey, John G.
I take that back, setting eager-release=true had no impact on my results (I had changed something else, Foolish me) -John -Original Message- From: McCaffrey, John G. Sent: Monday, June 02, 2003 11:57 AM To: 'OJB Users List' Subject: RE: Limited collection returned Gary, I tried

RE: Limited collection returned

2003-06-03 Thread Gary Richards
Hi, It's almost certain (at least for me with JBoss) the eager-release. I turned it off and everything i expected came back through the query. Did get a few stack traces of the sort [CachedConnectionManager] Successfully closed a connection for you. Please close them yourself: [EMAIL

Re: How to prevent?

2003-06-03 Thread Miroslav Lazarevi
On Saturday 31 May 2003 09:35, Miroslav Lazarevi wrote: A liitle addon. This is what I get in HSqldb properties file after removing user object from job. SET AUTOCOMMIT FALSE DELETE FROM DC_JOBS WHERE JOB=1 INSERT INTO DC_JOBS VALUES(1,'Administrator') DELETE FROM DC_USERS_JOBS WHERE

msaccess memo and ole object types

2003-06-03 Thread Mark Neighbors
Hi, Does anyone have the correct configuration for msaccess memo and ole object types? The configuration listed here causes a hangup in the sun.jdbc.odbc classes. The thread dump from a ctl-break is also listed below. Thanks in advance, Mark

RE: Limited collection returned

2003-06-03 Thread Matthew Baird
eager-release was put in to work around a problem with a leaked connection in JBoss when using managed transactions. I remember at the time thinking the solution stunk a bit, but Armin was in the middle of a big refactoring of the connection stuff and people just needed it to work. I'm

Cache question

2003-06-03 Thread Patrick_Reyes
Hi guys, I am quite sure this is the right behavior of the cache, but I would like some clarifications. 1) I read the content of a table and store the corresponding objects in a Collection. 2) I update the content of the objects. 3) I re-read the content of the table without updating the modified

Re: msaccess memo and ole object types

2003-06-03 Thread Thomas Mahler
Hi Mark, I don't believe you will have much success using access via the JdbcOdbcBridge. 1. Limitations of Access. We had to tweak OJB at several places to make it work at all (other O/R tools do not even support Access!). For example Access does not support transactions. 2. Limitations of

R: R: SequenceManagerHighLowImpl: trouble on rc3 - SOLVED?

2003-06-03 Thread Farnea Massimiliano
a, Just to check: are you saying that it is possible to use the latest JDBC driver (that comes with Oracle 9.x) with Oracle 8.1.7? Do you have a link to more information about possible issues doing this? Thanks, I'm using the classes12-g.zip (i'm still on JDK1.3) JDBC Driver for Oracle 9.2

Extent. How to?

2003-06-03 Thread Alen Ribic
Hi again I have sent an email already and got a good reply, but now I have an issue with mapping side. I have got classes as follows: // JavaBean public class User extends ValidatorForm {} // Struts form bean public class RegisterForm extends User {} Now I just need OJB to recognize

Re: Extent. How to?

2003-06-03 Thread Raymond Barlow
Hi Alen I hate to ask the obvious, but you never know :) Have you created a mapping for za.co.alen.struts.RegisterForm in your repository_user.xml file?? Regards, Raymond Barlow Alen Ribic wrote: Hi again I have sent an email already and got a good reply, but now I have an issue with mapping

Re: Cache question

2003-06-03 Thread Thomas Mahler
Hi Patrick, [EMAIL PROTECTED] wrote: Hi guys, I am quite sure this is the right behavior of the cache, but I would like some clarifications. 1) I read the content of a table and store the corresponding objects in a Collection. 2) I update the content of the objects. 3) I re-read the content of

Re: Extent. How to?

2003-06-03 Thread Raymond Barlow
Sorry, just reread your email. Yes, you do need to define a mapping ( a class-descriptor) for the RegisterForm class. Regrads, Raymond Barlow Alen Ribic wrote: Hi again I have sent an email already and got a good reply, but now I have an issue with mapping side. I have got classes as follows:

Re: Extent. How to?

2003-06-03 Thread Alen Ribic
Thanks Raymond for your reply. This is the thing. I am very lost. The User class descriptor in repository contains all my filed mappings to my User table in db. Now za.co.alen.struts.RegisterForm class mapping is a very good question. What would the za.co.alen.struts.RegisterForm class mapping

Re: Cache question

2003-06-03 Thread Patrick_Reyes
Thanks for your answers Thomas, great reply as usual! Now I have another question. Is having a global cash not quite dangerous in a multiuser environnment ? I.E. A different user might change an object that is not comitted, what if the originator doesn't commit the original changes later ? When

Re: Cache question

2003-06-03 Thread Patrick_Reyes
3. you can use the PerBrokerCache so that changes to cached objects are only visible within one thread. I don't seem to be able to find PerBrokerCache. What is the consequence of the cached objects being only visible within one thread ? By default OJB uses a global cache, so changes to any

RE: Limited collection returned

2003-06-03 Thread Gary Richards
Hi everyone, A slight correction to my previous post. I noticed I pasted the same exception twice. What I meant to say about the ODMG insert was... ... ... ... Unfortuanately inserts don't seem to work for ODMG when setting eager-release to false. I get a first stack trace, 08:51:44,603 INFO

Re: Extent. How to?

2003-06-03 Thread Raymond Barlow
Hi Alen, I'm fairly new to OJB, but I'm pretty sure that you would have to define a class-descriptor for the RegisterForm class. Just try this for now to see if it fixes your problem: copy the entire User class descriptor into a new RegisterForm class descriptor and just change the relevant

Re: Cache question

2003-06-03 Thread Thomas Mahler
[EMAIL PROTECTED] wrote: 3. you can use the PerBrokerCache so that changes to cached objects are only visible within one thread. I don't seem to be able to find PerBrokerCache. See OJB.properties file: # #

Re: Cache question

2003-06-03 Thread Patrick_Reyes
To avoid problems you should use Optimistic Locking (OL) to avoid write conflicts. How do you set it up ? And if you don't want to handle many OL exception you can set refresh=true for all persistent classes. Which means there will be no caching at all. Regards, Patrick Reyes

Re: Extent. How to?

2003-06-03 Thread Thomas Mahler
Hi again Alen. I think you should define the extent the other way round. That is: RegisterForm is the abstract base class and User is the concrete class defining all the persistent attributes. class-descriptor class=za.co.alen.struts.RegisterForm extent-class

OJB XDoclet module problem

2003-06-03 Thread Jim JXR
Hi, I wonder if anyone checked out the xdoclet module for OJB? I tried it and it seems that there's some problems with fields inherited from superclass. Basically, if a field of the superclass is marked by ojb.field tag, but the superclass itself is not marked by ojb.class, then this field will

Re: Cache question

2003-06-03 Thread Thomas Mahler
[EMAIL PROTECTED] wrote: To avoid problems you should use Optimistic Locking (OL) to avoid write conflicts. How do you set it up ? see http://db.apache.org/ojb/repository.html#field-descriptor for a description of the locking attribute. There are several samples in the repository_junit.xml.

NullPointerException while persisting

2003-06-03 Thread Michael Schua
Hello Ladies and Gentlemen, I need your help please. Storing the following data structures to the data base keeps ending up in a NullPointerException no matter what I try. BenutzerBO - m:n - PrivilegeBO - 1:n - ActionBO My configuration: OJB 1.1 rc3. MySQL 3.23.52 (as shipped with Suse-Linux

ODMG and collection descriptor

2003-06-03 Thread Miroslav Lazarevi
Hi, I have a question about collection descriptor's auto-retrieve, auto-update and auto-delete attributes when using ODMG API. In documentation is written that for OTM, ODMG and JDO auto-retrieve=true, auto-update=false and auto-delete=false. I have a two classes which everyone contain

RE: OJB XDoclet module problem

2003-06-03 Thread Gary Richards
Hi Jim , We've only OJBDocleted a very small part of our model to date but are happy with the current results. The bit we have modeled is like yours, a superclass with inherited members. Presumably you don't wan't the superclass present as a table, but you want the subclasses to have the