juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex O'Ree (JIRA)" <juddi-...@ws.apache.org>
Subject [jira] [Commented] (JUDDI-870) ORA-00910: specified length too long for its datatype in openjpa
Date Sat, 17 May 2014 12:07:15 GMT

    [ 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)

Mime
View raw message