<xsd:attribute> & <xsd:sequence> mutually exclusive???

[Mimi Tam]

Can anyone tell me how to straighten this out, please?

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="message">
	<xs:complexType>
		<xs:attribute name="id" type="xs:string" use="required"/>
[color=red]<xs:sequence minOccurs="0" maxOccurs="unbounded">[/color] 
      		<xs:element name="message" type="xs:string"/>
      		<xs:element name="name" type="xs:string"/>
      		<xs:element name="type" type="xs:string"/>
      		<xs:element name="consumer" type="xs:string"/>
    	</xs:sequence>     	
  	</xs:complexType>
</xs:element>
</xs:schema

>

Error is on the <xs: sequence> line.

In my XML:

	<!--  client to server (upload info) -->
	<message id='msg_id'> 
		<name>POST</name>
		<type>UPDATE</type>  <!-- Request to update customer -->		
		<consumer id='113'>  <!-- unique Id -->
		          <Hours_used>23</Hours_used>  
		</consumer>dd	</message>

The error message:

"s4s-elt-invalid-content.1: The content of '@AnonType_message' is invalid. Element 'sequence' is invalid, misplaced, or occurs too often"

Thanks very much in advance.

[Paul Clapham]

There's a forum for XML. And the question has nothing to do with JDBC. Moving...

[Benjamin Hiner]

I don't have the reference on me but sequences come before attributes.

   
 <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">  
   
 <xs:element name="message">  
     <xs:complexType>  
         <xs:sequence minOccurs="0" maxOccurs="unbounded"> 
             <xs:element name="message" type="xs:string"/>  
             <xs:element name="name" type="xs:string"/>  
             <xs:element name="type" type="xs:string"/>  
             <xs:element name="consumer" type="xs:string"/>  
         </xs:sequence>    
         <xs:attribute name="id" type="xs:string" use="required"/>        
     </xs:complexType>  
 </xs:element>  
 </xs:schema>