Hi Cesar,
is this working for you? I asked something similar a few weeks ago (I
named it qualifier instead of schema) but I don't see how I can set a
different schema name for each jcdalias.
Lasse
|---------+--------------------------->
| | Wayne Kidd |
| | <[EMAIL PROTECTED]|
| | om> |
| | |
| | 22.09.03 20:29 |
| | Bitte antworten |
| | an "OJB Users |
| | List" |
| | |
|---------+--------------------------->
>-------------------------------------------------------------------------------------------------------------------------------|
|
|
| An: OJB Users List <[EMAIL PROTECTED]>
|
| Kopie:
|
| Thema: Re: SCHEMA
|
>-------------------------------------------------------------------------------------------------------------------------------|
I don't think it matters how many companies you have for this to
work.
The thing does not have to be completely dynamic unless you create
the
schema after startup. What I do is run an initializer servlet at
startup. For each schema, I open a jcdalias (you could do this
dynamically by creating a JdbcConnectionDescriptor instance
(equivalent
to coding a jdbc-connection-descriptor entry in repository.xml)).
Unless there is something missing in this logic, you should be OK.
Wayne
cesar.leite wrote:
>Hi Wayne
>
>I read in emails this solution but my problem is that my
>application work "N" companies and for each company I have a
>schema different i'am working with DB2 and this solution is
>not best in my the case.
>
>Is There another solution with ojb?
>
>[ ]�s
>Cesar
>
>
>
>>When a PersistenceBrokerFactory creates a PersistenceBroker
>>
>>
>instance, it
>
>
>>can specify a different jcdalias. That alias can work again
>>
>>
>st the same
>
>
>>repository.xml but a different url (accessing a different da
>>
>>
>tabase). In
>
>
>>order for this to work properly, the OJB.properties should s
>>
>>
>pecify
>
>
>>ObjectCacheClass=org.apache.ojb.broker.cache.ObjectCachePerB
>>
>>
>rokerImpl
>
>
>>so that seperate caches are maintained for the separate
>>PersistenceBroker instances.
>>
>>Wayne
>>
>>
>>cesar.leite wrote:
>>
>>
>>
>>>Hi
>>>I would like to know if with ojb i can change my schema whe
>>>
>>>
>n
>
>
>>>i'm executing my program?
>>>
>>>Example: I can use the SCHEMA1.PRODUCT and later I can use
>>>SCHEMA2.PRODUCT to have access the same table product.
>>>
>>>thanks.
>>>Cesar
>>>
>>>
>>>---
>>>Acabe com aquelas janelinhas que pulam na sua tela.
>>>AntiPop-up UOL - � gr�tis!
>>>http://antipopup.uol.com.br
>>>
>>>
>>>-----------------------------------------------------------
>>>
>>>
>----------
>
>
>>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>>For additional commands, e-mail: ojb-user-
>>>
>>>
>[EMAIL PROTECTED]
>
>
>>>
>>>
>>>
>>>
>>------------------------------------------------------------
>>
>>
>---------
>
>
>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>>
>>
>
>
>---
>Acabe com aquelas janelinhas que pulam na sua tela.
>AntiPop-up UOL - � gr�tis!
>http://antipopup.uol.com.br
>
>
>
---------------------------------------------------------------------
>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]
