You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@maven.apache.org by "Brian Fox (JIRA)" <ji...@codehaus.org> on 2006/05/13 16:33:41 UTC
[jira] Created: (CONTINUUM-697) sizes incompatible with mssql
sizes incompatible with mssql
-----------------------------
Key: CONTINUUM-697
URL: http://jira.codehaus.org/browse/CONTINUUM-697
Project: Continuum
Type: Bug
Versions: 1.0.3
Environment: windows/mssql2000
Reporter: Brian Fox
This is my configuration:
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>net.sourceforge.jtds.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>continuum</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>continuum</value>
</property>
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)
Posted by "Brian Fox (JIRA)" <ji...@codehaus.org>.
[ 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:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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)
Posted by "Jesse McConnell (JIRA)" <ji...@codehaus.org>.
[ 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:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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
Posted by "Brian Fox (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=all ]
Brian Fox updated CONTINUUM-697:
--------------------------------
Attachment: continuum-697.patch
Attaching Patch file. To make this work on sql server 2005 the max sizes just need to be decreased from 8192 to 8000.
> sizes incompatible with mssql
> -----------------------------
>
> 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:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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)
Posted by "Emmanuel Venisse (JIRA)" <ji...@codehaus.org>.
[ 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:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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] Commented: (CONTINUUM-697) sizes incompatible with mssql
(Patch Attached)
Posted by "Thomas Marti (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_107804 ]
Thomas Marti commented on CONTINUUM-697:
----------------------------------------
Oracle has exactly the same problem except that the maximum length is 4000. Using CLOB here seems like a more universal solution. Not?
> 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
> Assignee: Emmanuel Venisse
> Fix For: 1.1-beta-3
>
> Attachments: CONTINUUM-697.patch, CONTINUUM-697.patch, continuum-697.patch
>
>
> This is my configuration:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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)
Posted by "Emmanuel Venisse (JIRA)" <ji...@codehaus.org>.
[ 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:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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
Posted by "Emmanuel Venisse (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=all ]
Emmanuel Venisse updated CONTINUUM-697:
---------------------------------------
Component: Database
> sizes incompatible with mssql
> -----------------------------
>
> Key: CONTINUUM-697
> URL: http://jira.codehaus.org/browse/CONTINUUM-697
> Project: Continuum
> Type: Bug
> Components: Database
> Versions: 1.0.3
> Environment: windows/mssql2000
> Reporter: Brian Fox
>
>
> This is my configuration:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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)
Posted by "Emmanuel Venisse (JIRA)" <ji...@codehaus.org>.
[ 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:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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)
Posted by "Jesse McConnell (JIRA)" <ji...@codehaus.org>.
[ 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:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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)
Posted by "Teodoro Cue Jr. (JIRA)" <ji...@codehaus.org>.
[ 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:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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)
Posted by "Teodoro Cue Jr. (JIRA)" <ji...@codehaus.org>.
[ 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:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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] Closed: (CONTINUUM-697) sizes incompatible with mssql (Patch
Attached)
Posted by "Emmanuel Venisse (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Emmanuel Venisse closed CONTINUUM-697.
--------------------------------------
Assignee: Emmanuel Venisse
Resolution: Fixed
Fix Version/s: (was: To Sort)
1.1-beta-3
Thanks Teodoro, I applied your patch.
The mapping property in application.xml must be uncommented to use Continuum with mssql
> 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
> Assignee: Emmanuel Venisse
> Fix For: 1.1-beta-3
>
> Attachments: CONTINUUM-697.patch, CONTINUUM-697.patch, continuum-697.patch
>
>
> This is my configuration:
> <property>
> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>net.sourceforge.jtds.jdbc.Driver</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:jtds:sqlserver://cordella.mht.stchome.com:1433/continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionUserName</name>
> <value>continuum</value>
> </property>
> <property>
> <name>javax.jdo.option.ConnectionPassword</name>
> <value>continuum</value>
> </property>
> 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