[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: AW: [eclipselink-users] How to work with multiple databases/schemas
|
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