Re: Clustering for OJB

Vamsi Atluri wrote: > Thanks for the response. In our situation, the users do use the same > database. Does doing a broker.clearCache() before every broker operation > overcome the stale data issue? We don't use any cache to make sure that the user is working with the current data records. But yo

Re: How can I insert a null value into an int field?

Christopher Cheng wrote: > I am using SQL Server 2000 and I want to insert a null value into a field > instead of 0. > How could I do that in OJB? To insert also null values we use Integer, Long and so on instead of their primitive complement. regards, Thomas -

Re: newbie can't get started

[EMAIL PROTECTED] wrote: > Can anyone point me to a "getting started" kind of document? Only follow the link: http://db.apache.org/ojb/docu/getting-started.html regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For a

Re: howto query this

Hans Novak wrote: > Can you give me a hint howto realize that ? I'll take a closer look to your statements and tables and try it. Did you publish all your terms so that I can find them into the previous mails? Regards, Thomas -

Re: howto query this

Hans Novak wrote: > yes, this was my first way too. But the "addSql" will insert this sql > script after "select ... from .. [here will be inserted]" I see. Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additi

Re: howto query this

Hans Novak wrote: > How can i use the ReportQueryByCriteria with more then one class, or is > it a chance to give the broker a native SQL script, without a class ? Maybe in this case you need a special class with your preferred reference descriptors? Regards, Thomas ---

Re: howto query this

Hi Hans, > PLEASE PLEASE HELP ME ! How about to use ReportQueryByCriteria and the Criteria#addSql method? I think it's the best way to perform this. Hope I could help! Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For addi

Re: how to trace ojb query generated sql

Tuna Ozkasap wrote: > Hi every one, I need to find out how to see the generated sql for an OJB > query? You'll find your answer there: http://db.apache.org/ojb/docu/faq.html regards, Thomas - To unsubscribe, e-mail: [EMAIL PRO

Re: NoSuchElementException

Thomas Franke wrote: > org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the > execution of the query (for de.mhr.wis.DBAdapter.rawdata.analyses.Logbuch): > Cannot write sorted rows. We got it. It seems with the latest driver we solved the problem. The except

Re: NoSuchElementException

Hi Armin, > It could be a jdbc-driver problem It seems that it is really a driver problem. We changed the driver to the latest version and the exception changed too. ;) The exception comes directly from the jdbc driver. Here is the stack trace in full: 11.11.2005 18:06:41 [ERROR] de.mhr.wis.DBAd

Re: NoSuchElementException

Hi Armin, > I setup a test against the latest version of OJB_1_0_RELEASE branch > using maxDB and hsql with an empty table. That's great, thanks. > All tests pass without problems. So we have isolate your issue (not > really ;-)): It could be a jdbc-driver problem or a bug in an older > version o

NoSuchElementException

Hello there, if we call log = (Logbuch) broker.getObjectByQuery(query); we get a NoSuchElementException. At the moment because of a fresh database we know there aren't any records. We're using Informix Dynamik Server 9.4 and Informix JDBC.3.00.JC1 driver. I could imagine it is rather a jdbc dri

Re: PlatformInformixImpl

Hi Armin, > Would it be possible to use INTEGER in Informix too? Ask this because I want > to move #prepareNextValProcedureStatement implementation method to > PlatformDefaultImpl. I could do that but I'll explain you why I did this decision. First of all the SequenceManagerStoredProcedureImpl#bu

Re: PlatformInformixImpl

Thomas Dudziak wrote: > but this seems to be down at the moment. But I guess it will be online > again in a couple of hours. Thanks, I'll try it. Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comman

Re: PlatformInformixImpl

Thomas Dudziak wrote: > Thanks! > Could you perhaps create a feature request in JIRA and attach the source > there ? > Would you be willing to run the unit tests when we cut new releases ? Yes, I will both of them. But I could need a little help. Where can I do the first one? Regards, Thomas -

PlatformInformixImpl

Hello Armin, I implemented the prepareNextValProcedureStatement() method in the class above. Now the SequenceManagerStoredProcedureImpl works also together with Informix. This implementation is tested against Informix Dynamik Server 9.4 and the Informix JDBC.3.00.JC1 driver. I attached also the s

Re: Informix + SequenceManagerHighLowImpl

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Armin, > Have a look in method > SequenceManagerHighLowImpl#lookupStoreSequence(PersistenceBroker broker, > FieldDescriptor field, String seqName) > this method is called to store/lookup a HighLowSequence instance. > > OJB first lookup a HighLowSe

Informix + SequenceManagerHighLowImpl

Hello there, we use in one case Informix and the org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl as the sequence manager. First it seemed good but then we must realize that we can't create a new record, if we didn't create a record in the rdbms before using OJB. So if we want to cre

Re: impossibly long insert time for one object

Charles Harvey III wrote: > Any ideas? Could it be the data structure? A setting in OJB? Something > wrong with the database (MSSQL)? How about to try your statement without OJB e.g. only with JDBC? So you could figure out if it is an OJB or another problem. Maybe you are using the wrong drive

Re: problems with autoincrement tables

Thomas Franke wrote: > I think that isn't the right way. We use also autoincrement fields with MySQL > and the "org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl" and > it works without those problems. With Oracle and Informix we don't use > autoincr

Re: problems with autoincrement tables

[EMAIL PROTECTED] wrote: > When you insert an object with an id, OJB insert the object without the ID > specified so the id is not the same in the database and in the object because > in this case OJB don't fetch the new ID and don't update the object. I think that isn't the right way. We use als

Re: OJB + Oracle BLOB

Christoph Bohl wrote: > After consulting the ojb documentation and the mailing list archives I > think that I do everything the right way, but I still cannot query a table > with a blob... We've had problems with CLOBs too. Our solution for the problems, I don't remember, was to separate the CLOB

Re: connection problem with ojb and Sql server

Davide Emanuele Denicolo wrote: > but the problem is the same!!! strange. Could you send your repository_database.xml and ojb.properties? Or I send you mine and you can compare your settings. I think it is a good idea to align both files. I have heard sometimes there are problems if in both files

ojb-blank.jar

Hello, I downloaded the ojb-blank.jar from 'http://mirrorspace.org/apache/db/ojb/db-ojb-1.0.3/'. But I'm missing the profile directory with the database profiles in it. I thought this is necessary. What does that mean? Regards, Thomas

Re: connection problem with ojb and Sql server

Davide Emanuele Denicolo wrote: > I've tried it, but i receive the same problem! OK, did you change datenklasse with a table of your database? Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: connection problem with ojb and Sql server

Davide Emanuele Denicolo wrote: > My problem is that when the connection between tomcat and sql server has > broken or SQL gets down,I receive this message to browser How about to use the validationQuery attribute in the connection-pool element of the repository_database.xml like this: Since w

Re: Boolean2IntFieldConversion with TINYINT

Thomas Dudziak wrote: > Therefore you'll have to either use BIT as the JDBC column type or > write your own Boolean2Byte conversion (simply copy the code of the > Boolean2Int conversion and replace Integer with Byte). That's true. We have also our own conversions for example a Long2Calender conver

Re: [junk] Re: Boolean2IntFieldConversion with TINYINT

Daniel Perry wrote: > What i mean, is that you cant do: I see. > Problem is... i am using xdoclet to make the repository and torque to make > the database. So, i have to use INTEGER in the xdoclet comment, so it ends > up as integer in the database. I previously have put it as INTEGER then > us

Re: Boolean2IntFieldConversion with TINYINT

Daniel Perry wrote: > Boolean2IntFieldConversion mapped as a TINYINT - it MUST be INTEGER!!! I don't know what you exactly mean but we use this and it works out fine. In the database the data type is tinyint. Regards, Thomas --

Re: Oracle9i and sequences

neration to Oracle. -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung -- the energy for a better world -- softEnergy GmbH Platz der Freundschaft 1 18059 Rostock -- fon: +49 381 40 587 5

Re: Oracle9i and sequences

; And xDoclet generated the following mapping snippet: > > primarykey="true" autoincrement="true"sequence-name="seq1" > access="readonly" >> access should be set to readwrite. If you don't use autoNaming you have also to

Re: Informix

Thomas Dudziak wrote: > For OJB, you need to specify a JNDI datasource using the corresponding > attribute: Thank you, Tom. I try it. :) Regards, Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung -- the energy for a better

Informix

help! Regards, Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung -- the energy for a better world -- softEnergy GmbH Platz der Freundschaft 1 18059 Rostock -- fon: +49 381 4

Re: Displaying data :: Best practise

ut we use the value object pattern and OJB classes which represents a row of a table if possible. regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung -- the energy for a better world -- softEnergy GmbH

Re: problem with ojb when overwriting the toString() method

ake a look on your source code? regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung -- the energy for a better world -- softEnergy GmbH Platz der Freundschaft 1 18059 Rostock -

Re: ClassNotPersistenceCapableException with multiple primary keys

under heavy load. OK, I will try latest from OJB 1.0.x branch. Thanks for help! best regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung the energy for a better world softEnergy GmbH Platz der Freundschaft

Re: ClassNotPersistenceCapableException with multiple primary keys

yKeys(Unknown Source) ... 13 more best regards and thanks for your answer Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung the energy for a better world softEnergy GmbH Platz der Freundschaft 1 18059 Ro

ClassNotPersistenceCapableException with multiple primary keys

="de.softenergy.wis.dbadapter.rawdata.calculations.tcategories.Calc_t_day" table="calc_t_day" > Thanks for help! :) regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung the en

Re: Borrow broker from pool failed

noch irgendwo ein fertiges JAR, in dem alle Klassen enthalten sind? Dazu kann ich gar nichts sagen, weil das bisher in unserem Projekt nicht anwenden. Tut mir leid. Kann man nicht die fehlenden Klassen auch als extra jar mitgeben? -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter

Re: Borrow broker from pool failed

1.0.1 we haven't had this problem anymore. The change from 1.0-rc5 to 1.0.1 was really easy and without any trouble. good luck regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung the energy for a be

Re: Strange OJB Behaviour with Struts

Sylvain ~ wrote: In OJB.properties I changed the property ObjectCacheClass and in repository_database.xml I changed the line thanks. regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMA

Re: Strange OJB Behaviour with Struts

Sylvain ~ wrote: Finally I found the error myself, the repository_database.xml file cache properties are not generated automatically on build when changing values in OJB.properties, so I modified the xml file manually and now it works great with ObjectCachePerBrokerImpl. Could you tell me which pro

Re: [OT] mailing list archive

George Mardale wrote: In my opinion, very active is a little bit too much to say :-(... For instance, I've asked 4 relative simple questions related to OJB-JDO until now, but no one answered me. Each thread I start seems to be doomed right from the start :-). I'm sorry. I want help you but I can

Re: PBKey

anged xml files couldn't be compiled. -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung The energy for a better world softEnergy GmbH Platz der Freundschaft 1 18059 Rostock fon: +49

Re: PBKey

have exported our application into a jar file and the repository.xml is in the root in this jar file. It's the same as under \classes. regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung The energy for a be

Re: OJB

[EMAIL PROTECTED] wrote: Can you help me please? You will find everything you need under: http://db.apache.org/ojb/docu/index.html There are lots of things to learn before you find ojb easy to use. regards Thomas - To unsubscribe,

Re: to many WARN logs

Hi Thomas, sorry, I was for 2 days out of office, now my comments below ... Thanks, Thomas. Normally not. This coding does it for me. Wherever I changed my code in this manner, I don't got the warning _for this place_ anymore ... I think you got the warning further because your change didn't capt

Re: Problem with n:m association

Thomas Papke wrote: Did you use a Non-Decomposed mapping or manual-decomposing mapping with a object as relation We use non-decomposed mappings and haven't any mappings for the intersection tables. Do you have one or more mappings for your tables? Sometimes there are problems, when there are dif

Re: Problem with n:m association

x27;s black-list : Message contains [1] file attachments Subject: [***SPAM*** Score/Req: 100.00/04.40] Re: Problem with n:m association From: Thomas Franke <[EMAIL PROTECTED]> Date: Sat, 04 Dec 2004 20:00:22 +0100 To: OJB U

Re: Problem with n:m association

Thomas Papke wrote: I need the inId because its like ebay: in each productgroup there is a collection of "untergruppen/undergroups". And this works: i could add objects of produktgruppe and save them (so inId will store the reference to the main productgroup). I tought first on a problem that we

Re: Problem with n:m association

Thomas Papke wrote: Why you need the inId? Here is my descriptor of the two classes: I thing this can't work and I thing also it is a wrong design: Take into your Produkt class a collection descriptor with Produktgruppe classes. For th

Re: to many WARN logs

Armin Waibel wrote: No. With enabled PB-tx you shouldn't get warnings of missing PB-tx. Do you made changes in PersistenceBrokerImpl or ConnectionManagerImpl? Could it be concurrency issue? Do several threads using the same PB instance? I didn't make any changes in PersistenceBrokerImpl or Conne

Re: to many WARN logs

Hi Thomas, It's not a bug it's a feature :-) No, it's only a warning but very helpful by telling you: Hey man, could it be you forget to bound your transaction. I see it just like the deprecation messages displayed by the javac - ignore them as you like, but using transactions isn't only good s

to many WARN logs

Hello there, since we use ojb 1.0.1 we find in our tomcat logs many messages like this: [org.apache.ojb.broker.core.PersistenceBrokerImpl] WARN: No running tx found, please only store in context of an PB-transaction, to avoid side-effects - e.g. when rollback of complex objects Could it be a little

Re: OJB in Tomcat

Łukasz Korzybski wrote: Do you mean pack them in jar and put it to lib folder (WEB-INF/lib) ? I will try Right. I remember that at first we had a similar problem and our solution is this. regards Thomas - To unsubscribe, e-mail:

Re: OJB in Tomcat

Łukasz Korzybski wrote: Is anyone have a idea why ojb 1.0.1 doesn't see configuration files which are directly in WEB-INF/classes? I am fighting with it all day and I am not able to make it work, I use tomcat 5 embedded in Netbeans 4, I will download today tomcat and make alone installation and

Thanks for help! was: validation query for connection failed

Hi Roland and all, I also had problems with the broker and now I'm realised, that only if I define the connection Pool in both files where it is possible (OJB.properties AND reposistory.xml), it works like we want. I tried many settings and tested it with JMeter and produced havy laod on the web ap

Re: join with ojb

se a collection-descriptor as a reference in my statement. Now I got it. Thanx for help. regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer softEnergy GmbH The energy for a better world softEnergy GmbH Platz der

Re: validation query for connection failed

Ribi Roland wrote: Try to make the settings in both files. Thanx for your good information. I will try it. regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer softEnergy GmbH The energy for a better world softEnergy GmbH

Re: join with ojb

[EMAIL PROTECTED] wrote: If the cardinality is as following: Addressen 1:n Adressen_adressart_typ 1:n Adressartandtyp 1:n Right you are, this is our cardinality. Then you can have several instances of the same Adress. Exactly. You can ensure (force) the outer joins with query.setPathOuterJoin(".")

Re: join with ojb

eundlichen Grüßen Thomas Franke Geschäftsführer softEnergy GmbH The energy for a better world softEnergy GmbH Platz der Freundschaft 1 18059 Rostock fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 17152

Re: validation query for connection failed

okers are definitely being closed in a finally block but our problem is still there. regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer softEnergy GmbH The energy for a better world softEnergy GmbH Platz der Freundsch

Re: join with ojb

don't know the right mapping and how to build the 'Criteria' object. regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer softEnergy GmbH The energy for a better world softEnergy GmbH Pla

join with ojb

imple solution? Thanks in advance. regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer softEnergy GmbH The energy for a better world softEnergy GmbH Platz der Freundschaft 1 18059 Rostock fon: +4

Re: validation query for connection failed

ive me any help on this? regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer softEnergy GmbH The energy for a better world softEnergy GmbH Platz der Freundschaft 1 18059 Rostock fon: +49 381 40

Re: validation query for connection failed

Armin Waibel wrote: Thanks for your answer, Armin. which version of OJB do you use? We still use db-ojb-1.0.rc6.jar. It is possible to make a change to db-ojb-1.0.1.jar without any trouble? Normally ConnectionFactoryPooledImpl tries 100 times to lookup a valid connection from the DB, so you should

validation query for connection failed

Hello there, Our application should work twenty-for seven. Suddenly an exception occurs. This exception isn't caught in the application, instead I see it on the console. (At the moment we start the application from the console). For example I see: ... WARN: Validation query for connection failed

Re: JDBC Types... Primitive or Objects?

Martin I. Levi wrote: I think objects is the best option because if the row is null, the object is null. Ok, but why the JDBC spec doesn't say the same? I use ojb like a black box. I can't say what ojb do. But I can say it works good. :) -- Mit freundlichen Grüßen Thomas Franke

Re: JDBC Types... Primitive or Objects?

Martin I. Levi wrote: I think objects is the best option because if the row is null, the object is null. Ok, but why the JDBC spec doesn't say the same? I use ojb like a black box. I can't say what ojb do. But I can say it works good. :) -- Mit freundlichen Grüßen Thomas Franke Pro

Re: Regd Updating Selected Columns

based on a key value. Is this possible?? No, at the time all columns will be updatet. Or you must write a special class with the columns you want to update. -- Mit freundlichen Grüßen Thomas Franke Projektleiter WIS-Projekt Wissen Innovation Siche

Re: JDBC Types... Primitive or Objects?

Martin I. Levi wrote: JDBC Java BOOLEAN ---> Boolean INTEGER ---> Integer In our project we use this without any problems. Which is the best option if there is any? I think objects is the best option because if the row is null, the object is null. -- Mit freundlichen Grüßen Thomas