Registration in orbeon forms
Locked
 
|
Hi All, 1).I am using orbeon PE and oracle database.I am able to
store the data in database I am fine with that.but a column name
username is always null.I understand since there is no registration here that
column is null.How I can make the Forms to store against particular user. 2).Second thing I want to add one more column userid in
orbeon_form_definition.and make this user id to be inserted In table.how I can achive this. 3).I can see the orbeon log as below some query processing
is going on.I want to edit this query where I should go and edit? Preparing to execute row: hasNext = true, statement =
select
last_modified,
t.xml.getClobVal() xml
from orbeon_form_definition t
where app = ?
and form = ?
and last_modified = (
select max(last_modified) from orbeon_form_definition
where
app = ?
and form = ?
)
and deleted = 'N' 2011-02-24 15:05:20,546 DEBUG SQLProcessor -
Execute row: rowNum = 1 2011-02-24 15:05:20,546 DEBUG SQLProcessor -
ResultSet info: no more result set, update count = -1 Regards, Smaran Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.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 OW2 mailing lists service home page: http://www.ow2.org/wws |
Re: Registration in orbeon forms
|
Administrator
|
Smaran,
If the user is authenticated using the servlet API, the username is propagated to the database. In other words you need to setup user authentication, and then things should work.
Here is the code that handles Oracle persistence: https://github.com/orbeon/orbeon-forms/blob/master/src/resources/apps/fr/persistence/oracle/crud.xpl
-Erik
On Thu, Feb 24, 2011 at 1:43 AM, <[hidden email]> wrote:
-- 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 |
|
|
Hi You mean to say I need to create a folder inside the apps
folder with persistence/oracle
/ and inside that I should place crud.xpl? Regards, Smaran From: [hidden email]
[mailto:[hidden email]] On Behalf Of Erik Bruchez Smaran, If the user is authenticated using the servlet API, the
username is propagated to the database. In other words you need to setup user authentication, and
then things should work. Here is the code that handles Oracle persistence: https://github.com/orbeon/orbeon-forms/blob/master/src/resources/apps/fr/persistence/oracle/crud.xpl -Erik On Thu, Feb 24, 2011 at 1:43 AM, <[hidden email]>
wrote: Hi
All, 1).I
am using orbeon PE and oracle database.I am able to store the data in database
I am fine with that.but a column name username is always null.I
understand since there is no registration here that column is null.How I can
make the Forms
to store against particular user. 2).Second
thing I want to add one more column userid in orbeon_form_definition.and make
this user id to be inserted In
table.how I can achive this. 3).I
can see the orbeon log as below some query processing is going on.I want to
edit this query where I should go and edit? Preparing
to execute row: hasNext = true, statement =
select
last_modified,
t.xml.getClobVal() xml
from orbeon_form_definition t
where app = ?
and form = ?
and last_modified = (
select max(last_modified) from orbeon_form_definition
where
app = ?
and form = ?
)
and deleted = 'N'
2011-02-24
15:05:20,546 DEBUG SQLProcessor - Execute row: rowNum = 1 2011-02-24
15:05:20,546 DEBUG SQLProcessor - ResultSet info: no more result set,
update count = -1 Regards, Smaran Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not the
intended recipient, you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately and destroy all copies of this message and
any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.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 OW2 mailing lists service home page: http://www.ow2.org/wws |
|
|
In reply to this post by Erik Bruchez
Hi All, Can any one help me in solving 2nd and 3rd
points in my email. 2).Second
thing I want to add one more column userid in orbeon_form_definition.and make
this user id to be inserted In
table.how I can achive this. 3).I
can see the orbeon log as below some query processing is going on.I want to
edit this query where I should go and edit? Preparing
to execute row: hasNext = true, statement =
select
last_modified,
t.xml.getClobVal() xml
from orbeon_form_definition t
where app = ?
and form = ?
and last_modified = (
select max(last_modified) from orbeon_form_definition
where
app = ?
and form = ?
)
and deleted = 'N'
Regards, Smaran From: [hidden email]
[mailto:[hidden email]] On Behalf Of Erik Bruchez Smaran, If the user is authenticated using the servlet API, the
username is propagated to the database. In other words you need to setup user authentication, and
then things should work. Here is the code that handles Oracle persistence: https://github.com/orbeon/orbeon-forms/blob/master/src/resources/apps/fr/persistence/oracle/crud.xpl -Erik On Thu, Feb 24, 2011 at 1:43 AM, <[hidden email]>
wrote: Hi
All, 1).I
am using orbeon PE and oracle database.I am able to store the data in database
I am fine with that.but a column name username is always null.I
understand since there is no registration here that column is null.How I can
make the Forms
to store against particular user. 2).Second
thing I want to add one more column userid in orbeon_form_definition.and make
this user id to be inserted In
table.how I can achive this. 3).I
can see the orbeon log as below some query processing is going on.I want to
edit this query where I should go and edit? Preparing
to execute row: hasNext = true, statement =
select
last_modified,
t.xml.getClobVal() xml
from orbeon_form_definition t
where app = ?
and form = ?
and last_modified = (
select max(last_modified) from orbeon_form_definition
where
app = ?
and form = ?
)
and deleted = 'N'
2011-02-24
15:05:20,546 DEBUG SQLProcessor - Execute row: rowNum = 1 2011-02-24
15:05:20,546 DEBUG SQLProcessor - ResultSet info: no more result set,
update count = -1 Regards, Smaran Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not the
intended recipient, you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately and destroy all copies of this message and
any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.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 OW2 mailing lists service home page: http://www.ow2.org/wws |
| Free forum by Nabble | Edit this page |