Hi Ranchers,
I am trying to connect and retrive Pointbase database table with a
JSP page. So, I wrote a JSP page PerDetails.jsp file and placed it in a war file PerDet.war file I tried to deploy it in Sun One Application server 7 on Windows but I got an exception. Any ideas where I am going wrong?
My JSP page PerDetails.jsp
I Created a table INFOTABLE in pointbase database
Point base database Connection Details
Driver:"com.pointbase.jdbc.jdbcUniversalDriver"
URL: "jdbc:pointbase://localhost/sample"
Username:"pbpublic"
Password:"pbpublic"
JSP page "PerDetails.jsp" program
<%@ page import="java.sql.*" %>
<% Class.forName("com.pointbase.jdbc.jdbcUniversalDriver"); %>
<HTML>
<HEAD><TITLE>INFORMATION TABLE</TITLE></HEAD>
<BODY>
<H1>PERSONAL DETAILS</H1>
<% Connection connection = DriverManager.getConnection( "jdbc:pointbase://localhost/sample", "pbpublic", "pbpublic");
Statement statement = connection.createStatement() ;
ResultSet resultset = statement.executeQuery("select * from INFOTABLE") ;
%>
<TABLE BORDER="1">
<TR>
<TH>FIRSTNAME</TH>
<TH>LASTNAME</TH>
<TH>PHONE</TH>
<TH>STREET</TH>
<TH>APT</TH>
<TH>STATE</TH>
<TH>PIN</TH>
</TR>
<% while(resultset.next())
{ %>
<TR>
<TD> <%= resultset.getString(1) %></td>
<TD> <%= resultset.getString(2) %></TD>
<TD> <%= resultset.getString(3) %></TD>
<TD> <%= resultset.getString(4) %></TD>
<TD> <%= resultset.getString(5) %></TD>
<TD> <%= resultset.getString(6) %></TD>
<TD> <%= resultset.getString(7) %></TD>
</TR>
<% } %>
</TABLE>
</BODY>
</HTML>
and I got an Exception like:
cause: java.io.FileNotFoundException: C:\Sun\AppServer7\domains\domain1\server1\applications\j2ee-modules\PerDet_1\WEB-INF\web.xml (The system cannot find the path specified)
at com.iplanet.ias.instance.WebModulesManager.getDescriptor(WebModulesManager.java:280)
at com.iplanet.ias.instance.WebModulesManager.getDescriptor(WebModulesManager.java:241)
at com.iplanet.ias.web.VirtualServer.loadWebModuleConfig(VirtualServer.java:627)
at com.iplanet.ias.web.VirtualServer.getWebModules(VirtualServer.java:194)
at com.iplanet.ias.web.WebContainer.loadWebModules(WebContainer.java:612)
at com.iplanet.ias.web.WebContainer.start(WebContainer.java:408)
at com.iplanet.ias.web.WebContainer.startInstance(WebContainer.java:514)
at com.iplanet.ias.server.J2EERunner.confPostInit(J2EERunner.java:170)
Caused by: com.iplanet.ias.deployment.AppConfigException: java.io.FileNotFoundException: C:\Sun\AppServer7\domains\domain1\server1\applications\j2ee-modules\PerDet_1\WEB-INF\web.xml (The system cannot find the path specified)
at com.iplanet.ias.deployment.ModuleConfigEnvImpl.getXmlFile(ModuleConfigEnvImpl.java:93)
at com.iplanet.ias.deployment.WebBundleXmlReader.loadStdAloneModule(WebBundleXmlReader.java:152)
at com.iplanet.ias.instance.WebModulesManager.getDescriptor(WebModulesManager.java:265)
Any help would be appreciated.
Thank you,
Sukhanya.
