oracle - Accessing XML using XQuery (within XQJ code) from a column in database table -


i have created following table in locally installed oracle database :-

create table "system"."warehouses"     (    "warehouse_id" number not null enable,      "warehouse_spec" clob,       constraint "warehouses_pk" primary key ("warehouse_id");

it 4 rows primary keys 1,2,3 , 4.

now have written following java code access "warehouse_spec" column (which contains xml file every row) :-

import oracle.xml.xquery.xqjdb.oxqddatasource;  import javax.xml.xquery.xqitemtype; import javax.xml.xquery.xqresultsequence; import javax.xml.xquery.xqconnection; import javax.xml.xquery.xqpreparedexpression; import javax.xml.namespace.qname;  public class accessdata {     public static void main(string argv[])     {         try         {             oxqddatasource oxqds = new oxqddatasource();             oxqds.setproperty("driver", "jdbc:oracle:thin");             oxqds.setproperty("dbusername", "system");             oxqds.setproperty("dbpassword", "pwd");             oxqds.setproperty("dbserver", "localhost");             oxqds.setproperty("dbport", "1521");             oxqds.setproperty("servicename", "xe");             xqconnection conn = oxqds.getconnection();             xqitemtype  itemtypeint = conn.createatomictype(xqitemtype.xqbasetype_int);             xqpreparedexpression expr = conn.prepareexpression("declare variable $x xs:int external; $i in fn:collection('oradb:/mydb/warehouses') $i/row/warehouse_id < $x return $i/row/warehouse_spec/warehouse");             expr.bindint(new qname("x"), 3, itemtypeint);             xqresultsequence xqseq = expr.executequery();             while (xqseq.next()) {                 system.out.println(1);                 system.out.println (xqseq.getitemasstring(null));             }         }         catch (exception e)         {             e.printstacktrace();         }     } }

here, "mydb" database schema , "warehouses" table name.

the code should return 2 rows primary keys 1 , 2, instead, unable find table, , giving following error :-

javax.xml.xquery.xqexception: java.sql.sqlexception: ora-00942: table or view not exist      @ oracle.xml.xquery.xqjimpl.oxqdsequence.next(oxqdsequence.java:421)     @ example1.main(accessdata.java:33) caused by: java.lang.runtimeexception: java.sql.sqlexception: ora-00942: table or view not exist      @ oracle.xml.xquery.xqjimpl.xqjdbinfrastructure.oxqdxdbconnexpr.prepare(oxqdxdbconnexpr.java:367)     @ oracle.xml.xquery.xqjimpl.xqjdbinfrastructure.oxqdxdbconnexpr.access$000(oxqdxdbconnexpr.java:102)     @ oracle.xml.xquery.xqjimpl.xqjdbinfrastructure.oxqdxdbconnexpr$xdbconniterator.restart(oxqdxdbconnexpr.java:808)     @ oracle.xml.xquery.xqjimpl.xqjdbinfrastructure.oxqdxquerysequence.next(oxqdxquerysequence.java:127)     @ oracle.xml.xquery.xqjimpl.oxqdsequence.next(oxqdsequence.java:386)     ... 1 more caused by: java.sql.sqlexception: ora-00942: table or view not exist      @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:112)     @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:331)     @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:288)     @ oracle.jdbc.driver.t4c8oall.receive(t4c8oall.java:745)     @ oracle.jdbc.driver.t4cpreparedstatement.dooall8(t4cpreparedstatement.java:219)     @ oracle.jdbc.driver.t4cpreparedstatement.executefordescribe(t4cpreparedstatement.java:813)     @ oracle.jdbc.driver.oraclestatement.executemaybedescribe(oraclestatement.java:1049)     @ oracle.jdbc.driver.t4cpreparedstatement.executemaybedescribe(t4cpreparedstatement.java:854)     @ oracle.jdbc.driver.oraclestatement.doexecutewithtimeout(oraclestatement.java:1154)     @ oracle.jdbc.driver.oraclepreparedstatement.executeinternal(oraclepreparedstatement.java:3370)     @ oracle.jdbc.driver.oraclepreparedstatement.executequery(oraclepreparedstatement.java:3415)     @ oracle.xml.xquery.xqjimpl.xqjdbinfrastructure.oxqdxdbconnexpr.prepare(oxqdxdbconnexpr.java:351)     ... 5 more

am doing wrong here ?


-

Comments

Post a Comment

Popular posts from this blog

serialization - Convert Any type in scala to Array[Byte] and back -

i have following question: i have variable value in program declared value. i want convert value byte array.. how can serialize byte array , back? found examples related other types such double or int, not any. this should need. it's pretty similar how 1 in java. import java.io.{bytearrayinputstream, bytearrayoutputstream, objectinputstream, objectoutputstream} object serialization extends app { def serialise(value: any): array[byte] = { val stream: bytearrayoutputstream = new bytearrayoutputstream() val oos = new objectoutputstream(stream) oos.writeobject(value) oos.close stream.tobytearray } def deserialise(bytes: array[byte]): = { val ois = new objectinputstream(new bytearrayinputstream(bytes)) val value = ois.readobject ois.close value } println(deserialise(serialise("my test"))) println(deserialise(serialise(list(1)))) println(deserialise(serialise(map(1 -> 2)))) println(deserialise(seri
Read more

matplotlib support failed in PyCharm on OSX -

any idea how fix ? how can debug might problem ? not seem : https://youtrack.jetbrains.com/issue/py-15520 i in console: python 2.6.9 (unknown, jul 14 2015, 19:46:31) [gcc 4.2.1 compatible apple llvm 6.0 (clang-600.0.39)] on darwin >>> import matplotlib.pyplot plt matplotlib support failed the backend : >>> import matplotlib >>> print(matplotlib.rcparams['backend']) macosx
Read more

python - Matplotlib: TypeError: 'AxesSubplot' object is not callable -

i new programming please pardon me if rookie mistake. i writing python script have defined functions create subplots of distributions. i have slider widget end user change value of variables(mu , sigma) , see effect on distribution. here's code import numpy np print np.__version__ import scipy print scipy.__version__ scipy.stats import norm, lognorm, uniform import matplotlib print matplotlib.__version__ import matplotlib.pyplot plt matplotlib.widgets import slider, button, radiobuttons, checkbuttons #####calculating mean , standard deviation##### global mu_a1 mu_a1 = 1 global mu_b1 mu_b1 = 10 global mu_c1 mu_c1 = -13 global sigma_a1 sigma_a1 = 0.14 global sigma_b1 sigma_b1 = 1.16 global sigma_c1 sigma_c1 = 2.87 mu_x01 = -11 sigma_x01 = 1.9 #####_____##### #####generating random data##### a1 = 0.75*mu_a1 + (1.25 - 0.75)*sigma_a1*np.random.sample(10000) b1 = 8*mu_b1 + (12 - 8)*sigma_b1*np.random.sample(10000) c1 = -12*mu_c1 + 2*sigma_c1*np.random.sample(10000)
Read more