Re: RE : problems with back-sql

["Pierangelo Masarati" <ando@sys-net.it>]

> Hi,
>
> Here are some corrections and remarks for ITS# 2639 to 2642.
>
> - ITS#2639 :
>         - oracle : a simple correction consists to add
> "has_ldap_info_dn_ru no" in the slapd.conf sample (that is what I have
> done for my tests):
> #######################################################################
> # sql database definitions
> #######################################################################
> database	sql
> suffix		"o=sql,c=RU"
> rootdn		"cn=root,o=sql,c=RU"
> rootpw		secret
> dbname		ldap_ora8
> dbuser		ldap
> dbpasswd	ldap
> subtree_cond	"UPPER(ldap_entries.dn) LIKE CONCAT('%',UPPER(?))"
> insentry_query	"INSERT INTO ldap_entries
> (id,dn,oc_map_id,parent,keyval) VALUES (ldap_entry_ids.nextval,?,?,?,?)"
> upper_func	UPPER
> has_ldap_info_dn_ru no
>         - mysql : add the definition of the sel_expr_u column in the
> ldap_attr_mappings table definition, in backsql_create.sql :
> create table ldap_attr_mappings
>  (
> 	id integer unsigned not null primary key auto_increment,
> 	oc_map_id integer unsigned not null references
> ldap_oc_mappings(id),
> 	name varchar(255) not null,
> 	sel_expr varchar(255) not null,
> 	sel_expr_u varchar(255) not null,
> 	from_tbls varchar(255) not null,
> 	join_where varchar(255),
> 	add_proc varchar(255),
> 	delete_proc varchar(255),
> 	param_order tinyint not null,
> 	expect_return tinyint not null
> );

I'll fix this ASAP

> - ITS#2640 : tested, OK.

Fine

> - ITS#2641 : I think this is the same kind of problem as ITS#2568
> (SQLBindParameter + SQLExecDirect instead of SQLPrepare +
> SQLBindParameter + SQLExecute). This problem occurs several times in the
> code, I need some time to fix them all.

I found that older ITS, you possibly gave more precise
indications, so I might be able to trace the bug myself;
however, the last time I was playing with back-sql (when
porting it to 2.1) the modify/add/delete routines were
working, at least with psotgresql and IBM db2, how can
this be an oracle only problem?  Needs investigation.

> - ITS#2642 :  tested, OK, though another problem occurs later in
> backsql_count_children(), in the call to backsql_bindRowAsStrings() (I
> have to investigate this problem more).

I'll also look at it.

p.

-- 
Pierangelo Masarati
mailto:pierangelo.masarati@sys-net.it