[opencms-dev] Addressing external database from JSP

Fri Apr 30 20:57:01 CEST 2004

Hi Björn,

inside of a definition block (starting with "<%!" ) you can only place
member variable an method definitions, but not normal code. You have to
close this block with a "%>" after the method jspInit's closing bracket and
open a code block for the rest with "<%".
After the closing bracket of the while loop you should also place some clean
up:
try {
 if (rs!=null) rs.close();
 if (st!=null) st.close();
 if (cn!=null) cn.close();
}
catch (Exception ignore) {}

Bye,
Stephan

----- Original Message -----
From: "Björn Schlueter" <bschlueter at lenord.de>
To: <opencms-dev at opencms.org>
Sent: Friday, April 30, 2004 10:40 AM
Subject: [opencms-dev] Addressing external database from JSP

Hello there,

as a newbie I am stuck with this little problem.
I am trying to access from opencms an external datebase (namely a ms sql
2000 server).
I know I should use a servlet to access that db, but right know i want to
use a jsp as a shortcut.

This ist what my code looks like:

<html>
<body>
<%@ page
import = "java.io.*"
import = "java.lang.*"
import = "java.sql.*"
%>

<%!
   String sDbDrv = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
   String sDbUrl = "jdbc:microsoft:sqlserver://server/bla";
   String sSql = "SELECT * from Example";

   public void jspInit()
       {
       Class.forName(sDbDrv);
       Connection cn = DriverManager.getConnection(sDbUrl, "bla", "bla");
       }

   Statement st = cn.createStatement();
   ResultSet rs = st.executeQuery(sSql);

   ResultSetMetaData meta = rs.getMetaData();
   out.println("Got results:");

            while
              (rs.next() == true)
              {
                // Which Column?
                out.println("Working Title: ");
                String a = rs.getString("P_TITEL");
                out.print(a);

                 //Which Column?
                out.print("Projektziel: ");
                String b = rs.getString("P_ZIEL");
                out.print(b);
}
%>
</body>
</html>

I really don't know, why OpenCMS does not want to compile that jsp.

I get the following  messages:

javax.servlet.ServletException: Resource loader error in file '/testdb.jsp'

Root cause:
org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: -1 in the jsp file: null

I am pretty much helpless right know. I couldn't find help at google or
relevant java forums!

Can somone of you give me a hint?

Thanks

Björn

_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev