I am running multiple tenants by schemas in postgresql.
How would it be with B4X to connect to the schema according to the corresponding customer.
Client_1 is for Customer_1;
Client_2 is for Customer_2;
Client_3 is for Customer_3;
Each customer has its users, restrictions, etc.
how can i call procedures in jRDC2 on PostgreSQL?
I call it so:
but jRDC2 says:
org.postgresql.util.PSQLException: ERROR: procedure sdbspget_checkuser(character varying, character varying, character varying, character varying) does not exist
Hinweis: No procedure...
I have a PostgreSQL SQL statement like:
private SqlStr as String
EmployeeId = "ef8ba4b3-7898-4240-aa8f-a0586ed04fb7"
SqlStr = "select * from employee where employee_id=?"
Params = Array As Object(EmployeeId)
rs = SQL.ExecQuery2(SqlStr, Params)
This will throw an exception...