[
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
