db scripts from dao-hibernate-db/target doesn't work well by default.
---------------------------------------------------------------------
Key: ODE-690
URL: https://issues.apache.org/jira/browse/ODE-690
Project: ODE
Issue Type: Bug
Affects Versions: 1.3.3
Reporter: Jeff Yu
db scripts from dao-hibernate-db/target doesn't work well by default.
At least for Mysql, Postgres, sqlserver, Oracle, the blob type needs to be
updated to its corresponding type according to the database.
Quote from Karthick Sankarachary:
"Just for future reference, shown below are the column types that denote
blobs in certain database providers:
MySQL - mediumblob
Postgres - bytea
Ingres - long byte
Oracle - blob
Derby - blob(2G)
DB2 - blob(1073741823)
Sybase - IMAGE null
SQL Server - image null
Hope it helps.
Best Regards,
Karthick Sankarachary
"
The scripts are generated by Hibernate, the best solution is to try to provide
the correct sql out-of-box.
Regards
Jeff
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
