Hmm
maybe gmail swallowed some part but I got:
<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"/>
which can't work, if you set the previous one which seems correct you
shouldn't get an error is the oracle driver is in the common.loader
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. Unfortunately I am unable to find the difference between what I have
> written and what is recommended by Tomee.
>
> ---TomEE --------------------------------------
> <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>
>
> ---Mine-------------------------------------------
>
> <Resource id="jdbc/jQuery" type="DataSource">
> JdbcDriver oracle.jdbc.OracleDriver
> JdbcUrl jdbc:oracle:thin:@10.10.10.10:1521:A5310209
> UserName u
> Password pass
> </Resource>
>
> Do you see any difference ?
>
> 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 7:20 PM
> To: Ajit Kanada
> Cc: users@tomee.apache.org; OpenEJB Users
> Subject: Re: TomEE- 1.5.2 SEVERE: FATAL ERROR: Unknown error in Assembler.
>
> 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.
>>> >>
>>> >>
>>> >
>>> >
> ****************************************************************************
>>> >>
>>> >
>>> >
> ****************************************************************************
>>> >> *******
>>> >>
>>> >>
>>> >>
>>> >
>>
>>
>
