Hi,
Another option would be to use the p6spy jdbc driver
http://www.p6spy.com/ which, if I remember correctly logs the time taken
to execute the statement as well as the statement itself.
Cheers,
Charles.
-Original Message-
From: Armin Waibel [mailto:[EMAIL PROTECTED]
Sent: 15
Hi,
It's not possible to do this type of query using ODMG/OQL.
You have to use the PB API. You can use the PB Style quries from
within ODMG - see
http://db.apache.org/ojb/docu/guides/odmg-guide.html#I+don%27t+like+OQL%
2C+can+I+use+the+PersistenceBroker+Queries+within+ODMG
for more details
Hi,
You could write your own ConnectionFactory
http://db.apache.org/ojb/docu/guides/connection.html
And execute the appropriate statement in the lookup method.
E.g.
public class MyConnectionManager extends ConnectionFactoryDBCPImpl {
public Connection
No, it's not really a bug;
Let's say you have objects A, B and C where C is an objject mapped onto a view
joining A B.
OJB Caches objects on their Class + PK; when you update an object, it is
ejected from the cache based on it's class and PK.
So, let's say C with a PK of one is references
explicitely read the view. At
that point my expactation was to retrieve the new value. The
SQL statement returns the correct (new) value, but ojb uses
the object from the cache with the old value. This confuses
me a little.
Best regards,
Frank
-Ursprüngliche Nachricht-
Von: Charles
/
on the specific table (that actually is a view) resolves the problem?
Frank
-Ursprüngliche Nachricht-
Von: Charles Anthony [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 19. September 2006 16:04
An: OJB Users List
Betreff: RE: Support of database views
Yes, but all (by default
-Ursprüngliche Nachricht-
Von: Charles Anthony [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 19. September 2006 16:09
An: OJB Users List
Betreff: RE: Support of database views
Well, that's my guess...
-Original Message-
From: Hiller, Frank RD-AS2 [mailto:[EMAIL PROTECTED]
Sent: 19
Hi,
I'm afraid the answer is simply no. Joins in OJB queries can only be done
by using the references defined in the metadata.
My suggestion would be to dynamically add/remove the class metadata for
A/B/C at runtime (or indeed permanently) with references to TEMP. The TEMP
entity should not be
-Original Message-
From: Thomas Dudziak [mailto:[EMAIL PROTECTED]
Sent: 19 June 2006 22:26
Subject: Re: Bug : duplicate objects in resultset : Why add orderby
columns to resultset?
On 6/19/06, Janssen, Roger [EMAIL PROTECTED] wrote:
Diving deeper into the OJB code I see that
From: Thomas Dudziak [mailto:[EMAIL PROTECTED]
Sent: 03 May 2006 15:55
On 5/3/06, Anjishnu Bandyopadhyay [EMAIL PROTECTED] wrote:
I am looking for an alternative to the implementation of
CallableStatement Java API.
If you want to insert/update/delete a Java object (or more
= Lina's Father so Abou = Father and Lina is
the name of my daughter. so is only an alias and not my realy name.
thx in advance.
On 4/6/06, Charles Anthony [EMAIL PROTECTED] wrote:
The AS400 has it's own JDBC driver, which talks to a different set of
background jobs on the AS400
The AS400 has it's own JDBC driver, which talks to a different set of
background jobs on the AS400. They are (in theory) more efficient that the
DRDA jobs which the normal DB2 driver uses when talking to the AS400.
Abou Lina (or Lina Abou - sorry not, sure which way round your names go) :
what is
The AS400 schema/library you are using does not have journalling turned on
- but the AS400 JDBC driver needs it turned on. See
http://www-03.ibm.com/servers/enable/site/java/jdbc/jdbcfaq.html#B20
In short : for simplicity, you should create the AS400 library using either
of theses SQL
Not directly, but we are using OJB on iSeries just fine, using the standard
DB2 platform.
-Original Message-
From: Bruce Benfield [mailto:[EMAIL PROTECTED]
Sent: 14 December 2005 17:21
To: OJB Users List
Subject: Zseries db2 support
Has anyone attempted this ?
thanks
It could simply be a timeout issue.
Do you have a connection pool setup ? Do you close idle connections - i.e.
if a connection has been unused in the pool for more than, say, 5 minutes -
do you close it ? This can be configured with the DBCP connection pool, and
I imagine it can with the Tomcat
Hi,
In this case, you would have to modify your jndi-datasource to use the
P6SpyDriver...
Cheers,
Charles.
-Original Message-
From: Vamsi Atluri [mailto:[EMAIL PROTECTED]
Sent: 19 August 2005 14:22
To: OJB Users List
Subject: Re: optimistic locking problems (P6Spy question)
Hello
Hi Luc,
PersistenceBroker pb = ... /* however you get your PB */
pb.beginTransaction(); // This will associate a connection with the pb
java.sql.Connection connection =
pb.serviceConnectionManager().getConnection();
/* Do your stuff */
pb.commitTransaction(); // This will close/return the
Hi,
Just so you don't think you're being ignored - what you are doing looks
correct to me.
I'm afraid I don't know why you are getting that exception, and I'm sorry
but I've not currently got any time to look in any detail; hopefully Armin
or someone will be able to look closer...
Cheers,
OK - quick response, no, it is not possible to map to temporary tables in
OJB.
However, it might be possible to dynamically change the repository metadata
to point to the temporary table...
-Original Message-
From: Bruno CROS [mailto:[EMAIL PROTECTED]
Sent: 27 June 2005 10:17
To: OJB
remove all
index-descriptor
attributes to get a cleaner OJB repository.
Also, the following is a key issue:
Charles Anthony wrote:
The database always decides what indexes to use, never OJB !
What you should do to get OJB to use database indexes is use P6Spy or
the logtrace from your
Hi Phillipe,
The database always decides what indexes to use, never OJB ! OJB knows
nothing about indexes (the repository.xml entry is, or used to be, used to
generate the SQL/DDL to create the tables in the database. It isn't used at
runtime)
The SQL query that has been generated *doesn't* use
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 the file from
Just define the candidate key as th primary key in the repository.xml;
everything should work fine.
OJB Does not *need* the foreign key and primary keys defined as constraints
in the database at all...
-Original Message-
From: Mcgough, Brian Joseph [mailto:[EMAIL PROTECTED]
Sent: 14 May
Hi,
I'm trying to help one of my developers with a query - and I have to say, I
don't OJB can cope with it at the moment.
Essentially, we want OJB to generate some SQL to do some arithmetic in the
where clause - e.g.
SELECT FROM ... WHERE (COLUMNA + COLUMNB - COLUMNC) = 0
I'd like a
Here's a quick off the cuff list of steps for listeners that work for both
ODMG PB, based on what we do here.
a) Create your own persistence broker factory, extending
PersistenceBrokerFactoryDefaultImpl
b) Override createNewBrokerInstance(PBKey key) and add your listener(s)
you know if listener state events (afterBegin, afterCommit, ...) are
going to be invoked in managed environment?
Thank you,
Max.
-Original Message-
From: Charles Anthony [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 07, 2005 9:12 AM
To: 'OJB Users List'
Cc: [EMAIL PROTECTED]
Subject: RE
Dear Mr/Ms List Admin - could you please remove this address from the
mailing list.
It's beginning to get on my nerves - I don't think I could put up with it
until the beginning of may ! (Especially since I don't get a holiday until
Christmas...)
Cheers,
Charles.
-Original Message-
May I suggest that you simply dump the class to the stderr e.g. something
like this
Object tmp = result[1];
System.err.println( tmp == null ? Null : message.getClass().getName() +
= + String.valueOf(tmp));
This should show you what to cast to (as well as the value returned).
Tangent
Alternatively, either in one of your Servlets destroy methods (or via webapp
context listener, or however you currently do your shutdown logic) get the
connection factory and invoke the releaseAllResources method
http://db.apache.org/ojb/api/org/apache/ojb/broker/accesslayer/ConnectionFac
Hi,
OJB uses prepared statements to generate queries - e.g.
SELECT blah FROM foo WHERE datecreated = ?
It then uses the JDBC driver to bind the values to the query
PreparedStatement#setObject(ix, value, targetSqlType)
The problem is that the connection pool is being exhausted - looking at
the exception, the pool is configured with a max 20. I suspect this is
because the broker is not being closed; you must close the broker when you
are finished with it.
Cheers,
Charles.
-Original Message-
From:
Hi,
I believe the reason that you've not had any answers on questions relating
to OJB-JDO plugin is that few people are using it.
I believe that the reason that people aren't using it are that Sun's
licensing on the JDO RI prevents it's use in production environments. Of
course, I am happy to be
Hi Michael,
You said earlier I have put the needed xml files in the folder where my
application is - could you please be a little clearer ?
Could you show us the folder layout - i.e. where the classes are, where the
xml files are, what the names of the xml files are, and what the
working/current
Hi,
OJB definitely ISN'T finding it there - your log specifically says :
(metadata.RepositoryPersistor? ) OJB Descriptor Repository:
file:/C:/Program%20Files/eclipse3.0/workspace/TSSt/bin/repository.xml
Cheers,
Charles.
-Original Message-
From: Phillip Blevins
Hi Frank,
Are your OJB jars stored in the WebApp itself, or in a shared directory e.g.
tomcat\common ?
Essentially, it's important that OJB classes be stored within the WebApp
themselves, as opposed to anywhere else. e.g.
App1
WEB-INF
lib
db-ojb-Blah.jar
Hi,
Currently, that feature is not available in OJB.
Sorry.
Charles.
-Original Message-
From: Herselman, Thinus [mailto:[EMAIL PROTECTED]
Sent: 05 November 2004 08:11
To: '[EMAIL PROTECTED]'
Subject: Pessimistic Locking?
Hi, I'm not sure if I'm missing something, or
That'd be cool - I've never even heard of it, and a search of the mailing
list archives only turns up references in code for patches.
Anyone got a handy description of what projectionAttribute does (and how
it's different to, say, prefetchedRelationship) ?
Cheers,
Charles.
-Original
Hi,
What is the query you are executing (i.e. how do you build
oReportQueryByCriteria)?
Cheers,
Charles.
-Original Message-
From: Sathish [mailto:[EMAIL PROTECTED]
Sent: 18 October 2004 17:04
To: [EMAIL PROTECTED]
Subject: Query Performance very slow for retrieval
Hi All,
-Original Message-
From: Mark Neighbors [mailto:[EMAIL PROTECTED]
Sent: 06 October 2004 20:54
To: [EMAIL PROTECTED]
Subject: We need to migrate from ODMG to clustering with opt locking. If
this possible?
We need to know if OJB will support clustering with a low-cost migration
from
Hi,
Between 1.0.0 and 1.0.1, some improvements were made to reading rowsets. The
result was that columns were being read twice - and the MSSql jdbc driver
throws a hissy fit if columns are re-read when there's a blob (or
longvarchar or something similar) in the resultset.
To get round this, we
Hi,
Yes, I can confirm the StatementsForClassImpl does cache the generated SQL
for each class, and the ClassDescriptor keeps hold of the
StatementsForClassIF.
I would agree that your best way forward would be to implement a new
StatementsForClassIF. (I would suggest subclassing the existing
Hi,
We do something similar (for different reasons).
We use a thin layer (closed source, sorry) above the OJB layer, and have
created simple lazyBegin, lazyCommit methods that respectively open and
close the pb transaction - lazyBegin begins a transaction if one has not
already been started and
:43
To: OJB Users List
Subject: RE: Transaction Isolation Level
Hi,
We are also using a thin layer above the OJB layer.
How do you check whether a transaction is active (isBegun()??)
Thanks,
Frank Renaers
Ikan Software
-Original Message-
From: Charles Anthony [mailto
]
Sent: 16 September 2004 10:00
To: OJB Users List
Subject: RE: Transaction Isolation Level
Or maybe it's better to use
'TxManagerFactory.instance().getTransaction()'
to check whether there's a transaction for the calling thread.
-Original Message-
From: Charles Anthony
Hi,
It is possible to specify the location of the OJB.properties file - see the
bottom of http://db.apache.org/ojb/docu/guides/ojb-properties.html for
details. Essentially, you can set a system property to specify the location
- but you can only have one value for that system property for the
Hi,
One possibilty that is worth investigating is garbage collection : how often
is it happening, how much garbage is, um, being collected and so on. I don't
wish to teach grandmothers to suck eggs - but making sure that garbage
collection is efficient really does have an impact on long running
Hi,
OJB does not support Cloudscape out-of-the-box, no, although one probably
could make OJB support it.
It does support HSQLDB, though, which is another open-source just-java
database.
Cheers,
Charles.
-Original Message-
From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
Sent: 17
Hi,
java.sql.TimeStamp
Cheers,
Charles.
-Original Message-
From: Joncheng Kuo [mailto:[EMAIL PROTECTED]
Sent: 11 August 2004 17:26
To: OJB Users List
Subject: mapping of the datetime type
Hi,
I have a column of type 'datetime' in a MS SQL database. What type
should I use
Hi David,
Another approach : if you get your persistent objects to implement
org.apache.ojb.broker.PersistenceBrokerAware interface, you could then
implement the afterLookup method e.g.
public void afterLookup(PersistenceBroker broker) {
_postinit();
};
The afterLookup method is invoked
Sheesh - I can't even type my name properly today.
It's got to be Monday.
Cheers,
C.H.A.R.L.E.S.
-Original Message-
From: Charles Anthony [mailto:[EMAIL PROTECTED]
Sent: 26 July 2004 10:05
To: 'OJB Users List'
Subject: RE: how to postinitialize objects after being completely
Hi,
The easiest way to do this is to use p6spy.
Please see the FAQ at http://db.apache.org/ojb/docu/faq.html#traceProfileSQL
Cheers,
Charles.
-Original Message-
From: Tino Schöllhorn [mailto:[EMAIL PROTECTED]
Sent: 26 July 2004 12:18
To: [EMAIL PROTECTED]
Subject: Debugging
Just for curiosity what is the purpose of you own calendar class ?
from Calendar apidoc:
Subclasses of Calendar interpret a Date according to the rules of a
specific calendar system. The platform provides one concrete
subclass of
Calendar: GregorianCalendar. Future subclasses could
Imagine, you use the DummyCalendar in Calendar2DateFieldConversion.
javaToSql will be ok.
(... if (source instanceof Calendar) ...)
but sqlToJava will materialize not the DummyCalendar (that you need),
but a GregorianCalendar.
(... GregorianCalendar cal = new GregorianCalendar()...)
-Original Message-
From: Thomas Mahler [mailto:[EMAIL PROTECTED]
Sent: 12 April 2004 07:06
To: OJB Users List
Subject: Re: HSQLDB Issue
[...]
The other issue is that I can't seem to find a way to get
OJB to find
the hsqldb script and data files directly within the exploded
Hi,
The jdbc driver is having trouble connecting to the SQL Server machine. My
German is a little rusty, (and babelfish not overly helpful), but I suspect
it's complaining that it can't connect to the socket.
a) Is the host SERVER your local machine ?
b) Can windows resolve SERVER to a TCP/IP
Hi Dirk,
I'm afraid this would not be possible using OJB. OJB is, at it's very lowest
level, simply converting the query objects (or OQL) into ordinary SQL
Queries.
It is not possible (at least, not as far as I am aware) for SQL queries to
span multiple
Hi Edson,
From: Edson Carlos Ericksson Richter
[mailto:[EMAIL PROTECTED]
Sent: 08 March 2004 13:56
To: 'OJB Users List'
Subject: OJB rc5 don't call toString in the object when using Proxies
Hi!
I'm asking you to remove the feature that make OJB doesn't
materialize a object when
Hi all,
Following my query last week, I've botched my query to use the
ojbConcreteClass directly. I now have a problem that the generated SQL for
the following sample is incorrect :
Criteria criteria1 = new Criteria();
criteria1.addEqualTo(outPayment.agreement.ojbConcreteClass,
In a word, Yes.
You Must.
Cheers,
Charles.
-Original Message-
From: Ziv Yankowitz [mailto:[EMAIL PROTECTED]
Sent: 05 February 2004 13:37
To: OJB (E-mail)
Subject: OJB - Constructor.
Folks,
Can anyone tell me if we must have an empty constructor in
Objects we want to
Hi,
If you want to use optimistic locking with the standard OJB distribution,
you have to have a locking field. One approach you could take would be to
create JdbcAccess access implementation which does it's own optimistic
locking; I suggest this as
Hi,
From the javadoc for interface org.apache.ojb.broker.core.PersistenceBroker
:
/**
* Begin a transaction against the underlying RDBMS.
* Calling codebeginTransaction/code multiple times,
* without an intervening call to codecommitTransaction/code or
Hi Jakob,
I think an addNot(Criteria crit) would make more sense, be more flexible,
and be more in fitting with the rest of the QueryByCriteria API.
e.g.
Criteria main = new Criteria();
Criteria subCriteria = new Criteria();
subCriteria.addEqualTo(field1,test1);
I think you'll find that putting OJB in /common/lib is your problem.
Try putting the the OJB jars in the each webapps WEB-INF/lib directory, and
see if the problem goes away.
I think it will.
Cheers,
Charles.
-Original Message-
From: Michael Mogley [mailto:[EMAIL PROTECTED]
Sent: 09
-connection-descriptors
You're probably right. But is there no way then to keep Ojb
as a shared
library?
Michael
- Original Message -
From: Charles Anthony [EMAIL PROTECTED]
To: 'OJB Users List' [EMAIL PROTECTED]
Sent: Monday, December 08, 2003 11:23 PM
Subject: RE: ojb mixing up
You must cast to InterfaceNotaRecibo not NotaRecibo.
-Original Message-
From: Glauber Andrade [mailto:[EMAIL PROTECTED]
Sent: 26 November 2003 15:28
To: [EMAIL PROTECTED]
Subject: proxy ClassCastException
Importance: High
I am trying to use proxy (my first time) and I am
That's what I thought, untill I realised that eric's strings are stored as
rows in a table, as opposed to a single column.
Cheers,
Charles.
-Original Message-
From: Mahler Thomas [mailto:[EMAIL PROTECTED]
Sent: 24 November 2003 16:31
To: 'OJB Users List'
Subject: RE: Collection of
Hello,
I've followed the descussion about hibernate and OJB.
Yes - that's probably the biggest difference between OJB and
Hibernate.
Hibernate want KISS, OJB want ultimate flexibility ;)
What does KISS mean?
Please explain, I don't understand?
KISS is an acronym, meaning
Keep
Hi,
Check your class. I think you'll find that Application.releaseDate is a
java.sql.Date and *not* a java.util.Date.
The error message is saying com.itservices.woc.data.Application has an
attribute releaseDate with a type of java.sql.Date, but I have a value of
java.util.Date.
that we could define the format in OJB.
I could do the conversion with Java but it's lot of work.
What do you think?
Thanks
Regards
Sylvain
-Message d'origine-
De: Charles Anthony [mailto:[EMAIL PROTECTED]
Date: mardi, 18. novembre 2003 10:09
À: 'OJB Users List'
Objet: RE
Hi,
Just to clarify the clarification :
Finally, the licensing issue is either a
huge difference or a doesn't-matter depending on your
company's lawyers
and/or how you intend to distribute the application -- OJB is ASL
Hibernate is LGPL.
Just remember to read of license faq
Give us a chance - it's early Monday morning over here in (Western) Europe !
Alot of OJB developers are in Europe, and only deal with OJB mailing lists
during the working week.
http://druid.sourceforge.net will (I believe) generate repository, and
classes from a given database.
I've not used it,
Hi,
I've not dabbled with per-thread repositories, so take-with-a-pinch-of-salt,
but :
a) Are the threads coming from a pool ?
b) Do you ever mm.setDescriptor(null); ?
A quick scan of the source suggests that the per-thread descriptors are
stored in a ThreadLocal,
so mm.copyOfGlobalRepositor()
From: Jason Pyeron [mailto:[EMAIL PROTECTED]
On Mon, 17 Nov 2003, Robert S. Sfeir wrote:
I've figured out how to import existing tables if anyone is
interested.
Setup your jdbc driver
...
Choose Import Entities
Check everything
where are the foreign keys
[...]
I
Hi Sylvain,
It's probably a language misunderstanding, but : which dates, where, and why
do you think they are in the wrong format ?
A little more information on your problem would be helpful - but, as a
pointer, if you have a java.util.Date (or a java.sql.Date) attribute on an
object and you
, maybe the wrong list for this question (more a Java
coding question).
Thanks
Sylvain
-Message d'origine-
De: Charles Anthony [mailto:[EMAIL PROTECTED]
Date: vendredi, 14. novembre 2003 16:26
À: 'OJB Users List'
Objet: RE: Date: how to retrieve them in european format
Hi,
It is not possible to do this in a cross platform way, so No, currently this
is not possible in OJB.
For an explanation of the reasons why, see
http://article.gmane.org/gmane.comp.jakarta.ojb.user/10065/match=paging+perf
ormance+issues
Cheers,
Charles.
-Original Message-
From:
?
On November 11, 2003 6:41 am, Charles Anthony wrote:
Hi,
It is not possible to do this in a cross platform way, so
No, currently
this is not possible in OJB.
For an explanation of the reasons why, see
http://article.gmane.org/gmane.comp.jakarta.ojb.user/10065/mat
ch=paging+per
f
Message-
From: Andy Czerwonka [mailto:[EMAIL PROTECTED]
Sent: 11 November 2003 14:11
To: OJB Users List
Subject: Re: only grab 10 records
Oracle 9i
On November 11, 2003 6:49 am, Charles Anthony wrote:
Which Database ?
-Original Message-
From: Andy Czerwonka [mailto
Hi
1) Using getStartAtIndex() and getEndAtIndex(): this sounds like an
efficient way but if I look into the DB log there's no LIMIT option in
the SQL query! This is really surprising isn't it?
Currently, OJB does not attempt to use the LIMIT option. This is not
particularly surprising, since
It seems that you are using PlatformSybaseASAImpl.
Try using PlatformSybaseASEImpl :
jdbc-connection-descriptor platform=SysbaseASE ...
in repository.xml
(I know nothing about this, I just looked in the source code and saw there
were two different platforms for Sybase, one of which executes
It's not using a database sequence; Mark is testing the
SequenceManagerHighLowImpl (see other mail messages), which does not use db
based sequences.
Moreover, MS Sql does not support native datbase sequences - and, as Mark
mentions, he is using MS SQL.
Cheers,
Charles.
-Original
P6SPY ?
It's dead easy to use; p6SPY is a wrapper jdbc driver.
a) Ensure p6spy.jar is in the classpath, as well as the
b) find spy.properties in the OJB distribution - it's about somewhere. Copy
it, and place it on the classpath - actually, with the version of p6spy
distributed with OJB, we've
Hi,
at line 27, you should repeat lines 9-13.
At line 10 PersistenceBrokerFactory.defaultPersistenceBroker() asks the pool
for a broker, creating one *if* *necessary*.
broker.close releases some resources from the broker, and returns the
broker to the pool.
In other words, after you close the
Sylvain
-Message d'origine-
De: Charles Anthony [mailto:[EMAIL PROTECTED]
Date: lundi, 27. octobre 2003 11:27
À: 'OJB Users List'
Objet: RE: problem with PB instances creation
Hi,
at line 27, you should repeat lines 9-13.
At line 10
Message-
From: Charles Anthony [mailto:[EMAIL PROTECTED]
Sent: October 27, 2003 7:03 AM
To: 'OJB Users List'
Subject: RE: problem with PB instances creation
Hi,
Hello,
OK! It is a bit clearer for me, thanks.
Each time I want to use a broker I should do:
broker
Hi,
Problem is that an class name attribute is empty.
It seems that your first extent-class has an incorrectly spelled class-ref
attribute (you have calls-ref).
Cheers,
Charles.
-Original Message-
From: Reitsam Andreas [mailto:[EMAIL PROTECTED]
Sent: 23 October 2003 08:18
To:
being executed. Correct?
On Thu, 2003-10-23 at 00:32, Charles Anthony wrote:
Hi,
It is indeed to do with caching.
Let us have a one-to-many relation : A has many Bs.
We modify A (but leave it's related B's alone), and A
remains in the cache.
We then create a B, and associate
Hi,
TransactionExt was introduced after rc4 - so yes, new-and-unreleased. No
idea to the latter.
If you cast to TransactionImpl (as opposed to Ext), you should be able to
access the markDirty method, as this has been available for some time.
Cheers,
Charles
-Original Message-
From:
Hi Axel,
This may be a completely stupid question, and irrelevant, but do you have an
index created on column hisOID ?
If not, Is hisOID actually marked as being a primary key (i.e. does it have
a primary key constraint) ?
The syntax you specify in the first example is *not* generated by OJB,
Hi,
I, too, have had problems with this algorithm - and, it is not just deletes
that have a problem - my FK violations actually happen on an insert update.
My particular scenario was solved by calling re-order twice.
I then patched my local copy to call re-order until no changes were
performed.
Hi,
Some time ago, I ran a comparison of MSSql drivers.
http://article.gmane.org/gmane.comp.jakarta.ojb.user/7367
http://article.gmane.org/gmane.comp.jakarta.ojb.user/7369
(Note The first link contained errors which I updated in the second
reference)
As I said in the original post, the
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 09 October 2003 11:01
To: [EMAIL PROTECTED]
Subject: Choose columns to update
Hi all,
I need to tell OJB which columns to update when persisting an object
(instead of updating all mapped fields). Can
Hi,
[...]
(did anyone uses OJB for DB2 before?).
Yep - we're using OJB on DB2/400, with no major problems.
Cheers,
Charles.
This email and any attachments are strictly confidential and are intended
solely for the addressee. If you are not the intended recipient you must
not disclose,
Hi,
You need to ensure that you are closing the broker.
public void onEvent(){
PersistenceBroker pb =
PersistenceBrokerFactory.defaultPersistenceBroker();
pb.store(this); // or whatever it is you want to do with the broker
pb.close();
}
You should only get brokers when you need them,
Morning all,
I have a base class Agreement. It has several 14 subclasses, all mapped to
the same table AGREEMENT. I have an ojbConcreteClass attribute correctly
configured.
One of the subclasses of Agreement is ServiceAgreement. If I do a
QueryByCriteria for all ServiceAgreements
HI Jay, Armin And All,
-Original Message-
From: Armin Waibel [mailto:[EMAIL PROTECTED]
Sent: 01 October 2003 01:18
To: OJB Users List
Subject: Re: User/Password for JDBC Connection
Hi Jay,
- Original Message -
From: Xu Jie [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi,
Not out-of-the-box, no.
However, all the metadata is modifiable at runtime. We do something like the
following code.
Hope that helps
Charles.
private void init {
JdbcConnectionDescriptor connectionDescriptor =
getConnectionDescriptor();
Properties databaseProperties =
Hi,
Only by sneaking round the backdoor to get a connection, and
preparing/executing/etc the statment yourself. See
http://db.apache.org/ojb/faq.html#FAQ25, Question : Can I directly obtain a
java.sql.Connection within OJB?
BTW Thomas Et Al : The HTML anchors in the FAQ don't seem to working.
: Charles Anthony [EMAIL PROTECTED]
To: 'OJB Users List' [EMAIL PROTECTED]
Sent: Friday, September 12, 2003 1:52 PM
Subject: RE: query before commit problem
Hi,
As Thomas says, this is by design. However, you can force the
transaction
to
flush all object
Hi Edson,
You say you're working client-server with OJB. Assuming that you do all
the persisting on the server side (i.e. OJB only used on the server), you
could use a PBListener for BeforeUpdate/Insert events, and set the datetime
then (using a java.sql.Date).
If you really just want to
1 - 100 of 141 matches
Mail list logo