1. Regarding connecting to Oracle: you have to set a datasource as usual in your app server. For example in Tomcat, you would have something like this in your context:
<Resource name="jdbc/db" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/db">
<parameter>
<name>username</name>
<value>scott</value>
</parameter>
<parameter>
<name>password</name>
<value>tiger</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:oci:@rosaura</value>
</parameter>
</ResourceParams>The UBL example currently is only an illustration of XForms capabilities. It does not connect to a database. To do so, you will have to write a "save" action to save the current data to the database, and another pipeline to read data from it. The simple Address Book example is a good start as it does similar things. An earlier posting on the list explains how to use that example with Oracle.
2. Yes, through the SQL processor. You can simply enclose your call between begin / end.
3. For this, you will have to implement some JavaScript in your theme. There is no built-in mechnism to do it. But it's actually fairly standard JavaScript. Let us know if/when you need the details and we can provide you with some code samples.
4. Same thing here, if you are just talking about specifying a tab order you can specify a d:tabindex attribute on the XForms elements in your view, or implement a more generic tabindex attribution mechanism in a centralized way in your theme.
I hope this helps,
-Erik
Tony Tay wrote:
> hi,
>
> Can someone point me (with example if possible) as to how i can access a oracle database ?
> I would like to do the following:
>
> 1. use the UBL example from the "xforms-ubl" example by Orbeon and connect to oracle database and display data and update to database.
>
> 2. can oxf use Oracle database Store Procedures ?
>
> 3. How do i use <return> key as the submit key ?
>
> 4. Will i be able to specify the fields to populate and automatically <TAB> to the next editable field ?
> For example, the price may be different and i would like the user to change values if they wish to.
>
>
> Regards,
> Tony
_______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
