You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Jeff Yu (JIRA)" <ji...@apache.org> on 2009/11/02 08:34:59 UTC
[jira] Created: (ODE-690) db scripts from dao-hibernate-db/target
doesn't work well by default.
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.
Posted by "Dhanush Gopinath (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dhanush Gopinath updated ODE-690:
---------------------------------
Attachment: ode_in_psql.sql
Attaching the SQL scripts for setting up ODE in POSTGRES. This was made based on the scripts given out of the box for other DB in ODE distribution and from the SQL for ORACLE given in the blog page http://diazdeveloper.blogspot.com/2009/07/apache-ode-with-jboss-and-oracle.html
> 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.
[jira] Commented: (ODE-690) db scripts from dao-hibernate-db/target
dont work well by default.
Posted by "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.
[jira] Updated: (ODE-690) db scripts from dao-hibernate-db/target
dont work well by default.
Posted by "Jeff Yu (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (ODE-690) db scripts from dao-hibernate-db/target
dont work well by default.
Posted by "Tammo van Lessen (JIRA)" <ji...@apache.org>.
[ 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