> Obviously, you can implement a "datasource management" sub-system (with > a web front-end) in your application! > But, why do you have to re-invent the wheel?
With a metaphore, I can say that the wheel invented by Tomcat is square and I have to "round" it a bit. (The DataSource management in Struts is triangular instead :-P ). First of all, not everyone will use Tomcat. Surely its administration front-end is nice. But what if I use a simple servlet container, with no tools at all? In this moment I cannot remember anyone, but I swear there are :-P My idea of "front-end" is, at least, two front-ends: one for a generic DataSource (where you can decide the "set-property" elements), the other for a DataSource tied to a JDBC connection (with a more friendly interface), maybe using some connection string builder (to easily build a connection string starting from a DBMS name, the name of the DB, etc.). I made a thing like it some time ago with a GUI form. I know that complete independence from database cannot be achieved, but at least JDBC independence can be done. For this reason I would like to put in all my application a sub-system and a front-end that any administrator can easily configure. My idea is the one used in "OpenCMS", where even the DB initialization is done and a number of DBMS are supported. But these are only words, it's time to code ;-) Ciao Antonio > Hi, > if you are using Tomcat, you can use the Tomcat Web Server > Administration Tool as HTML front-end. With this tool you can set the > dataSource (without configuring context.xml). In this case the > application is automatically reloaded from Tomcat. > The only things to do is to put inside the common/lib directory the jar > file containing the driver classes. > > Obviously, you can implement a "datasource management" sub-system (with > a web front-end) in your application! > But, why do you have to re-invent the wheel? > > BR > /Amleto > > > > -----Messaggio originale----- > Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Inviato: marted� 21 settembre 2004 12.22 > A: [EMAIL PROTECTED] > Oggetto: Smart DataSource management (WAS: Assigning a DataSource to a > Business Delegate on startup) > > > In fact I need to do something more. > Suppose that I want to distribute my application, and the destination > has a different DBMS (well at least he/she has a different username and > password...). I think that configuring the context.xml file for a > non-technical person is a bit difficult, and I wish to give an HTML > front-end. Within one of my applications, I successfully managed to > modify the "struts-config.xml" in the "data-sources" part, but to see > the changes, I have to reload the application (ugly thing). If I use the > "context.xml" (correct me if I am wrong) I have to redeploy the > application (well at least I have to reload it). Another problem that I > encountered is that when I have not the JDBC driver class specified in a > "data-source" entry (neither in the "lib" directory, nor in the Java > "ext" directory") the Struts application, in its entirety, fails to > load. Now, how can I do to re-configure data sources without app reload? > I am thinking about grabbing part of Struts code to make a "data source > manager" and a simple web front-end. But, is there anything already > done? (hopefully open source...) Maybe I got a bit off-topic ;-) Ciao > Antonio Petrelli > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
