How to include a file with connection parameters in JSP

Per Magnus L?vold · Aug 27, 2004

Hi, all!
I have a series of JSP pages wich connect to an Oracle DB using JDBC.
Several of these pages use the same connection string for JDBC, and
now that the connection parameters change, I have to uådate every one
of them.
So now I am trying to set the parameters in an included file, so I
only have to keep one file up-to-date.
I've searched the web and newsgroups, and found several tips, but none
have worked for me. One specific I am trying to make work is this:

*** file with parameters (test.jsp) ***
<%
request.setAttribute("test", "Display this");
%>
*** end file w params ***

*** main file (main.jsp) ***
<html>
<head></head>
<body>
<%@include file="test.jsp"%>
The test parameter is: <%= test %>.<br>
</body>
</html>
*** end main file ***

This won't compile. I get the error message
"variable test not found in class _main"

I can't see why this shouldn't work. Any ideas how to make this work?

Regards, Per Magnus

Ryan Stewart · Aug 27, 2004

Per Magnus L?vold said:
Hi, all!
I have a series of JSP pages wich connect to an Oracle DB using JDBC.
Several of these pages use the same connection string for JDBC, and
now that the connection parameters change, I have to uådate every one
of them.
So now I am trying to set the parameters in an included file, so I
only have to keep one file up-to-date.
I've searched the web and newsgroups, and found several tips, but none
have worked for me. One specific I am trying to make work is this:

*** file with parameters (test.jsp) ***
<%
request.setAttribute("test", "Display this");
%>
*** end file w params ***

*** main file (main.jsp) ***
<html>
<head></head>
<body>
<%@include file="test.jsp"%>
The test parameter is: <%= test %>.<br>
</body>
</html>
*** end main file ***

This won't compile. I get the error message
"variable test not found in class _main"

I can't see why this shouldn't work. Any ideas how to make this work?

Regards, Per Magnus

Yes:
<%= request.getAttribute("test") %>

A much better way would be to create context parameters in web.xml to hold
your information:
<context-param>
<param-name>name</param-name>
<param-value>value</param-value>
</context-param>

Then:
<%= application.getInitParameter("name") %>

You could also put your data in a .properties file. See
java.util.Properties.

Per Magnus L?vold · Aug 30, 2004

Thank you!
This is working fine with request.getAttribute()

I'm curious why putting the parameter in web.xml is a much better
solution?
During testing I have seen that I do not even need the web.xml file
for running the application. I thought this file was used for
overriding default server parameters or something.

Regrads, Per Magnus

How can I view / open / render / display a pdf file with c code?	0	Sep 23, 2023
How to include a HTML in JSP?	0	Jan 24, 2012
How to create PDF file in Batch	5	May 11, 2022
How to change key name in json file with python	0	Oct 2, 2022
How to save JSON Data to a file using fetch() api?	2	Apr 28, 2022
How to include a text file in my executable JAR file?	6	Aug 23, 2012
How to sort a CSV file with merge sort JAVA	7	May 6, 2021
I want to include fees depending on the payment method, using the plugin "Deposits for Woocommerce"	0	Aug 17, 2022

How to include a file with connection parameters in JSP

Per Magnus L?vold

Ryan Stewart

Per Magnus L?vold

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads