Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
Locked
Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
 
|
Hello,
I have installed orbeon 3.7.1 in jboss 4.2.2, and it works fine with the default database exist. If I connect Orbeon with Oracle, reading tables works fine too, but when is going to Save something (a new form/book or editing a form/book previous, I have proved orbeon and connect to Oracle from Tomcat, and inserted some books and forms in the Oracle's database correctly) appears one error. First of all, the configuration: The configuration of Orbeon 3.7.1 in JBoss 4.2.2 and persistance in Oracle 10.2.0 is the next: $JBOSS_HOME-4_2_2\server\default\deploy\oracle-ds.xml <?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>OracleDS</jndi-name> <connection-url>jdbc:oracle:thin:@172.xxx.xxx.xxx:1521:ora10D</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>orbeon</user-name> <password>orbeon</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> </local-tx-datasource> </datasources> /orbeon/WebContent/WEB-INF/jboss-web.xml <?xml version="1.0" encoding="UTF-8"?> <jboss-web> <resource-ref> <res-ref-name>jdbc/OracleDS</res-ref-name> <jndi-name>java:/OracleDS</jndi-name> </resource-ref> </jboss-web> /orbeon/WebContent/WEB-INF/web.xml ... <context-param> <param-name>oxf.initialize-logging</param-name> <param-value>false</param-value><!-- JBoss: change true to false --> </context-param> ... <resource-ref> <description>DataSource</description> <res-ref-name>jdbc/OracleDS</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> ... /orbeon/WebContent/WEB-INF/resources/config/properties-form-runner.xml
...
<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/oracle"/>
<property as="xs:anyURI" name="oxf.fr.persistence.service.exist.uri" value="/exist/rest/db"/>
<property as="xs:anyURI " name="oxf.fr.persistence.service.oracle.datasource" value="OracleDS"/>
...
driver
$JBOSS_HOME-4_2_2\server\default\lib\ojdbc14.jar
And the error that appears: 2010-05-10 13:11:02,459 ERROR [org.orbeon.oxf.webapp.ProcessorService] Exception with no location data java.lang.ClassNotFoundException: org.apache.commons.dbcp.DelegatingPreparedStatement at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204) at org.orbeon.oxf.processor.sql.delegates.SQLProcessorOracleTomcat4Delegate.getOraclePreparedStatement(SQLProcessorOracleTomcat4Delegate.java:43) at org.orbeon.oxf.processor.sql.SQLProcessorOracleDelegateBase.setClob(SQLProcessorOracleDelegateBase.java:70) at org.orbeon.oxf.processor.sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:482) 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) ... ¿Any idea? ¿Somebody knows why if the server is Tomcat this problem (ClassNotFoundException) not exists but in the server JBoss appears? I have proved to add various dbcp libraries (commons-dbcp-1.3.jar, commons-dbcp-1.4.jar, naming-factory-dbcp.jar) in differents locations (default/lib, orbeon/WEB-INF/lib), but then appears other error when is going to Save something in database. The error that appers in this case:
2010-05-10 13:47:12,506 INFO [org.orbeon.oxf.processor.sql.SQLProcessor] Using Oracle Tomcat 4 delegate.
2010-05-10 13:47:12,522 ERROR [org.orbeon.oxf.processor.sql.SQLProcessor] PreparedStatement:
declare
last_last_modified timestamp;
last_created timestamp;
last_deleted char(1);
begin
select max(last_modified), max(created) into last_last_modified, last_created
from (
(
select max(last_modified) last_modified, max(created) created
from orbeon_form_data
where
app = ?
and form = ?
and document_id = ?
) union all ( select null last_modified, null created from dual )
) ;
if last_last_modified is not null then
select deleted into last_deleted
from orbeon_form_data
where
app = ?
and form = ?
and document_id = ?
and last_modified = last_last_modified ;
end if;
if last_deleted is null or last_deleted = 'Y' then
last_created := ? ;
end if;
insert
into orbeon_form_data
(created, last_modified, username, app, form, document_id, deleted,
xml)
values (
last_created,
? ,
? ,
? ,
? ,
? ,
'N',
XMLType( ? )
);
end;
2010-05-10 13:47:12,522 INFO [org.orbeon.oxf.processor.DatabaseContext] Rolling back JDBC connection for datasource: jdbc/OracleDS.
2010-05-10 13:47:12,522 ERROR [org.orbeon.oxf.webapp.ProcessorService] Exception at line 368 of oxf:/apps/fr/persistence/oracle/crud.xpl
java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.WrappedPreparedStatement cannot be cast to org.apache.commons.dbcp.DelegatingPreparedStatement
at org.orbeon.oxf.processor.sql.delegates.SQLProcessorOracleTomcat4Delegate.getOraclePreparedStatement(SQLProcessorOracleTomcat4Delegate.java:43)
at org.orbeon.oxf.processor.sql.SQLProcessorOracleDelegateBase.setClob(SQLProcessorOracleDelegateBase.java:70)
at org.orbeon.oxf.processor.sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:482)
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)
...
I don't know which could be the problem. Thanks a lot for the help. |
Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
Administrator
|
This class is present in the commons-dbcp-1.1.jar that comes with
Orbeon Forms, but maybe JBoss uses another version of that library which doesn't have that class. Try changing the WEB-INF/jboss-web.xml to instruct JBoss to use in priority the classes coming from the war file. Maybe adding the following: <loader-repository>orbeon.war:loader=orbeon.war</loader-repository> Inside the <jboss-web> will do the trick. I found the JBoss documentation on this subject to be lacking, but you'll find some fragmentary information which might help at: http://community.jboss.org/wiki/classloadingconfiguration Alex On Tue, May 11, 2010 at 12:11 AM, paleandromus <[hidden email]> wrote: > > Hello, > > I have installed orbeon 3.7.1 in jboss 4.2.2, and it works fine with the > default database exist. > > If I connect Orbeon with Oracle, reading tables works fine too, but when is > going to Save something (a new form/book or editing a form/book previous, I > have proved orbeon and connect to Oracle from Tomcat, and inserted some > books and forms in the Oracle's database correctly) appears one error. > > First of all, the configuration: > > The configuration of Orbeon 3.7.1 in JBoss 4.2.2 and persistance in Oracle > 10.2.0 is the next: > $JBOSS_HOME-4_2_2\server\default\deploy\oracle-ds.xml > > <?xml version="1.0" encoding="UTF-8"?> > <datasources> > <local-tx-datasource> > <jndi-name>OracleDS</jndi-name> > > <connection-url>jdbc:oracle:thin:@172.xxx.xxx.xxx:1521:ora10D</connection-url> > <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> > <user-name>orbeon</user-name> > <password>orbeon</password> > > <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> > </local-tx-datasource> > </datasources> > > > /orbeon/WebContent/WEB-INF/jboss-web.xml > > <?xml version="1.0" encoding="UTF-8"?> > <jboss-web> > <resource-ref> > <res-ref-name>jdbc/OracleDS</res-ref-name> > <jndi-name>java:/OracleDS</jndi-name> > </resource-ref> > </jboss-web> > > > /orbeon/WebContent/WEB-INF/web.xml > > ... > <context-param> > <param-name>oxf.initialize-logging</param-name> > <param-value>false</param-value><!-- JBoss: change true to false --> > </context-param> > ... > <resource-ref> > <description>DataSource</description> > <res-ref-name>jdbc/OracleDS</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > ... > > > /orbeon/WebContent/WEB-INF/resources/config/properties-form-runner.xml > > ... > <property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" > value="/fr/service/oracle"/> > > <property as="xs:anyURI" name="oxf.fr.persistence.service.exist.uri" > value="/exist/rest/db"/> > <property as="xs:anyURI " > name="oxf.fr.persistence.service.oracle.datasource" > value="OracleDS"/> > ... > > > driver > > $JBOSS_HOME-4_2_2\server\default\lib\ojdbc14.jar > > > And the error that appears: > > 2010-05-10 13:11:02,459 ERROR [org.orbeon.oxf.webapp.ProcessorService] > Exception with no location data > java.lang.ClassNotFoundException: > org.apache.commons.dbcp.DelegatingPreparedStatement > at > org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358) > at > org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204) > at > org.orbeon.oxf.processor.sql.delegates.SQLProcessorOracleTomcat4Delegate.getOraclePreparedStatement(SQLProcessorOracleTomcat4Delegate.java:43) > at > org.orbeon.oxf.processor.sql.SQLProcessorOracleDelegateBase.setClob(SQLProcessorOracleDelegateBase.java:70) > at > org.orbeon.oxf.processor.sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:482) > 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) > ... > > > ¿Any idea? > > ¿Somebody knows why if the server is Tomcat this problem > (ClassNotFoundException) not exists but in the server JBoss appears? > > I have proved to add various dbcp libraries (commons-dbcp-1.3.jar, > commons-dbcp-1.4.jar, naming-factory-dbcp.jar) in differents locations > (default/lib, orbeon/WEB-INF/lib), but then appears other error when is > going to Save something in database. The error that appers in this case: > > > 2010-05-10 13:47:12,506 INFO [org.orbeon.oxf.processor.sql.SQLProcessor] > Using Oracle Tomcat 4 delegate. > 2010-05-10 13:47:12,522 ERROR [org.orbeon.oxf.processor.sql.SQLProcessor] > PreparedStatement: > > declare > last_last_modified > timestamp; > last_created timestamp; > last_deleted char(1); > begin > > select > max(last_modified), max(created) into last_last_modified, last_created > from ( > ( > select > max(last_modified) last_modified, max(created) created > from > orbeon_form_data > where > app = ? > and form = > ? > and > document_id = ? > ) union all ( select > null last_modified, null created from dual ) > ) ; > > if last_last_modified is > not null then > select deleted into > last_deleted > from > orbeon_form_data > where > app = ? > and form = ? > and > document_id = ? > and > last_modified = last_last_modified ; > end if; > > if last_deleted is null > or last_deleted = 'Y' then > last_created := ? ; > end if; > > insert > into > orbeon_form_data > (created, > last_modified, username, app, form, document_id, deleted, > xml) > values ( > last_created, > ? , > ? , > ? , > ? , > ? , > > 'N', > > XMLType( ? ) > > > > ); > end; > > 2010-05-10 13:47:12,522 INFO [org.orbeon.oxf.processor.DatabaseContext] > Rolling back JDBC connection for datasource: jdbc/OracleDS. > 2010-05-10 13:47:12,522 ERROR [org.orbeon.oxf.webapp.ProcessorService] > Exception at line 368 of oxf:/apps/fr/persistence/oracle/crud.xpl > java.lang.ClassCastException: > org.jboss.resource.adapter.jdbc.WrappedPreparedStatement cannot be cast to > org.apache.commons.dbcp.DelegatingPreparedStatement > at > org.orbeon.oxf.processor.sql.delegates.SQLProcessorOracleTomcat4Delegate.getOraclePreparedStatement(SQLProcessorOracleTomcat4Delegate.java:43) > at > org.orbeon.oxf.processor.sql.SQLProcessorOracleDelegateBase.setClob(SQLProcessorOracleDelegateBase.java:70) > at > org.orbeon.oxf.processor.sql.interpreters.QueryInterpreter.end(QueryInterpreter.java:482) > 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) > ... > > > I don't know which could be the problem. > > Thanks a lot for the help. > -- > View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Problem-saving-data-from-Orbeon-to-Oracle-if-server-is-JBoss-no-problem-in-Tomcat-tp2173417p2173417.html > Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.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 > > -- Orbeon Forms - Web forms, open-source, for the Enterprise - http://www.orbeon.com/ My Twitter: http://twitter.com/avernet -- 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
--
Follow Orbeon on Twitter: @orbeon Follow me on Twitter: @avernet |
Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
|
Hello Alex, thank you very much for the reply. I did that you comment: configure in /orbeon.war/WEB-INF/jboss-web.xml a loader-repository: <?xml version="1.0" encoding="UTF-8"?> <jboss-web> <class-loading> <loader-repository> org.orbeon:archive=orbeon.war </loader-repository> </class-loading> ... </jboss-web>but now appears a new different error: Orbeon Forms Error Type class java.lang.ClassCastException Message org.apache.xerces.jaxp.datatype.DatatypeFactoryImpl cannot be cast to javax.xml.datatype.DatatypeFactory Location oxf:/ops/pfc/xforms-epilogue.xpl Line 140 Column 60 Stack Trace java.lang.ClassCastException: org.apache.xerces.jaxp.datatype.DatatypeFactoryImpl cannot be cast to javax.xml.datatype.DatatypeFactory at javax.xml.datatype.DatatypeFactory.newInstance(Unknown Source) at org.exist.xquery.XQueryContext.prepare(XQueryContext.java:465) at org.exist.xquery.XQuery.execute(XQuery.java:213) at org.exist.xquery.XQuery.execute(XQuery.java:184) at org.exist.xmldb.LocalXPathQueryService.execute(LocalXPathQueryService.java:388) at org.exist.xmldb.LocalXPathQueryService.doQuery(LocalXPathQueryService.java:305) at org.exist.xmldb.LocalXPathQueryService.query(LocalXPathQueryService.java:127) at org.exist.xmldb.LocalXPathQueryService.query(LocalXPathQueryService.java:118) at org.orbeon.oxf.processor.xmldb.XMLDBProcessor.executeQuery(XMLDBProcessor.java:295) at org.orbeon.oxf.processor.xmldb.XMLDBProcessor.query(XMLDBProcessor.java:175) ...In the last message I had forgotten to comment that I'm using Java6, I don't know if this detail is important. In this page http://orbeon.uservoice.com/forums/27-general/suggestions/201360-jboss5-orbeon-installation?ref=comments comment something about this error, but the solutions proposed (by Tomasz Wysocki and louisk) don't work, and the last link say "This thread has been deleted.": http://old.nabble.com/Orbeon-won%27t-run-on-JBoss-5.0,-need-help-td22957210.html ¿Any other idea about what is happening and how to correct the problem? Thank you in advance. Regards. |
Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
|
This new post is only for bring more information, and to comment that I have proved a lot of altenative configurations of the loader-repository, and for JBoss 4.2.2 seems that only works with com.example:archive=... (if the configuration of the loader-repository don't work simply appears the first error: ClassNotFoundException). For example, this alternative, in the same format that you comment in your reply, removes the error ClassNotFoundException but produces too the error ClassCastException: org.apache.xerces.jaxp.datatype.DatatypeFactoryImpl cannot be cast to javax.xml.datatype.DatatypeFactory <class-loading> <loader-repository> orbeon.war:archive=orbeon.war </loader-repository> </class-loading> |
Re: Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
Administrator
|
Indeed. I also tried this with JBoss 5.1.0 and 6.0.0-M3. For now, I
added a bug (linked below), added a note about this in the installation instructions, and it will take either someone contributing a fix for this or a client with Development Support plan for this to be fixed. http://forge.ow2.org/tracker/index.php?func=detail&aid=315005&group_id=168&atid=350207 Alex On Thu, May 13, 2010 at 3:50 AM, paleandromus <[hidden email]> wrote: > > > paleandromus wrote: >> >> >> <?xml version="1.0" encoding="UTF-8"?> >> <jboss-web> >> >> <class-loading> >> <loader-repository> >> org.orbeon:archive=orbeon.war >> </loader-repository> >> </class-loading> >> ... >> </jboss-web> >> >> > > This new post is only for bring more information, and to comment that I have > proved a lot of altenative configurations of the loader-repository, and for > JBoss 4.2.2 seems that only works with com.example:archive=... (if the > configuration of the loader-repository don't work simply appears the first > error: ClassNotFoundException). For example, this alternative, in the same > format that you comment in your reply, removes the error > ClassNotFoundException but produces too the error ClassCastException: > org.apache.xerces.jaxp.datatype.DatatypeFactoryImpl cannot be cast to > javax.xml.datatype.DatatypeFactory > > <class-loading> > <loader-repository> > orbeon.war:archive=orbeon.war > </loader-repository> > </class-loading> > > > -- > View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Problem-saving-data-from-Orbeon-to-Oracle-if-server-is-JBoss-no-problem-in-Tomcat-tp2173417p2197390.html > Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.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 > > -- Orbeon Forms - Web forms, open-source, for the Enterprise - http://www.orbeon.com/ My Twitter: http://twitter.com/avernet -- 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
--
Follow Orbeon on Twitter: @orbeon Follow me on Twitter: @avernet |
Re: Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
|
Thank you for your help.
|
Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
|
In reply to this post by paleandromus
The problem on Jboss is not with class loading. I ran into same problem when I deployed this on JBOSS. I defined my datasource in oracle-ds.xml and I was getting this class cast exception.
The problem is JBOSS data source didn't use DBCP. The SQLProcessorOracleTomcat4Delegate which was getting used assumes the classes are from DBCP. Ideally, I would fix it by creating JBOSS delegate and configure Orbeon to use it. I dont know how to configure Orbeon to use new SQL delegate. so here is what I did.
1. Download the source code. 2. Open the SQLProcessorOracleTomcat4Delegate.java 3. Replaced "PreparedStatement preparedStatement = ((DelegatingPreparedStatement) stmt).getDelegate();" with "PreparedStatement preparedStatement = ((WrappedPreparedStatementJDK5) stmt).getUnderlyingStatement();" 4. Replaced "((DelegatingResultSet) resultSet).getDelegate();" with "((WrappedResultSetJDK5) resultSet).getUnderlyingResultSet();" 5. Compile the code. Take the class file and update orbeon.jar inside orbeon.war file. |
Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
|
I proved this solution and works fine with JBoss 4.2.2 / Oracle, thank you very much!!! Now I have another question. I proved the solution with Orbeon 3.7.0 beta (the last version available in SVN repository), because the source code of Orbeon release 3.7.1 in GIT fails --> http://github.com/orbeon/orbeon-forms/tree/release-dev-3.7.1
I proved to supply the jars that are corrupted but then appears another errors This build works corretly with the source code of Orbeon 3.7.0 downloaded from SVN repository ¿anybody knows a repository/location/URL where I can obtain the source code of Orbeon release 3.7.1 that works? |
Re: Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
Administrator
|
Thanks for the feedback on JBoss.
I think what happened is that when we imported the old CVS repository into Git, some binary files ended up having a size of zero. I think that's what you are observing here. At any rate, the dev-3.7.1 build is pretty old now and it would be better if you used 3.8. Is it possible for you? -Erik On Fri, May 28, 2010 at 5:21 AM, paleandromus <[hidden email]> wrote: > Gaurav Shah wrote: > The problem on Jboss is not with class loading. I ran into same problem when > I deployed this on JBOSS. I defined my datasource in oracle-ds.xml and I was > getting this class cast exception. The problem is JBOSS data source didn't > use DBCP. The SQLProcessorOracleTomcat4Delegate which was getting used > assumes the classes are from DBCP. Ideally, I would fix it by creating JBOSS > delegate and configure Orbeon to use it. I dont know how to configure Orbeon > to use new SQL delegate. so here is what I did. > 1. Download the source code. > 2. Open the SQLProcessorOracleTomcat4Delegate.java > 3. Replaced "PreparedStatement preparedStatement = > ((DelegatingPreparedStatement) stmt).getDelegate();" with "PreparedStatement > preparedStatement = ((WrappedPreparedStatementJDK5) > stmt).getUnderlyingStatement();" > 4. Replaced "((DelegatingResultSet) resultSet).getDelegate();" with > "((WrappedResultSetJDK5) resultSet).getUnderlyingResultSet();" > 5. Compile the code. Take the class file and update orbeon.jar inside > orbeon.war file. > > I proved this solution and works fine with JBoss 4.2.2 / Oracle, thank you > very much!!! > > Now I have another question. > > I proved the solution with Orbeon 3.7.0 beta (the last version avalible in > SVN repository), because the source code of Orbeon relesase 3.7.1 in GIT > fails --> http://github.com/orbeon/orbeon-forms/tree/release-dev-3.7.1 > > > D:\workspace-orbeon\orbeon-forms>ant > Buildfile: D:\workspace-orbeon\orbeon-forms\build.xml > > init: > [echo] Building Orbeon Forms dev-3.7.1.201005281203 > > prepare: > [mkdir] Created dir: D:\workspace-orbeon\orbeon-forms\build\classes > [mkdir] Created dir: D:\workspace-orbeon\orbeon-forms\build\lib > > classpath: > > classes: > [mkdir] Created dir: D:\workspace-orbeon\orbeon-forms\build\src > [copy] Copying 1 file to D:\workspace-orbeon\orbeon-forms\build\src > [javac] D:\workspace-orbeon\orbeon-forms\build.xml:202: warning: > 'includeantruntime' was not set, defaulting to build.sysclasspa > th=last; set to false for repeatable builds > [javac] Compiling 744 source files to > D:\workspace-orbeon\orbeon-forms\build\classes > [javac] error: error reading > D:\workspace-orbeon\orbeon-forms\lib\antlr-2_7_4.jar; error in opening zip > file > [javac] error: error reading > D:\workspace-orbeon\orbeon-forms\lib\exist-xmlrpc-1_2-patched.jar; error in > opening zip file > [javac] error: error reading > D:\workspace-orbeon\orbeon-forms\lib\kawa-1_7.jar; error in opening zip file > [javac] error: error reading > D:\workspace-orbeon\orbeon-forms\lib\mondrian-0_5_orbeon.jar; error in > opening zip file > [javac] error: error reading > D:\workspace-orbeon\orbeon-forms\lib\mondrian-javacup.jar; error in opening > zip file > [javac] error: error reading > D:\workspace-orbeon\orbeon-forms\lib\saxon-6_5_2.jar; error in opening zip > file > [javac] error: error reading > D:\workspace-orbeon\orbeon-forms\lib\saxon-8_8_orbeon_20080516.jar; error in > opening zip file > [javac] error: error reading > D:\workspace-orbeon\orbeon-forms\lib\xalan-2_5_1_orbeon.jar; error in > opening zip file > [javac] error: error reading > D:\workspace-orbeon\orbeon-forms\lib\xsltc-2_5_1_orbeon.jar; error in > opening zip file > [javac] 9 errors > > BUILD FAILED > D:\workspace-orbeon\orbeon-forms\build.xml:202: Compile failed; see the > compiler error output for details. > > Total time: 5 seconds > D:\workspace-orbeon\orbeon-forms> > > > I proved to supply the jars are corrupted but then appears anothers errors > > This build works corretly with the source code of Orbeon 3.7.0 downloaded > from SVN repository > > ¿anybody knows a repository/location/URL where I can obtain the source code > of Orbeon release 3.7.1 that works? > > ________________________________ > View this message in context: Re: Problem saving data from Orbeon to Oracle > if server is JBoss (no problem in Tomcat) > Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.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 > > -- 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: Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
Administrator
|
In reply to this post by Gaurav Shah
Gaurav,
It would be good to integrate this with the SQL processor. The code that tries which delegate to use is in this file: http://github.com/orbeon/orbeon-forms/blob/master/src/java/org/orbeon/oxf/processor/sql/SQLProcessorInterpreterContext.java So the idea would be: * create new delegate class for JBoss * try to load that class in SQLProcessorInterpreterContext.java Is this something you can try? -Erik On Thu, May 27, 2010 at 8:13 AM, Gaurav Shah <[hidden email]> wrote: > The problem on Jboss is not with class loading. I ran into same problem when > I deployed this on JBOSS. I defined my datasource in oracle-ds.xml and I was > getting this class cast exception. The problem is JBOSS data source didn't > use DBCP. The SQLProcessorOracleTomcat4Delegate which was getting used > assumes the classes are from DBCP. Ideally, I would fix it by creating JBOSS > delegate and configure Orbeon to use it. I dont know how to configure Orbeon > to use new SQL delegate. so here is what I did. > 1. Download the source code. > 2. Open the SQLProcessorOracleTomcat4Delegate.java > 3. Replaced "PreparedStatement preparedStatement = > ((DelegatingPreparedStatement) stmt).getDelegate();" with "PreparedStatement > preparedStatement = ((WrappedPreparedStatementJDK5) > stmt).getUnderlyingStatement();" > 4. Replaced "((DelegatingResultSet) resultSet).getDelegate();" with > "((WrappedResultSetJDK5) resultSet).getUnderlyingResultSet();" > 5. Compile the code. Take the class file and update orbeon.jar inside > orbeon.war file. > ________________________________ > View this message in context: Re: Problem saving data from Orbeon to Oracle > if server is JBoss (no problem in Tomcat) > Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.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 > > -- 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: Re: Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
|
I can give it a try.
Gaurav
On Tue, Jun 1, 2010 at 6:19 PM, Erik Bruchez <[hidden email]> wrote: Gaurav, -- Gaurav Shah Born to make the Difference http://khantu.spaces.msn.com --------------------------------------------- The weak can never forgive. Forgiveness is the attribute of the strong. ''Mahatma Gandhi'' -- 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: Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
|
In reply to this post by Erik Bruchez
Thanks for you reply. but using version 3.8 is not an option for now, I would really like to get the source code for version dev-3.7.1 (the released version). Where could I get a working version from? Since I've already looked in CVS (it isn't available), SVN (same as CVS) and GIT (where I found a version which fails). Your help would be much appreciated. Thanks very much, regards. |
Re: Re: Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
Administrator
|
> Thanks for you reply. but using version 3.8 is not an option for now, I
> would really like to get the source code for version dev-3.7.1 (the released > version). Where could I get a working version from? Since I've already > looked in CVS (it isn't available), SVN (same as CVS) and GIT (where I found > a version which fails). > > Your help would be much appreciated. Thanks very much, regards. Did you try: cvs -z3 -d:pserver:[hidden email]:/cvsroot/ops co -r TAG_OPS_dev-3_7_1_200905272119 orbeon -Erik -- 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: Re: Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
|
This works fine, thank you very much!!! PS: I have put spaces intentionally in the command cvs (around the @) for visibility (else appears [hidden email] message) |
Re: Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
|
In reply to this post by Erik Bruchez
SQLProcessorOracleJBossDelegate.java
SQLProcessorInterpreterContext.java jboss-common-jdbc-wrapper.jar Above are the code changes to make Orbeon work on JBOSS with Oracle. Two java files and one jar files. The jar file needs to go to lib folder, and it should not be bundled in WAR file |
Re: Re: Re: Problem saving data from Orbeon to Oracle if server is JBoss (no problem in Tomcat)
|
Administrator
|
Gaurav,
Thanks, we will have a look at this! -Erik On Wed, Jun 9, 2010 at 11:32 AM, Gaurav Shah <[hidden email]> wrote: > SQLProcessorOracleJBossDelegate.java > SQLProcessorInterpreterContext.java > jboss-common-jdbc-wrapper.jar > Above are the code changes to make Orbeon work on JBOSS with Oracle. Two > java files and one jar files. The jar file needs to go to lib folder, and it > should not be bundled in WAR file > ________________________________ > View this message in context: Re: Re: Problem saving data from Orbeon to > Oracle if server is JBoss (no problem in Tomcat) > Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.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 > > -- 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 |
«
Return to Orbeon Forms community mailing list
|
1 view|%1 views
| Free forum by Nabble | Edit this page |