Just thinking off the top of my head ... you might be able to skip
datasources altogether and use a straight driverManager and simply
dynamically change the connection URL dynamically;
Such as we had to do earlier in our projects.
DriverManager.registerDriver("com.somecomp.someejdbcDriver"); <----should
work if the JDBC driver is in the appservers classpath
String URL = "jdbc:easysoft://sb463.sbec.com:8831/"+SOMEDATABASENAME
String USERID = "MYUSERID";
String PASSWORD = "MYPASSWORD";
Connection conn = driverManager.getConnection(URL,USERID,PASSWORD);
This is just kinda of a goBy off the top of my head and the syntax probably
isn't correct since I haven't gone this route in quite a while But with this
you can configure the connection URL dynamically.
Hope this is of any help
-----Original Message-----
From: Mohammad Kargar [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 1:51 PM
To: Nimmons, Buster; [EMAIL PROTECTED]
Subject: RE: J2EE
Hi,
Please notice that in this case, since users are allowed to create their own
databases dynamically, number of databases is not specified at deployment
time. So, setting up one datasource for each database is not practical.
Best regards,
Mohammad
-----Original Message-----
From: A mailing list for Enterprise JavaBeans development
[mailto:[EMAIL PROTECTED]]On Behalf Of Nimmons, Buster
Sent: Monday, August 27, 2001 10:00 PM
To: [EMAIL PROTECTED]
Subject: Re: J2EE
We are in the exact same scenario. I've asked the same question in many
different places and so far the only solution
we've been able to come up with is to forgo using CMP entity beans. In our
application server we set up one datasource for each database (all of our
databases have the exact same structure just different data. since we are an
engineering company we do many projects at once defined by Job Numbers. We
set up a blank database for each job so at project closeout we can easily
remove that project data from disk. This was implemented many years before I
came and now I am trying to work around this design) By using BMP entity
beans we have been able to dynamically change the datasource name to lookup.
Of course I was really looking forward to using CMP but for data against
this database it does not seem curently possible. We have however made all
of our beans CMP beans then subclassed those beans to make BMP beans. THis
way if we ever do figure out a backend way to solve this problem all we
simply have to do is change all of our bean deployment descriptors to choose
the base class instead of the subclass and the container will then use the
CMP bean.
-----Original Message-----
From: Roshd Afzar [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 8:45 AM
To: [EMAIL PROTECTED]
Subject: J2EE
We are developing a multi-tier enterprise application
using J2EE . The problem we have is that we
will have unspecified number of databases,
one for each user that is we need to create a separate
database for each of the users of our system.
we need to make the appropriate connection
to these databases based on the information the users
enter at logon.How should we handle this? notice that we want to
implement our business objects as Entity Beans and at the time
of deployment we really do not know the datasource of these
Entity Beans since it will depend on database the user want to
connect.In another word we need to specify the datasource for out
Entity Beans dynamically.We would be thankfull if anyone can give
us comments and suggestions about this problem.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
