Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Error when using Double in Entity on GlassFish v3

When you map them as Doubles you get
"java.lang.ClassNotFoundException: oracle.sql.TIMESTAMP" that's odd.

Did you try double primitive or float?

./tch



On Tue, Sep 30, 2008 at 9:54 AM, Wouter van Reeven <wouter@xxxxxxxxxxxxx> wrote:
> Hi all,
>
>
> As an active member of the GlassFish community I am involved in beta testing
> GlassFish v3. Last night I ran into a problem with EclipseLink on GFv3 build 26.
> When I reported the error on the quality GF mailinglist I was asked to post the
> error to this list.
>
> I have an Oracle XE database with a table with several NUMBER(3,1) columns. I am
> using ojbdc14.jar which I copied into the GlassFish lib dir.
>
> Whenever I map those columns to Integer members in my Entity the data is fetched
> ok but as integer values which makes sense but is not what I want.
>
> If I map them as Double like this
>
> @Column(name = "MAG")
> private Double mag;
>
> and redeploy my app, I get the stacktrace I copied and pasted below. Any ideas?
>
>
> Thanks, Wouter van Reeven
>
> javax.ejb.EJBException
>    at com.sun.ejb.containers.BaseContainer.processSystemException(BaseContainer.java:4152)
>    at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:4050)
>    at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3852)
>    at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1512)
>    at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1474)
>    at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:195)
>    at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:82)
>    at $Proxy122.getAllPlanning(Unknown Source)
>    at nl.reeven.van.astro.jsf.PlanningBackingBean.getAllPlanning(PlanningBackingBean.java:27)
>    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 javax.el.BeanELResolver.getValue(BeanELResolver.java:261)
>    at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:143)
>    at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
>    at com.sun.el.parser.AstValue.getValue(AstValue.java:138)
>    at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206)
>    at javax.faces.component.UIData.getValue(UIData.java:609)
>    at org.ajax4jsf.component.UIDataAdaptor.getValue(UIDataAdaptor.java:1640)
>    at org.ajax4jsf.component.SequenceDataAdaptor.getDataModel(SequenceDataAdaptor.java:48)
>    at org.ajax4jsf.component.SequenceDataAdaptor.createDataModel(SequenceDataAdaptor.java:42)
>    at org.richfaces.component.UIDataTable.createDataModel(UIDataTable.java:122)
>    at org.ajax4jsf.component.UIDataAdaptor.getExtendedDataModel(UIDataAdaptor.java:621)
>    at org.ajax4jsf.component.UIDataAdaptor.getRowCount(UIDataAdaptor.java:248)
>    at org.richfaces.component.UIDatascroller.getRowCount(UIDatascroller.java:347)
>    at org.richfaces.component.UIDatascroller.getPageCount(UIDatascroller.java:322)
>    at org.richfaces.component.UIDatascroller.getPageCount(UIDatascroller.java:343)
>    at org.richfaces.renderkit.html.DatascrollerTemplate.doEncodeEnd(DatascrollerTemplate.java:203)
>    at org.richfaces.renderkit.html.DatascrollerTemplate.doEncodeEnd(DatascrollerTemplate.java:680)
>    at org.ajax4jsf.renderkit.RendererBase.encodeEnd(RendererBase.java:135)
>    at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:861)
>    at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:286)
>    at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
>    at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:220)
>    at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:215)
>    at org.ajax4jsf.renderkit.RendererBase.encodeChildren(RendererBase.java:121)
>    at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
>    at javax.faces.component.UIComponent.encodeAll(UIComponent.java:936)
>    at javax.faces.render.Renderer.encodeChildren(Renderer.java:148)
>    at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
>    at javax.faces.component.UIComponent.encodeAll(UIComponent.java:936)
>    at javax.faces.component.UIComponent.encodeAll(UIComponent.java:942)
>    at com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:271)
>    at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:202)
>    at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:108)
>    at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:196)
>    at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:109)
>    at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
>    at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
>    at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
>    at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:431)
>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:337)
>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
>    at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:177)
>    at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:267)
>    at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:380)
>    at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:507)
>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:250)
>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:218)
>    at org.apache.catalina.core.StandardWrapperValve.preInvoke(StandardWrapperValve.java:460)
>    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:139)
>    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:186)
>    at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
>    at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
>    at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96)
>    at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
>    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187)
>    at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
>    at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
>    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
>    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
>    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:142)
>    at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719)
>    at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657)
>    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651)
>    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030)
>    at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:307)
>    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:226)
>    at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:180)
>    at com.sun.grizzly.http.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:625)
>    at com.sun.grizzly.http.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:562)
>    at com.sun.grizzly.http.DefaultProcessorTask.process(DefaultProcessorTask.java:819)
>    at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:152)
>    at com.sun.enterprise.v3.services.impl.GlassfishProtocolChain.executeProtocolFilter(GlassfishProtocolChain.java:71)
>    at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:103)
>    at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:89)
>    at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
>    at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:67)
>    at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:56)
>    at com.sun.grizzly.util.WorkerThreadImpl.processTask(WorkerThreadImpl.java:325)
>    at com.sun.grizzly.util.WorkerThreadImpl.run(WorkerThreadImpl.java:184)
> Caused by: java.lang.NoClassDefFoundError: oracle/sql/TIMESTAMP
>    at org.eclipse.persistence.internal.platform.database.oracle.TIMESTAMPTypes.<clinit>(TIMESTAMPTypes.java:22)
>    at org.eclipse.persistence.platform.database.oracle.Oracle9Platform.convertObject(Oracle9Platform.java:245)
>    at org.eclipse.persistence.mappings.foundation.AbstractDirectMapping.getFieldValue(AbstractDirectMapping.java:539)
>    at org.eclipse.persistence.internal.expressions.QueryKeyExpression.getFieldValue(QueryKeyExpression.java:304)
>    at org.eclipse.persistence.internal.expressions.ConstantExpression.printSQL(ConstantExpression.java:117)
>    at org.eclipse.persistence.expressions.ExpressionOperator.printDuo(ExpressionOperator.java:1816)
>    at org.eclipse.persistence.internal.expressions.CompoundExpression.printSQL(CompoundExpression.java:277)
>    at org.eclipse.persistence.internal.expressions.RelationExpression.printSQL(RelationExpression.java:563)
>    at org.eclipse.persistence.expressions.ExpressionOperator.printDuo(ExpressionOperator.java:1811)
>    at org.eclipse.persistence.internal.expressions.CompoundExpression.printSQL(CompoundExpression.java:277)
>    at org.eclipse.persistence.internal.expressions.ExpressionSQLPrinter.translateExpression(ExpressionSQLPrinter.java:288)
>    at org.eclipse.persistence.internal.expressions.ExpressionSQLPrinter.printExpression(ExpressionSQLPrinter.java:118)
>    at org.eclipse.persistence.internal.expressions.SQLSelectStatement.printSQL(SQLSelectStatement.java:1425)
>    at org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.printSQLSelectStatement(DatabasePlatform.java:2508)
>    at org.eclipse.persistence.platform.database.OraclePlatform.printSQLSelectStatement(OraclePlatform.java:696)
>    at org.eclipse.persistence.internal.expressions.SQLSelectStatement.buildCall(SQLSelectStatement.java:742)
>    at org.eclipse.persistence.descriptors.ClassDescriptor.buildCallFromStatement(ClassDescriptor.java:610)
>    at org.eclipse.persistence.internal.queries.StatementQueryMechanism.setCallFromStatement(StatementQueryMechanism.java:387)
>    at org.eclipse.persistence.internal.queries.StatementQueryMechanism.prepareSelectAllRows(StatementQueryMechanism.java:313)
>    at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.prepareSelectAllRows(ExpressionQueryMechanism.java:1552)
>    at org.eclipse.persistence.queries.ReadAllQuery.prepareSelectAllRows(ReadAllQuery.java:849)
>    at org.eclipse.persistence.queries.ReadAllQuery.prepare(ReadAllQuery.java:787)
>    at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:463)
>    at org.eclipse.persistence.queries.ObjectLevelReadQuery.checkPrepare(ObjectLevelReadQuery.java:616)
>    at org.eclipse.persistence.queries.DatabaseQuery.prepareCall(DatabaseQuery.java:1533)
>    at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getDatabaseQuery(EJBQueryImpl.java:449)
>    at org.eclipse.persistence.internal.jpa.EJBQueryImpl.setAsSQLReadQuery(EJBQueryImpl.java:117)
>    at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:503)
>    at nl.reeven.van.astro.db.session.PlanningBean.getAllPlanning(PlanningBean.java:24)
>    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 com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:3161)
>    at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4269)
>    at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:187)
>    ... 86 more
> Caused by: java.lang.ClassNotFoundException: oracle.sql.TIMESTAMP
>    at org.apache.felix.framework.searchpolicy.R4SearchPolicyCore.findClass(R4SearchPolicyCore.java:198)
>    at org.apache.felix.framework.searchpolicy.R4SearchPolicy.findClass(R4SearchPolicy.java:45)
>    at org.apache.felix.framework.searchpolicy.ContentClassLoader.loadClass(ContentClassLoader.java:109)
>    at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
>    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
>    ... 122 more
> Caused by: java.lang.ClassNotFoundException: oracle.sql.TIMESTAMP
>    at org.apache.felix.framework.searchpolicy.R4SearchPolicyCore.findClassOrResource(R4SearchPolicyCore.java:486)
>    at org.apache.felix.framework.searchpolicy.R4SearchPolicyCore.findClass(R4SearchPolicyCore.java:185)
>    ... 126 more
> |#]
>
>
>
> --
>
> People: "If she weighs the same as a Duck, she's made of wood!"
> Sir Bedevere: "And therefore...?"
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>


Back to the top