JDBC assignments

[Paul Ralph]

I was surfing through the cattle drive and came to some JDBC assignments that come after the Servlets. It doesn't look like anyone is doing them and only Marilyn is listed as graduating from Servlet school. If and when someone gets there, who will be nitpicking them? Are you working on them in secret Marilyn? Or did you write them?
I also found references to XML-1, and EJB-1 in an old post by Paul, but perhaps those are offlimits to even look at.
Paul R
[This message has been edited by Paul Ralph (edited April 25, 2001).]

[Daniel Olson]

Good question! I am getting close to finishing the Servlet unit and am interested in doing whatever is next.

[Marilyn de Queiroz]

I will be nitpicking them. I will finish the JDBC section in the very near future.

XML and EJB pages have not yet been written. They are still in the future.

Paul Wheaton wrote all of the assignments.

[Johannes de Jong]

This is starting to become a "course" of distinction.
Tkanks Paul & Marilyn.

[Paul Ralph]

I will be nitpicking them. I will finish the JDBC section in the very near future.

OK this is admittedly kinda nosy, so feel free to ignore it if you think I've gone too far.

What do you mean by "finish", Marilyn? Are you doing the assignments yourself, with the trailboss grading them? If so, I think it would be cool to see you on the Assignment Log. Or are you rewriting the assignments?
Thanks
Paul R

[Marilyn de Queiroz]

What do you mean by "finish", Marilyn? Are you doing the assignments yourself, with the trailboss grading them?

Yes. Actually, I started last September when there were only the first eight assignments. I did OOP, Servlets, and most of JDBC as they were written (November through January). Since then the number of students has increased so dramatically that I postponed completing JDBC. Hopefully I'll be able to complete them soon and move on to XML.

Or are you rewriting the assignments?

No

[Lance Finney]

I'm working on JDBC-2 now, but I'm looking ahead to 3 and 4, which require updating and deleting records. I'm not sure how we're supposed to handle identifying the records to be deleted.
For example, while playing around I've created two different movies called "Hi" starring "Hello" that are DVD action movies described as "Good Evening". I know I need a way to distinguish between them for updating and deleting, but I don't have anything for this yet.
I'm not sure which of these options to follow:
a) Change the table schema to make an existing column or combination of columns unique.
b) Change the table schema to add a new id field that is hidden from the user.
c) Ignore this issue.
Any thoughts?
P.S. I'm posting on this old thread because I can't create a new topic.

[jason adam]

Haven't addressed this issue, but if you want to have multiple entries for one title, I would think the best route would be B. Even though they have the same name, the ID should be different. This number would be a key in the database, and can be used to reference that specific entry. This would allow you to edit and delete specific movies without dealing with the problems of either deleting all movies with that name, or editing just the last entry.
I don't think there is anything in the assignment that states whether multiple entries are acceptable or not, and how to deal with them, so I would say that is all up to you. Personally, I took the lazy way and just avoided putting multiple entries into my listing.
Jason
[ January 07, 2002: Message edited by: jason adam ]

[Marilyn de Queiroz]

Jason,
See this thread. Lots of people are having the same problem.

[jason adam]

Originally posted by Marilyn deQueiroz:
Jason,
See this thread. Lots of people are having the same problem.

Yeah, read that after doing the initial post so I edited the part out about why he's getting the problem. Teaches me not to read MO first.

[Marilyn de Queiroz]

Originally posted by Lance Finney:
I'm not sure how we're supposed to handle identifying the records to be deleted.
For example, while playing around I've created two different movies called "Hi" starring "Hello" that are DVD action movies described as "Good Evening".

This sounds like the same movie to me.

I know I need a way to distinguish between them for updating and deleting, but I don't have anything for this yet.

I'm not sure which of these options to follow:
a) Change the table schema to make an existing column or combination of columns unique.
b) Change the table schema to add a new id field that is hidden from the user.
c) Ignore this issue.

c) Ignore the issue. Use the title as your primary key. Although there are ways around your problem, one of the rules of the cattle drive is don't add extra stuff unless specifically mentioned. It just makes more work for me.