Hi,
I'm trying my first lcds app using jrun and sqlAssembler. I'm getting
the following error:
Configuration error encountered on line 61, column 14: 'XML document
structures must start and end within the same entity.'
contacts_ol Unknown 1186162106978 87
I've checked the validation for the data-management-config file:
<?xml version="1.0" encoding="UTF-8"?>
<service id="data-service"
class="flex.data.DataService">
<adapters>
<adapter-definition id="actionscript"
class="flex.data.adapters.ASObjectAdapter" default="true"/>
<adapter-definition id="java-dao"
class="flex.data.adapters.JavaAdapter"/>
</adapters>
<default-channels>
<channel ref="my-rtmp"/>
</default-channels>
<destination id="sql-contact">
<adapter ref="java-dao"/>
<properties>
<source>flex.data.assemblers.SQLAssembler</source>
<scope>application</scope>
<metadata>
<identity property="id"/>
</metadata>
<network>
<subscription-timeout-minutes>20</
subscription-timeout-minutes>
<pageing enabled="false" pagesize="30"/>
<throttle-inbound policy="ERROR" max-
frequency="500"/>
<throttle-outbound policy="REPLACE" max-
frequency="500"/>
</network>
<server>
<database>
<driver-class>com.mysql.jdbc.Driver</driver-
class>
<url>C:/wamp/bin/mysql/mysql5.0.51b/data/
Contacts</url>
<username>jd</username>
<password>magewind</password>
<login-timeout>20</login-timeout>
</database>
<actionscript-
class>valueObjects.ContactVO<actionscript-class>
<fill>
<name>all</all>
<sql>SELECT * FROM contacts ORDER BY lName</
sql>
</fill>
<create-item>
<sql> INSERT INTO contacts(fName, lName, mI,
title, address, city, state, country, zip, phoneMobile, phoneOffice,
phoneHome, phoneFax=, email, site, company, contactFreq, lastContact,
birthday, sharedIterest, sharedContacts, category)
VALUES(#fName#, #lName#, #mI#, #title#, #address#, #city#, #state#,
#country#, #zip#, #phoneMobile#, #phoneOffice#, #phoneHome,
#phoneFax#, #email#, #site#, #company#, #contactFreq#, #lastContact#,
#birthday#, #sharedIterest#, #sharedContacts#, #category#)
</sql>
</create-item>
<update-item>
<sql>UPDATE contacts SET
fName=#fName#, lName=#lName#, mI=#mI#, title=#title#,
address=#address#, city=#city#, state=#state#, country=#country#,
zip=#zip#, phoneMobile=#phoneMobile#,
phoneOffice=#phoneOffice#, phoneHome=#phoneHome#,
phoneFax=#phoneFax#, email=#email#,
site=#site#, company=#company#, contactFreq=#contactFreq#,
lastContact=#lastContact#, birthday=#birthday#,
sharedIterest=#sharedIterest#,
sharedContacts=#sharedContacts#, category=#category# WHERE id
= PREV.#ID#
</sql>
</update-item>
<delete-item>
<sql>DELETE FROM contacts WHERE id=#id#</sql>
</delete-item>
<count>
<name>all</name>
<sql>SELECT count(*) FROM contacts</sql>
</count>
</server>
</properties>
</destination>
</service>
I know I'm doing something stupid here but I can't many complete
destination examples that would show me the problem
Thanks, JD