Access eXist db via jsp pages

Question

Sidharth Agarwa 0 Newbie Poster

14 Years Ago

Hi

I have a small issue with displaying xml document when tried retriving in jsp page.

This is the complete code:

<%@ page import="java.io.*" %>
<%@ page import=" org.xmldb.api.base.*" %>
<%@ page import=" org.xmldb.api.modules.*" %>
<%@ page import=" org.xmldb.api.*" %>
<%@ page import=" javax.xml.transform.OutputKeys" %>
<%@ page import=" javax.servlet.jsp.*" %>
<%@ page import=" javax.servlet.jsp.tagext.*" %>
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
Collection col = null;
XMLResource res = null;
try {
     Class cl = Class.forName("org.exist.xmldb.DatabaseImpl");
     Database database = (Database) cl.newInstance();
     DatabaseManager.registerDatabase(database);
     col = DatabaseManager.getCollection("xmldb:exist://localhost:8080/exist/xmlrpc/db/NeuroML/Level1");
 col.setProperty(OutputKeys.INDENT, "no");
 res = (XMLResource)col.getResource("rest.xml");
     out.println(res.getContent());              
}
 catch (Exception e)  
   {   out.println("hererere");
out.println(e);
e.printStackTrace();
    }   finally { }  
%>
</body>
</html>

It gives me content on the file, in my case contents of "rest.xml", but what i need is to display the original xml tree structure in the browser, not just the contents present between tags.
What i am missing in the code to make it happen??

Thanks
Sidharth

java-jsp

Edited 14 Years Ago by peter_budo because: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

2 Contributors
6 Replies
161 Views
1 Day Discussion Span
Latest Post 14 Years Ago Latest Post by ~s.o.s~

~s.o.s~ 2,560 Failure as a human

14 Years Ago

This seems to be a problem with content type of your servlet response. You need to set the content type to text/xml instead of text/html for the browser to render your response in a "tree" format.

~s.o.s~ 2,560 Failure as a human

14 Years Ago

The "tree" structure of XML is shown only if you render an XML file, not when you a try to render a XML file within an HTML. If your requirement is the latter i.e. to mix and match HTML and XML you'd need to use a Javascript library to emulate the same. For e.g. the following code works and shows a tree structured XML file in IE and FF:

<%@ page language="java" contentType="text/xml; charset=UTF-8"
	pageEncoding="UTF-8"%>
<html>
 <head>
  <title>
    Insert title here
  </title>
 </head>
 <body>HI</body>
</html>

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Sidharth Agarwa 0 Newbie Poster · Answer 1 · 2010-07-23T02:28:12+00:00

That doesnt changed any thing. Result is the same.
Any other suggestion?

Sidharth Agarwa 0 Newbie Poster · Answer 2 · 2010-07-23T11:45:10+00:00

Thanks a lot, my code worked fine now. Thanks again.

Sidharth Agarwa 0 Newbie Poster · Answer 3 · 2010-07-23T12:04:49+00:00

Hey i have one more question.
I am using eXist native XMl database, and want the jsp code to retrieve the stored xml file from db and show up in the browser.
How should i go about it. Right now i now how to retrieve a file present in the db, by registering the db inside the jsp code and giving file path and name.

My final aim is to have a jsp page showing up collections stored in the db, and the user can access the collection and see xml files in them, just read accessibility.

~s.o.s~ 2,560 Failure as a human Team Colleague Featured Poster · Answer 4 · 2010-07-23T13:09:06+00:00

Hey i have one more question.
I am using eXist native XMl database, and want the jsp code to retrieve the stored xml file from db and show up in the browser.
How should i go about it. Right now i now how to retrieve a file present in the db, by registering the db inside the jsp code and giving file path and name.
My final aim is to have a jsp page showing up collections stored in the db, and the user can access the collection and see xml files in them, just read accessibility.

A better way would be to move the entire XML loading logic to a servlet. Also, register/load the required classes/resources only once instead of doing it for every request. Create your own context listener which would be invoked after the servlet context has been initialized (once for every web application as per servlet specification) and do the common loading and registration there. Your servlet should be smart enough to know the intent of the user. If the request is for something like "http://localhost:8080/myapp/all" then display the links to list of all the XML files you have in your database. If the URL is something like "http://localhost:8080/myapp/view/XXX", then show the XML file XXX to the user and so on. I hope you catch the drift..

Also, I've never worked with the native XMLDB product you mention so I won't know what would be an efficient way of initializing/loading the driver/database. Look into the products documentation for more details.