> Hi Erik,
>
>
>
> You are correct. The Tomcat was not picking the JNDI connection. I followed
> the guide line given in the following link.
>
>
http://wiki.orbeon.com/forms/doc/developer-guide/form-runner-oracle-persistence-layer>
> The only change what was missed out in the above link was in “Application
> Server Setup”. I added the JNDI resource in server.xml within the context
> and it worked.
>
> <Context path="/orbeon" docBase="orbeon" debug="5" reloadable="true"
> crossContext="true">
>
> <Resource name="jdbc/oracle" auth="Container"
> type="javax.sql.DataSource"
> initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
>
> validationQuery="select * from dual"
> driverClassName="oracle.jdbc.OracleDriver"
> poolPreparedStatements="true"
> username="orbeon"
> password="password"
> url="jdbc:oracle:thin:@//oracle.acme.com:1521/orcl"/>
>
> </Context>
>
>
>
> The following link was useful to find out the resolution
>
>
http://tomcat.apache.org/tomcat-4.1-doc/jndi-datasource-examples-howto.html>
>
>
>
>
> Thanks,
>
> Gopi Krishna
>
>
>
> -----Original Message-----
> From: Erik Bruchez [mailto:
[hidden email]]
> Sent: Wednesday, May 06, 2009 5:27 AM
> To:
[hidden email]
> Subject: [ops-users] Re: Re: Re: Error saving form definition and data to
> oracle database
>
>
>
> So are you saying that this is now a different problem? The exception you
> pasted below says that WebLogic cannot connect to the database because it
> does not find the JNDI name. Do you now have a different exception?
>
>
>
> -Erik
>
>
>
> On May 5, 2009, at 4:35 PM, Gopi Krishna wrote:
>
>
>
>> Hi Erik,
>
>>
>
>> Thanks for your response. The server seems to connect with the
>
>> database. I am trying JNDI datasource connectivity of weblogic.
>
>> While refering to the following line in "oxf:/apps/fr/persistence/
>
>> oracle/crud.xpl" file it is giving our exceptions
>
>>
>
>> <xsl:if test="not($is-attachment)">
>
>> XMLType(<sql:param type="odt:xmlFragment" sql-type="clob" select="/
>
>> request/document/*"/>)
>
>> </xsl:if>
>
>> I have attached the file which is creating the problem. In line no
>
>> 350 the above code exists. Any suggestions on this.
>
>>
>
>> Thanks,
>
>> Gopi Krishna
>
>>
>
>> On Wed, May 6, 2009 at 2:44 AM, Erik Bruchez <
[hidden email]>
>
>> wrote:
>
>> You will have to figure out why your application server doesn't seem
>
>> to expose the JDBC name for that datasource.
>
>>
>
>> -Erik
>
>>
>
>>
>
>> On May 5, 2009, at 1:46 PM, Gopi Krishna wrote:
>
>>
>
>> Hi,
>
>>
>
>> I am new to the world of XForms. I tried configuring the orbeon
>
>> persistence layer as oracle and succeeded with the configuration as
>
>> guided in the following link
>
>>
>
>>
>> "
http://wiki.orbeon.com/forms/doc/developer-guide/form-runner-oracle-persistence-layer>
>> "
>
>>
>
>> When i try to create a new form in Form Builder and save it. I am
>
>> getting the following exception. Can someone help me on this.
>
>>
>
>> I am running "Orbeon Forms 3.7.0beta1+.200902120135" in weblogic 9.2.
>
>>
>
>> Orbeon Forms Error
>
>> Type
>
>> class javax.naming.NameNotFoundException
>
>> Message
>
>> While trying to look up jdbc/oracle in java:comp/env.
>
>> Location
>
>> oxf:/apps/fr/persistence/oracle/crud.xpl
>
>> Line
>
>> 350
>
>> Column
>
>> -1
>
>> Stack Trace
>
>> javax.naming.NameNotFoundException: While trying to look up jdbc/
>
>> oracle in java:comp/env.; remaining name 'jdbc/oracle'
>
>> at
>
>> weblogic
>
>> .jndi
>
>> .internal
>
>> .BasicNamingNode.newNameNotFoundException(BasicNamingNode.java:1139)
>
>>
>
>> at
>
>> weblogic
>
>> .jndi
>
>> .internal.ApplicationNamingNode.lookup(ApplicationNamingNode.java:142)
>
>> at
>
>> weblogic
>
>> .jndi.internal.WLEventContextImpl.lookup(WLEventContextImpl.java:269)
>
>> at
>
>> weblogic.jndi.internal.WLContextImpl.lookup(WLContextImpl.java:362)
>
>>
>
>> at
>
>> weblogic
>
>> .jndi
>
>> .factories
>
>> .java.ReadOnlyContextWrapper.lookup(ReadOnlyContextWrapper.java:45)
>
>> at
>
>> org
>
>> .orbeon
>
>> .oxf.processor.DatabaseContext.getConnection(DatabaseContext.java:55)
>
>> at
>
>> org
>
>> .orbeon
>
>> .oxf
>
>> .processor
>
>> .sql
>
>> .SQLProcessorInterpreterContext
>
>> .getConnection(SQLProcessorInterpreterContext.java:318)
>
>>
>
>> at
>
>> org
>
>> .orbeon
>
>> .oxf
>
>> .processor
>
>> .sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:184)
>
>> at org.orbeon.oxf.processor.sql.SQLProcessor
>
>> $InterpreterContentHandler.endElement(SQLProcessor.java:542)
>
>> at org.orbeon.oxf.processor.sql.SQLProcessor
>
>> $ForwardingContentHandler.endElement(SQLProcessor.java:634)
>
>>
>
>> at org.orbeon.oxf.processor.sql.SQLProcessor
>
>> $InterpreterContentHandler.endElement(SQLProcessor.java:544)
>
>> at org.orbeon.oxf.processor.sql.SQLProcessor
>
>> $ForwardingContentHandler.endElement(SQLProcessor.java:634)
>
>> at org.orbeon.oxf.processor.sql.SQLProcessor
>
>> $InterpreterContentHandler.endElement(SQLProcessor.java:544)
>
>>
>
>> at org.orbeon.oxf.processor.sql.SQLProcessor
>
>> $ForwardingContentHandler.endElement(SQLProcessor.java:634)
>
>> at org.orbeon.oxf.processor.sql.SQLProcessor
>
>> $InterpreterContentHandler.endElement(SQLProcessor.java:544)
>
>> at org.orbeon.oxf.processor.sql.SQLProcessor
>
>> $RootInterpreter.endElement(SQLProcessor.java:304)
>
>>
>
>> at org.orbeon.oxf.xml.SAXStore.replay(SAXStore.java:202)
>
>> at
>
>> org.orbeon.oxf.processor.sql.SQLProcessor.execute(SQLProcessor.java:
>
>> 268)
>
>> at
>
>> org.orbeon.oxf.processor.sql.SQLProcessor.start(SQLProcessor.java:117)
>
>> at org.orbeon.oxf.processor.pipeline.PipelineProcessor
>
>> $11.run(PipelineProcessor.java:644)
>
>>
>
>> at
>
>> org
>
>> .orbeon
>
>> .oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:519)
>
>> at
>
>> org
>
>> .orbeon
>
>> .oxf
>
>> .processor.pipeline.PipelineProcessor.start(PipelineProcessor.java:
>
>> 641)
>
>> at
>
>> org
>
>> .orbeon
>
>> .oxf
>
>> .processor
>
>> .pipeline
>
>> .choose.ConcreteChooseProcessor.start(ConcreteChooseProcessor.java:
>
>> 242)
>
>>
>
>> at org.orbeon.oxf.processor.pipeline.PipelineProcessor
>
>> $11.run(PipelineProcessor.java:644)
>
>> at
>
>> org
>
>> .orbeon
>
>> .oxf.processor.ProcessorImpl.executeChildren(ProcessorImpl.java:519)
>
>> at
>
>> org
>
>> .orbeon
>
>> .oxf
>
>> .processor.pipeline.PipelineProcessor.start(PipelineProcessor.java:
>
>> 641)
>
>>
>
>>
>
>>
>
>>
>
>> Thanks For your help,
>
>> Gopi Krishna
>
>>
>
>> This message may contain privileged and/or confidential information.
>
>> If you have received this e-mail in error or are not the intended
>
>> recipient, you may not use, copy, disseminate or distribute it; do
>
>> not open any attachments, delete it immediately from your system and
>
>> notify the sender promptly by e-mail that you have done so. Thank you.
>
>> Powered by STPL Portal .
>
>>
>
>>
>
>> --
>
>> 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>
>>
>
>> --
>
>> Orbeon Forms - Web Forms for the Enterprise Done the Right Way
>
>>
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
>
>> OW2 mailing lists service home page:
http://www.ow2.org/wws>
>>
>
>>
>
>>
>
>>
>
>> --
>
>> Thanks,
>
>> Gopi Krishna
>
>> Software Engineer
>
>> Sysbiz Technologies Pvt. Ltd
>
>> (A subsidiary of BPI Technologies Inc)
>
>>
>
>> Office - +91-44-42636341 (EXT) - 222
>
>> Mobile - +91-9884719229
>
>> This message may contain privileged and/or confidential information.
>
>> If you have received this e-mail in error or are not the intended
>
>> recipient, you may not use, copy, disseminate or distribute it; do
>
>> not open any attachments, delete it immediately from your system and
>
>> notify the sender promptly by e-mail that you have done so. Thank you.
>
>> Powered by STPL Portal .
>
>>
>
>> <crud.xpl>
>
>> --
>
>> 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>
>
>
> --
>
> Orbeon Forms - Web Forms for the Enterprise Done the Right Way
>
>
http://www.orbeon.com/>
>
>
> This message may contain privileged and/or confidential information. If you
> have received this e-mail in error or are not the intended recipient, you
> may not use, copy, disseminate or distribute it; do not open any
> attachments, delete it immediately from your system and notify the sender
> promptly by e-mail that you have done so. Thank you.
> Powered by STPL Portal .
>
>
>
> --
> 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
crud.xpl (34K)