(0 ms) [http-8080-1] ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate#execute : Unsuccessful: create table tour.base_hotel (id integer not null, typeId_1 integer, totalTime float, totalMoney float, line varchar(255), typeId_2 integer, scenerySpotList text, stopList text, hotel_id integer, hotelName varchar(20), hotelClassType varchar(16), hotelPrice float, primary key (id, typeId_1, totalTime, totalMoney, line, typeId_2, scenerySpotList, stopList, hotel_id, hotelName, hotelClassType, hotelPrice))
(0 ms) [http-8080-1] ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate#execute : BLOB/TEXT column 'scenerySpotList' used in key specification without a key length
(15 ms) [http-8080-1] ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate#execute : Unsuccessful: create table tour.problem_hotel (id integer not null, time float, realTime float, money float, realMoney float, relationTime float, relationMoney float, typeid_2 integer, typeid_1 integer, line varchar(45), stopList varchar(45), scenerySpotMoney float, generalLine text, hotel_id integer, contradictionType varchar(10), hotelNo integer, hotelName varchar(20), hotelClassType varchar(16), hotelPrice float, primary key (id, time, realTime, money, realMoney, relationTime, relationMoney, typeid_2, typeid_1, line, stopList, scenerySpotMoney, generalLine, hotel_id, contradictionType, hotelNo, hotelName, hotelClassType, hotelPrice))
(15 ms) [http-8080-1] ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate#execute : Too many key parts specified; max 16 parts allowed
(15 ms) [http-8080-1] ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate#execute : Unsuccessful: create table tour.stop_tool (id integer not null, startNo integer, endNo integer, distance float, toolNo integer, startPicture varchar(10), endPicture varchar(10), toolName varchar(16), speed float, price float, startPrice float, startLenght float, primary key (id, startNo, endNo, distance, toolNo, startPicture, endPicture, toolName, speed, price, startPrice, startLenght))
(31 ms) [http-8080-1] ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate#execute : Table 'stop_tool' already exists

Hi iwill,

could you please also post the mapping files of the entities in question?

Please use BBCode to enclose your code snippets and stack traces (check the buttons below the subject line). This will be much easier to read then.

CU
Froestel

Hi Iwill,

this looks rather complicated since there are several errors.

[*]There might be trouble in your mapping for BaseHotel. I'm not sure, but I don't think it is a good idea to have the value for field name in <composite-id> being equal to that of one of its <key-property> name fields. What is this id anyway? Why is there need to have a composite id in this place?
[*]Do you use the property scenerySpotList somewhere else? You might have forgotten to add a value for its length attribute.
[*]The problem_hotel table has too many key fields, at max. 16 seem to be allowed. (Why even have more than two or three in a key?)
[*]The stop_hotel table seems to be mapped more than once - a copy-and-paste error

Did you actually put up a proper data model that could possibly end up in a straight and normalized database schema. It looks like you have conceptual problems with the theoretical basis of your work.

CU
Froestel