geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hamelin, Thibault" <>
Subject RE : Problem with DataBase Connection
Date Thu, 11 May 2006 07:20:45 GMT

I have already tried to specify the schema in the query, but it didn't work.
But I found a solution, I'm not sure it's the best one :

After the connection, I put this query : "Set Current Schema='Nom_Schema'"
So it works correctly...

It was so easy...

In any case, thank you for your help !


Thibault HAMELIN
Tél. : 01 70 38 32 19

-----Message d'origine-----
De : Hernan Cunico [] 
Envoyé : 10 May 2006 18:58
À :
Objet : Re: Problem with DataBase Connection

Hi Thibault,
you should still be able to access the data if you specify the schema in
your query (schema.table)

The id for connection does not necessarily need to be the same that created
data/schema in the db.



Hamelin, Thibault wrote:
> Hello,
> I'm currently developping an application with EJB, and I have a big 
> problem with the connection to the DB2 DataBase.
> In the Resource Adapter, I defined correctly the user/pwd for my 
> connection but when I try to get data with my EJB, the database schema 
> used is set with my username.
> I want to use of course a data base schema different from my user name.
> I tried to create a schema with a name equals to my username, and of 
> course I succeed to get my data.
> How can I set a different schema name to use ? Unfortunately, I have 
> constraints with the usernames which can be created.
> Cordialement,
> Thibault HAMELIN

View raw message