Per-jcdAlias OJB cache?

2003-12-03 Thread Martin Kalén
-pool cache. This would be sort of redefining Identity to be a composite of current definition (all persistent fields with primary-key=true) and jcdAlias from the connection-pool. Any thoughts about this? Has anyone tried a similar solution? TIA, Martin -- Martin Kalén Curalia AB

Re: Per-jcdAlias OJB cache?

2003-12-03 Thread Martin Kalén
are not affected by those.) -You just made my day! :-) Cheers, Martin -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40

Re: error when start OJB

2003-12-04 Thread Martin Kalén
/deployment.html for the OJB deployment guide, or (more to the point) http://db.apache.org/ojb/dependencies.html for a list of the JAR-files you need to deploy with OJB. -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 Stocksund

Re: hot to reload cached object?

2003-12-04 Thread Martin Kalén
/PersistenceBroker.html#removeFromCache(java.lang.Object) (And then a new load, of course.) -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40

Re: Oracle and Char[size]

2003-12-04 Thread Martin Kalén
') is the only one that would match char[5] (or addLike(pkAlias, 'FR%') but that is ambigous). Cheers, Martin -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40

Re: hot to reload cached object?

2003-12-05 Thread Martin Kalén
follow reference-descriptors and remove them from cache too in step 1). Or you could just follow Armin Waibel's instructions about clearing the whole cache if you would like _all_ objects to be reloaded. -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2B

Re: ojb mixing up jdbc-connection-descriptors

2003-12-09 Thread Martin Kalén
. Thanks! -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: Connection.close() failed, message was Exception d'E/S: Socket closed

2003-12-09 Thread Martin Kalén
if Oracle kicked you out). Cheers, Martin -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40 - To unsubscribe, e-mail: [EMAIL

Re: how to reload cached object?

2003-12-09 Thread Martin Kalén
from cache) myRemoveFromCache(O) = removeFromCache(C);removeFromCache(O) load(O) (loads O and C from database) Thank you very much for your help. NP; trying to learn myself. :-) Cheers, Martin -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail

Re: OutOfMemoryError using commons-lang 2.0 and OJB 1.0rc4

2003-12-10 Thread Martin Kalén
-broker-cache. This can lead to java.lang.OutOfMemoryError if there are circular auto-retrieve references in the repository. ObjectCacheDefaultImpl can cope with this beacuse of it's static/global cache and would not reveal this mapping problem. Regards, Martin -- Martin Kalén Curalia AB

Re: how to mix obj and other jdbc pool in one application?

2003-12-11 Thread Martin Kalén
/howto-work-with-clustering.html Regards, Martin -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40 - To unsubscribe, e

Re: select question (again)

2003-12-18 Thread Martin Kalén
Hennebelle wrote: personnally, I put : criteria.addSql(date = TO_DATE('2004', '')); There's also: criteria.addEqualTo(date, TO_DATE('2004', '')); Works similar with all operators/'add'-methods on a Criteria. Regards, Martin -- Martin Kalén Curalia AB Web: http

Re: Problem with cursors

2003-12-18 Thread Martin Kalén
-- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e

Re: How to set null for a column for which the corresponding java type is long

2004-01-28 Thread Martin Kalén
} conversion=com.mycompany.PrimitiveLong2LongFieldConversion/ HTH, Martin -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40

Re: Performance difference between mapping number column to long vs BigDecimal

2004-01-28 Thread Martin Kalén
with Oracle (or even different versions on MySQL server). Regards, Martin -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40

Re: Clob : Coonection reset (??)

2004-02-25 Thread Martin Kalén
on the machine running OJB) 2. Update to OJB from CVS HEAD and use the new Oracle9i platform which supports Oracle-style inserts of large LOB values with the thin driver. If you switch to this platform both thin and OCI will work, but only OCI will support batch-mode=true. -- Martin Kalén Curalia AB

Re: Sanity Check on Sharing PersistenceBroker

2004-02-25 Thread Martin Kalén
this behaviour. (A two-level cache has been in the works for some time, and my bet is that you will see one in OJB 1.1). However; I don't consider myself as one of the gurus so feel free to disregard all of the above. :-D -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2B

Re: problem ClassCastException for addThisListenerTo

2004-02-25 Thread Martin Kalén
by changing the proxy-prefetching-limit to a value =0 in your repository -- typically on the collection-descriptor causing problems.) -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40

Re: [OTM] invalidating cache causes NPE on next collection query

2004-03-03 Thread Martin Kalén
. (If they are using Oracle at alla that is...) -- Martin Kalén Curalia AB Web: http://www.curalia.se Orrspelsvägen 2BMail: [EMAIL PROTECTED] SE-182 79 StocksundTel: +46-8-410 064 40 - To unsubscribe, e-mail: [EMAIL

Re: Oracle Blob socket write error and autoCommit(true) failed

2004-04-14 Thread Martin Kalén
. (But I would like to get a stab at this as soon as possible.) Unfortunately there doesn't seem to be a huge number of OJB developers with an Oracle server installation at hand, so development can be a bit slow at times - please contribute all you can. Regards, Martin -- Martin Kalén Curalia AB

Re: Mysql JDBC driver and reverse-db

2004-06-02 Thread Martin Kalén
pointless =) ..it seems that your chances are slim getting reverse-db to work. ...does anyeone know how to get the last driver working? Armin Waibel wrote on the comments for OJB154: Work on reverseDB is halted, we recommend to use another tool, e.g. Druid Regards, Martin -- Martin Kalén Curalia

Re: Oracle 9i date-timestamp tip

2005-03-14 Thread Martin Kalén
Bruno CROS bruno.cros at gmail.com writes: it's important to note that mapping date attributes such as java.sql.Time java.util.Date (with hours ...) and even java.sql.Timestamp using DATE oracle type IS NOT POSSIBLE since Oracle 9.2 !! (Hours are lost ... with all it can occurs too !) FYI:

Re: DBCP, Oracle9i Blob/Clob broken

2005-03-14 Thread Martin Kalén
Danilo Tommasina dtommasina at risksys.com writes: When using the Oracle9i platform storing Blobs/Clobs does not work when using the DBCP connection factory (org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl) Hi Danilo, thank you for your patch and suggestions. Unfortunately this

Re: Oracle Driver jdbc10.1.0.2

2005-03-14 Thread Martin Kalén
Thierry Hanot wrote: Hello All just for info. It does not look like bug but more like a small missing feature :) . A support of Oracle thin driver 10 does not exist in Ojb. It could be nice to have it in Obj 1.0 because normally ( just reading the documentation ) , there is is a lot of

Re: Oracle Driver jdbc10.1.0.2

2005-03-14 Thread Martin Kalén
Dougall Squair wrote: Are you running within a managed environment? We seem to be getting a similar exception when we use the Oracle9i platform support class, I suspect it's caused by WebLogic wrapping the Oracle connection object. Generic unwrapping of both Connection and PreparedStatement have

Re: May Be a Problem with Lob reader ????

2005-03-14 Thread Martin Kalén
Thierry Hanot wrote: Hello , i have a problem when loading some data from blob. I use the standard support of lob in plateform Oracle 9i. The problem is when i try to load object with a blob in different Thread. I request a broker from thread 1 for loading objects with lob. I request an other

Re: DBCP, Oracle9i Blob/Clob broken

2005-03-15 Thread Martin Kalén
Danilo Tommasina wrote: I found out that there is the method getInnermostDelegate() on the DBCP DelegatingPreparedStatement calling this will return the original PreparedStatement independently on how many hierarchies of wrappers DBCP is using. That's perfectly right -- yesterday I added a

Re: DBCP, Oracle9i Blob/Clob broken

2005-03-15 Thread Martin Kalén
Danilo Tommasina wrote: There is a problem with using Oracle and the default DBCP connection factory, since PreparedStatement caching in DBCP will eat all your Oracle cursors rather quickly. See the release notes for a work-around (set PSPoolFactory==null). In OJB 1.1 the configuration

Re: Oracle Driver jdbc10.1.0.2

2005-03-16 Thread Martin Kalén
Don Lyon wrote: I ran into a similar problem using JBoss as the managed environment. Could we add that to the list for 1.0.2? Hello Don, thank you for your report. protected static final String UNWRAP_CONN_METHOD_NAMES[] = getUnderlyingConnection /* JBoss */ [...]

Re: Excalibur Integration

2005-03-16 Thread Martin Kalén
Markus Wolf wrote: is there a way to reuse existing connections for the whole OJB setup? I've implemented a ConnectionFactory for OJB as Excalibur component, but when I create a new database and open it (as stated in the tutorials) the repository_database.xml part is always expected. Are there

Re: How to delete single objects in a referenced collection?

2005-03-16 Thread Martin Kalén
Hiller, Frank RD-AS2 wrote: In the first table I have the machines and in the second one the currently logged on persons. In the EMPLOYEES table I'm using a PK of two columns (PERSONALID / MACHINEID). I'm not using ID. When a person logs off, it is not deleted from EMPLOYEES table when using

Re: Oracle Driver jdbc10.1.0.2

2005-03-17 Thread Martin Kalén
Don Lyon wrote: It looks like unwrapping the connection in initializeJdbcConnection() is causing another problem for managed connections in JBoss. Trying to setStatementCacheSize throws the exception: Caused by: java.sql.SQLException: Statement Caching cannot be enabled for this logical

Re: Excalibur Integration

2005-03-17 Thread Martin Kalén
Markus Wolf wrote: So doesn't this log output mean the files are not found?... Am I missing something here? Can anybody give me a hint how to successful load the repository.xml from a jar-file? I have all repository parts in the root (default-package) of my jar-file. This setup works for me. OJB

Re: Oracle Driver jdbc10.1.0.2

2005-03-17 Thread Martin Kalén
Don Lyon wrote: Here's the debug from the statement cache exception: 2005-03-17 10:23:32,546 DEBUG [org.apache.ojb.broker.platforms.PlatformOracle9iImpl] PlatformOracle9iImpl could not enable Oracle statement caching. Original/unwrapped connection

Re: AW: How to delete single objects in a referenced collection?

2005-03-17 Thread Martin Kalén
Hiller, Frank RD-AS2 wrote: using p6spy was a good idea. I tryed the way of using only pb.store(obj) with the following result. I had a machine with three employees logged on. Now I let a fourth person log on to the machine on my test system. The person was added to the EMPLOYEES table, I can see

Re: AW: Oracle Blob

2005-03-17 Thread Martin Kalén
Geigl Maximilian, R235 wrote: does the plattform setting 'Oracle9i' only affect the client side and can i use it together with an 8i database, or do i have to use 9i on either side if i use Oracle9i in my connection descriptor. Very old post, but for the record I will answer anyway... See this

Re: bizarro errors

2005-03-17 Thread Martin Kalén
Charles N. Harvey III wrote: (MetadataManager.java:155) - No repository.xml file found, starting with empty metadata and connection configuration See also http://nagoya.apache.org/eyebrowse/[EMAIL PROTECTED]msgNo=16025 This has been known to be working (see my reply to Markus). Are you

Re: bizarro errors

2005-03-17 Thread Martin Kalén
Charles N. Harvey III wrote: I am using the binary release of OJB 1.0.1. And I don't know which XML parser I am using. I don't even know where to specify that. The only xml processing jar in my classpath is dom4j. Should something else be there? I just put xerces-2.4.0 in the WEB-INF/lib/ to no

Re: Excalibur Integration

2005-03-17 Thread Martin Kalén
Markus Wolf wrote: So doesn't this log output mean the files are not found?... Am I missing something here? Can anybody give me a hint how to successful load the repository.xml from a jar-file? As Charles Harvey just pointed out, if your are using a repository with a HTTP dtd-declaration the

Re: Excalibur Integration

2005-03-18 Thread Martin Kalén
Markus Wolf wrote: Thanks for your help, When the dtd is in the jar also (in the same directory) then it works. Great - but it really shows that the error reporting needs to be shaped up in that area. When specifying then ConnectionFactoryManagedImpl then each and every connection attempt is

Re: AW: AW: How to delete single objects in a referenced collection?

2005-03-18 Thread Martin Kalén
Hiller, Frank RD-AS2 wrote: is there a way to check if user uD was successfully associated to M? Have add and remove of associations to be done manually? What I was trying to say was just that you need to perform the operations on the vector that OJB returns, not to make a new vector, add an

Re: repository.xml partially read

2005-03-18 Thread Martin Kalén
Bruno CROS wrote: I setup a repository.xml as ojb-blank project description of my file is below. This file works very well on Tomcat over windows, but not at all on AIX ! This is the third subject on the same issue in a pretty short time, the other two were resolved by changing DTD declaration

Re: Composite primary keys

2005-03-18 Thread Martin Kalén
Mike Jackson wrote: I've been looking at the docs but I don't see one that screams here. Can someone point me at something that tell me how to setup for composite primary keys? Use primarykey=true on multiple field-descriptor elements, and the key will be composed as a composite of all those.

Re: How to shutdown OJB when stopping web context.

2005-03-24 Thread Martin Kalén
Greetings all, first off - all the different hints of how not to leave open connections at webapp shutdown (ie using DBCP in Tomcat and supply JNDI DataSource to OJB, or explicitly calling release methods in OJB at shutdown) are equally good ways of doing. Danilo Tommasina wrote: however it

Re: newbie

2005-03-30 Thread Martin Kalén
krupa B wrote: Can somebody suggest a good book or tutorials in easy to understand manner. Did you try the Getting Started section? http://db.apache.org/ojb/docu/getting-started.html You can also find useful info in the FAQ: Getting Started: http://db.apache.org/ojb/docu/faq.html#gettingStarted

Re: Setup Question.

2005-03-31 Thread Martin Kalén
Philip Denno wrote: Actually, I found the jar file, but now I get NullPointerExceptions. Did you check the JDO tutorial? http://db.apache.org/ojb/docu/tutorials/jdo-tutorial.html Regards, Martin P.S. JDO support in OJB is not yet production-ready, or as stated on the homepage: A full JDO

Re: DBCP, Oracle9i Blob/Clob broken

2005-03-31 Thread Martin Kalén
Danilo Tommasina wrote: we just upgraded to OJB 1.0.2, the fixes in Oracle9i platform work like a charm many, many thanks again for the great work to everybody that contributed. Hi Danilo, that's great to hear! Thank you for contributing valuable feedback, code suggestions and for reporting back

Re: Setup Question.

2005-04-04 Thread Martin Kalén
Charles Anthony wrote: Dear Mr/Ms List Admin - could you please remove this address from the mailing list. In progress... Also see your welcome mail from the list and the footer of every post for how to get in touch with the list owner directly. It's beginning to get on my nerves - I don't think I

Re: Setup Question.

2005-04-04 Thread Martin Kalén
Philip Denno wrote: I gave up as I ran into a bug with the implementation. I am sure the OJB JDO developers will want to hear your feedback, although the JDO layer is known not to be complete. I then found an article which used the PersistenceBroker (instead of the PersistenceManager) and it

Re: Setup Question.

2005-04-04 Thread Martin Kalén
Charles Anthony wrote: Dear Mr/Ms List Admin - could you please remove this address from the mailing list. In progress... Geir Magnusson Jr. (of the infrastructure team) has fixed this. Regards, Martin - To unsubscribe, e-mail:

Re: Connection problem

2005-04-07 Thread Martin Kalén
Bikram B Kapoor wrote: I am facing a serious problem with Connection in OJB. The situation this error occurs is when the site has been inactive for quite some time Use a validation query that just performs a fast/simple query to ping the database server. This can be eg SELECT 1

Re: OJB Listener :: Best practise

2005-04-07 Thread Martin Kalén
Nils Liebelt wrote: I need a simple Listener which methods get called after insert, update and delete. I just found Listener for Transaction stuff in the API. Any suggestions? If it is an option for you to modify your persistence beans, you can implement

Re: Used ConnectionManager instance could not obtain a connection, retrying...

2005-04-11 Thread Martin Kalén
Hari Om wrote: hello I am using JDK1.4, OJB, and Oracle 9.2.0.2 on SuSE Linux 9.0 We ha dthis Web Application Running for few months... and there was NO ACTIVITY on this web site in past 4-6 weeks... and now when I log on to that I get following ERRORS...wonder why... Oracle RDBMS will

Re: Used ConnectionManager instance could not obtain a connection, retrying...

2005-04-11 Thread Martin Kalén
Hari Om wrote: Thanks Martin...any other input on this? You're most welcome. Not sure what you mean with other input... Just click the link below and read my previous reply in the mail archive, for more detailed info on how to enable a validation query for OJB pooled connections: See

Re: generator, create-db on Oracle

2005-04-11 Thread Martin Kalén
Laran Evans wrote: So is there some trick to running the create-db task in the generator to create a database in Oracle? Just make sure that database hostname, port number and Oracle SID are all set in the oracle or oracle9i profile you are using in OJB. When I run the task I get a The Network

Re: generator, create-db on Oracle

2005-04-11 Thread Martin Kalén
Martin Kalén wrote: So is there some trick to running the create-db task in the generator to create a database in Oracle? Just make sure that database hostname, port number and Oracle SID are all set in the oracle or oracle9i profile you are using in OJB. P.S. I assume you performed check 1A

Re: Out of Memory on Large ResultSets/Needed: SetFetchSize Method

2005-04-14 Thread Martin Kalén
Andreas Bohnert wrote: Postgres (for example) don't use cursors on default. The PG jdbc driver loads the entire ResultSet all at once and keeps it in memory! So, even if you do a getIteratorByQuery the memory load on a large resultset is huge! You can get around this, if you set the fetchsize

Re: Out of Memory on Large ResultSets/Needed: SetFetchSize Method

2005-04-14 Thread Martin Kalén
Martin Kalén wrote: Postgres (for example) don't use cursors on default. The PG jdbc driver loads the entire ResultSet all at once and keeps it in memory! So, even if you do a getIteratorByQuery the memory load on a large resultset is huge! You can get around this, if you set the fetchsize

Re: Out of Memory on Large ResultSets/Needed: SetFetchSize Method

2005-04-14 Thread Martin Kalén
Martin Kalén wrote: Postgres (for example) don't use cursors on default. The PG jdbc driver loads the entire ResultSet all at once and keeps it in memory! So, even if you do a getIteratorByQuery the memory load on a large resultset is huge! You can get around this, if you set the fetchsize

Re: Out of Memory on Large ResultSets/Needed: SetFetchSize Method

2005-04-14 Thread Martin Kalén
Martin Kalén wrote: It might be possible to use fetch size 1 explicitly only for iterators, I will have a look at this too. This is a bigger refactoring since it affects internal statement creation and would need many internal methods' signature to be expanded with a flag and/or explicit size

Re: JNDI connection

2005-04-14 Thread Martin Kalén
Bobby Lawrence wrote: Nevermind - it seems that I needed to set the useAutoCommit='0' in my connection descriptor. That's right - WebLogic (and other EJB-containers) needs to handle this globally so that OJB does not commit a global transaction and breaks the container-managed transaction

Re: Sequence managers and insert triggers

2005-04-18 Thread Martin Kalén
Mike Jackson wrote: I'm running on an Oracle database (8i) with insert triggers to create artifical keys for my table records. The howtos seemed to indicate that SequenceManagerNativeImpl might be the proper sequence manager to use but the keys are coming out goofy, so clearly I'm not

Re: Oracle sequences...

2005-04-20 Thread Martin Kalén
Bobby Lawrence wrote: It seems that my database has triggers on it that insert the nextval from the sequence upon insert. So OJB determines the sequence, and then Oracle does the same thing. Thats why my sequences are being called twice... Also beware of Oracle sequence caching if your

Re: What are Transaction limits with autoupdate = true.?

2005-04-20 Thread Martin Kalén
Alessandro Colantoni wrote: Change are really written to the database. I get an error of MsSQLServer. Beware that MySQL using MYISAM storage in early versions [*] does not implement database transactions. Either use InnoDB if your licensing requirements permit it or try to upgrade to a newer MySQL

Re: Error invoking method (IndirectionHandler)

2005-04-20 Thread Martin Kalén
Lemke, Wesley wrote: Anyone have any luck setting up p6spy with Websphere 5.1? This is kind of on-topic because Thomas suggested I try it for debugging the OJB issue. Anyone familiar with this error: [4/15/05 10:07:48:319 CDT] 68779cc2 FreePool E J2CA0046E: Method

Re: Tomcat 5.5.9 and OJB?

2005-04-21 Thread Martin Kalén
[EMAIL PROTECTED] wrote: I belive some of this stuff was changed for them in 5.5 and the dbcp part is called: naming-factory-dbcp.jar I am not using another dbcp library. OJB is at the moment directly dependent on Commons DBCP to work at run-time, even if you don't use the Commons

Re: Tomcat 5.5.9 and OJB?

2005-04-21 Thread Martin Kalén
[EMAIL PROTECTED] wrote: I thought I would not need or even want the commons dbcp because of this speicific link: I was a bit unclear in my last post. Rephrase: * unless you change the default OJB.properties, OJB will not use DBCP * unfortunately there is a class-dependency at run-time from

Re: MySQL communication link failure

2005-04-28 Thread Martin Kalén
Stijn de Witt wrote: We have developed a web application using OJB. All seems to work fine, but after some hours of being deployed we run into a problem. snip/ java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1394) snip/ I have seen a number of solutions mentioned: 1)

Re: lazy materialization problem

2005-04-28 Thread Martin Kalén
Maksimenko Alexander wrote: I have tree like structure (with parent,children relationships). I'm using proxies to lazy materialize them. Everything works well but in particular cases I have to materialize the whole tree because folder.getChildren().get(0).getParent() is not the same as folder

Re: 1-1 Relationship Both ways

2005-04-28 Thread Martin Kalén
Lemke, Wesley wrote: Our problem occurs when we save a GenericGroup. It will first save the ClientBillingInfo object, so it puts -1 in the generic_grp_id field of the client_billing table (We are using database generated keys). If I understand you correctly, your problem is that your DB will set

Re: MetadataManager.copyOfGlobalRepository problem

2005-04-28 Thread Martin Kalén
Stas Ostapenko wrote: org.apache.commons.lang.SerializationException: java.lang.ClassNotFoundException : Domain So, java.lang.ClassNotFoundException occurs. But Domain.class is in the same directory with test_copyOfGlobalRepository. class ! At

Re: Proxy, Prefetching, Memory Usage

2005-04-28 Thread Martin Kalén
Jakob Braeuchi wrote: i just comitted a patch (OJB 1.1) to solve this problem. please have a look at it. FYI: the setFetchSize hint is available in OJB_1_0_RELEASE branch (as beta-status, with refactoring warning!) waiting to be merged with the trunk. Whenever I get a free timeslot I will look

Re: Problems with collections in ODMG - just upgraded to OJB 1.0.3

2005-04-28 Thread Martin Kalén
[EMAIL PROTECTED] wrote: I've always (in OJB ODMG) used cascading delete bounded by appropriate auto-delete settings; now it looks as if I have no choice but to delete each individual object by hand. True? Setting the cascading delete settings by relationship type (1:1, 1:n, m:n) seems

Re: MetadataManager.copyOfGlobalRepository problem

2005-04-28 Thread Martin Kalén
Stas Ostapenko wrote: So, here is new code public class Domain implements java.io.Serializable SerializationUtils needs Serializable classes by contract, this should probably be better documented. Any suggestions as to where in the docs/config files you would first look for this? (So we could

Re: MySQL communication link failure

2005-04-29 Thread Martin Kalén
Stijn de Witt wrote: The advantage of mastering the Commons Pool options is that this will work with all database servers that OJB supports, not just MySQL. Do you know if the autoReconnect=true option alone will fix it? I have seen mention of autoReconnectForPools option? We are not planning

Re: MetadataManager.copyOfGlobalRepository problem

2005-04-30 Thread Martin Kalén
Stas Ostapenko wrote: Hi Martin ! I`m using the following JVM java version 1.4.2_04 Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05) Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode) and no app servers or other software for this simple (work or not) test. Info

Re: MetadataManager.copyOfGlobalRepository problem

2005-04-30 Thread Martin Kalén
Stas Ostapenko wrote: Hi Martin ! I`m using the following JVM java version 1.4.2_04 Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05) Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode) and no app servers or other software for this simple (work or not) test. I just

Connection pooling: adjustment of object validation contracts

2005-04-30 Thread Martin Kalén
Greetings, as some of you know there have been previous discussions on the list about the responsibility for validation of discarded Connection instances in the object pools in OJB's default ConnectionManagerPooledImpl and ConnectionManagerDBCPImpl. A user-submitted patch applied to OJB's pooling

Re: Out of Memory on Large ResultSets/Needed: SetFetchSize Method

2005-05-02 Thread Martin Kalén
Andreas Bohnert wrote: Postgres (for example) don't use cursors on default. The PG jdbc driver loads the entire ResultSet all at once and keeps it in memory! So, even if you do a getIteratorByQuery the memory load on a large resultset is huge! You can get around this, if you set the fetchsize

Re: Out of Memory on Large ResultSets/Needed: SetFetchSize Method

2005-05-18 Thread Martin Kalén
Andreas Bohnert wrote: I have just run several tests with different hints. It works very well, however, if I don't set a hint, no cursors are used, even with getIteratorByQuery! Good to hear that it's working well! But maybe that's not too bad. If you enable cursors on iterators by default,

Re: Future of OJB?

2005-05-18 Thread Martin Kalén
Cesar Leite wrote: the project OJB will be interrupted? I certainly do not hope so! In that case, they forgot to tell me. ;) Cheers, Martin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: OJB-JDO why sequence increment in retrieve

2005-05-18 Thread Martin Kalén
Alessandro Vincelli wrote: I have tried, but I have had great problems. Tomcat always says: Message: Scheduler with name 'Cocoon' already exists. This is only the effect of a previous error. Cocoon has the following web.xml configuration: load-on-startup1/load-on-startup This means that Tomcat

Re: identity column

2005-05-18 Thread Martin Kalén
Vagula wrote: I have an identity column in my database. Lets day for example in Activity table we have identity column act_code. What are the steps I should be following? Do you want to: a) just map ACTIVITY.ACT_CODE as primary key in OJB? b) use database

Re: Oracle9i BLOB w/ JNDI datasource on WebLogic

2005-05-18 Thread Martin Kalén
Bobby Lawrence wrote: Nevermind on any of this... I have found the solutioneither upgrade to = OJB 1.0.2, or use WLOracle9i platform. Hi Bobby, since I have been working a bit in this area I do actually mind - even if it now works for you. :) I am interested in feedback from users running OJB

Re: P6Spy config

2005-05-18 Thread Martin Kalén
Charles Anthony wrote: Just a note on p6spy which may, or may not, be relevant : I've often had problems with processes finding the p6spy.properties file - it always seems to work for me if the file is in the current directory when the process starts. So, for tomcat, for example, it seems to read

Re: OJB cache :: Best Practise

2005-05-18 Thread Martin Kalén
Nils Liebelt wrote: Having some trouble with the OJB caching. I use the default implementation which should give a global cache for all Brokers. My Business objects have a store() method that inserts/updates this object towards the db and removes this object from the cache with the

Re: Executing plain SQL UPDATE statments in PB transactions

2005-05-18 Thread Martin Kalén
wilson lists wrote: I need to run a plain SQL Update inside a PersistenceBroker transaction. The DBMS is Oracle 8. Trimming your example a bit: broker = PersistenceBrokerFactory.createPersistenceBroker(pbKey); broker.beginTransaction(); conn =

Re: Oracle9i BLOB w/ JNDI datasource on WebLogic

2005-05-19 Thread Martin Kalén
Bobby Lawrence wrote: I am currently working on another project for a short time, but I am going back to our OJB/WebLogic/Oracle9i project soon. We are currently on OJB 1.0.1, but I am planning on upgrading to 1.0.3 soon. When I get a chance, I will test the regular Oracle9i platform and tell

Re: P6Spy config

2005-05-19 Thread Martin Kalén
[EMAIL PROTECTED] wrote: Martin, Can you elaborate on this a bit? Why does the change in location of spy.properties solve the problem? Should deregister work on its own? Also, would a similar consideration apply if Tomcat is using a JDBC-based realm? I've never had any luck getting p6spy to

Re: 1.0.0 - 1.0.3 differences (log)

2005-05-24 Thread Martin Kalén
Edson Carlos Ericksson Richter wrote: Could someone point me to a change log or something else (if exists), or if this not exist, just tell me - so I don't stay looking for something that I'll never find ;-) You could try eg:

Re: Use OJB and JNDI Data Source

2005-05-31 Thread Martin Kalén
Júlio Cesar de Melhado e Lima wrote: I'm using Tomcat 5.0.28, Postgres 7.4 and OJB 1.0.1. So, I made available a JNDI Resource mydatasource, and this resource is accessable ( I wrote a tiny jsp page to lookup for this object and everything looks fine ). Then a change the file

Re: Incompatible class Exception

2005-05-31 Thread Martin Kalén
Bobby Lawrence wrote: I just upgraded from OJB 1.0.1 to 1.0.3 and I keep getting an java.io.InvalidClassException: snip/ I have NOT changed my OJB.properties file, could this have something to do with it? Without looking to deeply into the stacktrace you sent; it is always recommended to

Re: I am having a problem with enhancing a .class for JDO

2005-05-31 Thread Martin Kalén
Rahul Srivastava wrote: Hi i am having a rpoblem with JDO . please help me for this. snip/ [java] com.sun.jdori.enhancer.util.InternalError: assertion failed: cannot find class file for class: org/apache/ojb/tutorial5/Product snip/ BUILD FAILED D:\ojb-blank\ojb-blank\build.xml:226: Java

Re: JDO Query / indexed column

2005-05-31 Thread Martin Kalén
Philippe Guillard wrote: Thanks Charles, Unfortunately i get the same result without parameter. ( I use JDO 1.01 form Sun, OJB as integrated in cocoon framework). You guess right i 've built the DB by hand before and adapted a repository later. It is not supposed to be used at runtime, but i

Re: JDO Query / indexed column

2005-05-31 Thread Martin Kalén
Martin Kalén wrote: The index-descriptor is (as Charles pointed out) only used if you generate DDL/SQL with OJB using Torque. If you create your database by hand, you can remove all index-descriptor attributes to get a cleaner OJB repository. Clarification: The index-descriptor attribute

Re: Deep down

2005-06-01 Thread Martin Kalén
Nils Liebelt wrote: I get a wired Exception thrown by a OJB application seems like something deep out of the MySQL JDBC. snip/ The error only occures when the system isn't answering any request for a while. snip/ java.sql.SQLException: Communication link failure: java.io.EOFException, You

Re: Incompatible class Exception

2005-06-02 Thread Martin Kalén
Armin Waibel wrote: Well - The OJB jar is not in the web-app classpath. I have the jar in the EJB classpath. I have removed it and I get the desired effect...the app server can't find the PersistenceBroker class. When I use ANY version of 1.0.1, I get this exception. you mentioned that you

Re: java.lang.NoSuchMethodError on criteria.addLike

2005-06-02 Thread Martin Kalén
Alessandro Colantoni wrote: I'm trying to use the ojb implementation of PropertySet (a framework of opensymphony.com http://opensymphony.com) There is a piece of code Criteria critere = new Criteria(); critere.addEqualTo(globalKey, globalKey); critere.addLike(itemKey, key); When executing

Re: JDO Query / indexed column

2005-06-06 Thread Martin Kalén
Philippe Guillard wrote: Then i red somthing i should read before in FAQ section 3.3 I recommend to not use JDO now, but to use the existing ODMG api for the time being and wonder if this would affect my problem too... Any suggestion / what i should do next? If you have any doubts about the

Re: This feature is not supported by this implementation - UnsupportedOperationException

2005-06-06 Thread Martin Kalén
Dennis Riedel wrote: repository_database.xml: # jdbc-connection-descriptor default-connection=true jcd-alias=postgres-pool platform=postgresql subprotocol=postgresql Is it a MUST DO to configure OJB for a specific database before BUILD ? I just compiled cocoon with the JDO libraries

  1   2   >