Dan Parsons

I have done browser sniffer using servlet in the past.
Now I want to detect OS using Servlet but I keep getting OS of the Web Server that is hosting my Tomcat container:
//Servlet condition if (navigator.appVersion.indexOf("5.1")!=-1) { //redirect }

Anyway I can detect the client OS using server side Java instead of client side JavaScript?

I have my local Tomcat 6.0.20 container JNDI Connection Pool working in local TomcatHome\conf\context.xml:
<Resource name="jdbc/myoracle" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@myserver:1521:mysid" username="smith" password="passwd" maxActive="20" maxIdle="10" maxWait="-1"/>

I want to use the Connection Pool with JNDI on the server but dont have permissions to edit the context.xml on the server. Anyway I can put the above JNDI somewhere in my webapp?

I am connecting to Oracle 10g RAC using JDBC in Tomcat 6.0.20.
It works around 50% of the time. When it doesnt work it shows this error message:
IO exception: The Network Adapter could not establish the connection.

Here is my JDBC String:
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP) (HOST=170.11.5.111) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=170.11.5.112) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=service) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ))) The above Description parameters I use in my tnsnames.ora and can successfully connect to the Oracle RAC using SQL Plus with no issues. I can also successfully ping to the IP addresses with no issues.
I also played around with the JDBC string and added (FAILOVER=ON) but still have same issues.

Please advise.

I am using Servlet as a controller for my form entries.

If I send them to the Servlet with or without sessions it wont show anything after the servlet forwards to a JSP. I am encoding with sun.misc.BASE64Encoder in another Servlet and it seems to be effecting all my Servlets for this webapp. If I take out the sun.misc.BASE64Encoder in the other servlet, the form entries will work in my servlet and show up in the forwarded jsp. I was hoping to somehow clear or eliminate any threads that were created from another Servlet in my webapp that has the sun.misc.BASE64Encoder.

I would like to initialize a Servlet when it is called.
Will this clear any sessions and threads?
public class CatalogServlet extends HttpServlet { public void init() throws ServletException { session.invalidate(); } }

I am attempting to create my first custom tag in Tomcat 6.0.20.
I get the following error:
org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 13 in the generated java file MyFunctions cannot be resolved to a type Stacktrace: org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92) org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330) org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439) org.apache.jasper.compiler.Compiler.compile(Compiler.java:334) org.apache.jasper.compiler.Compiler.compile(Compiler.java:312) org.apache.jasper.compiler.Compiler.compile(Compiler.java:299) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:586) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

abc.tld located in projectOne\WEB-INF
<taglib xmlns="http://java.sun.com/xml/ns/j2ee" version="2.0"> <tlib-version>1.0</tlib-version> <short-name>abc</short-name> <uri>http://projectOne/taglib/abc</uri> <function> <name>replace</name> <function-class>MyFunctions</function-class> <function-signature> String replace(java.lang.String,java.lang.String,java.lang.String) </function-signature> </function> </taglib>

MyFunctions.java located in WEB-INF\classes
import java.util.*; public class MyFunctions { public static String replace(String source, String x, String y) { if (source==null) { return null; } else { return source.replaceAll(x, y); } } }

web.xml
<taglib> <taglib-uri>http://projectOne/taglib/abc</taglib-uri> <taglib-location>/WEB-INF/abc.tld</taglib-location> </taglib>

main.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="abc" uri="http://projectOne/taglib/abc" %> <html> <body> ${abc:replace('This is a good test','good','bad')}


Please advise what I need to change to get this to work?

Keith Flo wrote:Dan,

No .. it doesn't look correct ... a couple questions ...

1. What does MovieListing.getList() return? a java.util.ArrayList of Strings, a java.util.ArrayList of MovieBeans or something else?
2. It looks like your JSP code places an ArrayList of MovieBean into scope and the toString() method of MovieBean prints what you want when you iterate using forEach. Is this what you want?
3. What do you want the Java code to do?

Its not working and seems to print all the records per array.
Its suppose to print a Java java.util.ArrayList of MovieBeans.

I have a JSTL forEach example that I would like to implement in a Java class instead of JSP.
Example:Java class: ArrayList<MovieBean> movies = New ArrayList<MovieBean> (MovieListing.getList()); request.setAttribute(movies, "movies"); JSP: <c:forEach var="movie" items="${movies}"> ${movie} <br> </c:forEach>


Is the below attempt the right way?

Java class: ArrayList<MovieBean> movies = New ArrayList<MovieBean> (MovieListing.getList()); for (Iterator it = movies.iterator(); it.hasNext(); ) { String movies = (String)it.next(); } request.setAttribute(movies, "movies");

Thanks, As a client I need to get information from a Web Service where I will use an XML tag (CityRequest) to fetch a specific city and get the city information as an XML output.

I need to create an XML object:
<?xml version="1.0"?> .... <CityRequest City = "Boston" /> .... </SOAP-ENV:BODY>

Then call the City Web Service URL: http://cityService/URLConnector
I would then get the XML response with Boston information.

I am getting NetBeans 6.7 and will use that for consuming a web service. I will be building the client side on Tomcat 6.0.20 to fetch somebody elses web service that is located on another server.
Do I need to get Axis or other extra software on my Tomcat to consume a web service that is located on a another server?

I am getting closed exception messages with my below jdbc connection to Oracle 9i from Tomcat 6 container:
java.sql.SQLException: Closed Statement
and
java.sql.SQLException: Closed Statement: next



Please advise what I can modify to eliminate the exception messages?
private Connection connection; public ArrayList<MoneyBean> getMoneyList() { ArrayList<MoneyBean> list = new ArrayList<MoneyBean>(); connection = new DatabaseConnector.getConnection(); if(connection != null) { ResultSet rs = null; PreparedStatement preparedStatement = null; try { String BankQuery = "Select money from Bank"; preparedStatement = connection.preparedStatement(BankQuery); rs = preparedStatement.executeQuery(); while(rs.next()) { MoneyBean money = new MoneyBean(); money.setMoney(rs.getString("money")); list.add(money); } } } catch(SQLException ex) { System.out.println(ex); } finally { try { if(rs != null) { rs.close(); } } catch(Exception e) { e.printStackTrace(); } try { if(preparedStatement != null) { preparedStatement.close(); } } catch(Exception e) { e.printStackTrace(); } try { if(connection != null) { connection.close(); } } catch(Exception e) { e.printStackTrace(); } } return list; }


Servlet controller handling of list:
private ArrayList<MoneyBean> money; ..... money = new ArrayList<MoneyBean>(moneyManager.getMoneyList()); session.setAttribute("money", money);

I am connecting to Oracle 9i using JDBC in my JSP/Servlets web pages with Tomcat 6.0.20 container. I am closing all my connections in Finally blocks. Everything works great during the day with JDBC and Oracle where only 2 people are using the web site with about 300 small records in the Oracle database.
But after a Web crawler runs through our web server at 3 AM the next morning a v$session check shows several lines of JDBC Thin Client inactive status marked at 3 AM. Any way to find exactly what sql statement or program that could be causing the JDBC Thin Client to show up?

I need a web.xml context value to work in a plain Java Class that is not a Servlet.
<param-name>myValue</param-name> <param-value>aaaaaavalue</param-value>

For a servlet I can fetch the value like this:
config.getInitParameter("myValue")

Anyway to get a web.xml param or something similiar to work in a Java class?

Bear Bibeault wrote:This has nothing to do with the JSTL -- this is an EL question.

And the answer is that the EL can't call general methods by design -- it is intended to work only with bean properties. Method calls with parameters are not valid bean properties and hence cannot be invoked.

Beans should be designed as beans, and not be general classes masquerading as beans.

If you really need to call a general method, you can explore defining custom tags or EL functions.

Thanks, I will google and read on how to define custom tag or EL function and decide which is best for my situation.

I have the following in Tomcat 6.1.20 working in my JSP and now want to eliminate the Scriptlet and use JSTL:
jsp:useBean id="dataBean" class="beanPackage.DataBean" scope="request" /> <%= dataBean.getMessage("cityField") %>

My attempt didnt work because it doesnt like my JSTL part:
jsp:useBean id="dataBean" class="beanPackage.DataBean" scope="request" /> ${dataBean.getMessage("cityField")}

Please advise how I can get this to work using JSTL instead of Scriptlet.