You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by "Alex O'Ree (JIRA)" <ju...@ws.apache.org> on 2014/10/25 13:49:33 UTC
[jira] [Comment Edited] (JUDDI-870) ORA-00910: specified length too
long for its datatype in openjpa
[ https://issues.apache.org/jira/browse/JUDDI-870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14000757#comment-14000757 ]
Alex O'Ree edited comment on JUDDI-870 at 10/25/14 11:48 AM:
-------------------------------------------------------------
http://stackoverflow.com/questions/3804441/how-to-generate-orm-xml-mapping-files-from-annotations
that has some hints, but the URLs are broken. We already generate database ddl files using the hibernate tool at build time (see juddi-ddl-generator)
According to that stackoverflow link, there's an openjpa tool which might do the rest of the work.
Basically, we need to generate an accurate orm file from code. Once we have that, then we can document what changes need to made to the orm file for oracle users.
The only deadline is your own.
If this doesn't pan out, we'll have to go the code route, convert the long fields to byte[] and refactor
was (Author: spyhunter99):
http://stackoverflow.com/questions/3804441/how-to-generate-orm-xml-mapping-files-from-annotations
that has some hints, but the URLs are broken. We already generate database ddl files using the hibernate tool at build time (see juddi-ddl-generator)
According to that stackoverflow link, there's an openjpa tool which might do the rest of the work.
Basically, we need to generate and accurate orm file from code. Once we have that, then we can document what changes need to made to the orm file for oracle users.
The only deadline is your own.
If this doesn't pan out, we'll have to go the code route, convert the long fields to byte[] and refactor
> ORA-00910: specified length too long for its datatype in openjpa
> ----------------------------------------------------------------
>
> Key: JUDDI-870
> URL: https://issues.apache.org/jira/browse/JUDDI-870
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 3.2
> Environment: Wildfly 8, openjpa, oracle 11g
> Reporter: Dima
> Assignee: Kurt T Stam
> Fix For: 3.2.1
>
>
> ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 52) MSC000001: Failed to start service jboss.persistenceunit."juddiv3.war#juddiDatabase": org.jboss.msc.service.StartException in service jboss.persistenceunit."juddiv3.war#juddiDatabase": <openjpa-2.2.1-r422266:1396819 fatal user error> org.apache.openjpa.persistence.ArgumentException: Could not invoke the static newInstance method on the named factory class "org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory".
> at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:172) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:117) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
> at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.7.0_40]
> at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:474)
> at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:182) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_40]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_40]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_40]
> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> Caused by: <openjpa-2.2.1-r422266:1396819 fatal user error> org.apache.openjpa.persistence.ArgumentException: Could not invoke the static newInstance method on the named factory class "org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory".
> at org.apache.openjpa.kernel.Bootstrap.newBrokerFactory(Bootstrap.java:76) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.persistence.PersistenceProviderImpl.getBrokerFactory(PersistenceProviderImpl.java:147) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.persistence.PersistenceProviderImpl.createContainerEntityManagerFactory(PersistenceProviderImpl.java:187) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.persistence.PersistenceProviderImpl.createContainerEntityManagerFactory(PersistenceProviderImpl.java:62) [openjpa-2.2.1.jar:2.2.1]
> at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:318) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.access$1100(PersistenceUnitServiceImpl.java:67) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:167) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
> ... 8 more
> Caused by: <openjpa-2.2.1-r422266:1396819 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-00910: заданная длина слишком велика для этого типа данных
> {stmnt 623393304 CREATE TABLE SIRIUS_UDDI.j3_binding_template (entity_key VARCHAR2(255) NOT NULL, access_point_type VARCHAR2(255), access_point_url VARCHAR2(4096), hosting_redirector VARCHAR2(255), service_key VARCHAR2(255) NOT NULL, PRIMARY KEY (entity_key))} [code=910, state=42000]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:559) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:455) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:209) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:185) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.AbstractBrokerFactory.postCreationCallback(AbstractBrokerFactory.java:860) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.postCreationCallback(JDBCBrokerFactory.java:105) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.Bootstrap.newBrokerFactory(Bootstrap.java:67) [openjpa-2.2.1.jar:2.2.1]
> ... 14 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00910: заданная длина слишком велика для этого типа данных
> {stmnt 623393304 CREATE TABLE SIRIUS_UDDI.j3_binding_template (entity_key VARCHAR2(255) NOT NULL, access_point_type VARCHAR2(255), access_point_url VARCHAR2(4096), hosting_redirector VARCHAR2(255), service_key VARCHAR2(255) NOT NULL, PRIMARY KEY (entity_key))} [code=910, state=42000]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:914) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:114) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1224) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:975) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:551) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:366) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:343) [openjpa-2.2.1.jar:2.2.1]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:505) [openjpa-2.2.1.jar:2.2.1]
> ... 23 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)