This works (tested last week again) but it is not what you do Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr.linkedin.com/in/rmannibucau Github: https://github.com/rmannibucau
2013/11/12 Ajit Kanada <ajit.kan...@electracard.com>: > This is what tomme official site refers to. > > http://tomee.apache.org/common-datasource-configurations.html > > This has sample configurations for Oracle. If you have > > <Resource id="Oracle Database" type="DataSource"> > # Oracle example > # > # This connector will not work until you download the driver at: > # http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html > JdbcDriver oracle.jdbc.OracleDriver > JdbcUrl jdbc:oracle:thin:@localhost:1521:orcl > UserName scott > Password tiger > </Resource> > > If you have working sample tomee.xml which has datasource configurations, > please share with me. > > > > > -- > Ajit Kanada > Electra Card Services Pvt. Ltd., > > > ***************************************************************************************************************************************************************************************** > > This message contains information that may be privileged or confidential and > is the property of Electra card Services. It is intended only for the person > to whom it is addressed. If you are not the intended recipient, you are not > authorized to read, print, retain, copy, disseminate, distribute, or use > this message or any part thereof. If you receive this message in error, > please notify the sender immediately and delete all copies of this message. > ****************************************************************************************************************************************************************************************** > > > On Tue, Nov 12, 2013 at 7:09 PM, Romain Manni-Bucau <rmannibu...@gmail.com> > wrote: >> >> still not a tomee resource, config is passed through properties/xml >> body not through attributes >> Romain Manni-Bucau >> Twitter: @rmannibucau >> Blog: http://rmannibucau.wordpress.com/ >> LinkedIn: http://fr.linkedin.com/in/rmannibucau >> Github: https://github.com/rmannibucau >> >> >> >> 2013/11/12 ajit kanada <ajit.kan...@electracard.com>: >> > Thanks, >> > >> > Earlier I tried below. >> > <Resource >> > name="jdbc/jQuery" >> > auth="Container" >> > id="jQuery" >> > type="javax.sql.DataSource" >> > driverClassName="oracle.jdbc.OracleDriver" >> > url="jdbc:oracle:thin:@IP:Pass:A5310209" >> > username="u" >> > password="pass" >> > maxActive="20" >> > maxIdle="10" >> > maxWait="-1"/> >> > >> > >> > And I got below error. >> > >> > Nov 12, 2013 7:08:53 PM org.apache.tomee.catalina.ServerListener >> > lifecycleEvent >> > SEVERE: TomEE Listener can't start OpenEJB >> > org.apache.openejb.OpenEJBException: Unable to read OpenEJB >> > configuration >> > file at D:\Work\PMG\PG-Roadmap-electraECOMM10. >> > 0\Dev\MyStuff\apache-tomee-plus-1.5.2\conf\tomee.xml: Unsupported >> > Attribute(s): name, auth, driverClassName, url, userna >> > me, password, maxActive, maxIdle, maxWait. Supported Attributes are: >> > type, >> > jar, provider, id, class-name, constructor, >> > factory-name, jndi, aliases. If the setting is a configuration property >> > it >> > must be placed inside the element body. >> > at >> > >> > org.apache.openejb.config.sys.JaxbOpenejb.readConfig(JaxbOpenejb.java:252) >> > at >> > >> > org.apache.openejb.config.ConfigurationFactory.getOpenEjbConfiguration(Confi >> > gurationFactory.java:433) >> > at >> > >> > org.apache.openejb.assembler.classic.Assembler.getOpenEjbConfiguration(Assem >> > bler.java:373) >> > at >> > org.apache.openejb.assembler.classic.Assembler.build(Assembler.java:352) >> > at org.apache.openejb.OpenEJB$Instance.<init>(OpenEJB.java:147) >> > at org.apache.openejb.OpenEJB.init(OpenEJB.java:292) >> > at >> > org.apache.tomee.catalina.TomcatLoader.initialize(TomcatLoader.java:233) >> > at >> > org.apache.tomee.catalina.TomcatLoader.init(TomcatLoader.java:130) >> > at >> > >> > org.apache.tomee.catalina.ServerListener.lifecycleEvent(ServerListener.java: >> > 121) >> > at >> > >> > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor >> > t.java:119) >> > at >> > >> > org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java >> > :90) >> > at >> > >> > org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:4 >> > 02) >> > at >> > org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:110) >> > at org.apache.catalina.startup.Catalina.load(Catalina.java:633) >> > at org.apache.catalina.startup.Catalina.load(Catalina.java:658) >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> > at >> > >> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 >> > ) >> > at >> > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl >> > .java:25) >> > at java.lang.reflect.Method.invoke(Method.java:597) >> > at >> > org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:281) >> > at >> > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:455) >> > Caused by: org.xml.sax.SAXException: Unsupported Attribute(s): name, >> > auth, >> > driverClassName, url, username, password, max >> > Active, maxIdle, maxWait. Supported Attributes are: type, jar, >> > provider, >> > id, class-name, constructor, factory-name, jnd >> > i, aliases. If the setting is a configuration property it must be >> > placed >> > inside the element body. >> > at >> > >> > org.apache.openejb.config.sys.StackHandler.checkAttributes(StackHandler.java >> > :59) >> > at >> > >> > org.apache.openejb.config.sys.StackHandler$ServiceElement.startElement(Stack >> > Handler.java:140) >> > at >> > >> > org.apache.openejb.config.sys.StackHandler$ResourceElement.startElement(Stac >> > kHandler.java:175) >> > at >> > >> > org.apache.openejb.config.sys.SaxOpenejb$Root.startElement(SaxOpenejb.java:7 >> > 7) >> > at >> > >> > org.apache.openejb.config.sys.StackHandler.startElement(StackHandler.java:82 >> > ) >> > at >> > org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown >> > Source) >> > at >> > org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown >> > Source) >> > at >> > >> > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatc >> > her.dispatch(Unknown Source) >> > at >> > >> > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown >> > Source) >> > at org.apache.xerces.parsers.XML11Configuration.parse(Unknown >> > Source) >> > at org.apache.xerces.parsers.XML11Configuration.parse(Unknown >> > Source) >> > at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) >> > at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown >> > Source) >> > at >> > org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown >> > Source) >> > at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) >> > at >> > org.apache.openejb.config.sys.SaxOpenejb.parse(SaxOpenejb.java:52) >> > at >> > >> > org.apache.openejb.config.sys.JaxbOpenejb.readConfig(JaxbOpenejb.java:259) >> > at >> > >> > org.apache.openejb.config.sys.JaxbOpenejb.readConfig(JaxbOpenejb.java:248) >> > ... 20 more >> > >> > Ajit Kanada >> > Electracard Services >> > Phone : +91-02066272100- Ext. 108 >> > Pune,India >> > >> > **************************************************************************** >> > >> > **************************************************************************** >> > ******* >> > This message contains information that may be privileged or confidential >> > and >> > is the property of Electra card Services. It is intended only for the >> > person >> > to whom it is addressed. If you are not the intended recipient, you are >> > not >> > authorized to read, print, retain, copy, disseminate, distribute, or use >> > this message or any part thereof. If you receive this message in error, >> > please notify the sender immediately and delete all copies of this >> > message. >> > >> > **************************************************************************** >> > >> > **************************************************************************** >> > ******* >> > >> > >> > -----Original Message----- >> > From: Romain Manni-Bucau [mailto:rmannibu...@gmail.com] >> > Sent: Tuesday, November 12, 2013 6:59 PM >> > To: users@tomee.apache.org; ajit.kan...@electracard.com >> > Cc: OpenEJB Users >> > Subject: Re: TomEE- 1.5.2 SEVERE: FATAL ERROR: Unknown error in >> > Assembler. >> > >> > Hi >> > >> > this is not the way to declare a resource in tomee.xml: >> > >> > <Resource id="My DataSource" type="DataSource"> >> > JdbcDriver org.hsqldb.jdbcDriver >> > JdbcUrl jdbc:hsqldb:file:data/hsqldb/hsqldb >> > UserName sa >> > Password >> > JtaManaged true >> > </Resource> >> > Romain Manni-Bucau >> > Twitter: @rmannibucau >> > Blog: http://rmannibucau.wordpress.com/ >> > LinkedIn: http://fr.linkedin.com/in/rmannibucau >> > Github: https://github.com/rmannibucau >> > >> > >> > >> > 2013/11/12 ajit kanada <ajit.kan...@electracard.com>: >> >> Hi, >> >> >> >> >> >> >> >> I am getting below error when I configure data source as below. >> >> >> >> >> >> >> >> >> >> >> >> <?xml version="1.0" encoding="UTF-8"?> >> >> >> >> <tomee> >> >> >> >> <!-- see http://tomee.apache.org/containers-and-resources.html --> >> >> >> >> <!-- >> >> >> >> <Resource >> >> >> >> name="jdbc/jQuery" >> >> >> >> auth="Container" >> >> >> >> id="jQuery" >> >> >> >> type="javax.sql.DataSource" >> >> >> >> driverClassName="oracle.jdbc.OracleDriver" >> >> >> >> url="jdbc:oracle:thin:@IP:PORT:A5310209" >> >> >> >> username="unam" >> >> >> >> password="pass" >> >> >> >> maxActive="20" >> >> >> >> maxIdle="10" >> >> >> >> maxWait="-1"> >> >> >> >> >> >> >> >> </Resource> >> >> >> >> --> >> >> >> >> >> >> >> >> <Resource id="jdbc/jQuery" >> >> type="javax.sql.DataSource"> >> >> >> >> JdbcDriver oracle.jdbc.OracleDriver >> >> >> >> JdbcUrl jdbc:oracle:thin:@10.10.10.16:1521:A5310209 >> >> >> >> UserName epgicicipsg >> >> >> >> Password elttest1 >> >> >> >> </Resource> >> >> >> >> >> >> >> >> </tomee> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> SEVERE: FATAL ERROR: Unknown error in Assembler. Please send the >> > following >> >> stack trace and this message to users@openej >> >> >> >> b.apache.org : >> >> >> >> org.apache.xbean.propertyeditor.PropertyEditorException: Unable to >> > resolve >> >> class oracle.jdbc.OracleDriver >> >> >> >> at >> >> >> > >> > org.apache.xbean.propertyeditor.ClassEditor.toObjectImpl(ClassEditor.java:43 >> >> ) >> >> >> >> at >> >> >> > >> > org.apache.xbean.propertyeditor.AbstractConverter.toObject(AbstractConverter >> >> .java:86) >> >> >> >> at >> >> >> > >> > org.apache.xbean.propertyeditor.PropertyEditors.getValue(PropertyEditors.jav >> >> a:284) >> >> >> >> at >> >> org.apache.xbean.recipe.RecipeHelper.convert(RecipeHelper.java:172) >> >> >> >> at >> >> >> > >> > org.apache.xbean.recipe.ObjectRecipe.extractConstructorArgs(ObjectRecipe.jav >> >> a:592) >> >> >> >> at >> >> >> >> org.apache.xbean.recipe.ObjectRecipe.internalCreate(ObjectRecipe.java:275) >> >> >> >> at >> >> org.apache.xbean.recipe.AbstractRecipe.create(AbstractRecipe.java:96) >> >> >> >> at >> >> org.apache.xbean.recipe.AbstractRecipe.create(AbstractRecipe.java:61) >> >> >> >> at >> >> org.apache.xbean.recipe.AbstractRecipe.create(AbstractRecipe.java:49) >> >> >> >> at >> >> >> > >> > org.apache.openejb.assembler.classic.Assembler.createResource(Assembler.java >> >> :1797) >> >> >> >> at >> >> >> > >> > org.apache.openejb.assembler.classic.Assembler.buildContainerSystem(Assemble >> >> r.java:434) >> >> >> >> at >> >> >> >> org.apache.openejb.assembler.classic.Assembler.build(Assembler.java:353) >> >> >> >> at org.apache.openejb.OpenEJB$Instance.<init>(OpenEJB.java:147) >> >> >> >> at org.apache.openejb.OpenEJB.init(OpenEJB.java:292) >> >> >> >> at >> >> >> >> org.apache.tomee.catalina.TomcatLoader.initialize(TomcatLoader.java:233) >> >> >> >> at >> >> org.apache.tomee.catalina.TomcatLoader.init(TomcatLoader.java:130) >> >> >> >> at >> >> >> > >> > org.apache.tomee.catalina.ServerListener.lifecycleEvent(ServerListener.java: >> >> 121) >> >> >> >> at >> >> >> > >> > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor >> >> t.java:119) >> >> >> >> at >> >> >> > >> > org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java >> >> :90) >> >> >> >> at >> >> >> > >> > org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:4 >> >> 02) >> >> >> >> at >> >> org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:110) >> >> >> >> at org.apache.catalina.startup.Catalina.load(Catalina.java:633) >> >> >> >> at org.apache.catalina.startup.Catalina.load(Catalina.java:658) >> >> >> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> >> >> >> at >> >> >> > >> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 >> >> ) >> >> >> >> at >> >> >> > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl >> >> .java:25) >> >> >> >> at java.lang.reflect.Method.invoke(Method.java:597) >> >> >> >> at >> >> org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:281) >> >> >> >> at >> >> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:455) >> >> >> >> Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver >> >> >> >> at java.net.URLClassLoader$1.run(URLClassLoader.java:202) >> >> >> >> at java.security.AccessController.doPrivileged(Native Method) >> >> >> >> at java.net.URLClassLoader.findClass(URLClassLoader.java:190) >> >> >> >> at java.lang.ClassLoader.loadClass(ClassLoader.java:307) >> >> >> >> at java.lang.ClassLoader.loadClass(ClassLoader.java:248) >> >> >> >> at java.lang.Class.forName0(Native Method) >> >> >> >> at java.lang.Class.forName(Class.java:247) >> >> >> >> at >> >> >> > >> > org.apache.xbean.propertyeditor.ClassEditor.toObjectImpl(ClassEditor.java:40 >> >> ) >> >> >> >> ... 28 more >> >> >> >> >> >> >> >> Ajit Kanada >> >> >> >> Electracard Services >> >> >> >> Phone : +91-02066272100- Ext. 108 >> >> >> >> Pune,India >> >> >> >> >> > >> > **************************************************************************** >> >> >> > >> > **************************************************************************** >> >> ******* >> >> >> >> This message contains information that may be privileged or >> >> confidential >> > and >> >> is the property of Electra card Services. It is intended only for the >> > person >> >> to whom it is addressed. If you are not the intended recipient, you are >> > not >> >> authorized to read, print, retain, copy, disseminate, distribute, or >> >> use >> >> this message or any part thereof. If you receive this message in error, >> >> please notify the sender immediately and delete all copies of this >> > message. >> >> >> >> >> > >> > **************************************************************************** >> >> >> > >> > **************************************************************************** >> >> ******* >> >> >> >> >> >> >> > > >
