Hello,
On 9.1 we had an application using AxlSqlToolkit , working just fine.
I'm trying to get it working after migration to 11.5, but have some issues with it.
I have downloaded and installed the new AxlSqlToolkit from 11.5,
for start I'm trying this simple query:
<?xml version="1.0" encoding="UTF-8"?>
<!--DTD generated by XMLSPY v5 rel. 4 U (http://www.xmlspy.com)-->
<!DOCTYPE data [
<!ELEMENT data (sql+)>
<!ELEMENT sql EMPTY>
<!ATTLIST sql
query CDATA #IMPLIED
update CDATA #IMPLIED
>
]>
<data>
<sql query="SELECT * FROM personalphonebook WHERE fkenduser=(SELECT pkid FROM enduser WHERE userid='CustomerDir')"/>
</data>
For this I'm calling
java -cp ./classes:./lib/saaj-api.jar:./lib/saaj-impl.jar:./lib/mail.jar:./lib/activation.jar:./lib/jaxm-api.jar:./lib/jaxm-runtime.jar:./lib/xercesImpl.jar:./lib/xml-apis.jar AxlSqlToolkit ,
with parameters like
-host=$hostip -username=$uid -password=$pw \
-input=$inputfile -output=$outputfile
and I'm getting this in return:
---------------------------- SELECT * FROM personalphonebook WHERE fkenduser=(SELECT pkid FROM enduser WHERE userid='CustomerDir') ----------------------------
<?xml version="1.0" encoding="UTF-8" standalone="no"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Client</faultcode><faultstring>Incorrect password or user com.informix.asf.IfxASFRemoteException: dbaxlreadonly@lu00pvc01i901fm is not known on the database server.</faultstring><detail><axlError><axlcode>-951</axlcode><axlmessage>Incorrect password or user com.informix.asf.IfxASFRemoteException: dbaxlreadonly@lu00pvc01i901fm is not known on the database server.</axlmessage><request>executeSQLQuery</request></axlError></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>
The hostname lu00pvc01i901fm corresponds to the host IP, that I'm supplying in parameter.
Can anyone help ?
Thank you in advance.