Question Re: Postgress JDBC Error SQL Exception: [SQL State:] 08001 in Technology Q&A

Postgress JDBC Error SQL Exception: [SQL State:] 08001

former_member1143721 — Wed, 19 Jan 2022 07:29:49 GMT

I am using Crystal reports and trying to create a JDBC connection. I am getting the following error:

Logon failed. Details: SQL Exception: [SQL State:] 08001 [Error Message:] Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

I was able to successfully do so with the CData driver, but I want to use an open source one. I am using the same information as I did with the CData software. I put the postgresql-42.3.1.jar in the SAP folder and updated the CRConfig.xml file with the new path and name. I also deleted the CData folder from my computer and reinstalled Crystal.

Connection URL: jdbc:postgresql:User=*****;Password=*****;Database=*****;Port=5432 (This is what I was using with the Cdata driver)

Databas Class Name: org.postgresql.Driver

Database: Same as with the Cdata driver.

UserID: ****

Password: ****

I would appreciate any help. Thank you.

Re: Postgress JDBC Error SQL Exception: [SQL State:] 08001

sveabecker — Wed, 19 Jan 2022 07:30:10 GMT

Welcome and Thank you for visiting SAP Community to get answers to your questions. Please add more details to your question, e.g. you can also add a screenshot. With that, you can reach a broader range of experts to get your question answered. I also recommend to do this tutorial https://developers.sap.com/tutorials/community-qa.html

The more details you provide, the more likely it is that members will be able to assist you.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Regards, Svea

SAP Community Global Moderator

Re: Postgress JDBC Error SQL Exception: [SQL State:] 08001

DellSC — Wed, 19 Jan 2022 14:24:42 GMT

If you look at the documentation for the PostgreSQL jdbc driver here, it appears that it's looking for a somewhat different format for the jdbc connection.

-Dell

Re: Postgress JDBC Error SQL Exception: [SQL State:] 08001

former_member1143721 — Wed, 19 Jan 2022 16:14:12 GMT

<Classpath>C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/crlovmanifest.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRLOVExternal.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBJDBCServer.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBXMLServer.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBJavaBeansServer.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/log4j.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/CRDBWicServer.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/CRDBWicExternal.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/CRDBXMLExternal.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\postgresql-42.3.1.jar;${CLASSPATH}</Classpath>

Re: Postgress JDBC Error SQL Exception: [SQL State:] 08001

former_member1143721 — Wed, 19 Jan 2022 16:14:34 GMT

Thank you. I'm sorry, I'm having trouble understanding the link.

I attached screenshots for you. Everything was working with the CData driver, so I don't understand why it's not working now. The only thing I changed was the Database ClassName.

Re: Postgress JDBC Error SQL Exception: [SQL State:] 08001

DellSC — Wed, 19 Jan 2022 16:47:22 GMT

It seems that the driver is looking for the URL in one of these formats:

//host:port/database
//host:port/

So, you would use "host:port" format instead of "host;Port=5432"

-Dell

Re: Postgress JDBC Error SQL Exception: [SQL State:] 08001

former_member1143721 — Wed, 19 Jan 2022 19:27:26 GMT

Thank you so, so much! I got it to work.

I used the following format based on your suggestion.

jdbc:postgresql://<server name>:[port number]/<database name>

Which for me looks like:

jdbc:postgresql://mylongserverurl.com:5432/accounting

Thanks again!