aspose file tools*
The moose likes Websphere and the fly likes Question to Bob Janson - database topics in the book Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Question to Bob Janson - database topics in the book" Watch "Question to Bob Janson - database topics in the book" New topic
Author

Question to Bob Janson - database topics in the book

Mikalai Zaikin
Ranch Hand

Joined: Jun 04, 2002
Posts: 3233
    
    7
Hi Bob,

Some questions:

1) Do you cover database products download and install? Can reader run the accompanying code from apress.com ?

2) Are your samples use JPA? (I downloaded samples, but seems code uses plain JDBC, maybe I overlooked, please correct me)

3) Assuming from your earlier explanations that your book is for Java newbies, do you think it's a proper style to use SQL and/or JDBC?




Thanks,
MZ





Free SCDJWS 5.0 Study Guide - SCDJWS 5.0 Quiz (How to get SCDJWS 5.0 Quiz)
Java Platform, Enterprise Edition 6 Web Services Developer Certified Expert Exam Study Guide and Quiz
Robert Janson
Author
Greenhorn

Joined: Nov 26, 2013
Posts: 12
    
    5
Hi MZ,
1. Nothing about installing a DBMS (kinda outside the scope of an intro to java book) but if you have access to a DB2, Oracle or Access DBMS you can add the unique info for the DBMS to the code and it will run. I included Access because I figured most newbies wouldn't have access to an enterprise level DBMS like Oracle or DB2. Again, the book goes through step by step how to set up a ODBC data source in Windows (which is part of the non-WebSphere technology that I alluded to in other posts).
2. Plain JDBC in the client app and then SDO in the server based section. Do you think JPA is appropriate for beginners? Defining the relationships between the JPA entities, referential constraints, etc. seemed too much to me. I guess I could have just had a single table. Do you see JPA as a substitute for SDO and JDBC or in addition to?
3. I'm not sure what you mean by "proper style". Do you think it's too complicated? Bad programming? Old technology? I partially did it so they would appreciate the GUI tools for using SDOs.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Question to Bob Janson - database topics in the book