java - How to specify SQL column type for a specific database in hibernate mapping file -


is possible set multiple sql column types hibernate property depending on dialect used ? if yes how ?

for example, if have column of type char[], create clob type oracle , text type in sql server.

the short answer "no, it's not possible".

the long answer "kind of, don't want that":

hibernate automatically to extent - is, when define (implicitly or explicitly) property of hibernate type, translate type appropriate rdbms-specific sql type. dialect , descendants responsible translation.

you influence how translation occurs - again, extent - extending dialect(s) you're working (like oracle or sql server) , registering own column types. you're better off relying on default hibernate type mappings, though.


Comments

Popular posts from this blog

Cursor error with postgresql, pgpool and php -

delphi - ESC/P programming! -

c++ - error: use of deleted function -