 |
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|

July 30th, 2009, 05:27 AM
|
Friend of Wrox
|
|
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
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..
|

August 1st, 2009, 11:24 AM
|
Authorized User
|
|
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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:
|
|

August 1st, 2009, 11:34 AM
|
Authorized User
|
|
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
|
|
|

August 1st, 2009, 05:42 PM
|
Friend of Wrox
|
|
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
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.
|

August 3rd, 2009, 03:51 AM
|
Friend of Wrox
|
|
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
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.
|

August 3rd, 2009, 07:15 AM
|
Authorized User
|
|
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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
|

August 5th, 2009, 07:00 AM
|
Friend of Wrox
|
|
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
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..
|

August 15th, 2009, 04:12 AM
|
Authorized User
|
|
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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
|

August 17th, 2009, 01:25 AM
|
Friend of Wrox
|
|
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
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.
|

August 17th, 2009, 02:38 AM
|
Authorized User
|
|
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Dear Peace,
Thanks for the advise. I will follow them and benefit from them.
Regards
Jawad
How's is the APEX project going?
|
|
 |