Thread: Emmedding Oracle 10g XE into JDeveloper


Permlink Replies: 15 - Pages: 2 [ 1 2 | Next ] - Last Post: Sep 11, 2006 6:13 AM Last Post By: timfodell
marcel.overdijk...

Posts: 104
Registered: 06/08/04
Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 10, 2006 12:09 PM
Click to report abuse...   Click to reply to this thread Reply
Recently competing IDE suppliers are embedding databases out-of-the-box to their IDE's. SJSC2 has Pointbase and Netbeans will have Apache Derby.

I think for JDeveloper this would add value so we can (without installing Oracle separately) use a database directly.

Would it be an idea to embed Oracle 10g XE to JDeveloper?
Shay Shmeltzer

Posts: 9,974
Registered: 03/08/01
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 10, 2006 1:41 PM   in response to: marcel.overdijk... in response to: marcel.overdijk...
Click to report abuse...   Click to reply to this thread Reply
This is something that we have been looking at for a while now.
What are other people on the list think?
Do you want a bundle that includes JDeveloper and a Database with the demo schema tables?
Or do you prefer a separate database and JDeveloper downloads?
Chris Muir

Posts: 1,481
Registered: 02/16/05
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 10, 2006 2:04 PM   in response to: Shay Shmeltzer in response to: Shay Shmeltzer
Click to report abuse...   Click to reply to this thread Reply
For me: separate.

Reasons:

1) Often run JDev without a database.
2) I switch between databases and already have multiple installed on my machine.
3) I wouldn't want to have to download an extra 200MB+ when I already have them (the whole world isn't on the end of a fast-link)

However if it was an option, something along the lines of Studio, and Studio DB, that would be fine.

I can also see for beginners it would be nice to have one download. It would eliminate that problem of "I've downloaded JDev, but now which database do I need to download?".
Steve Heidebrink

Posts: 473
Registered: 01/08/02
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 10, 2006 3:55 PM   in response to: Chris Muir in response to: Chris Muir
Click to report abuse...   Click to reply to this thread Reply
I agree, for beginners this would be a very nice feature. Especially if there was very little effort new users would need to put in for getting a simple db app up and running. I've trained users on JDev and reducing the intial number of steps would be very helpful.
Brenden Anstey

Posts: 1,101
Registered: 11/05/03
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 10, 2006 8:06 PM   in response to: Steve Heidebrink in response to: Steve Heidebrink
Click to report abuse...   Click to reply to this thread Reply
I would say keep them seperate (keep JDev lean and mean)

What would be nice is an install sample schema function in JDev where you have downloaded XE seperately and you want to install the sample/tutorial schemas.

I already have five Oracle homes for all the products and versions i have to use, plus a number of JDK's and JInitiators of various different versions.... so either seperate or an optional download would be my preference.
Timo Hahn

Posts: 2,149
Registered: 08/20/04
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 10, 2006 11:37 PM   in response to: Brenden Anstey in response to: Brenden Anstey
Click to report abuse...   Click to reply to this thread Reply
Keep them separate!
I would like the packages as small as possible.
Didier Laurent

Posts: 611
Registered: 01/10/01
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 11, 2006 12:12 AM   in response to: marcel.overdijk... in response to: marcel.overdijk...
Click to report abuse...   Click to reply to this thread Reply
Hi Shay,

We did it in the past for Oracle Designer and Oracle SCM.
There was there a real added value as the Designer Repository was pre-installed in the database (installing it was taking more than 2 hours at that time and it had a large list of manual operations to do in the DB before beginning with the installation).

However, it was not as successfull as we though it would be and we gave up with this pre-installed database in the next release.

Regards,

Didier.
Olaf Heimburger

Posts: 1,577
Registered: 01/10/01
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 11, 2006 1:21 AM   in response to: marcel.overdijk... in response to: marcel.overdijk...
Click to report abuse...   Click to reply to this thread Reply
Marcel,
embedded databases are usually java libraries that run in the same java process.
Oracle XE for example is a full-flegded standalone database.

I agree with Didier that bundling JDeveloper with Oracle XE would have it's benefits
and also agree with other who want to have it seperate. JDeveloper should be
runnable and installable as a standalone product without any database, I have
5 JDev versions installed and run all in parallel.
Sandor Nieuwenh...

Posts: 192
Registered: 01/19/02
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 11, 2006 3:04 AM   in response to: Olaf Heimburger in response to: Olaf Heimburger
Click to report abuse...   Click to reply to this thread Reply
What about embedding Oracle Lite with JDev??
When you download BPEL PM, by default it comes with OLite which turns out to be very easy for developers.
Just a thought...
gdavison

Posts: 80
Registered: 01/10/01
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 11, 2006 3:54 AM   in response to: marcel.overdijk... in response to: marcel.overdijk...
Click to report abuse...   Click to reply to this thread Reply
Hi,

Just a suggestion; but a simpler alternative would be for JDeveloper to auto-detect an XE install, or any other oracle databses on the current machine for that matter, and populate the Connections page first time it is shown.

This would seem to have the both of best worlds without creating a confusing bundle of different installers,

Gerard
daniel_co

Posts: 175
Registered: 06/30/04
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 11, 2006 8:38 AM   in response to: Shay Shmeltzer in response to: Shay Shmeltzer
Click to report abuse...   Click to reply to this thread Reply
I think emmedding XE into JDeveloper would be a good idea, but will be nice to keep it like a "flavor" of JDeveloper.
In that way you can donwload something like the BASE version (or lite), and the full version with XE included.
To keep it simple to newbies this Full Version should have something like an Universal Installer to chose the name (SID) , port and password to the database ( just like the OUI in the 10gR2 database).

This can help to many people to get closer to oracle "free" products.
marcel.overdijk...

Posts: 104
Registered: 06/08/04
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 12, 2006 1:20 AM   in response to: Shay Shmeltzer in response to: Shay Shmeltzer
Click to report abuse...   Click to reply to this thread Reply
Shay,

The discussion as it's going now is just what I wanted. I think there was some good feedback.

I think until now there is a 50-50 tie for embedding it and keeping it separate.
I'm a little bit surprised because for 'real' JDeveloper users, an embedded database is not really needed as working in projects means that there is central installed database. And I expected thoses users around on this forum.

Personally speaking, when working with JDeveloper on projects an embedded database is not needed. As I said before, most of the times in this case there is a central database server hosting the database.
So for those people I understand they prefer keeping it separately (to keep it small).

But there are cases that it really would add value:
- JDeveloper Starters: starters who want to experience with JDeveloper and e.g. do some ADF tutorials need to install Oracle. Because of this additional installation many of them will bail out; that's not what we want!
- Students: I JDeveloper would have an embedded database it could be used more easily for education on schools; the younger they start, the better!
- Regurlaly/Experienced JDvelopers users who want to try something at home but don't have Oracle installed for some reason.

For me it doesn't have to be Oracle XE, because it's still fairly big. It could also be a embedded Java database like Derby or HSQL. As long as it works with ADF Business Components without problem. (I tried MySQL once, but it didn't worked optimal with BC4J: e.g. primary keys are not added)

Also remember that JDeveloper is shipped with embedded OC4J out-of-the-box. I know you cannot compare this to an embedded database, but it is in and you can choose to use it or not.

Regards,
Marcel

brian.greenfield

Posts: 165
Registered: 10/10/01
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Jan 13, 2006 6:11 PM   in response to: marcel.overdijk... in response to: marcel.overdijk...
Click to report abuse...   Click to reply to this thread Reply
This is a very good idea. I would vote to keep it separate.
anjanb

Posts: 4
Registered: 03/03/06
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Mar 3, 2006 9:49 AM   in response to: marcel.overdijk... in response to: marcel.overdijk...
Click to report abuse...   Click to reply to this thread Reply
hi there,

it all depends :-) (no, I am not a consultant)

things to ponder : how big is the package(JDeveloper + Oracle XE). How long will it take to install the bundled DB.

pros with XE : that will let your target audience know how to bundle XE with their applications. If you can trim(size) XE to be embeddable (like mysql), then it will make sense for a developer to install the whole package. It will be nice if you can make it easy for developers to create a deployable package(like installShield) including Oracle XE. If that becomes less than a 150/200 MB package with nice screens, etc, then that will be interesting. Your DB division will love you if that can improve Oracle's position in the low-end DB market.

BR,
~A
anjanb

Posts: 4
Registered: 03/03/06
Re: Emmedding Oracle 10g XE into JDeveloper
Posted: Mar 3, 2006 9:50 AM   in response to: marcel.overdijk... in response to: marcel.overdijk...
Click to report abuse...   Click to reply to this thread Reply
hi there,

it all depends :-) (no, I am not a consultant)

things to ponder : how big is the package(JDeveloper + Oracle XE). How long will it take to install the bundled DB.

pros with XE : that will let your target audience know how to bundle XE with their applications. If you can trim(size) XE to be embeddable (like mysql), then it will make sense for a developer to install the whole package. It will be nice if you can make it easy for developers to create a deployable package(like installShield) including Oracle XE. If that becomes less than a 150/200 MB package with nice screens, etc, then that will be interesting. Your DB division will love you if that can improve Oracle's position in the low-end DB market.

BR,
Anjan Bacchu (http://anjanb.wordpress.com)
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums