java - Hibernate can't instantiate id generator in Spring project with multiple data sources -

i have spring project using hibernate 2 data sources (db2 , sql-server).

as add

@generatedvalue(strategy = generationtype.sequence, generator = "some_seq")

to column field in entity class, beancreationexception when creating sql-server entitymanagerfactory because org.hibernate.dialect.sqlserverdialect doesn't support sequences. place entity being used, though, in dao uses db2 entitymanagerfactory using appropriate dialect.

what missing?

try generationtype=auto instead of generationtype=sequence.

@generatedvalue(strategy = generationtype.auto, generator = "some_seq") 

with auto hibernate uses best fitting generation strategy, sequences databases , autoincrement others.

(n. b.: never use annotations use mapping files. there <generator class="native"> works different database types. generationtype=auto should same annotations.)