[jira] Updated: (CONTINUUM-697) sizes incompatible with mssql (Patch Attached)
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Teodoro Cue Jr. updated CONTINUUM-697: -- Attachment: CONTINUUM-697.patch Wasn't able to include the other fields. Sorry... :) > sizes incompatible with mssql (Patch Attached) > -- > > Key: CONTINUUM-697 > URL: http://jira.codehaus.org/browse/CONTINUUM-697 > Project: Continuum > Issue Type: Bug > Components: Database >Affects Versions: 1.0.3 > Environment: windows/mssql2000 >Reporter: Brian Fox > Fix For: To Sort > > Attachments: CONTINUUM-697.patch, CONTINUUM-697.patch, > continuum-697.patch > > > This is my configuration: > > javax.jdo.option.ConnectionDriverName > net.sourceforge.jtds.jdbc.Driver > > > javax.jdo.option.ConnectionURL > > jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum > > > javax.jdo.option.ConnectionUserName > continuum > > > javax.jdo.option.ConnectionPassword > continuum > > I get this exception: > 3984 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - An exception was > thrown while adding/validating class(es) : The size (8192) given to the > column 'COMMENT' exceeds the maximum allowed for any data type (8000). > java.sql.SQLException: The size (8192) given to the column 'COMMENT' exceeds > the maximum allowed for any data type (8000). > 4000 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - java.sql.SQLException: > The size (8192) given to the column 'COMMENT' exceeds the maximum allowed for > any data type (8000). -- 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: (CONTINUUM-697) sizes incompatible with mssql (Patch Attached)
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Teodoro Cue Jr. updated CONTINUUM-697: -- Attachment: CONTINUUM-697.patch Here's one solution using ORMs(http://www.jpox.org/docs/1_1/metadata.html#File_Types) in JPOX. The solution would affect all the databases but Brian though can maybe patch a copy of Continuum, build it and use that with MSSQL. :) If we're looking at ORMs as a long term solution, we need to add the property Mapping when using MSSQL databases. So far, I can only see this happening in the code. Test the driver and if it's an MSSQL one, include the property Mapping when creating the PersistenceManager. Any ideas as to how we can add a dynamic entry on application.xml? Such that when a user deploys Continuum with MSSQL, he/she can add the Mapping property. > sizes incompatible with mssql (Patch Attached) > -- > > Key: CONTINUUM-697 > URL: http://jira.codehaus.org/browse/CONTINUUM-697 > Project: Continuum > Issue Type: Bug > Components: Database >Affects Versions: 1.0.3 > Environment: windows/mssql2000 >Reporter: Brian Fox > Fix For: To Sort > > Attachments: CONTINUUM-697.patch, continuum-697.patch > > > This is my configuration: > > javax.jdo.option.ConnectionDriverName > net.sourceforge.jtds.jdbc.Driver > > > javax.jdo.option.ConnectionURL > > jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum > > > javax.jdo.option.ConnectionUserName > continuum > > > javax.jdo.option.ConnectionPassword > continuum > > I get this exception: > 3984 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - An exception was > thrown while adding/validating class(es) : The size (8192) given to the > column 'COMMENT' exceeds the maximum allowed for any data type (8000). > java.sql.SQLException: The size (8192) given to the column 'COMMENT' exceeds > the maximum allowed for any data type (8000). > 4000 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - java.sql.SQLException: > The size (8192) given to the column 'COMMENT' exceeds the maximum allowed for > any data type (8000). -- 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: (CONTINUUM-697) sizes incompatible with mssql (Patch Attached)
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Emmanuel Venisse updated CONTINUUM-697: --- Fix Version/s: (was: 1.1-beta-3) To Sort > sizes incompatible with mssql (Patch Attached) > -- > > Key: CONTINUUM-697 > URL: http://jira.codehaus.org/browse/CONTINUUM-697 > Project: Continuum > Issue Type: Bug > Components: Database >Affects Versions: 1.0.3 > Environment: windows/mssql2000 >Reporter: Brian Fox > Fix For: To Sort > > Attachments: continuum-697.patch > > > This is my configuration: > > javax.jdo.option.ConnectionDriverName > net.sourceforge.jtds.jdbc.Driver > > > javax.jdo.option.ConnectionURL > > jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum > > > javax.jdo.option.ConnectionUserName > continuum > > > javax.jdo.option.ConnectionPassword > continuum > > I get this exception: > 3984 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - An exception was > thrown while adding/validating class(es) : The size (8192) given to the > column 'COMMENT' exceeds the maximum allowed for any data type (8000). > java.sql.SQLException: The size (8192) given to the column 'COMMENT' exceeds > the maximum allowed for any data type (8000). > 4000 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - java.sql.SQLException: > The size (8192) given to the column 'COMMENT' exceeds the maximum allowed for > any data type (8000). -- 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: (CONTINUUM-697) sizes incompatible with mssql (Patch Attached)
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Emmanuel Venisse updated CONTINUUM-697: --- Fix Version/s: (was: 1.1-beta-2) 1.1-beta-3 > sizes incompatible with mssql (Patch Attached) > -- > > Key: CONTINUUM-697 > URL: http://jira.codehaus.org/browse/CONTINUUM-697 > Project: Continuum > Issue Type: Bug > Components: Database >Affects Versions: 1.0.3 > Environment: windows/mssql2000 >Reporter: Brian Fox > Fix For: 1.1-beta-3 > > Attachments: continuum-697.patch > > > This is my configuration: > > javax.jdo.option.ConnectionDriverName > net.sourceforge.jtds.jdbc.Driver > > > javax.jdo.option.ConnectionURL > > jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum > > > javax.jdo.option.ConnectionUserName > continuum > > > javax.jdo.option.ConnectionPassword > continuum > > I get this exception: > 3984 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - An exception was > thrown while adding/validating class(es) : The size (8192) given to the > column 'COMMENT' exceeds the maximum allowed for any data type (8000). > java.sql.SQLException: The size (8192) given to the column 'COMMENT' exceeds > the maximum allowed for any data type (8000). > 4000 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - java.sql.SQLException: > The size (8192) given to the column 'COMMENT' exceeds the maximum allowed for > any data type (8000). -- 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: (CONTINUUM-697) sizes incompatible with mssql (Patch Attached)
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Emmanuel Venisse updated CONTINUUM-697: --- Fix Version/s: (was: 1.1-beta-1) 1.1-beta-2 > sizes incompatible with mssql (Patch Attached) > -- > > Key: CONTINUUM-697 > URL: http://jira.codehaus.org/browse/CONTINUUM-697 > Project: Continuum > Issue Type: Bug > Components: Database >Affects Versions: 1.0.3 > Environment: windows/mssql2000 >Reporter: Brian Fox > Fix For: 1.1-beta-2 > > Attachments: continuum-697.patch > > > This is my configuration: > > javax.jdo.option.ConnectionDriverName > net.sourceforge.jtds.jdbc.Driver > > > javax.jdo.option.ConnectionURL > > jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum > > > javax.jdo.option.ConnectionUserName > continuum > > > javax.jdo.option.ConnectionPassword > continuum > > I get this exception: > 3984 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - An exception was > thrown while adding/validating class(es) : The size (8192) given to the > column 'COMMENT' exceeds the maximum allowed for any data type (8000). > java.sql.SQLException: The size (8192) given to the column 'COMMENT' exceeds > the maximum allowed for any data type (8000). > 4000 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - java.sql.SQLException: > The size (8192) given to the column 'COMMENT' exceeds the maximum allowed for > any data type (8000). -- 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: (CONTINUUM-697) sizes incompatible with mssql (Patch Attached)
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesse McConnell updated CONTINUUM-697: -- Fix Version/s: (was: 1.1-alpha-1) 1.1-alpha-2 I don't think we want to solve this with this kinda approach, as noted on the mailing list we are probably better off trying to either store this as some kinda BLOB/CLOB deal, or just write out to disk like brett was thinking. unless this is critical, I am going to move it out to the next alpha for now > sizes incompatible with mssql (Patch Attached) > -- > > Key: CONTINUUM-697 > URL: http://jira.codehaus.org/browse/CONTINUUM-697 > Project: Continuum > Issue Type: Bug > Components: Database >Affects Versions: 1.0.3 > Environment: windows/mssql2000 >Reporter: Brian Fox > Fix For: 1.1-alpha-2 > > Attachments: continuum-697.patch > > > This is my configuration: > > javax.jdo.option.ConnectionDriverName > net.sourceforge.jtds.jdbc.Driver > > > javax.jdo.option.ConnectionURL > > jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum > > > javax.jdo.option.ConnectionUserName > continuum > > > javax.jdo.option.ConnectionPassword > continuum > > I get this exception: > 3984 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - An exception was > thrown while adding/validating class(es) : The size (8192) given to the > column 'COMMENT' exceeds the maximum allowed for any data type (8000). > java.sql.SQLException: The size (8192) given to the column 'COMMENT' exceeds > the maximum allowed for any data type (8000). > 4000 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - java.sql.SQLException: > The size (8192) given to the column 'COMMENT' exceeds the maximum allowed for > any data type (8000). -- 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: (CONTINUUM-697) sizes incompatible with mssql (Patch Attached)
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesse McConnell updated CONTINUUM-697: -- Fix Version/s: 1.1-alpha-1 > sizes incompatible with mssql (Patch Attached) > -- > > Key: CONTINUUM-697 > URL: http://jira.codehaus.org/browse/CONTINUUM-697 > Project: Continuum > Issue Type: Bug > Components: Database >Affects Versions: 1.0.3 > Environment: windows/mssql2000 >Reporter: Brian Fox > Fix For: 1.1-alpha-1 > > Attachments: continuum-697.patch > > > This is my configuration: > > javax.jdo.option.ConnectionDriverName > net.sourceforge.jtds.jdbc.Driver > > > javax.jdo.option.ConnectionURL > > jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum > > > javax.jdo.option.ConnectionUserName > continuum > > > javax.jdo.option.ConnectionPassword > continuum > > I get this exception: > 3984 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - An exception was > thrown while adding/validating class(es) : The size (8192) given to the > column 'COMMENT' exceeds the maximum allowed for any data type (8000). > java.sql.SQLException: The size (8192) given to the column 'COMMENT' exceeds > the maximum allowed for any data type (8000). > 4000 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - java.sql.SQLException: > The size (8192) given to the column 'COMMENT' exceeds the maximum allowed for > any data type (8000). -- 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: (CONTINUUM-697) sizes incompatible with mssql (Patch Attached)
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=all ] Brian Fox updated CONTINUUM-697: Summary: sizes incompatible with mssql (Patch Attached) (was: sizes incompatible with mssql) Patch attached: Yes > sizes incompatible with mssql (Patch Attached) > -- > > Key: CONTINUUM-697 > URL: http://jira.codehaus.org/browse/CONTINUUM-697 > Project: Continuum > Issue Type: Bug > Components: Database >Affects Versions: 1.0.3 > Environment: windows/mssql2000 >Reporter: Brian Fox > Attachments: continuum-697.patch > > > This is my configuration: > > javax.jdo.option.ConnectionDriverName > net.sourceforge.jtds.jdbc.Driver > > > javax.jdo.option.ConnectionURL > > jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum > > > javax.jdo.option.ConnectionUserName > continuum > > > javax.jdo.option.ConnectionPassword > continuum > > I get this exception: > 3984 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - An exception was > thrown while adding/validating class(es) : The size (8192) given to the > column 'COMMENT' exceeds the maximum allowed for any data type (8000). > java.sql.SQLException: The size (8192) given to the column 'COMMENT' exceeds > the maximum allowed for any data type (8000). > 4000 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA - java.sql.SQLException: > The size (8192) given to the column 'COMMENT' exceeds the maximum allowed for > any data type (8000). -- 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
