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

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

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

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

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

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 of

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]

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 exception above occurs

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

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

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

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

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

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

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 autoincrement fields because there isn't

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 also

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: 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:

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,

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: 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

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

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 used

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. field-descriptor name=deleted column=deleted jdbc-type=INTEGER

Re: Oracle9i and sequences

=seq1 access=readonly access should be set to readwrite. If you don't use autoNaming you have also to create the sequences in Oracle. -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung -- the energy for a better world

Re: Oracle9i and sequences

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 535 fax: +49 381

Informix

a connection, isn't it? We use the IBM Informix JDBC Driver 3.00.JC1. Any suggestions? Thank you for your help! Regards, Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung -- the energy for a better world

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 world

Re: Displaying data :: Best practise

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 Platz

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

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 -- fon

ClassNotPersistenceCapableException with multiple primary keys

-descriptor name=term column=term jdbc-type=BIGINT / field-descriptor name=lop column=lop jdbc-type=INTEGER / /class-descriptor Thanks for help! :) regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer Leiter Entwicklung

Re: ClassNotPersistenceCapableException with multiple primary keys

(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 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: 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: [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

Re: PBKey

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 better world

Re: PBKey

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 381 40 587

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

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: 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

: 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 Users List [EMAIL

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

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

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

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

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

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

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 587 535 fax: +49 381 40 587

join with ojb

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: +49 381

Re: join with ojb

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 Platz der Freundschaft 1 18059 Rostock

Re: validation query for connection failed

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 Freundschaft 1

Re: join with ojb

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 587 535 fax: +49 381 40 587 555 mobil: +49

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(ref

Re: validation query for connection failed

{ if (broker != null) { broker.clearCache(); broker.close(); } } end Can anyone give me any help on this? regards Thomas -- Mit freundlichen Grüßen Thomas Franke Geschäftsführer softEnergy GmbH The energy

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

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

Re: Regd Updating Selected Columns

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 Sicherheit