Postgres NetBeans connection driver issue

Question

I am tryng to configure a connection to postrgresql db server via Services window of Netbeans 7.3.1 and I get the following error: Cannot establish a connection to jdbc:postgresql://xxx.xxx.xx:5432/ using org.postgresql.Driver (ERROR: Unsupported startup parameter: extra_float_digits)

I have foud a possible workaround : ignore_startup_parameters = extra_float_digits Is there some way to set this parameter in a config file?

Thanks

What is your driver version and what is your Postgres version? — user330315
– user330315, Commented Sep 16, 2014 at 14:35
At a guess you're connecting to a truly ancient PostgreSQL version. — Craig Ringer
– Craig Ringer, Commented Sep 16, 2014 at 14:48
Postgresql is 9.0.3.2, the jdbc driver is postgresql-9.2-1002.jdbc4.jar — aorlando
– aorlando, Commented Sep 16, 2014 at 15:10
Have you found a solution for your problem so far? I'm having similar issue. — weekens
– weekens, Commented Oct 30, 2014 at 14:31
I do not use netbeans client at the moment. I am waiting for a solution — aorlando
– aorlando, Commented Nov 1, 2014 at 10:32

Houari · Accepted Answer · 2014-09-16 21:05:18Z

1

From PostgreSQL 9.2, a new server parameter extra_float_digits is added to control precision display of floating-point numbers Source. I think that it is better to use the right jdbc version for your server PostgreSQL version(9.0.3.2). In your case 9.0-802 JDBC 4

answered Sep 16, 2014 at 21:05

Houari

5,6513 gold badges33 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

aorlando Over a year ago

Thanks for the answer, but it does not work, same error.

Collectives™ on Stack Overflow

Postgres NetBeans connection driver issue

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related