Re: what's with OJB Project?

Hello, I also have been working with ojb for many years now and also worked with hibernate but only when I have to. Ojb has a marketing problem but for me that is not a problem. To tell you the truth there is nothing missing in Ojb, it does exactly what I need, no more no less. Best Regards,

Re: QueryBySQL

Hi, you could create a view and map that on a class that represents that view, then you dont need QueryBySQL. regards, Dennis 2007/7/24, krupa [EMAIL PROTECTED]: Hi All, I have several SQLs already written. I want to use QueryBySQL to use the existing SQLs. The problem I am facing is how

Re: massive performance problem with q.setStartAtIndex() and q.setEndAtIndex()

I think that is because ojb does not add the LIMIT thing to the query. Only the objects in the range are materialized but everything is selected from the DB. I guess it is becasue it is not standard SQL, every DB has its own way. 2007/3/20, Björn Agel [EMAIL PROTECTED]: hi there, i figured

Re: Borrow broker from pool failed. in production server

when i have a quick look it seems to be about the broker pool and not the connection pool. Check your OJB.properties and set maxActive to the same value as maxActive of the connection pool settings in repository_database.xml. I am not sure about it but your problem happened to me once this way

Re: removal aware list

I tried to reproduce your test (m:n reference + proxy) without success - I always get a ManageableArrayList instance. I'm using latest from SVN (OJB_1_0_RELEASE branch). Could you exactly describe how to reproduce your problem. regards, Armin While describing i found out that there was another

Re: removal aware list

, if you are not using 1.0.3 or 1.0.4, upgrade your version (check mail list about changes that could affect your upgrade). Regards, Richter Dennis Bekkering escreveu: Hello all, I have an M:N collection that has a ManageableArrayList as collection class and proxy set to true. But when

Re: mysql pool problem (again)

Martin, Thanks for the help. As usual i was to fast with conclusions, my problems at the time originated from a connection leak. Thanks, Dennis 2006/8/8, Martin Kalén [EMAIL PROTECTED]: Dennis Bekkering skrev: A validation query doesn't help in the MySQL scenario: The driver

java.util.NoSuchElementException after stesstest

Hello, After and while running a stresstest with a tool i get the following error. My code stops at PersistenceBrokerFactory.defaultPersistenceBroker(). I know it is imposible to see what is happening from the trace and that it happens in apache - commons code but maybe somebody has seen this

Re: java.util.NoSuchElementException after stesstest

Hello Armin, If you run stress tests on OJB please make sure that the maximal active PB instances setting and the maximal active connections setting in ConnectionFactory (see repository file connection-pool http://db.apache.org/ojb/docu/guides/repository.html#connection-pool-N10251 ) is

Re: java.util.NoSuchElementException after stesstest

Armin, You are right. I run a test with latest from SVN (OJB_1_0_RELEASE branch) with whenExhaustedAction=2 and it works as expected. Wrong OJB.properties file in your classpath? regards, Armin I actually dont use OJB.properties but repository-database.xml for pool settings. The

Re: java.util.NoSuchElementException after stesstest

Within the connection-pool element you set the size of the connection-pool, in the OJB.properties file you set the size of the PB-pool (this is not the same). Thus you need both settings. It's obvious that the PB-pool size should always greater or equals to the connection-pool size. regards,

Re: ORA-00932 inconsistent datatypes with CLOB

Hello Steve, What does your criteria code look like? I have the same problem when applying like operation on a CLOB. I therefore changed the fieldtype to varchar2(4000). Cheers, Dennis

Re: mysql pool problem (again)

Hello Armin, I'm confused. How does this happen. OJB always use ConnectionFactory#lookupConnection to lookup connections and doesn't differ between transactional and non-transactional connections, thus the validation query is always performed. The only difference is the lifetime of the

Re: mysql pool problem (again)

Hello Tom, Hmm, I'm not too sure why you need this behavior, but I think you should definitely ask the DBCP guys over at the commons-user mailing list. I checked OJB.properties and I am using ConnectionFactoryPooledImpl.class . I kill the connections with the mysql administrator tool,

mysql pool problem (again)

Hello all, I am experiecing problems with mysql regarding connection time outs again. This problem cannot be resolved by the pool settings provided or jdbc driver settings such as autoReconnect (wich should not be used anyhow). Here is a more detailed explaination about the problem (from tss). I

oracle id in m:n tables

Hello All, When i add a record to a collection that is of type many 2 many the following sql is executed INSERT INTO m2m_196 (ruleValueListId,ruleValueId) VALUES (?,?) , the id field is not specified in the query but the table has such a field and therefore oracle complains about the fact that

Re: oracle id in m:n tables

Thanks for the link Tom, that information was exactly what i was looking for. 2006/6/19, Thomas Dudziak [EMAIL PROTECTED]: On 6/19/06, Dennis Bekkering [EMAIL PROTECTED] wrote: When i add a record to a collection that is of type many 2 many the following sql is executed INSERT

Re: generate global uid's

Sorry, nope! At the beginning of OJB some people plan to support beside RDBMS and other persistence datastores, but it was too complex to realize with a few OJB committer. Thanks for clearing out, where exactly lies the complexity, the quering i solved my own project. I have the biggest

Re: generate global uid's

for instance use db4objects with OJB? Cheers, Dennis 2006/5/13, Dennis Bekkering [EMAIL PROTECTED]: All, I converted all my int id's and refs to varchar id's and ref's, i offcourse updated the repository file also. Now it seems that OJB expects id's to be of type int in 1:N and M:N relations. I get

Re: generate global uid's

All, I converted all my int id's and refs to varchar id's and ref's, i offcourse updated the repository file also. Now it seems that OJB expects id's to be of type int in 1:N and M:N relations. I get errors regarding select where id IN (?,?,?,?,?). I did not really looked in the source yet at

Re: generate global uid's

SequenceManagerMSSQLGuidImpl). regards, Armin Dennis Bekkering wrote: great, thanks! 2006/4/24, Thomas Mahler [EMAIL PROTECTED]: Hi Dennis, org.apache.ojb.broker.util.GUIDFactory produces GUIDs that are unique across different VMs. cheers, Thomas Dennis Bekkering wrote: Hello all, I have a situation where i

Re: generate global uid's

great, thanks! 2006/4/24, Thomas Mahler [EMAIL PROTECTED]: Hi Dennis, org.apache.ojb.broker.util.GUIDFactory produces GUIDs that are unique across different VMs. cheers, Thomas Dennis Bekkering wrote: Hello all, I have a situation where i frequently have to merge data from

generate global uid's

Hello all, I have a situation where i frequently have to merge data from different databases. Uptill now every database has it's own sequence. That means that i cannot merge the data blindly because two records with the same id might not be the same record. I am thinking of switching from int

Re: ojb start ?

Hibernate gives (way) more headache because of very unclear error messages. Hibernate does a lot of checking (therefore more unclear error messages) and safes programmers for mistakes more than OJB. Hibernate is session based wich means that your object tree has boundaries outside the session

Re: Spring Transactions

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

Re: EJB3 ?

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: Help needed for Transaction Rollbacks

I think OTM is kind of deprecated, but i don't know if it's important for this issue. In my mind when you do a commit a transaction, if something fails, no step of the transaction should have been commited, so maybe your database do not support transactions. I also wonder what the OTM

Re: Problem with signed applet.

the applet can propbably not find the repository in it's class path. Try to stuff everything in a jar and use that jar instead of a single class. 2006/2/1, alessandro olivieri [EMAIL PROTECTED]: Hi, I'm using ojb 1.0 rc1 in a signed applet. Without warning, this applet is not working when I

Re: OJB_HL_SEQ

I had the same problem and fixed it by removing field-descriptor name=name column=FIELDNAME jdbc-type=VARCHAR primarykey=true / from class-descriptor class=org.apache.ojb.broker.util.sequence.HighLowSequence table=ojb_hl_seq in

Re: lazy loading 1.0.4

Armin, I looked at it a little better and it is because i have my own cache for model and view objects because they are used so much. I think that I also understand why the initial organisation query only queries the organisation and country table while there are a lot more references. When the

ERROR: Can't lookup new HighLowSequence for field id using sequence name SEQ_appointment

Hi, 1.0.4 seem to be case sensitive or something else is wrong, anyway when I change SEQ_Appointment to SEQ_appointment in the ojb_hl_seq table I still get the error. It will propbably be OK when I restart my server but I like to do that at night and not in the middle of the day. Is there a way

Caused by: org.apache.ojb.broker.util.sequence.SequenceManagerException: Can't build new sequence

Hi, In my previous mail I said that it would probably be OK if I restart the server. I made sure there is an entry SEQ_appointment but I still cannot insert records due to this error. Any hints? thanks, Dennis

Re: Caused by: org.apache.ojb.broker.util.sequence.SequenceManagerException: Can't build new sequence

excuse me for doing before reading;). I replaced the repository_internal and it is OK now. Thanks! 2006/1/10, Armin Waibel [EMAIL PROTECTED]: Hi Dennis, Dennis Bekkering wrote: Hi, In my previous mail I said that it would probably be OK if I restart the server. I made sure

Re: broken pipe?

my driver was and is mysql-connector-java-3.1.5-gamma-bin.jar so I updated to jdbc level 3. Will update to 1.0.3 tonight if lazy is still lazy. 2006/1/9, Thomas Dudziak [EMAIL PROTECTED]: On 1/9/06, Dennis Bekkering [EMAIL PROTECTED] wrote: The whole thing looks like this now, I don't use

Re: lazy loading 1.0.4

to declare the cache within the jdbc-connection-descriptor using a object-cache element. http://db.apache.org/ojb/docu/guides/objectcache.html regards, Armin Dennis Bekkering wrote: Hello, I recently switched from rc7 to 1.0.4 and lazy loading seem to happen any more. Can someone please

Re: broken pipe?

everything is on 1.0.4 now. I also updated all my other libraries with the latest. The jdbc level is 3, lets wait and see. If it still fails I will have to modify the pool class(es) I guess. 2006/1/9, Dennis Bekkering [EMAIL PROTECTED]: my driver was and is mysql-connector-java-3.1.5-gamma

lazy loading 1.0.4

Hello, I recently switched from rc7 to 1.0.4 and lazy loading seem to happen any more. Can someone please check my config out. 1.0.4 fires twice as much queries? thanks. sql output get all organisations 1.0.4 just after clear cache

Re: broken pipe?

I asked my provider and they didn't change anything. They pointed out the possible absence of autoReconnect=true in my JDBC url. Does anybody knows if that might help. I'd rather have that than a ping query for every call. Thanks, Dennis 2006/1/4, Dennis Bekkering [EMAIL PROTECTED]: Thomas

Re: broken pipe?

i added testOnBorrow=true validationQuery=SELECT 1 to the descriptor, I'l wait and see what happens. Dennis 2006/1/5, Thomas Dudziak [EMAIL PROTECTED]: On 1/5/06, Dennis Bekkering [EMAIL PROTECTED] wrote: I asked my provider and they didn't change anything

Re: broken pipe?

Thomas, I'v been using OJB for years now and it is the first time that I get it. Maybe my provider changed something, i will check that out. My descriptor looks like this for quite a while now : !-- this connection was used as the default one within OJB -- jdbc-connection-descriptor

otm transactions

Hello, I don't understand the following, how those the kit know if the connection already is in a transaction? public Iterator moreRealisticQueryByCriteria(Query query, int lock) { OTMKit kit = SimpleKit.getInstance(); OTMConnection conn = null; Transaction tx = null; try

Re: OJB/JSP app: how to structure it?

You most certainly don't want to code business functionality right into the JSP. Your project sounds like it would benefit from the Struts framework, have a look here: http://jakarta.apache.org/struts/ and here for a tutorial: http://www.fawcette.com/javapro/2002_07/online/kjones/ Also,

a lot of delete statements on insert m:n rc7

Hello, I have a simple unit test class : public static String id; public AppointmentDelegateTest(String arg0) throws Exception { super(arg0); Appointment appointment = new Appointment(); User user = new User(); appointment.setUser(user); appointment.setCreationDate( new

Re: a lot of delete statements on insert m:n rc7

: dennis bekkering [EMAIL PROTECTED] To: OJB Users List [EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 4:05 AM Subject: a lot of delete statements on insert m:n rc7 Hello, I have a simple unit test class : public static String id; public AppointmentDelegateTest(String arg0) throws Exception

Re: joining

: Wednesday, June 09, 2004 9:39 PM Subject: Re: joining hi dennis, how does the classdescriptor for Contact look ? jakob dennis bekkering wrote: Hello, I have class Mail with some collections that return contacts. public class Mail { private Collection attachementList = new

transaction spanning multiple methods

Hello, I have a general question about use of transactions , i am not really confidend in this area. I have delegate classes to store and get objects from the database. eg ContactDelegate.storeContact() and MailDelegate.storeMail() and so on ... I like to reuse those methods and dont want to