modified xforms-sql-address-book app not working.

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

modified xforms-sql-address-book app not working.

Alex Sharaz
Chaps,

I've taken the sql address book example and modified it to store
username and passwords for a wireless network we've got here.

Reading the sql database TIA
Alexand deleting things from the database works fine.  

Adding things to the database however just doesn't work.

Attached are the files. Could someone havea quick peek and see what the
problem is.

The main change is that I've configured my resin app server to have

<database>
      <jndi-name>jdbc/comm_auth</jndi-name>
      <driver type="org.gjt.mm.mysql.Driver">
         <url>jdbc:mysql://databases.hull.ac.uk:3306/DBNAME</url>
         <user>YES</user>
         <password>NO</password>
      </driver>
      <prepared-statement-cache-size>8</prepared-statement-cache-size>
      <max-connections>80</max-connections>
      <max-idle-time>30s</max-idle-time>
   </database>

And then included a datasource statement e.g.

  <sql:connection>
     <sql:datasource>comm_auth</sql:datasource>
   .......
   </sql:connection>


TIA
alex

*****************************************************************************************
To view the terms under which this email is distributed, please go to http://www.hull.ac.uk/legal/email_disclaimer.html
*****************************************************************************************

--
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
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

page-flow.xml (1K) Download Attachment
view.xhtml (7K) Download Attachment
service-add.xpl (2K) Download Attachment
service-delete.xpl (2K) Download Attachment
service-get.xpl (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: modified xforms-sql-address-book app not working.

Alessandro Vernet
Administrator
Hi Alex,

Are you getting any error when you add things to the database? Have
you checked what the 'instance' input of the service-add.xpl matches
your expectation? Does it have a /form/first and /form/last?

I am sorry if I can't help more, but since this code uses MySQL, this
is not an easy one to reproduce.

Alex

On 3/15/07, Alex Sharaz <[hidden email]> wrote:

> Chaps,
>
> I've taken the sql address book example and modified it to store
> username and passwords for a wireless network we've got here.
>
> Reading the sql database TIA
> Alexand deleting things from the database works fine.
>
> Adding things to the database however just doesn't work.
>
> Attached are the files. Could someone havea quick peek and see what the
> problem is.
>
> The main change is that I've configured my resin app server to have
>
> <database>
>       <jndi-name>jdbc/comm_auth</jndi-name>
>       <driver type="org.gjt.mm.mysql.Driver">
>          <url>jdbc:mysql://databases.hull.ac.uk:3306/DBNAME</url>
>          <user>YES</user>
>          <password>NO</password>
>       </driver>
>       <prepared-statement-cache-size>8</prepared-statement-cache-size>
>       <max-connections>80</max-connections>
>       <max-idle-time>30s</max-idle-time>
>    </database>
>
> And then included a datasource statement e.g.
>
>   <sql:connection>
>      <sql:datasource>comm_auth</sql:datasource>
>    .......
>    </sql:connection>
>
>
> TIA
> alex
>
> *****************************************************************************************
> To view the terms under which this email is distributed, please go to http://www.hull.ac.uk/legal/email_disclaimer.html
> *****************************************************************************************
>
> --
> 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
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>

--
Orbeon Forms - Web 2.0 Forms for the Enterprise
http://www.orbeon.com/



--
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
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws