ICEsoft.org Forums: ICEfaces, ICEmobile, ICEpdf

Thank you very much, judy. I'll try the post...

No judy, I think you didn't understand...

I am using only one datasource. Look, the real problem is the next one:

I developed the application, it only has one datasource. The specifications for the connection to the database is in the context.xml file. Now, I have to give the application to other person. That person should have the posibility to change the connection to the database by only changing some text file (a .xml or something like that). In the time I am making the site I don't know what are the IPs where it is possible the MySQL server will be, so, I am planning only one connection in the context.xml file (for localhost only), but it should be possible for the final user to change the connection by specifying a different IP number. Do you understand now? I am sorry if my English is not good, I am from Cuba. Maybe I did not explain very well, but the problem is that the application should be use by other people, so, they should have the possibility to change the connection without my concern.

Any idea about that?

Hi there:

First of all: I am so sorry about my English. I am from Latin America.

I am a rookie in Seam.

At this moment, I am making a web site using Seam 1.2. My site uses a database (in MySQL Server) named ALregclients. That DB has only one table: trazasfallos. I am developing my site in Eclipse. I can change the connection to the database from the context.xml file, and it works fine... The problem comes when I deploy the site. In this case, the site will be hosted in a PC, and the MySQL server will be running in another PC. So, to make the site can run, I have to change the connection string in the context.xml and compile the project. It generates a compiled class named trazasfallos.class, and that is the file I have to overwrite in the folder I put the deployment of the site. Changing only the context.xml and overwriting it in the deployment folder, doesn't work!! Always I have to recompiling the entire site. The point is: how to change the connection string without recompiling the whole project (site)? How to connect to any MySQL server with just a change of a .xml file (or something like that)?

Is it possible to change the connection at runtime? If it is possible, how to do it???