Error: 500
Location: /struts-bbnpa/dbtest.jsp
Internal Servlet Error:
javax.servlet.ServletException: Driver class 'org.postgresql.Driver'
not found
<%@ taglib uri="http://jakarta.apache.org/taglibs/dbtags" prefix="sql"
%>
<html>
<head><title>dbtest</title></head>
<body>
<P><B>Opening connection to PostgreSql </B></P>
<%-- open database connction--%>
<table>
<sql:connection id="conn1">
<sql:url>jdbc:postgresql://172.16.1.15/test1</sql:url>
<sql:driver>org.postgresql.Driver</sql:driver>
<sql:userId>chucka</sql:userId>
<sql:password></sql:password>
</sql:connection>
<sql:statement id="stmt1" conn="conn1">
<sql:query>
select firstname, lastname, department from employee_1
order by 1
</sql:query>
<%-- loop through the rows of your query--%>
<sql:resultSet id="rset1">
<br><sql:getColumn position="1"/>
<br><sql:getColumn position="2"/>
<br><sql:getColumn position="3"/><sql:wasNull>[no description]</sql:wasNull>
</sql:resultSet>
</sql:statement>
<%-- close a database connection --%>
<sql:closeConnection conn="conn1"/>
</table>
</body>
</html>
--
The views expressed by the sender of this message don't
necessarily represent those of Brecon Beacons National Park
Authority. This message is intended for the addressee(s) only
and is sent in confidence; if you receive it in error, please can you
let us know (at [EMAIL PROTECTED]) and then destroy all copies.
Nid yw'r farn a fynegir gan anfonwr y neges hon o anghenraid yn
adlewyrchu barn Awdurdod Parc Cenedlaethol Bannau Brycheiniog.
Neges yw hon a fwriadwyd ar gyfer y derbynnydd/derbynyddion
yn unig ac fe'i hanfonir yn gyfrinachol; os ydych yn ei dderbyn
mewn camgymeriad, a fyddech gystal â rhoi gwybod i
ni (yn [EMAIL PROTECTED]) ac yna dilëwch bob copi.
