You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Tammo van Lessen (JIRA)" <ji...@apache.org> on 2010/04/13 14:29:05 UTC
[jira] Updated: (ODE-690) db scripts from dao-hibernate-db/target
dont work well by default.
[ 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: 1.3.5
> 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.3.5
>
> 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.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira