You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@archiva.apache.org by "Mick Knutson (JIRA)" <ji...@codehaus.org> on 2008/01/16 16:57:57 UTC
[jira] Created: (MRM-657) 'ORA-00910: specified length too long for
its datatype' Error when clicking on searched artifact.
'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
-------------------------------------------------------------------------------------------------
Key: MRM-657
URL: http://jira.codehaus.org/browse/MRM-657
Project: Archiva
Issue Type: Bug
Affects Versions: 1.0
Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
Reporter: Mick Knutson
When I do a search for an artifact, then I get the results, I then get this error:
javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
java.sql.SQLException: ORA-00910: specified length too long for its datatype
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
Now this does not come up like with continuum (at start up):
http://jira.codehaus.org/browse/CONTINUUM-1622
So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (MRM-657) 'ORA-00910: specified length too long for
its datatype' Error when clicking on searched artifact.
Posted by "Brett Porter (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brett Porter updated MRM-657:
-----------------------------
Fix Version/s: (was: 1.0.2)
1.0.x
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.0.x
>
> Attachments: archiva-base.xml-patched, package-oracle.orm
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (MRM-657) 'ORA-00910: specified length too long for
its datatype' Error when clicking on searched artifact.
Posted by "Brett Porter (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brett Porter updated MRM-657:
-----------------------------
Fix Version/s: (was: 1.1)
1.0.2
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.0.2
>
> Attachments: archiva-base.xml-patched, package-oracle.orm
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (MRM-657) 'ORA-00910: specified length too long
for its datatype' Error when clicking on searched artifact.
Posted by "Aaron Hamid (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=148390#action_148390 ]
Aaron Hamid commented on MRM-657:
---------------------------------
Attempting a partial db-dependent override via package-oracle.orm and package-oracle.jdo did not work for me. I had to edit and replace the main package.jdo (by placing the override in classes/).
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.1.x
>
> Attachments: archiva-base.xml-patched, package-oracle.orm
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (MRM-657) 'ORA-00910: specified length too long
for its datatype' Error when clicking on searched artifact.
Posted by "arno koehler (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=133532#action_133532 ]
arno koehler commented on MRM-657:
----------------------------------
I see the same error in my log files.
The setup I am using is Archiva.WAR on JBoss in combination with Oracle.
The solution Gunther presents is a bit difficult for me, because in the WAR there is (off course) no application.xml and I would not know what to do with this now.
I tried to add
<property>
<name>javax.jdo.option.Mapping</name>
<value>oracle</value>
</property>
to my web.xml but it doens't fix the problem.
What is wrong?
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.0.x
>
> Attachments: archiva-base.xml-patched, package-oracle.orm
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (MRM-657) 'ORA-00910: specified length too long
for its datatype' Error when clicking on searched artifact.
Posted by "Aaron Hamid (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=148384#action_148384 ]
Aaron Hamid commented on MRM-657:
---------------------------------
This error occurs for me if I hit the Reports button. Any update on this issue? I'm not sure where to find the original files to modify (other than application.xml, where I added the javax.jdo.option.Mapping, but it didn't appear to help...maybe I need to start fresh with this option?). I'd rather not limit the column size, but instead set them to CLOB so they can support the requirements.
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.1.x
>
> Attachments: archiva-base.xml-patched, package-oracle.orm
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (MRM-657) 'ORA-00910: specified length too long
for its datatype' Error when clicking on searched artifact.
Posted by "Gunther Van den Bosch (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_126122 ]
Gunther Van den Bosch commented on MRM-657:
-------------------------------------------
This could be solved by adapting the JDO mapping for Oracle. Oracle supports only VARCHAR types with a maximum length of 4000. The standard implementation of archiva sometimes uses fields which are longer.
I have attached the package-oracle.orm file which should be included in the archiva-model-1.0.1.jar next to the package.jdo
Using the Oracle mapping can be activated by setting the mapping property in the application.xml for the Jdofactory component
<property>
<name>javax.jdo.option.Mapping</name>
<value>oracle</value>
</property>
I hope this helps
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.1
>
> Attachments: package-oracle.orm
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (MRM-657) 'ORA-00910: specified length too long
for its datatype' Error when clicking on searched artifact.
Posted by "Olivier Dassaud (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_127445 ]
Olivier Dassaud commented on MRM-657:
-------------------------------------
Hello,
We used to experience the same problem.
We solved it changing some sizes in :
archiva-base/archiva/model/src/main/mdo/archiva-base.xml (stash.maxSize="4000")
FYI the new file is attached to that ticket.
But it looks that Gunther proposal is smarter.
Olivier.
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.1
>
> Attachments: archiva-base.xml-patched, package-oracle.orm
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (MRM-657) 'ORA-00910: specified length too long for
its datatype' Error when clicking on searched artifact.
Posted by "Maria Odea Ching (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maria Odea Ching updated MRM-657:
---------------------------------
Fix Version/s: 1.1
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.1
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (MRM-657) 'ORA-00910: specified length too long for
its datatype' Error when clicking on searched artifact.
Posted by "Olivier Dassaud (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Olivier Dassaud updated MRM-657:
--------------------------------
Attachment: archiva-base.xml-patched
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.1
>
> Attachments: archiva-base.xml-patched, package-oracle.orm
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (MRM-657) 'ORA-00910: specified length too long for
its datatype' Error when clicking on searched artifact.
Posted by "Gunther Van den Bosch (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gunther Van den Bosch updated MRM-657:
--------------------------------------
Attachment: package-oracle.orm
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.1
>
> Attachments: package-oracle.orm
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Issue Comment Edited: (MRM-657) 'ORA-00910: specified length
too long for its datatype' Error when clicking on searched artifact.
Posted by "arno koehler (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=133532#action_133532 ]
intrix edited comment on MRM-657 at 5/5/08 7:11 AM:
----------------------------------------------------------
I see the same error in my log files.
The setup I am using is Archiva.WAR on JBoss in combination with Oracle.
The solution Gunther presents is a bit difficult for me, because in the WAR there is (off course) no application.xml and I would not know what to do with this now.
I tried to add
<property>
<name>javax.jdo.option.Mapping</name>
<value>oracle</value>
</property>
to my web.xml but it doens't fix the problem.
What can I do to fix my problem?
was (Author: intrix):
I see the same error in my log files.
The setup I am using is Archiva.WAR on JBoss in combination with Oracle.
The solution Gunther presents is a bit difficult for me, because in the WAR there is (off course) no application.xml and I would not know what to do with this now.
I tried to add
<property>
<name>javax.jdo.option.Mapping</name>
<value>oracle</value>
</property>
to my web.xml but it doens't fix the problem.
What is wrong?
> 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.
> -------------------------------------------------------------------------------------------------
>
> Key: MRM-657
> URL: http://jira.codehaus.org/browse/MRM-657
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.0
> Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
> Reporter: Mick Knutson
> Fix For: 1.0.x
>
> Attachments: archiva-base.xml-patched, package-oracle.orm
>
>
> When I do a search for an artifact, then I get the results, I then get this error:
> javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype
> java.sql.SQLException: ORA-00910: specified length too long for its datatype
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
> at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
> at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
> at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
> at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
> at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
> at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)
> Now this does not come up like with continuum (at start up):
> http://jira.codehaus.org/browse/CONTINUUM-1622
> So Archiva runs, but not when I try to search.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira