Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > BOOK: Beginning Oracle Application Express ISBN: 9780470388372
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning Oracle Application Express ISBN: 9780470388372
This is the forum to discuss the Wrox book Beginning Oracle Application Express by Rick Greenwald; ISBN: 9780470388372
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Oracle Application Express ISBN: 9780470388372 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 30th, 2009, 05:27 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default Need Process for Chapter 12: Deployment

All:
I am currently on Chapter 12: Deployment-Migrating Your Applications - Prerequisites, page 333 and I am stuck. Currently on my laptop, prior to this chapter resides the following:
  • Operating system = Windows XP Professional;
  • MS SQL Server 2005 Express;
  • Oracle 10g w/ Application Express 3.2;
  • Java (jre 1.5.0._06) and jre6.0, selecting java icon in the control panel jave 6.0 _14.
I have downloaded both versions of the Oracle SQL Developer: sqldeveloper-1.5.5.59.69, which includes the Jdeveloper and sqldeveloper-1.5.5.59.69-no jre, which does not include the JDeveoper, but makes the assumption that JDK5.0 is currently on your machine, according to the document, Installing Oracle SQL Developer,
http://download.oracle.com/docs/cd/E...53/install.htm
It is not clear to me what to do with the two current versions of Java:

While installing the Oracle Sql Developer by clicking the sqldeveloper icon, the Oracle dialog box pops-up and prompts for the full path to the Java.exe. Regardless to which java release I use the error message is the same:
  • "Cannot find a J2SE installed at path: C:\ProgramFiles\Java\jre1.5.0_06".
  • "Cannot find a J2SE installed at path: C:\ProgramFiles\Java\jre6.0".
Should I download the JDK 5.0 for the Oracle 10g DB?
I need assistance in determining what to do next to get the Oracle Sql Developer up and running.

Thanks In Advance.
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Last edited by peace95; July 31st, 2009 at 01:54 AM..
  #2 (permalink)  
Old August 1st, 2009, 11:24 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

Dear Peace,

The problem is with Java. Apparently with JRE (Java Runtime Envoirment) and JDK (Java Development Kit). The Oracle SQl Developer needs JDK as JRE is not enough for it to run. The Oracle site says that JDK is included with the Oracle SQL developer but it seems it is not. Here is what I did.

1 - Download
http://i25.tinypic.com/2vm7zgl.jpg

2 - Unzip
http://i32.tinypic.com/nl603m.jpg

3 - Run
http://i29.tinypic.com/2ytppiw.jpg

4 - It simply runs with out asking for java.exe
http://i31.tinypic.com/mhbwna.jpg

5 - The Interface
http://i26.tinypic.com/10foz01.jpg

6 - If I browse i find that it is JRE and not JDK
http://i31.tinypic.com/25qcepg.jpg

The Oracle SQL Developer needs JDK and not JRK even though Oracle downloads says it is JDK.

I had installed Oracle Database 11g Release 1 and when I tried Oracle SQL developer it gave the same error for jave.exe but no problems with Oracle XE.

Regards

Jawad Asghar Ali
The Following User Says Thank You to JAA149 For This Useful Post:
peace95 (August 1st, 2009)
  #3 (permalink)  
Old August 1st, 2009, 11:34 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

See this at the Oracle OTC forums

http://forums.oracle.com/forums/thre...ageID=3559668?
  #4 (permalink)  
Old August 1st, 2009, 05:42 PM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

Thank you, JAA149. I will give it a try.
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.
  #5 (permalink)  
Old August 3rd, 2009, 03:51 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

JAA149:
Please send name of thread you referenced in your recent post. In the OTN, the message came back with "Thread not found".

However, following your suggestions your first post has helped tremendously. I am trying to accomplish:
  • Migrate application from my Oracle Hosted Account to my Oracle Localhost Account.
I have just discovered the correct Username and password for the SQL Developer connection. For two days I kept receiving:
  • Status: Failure-Test select: ORA-01017: Invalid username/password, logon denied
I knew since the information on page 334, for Username, Password and Connection Type was not working in my scenario, I went back to the part of the upgrade from Oracle 10g XE 2.1 to APEX 3.2. I used this installation guide to accomplish it:I used the part 2 of the article, installing APEX.. I thought at one point that I needed the SQL Developer for Oracle 10g plus the JDeveloper for Oracle 10g. The website I found helpful:How is it going for you? Have you passed the Migration yet?
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.
  #6 (permalink)  
Old August 3rd, 2009, 07:15 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

Dear Peace 95,

The Oracle OTN forum threaad name is

"Thread: SQL Developer asks for java.exe with the version that has java built in. "

and is at

http://forums.oracle.com/forums/thre...6204&tstart=44

The poster is Centinul who says he resloved it by "Resolved. There was a difference of permissions on the user's machine."

Don't know what that means.

Have not made much progress about the book. Been busy with database modeling and Chris date's book "SQL & the relational theory". Will however start with the book again.

When I first started, I thought database application developement was part of the the modeling. However I soon came to know that

1 - Database Modeler
2 - Databse Designer
3 - Databse Develloper
4 - Database Administaror
5 - Database Programmer (Application)

are and maybe very different although very interlated fields. My interests are in the modling & designing the database. However the databse application programming is quite a large field and one must know HTML, PHP, XML and some others. Never the less I will go throgh these 3 books.

1 - Beginning Oracle Application Express - New Edition 2008
2 - Pro Oracle Application Express - 1st Edition 2008
3 - Professional Oracle Programming - 2005

What say Yee?

Reagrds

Jawad
  #7 (permalink)  
Old August 5th, 2009, 07:00 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default Chapter 12: Deployment-New Page 341 -- YAHOO!!

JAA149:

I did not get your response thru the normal channel. It just so happened I was looking for your response to my question on the tinypics.com website and that is when I discovered your recent response.
==============================

The person that posted the problem, Centinul, resolved the problem by changing the permissions. The SQL Developer version was 1.5.4 and we are using 1.5.5_06.

I also like DB Developing. In your list DB-Modeling,Designing and Developing overlap, but even that depends on the company and/or contract. I also enjoy IT Auditing and Business Process Modeling. Good Luck with Chris's Date Book???? ... Interesting, I think. It all boils down to basically 3 Structure Types: Relational (Oracle, Access, MS SQL Server), Hierarchial (Oracle-OOP, XML,any OOP) and Data Warehouse, which is a combination of Relational and Hierarchial (Oracle DW, Informatica, IBM COGNOS (BI) ).

===============================
I am on a new page and section, Create an Pracle Application Express Workspace. The first part of the Migration was definitely a Challenge, because of Oracle version 10g on my personal laptop.

I am ready to start on the OTN APEX 2009 Challenge. I have about 2 weeks to complete.
at the same time complete the book.
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Last edited by peace95; August 5th, 2009 at 07:11 AM..
  #8 (permalink)  
Old August 15th, 2009, 04:12 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

Dear Peace95,

The Database world is not only crowded but misconceptions and wrong interpetations are found every where. For a new guy like me it some times seems impossible to continue my journey through this wonderful world. For example, Oracle, MS SQL sever and MYSQL, to name a few, are not really RDBMS but SQL DBMS. The difference is amazing. The books by Chris Date, Fabin Pascal, Dr. Coad and Darwin bring out this difference.

Any body and I mean every body who studies the relational model must also study maths in particular Logic specially propositional logic and quantifi logic, the 5 logical connectives, truth tables and truth trees, logical proofs, checking for logical validity, soundeness, tautologies, Cantor's set theory, relational algebra and calculus.

Stricly speaking, for a database professional one has to have firm understanding of three segments. The Relational Structures (The mathemathical constructs known as "Relations"), the Integerity and the manipulation.

The book by Chris Date "SQL and the Relational Theory" introduces the difference between "The Relational Model" and its implementation "The SQL Model (For want of a better term). The book is a must for a database professional. For example, till recentally I was under the impression that The "Relational" in the Relational Model was because there were relationships between tables. However after reading the book, one realizes the the "relation" in the relational model has nothing to do with the relationships but is instead beacuse of the "Relations" or in a more SQL familiar term as Tables.

Also, the so claimed RDBMS such as Oracle and others are have abused the relational model. Subsequently one has to know exactly what the relational model is so he can transport his knowledge to various DBMS. Lets say we progame as

SELECT cust_id, cust_name FROM customers ORDER BY cust_name ASC;

Because this SQL statement returns a result set that has ordering to its rows, therefore the result set is not a relation but a table. This is turn denies the most important property of Relations caled Closure which states that any relational operation + relational assignment on a given relation must result in a relation. In other words "at least one relation in, utmost one relation out". The consequence of this is that when one uses any DBMS such as Oracle, he must know where the DBMS departs from the relational model in order for him to employ the DBMS properly. This is the aim of the book.

Recentally I was enganged in a debate with an ORACLE DBA. That person in question had no idea about the relational model. Not even the basics. My aim is to study the principals, than the products.

Regards

Jawad
  #9 (permalink)  
Old August 17th, 2009, 01:25 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

JAA149:
WOW!!! You sound as if you are on DB or DBMS "Overload".

When discovering yoour "field of concentration", start by examining what you enjoy doing, which you have stated already and then listing those things you wish or feel you need to know about your chosen field.

Dr. E. F. Codd is the "Father" of DBMS or RDBMS. Working for IBM at the time, he created the standard. I suggest you read all information about his definitions or standards. Everything and I do mean everything stating "relational" are compared to Dr. Codds Standards. Since you are looking for principles start with Dr. E. F. Codd.... back to the beginning. Pay close attention to his rules on Normalization.

Oracle is a Relational Database Management System. I am not new to DBMS or RDBMS and I am not new to Oracle. I am new to APEX, which is an Application that sits on top of Oracle. The problems I am having, as stated in an earlier thread, my laptop Oracle is 10g with APEX 3.2. I am sure if I changed to Oracle 11g then the only problems I would have are those related to a "Hosted Account" which is still different from what is illustrated in the book in Chapter 12.

SQL, MS SQL, MySQL all came after Codd's Standards. When you pick up a book always read the Preface and Forward, they give you an idea of the author's approach or way of thinking.

I am not surprised about your responses from the Oracle DBA. The qualifications for an Oracle DBA are not as tough as in they were in the past. In an Oracle class at one of their Training Centers in Irvine, TX, the instructor had failed the DBA Test twice and was preparing to sit a 3rd time. I asked 4 different co-workers to define a "record". The Application Programmer referenced the entries in a file. The Systems Programmer responded with a file entry in a directory.. Whose right and whose wrong? It depends on where you stand.

Ease up on yourself....you will get there.
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.
  #10 (permalink)  
Old August 17th, 2009, 02:38 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

Dear Peace,

Thanks for the advise. I will follow them and benefit from them.

Regards

Jawad

How's is the APEX project going?
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 8: checkout process mbeppe BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 4 August 10th, 2007 07:59 AM
Generics chapter 12 difficult chapter i found ...? Larryz C# 2005 1 July 4th, 2007 09:40 PM
Errors on Chapter 12 example(12.8) sonnie ASP.NET 2.0 Professional 2 June 7th, 2006 10:55 AM
deployment chapter hard to follow robert BOOK: ASP.NET Website Programming Problem-Design-Solution 3 June 20th, 2003 12:22 PM



All times are GMT -4. The time now is 12:23 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.