External password for database connection

minthril

<p>Hello,<br><br>
I have question about connecting data - like database address, user name and password.<br>
 </p>
<p>I made web application for customer but he changes database very often.. It is not good situation for me (to do it and send whole big war file) nor for customer (sending important [may be confidential] data to me).</p>
<p> </p>
<p>Is there any possibility to get this arguments from outer/external place than from rptdesign? If yes could you please attach little/simple example?</p>
<p> </p>
<p>Best regards,</p>
<p>Tomasz</p>

pricher

<p>Hi Tomasz,</p>
<p> </p>
<p>Yes, you can externalize database connection properties by reading connection information from a property file.</p>
<p> </p>
<p>In the attached example, the properties file has information about the JDBC URL, the username and the password of a MySQL connection. Of course, you will have to change the values to suit your environment...</p>
<p> </p>
<p>In the report design, the Data Source defines the basic connection information. In other words, even if you externalize the properties, you will need to hard code at least one valid database connection. If you click on Property Bindings in the left hand side of the window, you will get to a screen where you can enter expressions for the different database connection properties. Look at the 3 values for JDBC URL, username and password. In each case, I call the properties file using a simple Java call. You will also need to modify the file location to make it work in your environment.</p>
<p> </p>
<p>Hope this helps,</p>
<p> </p>
<p>P.</p>