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

Reply via email to