tomcat-jdbc is not the oracle driver...
2013/11/12 ajit kanada <ajit.kan...@electracard.com> > Yes. It is. > > > > > > 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:52 PM > To: Ajit Kanada > Cc: users@tomee.apache.org; OpenEJB Users > Subject: Re: TomEE- 1.5.2 SEVERE: FATAL ERROR: Unknown error in Assembler. > > > > are you sure oracle driver is in common.loader (tomee/lib)? > > 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>: > > > Please find the tomee.xml. > > > > > > This is the code.. > > > > > > public Connection getConnection(){ > > > > > > System.out.println("Initial Context is : " + moContext); > > > //DataSource ds; > > > try { > > > > > > System.out.println("Initial Context is : > > > -----------" + moContext); > > > > > > > > > ds = > > > (DataSource)moContext.lookup("java:comp/env/jdbc/jQuery"); > > > > > > System.out.println("DataSource is : > > > -----------" + ds); > > > > > > return ds.getConnection(); > > > > > > } catch (NamingException e) { > > > // TODO Auto-generated catch block > > > System.out.println("Naming > > > exception........."); > > > e.printStackTrace(); > > > } > > > catch (SQLException e) { > > > // TODO Auto-generated catch block > > > System.out.println("SQL > > > Exception.........."); > > > e.printStackTrace(); > > > } > > > > > > return null; > > > } > > > > > > 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: ajit kanada [mailto:ajit.kan...@electracard.com] > > > Sent: Tuesday, November 12, 2013 7:42 PM > > > To: 'Romain Manni-Bucau' > > > Cc: 'users@tomee.apache.org'; 'OpenEJB Users' > > > Subject: RE: TomEE- 1.5.2 SEVERE: FATAL ERROR: Unknown error in > Assembler. > > > > > > Hi, > > > > > > <Resource id="jdbc/jQuery" type="javax.sql.DataSource"> > > > > > > JdbcDriver oracle.jdbc.OracleDriver > > > JdbcUrl jdbc:oracle:thin:@10.10.10.16:1521:A5310209 > > > UserName unam > > > Password pass > > > </Resource> > > > > > > With this in conf/tomee.xml I am getting below error. I have > tomcat-jdbc.jar > > > in my tomcat folder. > > > > > > > > > Nov 12, 2013 7:40:39 PM org.apache.tomee.catalina.ServerListener > > > lifecycleEvent > > > SEVERE: TomEE Listener can't start OpenEJB > > > org.apache.openejb.OpenEJBException: > > > org.apache.xbean.propertyeditor.PropertyEditorException: Unable to > resolve > > > class or > > > acle.jdbc.OracleDriver: Unable to resolve class oracle.jdbc.OracleDriver > > > at > > > org.apache.openejb.assembler.classic.Assembler.build(Assembler.java:366) > > > 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.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) > > > ... 17 more > > > 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. > > > > **************************************************************************** > > > > **************************************************************************** > > > ******* > > > > > > > > > -----Original Message----- > > > From: Romain Manni-Bucau [mailto:rmannibu...@gmail.com] > > > Sent: Tuesday, November 12, 2013 7:34 PM > > > To: ajit.kan...@electracard.com > > > Cc: users@tomee.apache.org; OpenEJB Users > > > Subject: Re: TomEE- 1.5.2 SEVERE: FATAL ERROR: Unknown error in > Assembler. > > > > > > 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. > > >>>> >> > > >>>> >> > > >>>> > > > >>>> > > > >> > > > > **************************************************************************** > > >>>> >> > > >>>> > > > >>>> > > > >> > > > > **************************************************************************** > > >>>> >> ******* > > >>>> >> > > >>>> >> > > >>>> >> > > >>>> > > > >>> > > >>> > > >> >
