| Beginner | 
				 
							
					  | 
				 
							 
				
					 Joined: Mon Oct 30, 2006 12:46 am Posts: 26				
			 | 
			
				
				
					| 
					
						 Hi All,  
 
 I am setting unique-key for multuple columns  for a table.
 
 Here is the  snipplet:
 
 
 
 <property name="name" type="java.lang.String">
                         <column name="Name" not-null="true" unique-key="UNIQUE"/>
                 </property>
 
                 <property name="file" type="java.lang.String">
                         <column name="SourceFile" not-null="true" />
                 </property>
 
                 <property name="function" type="java.lang.String">
                   <column name="function" not-null="true"  unique-key="UNIQUE" />
                 </property>
 
                 <property name="subFunction" type="java.lang.String">
                         <column name="SubFunction" not-null="true" unique-key="UNIQUE"  />
                 </property>
                 <property name="mode" type="java.lang.String">
                         <column name="Mode" not-null="true" unique-key="UNIQUE" />
                 </property>
 
 
 but here i am getting error while creating table.
 The error  is : 
 03:17:41,978 ERROR SchemaExport:161 - Specified key was too long. Max key length is 500
 
 
 pls anyone help me !! 
 
 pls 
					
  
						
					 | 
				 
				 
			 |