Re: "competitive locking" configuration

2003-03-23 Thread Geoff Gerrietts
Quoting Armin Waibel ([EMAIL PROTECTED]):
> > Should I just be setting up ObjectCacheEmptyImpl instead of
> > ObjectCacheDefaultImpl? Is that enough?
> 
> Yes, this should be enough.
> (And it's recommended to use an database based sequence manager
> implementation, like SequenceManagerNextValImpl or your
> own impl.)

Thanks!

I'm not sure I understand the differences between the various sequence
managers very well. What I know is entirely taken from the
documentation for repository.xml, and that was not really explicit (or
maybe "verbose" is the word I'm after) enough to clue me in.

Should I be looking somewhere else, or should I be reading the source
code?

Thanks again,
--G.

-- 
Geoff Gerrietts "He was a great patriot, a humanitarian, a loyal friend;
<[EMAIL PROTECTED]>  providing, of course, he really is dead."
http://www.gerrietts.net/   --Voltaire

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: OJB + Custom connection

2003-03-23 Thread Armin Waibel
Hi,

> In the same vein, is it possible to use different metadata
(repository.xml)
> for different connections, dynamically?

sorry, currently not directly. It's only possible to change metadata per
thread or global at runtime. But this should be sufficient to
implement a per connection solution.
It is also possible to load additional class-descriptor (repository
files) at runtime and merge it with the main repository.

regards,
Armin


>
> >
> > - Original Message -
> > From: "Armin Waibel" <[EMAIL PROTECTED]>
> > To: "OJB Users List" <[EMAIL PROTECTED]>
> > Sent: Thursday, March 20, 2003 11:39 PM
> > Subject: Re: OJB + Custom connection
> >
> >
> > > Hi Edson,
> > >
> > > hope I don't misunderstand you,
> > >
> > > > I wan't to use a "user authenticated" database connection, not
one
> > > open with
> > > > general credentials...
> > > Do this mean you want pass user/password at runtime?
> > > No problem, see FAQ "Many different database user - How do they
> login?"
> > >
> > > OR
> > >
> > > > Isto possible to open external connection and then configure OJB
> to
> > > use it
> > > Do you mean to pass the complete connection properties at runtime?
> > > No problem, before the first use of PBF use the MetadataManager
and
> > > add a JdbcConnectionDescriptor (contain all connection info).
> > >
> > > OR
> > >
> > > Do you mean you get the real connection by an external process and
> > > you want to use this connection within OJB?
> > > No problem, implement your own
> > > org.apache.ojb.broker.accesslayer.ConnectionFactory and let OJB
> > > use it.
> > >
> > > HTH
> > > regards,
> > > Armin
> > >
> > > - Original Message -
> > > From: "Edson Carlos Ericksson Richter"
> > > <[EMAIL PROTECTED]>
> > > To: "'OJB Users List'" <[EMAIL PROTECTED]>
> > > Sent: Thursday, March 20, 2003 11:40 PM
> > > Subject: OJB + Custom connection
> > >
> > >
> > > > Hi!
> > > >
> > > > Isto possible to open external connection and then configure OJB
> to
> > > use it
> > > > (not the one in repository.xml - in real, is better if I don't
> need to
> > > > configure
> > > > connection in repository.xml, besides I think this is not
> possible).
> > > >
> > > > I wan't to use a "user authenticated" database connection, not
one
> > > open with
> > > > general credentials...
> > > >
> > > > Thanks,
> > > >
> > > > Edson Richter
> > > >
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.463 / Virus Database: 262 - Release Date: 17/3/2003
> > > >
> > >
> > >
> >
>
> -
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> >
>


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: "competitive locking" configuration

2003-03-23 Thread Armin Waibel
Hi Geoff,

- Original Message - 
From: "Geoff Gerrietts" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Sunday, March 23, 2003 3:56 AM
Subject: "competitive locking" configuration


> I've been trying to figure out how to set up OJB (hopefully using the
> ODMG API) for an environment where several distinct applications will
> be aiming at the same database.
> 
> To my mind, this involves either having no cache, or a pretty shallow
> cache. I've spent some time prowling through the docs, but I confess
> that I'm a bit confused as to how I should implement this. Should I
> just be setting up ObjectCacheEmptyImpl instead of
> ObjectCacheDefaultImpl? Is that enough?

Yes, this should be enough.
(And it's recommended to use an database based sequence manager
implementation, like SequenceManagerNextValImpl or your
own impl.)

regards,
Armin

> 
> Advice appreciated.
> 
> Thanks,
> --G.
> 
> -- 
> Geoff Gerrietts "Me and my homies, we tag O.D.."
> --Unknown grafitti artist at a party
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Problems with OJB & JDO

2003-03-23 Thread Thomas Mahler
You must enhance the byte-code of the tutorial app.
I assume you just forget the ant target enhance-jdori.
(See first section of tutorial4.html).
cheers,
Thomas
Gary Eberhart wrote:
Hello All,

I'm getting the following exception when running the OBJ JDO example
UCListAllProducts.
Any ideas?

javax.jdo.JDOUserException: Class given to getExtent does not implement
javax.jdo.spi.PersistenceCapable
at com.sun.jdori.common.PersistenceManagerImpl.getExtent(Unknown Source)
at com.sun.jdori.common.query.QueryImpl.checkCandidates(Unknown Source)
at com.sun.jdori.common.query.QueryImpl.execute(Unknown Source)
at
org.apache.ojb.tutorial5.UCListAllProducts.apply(UCListAllProducts.java:45)
at org.apache.ojb.tutorial5.Application.run(Application.java:102)
at org.apache.ojb.tutorial5.Application.main(Application.java:70)


Thanks in advance,
Gary


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


ODMG Query over objects always returns a Collection (DList)?

2003-03-23 Thread Edson Carlos Ericksson Richter
Hi!

Table:
  UsersTable (id, username, password) -> mapped to User object with same
properties.
where id is Primary Key, and username is a unique key.

Well, if I query "select user from User where username = $1 and password =
$2", ODMG will always return a collection when I issue query.execute()? Or
it should detect that has only one object, and return a User object?

Just get from API doc for OQLQuery:
"The object that represents the result of the query. The returned data,
whatever its OQL type, is encapsulated into an object. For instance, when
OQL returns an integer, the result is put into an Integer object. When OQL
returns a collection (literal or object), the result is always a Java
collection object of the same kind (for instance, a DList). "

Appear to me that when OQL returns an User, the result should be put into
User object, as in "For instance, when OQL returns an integer, the result is
put into an Integer object".


Thanks for any clarification.

Edson Richter



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.463 / Virus Database: 262 - Release Date: 17/3/2003


smime.p7s
Description: S/MIME cryptographic signature


OJB and AXIS

2003-03-23 Thread Manousos Bouloukakis
I have made an application that uses OJB.
This application run fine as standalone.
I have tried to make it accessible as a webservice, but something is happening
when i tried to access it ( i am using Axis Engine-Tomcat , all of them latest 
versions)
All classpath settings are correct.
(no error at any logfile or console).
My web service is dont running.

What is happening when using Axis + OJB?

Please Help...

Thanks.

Manousos Bouloukakis
Software Enginneer
[EMAIL PROTECTED]



Complex query

2003-03-23 Thread Edson Carlos Ericksson Richter
Hi!

Let's take a Products table with 20 fields, and about 500.000 or more
records.


1st. Query:

Using a SQL client I have used this query to navigate among records in a
products table. Each time I issue SELECT, I get next record. I can't use
recordset to navigate because a lot of changes in records (I really need to
be up-to-date):

select * from products where product.id = (select min(product.id) where
product.id > ? )

in place of ? I put old product Id. Someone knows how can I implement this
type of query using ODMG?

2nd. Query:

How can I get a list of primary keys, so I can use them to navigate between
records? Something like

select product.id from products


Thanks for any help,

Edson Richter



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.463 / Virus Database: 262 - Release Date: 17/3/2003


smime.p7s
Description: S/MIME cryptographic signature


Re: Multiple primary keys in ojb tables

2003-03-23 Thread Edson Carlos Ericksson Richter
I think that mostly databases allow only one primary key and several unique
keys.
Two type of keys allow references (by foreign keys). So, we can say that
unique keys is a king of primary key (except that Primary keys don't allow
nulls, and unique keys allow one value null).

I expect this explain help...

Best regards,


Edson Richter



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.463 / Virus Database: 262 - Release Date: 17/3/2003


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: OJB + Custom connection (solved)

2003-03-23 Thread Edson Carlos Ericksson Richter
Well, in real I had two diff questions. But you have answered all of them.

Thanks.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.463 / Virus Database: 262 - Release Date: 17/3/2003

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Webapp google queries: What is a good way to present multiple web pages with query results ?

2003-03-23 Thread Theo Niemeijer

Maybe someone has a suggestion for me:

The problem I am facing is that a user can have a very long list of results,
and that list of items is presented in multiple pages of HTML (like Google :->)

Let's assume that a query will have 10.000 resultitems, and I display 20 items
per HTML page with a Next and a Previous button. 

- When I use a QueryIterator and for each next page just iterate 20 items further 
I assume that it will tie the database connection up for quite some time, 
and I can not even be sure that the user will ask for the next page of results ! 

- When I just get all the items in a large collection it will cost me a lot of
"materialisation" time and a lot of memory. 

- When I only ask for the object identities and then get the pages by making a query 
for 20 identies in a kind of "select ... where id's in []" then the user would
have to wait for that query, but it may be mcuh faster than the original query. 

- When I just re-submit the query for each page, and iterate to the correct 20 items
then the user would have to wait for the query each time, but it may actually be
fast because only 20 items would be "materialised". 

  
Anyone having experience with this problem and wanting to share best practices ? 

Regards,
Theo Niemeijer

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]