[jira] Created: (ODE-690) db scripts from dao-hibernate-db/target doesn't work well by default.

View: New views
2 Messages — Rating Filter:   Alert me  

[jira] Created: (ODE-690) db scripts from dao-hibernate-db/target doesn't work well by default.

by JIRA jira@apache.org :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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.


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

by JIRA jira@apache.org :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


     [ https://issues.apache.org/jira/browse/ODE-690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeff Yu updated ODE-690:
------------------------

    Description:
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


  was:
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


        Summary: db scripts from dao-hibernate-db/target dont work well by default.  (was: db scripts from dao-hibernate-db/target doesn't work well by default.)

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