Java Connect to PostgreSQL Database Example

[@CodeJava]

To copy the code examples, refer to this article: www.codejava.net/java-se/jdbc/connect-to-postgresql-database-server-via-jdbc

[@schmutz06]

Hi Code Java, I watched 20 hours of PostgreSQL tutorials over the past month coming from little experience and this is the first one which directly helped me reach my first (basic) holy grail; make a remote database, manipulate it. Thank you , I feel I'm now on the path!

[@CodeJava]

Glad I could help!

[@schmutz06]

@@CodeJava Thanks! I have a question, I inserted several rows and deleted them. When I insert new rows the integer/primary key continues on. e.g. I have ID 1, 2 ,3 ... I delete 2 & 3, I insert a new row and instead of generating the ID of '2' it goes onto '4'. Is that OK/normal and is there any way to circumvent it?

[@emilefeltesse]

Done this today successfully. Im so proud! Thank you :)

[@CodeJava]

Wonderful!

[@stephenpeters4393]

Calm and Collected! 💯 very concise too!

[@CodeJava]

Glad you liked it!

[@CodeJava]

Glad you liked it!

[@Intaberna986]

Helpful beyond measure. Thank you SO very much.

[@CodeJava]

Glad it was helpful!

[@ajithchristo8569]

Explaining is very clear and easy to understand

[@CodeJava]

Glad to hear that

[@cjm101]

I liked and subscribed because this video was exactly what I needed to help me understand the concept of connecting to postgre sql database from eclipse, thank you for your good work!! 🙏♥♥

[@CodeJava]

Awesome, thank you!

[@asokang7086]

Best tutorial, Thank You😊

[@CodeJava]

You're welcome!

[@slatha6901]

Wow.. Wonderful explanation thank you

[@CodeJava]

Glad it was helpful!

[@ismailtekin9349]

Thank you for that Video. It helped

[@CodeJava]

welcome :)

[@MatBat__]

Great vid, but I'm having a problem. When I click on build path for ContactProgram it doesnt show Classpath in the Library tab (as seen in 12:00) I can only see JRE System Library. Any Idea why?

[@CodeJava]

It's might be you're using older version of Eclipse, and/or you're using JDK 8. In this video, I use JDK 11 which has module feature. That's why you see that screen.

[@MatBat__]

@@CodeJava I solved it by declaring the jdbc driver while creating the Class. TY for the answer!

[@365motivation.9]

I found your video really helpful

[@CodeJava]

Glad it helped

[@chameleonchamlee2551]

Thank you for doing login through code, i really needed it

[@CodeJava]

Happy to help!

[@DWEthiopia]

At 12:45 when I try to change my password into a wrong password I don't get an error. Is that normal? I only get an error when I change the username.

[@CodeJava]

Hmm, that's abnormal. It should reject connection. So double check if password is actually changed.

[@DWEthiopia]

@@CodeJava Yeah I double checked. I changed the password to a password that I don't recognize and I still was able to add a record to my table.

[@CodeJava]

Hmm, let me check and get back to you soon.

[@underdogg3972]

placeholder 12:37

[@SonNguyen-ik4ew]

@Code Java: How do I connect when my pgadmin4 is on other server. I have address and host name. However when I replace localhost by IP address or Hostname of server. I cannot connect to database? Which configure I must to set up?

[@CodeJava]

check firewall on the computer that runs PgAdmin. Add exception so that it can accept requests from outside.

[@SonNguyen-ik4ew]

@@CodeJava Thank you for your reply. I did not turn off firewall and also haven't configured in pg_hba.conf file

[@christianandresheredialeal4351]

Buen dia amigo, veo que todos explican muy bien el insert, update y el delete pero no encuentro como consultar esa base de datos, es decir poder hacer una consulta para que me traiga la informacion y poderla poner en un formulario, si tienes algo te agradezco

[@CodeJava]

Kindly check this video: kzbin.info/www/bejne/el66oKebeLWcZ5Y

[@trankhai7521]

Anh ơi em dùng NetBeans sau khi đã add JDBC.jar vào thư viện rồi run code thì màn hình output không có hiển thị gì (kể cả lỗi) là sao ạ?

[@CodeJava]

có nghĩa là nó chạy bình thường. Em có in ra gì ko? Có nuốt exception ko?

[@JonesVitox]

Thank you bro, very relevant for begginers like me, +sub.

[@CodeJava]

Thanks for the sub! Glad I could help :)

[@vinaytandel4539]

Hi, may I request you to prepare a video for calling the PostgreSQL function having JSON input and output parameters and calling it from Java, please? Thank you.

[@CodeJava]

I will study and publish a video about that when time permits. Thanks for your valuable suggestion.

[@umutbatakbasi]

Thank you for this video.

[@CodeJava]

Glad it was helpful!

[@umutbatakbasi]

@@CodeJava do you have a video to clear the data?

[@CodeJava]

@@umutbatakbasi no, I don't.

[@fumitox87]

Thank you !!! (Set local RUS: "Спасибо вам большое !!!")

[@CodeJava]

you're welcome :)

[@nickparzival]

when i clicked on run console didnt show any output. what should i do

[@CodeJava]

Can you put a System.out.println("message") in your code to check?

[@paininkabir4760]

Does it work for Android Studio too?

[@CodeJava]

it will work as long as it is Java.

[@RhiannaMilindra]

Can i use the same code on android studio?

[@CodeJava]

I'm not sure. I have not tested on Android.

[@nsgirish]

Good explanation

[@CodeJava]

Thanks and welcome

[@melikeyildiz1841]

hi i did same things but ı cant connect,do u have advicee

[@CodeJava]

what is the error? Double check username/password and ensure the server is up.

[@SarMotiv-Hostories]

hi bro im from UZB, pliiz can you show me how to connect postgresql to AndroidStudio and to do one easy thing? pliiiz!

[@CodeJava]

I think we should use SQLite in Android, right? Anyway I don't code Android so I can't say.

[@SarMotiv-Hostories]

@@CodeJava yea, in Android, do you have some code for Android studio ?

[@CodeJava]

No, I don't.

[@hotaru7099]

Thank you.... thank you so much :'>

[@CodeJava]

You're welcome!

[@dhruvkaith3160]

Thank you

[@CodeJava]

You're welcome

[@_a2life_]

Respect

[@CodeJava]

you're welcome.

[@vaibhavisuryavanshiiiii]

Thankyouuu

[@CodeJava]

You are welcome

[@iamnot664]

Painful tutorial to watch

[@CodeJava]

sorry to hear that. Could you share more details?

[@iamnot664]

@@CodeJava you’re making a lot of mistakes as people follow along with you. A good tutorial is a tutorial you prepare for beforehand.

[@CodeJava]

@@iamnot664 thanks for your valuable feedback.

[@isaccabral1291]

Esse cara tá falando em Russo? que inglês feio da desgraça

[@055parthiban.s4]

INSERT works perfecly. But while SELECT "org.postgresql.util.PSQLException: No results were returned by the query" what should i do....?

[@055parthiban.s4]

i'm in urgent...plz reply ASAP

[@CodeJava]

show me your SQL. Are there any rows in the table?

[@z4n045]

i get No suitable driver found for jdbc::postgresql://localhost:5432/jdbc how can i solve it?

[@CodeJava]

remove one colon in the prefix. It must be jdbc:postgresql://....