[ 
https://issues.apache.org/jira/browse/JUDDI-870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14000757#comment-14000757
 ] 

Alex O'Ree commented on JUDDI-870:
----------------------------------

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.2#6252)

Reply via email to