Hi people!

I'm developping a JDBC connector between idm and Oracle database using
JDBC connector.
I have problems when I lunch SQL queries to my database, result is not
correct!!

For example if I lunch this select :
select id_usuario as "IdUsuari by mail" from aa_usuaris2 where
id_atributo='4' and valor='Usuari001@mail.com'

DirXML code :

<nds dtdversion=\"3.5\" ndsversion=\"8.x\">
<source>
<product version=\"3.5.1.20070411 \">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<jdbc:statement event-id=\"0\" jdbc:type=\"query\"
xmlns:jdbc=\"urn:dirxml:jdbc\">
<jdbc:sql>select id_usuario as \"IdUsuari by mail\" from
aa_usuaris2 where id_atributo='4' and
valor='Usuari001@mail.com'</jdbc:sql>
</jdbc:statement>
</input>
</nds>

And result is :

[01/13/09 08:34:47.445]:Oracle-test ST:BEGIN Set
transaction isolation level.
[01/13/09 08:34:47.445]:Oracle-test ST:END Set transaction isolation
level.
[01/13/09 08:34:47.454]:Oracle-test ST:select id_usuario as \"IdUsuari
by mail\" from aa_usuaris2 where id_atributo='4' and
valor='Usuari001@mail.com'
[01/13/09 08:34:47.468]:Oracle-test ST: RS field 'IDUSUARI BY MAIL',
length: 2, value = '41'
[01/13/09 08:34:47.474]:Oracle-test ST:SubscriptionShim.execute()
returned:
[01/13/09 08:34:47.475]:Oracle-test ST:
<nds dtdversion=\"2.0\" ndsversion=\"8.x\"
xmlns:jdbc=\"urn:dirxml:jdbc\">
<source>
<product build=\"20070301_0610\" instance=\"Oracle-test\"
version=\"3.5.0\">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level=\"warning\">Unable to determine whether retrieval of
auto-generated keys is supported. Defaulting to false.</status>
<jdbc:result-set event-id=\"0\" jdbc:number-of-rows=\"1\">
<jdbc:row jdbc:number=\"1\">
<jdbc:column jdbc:name=\"IdUsuari by mail\" jdbcosition=\"1\"
jdbc:type=\"java.sql.Types.NUMERIC\">
<jdbc:value>41</jdbc:value>
</jdbc:column>
</jdbc:row>
</jdbc:result-set>
<status event-id=\"0\" level=\"success\"/>
</output>
</nds>

The result must be 0 ( doesn't exist )

The same with other sql query, that must return 5 and return 48

Any idea ?

Thanks 4 all and sorry for my english!


--
arturnebot
------------------------------------------------------------------------
arturnebot's Profile: http://forums.novell.com/member.php?userid=26694
View this thread: http://forums.novell.com/showthread.php?t=356611