You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Guido Beutler <GB...@cat-gmbh.de> on 2003/01/27 20:14:05 UTC
Multiple database problem
Hello,
I tried to separate the OJB internal tables from existing (user data)
tables.
I used the faraway sample and build different repository.xml and
repository_user.xml.
Re: Multiple database problem
Posted by Armin Waibel <ar...@code-au-lait.de>.
----- Original Message -----
From: "Guido Beutler" <GB...@cat-gmbh.de>
To: "OJB Users List" <oj...@jakarta.apache.org>; "Armin Waibel"
<ar...@code-au-lait.de>
Sent: Wednesday, January 29, 2003 9:04 AM
Subject: Re: Multiple database problem
> Hi,
>
> I used the farAway configuration as a sample and modified the
> MultipleDatabas
> test case for my configuration.
> Is the faraway test case included in the normal junit tests?
Yes.
> I don't think
> that the
> faraway database is created by the prepare-testdb.
The farAway database was not created by prepare-testdb,
the file used by hsql was copied in the target/test dir
(OJB_farAway.xxx)
regards,
Armin
> Maybe that I should check
> if
> this test case works.
> I will try the inmemory configuration too, because this will solve my
> problems too.
> Thanks for the help!
>
> cheers,
>
> Guido
> ----- Original Message -----
> From: "Armin Waibel" <ar...@code-au-lait.de>
> To: "OJB Users List" <oj...@jakarta.apache.org>
> Sent: Wednesday, January 29, 2003 12:31 AM
> Subject: Re: Multiple database problem
>
>
> >
> > ----- Original Message -----
> > From: "Guido Beutler" <GB...@cat-gmbh.de>
> > To: "OJB Users List" <oj...@jakarta.apache.org>
> > Sent: Tuesday, January 28, 2003 7:42 PM
> > Subject: Re: Multiple database problem
> >
> >
> > > Hi,
> > >
> > > I tried exactly what you descibed here.
> > > OJB seems to look at the default (OJB) database and not
> > > on my user database.
> > > Maybe this is a nes issue.
> >
> > there are test cases using PB-api and odmg-api to store/delete/query
> > to a second database (repositoryFarAway).
> > -src/test/org/apache/ojb/broker/MultipleDBTest.java
> > - src/test/org/apache/ojb/odmg/MultipleDBUsageTest.java
> > Maybe this could help you.
> >
> > >
> > > I couldn find information about the in memory OJB tables.
> > > Could you give me a better link to look at?
> >
> > Sorry, my description was imprecise. I mean you could use
> > e.g. the InMemorySequenceManagerImpl (see OJB.properties)
> > this implementation doesn't use the OJB_HL_SEQ table.
> >
> > More info you could found in shipped docs:
> > call bin\build.bat doc
> > to generate the all docs.
> > Section 'supported platforms' describe all internal tables.
> >
> > regards,
> > Armin
> >
> > >
> > > cheers,
> > >
> > > Guido
> > >
> > > ----- Original Message -----
> > > From: "Armin Waibel" <ar...@code-au-lait.de>
> > > To: "OJB Users List" <oj...@jakarta.apache.org>
> > > Sent: Tuesday, January 28, 2003 11:28 AM
> > > Subject: Re: Multiple database problem
> > >
> > >
> > > > Hi Guido,
> > > >
> > > > ----- Original Message -----
> > > > From: "Guido Beutler" <GB...@cat-gmbh.de>
> > > > To: "OJB Users List" <oj...@jakarta.apache.org>
> > > > Sent: Tuesday, January 28, 2003 7:03 AM
> > > > Subject: Re: Multiple database problem
> > > >
> > > >
> > > > > Hi,
> > > > >
> > > > > I am evaluating OJB for a project. Maybe that the decision
will be
> > to
> > > > use a
> > > > > other persistence layer than OJB so I do not want to create
the
> > OJB
> > > > > tables at the normal production database.
> > > > >It is easier to drop the
> > > > > whole OJB database than to delete all the OJB tables by hand.
> > > > > Currently I would like to use OJB for bean managed persistence
> > with
> > > > > jboss but I started with a small sample running under junit.
> > > > >
> > > > > Is there a way to get it working with 0.9.8 ? If I could build
> > > > > some tests and OJB will be used at that project in future
> > > > > I do not have a problem to create OJB Tables at the production
> > > > > enviroment.
> > > >
> > > > OK, now I have a better understanding;-)
> > > > To make it work with 0.9.8 you could try the following:
> > > > - define the repositoryOJB.xml as default (set in
OJB.properties)
> > > > -separate the class-descriptors in a repositoryProd_user.xml
file
> > using
> > > > a 'ENTITY link' in repositoryProd.xml.
> > > > - let the default repository know about all used
class-descriptors
> > > > (use entity link to the repositoryProd_user.xml)
> > > >
> > > > It's also possible to run OJB without any intern table
> > > > (see faq in shipped docs, e.g PB-api + InMemorySequenceManager).
> > > >
> > > > >
> > > > > What is the difference with an EJB server enviroment?
> > > > > Can I use the transaction layer of jboss, if yes how?
> > > > Yes, you could use OJB with container-managed-tx and
> > > > bean-managed-tx.
> > > > (OJB was shipped with working bean examples using cm-tx,
> > > > see src/ejb/org/apache/ojb/ejb).
> > > > see section 'deployment' in the shipped docs for jboss
integration.
> > > > see build-xdoclet.xml to generate the sample beans.
> > > >
> > > > regards,
> > > > Armin
> > > >
> > > > >
> > > > > cheers,
> > > > >
> > > > > Guido
> > > > >
> > > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Armin Waibel" <ar...@code-au-lait.de>
> > > > > To: "OJB Users List" <oj...@jakarta.apache.org>
> > > > > Sent: Tuesday, January 28, 2003 2:21 AM
> > > > > Subject: Re: Multiple database problem
> > > > >
> > > > >
> > > > > > Hi Guido,
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "Guido Beutler" <GB...@cat-gmbh.de>
> > > > > > To: <oj...@jakarta.apache.org>
> > > > > > Sent: Monday, January 27, 2003 8:14 PM
> > > > > > Subject: Multiple database problem
> > > > > >
> > > > > >
> > > > > > > Hello,
> > > > > > >
> > > > > > > I tried to separate the OJB internal tables from existing
> > (user
> > > > data)
> > > > > > > tables.
> > > > > > You separate internal tables in one database and user data
in
> > > > another
> > > > > > database?
> > > > > > If so, I advise not to do that, because OJB does not support
> > > > > > distributed transaction out of the box (or do you use a j2ee
> > conform
> > > > > > application server?).
> > > > > > With next release this will be definitely not possible to
do.
> > Each
> > > > > > database has its own OJB intern tables (if necessary).
> > > > > >
> > > > > > regards,
> > > > > > Armin
> > > > > >
> > > > > > > I used the faraway sample and build different
repository.xml
> > and
> > > > > > > repository_user.xml.
> > > > > > > From the log I cansee that both jdbc connections work.
> > > > > > > I am executing a simple select but OJB reports that the
table
> > > > could
> > > > > > not be
> > > > > > > found.
> > > > > > > Currently I think that I may have a configuration problem.
> > > > > > > Is there a way to get logging information for sql
statements
> > and
> > > > on
> > > > > > which
> > > > > > > connection (and database) the statement was executed by
ojb?
> > > > > > > I think that my statement is executed against the OJB (the
> > > > default)
> > > > > > database
> > > > > > > and not against my user database. How can I verify that?
> > > > > > >
> > > > > > > best regards,
> > > > > > >
> > > > > > > Guido
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > To unsubscribe, e-mail:
> > > > > > <ma...@jakarta.apache.org>
> > > > > > > For additional commands, e-mail:
> > > > > > <ma...@jakarta.apache.org>
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > To unsubscribe, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > > > For additional commands, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > > For additional commands, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > >
> > >
> > >
> >
> >
>
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ojb-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: ojb-user-help@jakarta.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: ojb-user-help@jakarta.apache.org
>
>
>
Re: Multiple database problem
Posted by Guido Beutler <GB...@cat-gmbh.de>.
Hi,
I used the farAway configuration as a sample and modified the
MultipleDatabas
test case for my configuration.
Is the faraway test case included in the normal junit tests? I don't think
that the
faraway database is created by the prepare-testdb. Maybe that I should check
if
this test case works.
I will try the inmemory configuration too, because this will solve my
problems too.
Thanks for the help!
cheers,
Guido
----- Original Message -----
From: "Armin Waibel" <ar...@code-au-lait.de>
To: "OJB Users List" <oj...@jakarta.apache.org>
Sent: Wednesday, January 29, 2003 12:31 AM
Subject: Re: Multiple database problem
>
> ----- Original Message -----
> From: "Guido Beutler" <GB...@cat-gmbh.de>
> To: "OJB Users List" <oj...@jakarta.apache.org>
> Sent: Tuesday, January 28, 2003 7:42 PM
> Subject: Re: Multiple database problem
>
>
> > Hi,
> >
> > I tried exactly what you descibed here.
> > OJB seems to look at the default (OJB) database and not
> > on my user database.
> > Maybe this is a nes issue.
>
> there are test cases using PB-api and odmg-api to store/delete/query
> to a second database (repositoryFarAway).
> -src/test/org/apache/ojb/broker/MultipleDBTest.java
> - src/test/org/apache/ojb/odmg/MultipleDBUsageTest.java
> Maybe this could help you.
>
> >
> > I couldn find information about the in memory OJB tables.
> > Could you give me a better link to look at?
>
> Sorry, my description was imprecise. I mean you could use
> e.g. the InMemorySequenceManagerImpl (see OJB.properties)
> this implementation doesn't use the OJB_HL_SEQ table.
>
> More info you could found in shipped docs:
> call bin\build.bat doc
> to generate the all docs.
> Section 'supported platforms' describe all internal tables.
>
> regards,
> Armin
>
> >
> > cheers,
> >
> > Guido
> >
> > ----- Original Message -----
> > From: "Armin Waibel" <ar...@code-au-lait.de>
> > To: "OJB Users List" <oj...@jakarta.apache.org>
> > Sent: Tuesday, January 28, 2003 11:28 AM
> > Subject: Re: Multiple database problem
> >
> >
> > > Hi Guido,
> > >
> > > ----- Original Message -----
> > > From: "Guido Beutler" <GB...@cat-gmbh.de>
> > > To: "OJB Users List" <oj...@jakarta.apache.org>
> > > Sent: Tuesday, January 28, 2003 7:03 AM
> > > Subject: Re: Multiple database problem
> > >
> > >
> > > > Hi,
> > > >
> > > > I am evaluating OJB for a project. Maybe that the decision will be
> to
> > > use a
> > > > other persistence layer than OJB so I do not want to create the
> OJB
> > > > tables at the normal production database.
> > > >It is easier to drop the
> > > > whole OJB database than to delete all the OJB tables by hand.
> > > > Currently I would like to use OJB for bean managed persistence
> with
> > > > jboss but I started with a small sample running under junit.
> > > >
> > > > Is there a way to get it working with 0.9.8 ? If I could build
> > > > some tests and OJB will be used at that project in future
> > > > I do not have a problem to create OJB Tables at the production
> > > > enviroment.
> > >
> > > OK, now I have a better understanding;-)
> > > To make it work with 0.9.8 you could try the following:
> > > - define the repositoryOJB.xml as default (set in OJB.properties)
> > > -separate the class-descriptors in a repositoryProd_user.xml file
> using
> > > a 'ENTITY link' in repositoryProd.xml.
> > > - let the default repository know about all used class-descriptors
> > > (use entity link to the repositoryProd_user.xml)
> > >
> > > It's also possible to run OJB without any intern table
> > > (see faq in shipped docs, e.g PB-api + InMemorySequenceManager).
> > >
> > > >
> > > > What is the difference with an EJB server enviroment?
> > > > Can I use the transaction layer of jboss, if yes how?
> > > Yes, you could use OJB with container-managed-tx and
> > > bean-managed-tx.
> > > (OJB was shipped with working bean examples using cm-tx,
> > > see src/ejb/org/apache/ojb/ejb).
> > > see section 'deployment' in the shipped docs for jboss integration.
> > > see build-xdoclet.xml to generate the sample beans.
> > >
> > > regards,
> > > Armin
> > >
> > > >
> > > > cheers,
> > > >
> > > > Guido
> > > >
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Armin Waibel" <ar...@code-au-lait.de>
> > > > To: "OJB Users List" <oj...@jakarta.apache.org>
> > > > Sent: Tuesday, January 28, 2003 2:21 AM
> > > > Subject: Re: Multiple database problem
> > > >
> > > >
> > > > > Hi Guido,
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Guido Beutler" <GB...@cat-gmbh.de>
> > > > > To: <oj...@jakarta.apache.org>
> > > > > Sent: Monday, January 27, 2003 8:14 PM
> > > > > Subject: Multiple database problem
> > > > >
> > > > >
> > > > > > Hello,
> > > > > >
> > > > > > I tried to separate the OJB internal tables from existing
> (user
> > > data)
> > > > > > tables.
> > > > > You separate internal tables in one database and user data in
> > > another
> > > > > database?
> > > > > If so, I advise not to do that, because OJB does not support
> > > > > distributed transaction out of the box (or do you use a j2ee
> conform
> > > > > application server?).
> > > > > With next release this will be definitely not possible to do.
> Each
> > > > > database has its own OJB intern tables (if necessary).
> > > > >
> > > > > regards,
> > > > > Armin
> > > > >
> > > > > > I used the faraway sample and build different repository.xml
> and
> > > > > > repository_user.xml.
> > > > > > From the log I cansee that both jdbc connections work.
> > > > > > I am executing a simple select but OJB reports that the table
> > > could
> > > > > not be
> > > > > > found.
> > > > > > Currently I think that I may have a configuration problem.
> > > > > > Is there a way to get logging information for sql statements
> and
> > > on
> > > > > which
> > > > > > connection (and database) the statement was executed by ojb?
> > > > > > I think that my statement is executed against the OJB (the
> > > default)
> > > > > database
> > > > > > and not against my user database. How can I verify that?
> > > > > >
> > > > > > best regards,
> > > > > >
> > > > > > Guido
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > To unsubscribe, e-mail:
> > > > > <ma...@jakarta.apache.org>
> > > > > > For additional commands, e-mail:
> > > > > <ma...@jakarta.apache.org>
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe, e-mail:
> > > <ma...@jakarta.apache.org>
> > > > > For additional commands, e-mail:
> > > <ma...@jakarta.apache.org>
> > > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > <ma...@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > > <ma...@jakarta.apache.org>
> > > >
> > > >
> > > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: ojb-user-help@jakarta.apache.org
>
Re: Multiple database problem
Posted by Armin Waibel <ar...@code-au-lait.de>.
----- Original Message -----
From: "Guido Beutler" <GB...@cat-gmbh.de>
To: "OJB Users List" <oj...@jakarta.apache.org>
Sent: Tuesday, January 28, 2003 7:42 PM
Subject: Re: Multiple database problem
> Hi,
>
> I tried exactly what you descibed here.
> OJB seems to look at the default (OJB) database and not
> on my user database.
> Maybe this is a nes issue.
there are test cases using PB-api and odmg-api to store/delete/query
to a second database (repositoryFarAway).
-src/test/org/apache/ojb/broker/MultipleDBTest.java
- src/test/org/apache/ojb/odmg/MultipleDBUsageTest.java
Maybe this could help you.
>
> I couldn find information about the in memory OJB tables.
> Could you give me a better link to look at?
Sorry, my description was imprecise. I mean you could use
e.g. the InMemorySequenceManagerImpl (see OJB.properties)
this implementation doesn't use the OJB_HL_SEQ table.
More info you could found in shipped docs:
call bin\build.bat doc
to generate the all docs.
Section 'supported platforms' describe all internal tables.
regards,
Armin
>
> cheers,
>
> Guido
>
> ----- Original Message -----
> From: "Armin Waibel" <ar...@code-au-lait.de>
> To: "OJB Users List" <oj...@jakarta.apache.org>
> Sent: Tuesday, January 28, 2003 11:28 AM
> Subject: Re: Multiple database problem
>
>
> > Hi Guido,
> >
> > ----- Original Message -----
> > From: "Guido Beutler" <GB...@cat-gmbh.de>
> > To: "OJB Users List" <oj...@jakarta.apache.org>
> > Sent: Tuesday, January 28, 2003 7:03 AM
> > Subject: Re: Multiple database problem
> >
> >
> > > Hi,
> > >
> > > I am evaluating OJB for a project. Maybe that the decision will be
to
> > use a
> > > other persistence layer than OJB so I do not want to create the
OJB
> > > tables at the normal production database.
> > >It is easier to drop the
> > > whole OJB database than to delete all the OJB tables by hand.
> > > Currently I would like to use OJB for bean managed persistence
with
> > > jboss but I started with a small sample running under junit.
> > >
> > > Is there a way to get it working with 0.9.8 ? If I could build
> > > some tests and OJB will be used at that project in future
> > > I do not have a problem to create OJB Tables at the production
> > > enviroment.
> >
> > OK, now I have a better understanding;-)
> > To make it work with 0.9.8 you could try the following:
> > - define the repositoryOJB.xml as default (set in OJB.properties)
> > -separate the class-descriptors in a repositoryProd_user.xml file
using
> > a 'ENTITY link' in repositoryProd.xml.
> > - let the default repository know about all used class-descriptors
> > (use entity link to the repositoryProd_user.xml)
> >
> > It's also possible to run OJB without any intern table
> > (see faq in shipped docs, e.g PB-api + InMemorySequenceManager).
> >
> > >
> > > What is the difference with an EJB server enviroment?
> > > Can I use the transaction layer of jboss, if yes how?
> > Yes, you could use OJB with container-managed-tx and
> > bean-managed-tx.
> > (OJB was shipped with working bean examples using cm-tx,
> > see src/ejb/org/apache/ojb/ejb).
> > see section 'deployment' in the shipped docs for jboss integration.
> > see build-xdoclet.xml to generate the sample beans.
> >
> > regards,
> > Armin
> >
> > >
> > > cheers,
> > >
> > > Guido
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: "Armin Waibel" <ar...@code-au-lait.de>
> > > To: "OJB Users List" <oj...@jakarta.apache.org>
> > > Sent: Tuesday, January 28, 2003 2:21 AM
> > > Subject: Re: Multiple database problem
> > >
> > >
> > > > Hi Guido,
> > > >
> > > > ----- Original Message -----
> > > > From: "Guido Beutler" <GB...@cat-gmbh.de>
> > > > To: <oj...@jakarta.apache.org>
> > > > Sent: Monday, January 27, 2003 8:14 PM
> > > > Subject: Multiple database problem
> > > >
> > > >
> > > > > Hello,
> > > > >
> > > > > I tried to separate the OJB internal tables from existing
(user
> > data)
> > > > > tables.
> > > > You separate internal tables in one database and user data in
> > another
> > > > database?
> > > > If so, I advise not to do that, because OJB does not support
> > > > distributed transaction out of the box (or do you use a j2ee
conform
> > > > application server?).
> > > > With next release this will be definitely not possible to do.
Each
> > > > database has its own OJB intern tables (if necessary).
> > > >
> > > > regards,
> > > > Armin
> > > >
> > > > > I used the faraway sample and build different repository.xml
and
> > > > > repository_user.xml.
> > > > > From the log I cansee that both jdbc connections work.
> > > > > I am executing a simple select but OJB reports that the table
> > could
> > > > not be
> > > > > found.
> > > > > Currently I think that I may have a configuration problem.
> > > > > Is there a way to get logging information for sql statements
and
> > on
> > > > which
> > > > > connection (and database) the statement was executed by ojb?
> > > > > I think that my statement is executed against the OJB (the
> > default)
> > > > database
> > > > > and not against my user database. How can I verify that?
> > > > >
> > > > > best regards,
> > > > >
> > > > > Guido
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > > For additional commands, e-mail:
> > > > <ma...@jakarta.apache.org>
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > >
> > >
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> > For additional commands, e-mail:
<ma...@jakarta.apache.org>
> >
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
>
Re: Multiple database problem
Posted by Guido Beutler <GB...@cat-gmbh.de>.
Hi,
I tried exactly what you descibed here.
OJB seems to look at the default (OJB) database and not
on my user database.
Maybe this is a nes issue.
I couldn find information about the in memory OJB tables.
Could you give me a better link to look at?
cheers,
Guido
----- Original Message -----
From: "Armin Waibel" <ar...@code-au-lait.de>
To: "OJB Users List" <oj...@jakarta.apache.org>
Sent: Tuesday, January 28, 2003 11:28 AM
Subject: Re: Multiple database problem
> Hi Guido,
>
> ----- Original Message -----
> From: "Guido Beutler" <GB...@cat-gmbh.de>
> To: "OJB Users List" <oj...@jakarta.apache.org>
> Sent: Tuesday, January 28, 2003 7:03 AM
> Subject: Re: Multiple database problem
>
>
> > Hi,
> >
> > I am evaluating OJB for a project. Maybe that the decision will be to
> use a
> > other persistence layer than OJB so I do not want to create the OJB
> > tables at the normal production database.
> >It is easier to drop the
> > whole OJB database than to delete all the OJB tables by hand.
> > Currently I would like to use OJB for bean managed persistence with
> > jboss but I started with a small sample running under junit.
> >
> > Is there a way to get it working with 0.9.8 ? If I could build
> > some tests and OJB will be used at that project in future
> > I do not have a problem to create OJB Tables at the production
> > enviroment.
>
> OK, now I have a better understanding;-)
> To make it work with 0.9.8 you could try the following:
> - define the repositoryOJB.xml as default (set in OJB.properties)
> -separate the class-descriptors in a repositoryProd_user.xml file using
> a 'ENTITY link' in repositoryProd.xml.
> - let the default repository know about all used class-descriptors
> (use entity link to the repositoryProd_user.xml)
>
> It's also possible to run OJB without any intern table
> (see faq in shipped docs, e.g PB-api + InMemorySequenceManager).
>
> >
> > What is the difference with an EJB server enviroment?
> > Can I use the transaction layer of jboss, if yes how?
> Yes, you could use OJB with container-managed-tx and
> bean-managed-tx.
> (OJB was shipped with working bean examples using cm-tx,
> see src/ejb/org/apache/ojb/ejb).
> see section 'deployment' in the shipped docs for jboss integration.
> see build-xdoclet.xml to generate the sample beans.
>
> regards,
> Armin
>
> >
> > cheers,
> >
> > Guido
> >
> >
> >
> > ----- Original Message -----
> > From: "Armin Waibel" <ar...@code-au-lait.de>
> > To: "OJB Users List" <oj...@jakarta.apache.org>
> > Sent: Tuesday, January 28, 2003 2:21 AM
> > Subject: Re: Multiple database problem
> >
> >
> > > Hi Guido,
> > >
> > > ----- Original Message -----
> > > From: "Guido Beutler" <GB...@cat-gmbh.de>
> > > To: <oj...@jakarta.apache.org>
> > > Sent: Monday, January 27, 2003 8:14 PM
> > > Subject: Multiple database problem
> > >
> > >
> > > > Hello,
> > > >
> > > > I tried to separate the OJB internal tables from existing (user
> data)
> > > > tables.
> > > You separate internal tables in one database and user data in
> another
> > > database?
> > > If so, I advise not to do that, because OJB does not support
> > > distributed transaction out of the box (or do you use a j2ee conform
> > > application server?).
> > > With next release this will be definitely not possible to do. Each
> > > database has its own OJB intern tables (if necessary).
> > >
> > > regards,
> > > Armin
> > >
> > > > I used the faraway sample and build different repository.xml and
> > > > repository_user.xml.
> > > > From the log I cansee that both jdbc connections work.
> > > > I am executing a simple select but OJB reports that the table
> could
> > > not be
> > > > found.
> > > > Currently I think that I may have a configuration problem.
> > > > Is there a way to get logging information for sql statements and
> on
> > > which
> > > > connection (and database) the statement was executed by ojb?
> > > > I think that my statement is executed against the OJB (the
> default)
> > > database
> > > > and not against my user database. How can I verify that?
> > > >
> > > > best regards,
> > > >
> > > > Guido
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > <ma...@jakarta.apache.org>
> > > > For additional commands, e-mail:
> > > <ma...@jakarta.apache.org>
> > > >
> > > >
> > > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
> >
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
Re: Multiple database problem
Posted by Armin Waibel <ar...@code-au-lait.de>.
Hi Guido,
----- Original Message -----
From: "Guido Beutler" <GB...@cat-gmbh.de>
To: "OJB Users List" <oj...@jakarta.apache.org>
Sent: Tuesday, January 28, 2003 7:03 AM
Subject: Re: Multiple database problem
> Hi,
>
> I am evaluating OJB for a project. Maybe that the decision will be to
use a
> other persistence layer than OJB so I do not want to create the OJB
> tables at the normal production database.
>It is easier to drop the
> whole OJB database than to delete all the OJB tables by hand.
> Currently I would like to use OJB for bean managed persistence with
> jboss but I started with a small sample running under junit.
>
> Is there a way to get it working with 0.9.8 ? If I could build
> some tests and OJB will be used at that project in future
> I do not have a problem to create OJB Tables at the production
> enviroment.
OK, now I have a better understanding;-)
To make it work with 0.9.8 you could try the following:
- define the repositoryOJB.xml as default (set in OJB.properties)
-separate the class-descriptors in a repositoryProd_user.xml file using
a 'ENTITY link' in repositoryProd.xml.
- let the default repository know about all used class-descriptors
(use entity link to the repositoryProd_user.xml)
It's also possible to run OJB without any intern table
(see faq in shipped docs, e.g PB-api + InMemorySequenceManager).
>
> What is the difference with an EJB server enviroment?
> Can I use the transaction layer of jboss, if yes how?
Yes, you could use OJB with container-managed-tx and
bean-managed-tx.
(OJB was shipped with working bean examples using cm-tx,
see src/ejb/org/apache/ojb/ejb).
see section 'deployment' in the shipped docs for jboss integration.
see build-xdoclet.xml to generate the sample beans.
regards,
Armin
>
> cheers,
>
> Guido
>
>
>
> ----- Original Message -----
> From: "Armin Waibel" <ar...@code-au-lait.de>
> To: "OJB Users List" <oj...@jakarta.apache.org>
> Sent: Tuesday, January 28, 2003 2:21 AM
> Subject: Re: Multiple database problem
>
>
> > Hi Guido,
> >
> > ----- Original Message -----
> > From: "Guido Beutler" <GB...@cat-gmbh.de>
> > To: <oj...@jakarta.apache.org>
> > Sent: Monday, January 27, 2003 8:14 PM
> > Subject: Multiple database problem
> >
> >
> > > Hello,
> > >
> > > I tried to separate the OJB internal tables from existing (user
data)
> > > tables.
> > You separate internal tables in one database and user data in
another
> > database?
> > If so, I advise not to do that, because OJB does not support
> > distributed transaction out of the box (or do you use a j2ee conform
> > application server?).
> > With next release this will be definitely not possible to do. Each
> > database has its own OJB intern tables (if necessary).
> >
> > regards,
> > Armin
> >
> > > I used the faraway sample and build different repository.xml and
> > > repository_user.xml.
> > > From the log I cansee that both jdbc connections work.
> > > I am executing a simple select but OJB reports that the table
could
> > not be
> > > found.
> > > Currently I think that I may have a configuration problem.
> > > Is there a way to get logging information for sql statements and
on
> > which
> > > connection (and database) the statement was executed by ojb?
> > > I think that my statement is executed against the OJB (the
default)
> > database
> > > and not against my user database. How can I verify that?
> > >
> > > best regards,
> > >
> > > Guido
> > >
> > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > >
> > >
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> > For additional commands, e-mail:
<ma...@jakarta.apache.org>
> >
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
>
Re: Multiple database problem
Posted by Guido Beutler <GB...@cat-gmbh.de>.
Hi,
I am evaluating OJB for a project. Maybe that the decision will be to use a
other persistence layer than OJB so I do not want to create the OJB
tables at the normal production database. It is easier to drop the
whole OJB database than to delete all the OJB tables by hand.
Currently I would like to use OJB for bean managed persistence with
jboss but I started with a small sample running under junit.
Is there a way to get it working with 0.9.8 ? If I could build
some tests and OJB will be used at that project in future
I do not have a problem to create OJB Tables at the production
enviroment.
What is the difference with an EJB server enviroment?
Can I use the transaction layer of jboss, if yes how?
cheers,
Guido
----- Original Message -----
From: "Armin Waibel" <ar...@code-au-lait.de>
To: "OJB Users List" <oj...@jakarta.apache.org>
Sent: Tuesday, January 28, 2003 2:21 AM
Subject: Re: Multiple database problem
> Hi Guido,
>
> ----- Original Message -----
> From: "Guido Beutler" <GB...@cat-gmbh.de>
> To: <oj...@jakarta.apache.org>
> Sent: Monday, January 27, 2003 8:14 PM
> Subject: Multiple database problem
>
>
> > Hello,
> >
> > I tried to separate the OJB internal tables from existing (user data)
> > tables.
> You separate internal tables in one database and user data in another
> database?
> If so, I advise not to do that, because OJB does not support
> distributed transaction out of the box (or do you use a j2ee conform
> application server?).
> With next release this will be definitely not possible to do. Each
> database has its own OJB intern tables (if necessary).
>
> regards,
> Armin
>
> > I used the faraway sample and build different repository.xml and
> > repository_user.xml.
> > From the log I cansee that both jdbc connections work.
> > I am executing a simple select but OJB reports that the table could
> not be
> > found.
> > Currently I think that I may have a configuration problem.
> > Is there a way to get logging information for sql statements and on
> which
> > connection (and database) the statement was executed by ojb?
> > I think that my statement is executed against the OJB (the default)
> database
> > and not against my user database. How can I verify that?
> >
> > best regards,
> >
> > Guido
> >
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
> >
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
Re: Multiple database problem
Posted by Armin Waibel <ar...@code-au-lait.de>.
Hi Guido,
----- Original Message -----
From: "Guido Beutler" <GB...@cat-gmbh.de>
To: <oj...@jakarta.apache.org>
Sent: Monday, January 27, 2003 8:14 PM
Subject: Multiple database problem
> Hello,
>
> I tried to separate the OJB internal tables from existing (user data)
> tables.
You separate internal tables in one database and user data in another
database?
If so, I advise not to do that, because OJB does not support
distributed transaction out of the box (or do you use a j2ee conform
application server?).
With next release this will be definitely not possible to do. Each
database has its own OJB intern tables (if necessary).
regards,
Armin
> I used the faraway sample and build different repository.xml and
> repository_user.xml.
> From the log I cansee that both jdbc connections work.
> I am executing a simple select but OJB reports that the table could
not be
> found.
> Currently I think that I may have a configuration problem.
> Is there a way to get logging information for sql statements and on
which
> connection (and database) the statement was executed by ojb?
> I think that my statement is executed against the OJB (the default)
database
> and not against my user database. How can I verify that?
>
> best regards,
>
> Guido
>
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
>