[jira] Commented: (ODE-690) db scripts from dao-hibernate-db/target dont work well by default.

["Jeff Yu (JIRA)" <ji...@apache.org>]

    [ 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.