Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.0.3
-
Fix Version/s: 1.1-beta-3
-
Component/s: Database
-
Labels:None
-
Environment:windows/mssql2000
-
Complexity:Intermediate
-
Number of attachments :
Description
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).
Attachments
Activity
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.
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.
Attaching Patch file. To make this work on sql server 2005 the max sizes just need to be decreased from 8192 to 8000.