This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes Other Java Products and Servers and the fly likes Deplyoing a JSP page in Sun One Application server 7 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Deplyoing a JSP page in Sun One Application server 7" Watch "Deplyoing a JSP page in Sun One Application server 7" New topic
Author

Deplyoing a JSP page in Sun One Application server 7

sukhanya sukku
Greenhorn

Joined: Feb 26, 2007
Posts: 12
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.
 
jQuery in Action, 2nd edition
 
subject: Deplyoing a JSP page in Sun One Application server 7