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 |
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 |
Free forum by Nabble | Edit this page |