Re: My 1st JDBC and PostgreSQL

2023-07-20 Thread Chuck Davis
You get the value you're willing to work for as a general rule. It takes more effort to admin a real SQL server than an easy embedded DB. Your interpretation is spot on. On Thu, Jul 20, 2023 at 8:18 AM Adrian Klaver wrote: > On 7/19/23 18:11, Chuck Davis wrote: > > Postgresql is a sophisticate

Re: My 1st JDBC and PostgreSQL

2023-07-20 Thread Adrian Klaver
On 7/19/23 17:37, Amn Ojee Uw wrote: Following the example in : https://www.tutorialspoint.com/postgresql/postgresql_java.htm Avoid the site above it will lead you down many false paths. -- Adrian Klaver adrian.kla...@aklaver.com

Re: My 1st JDBC and PostgreSQL

2023-07-20 Thread Adrian Klaver
On 7/19/23 18:11, Chuck Davis wrote: Postgresql is a sophisticated database server.  You can do what you're attempting with something like Derby at the connection.  But with Postgresql "you get what you pay for". Not sure what "you get what you pay for" means in this context? My take is you a

Re: My 1st JDBC and PostgreSQL

2023-07-19 Thread Jeffrey Walton
On Wed, Jul 19, 2023 at 8:37 PM Amn Ojee Uw wrote: > > Following the example in : > https://www.tutorialspoint.com/postgresql/postgresql_java.htm > I wrote the bellow method : > > public void connectToDatabase() throws ClassNotFoundException, > SQLException { > try { > this.p

Re: My 1st JDBC and PostgreSQL

2023-07-19 Thread Chuck Davis
Postgresql is a sophisticated database server. You can do what you're attempting with something like Derby at the connection. But with Postgresql "you get what you pay for". 1) Insall Postgresql 2) start the database 3) use the interface app psql to create a database; 4) load the JDBC driver in y

Re: My 1st JDBC and PostgreSQL

2023-07-19 Thread Tom Lane
Amn Ojee Uw writes: > https://www.tutorialspoint.com/postgresql/postgresql_java.htm > In reference to the above web page, it reads : > The following Java code shows how to connect to an existing database. If > the database does not exist, then it will be created and finally a > database object w

My 1st JDBC and PostgreSQL

2023-07-19 Thread Amn Ojee Uw
Following the example in : https://www.tutorialspoint.com/postgresql/postgresql_java.htm I wrote the bellow method : public void connectToDatabase() throws ClassNotFoundException, SQLException {     try {     this.perr(this.getDatabaseClass()); // org.postgresql.Driver = Class