Hi..
I know this project from Dan Allen post at jsf central. At the beginning I'm just curious about how to upgrade performance in seam framework application. Unfortunately, I don't have a Oracle Database instance in my notebook. I just have a PostgreSQL and MySQL. So I can't try and test the application in my machine.
Then I starting my migration from Oracle to PostgreSQL. Here is the PostgreSQL dump file: edasdb-postgresql. And FYI, here are small change I've been done to original database sample script:
- Change the BLOB datatype to bytea.
- Change the VARCHAR2 datatype to VARCHAR
- Change NUMBER datatype to numeric
Maybe I'm poor some optimization when migrating the data. But my first intent is quick-change-and-run in postgreSQL
. I hope this is very useful for folks who need it. Thanks.