You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@archiva.apache.org by Mick Knutson <mi...@gmail.com> on 2008/01/16 16:57:53 UTC

[archiva 1.0] 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.

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:
http://jira.codehaus.org/browse/CONTINUUM-1622

But it is the same error. I also opened a ticket:

http://jira.codehaus.org/browse/MRM-657

-- 
Thanks,
Mick Knutson

http://www.baselogic.com
http://www.blincmagazine.com
http://www.djmick.com
http://www.myspace.com/mickknutson
http://www.myspace.com/BLiNCMagazine
http://tahoe.baselogic.com
---

Re: [archiva 1.0] 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.

Posted by Olivier34 <ny...@sneakemail.com>.
Hello,

We used to experience the same problem. And we solved it changing some sizes
in 
archiva-base/archiva/model/src/main/mdo/archiva-base.xml
(stash.maxSize="4000")
 
But it seems that a better solution has been posted on the ticket you posted
:
http://jira.codehaus.org/browse/MRM-657

Olivier.


Mick Knutson-4 wrote:
> 
> 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:
> http://jira.codehaus.org/browse/CONTINUUM-1622
> 
> But it is the same error. I also opened a ticket:
> 
> http://jira.codehaus.org/browse/MRM-657
> 
> -- 
> Thanks,
> Mick Knutson
> 
> http://www.baselogic.com
> http://www.blincmagazine.com
> http://www.djmick.com
> http://www.myspace.com/mickknutson
> http://www.myspace.com/BLiNCMagazine
> http://tahoe.baselogic.com
> ---
> 
> 

-- 
View this message in context: http://www.nabble.com/-archiva-1.0--%27ORA-00910%3A-specified-length-too-long-for-its-datatype%27-Error-when-clicking-on-searched-artifact.-tp14886027p16091933.html
Sent from the archiva-users mailing list archive at Nabble.com.