Hello all,
I'm having great difficulty in getting a simple test with turbine working. The code I
am trying is (DBPool.jsp):
*/=============
<@ page import="org.apache.turbine.util.TurbineConfig" %>
<@ page import="org.apache.turbine.services.db.TurbineDB" %>
<@ page import="org.apache.turbine.util.db.pool.DBConnection" %>
<@ page import="java.sql.*" %>
<@ page import="org.apache.turbine.util.Log" %>
<HTML>
<HEAD>
<TITLE>JDBC Test</TITLE>
</HEAD>
<BODY>
This is a test
<%
DBConnection dbConn = TurbineDB.getConnection();
PreparedStatement pstmt = dbConn.prepareStatement("select * from test");
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
out.print("Got a result set!");
} else {
out.print("Nothing!!");
}
rs.close();
pstmt.close();
TurbineDB.releaseConnection(dbConn);
%>
</BODY>
</HTML>
==============\*
When I try to run this piece of code, I get:
*/==============
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from
fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 12 in the jsp file: /DBPool.jsp
Generated servlet error:
[javac] Compiling 1 source file
/opt/jakarta-tomcat-4.1.12/work/Standalone/localhost/inms/DBPool_jsp.java:53: cannot
resolve symbol
symbol : class DBConnection
location: class org.apache.jsp.DBPool_jsp
DBConnection dbConn = TurbineDB.getConnection();
^
=============\*
I am using a TurbineInit.java file which looks like:
*/============
package com.inms.services;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.PrintWriter;
import java.io.IOException;
import org.apache.turbine.util.TurbineConfig;
public class TurbineInit extends HttpServlet {
public void init() {
String prefix = getServletContext().getRealPath("/");
String dir = getInitParameter("turbine-resource-directory");
TurbineConfig tc = new TurbineConfig(dir, "TurbineResources.properties");
tc.init();
}
public void doGet(HttpServletRequest req, HttpServletResponse res) {
}
}
=============\*
Where should I start looking? I am using turbine 2.1.
I highly appreciate all answers - its probably something very silly or simple!
Regards,
Paul
