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