You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@archiva.apache.org by "Marc Lustig (JIRA)" <ji...@codehaus.org> on 2009/06/04 12:06:42 UTC
[jira] Created: (MRM-1198) field length for ARCHIVA_SCM.URL is too
short
field length for ARCHIVA_SCM.URL is too short
---------------------------------------------
Key: MRM-1198
URL: http://jira.codehaus.org/browse/MRM-1198
Project: Archiva
Issue Type: Bug
Components: repository scanning
Affects Versions: 1.2.1
Environment: Oracle RAC
Reporter: Marc Lustig
java.sql.SQLException: ORA-12899: value too large for column "CONTINUUM_12"."ARCHIVA_SCM"."URL" (actual: 267, maximum: 250)
I propose to change the field length to 1020.
--
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] Assigned: (MRM-1198) field length for ARCHIVA_SCM.URL is too
short
Posted by "Maria Odea Ching (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-1198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maria Odea Ching reassigned MRM-1198:
-------------------------------------
Assignee: Maria Odea Ching
> field length for ARCHIVA_SCM.URL is too short
> ---------------------------------------------
>
> Key: MRM-1198
> URL: http://jira.codehaus.org/browse/MRM-1198
> Project: Archiva
> Issue Type: Bug
> Components: repository scanning
> Affects Versions: 1.2.1
> Environment: Oracle RAC
> Reporter: Marc Lustig
> Assignee: Maria Odea Ching
> Fix For: 1.2.2
>
>
> java.sql.SQLException: ORA-12899: value too large for column "CONTINUUM_12"."ARCHIVA_SCM"."URL" (actual: 267, maximum: 250)
> I propose to change the field length to 1020.
--
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-1198) field length for ARCHIVA_SCM.URL is
too short
Posted by "Maria Odea Ching (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-1198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=185066#action_185066 ]
Maria Odea Ching commented on MRM-1198:
---------------------------------------
Related discussion from the dev list:
http://www.nabble.com/JDO-error-on-startup-td24142815.html
Changing the jdbc-type from VARCHAR2 to VARCHAR fixes the startup error posted above.
> field length for ARCHIVA_SCM.URL is too short
> ---------------------------------------------
>
> Key: MRM-1198
> URL: http://jira.codehaus.org/browse/MRM-1198
> Project: Archiva
> Issue Type: Bug
> Components: repository scanning
> Affects Versions: 1.2.1
> Environment: Oracle RAC
> Reporter: Marc Lustig
> Fix For: 1.2.2
>
>
> java.sql.SQLException: ORA-12899: value too large for column "CONTINUUM_12"."ARCHIVA_SCM"."URL" (actual: 267, maximum: 250)
> I propose to change the field length to 1020.
--
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-1198) field length for ARCHIVA_SCM.URL is too
short
Posted by "Maria Odea Ching (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-1198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maria Odea Ching updated MRM-1198:
----------------------------------
Fix Version/s: 1.2.2
> field length for ARCHIVA_SCM.URL is too short
> ---------------------------------------------
>
> Key: MRM-1198
> URL: http://jira.codehaus.org/browse/MRM-1198
> Project: Archiva
> Issue Type: Bug
> Components: repository scanning
> Affects Versions: 1.2.1
> Environment: Oracle RAC
> Reporter: Marc Lustig
> Fix For: 1.2.2
>
>
> java.sql.SQLException: ORA-12899: value too large for column "CONTINUUM_12"."ARCHIVA_SCM"."URL" (actual: 267, maximum: 250)
> I propose to change the field length to 1020.
--
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] Closed: (MRM-1198) field length for ARCHIVA_SCM.URL is too
short
Posted by "Maria Odea Ching (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-1198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maria Odea Ching closed MRM-1198.
---------------------------------
Resolution: Fixed
Field lengths of url fields are adjusted to 1020 in trunk -r798424.
> field length for ARCHIVA_SCM.URL is too short
> ---------------------------------------------
>
> Key: MRM-1198
> URL: http://jira.codehaus.org/browse/MRM-1198
> Project: Archiva
> Issue Type: Bug
> Components: repository scanning
> Affects Versions: 1.2.1
> Environment: Oracle RAC
> Reporter: Marc Lustig
> Assignee: Maria Odea Ching
> Fix For: 1.2.2
>
>
> java.sql.SQLException: ORA-12899: value too large for column "CONTINUUM_12"."ARCHIVA_SCM"."URL" (actual: 267, maximum: 250)
> I propose to change the field length to 1020.
--
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-1198) field length for ARCHIVA_SCM.URL is
too short
Posted by "Marc Lustig (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/MRM-1198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=181594#action_181594 ]
Marc Lustig commented on MRM-1198:
----------------------------------
We tried fxing this by changing the JDO-schema for Oracle:
For all fields "url" as well as "issueManagementUrl" and "connection" we changed as follows
<field name="url">
<column length="2500" jdbc-type="VARCHAR2"/>
</field>
As a result we got the following error on startup:
[ContainerBackgroundProcessor[StandardEngine[Catalina]]] ERROR JPOX.MetaData
- The following error occurred while parsing <column> nested within
<field name="url"
null-value="none">
</field>
Reverting the fields which are primary keys back to the original configuration did not help. Same error.
Only reverting ALL fields back to the original state caused the webapp to startup again.
IMO, it should be possible to change the jdbc-type to any db-specific character-field without compaints from the JDO-impl.
Furthermore, for certain fields, this is not only of "cosmetic" value, it is a functional necessity, as the URL's often surpass 250 chars.
> field length for ARCHIVA_SCM.URL is too short
> ---------------------------------------------
>
> Key: MRM-1198
> URL: http://jira.codehaus.org/browse/MRM-1198
> Project: Archiva
> Issue Type: Bug
> Components: repository scanning
> Affects Versions: 1.2.1
> Environment: Oracle RAC
> Reporter: Marc Lustig
> Fix For: 1.2.2
>
>
> java.sql.SQLException: ORA-12899: value too large for column "CONTINUUM_12"."ARCHIVA_SCM"."URL" (actual: 267, maximum: 250)
> I propose to change the field length to 1020.
--
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