I’m trying to connect a BOS 5.10.1 installation on a Windows 2008 R2 server via JDBC.
Other Windows processes use ODBC to complete this task, and so I’ve been given those settings to c configure the JDBC. I’ve also had the DB Admin confirm the case settings as correct, just in case it was case sensitive.
My settings are
Server : lwsv03dev02
Port : 30050
Database : pinsys
User : “report”
Password : “report”
Query: “select * from repcode”
so using the “JDBC – Execute a query on any DB using JDBC”
Driver - org.postgresql.Driver
URL - jdbc:postgresql://lwsv03dev02:30050/pinsys
User name : report
Password : report
Query : select * from repcode
getting bp_DCS_1 error,
org.postgresql.util.PSQLException: Protocol error. Session setup fail
I’ll keep looking for self help, but if anybody has any pointers on how to fix it would be appreciated.
Regards
Lawrence