[
https://issues.apache.org/jira/browse/ODE-690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12803219#action_12803219
]
Jeff Yu commented on ODE-690:
-----------------------------
Riftsaw project has included a working version of db scripts (include index)
for hsql, mysql, postgres, oracle and sqlserver. it is at:
http://anonsvn.jboss.org/repos/riftsaw/trunk/runtime/engine-assembly/src/main/resources/bpel-sql/
> 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
> 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.
