Register Now!
Login
Welcome to EDAS2
Sunday, September 05 2010 @ 11:23 AM EDT

 Forum Index > General > Community Forum New Topic Post Reply
 INFO: EDAS 2 Application in Postgre SQL Database
 |  Printable Version
by Anonymous: xsalefter () on September 13 2009 15:02 PM (Read 382 times)  
Anonymous: xsalefter

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 Big Grin . I hope this is very useful for folks who need it. Thanks.






  Quote
 
Content generated in: 0.02 seconds
New Topic Post Reply



 All times are EDT. The time is now 11:23 AM.
Normal Topic Normal Topic
Locked Topic Locked Topic
Sticky Topic Sticky Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Able to post 
HTML Allowed 
Censored Content 

Links

EDAS2 Development Tracker - Enter bugs and feature requests

User Functions





Don't have an account yet? Sign up as a New User
Lost your password?

Contacts

John Zastrow
Information Technology Services
Main: 703.963.1669
john.zastrow@tetratech.com

Vladi Royzman
Information Technology Services
Main: 703.385.6000 x333
vladislav.royzman@tetratech.com

Jeffrey S. White
Center for Ecological Sciences
Main: 410.356.8993 x112
jeffrey.white@tetratech.com