Re: AW: [eclipselink-users] How to work with multiple databases/schemas

[Andreas König <andreas.koenig@xxxxxxxxxx>]

Hey.

Thanks for the fast reply. If I use my DB-Client with the same 
connection-params (user/pass) the SQL that is rejected by ORA in the 
context of the app can be executed without problems.

Just to be sure: You did not try to instantiate multiple JPATemplates, 
didn't you?

Regards,
koenig

Berner Martin wrote:
> Are you shure the second Schema (OracleUser) has the required previlegue on the other scema and dos the Tabelname you are accessing include the scema in wich the tabele are?
> conn userX@DatabaseY
> select * from SCOTT.EMPLOYEE;
> // instade of select EMPLOYEE wich is not in the curent scema
>
> By side, I also access the Database wit difrent User. I initiali connect as a "Superuser" and set Propertyes by geting an Entitymanager form EntityManagerFactory aquiering a Proxiuser.
> The User You are Proxiing must have a "connect THROUGH" Grant. 
> (alter user proxiuser1 grant connect THROUGH Superuser)
>
> Best Regards Martin Berner
>
> > -----Ursprüngliche Nachricht-----
> > Von: eclipselink-users-bounces@xxxxxxxxxxx
> > [mailto:eclipselink-users-bounces@xxxxxxxxxxx]Im Auftrag von Andreas
> > König
> > Gesendet: Montag, 4. Mai 2009 15:08
> > An: EclipseLink User Discussions
> > Betreff: [eclipselink-users] How to work with multiple 
> > databases/schemas
> >
> >
> > Hey there!
> >
> > We are integrating some reporting functionalities and need to 
> > access the 
> > ORA-DB as another user than in the rest of the app.
> > How do I do this?
> > We're working with spring and I already tried to configure a second 
> > jpaTemplate with its own EntitymanagerFactory and own 
> > datasource. This 
> > doesn't work. I always get the ORA-00942: table or view does 
> > not exist.
> > Obviously the connection doesn't go to the right DB.
> > Any help?
> >
> > Greetz,
> > kÖnig
> >
> >
> >
> > --
> > Andreas König
> > Developer
> >
> > andreas.koenig@xxxxxxxxxx
> >
> > serie a logistics solutions AG
> > Hülchrather Straße 15
> > D-50670 Köln
> >
> > T +49 221 500 60 7-21
> > F +49 221 500 60 7-07
> >
> > Vorstand: Axel Löhr, Erwin Soldo
> > Aufsichtsrat: Adam Musialik (Vors.), Fritz Pleitgen, Hans Jörg Klofat
> >
> > Amtsgericht Köln HRB 61725
> >
> > www.serie-a.de
> >
> >
> > _______________________________________________
> > eclipselink-users mailing list
> > eclipselink-users@xxxxxxxxxxx
> > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users


--
Andreas König
Developer

andreas.koenig@xxxxxxxxxx

serie a logistics solutions AG
Hülchrather Straße 15
D-50670 Köln

T +49 221 500 60 7-21
F +49 221 500 60 7-07

Vorstand: Axel Löhr, Erwin Soldo
Aufsichtsrat: Adam Musialik (Vors.), Fritz Pleitgen, Hans Jörg Klofat

Amtsgericht Köln HRB 61725

www.serie-a.de