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 can't avoid all problems in clustering environment by using no cache. For example Bob is working with a certain data record. Then Carol gets the same data record from the database. Then Bob is changing the data into the database. After that Carol is changing the data too and saving them into database. Now Bobs changes are lost because Carol has the data record overwritten with her changes. If Bob now loads the data record again, he will see the changes of Carol. > However, we noticed that very randomly we get errors like "Borrow broker from > pool failed, using PBKey org.apache.ojb.broker.PBKey: jcdAlias=something, > user=something, password=*" or "java.sql.SQLException: Connection is > closed. [EMAIL PROTECTED] wrapped > [EMAIL PROTECTED] ]". That isn't a big problem. You can avoid it using the validationQuery attribute of the connection-pool tag in the repository_database.xml. Here is a example as well: See also the OJB documentation. > even more bizarrely, it says some of the data that we are trying to insert is > not present while doing a broker.store(), but I can very that the data is > right there. And very strangely, if we wait a minute or so and attempt to > save again, it all saves correctly without a hitch. Make sure that you use only the latest jdbc driver and I think you should use also the latest jdk and released OJB version. We were able to solve such problems changing to the latest versions. Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 additional commands, e-mail: [EMAIL PROTECTED]
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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 additional commands, e-mail: [EMAIL PROTECTED]
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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 additional commands, e-mail: [EMAIL PROTECTED]
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 PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 if the database server needs more memory. Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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.DBAdapter.ojbAdapter.management.OjbLogBook - getFirstEntry(Integer weaId): org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the execution of the query (for de.mhr.wis.DBAdapter.rawdata.analyses.Logbuch): Cannot write sorted rows. at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:349) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74) at org.apache.ojb.broker.accesslayer.RsIterator.(RsIterator.java:185) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1620) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307) at de.mhr.wis.DBAdapter.ojbAdapter.management.OjbLogBook.getFirstEntry(OjbLogBook.java:5017) at de.mhr.wis.DBAdapter.ojbAdapter.management.OjbLogBook.getStartTermCalculation(OjbLogBook.java:2268) at de.mhr.wis.businessLayer.logic.management.LogBook.calculateTermForEachStatus(LogBook.java:194) at de.mhr.wis.businessLayer.logic.management.LogBookQueue.run(LogBookQueue.java:115) Caused by: java.sql.SQLException: Cannot write sorted rows. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373) at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269) at com.informix.jdbc.IfxSqli.a(IfxSqli.java:1532) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1471) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1401) at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:204) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1192) at com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:369) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:312) ... 12 more Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 OJB. That's what I think. We're using ojb 1.0.3 from the source code because of my changing in the PlatformInformixImpl class. Right now we're testing our application against mysql and informix but in another environment. Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 driver problem but I don't know. Any suggestions are welcome as always. :) Here is the full stack trace: --- 2005-11-11 13:37:59 [FATAL] de.mhr.wis.DBAdapter.ojbAdapter.management.OjbLogBook - getFirstEntry(Integer weaId): java.util.NoSuchElementException: Could not obtain next object: inner hasNext was false at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:299) at org.apache.ojb.broker.accesslayer.PagingIterator.next(PagingIterator.java:187) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1636) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307) at de.mhr.wis.DBAdapter.ojbAdapter.management.OjbLogBook.getFirstEntry(OjbLogBook.java:5017) at de.mhr.wis.DBAdapter.ojbAdapter.management.OjbLogBook.getStartTermCalculation(OjbLogBook.java:2268) at de.mhr.wis.businessLayer.logic.management.LogBook.calculateTermForEachStatus(LogBook.java:194) at de.mhr.wis.businessLayer.logic.management.LogBook.importStatusdaten(LogBook.java:983) at de.softenergy.wis.businesslayer.facades.comserver.RawDataFacade.importStatusdaten(RawDataFacade.java:51) at de.mhr.wis.communicationlayer.communicationmanager.importers.SAXEnronStatusV4ImportHandler.endDocument(SAXEnronStatusV4ImportHandler.java:188) at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown Source) at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown Source) at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown Source) at org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(Unknown Source) at de.mhr.wis.communicationlayer.communicationmanager.importers.EnronImporter.importXml(EnronImporter.java:373) at de.mhr.wis.communicationlayer.communicationmanager.importers.EnronImporter.importXml(EnronImporter.java:385) at de.mhr.wis.communicationlayer.communicationmanager.importers.EnronImporter.xml2Enron_status(EnronImporter.java:346) at de.mhr.wis.communicationlayer.communicationmanager.importers.EnronImporter.importStatusData(EnronImporter.java:276) at de.mhr.wis.communicationlayer.communicationmanager.importers.EnronImporter.importRawFile(EnronImporter.java:133) at de.mhr.wis.communicationlayer.communicationmanager.importers.EnronImporter.importRawFile(EnronImporter.java:518) at de.mhr.wis.communicationlayer.communicationmanager.RawFileManager.run(RawFileManager.java:205) --- Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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#buildNextSequence method is
used the method CallableStatement#getLong to get the result. Thus with
BigInteger it passes Long values too.
Secondly the necessary argument of the method CallableStatement#prepareCall for
informix is a little bit different as the implemention of oracle or mssql.
Have a look at the difference:
This is the String argument for oracle and mssql:
"{? = call " + procedureName + "(?)}"
and this one is the String argument for informix:
"{? = call " + procedureName + "(?,?)}"
As you can see the informix implementation needs two '?' arguments. And this is
necessary for the database and driver type. The first '?' argument is necessary
to define the out parameter to get the result over the
CallableStatement#getLong.
Because of a bug in the informix driver you have also to call
CallableStatement#executeQuery here. It seems that the
CallableStatement#executeUpdate is incorrectly implemented.
So if you implement the PlatformDefaultImpl#prepareNextValProcedureStatement you
have continue to implement the
PlatformInformixImpl#prepareNextValProcedureStatement.
Regards,
Thomas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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 commands, e-mail: [EMAIL PROTECTED]
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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 sql statements to create the spl function and the OJB
sequence table.
Maybe you can use it.
Best Regards,
Thomas
drop table ojb_nextval_seq;
create table ojb_nextval_seq
(
seq_namevarchar(250,0) not null,
max_key int8,
primary key(seq_name)
);
drop function ojb_nextval_proc;
create function ojb_nextval_proc(out arg1 int8, arg2 varchar(250,250))
returns int8;
let arg1 = 0;
update ojb_nextval_seq set max_key = max_key + 1 where seq_name = arg2;
select max_key into arg1 from ojb_nextval_seq where seq_name = arg2;
return arg1;
end function;
package org.apache.ojb.broker.platforms;
/* Copyright 2002-2004 The Apache Software Foundation
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
import org.apache.ojb.broker.metadata.JdbcConnectionDescriptor;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;
/**
* This class extends PlatformDefaultImpl and defines specific
* behavior for the Informix platform.
*
* @version 1.0
* @author Thomas Mahler
*/
public class PlatformInformixImpl extends PlatformDefaultImpl {
/**
* @see Platform#initializeJdbcConnection
*/
public void initializeJdbcConnection(JdbcConnectionDescriptor jcd,
Connection conn) throws PlatformException {
super.initializeJdbcConnection(jcd, conn);
try {
Statement stmt = conn.createStatement();
stmt.execute("SET LOCK MODE TO WAIT");
} catch (SQLException e) {
// ignore it
}
}
/**
* @see
org.apache.ojb.broker.platforms.PlatformDefaultImpl#prepareNextValProcedureStatement(java.sql.Connection,
* java.lang.String, java.lang.String)
*/
public CallableStatement prepareNextValProcedureStatement(Connection con,
String procedureName, String sequenceName) throws PlatformException
{
try {
/*
* Following works for Informix Dynamik Server 9.4 and the Informix
* JDBC.3.00.JC1 driver. It is important to call the executeQuery()
* method here because the executeUpdate() method doesn't work
* correctly and returns an error if it is called alone.
*/
String sp = "{? = call " + procedureName + "(?,?)}";
CallableStatement cs = con.prepareCall(sp);
cs.registerOutParameter(1, Types.BIGINT);
cs.setString(2, sequenceName);
cs.executeQuery();
return cs;
} catch (SQLException e) {
throw new PlatformException(e);
}
}
}
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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 HighLowSequence instance from DB based on the > sequence name. If not found OJB try to read the max key of the target > column (using: SELECT MAX(column) FROM table). > The returned value is used as start value for the new HighLowSequence > object. OJB obtain a new PB instance (separate connection) to > store/update the HighLowSequence object to avoid problems on rollback of > tx of the main PB instance. Thanks for your quick answer. I'll take a look. Regards, Thomas -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: GnuPT 2.6.2.1 by EQUIPMENTE.DE Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDX3FDJ9/BHYFfmhMRAuB/AJ4um2iU5yZyJM5EqKWIJnboicBjpACgjHM2 zkCXjmljID9WyMNiwCaOPBg= =2IGh -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 create a new record over OJB we have to create a record in a certain table before so that at least one PK exist. After that OJB is able to create the autoincrement keys. I know it's weird. At the moment I have no ideas because I don't know how this sequence manager works. Any suggestions are welcome! :) Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 driver? Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 a sequence manager implementation > who works with autoincrement fields. I'm sorry. I did a mistake. I meant we use autoincrement fields in eather case but in case of Oracle and Informix we let OJB manages the autoincrement fields and not the database as in case of MySQL. Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 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 a sequence manager implementation who works with autoincrement fields. Are you sure that your chosen sequence manager works right with your database? Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 rows into a extra table. regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 differences. CU, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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, e-mail: [EMAIL PROTECTED]
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 we use this solution we solved our problem with lost connections. Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 conversion. Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 tinyint in mysql - but with xdoclet, everything is automated. Then it is more an xdoclet problem than an ojb problem. :) Regards, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Oracle9i and sequences
Thomas Dudziak wrote: > * Leave the pk generation to the database. In that case, use the > native sequence manager. With Oracle it would be a problem I think. If I right the native sequence manager don't work with Oracle. Therefore we use SequenceManagerNextValImpl and leave the pk generation 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 40 587 555 mobil: +49 162 249 8860 (Achtung neue Nummer!) http://www.softenergy.de mail: [EMAIL PROTECTED] -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Oracle9i and sequences
Guillaume Laforge wrote: We use Oracle with Oracle sequences and it works out fine. We use OJB 1.0.1 and Oracle9i. Have a look at our set-up: > className="org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl"> > attribute-name="globalSequenceStart" attribute-value="1000"/> > I think here is one conflict. You have to figure out who shall manage the sequences OJB or Oracle. If you don't use clustered environments or other not OJB applications which insert objects too OJB can manage the 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 create the sequences in 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 40 587 555 mobil: +49 162 249 8860 (Achtung neue Nummer!) http://www.softenergy.de mail: [EMAIL PROTECTED] -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 -- softEnergy GmbH Platz der Freundschaft 1 18059 Rostock -- fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 162 249 8860 (Achtung neue Nummer!) http://www.softenergy.de mail: [EMAIL PROTECTED] -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Informix
Hello, we want to connect to IDS 9.4 with OJB. Here is our repository_database.xml: If we start our server we get this exception: [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR: Instantiation of jdbc driver failed null java.lang.ClassCastException at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:266) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) If we trace the connection between our application and the data base we can see that the application tries to connect the database server with the connection type oltlitcp and the data base server answers olsoctcp. I think that means that the data base server expected soc. Therefore it is unpossible to get 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 -- softEnergy GmbH Platz der Freundschaft 1 18059 Rostock -- fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 162 249 8860 (Achtung neue Nummer!) http://www.softenergy.de mail: [EMAIL PROTECTED] -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Displaying data :: Best practise
Nils Liebelt wrote: What goes to the front (for viewing purposes)? For capturing data we use ActionForms! But how do you display data (from your model) nicely? Send Businesobjects, Businessobjects stuffed in Beans, ActionForm or something else to the view layer? I don't really what you mean but 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 Platz der Freundschaft 1 18059 Rostock -- fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: problem with ojb when overwriting the toString() method
Günther Wieser wrote: hmm, haven't seen any error so far when using the toString() method of objects of this class so far. what the toString() method does is to get all private fields of the object by introspection and fill a string buffer with the name of the field and the value. Could I take 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: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: ClassNotPersistenceCapableException with multiple primary keys
Armin Waibel wrote: I think this is a concurrency problem. Do this error occur under heavy load? I try to fix this in OJB 1.0.x release branch (OJB_1_0_RELEASE). If possible please try latest from OJB 1.0.x branch (PB-api is stable) and run your test against it. Yeah, your right, it occurs 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 1 18059 Rostock fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: ClassNotPersistenceCapableException with multiple primary keys
Thomas Dudziak wrote: Please post the stacktrace of the exact exception. In what way do you set the primarykey values, application or database ? We set the primary key in the application. Sometimes we create a new object with all primary keys but the row is already in the rdbms. We do this because we don't want get the object from the rdms first. Thus we have one rdbms access instead of two. Here is the full stacktrace: 25.02.2005 15:41:34 [ERROR] de.softenergy.wis.dbadapter.interfaces.calculations.tcategories.CalculatedTCatDayAdapterIF - store(Collection days): org.apache.ojb.broker.metadata.ClassNotPersistenceCapableException: Can not init Identity for given object [lop] 0 [lop_day] 110919960 [modification] 1109342494882 [nutzer_id] 1 [t_klassen_id] 4 [term] 0 [w_id] 50 at org.apache.ojb.broker.Identity.init(Unknown Source) at org.apache.ojb.broker.Identity.(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at de.softenergy.wis.dbadapter.ojb.calculations.tcategories.OjbCalculatedTCatDayAdapter.store(OjbCalculatedTCatDayAdapter.java:97) at de.softenergy.wis.businesslayer.logic.calculations.tcategories.TCategoryDay.calcPlantDays(TCategoryDay.java:320) at de.softenergy.wis.businesslayer.logic.calculations.tcategories.TCategoryDay.calcPlant(TCategoryDay.java:248) at de.softenergy.wis.businesslayer.logic.calculations.tcategories.TCategoryDay.calcTDay(TCategoryDay.java:205) at de.softenergy.wis.businesslayer.logic.calculations.tcategories.TCategoryDay.execute(TCategoryDay.java:166) at de.softenergy.wis.businesslayer.logic.calculations.CalculationStarter.run(CalculationStarter.java:60) Caused by: java.lang.NullPointerException at org.apache.ojb.broker.Identity.checkForPrimaryKeys(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 fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
ClassNotPersistenceCapableException with multiple primary keys
Hello there, since we use multiple primary keys instead of an autoincrement primary key we sometimes get a ClassNotPersistenceCapableException. The strange thing is that it only occurs sometimes and with different classes. We use OJB 1.0.1. This is one of the class descriptors: class="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 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 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Borrow broker from pool failed
Hallo Peter, vielen Dank für Deine Hinweise. Wir versuchen hier gerade auf OJB 1.0.1 zu updaten. Dem ojb JAR aus dem Binarypaket fehlen allerding die org.apapche.ojb.jboss.* - Klassen, die für den JNDI-Kram erforderlich sind. Ist Selbstkompillieren des OJB die einzige Möglichkeit oder bekommt man 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 Entwicklung 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 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Borrow broker from pool failed
Peter Juszack wrote: we use OJB 1.0-rc5 together with JBoss 3.2.1 and EJB in a production environment. The system is up for about one and a half years. The problem is, that we have to restart the JBoss application server once a week. This is necessary because new ServerContexts (Logins) can't get a persistence broker from the pool (stack tarce follows). I know that problem. We had the same a time ago. I think there are 2 solutions: First you must close each broker with broker.close. Check your code for this. Second it seems this is a bug in your ojb version. Since we changed to ojb 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 better world softEnergy GmbH Platz der Freundschaft 1 18059 Rostock fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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 properties do you mean or changed? regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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't because I don't use JDO. regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: PBKey
[EMAIL PROTECTED] wrote: The xml files are in the resources folder wihich is under classes. I tried also to out the files directly in the folder classes - with the same result. Have you removed the old work directory before you restarted? That's sometimes the reason for an error. The changed 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 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: PBKey
[EMAIL PROTECTED] wrote: Hello, I want to start the damo.class from the destination folder of this class. My repository.xml files are in target \classes\resources. How can i set it that he finds this files I remember at first we had this problem too. Put it under \classes. That's all. We 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 better world softEnergy GmbH Platz der Freundschaft 1 18059 Rostock fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 capture each occurrence of unTXed stores to db. Well, I'll look for each store methode without transaction and change it in the right way. The only criticism with the warning I see is that it won't tell you where a tx was missed. I thing so too. regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 differences between the mappings for the same table. Here is one example: regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem with n:m association
[EMAIL PROTECTED] wrote: Everytime when I post a message to this list a receive following message. Dear Andy, could you this change. I found this is spam. MDaemon has identified your message as spam. It will not be delivered. From : [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject : [***SPAM*** Score/Req: 100.00/04.40] Re: Problem with n:m association Message-ID: <[EMAIL PROTECTED]> Yes, hits=100.0 required=4.4 tests=USER_IN_BLACKLIST autolearn=no version=2.64 ** * 100 USER_IN_BLACKLIST From: address is in the user'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 Users List <[EMAIL PROTECTED]> To: OJB Users List <[EMAIL PROTECTED]> Start SpamAssassin results 100.0 points, 4.4 required; * 100 USER_IN_BLACKLIST From: address is in the user's black-list End SpamAssassin results Return-path: <[EMAIL PROTECTED]> Received: from mail.apache.org (hermes.apache.org [209.237.227.199]) by postoffice.mindgent.com (postoffice.mindgent.com [10.37.63.10]) (MDaemon.PRO.v7.2.1.R) with ESMTP id md5426216.msg for <[EMAIL PROTECTED]>; Sat, 04 Dec 2004 14:00:37 -0500 Received: (qmail 70795 invoked by uid 500); 4 Dec 2004 19:00:32 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:[EMAIL PROTECTED]> List-Subscribe: <mailto:[EMAIL PROTECTED]> List-Help: <mailto:[EMAIL PROTECTED]> List-Post: <mailto:[EMAIL PROTECTED]> List-Id: "OJB Users List" Reply-To: "OJB Users List" <[EMAIL PROTECTED]> Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 70779 invoked by uid 99); 4 Dec 2004 19:00:31 - X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= Received-SPF: pass (hermes.apache.org: local policy) Received: from mout1.freenet.de (HELO mout1.freenet.de) (194.97.50.132) by apache.org (qpsmtpd/0.28) with ESMTP; Sat, 04 Dec 2004 11:00:29 -0800 Received: from [194.97.55.192] (helo=mx8.freenet.de) by mout1.freenet.de with esmtpa (Exim 4.43) id 1Caf8r-0006uS-6c for [EMAIL PROTECTED]; Sat, 04 Dec 2004 20:00:25 +0100 Received: from [217.6.219.106] (helo=[172.30.1.79]) by mx8.freenet.de with esmtpa (ID [EMAIL PROTECTED]) (Exim 4.43 #13) id 1Caf8q-0005r1-RP for [EMAIL PROTECTED]; Sat, 04 Dec 2004 20:00:25 +0100 Message-ID: <[EMAIL PROTECTED]> Date: Sat, 04 Dec 2004 20:00:22 +0100 From: Thomas Franke <[EMAIL PROTECTED]> User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: OJB Users List <[EMAIL PROTECTED]> Subject: Re: Problem with n:m association References: <[EMAIL PROTECTED]><[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> In-Reply-To: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-MDRcpt-To: [EMAIL PROTECTED] X-Rcpt-To: [EMAIL PROTECTED] X-MDRemoteIP: 209.237.227.199 X-Return-Path: [EMAIL PROTECTED] X-MDaemon-Deliver-To: [EMAIL PROTECTED] 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 had. Sorry, I was wrong. :) The problem is not between productgroup and productgroup (1:n) - it is between Productgroup and Product (n:m) We have in our application similar relationships and our mappings look like your mapping and it's working. regards Thomas --------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- 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 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 had. Sorry, I was wrong. :) The problem is not between productgroup and productgroup (1:n) - it is between Productgroup and Product (n:m) We have in our application similar relationships and our mappings look like your mapping and it's working. regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 that case I would write a spezial mapping for Produktgruppe without a collection with Produkt class. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 ConnectionManagerImpl? That's your job not mine. ;) I call only this: broker = PersistenceBrokerFactory.defaultPersistenceBroker(); O.K., I will make another code review and I hope I'll find something. regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 style ... and to have _some_ WARN logs of these isn't hardly a problem ;-) O.K. I understand and I have made a code review. I changed my code e.g. to this: broker.beginTransaction(); broker.store(something); broker.commitTransaction(); But I have the same log outputs. Can it be? regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 bug? In my opinion it's not necessary each object to set into a transaction, isn't it. regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 try with it. Take the ojb xml files into the jar file and it should work. regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 application. The connection pool didn't grow over 21 connections to the db. Only with setting of maxActive=100 and maxIdle=20 in repository.xml and OJB.properties it growed over 21 connection on havy load. I don't know why but now it works fine now. I searched in the source of OJB and found the default settings in org.apache.ojb.broker.util.pooling.PoolConfiguration. Try to make the settings in both files. Our application now runs with your settings and we now use the latest official ojb release. And all the problems are solved. For our oracle database we use another sequence manager as before. All changes were made without any problems. I think ojb is a great and powerfull tool! :) Thanks for your help! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: join with ojb
Danilo Tommasina wrote:
Ok, then try something like this:
Criteria crit = new Criteria();
crit.addEqualTo( "..addressart", new Integer( 1 ) );
QueryByCriteria query = new QueryByCriteria( Adressen.class, crit, true );
PersistenceBroker pb = null;
try {
pb = PersistenceBrokerFactory.defaultPersistenceBroker();
Collection results = pb.getCollectionByQuery( query );
// The Collection now contains instances of class Adressen
} catch ( Exception e ) {
// Do exception handling
} finally {
if ( pb != null ) {
pb.close();
}
}
First I don't understand how I can use 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 Freundschaft 1
18059 Rostock
fon: +49 381 40 587 535
fax: +49 381 40 587 555
mobil: +49 1715222015
http://www.softenergy.de
mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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 Platz der Freundschaft 1 18059 Rostock fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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(".")
for example.
O.K.
Thanks. :)
regards
Thomas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: join with ojb
Danilo Tommasina wrote: Ok, then try something like this: Criteria crit = new Criteria(); crit.addEqualTo( "..addressart", new Integer( 1 ) ); is a collection. Can I do this with a collection? I try it. The reference in our address mapping looks like 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 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: validation query for connection failed
Ribi Roland wrote: Thanks for your help, Roland. http://www.websina.com/bugzero/kb/oracle-connection.html This is not our problem, because we almost always get a connection. The problem only occurs sometimes. But to often. An other problem could be that some Broker stay open after use. I had this behavior in my tomcat-application. After I checked the code where a PersistenceBroker is used and implemented the call of the close method correctly at the end of any request (also if it throws an exception!), it works fine. We found one method, where the broker wasn't closed. Now all the brokers 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 18059 Rostock fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: join with ojb
Danilo Tommasina wrote: Thanks a lot for your help. With the PersistenceBroker API you can use a ReportQueryByCriteria O.K., but we want as result a collection with 'Address' objects. The 'name' attribute is an exampel only. Sorry, my question was not clear enough. We 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 Platz der Freundschaft 1 18059 Rostock fon: +49 381 40 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
join with ojb
Hallo there, I want to do this with ojb but I can't find a good and straight forward way. SELECT DISTINCT A.name FROM adressen A, adressen_adressart_typ B, adressartandtyp C WHERE A.adressen_id = B.adressen_id AND B.adressart_id = C.adressart_id AND C.adressart = 1; Could anyone give me a simple 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 40 587 535 fax: +49 381 40 587 555 mobil: +49 1715222015 http://www.softenergy.de mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: validation query for connection failed
ConnectionManager instance could not obtain a connection
org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager
instance could not obtain a connection
at
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.(Unknown Source)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unknown
Source)
at de.mhr.wis.DBAdapter.ojbAdapter.Utils.getWea(Utils.java:627)
at
de.mhr.wis.DBAdapter.ojbAdapter.management.OjbLogbuchAdapter.importStatusdaten(OjbLogbuchAdapter.java:392)
at
de.mhr.wis.businessLayer.logic.management.LogBook.importStatusdaten(LogBook.java:879)
at
de.mhr.wis.businessLayer.facades.rawdata.RawDataFacade.importStatusdaten(RawDataFacade.java:50)
at
de.mhr.wis.communicationlayer.communicationmanager.importers.MitaImporter.importStatus(MitaImporter.java:723)
at
de.mhr.wis.communicationlayer.communicationmanager.importers.MitaImporter.importSingleRawFile(MitaImporter.java:358)
at
de.mhr.wis.communicationlayer.communicationmanager.importers.MitaImporter.importRawFile(MitaImporter.java:249)
at
de.mhr.wis.communicationlayer.communicationmanager.RawFileManager.run(RawFileManager.java:221)
Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not
borrow connection from pool -
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor:
[EMAIL PROTECTED]
---end
and so on.
Is the information enough or do you need any more?
Thanks for help!
regards
Thomas
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.
...
Nested Exception
unexpected end of input stream
...
After that the application doesn't work anymore. It seems like I can
no longer establish a connection to the database. The only way to get
the application running again is the comlete new start.
We use the following classes:
---begin
ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl
ConnectionManagerClass=org.apache.ojb.broker.accesslayer.ConnectionManagerImpl
---end
The repository.xml looks like this for example:
--begin
---end
The repository_database.xml looks like this:
--begin
className="org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl">
---end
And the code looks like this:
--begin
try {
broker = PersistenceBrokerFactory.defaultPersistenceBroker();
broker.beginTransaction();
[...]
broker.getObjectByQuery(query);
[...]
broker.store(data);
}
broker.commitTransaction();
} catch (TransactionInProgressException e) {
logger.error(e);
} catch (TransactionAbortedException e) {
logger.error(e);
} catch (TransactionNotInProgressException e) {
logger.error(e);
} catch (PBFactoryException e) {
logger.error(e);
} catch (PersistenceBrokerException e) {
logger.error(e);
} catch (Exception e) {
logger.error(e);
} finally {
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 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 1715222015
http://www.softenergy.de
mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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 get the warning several times before the pool break. Could you post the whole stack trace? Now our application runs in tomcat as webservice. I can't see any output in the tomcat logs. Here is what I see in our log: begin org.apache.ojb.broker.PBFactoryException: Borrow broker from pool failed, using PBKey org.apache.ojb.broker.PBKey: jcdAlias=lala, user=lulu, password=* at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker(PersistenceBrokerFactoryDefaultImpl.java:117) at org.apache.ojb.broker.core.PersistenceBrokerFactoryBaseImpl.defaultPersistenceBroker(PersistenceBrokerFactoryBaseImpl.java:158) at org.apache.ojb.broker.PersistenceBrokerFactory.defaultPersistenceBroker(PersistenceBrokerFactory.java:65) at de.mhr.wis.DBAdapter.ojbAdapter.communicationManager.JobGeneratorDBAdapter.getCommTypes(JobGeneratorDBAdapter.java:264) at de.mhr.wis.communicationlayer.jobgenerator.JobMaker.createJobs(JobMaker.java:850) at de.mhr.wis.communicationlayer.jobgenerator.JobMaker.createJobs(JobMaker.java:103) at de.mhr.wis.communicationlayer.jobgenerator.JobGenerator.run(JobGenerator.java:630) Caused by: java.util.NoSuchElementException at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:803) at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker(PersistenceBrokerFactoryDefaultImpl.java:99) ... 6 more --end best regards Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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.
...
Nested Exception
unexpected end of input stream
...
After that the application doesn't work anymore. It seems like I can no
longer establish a connection to the database. The only way to get the
application running again is the comlete new start.
We use the following classes:
---begin
ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl
ConnectionManagerClass=org.apache.ojb.broker.accesslayer.ConnectionManagerImpl
---end
The repository.xml looks like this for example:
--begin
---end
The repository_database.xml looks like this:
--begin
className="org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl">
---end
And the code looks like this:
--begin
try {
broker = PersistenceBrokerFactory.defaultPersistenceBroker();
broker.beginTransaction();
[...]
broker.getObjectByQuery(query);
[...]
broker.store(data);
}
broker.commitTransaction();
} catch (TransactionInProgressException e) {
logger.error(e);
} catch (TransactionAbortedException e) {
logger.error(e);
} catch (TransactionNotInProgressException e) {
logger.error(e);
} catch (PBFactoryException e) {
logger.error(e);
} catch (PersistenceBrokerException e) {
logger.error(e);
} catch (Exception e) {
logger.error(e);
} finally {
if (broker != null) {
broker.clearCache();
broker.close();
}
}
end
Can anyone give me any help on this?
regards
Thomas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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 __ Thomas Franke Softwareentwickler Wiesenweg 10 18334 Kölzow Tel.: 038228 61886 Mobil: 01629803488 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 Projektleiter WIS-Projekt Wissen Innovation Sicherheit MedienHaus Rostock GmbH Platz der Freundschaft 1 18059 Rostock fon: +49 381 40 587 535 fax: +49 381 40 587 552 mobil: +49 1715222015 http://www.mhr.de/wis mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Regd Updating Selected Columns
Parvathi Rajaraman wrote: Does anyone know how to update selected columns of a table using OJB. We are using the PersistanceBroker API's store method that will either insert or update all the columns based on the primary key value. But I want to update only a few columns for multiple records 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 Sicherheit MedienHaus Rostock GmbH Platz der Freundschaft 1 18059 Rostock fon: +49 381 40 587 535 fax: +49 381 40 587 552 mobil: +49 1715222015 http://www.mhr.de/wis mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 Franke Projektleiter WIS-Projekt Wissen Innovation Sicherheit MedienHaus Rostock GmbH Platz der Freundschaft 1 18059 Rostock fon: +49 381 40 587 535 fax: +49 381 40 587 552 mobil: +49 1715222015 http://www.mhr.de/wis mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
