You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@airavata.apache.org by "Marcus Christie (JIRA)" <ji...@apache.org> on 2018/06/04 13:34:00 UTC
[jira] [Commented] (AIRAVATA-2799) getGatewayResourceProfile error:
Out of range value for column 'GATEWAY_APPROVAL_STATUS' : value APPROVED is
not in Short range
[ https://issues.apache.org/jira/browse/AIRAVATA-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16500215#comment-16500215 ]
Marcus Christie commented on AIRAVATA-2799:
-------------------------------------------
openjpa is trying to convert the string value from the database column to an ordinal value for the enum. Looks like the fix would be a JPA annotation to let it know to convert the enum as a string instead:
{code:java}
@Column(name = "GATEWAY_APPROVAL_STATUS")
@Enumerated(EnumType.STRING)
private GatewayApprovalStatus gatewayApprovalStatus;
{code}
[@Enumerated docs|https://docs.oracle.com/javaee/5/api/javax/persistence/Enumerated.html]
> getGatewayResourceProfile error: Out of range value for column 'GATEWAY_APPROVAL_STATUS' : value APPROVED is not in Short range
> -------------------------------------------------------------------------------------------------------------------------------
>
> Key: AIRAVATA-2799
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2799
> Project: Airavata
> Issue Type: Bug
> Reporter: Marcus Christie
> Assignee: Marcus Christie
> Priority: Major
>
> Stacktrace:
> {noformat}
> 2018-06-04 13:14:08,400 [pool-10-thread-3] ERROR o.a.a.r.a.s.h.RegistryServerHandler - seagrid
> org.apache.openjpa.persistence.PersistenceException: Out of range value for column 'GATEWAY_APPROVAL_STATUS' : value APPROVED is not in Short range
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4918)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:86)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:309)
> at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:112)
> at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)
> at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1036)
> at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:994)
> at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:911)
> at org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:231)
> at org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:487)
> at org.apache.airavata.registry.core.repositories.expcatalog.ExpCatAbstractRepository.lambda$get$2(ExpCatAbstractRepository.java:50)
> at org.apache.airavata.registry.core.repositories.expcatalog.ExpCatAbstractRepository.execute(ExpCatAbstractRepository.java:99)
> at org.apache.airavata.registry.core.repositories.expcatalog.ExpCatAbstractRepository.get(ExpCatAbstractRepository.java:49)
> at org.apache.airavata.registry.core.repositories.expcatalog.ExpCatAbstractRepository.isExists(ExpCatAbstractRepository.java:87)
> at org.apache.airavata.registry.core.repositories.expcatalog.GatewayRepository.isGatewayExist(GatewayRepository.java:99)
> at org.apache.airavata.registry.api.service.handler.RegistryServerHandler.isGatewayExistInternal(RegistryServerHandler.java:4165)
> at org.apache.airavata.registry.api.service.handler.RegistryServerHandler.getGatewayResourceProfile(RegistryServerHandler.java:1966)
> at org.apache.airavata.registry.api.RegistryService$Processor$getGatewayResourceProfile.getResult(RegistryService.java:17713)
> at org.apache.airavata.registry.api.RegistryService$Processor$getGatewayResourceProfile.getResult(RegistryService.java:17697)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
> at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: java.sql.SQLException: Out of range value for column 'GATEWAY_APPROVAL_STATUS' : value APPROVED is not in Short range
> at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.parseShort(SelectResultSet.java:3433)
> at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getInternalShort(SelectResultSet.java:3146)
> at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getShort(SelectResultSet.java:3125)
> at org.apache.commons.dbcp.DelegatingResultSet.getShort(DelegatingResultSet.java:222)
> at org.apache.commons.dbcp.DelegatingResultSet.getShort(DelegatingResultSet.java:222)
> at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getShort(DelegatingResultSet.java:133)
> at org.apache.openjpa.jdbc.sql.DBDictionary.getShort(DBDictionary.java:877)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.getShortInternal(ResultSetResult.java:466)
> at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:397)
> at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
> at org.apache.openjpa.jdbc.meta.strats.HandlerStrategies.loadDataStore(HandlerStrategies.java:222)
> at org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.load(HandlerFieldStrategy.java:187)
> at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:928)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1094)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1038)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:409)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:304)
> ... 22 common frames omitted
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)