[
https://issues.apache.org/jira/browse/ODE-690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tammo van Lessen updated ODE-690:
---------------------------------
Fix Version/s: (was: 1.3.5)
1.4
> db scripts from dao-hibernate-db/target dont 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
> Fix For: 1.4
>
> Attachments: ode_in_psql.sql
>
>
> db scripts from dao-hibernate-db/target doesn't work well by default.
> At least for Mysql, Postgres, sqlserver, 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.
