Follow an exercise in leveraging stored procedures in a database with JDBC.
- [Instructor] We're going to jump into some more…of the advanced concepts in JDBC…by first of all working with stored procedures.…Now if you open up the exercise files…in the sequel scripts, I've modified the read me,…and added a new value.…The read me now has the steps to import…the store procedure that I've created…as part of the stored under proc.sequel file.…So let's jump in the terminal,…and I've loaded this directory up.…I have my database running.…
All right, so we are going to execute psql-h localhost -U…postgres -d hplussport -f stored_proc.sequel.…When it prompts for your password,…put in the password of password,…and now it's created the function,…and now it's available for us to use.…Go ahead and close all this down.…And we're going to go into our orders DAO…that we did during our challenge exercise.…
Now, semantically, we created a function…because it returns data,…but functions and store procedures really are synonymous…in Postgres, so we're going to go ahead and move on.…Now there are two ways to call this.…
AuthorFrank P Moley III
- Deciphering JDBC terminology
- Using containerized PostgreSQL
- Creating, reading, updating, and deleting data
- The Repository pattern
- Using stored procedures
- Ordering and limiting results
- Transactions in JDBC
- Handling exceptions
Skill Level Intermediate
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Programming Foundations: Databases (2015)with Simon Allardice3h 11m Intermediate
Java Essential Training: Objects and APIswith David Gassner2h 46m Intermediate
What you need to know5m 10s
1. Introducing Java Data Access
2. Data Access Basics
3. Advanced Data Access
Next steps3m 26s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.