Re: Help : Jdbc Descriptor

[Jose Maria Lopez Lagunas]

Hi.

Could it be possible to get the following behaviour?

I have a client/server application. The server has the persistence layer. I set the user and password of JDBC from info that the client sends. Since there can be several clients with different usernames and passwords, could it be possible to set the different user/passwords and using them acordingly.

To clear that, I'll show some of the code.
When a client connects the server creates a new Controller class (this class is from my application). This Controller class creates a new instance of OJB and opens a new database:

...
ojb = (org.apache.ojb.odmg.OJB) OJB.getInstance();
db = ojb.newDatabase();
db.open("repository.xml",Database.OPEN_READ_WRITE);

DescriptorRepository dr = DescriptorRepository.getInstance(ojb.getCurrentPBKey());
jd = dr.getDefaultJdbcConnection();
jd.setUserName(lth.getUsuario());
jd.setPassWord(lth.getPw());
...

So different clients interact with different Controller classes without interferring each other.

I'm having some problems when there are some clients running with different usernames. I'm using the singlevm broker. Is there any chance to use the same repository with different user/pw values or should I use the C/S broker to achieve that?

Thank you in advance.

Jose Maria



--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>