jdbc: "Parameter index out of range" on subform when using jdbc URL [closed]

asked 2012-06-05 20:22:37 +0200

funkyhat gravatar image

updated 2020-07-28 21:38:32 +0200

Alex Kemp gravatar image

I have a libreoffice base document which is connected to a mysql database, and I don't want to have to type in a password when opening the document, so I am using the "JDBC" option for the connection rather than MySQL (JDBC). This allows me to specify a URL for the database with the password embedded.

However, when opening a form with subforms, the subforms fail to get populated, and give the error:

Parameter index out of range (1 > number of parameters, which is 0).

The SQL command leading to this error is:

SELECT * FROM prm_test.addresses WHERE ( personID = :link_from_ID )

This does not happen if I switch the connection type to "MySQL (JDBC)", but that's not really an acceptable solution as there's then no way to store the password.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-03-21 10:22:36.071513


Hi @funkyhat, Are you still looking for an answer to your question?

qubit gravatar imagequbit ( 2013-03-06 08:52:27 +0200 )edit