Hi Catalin,
Thanks for your suggeston, which I have tried to follow.
As suggested, I went to:
http://jdbc.postgresql.org/download.html.
The only 8.1 jdbc2 driver there was for v412 not v404, which was
the number of the original driver in Flex Builder 3.
I downloaded that postgresql-8.1-412.jdbc2.jar anyway, and
copied it into the
Flex\ Builder\
3/.metadata/.plugins/com.adobe.datatools.derived/drivers/
folder, where the JDBC drivers are located, after first
moving the original driver into another directory
Then went to FB3 Preferences, Connections, and removed the
PostgreSQL JDBC Driver Definition, using the GUI tool, and added
the new postgresql-8.1-412.jdbc2.jar
I then got a message saying:
"Required property in driver definition missing value: User
ID"
I added User ID: "root" and it accepted this change
However, a message then appeared saying:
"Required property in driver definition missing value:
password"
When I added the root password and clicked OK, it did not
seem to save
the password slot became empty, and the message was still
there.
I closed the GUI window, and went back to Preferences to see
if the message was now gone, but it was still therre;
"Required property in driver definition missing value:
password"
I also tried creating a completely new connection file by
selecting
New -> other -> Select as Wizard window -> open
"Connection Profiles -> Wizard Selection Page
select "Postgres JDBC connection" -> "Create connection
profile"
Name:
Description:
checkbox: auto-connect
"Specify a Drive and Connection Details" window opens
Select a driver from the drop-down
-> "PostgreSQL JDBC Driver"
Connection URL: jdbc:postgresql:postgres
Database name: postgres
Driver Class: org.postgresql.Driver
Password: blank
User ID: root
When I try to add any password, either for root or postgres
users, it is not saved
When I either go to Preferences -> Connections
or try to create a new connection, I still get the same
error:
"Required property in driver definition missing value:
password"
Please advise.
Specific questions:
1) Is postgresql-8.1-412.jdbc2.jar a proper driver definition
to use? If not, which one is.
2) for the "PostgreSQL JDBC Driver" , are the following the
correct (default) settings?
Connection URL: jdbc:postgresql:postgres
Database name: postgres
Driver Class: org.postgresql.Driver
Password: blank
User ID: root
Thanks,
Mike
