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.
> >>
> >>
> >
> ****************************************************************************
> >>
> >
> ****************************************************************************
> >> *******
> >>
> >>
> >>
> >
>
