Forums

by Anonymous >> Thu, 3 May 2007 15:44:09 GMT

I have a virtual reference and I am trying to map it to an external SQL 2000 database which is currently defined as text (16). The data can be very large string.

I am not understanding the use of a mapping method.
How do I update a SQL table with a virtual reference from JADE?

I am already updating other columns in the table so ODBC connectivity has been established.
Can you shed some light on this.

by ElbowRoom >> Fri, 4 May 2007 3:57:17 GMT

I have a virtual reference and I am trying to map it to an external SQL 2000 database which is currently defined as text (16). The data can be very large string.

What JADE facility are you using here, is it RPS or 'External Database' connectivity? SQL Server text columns don't have a length specifier, did you really mean char(16)?

The default RPS mapping for an object reference is a char(16) column that will contain the OID value of the reference formatted as a string.

I am not understanding the use of a mapping method. How do I update a SQL table with a virtual reference from JADE?

In the 6.1 release you can map condition-safe virtual properties to table columns in the target relational schema.

The fact you are attempting to map a virtual reference suggests there is some level of indirection between a parent object and container for the unbounded string property. Can you please clarify how your string data is represented and stored in the Jade model?

by Umenso >> Fri, 4 May 2007 14:37:58 GMT

I'm using External Database Connectivity, JADE 6.027, and SQL Server 2000. The SQL column is text, not char or varchar. The string data in JADE is defined as String Maximum Length.

I'm finding that if the value is keyed in manually, there does not appear to be a problem. If I cut and paste the value in from some text file, no value is passed and the column appears to be locked in SQL Server.

How can I determine how JADE interprets a cut and paste vs data that is keyed in manually? I have converted the JadeRichText control I was using to a standard text box control to try to avoid formatting issues but I'm still having the same problem.

Thanks in advance for your help.