Hi Tony,
I'm currently do this. I'm running Orbeon alongside JSP pages and use
jdbc to connect to my postgresql db.
My data access layer is simply set of jsp pages which query the db and
return xml back, these jsp pages can then be called with simple
<xforms:instance src=..."> and <xforms:submission> elements.
An (admittedly overly complicated) example follows where I show how I
validate a username to confirm that no other matching username already
exists in the database :=
validate.jsp:
<jsp:root version="2.0"
xmlns:c="
http://java.sun.com/jsp/jstl/core"
xmlns:sql="
http://java.sun.com/jsp/jstl/sql"
xmlns:jsp="
http://java.sun.com/JSP/Page">
<jsp:directive.page language="java" contentType="text/xml" />
<c:set var="name">${param.name}</c:set>
<sql:query var="cods">
select *
from role
where rolename = ?
<sql:param value="${name}" />
</sql:query>
<validation xmlns="">
<c:forEach var="cod" items="${cods.rows}"><error/></c:forEach>
</validation>
</jsp:root>
then in my xforms page:
-- xforms model --
<xf:submission
id="validateUsername"
method="get"
separator="&amp;"
action="[dir_outside_orbeon_control]/validate.jsp"
ref="instance('editUser')/name"
replace="instance"
instance="validationUsername"/>
<xf:bind nodeset="instance('editUser')/name"
required="true()"
type="xsd:string"
constraint="not(instance('validationUsername')//error)" />
-- xforms model --
and in the body: <xf:input ref="./name">
<xf:label>Username</xf:label>
<xf:action ev:event="xforms-value-changed">
<xf:send submission="validateUsername" if="string-length(.) > 0"/>
<xf:delete nodeset="instance('validationUsername')/error"
at="1" if="string-length(.) = 0"/>
</xf:action>
</xf:input>
I've not included everything but I hope this makes at least some sense
- it gives you an idea of how to use postgresql, jsp and orbeon
alongside each other.
Chris.
Tony H. Liu wrote:
> Hi, ops-user mailing list,
> I am new to this forum. And I am new to Orbeon, too. I am wondering
> who have this experience of combining Orbeon, PostgreSQL and Tomcat
> together in order to record, save and retrieve XML data.
> I have installed PostgreSQL, Tomcat, Orbeon and Apache. I don't
> know how to configure them and let whole system running.
> Thank you very much.
>
--
You receive this message as a subscriber of the
[hidden email] mailing list.
To unsubscribe: mailto:
[hidden email]
For general help: mailto:
[hidden email]?subject=help
OW2 mailing lists service home page:
http://www.ow2.org/wws
Locked
