- BaseX-Talk - mailman.uni-konstanz.de

Re: [basex-talk] Seeking help on how to update XML file(INSERTION)
by Charles Foster 09 Dec '13

09 Dec '13

Hi Cong, BaseX XQJ supports XQuery 3.0, XQuery Update Facility as well as XQuery Full Text. If you are executing an XQuery Update expression and the BaseX XQJ driver is producing an XQException where BaseX was never even contacted in the first place, then this is a bug in BaseX XQJ. Bugs found in any XQJ driver from xqj.net can be reported at: http://xqj.net/issues To find out for sure, I would suggest turning debug mode to its highest level, with code along the lines of: XQDataSource ds = new BaseXXQDataSource(); ds.setProperty("logLevel", "TRACE"); ds.setLogWriter(new PrintWriter(System.out, true)); XQConnection xqc = ds.getConnection(); /** execute your update expression **/ Regarding the second problem, to make sure your XQResultSequences produced from an XQConnection instance is scrollable, you could use: XQConnection xqc = ds.getConnection(); XQStaticContext xqsc = xqc.getStaticContext(); xqsc.setScrollability(XQConstants.SCROLLTYPE_SCROLLABLE); xqc.setStaticContext(xqsc); /** execute expressions via xqc **/ Alternatively, you can create a scrollable copy of any type of XQSequence via the createSequence method, for instance: XQResultSequence rs = executeQuery(); XQSequence scrollableCopy = xqc.createSequence(rs); Hope this helps. Kind Regards, Charles > ---------- Forwarded message ---------- > From: Liu Cong <p5j6npaa(a)126.com> > Date: Sat, Dec 7, 2013 at 8:23 PM > Subject: [basex-talk] Seeking help on how to update XML file(INSERTION) > To: basex-talk(a)mailman.uni-konstanz.de > > > Hi all, > > Nice to be in this community! > > We are currently doing a project on XML database using BaseX and using > XQJ API to develop it in eclipse. What troubled us now is that when we > doing an insertion or deletion, there is actually nothing changed in > the XML file. Then I checked that it seems that XQJ is not available > to XQuery update. Is it really like that? Otherwise, how can we write > or delete things in the XML file? > > Another problem: when we want to show what has been changed for the > cached XML file, I get this notification: > '' > According to the XQJ 1.0 Specification, executing expressions via > XQPreparedExpression or XQExpression implicitly closes the previously > created XQResultSequence object which was tied to the parent > XQConnection object. > To keep a XQResultSequence alive and accessible, you could either > create an immutable XQSequence by using > XQConnection.createSequence(XQResultSequence) or modify the > XQStaticContext's Scrollability property to ensure that future > XQResultSequence objects will be "SCROLLABLE" (cached) and not > "FORWARD_ONLY" (streamed). > Please read the XQJ.NET documentation for further details.' > > I understand what does it mean but do not quite understand how to use > XQConnection.createSequence(XQResultSequence) or modify the > XQStaticContext's Scrollability property. Could you kindly give me > some guidance on that? > > My code is like:" > XQPreparedExpression aaa =xqc.prepareExpression(.......); > XQPreparedExpression bbb =xqc.prepareExpression(.......); > > XQResultSequence rs = aaa.executeQuery(); > XQResultSequence as = bbb.executeQuery(); > > while(rs.next()) > System.out.println(rs.getItemAsString(null)); > System.out.println(as.getItemAsString(null));" > > Many thanks! > > Cong Liu > > > > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk(a)mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >

1 0

Re: [basex-talk] PP PE and all kinds of excellent plastic material from gold supplier
by angelina＠andexintrade.com 09 Dec '13

09 Dec '13

Dear Purchase Manager, Good day! Pleased to know you. We get information from your website that you are producing plastic products. And,we are a professional Plastic raw material manufacturer. We are mainly dealing PP(Polypropylene) PE(Polyethylene ) PS(Polystyrene) and ABS and so on. Other product, please visit our website www.adx-trade.com. Also, many I know some information about you? 1) May I know do you have any new purchase plan recently? 2)If yes, how do you think of us?We ensure we will give you the best price. 3)If possible,What should we do to be your best supplier? Anyhow,we will be very pleased to receive your any reply. Wait for your any reply. Sorry to disturb you. Best regards Angelina WEB: www.adx-trade.com NAME: Qingdao andexin trading co.,ltd. EMAIL: angelina(a)andexintrade.com MSN: angelina-andexintrade(a)hotmail.com ADD: Licang District,Qingdao City,China POST code: 266000 TEL: 4000532314 FAX: 86-0532-80615882

1 0

欧美国家纯电池移动电源产品空运快递专家不需要任何电池文件
by jacky-msi 08 Dec '13

08 Dec '13

致所有带电池外贸朋友,合作伙伴：您好！我司是香港国际快递UPS, FEDEX，TNT等四大国际快递庄/香港空运一级代理,专业各种电池移动电源,以及含电池等产品拥有8年以上的操作经验，空运快递并以价格优惠多种渠道！保证安全快捷出口!同时拥有专业电池工厂的MSDS非危证明,. 无论你的电池包装是否合格，功率是否大于100W ，单个电池是否超过10KG .所有含电池，我司都可以正常出口，无需客户提供任何资料！无论你的包装是否合格，我司都可以出口，我司专业帮客户处理任何包装问题,重新按要求包装分折.准备齐全的电池标签,专业的各种规格电池包装盒，确保您的货物安全到达。欧美国家以超低价收货,安全时效有保证移动电源:欧洲,美国\加拿大\墨西哥 100KG 低至32RMB/KG 更多新加坡，泰国，马来西亚，韩国，日本，台湾专线，中东，非洲包装无任何限制，无论您是什么样的电池，单件超过10KG ,都可以直接出口！更多新加坡，泰国，马来西亚，韩国，日本，台湾专线，中东，非洲包装无任何限制，无论您是什么样的电池，单件超过10KG ,都可以直接出口！公司在华南地区珠三角拥有200多个收货,拥有6家直营分公司,150多专业销售人才,50位专客服人员,提供一对一操作服务 -- best regard contact:Jacky xiao M&S INTERNATIONAL FORWARDING LTD. ADD:RM903,9/FLOOR,239#ZHONGXING ROAD,LUOHU DISTRICT SHENZHEN CHINA TEL: 86-752-2118455 web :www.msi-air.com contact:Jacky xiao Mob:86-13829985609 FAX: 86-752-2118451 MSN:xgyuan5588@hotmail.com Email:jack@msi-air.com web:www.msi-air.com skype:xgyuan888 msn:xgyuan5588@hotmail.com QQ:188294360, QQ:1969322325, QQ:582011970,

1 0

Issue with backup
by John Best 08 Dec '13

08 Dec '13

Hi team, The backup have some problem... After taking multiple backups, all the previous backups get affected... Suppose, I took backup, say B1, then I made some changes and took another backup say B2.. Then the backup B1 is also getting affected... -- Have a nice day JBest

2 1

some questions over the profile module
by jean-marc Mercier 07 Dec '13

07 Dec '13

Hello Christian, I have some small questions over the profile module. 1) The following code declare function local:sequence($nb){for $i in 1 to xs:integer($nb) return $i}; prof:time(fn:count(local:sequence(1000000000000000000))) return 4.94 ms. It means that you lazy evaluate the query "{for $i in 1 to xs:integer($nb) return $i" ? (I recall that you already mentioned this point that but I would like a confirmation, since it might be a profiler issue) 2) It seems that you somehow call the fn:trace function in the profile module. Is there a way to catch the returned values of these functions ? The motivation is for profiling purposes. To be more specific, I would like to treat the output results as <output @function = "my_function">{prof:time( "xquery" ) }</output> to be able to aggregate results at a higher level of call, i.e. something like for $output in $prof//output let $fun := data($output/@function) group by $fun return element-name{$fun}{sum(data($output) ) } Thanks Jean-Marc

2 7

Seeking help on how to update XML file(INSERTION)
by Liu Cong 07 Dec '13

07 Dec '13

Hi all, Nice to be in this community! We are currently doing a project on XML database using BaseX and using XQJ API to develop it in eclipse. What troubled us now is that when we doing an insertion or deletion, there is actually nothing changed in the XML file. Then I checked that it seems that XQJ is not available to XQuery update. Is it really like that? Otherwise, how can we write or delete things in the XML file? Another problem: when we want to show what has been changed for the cached XML file, I get this notification: '' According to the XQJ 1.0 Specification, executing expressions via XQPreparedExpression or XQExpression implicitly closes the previously created XQResultSequence object which was tied to the parent XQConnection object. To keep a XQResultSequence alive and accessible, you could either create an immutable XQSequence by using XQConnection.createSequence(XQResultSequence) or modify the XQStaticContext's Scrollability property to ensure that future XQResultSequence objects will be "SCROLLABLE" (cached) and not "FORWARD_ONLY" (streamed). Please read the XQJ.NET documentation for further details.' I understand what does it mean but do not quite understand how to use XQConnection.createSequence(XQResultSequence) or modify the XQStaticContext's Scrollability property. Could you kindly give me some guidance on that? My code is like:" XQPreparedExpression aaa =xqc.prepareExpression(.......); XQPreparedExpression bbb =xqc.prepareExpression(.......); XQResultSequence rs = aaa.executeQuery(); XQResultSequence as = bbb.executeQuery(); while(rs.next()) System.out.println(rs.getItemAsString(null)); System.out.println(as.getItemAsString(null));" Many thanks! Cong Liu

1 0

BaseX Failing After a Number of Requests
by Jeremy Moseley 06 Dec '13

06 Dec '13

Hi Guys, We have implemented BaseX to provide a REST API to access specific information out of the database. Databases range in size from hundreds to 6000+ XML files, and the APIs use the attribute index to quickly locate nodes and return information about them. We have been noticing that BaseX has been randomly failing after a number of requests in the range of several hundred. I can replicate the failure in a few minutes by looping curl requests from the command line. The failure is made apparent by a valid request returning a Jetty 404 Error: HTTP ERROR 404 > > Problem accessing { redacted URL }. Reason: > > No function found that matches the request. > > ------------------------------ > *Powered by Jetty://* > This message is the same message that is thrown when requesting a URL that does not have a matching path, but this request is valid, and has been used before. It appears that the issue is the BaseX server failing somehow, but I can't track the reason. No information is logged at the time of the crash. If I connect to the BaseX server (on port 1984) using the basexclient, it connects, but reports that there are no databases available. Once I restart the service, I can reconnect, and it lists all databases as it should. Any ideas what might be causing these issues? Thanks, Jeremy

2 2

BaseX Evaluation for Big Data
by Huband, Gary W *HS 06 Dec '13

06 Dec '13

I'm evaluating BaseX to use in a project that involves 10s of TB of xml data. Our goal is to be able to return a small amount of data from a query within a few seconds. Is BaseX capable of handling this much data? My initial evaluation of 1GB of data met our requirements. But, when I evaluated BaseX using about 20GB of data I get an out of memory message when I run a query. I'm running Windows 7 Pro on a Core i7, 8GB memory, and using the BaseX GUI. Thanks for your time Gary

3 3

Re: [basex-talk] BaseX Evaluation for Big Data
by jean-marc Mercier 06 Dec '13

06 Dec '13

Hi Gary, Maybe you should wait for BaseX team members advises over this topic. Telling from my own experience, I can remember also having met some problem trying to insert 20 Gb of data into BaseX through the GUI. I had to achieve this into smaller steps, using batch commands (see http://docs.basex.org/wiki/Commands) in order to free memory. i.e. I first inserted the xml into 4 or 5 passes. Then created some indexes, etc...In that way it was possible to run the insertion, even with 4Gb machines. Hope this helps Jean-Marc 2013/12/6 Huband, Gary W *HS <GWH2SJ(a)hscmail.mcc.virginia.edu> > I still get an out of main memory when I try to create attribute indexes. > > I originally added the xml data with no indexes. > > Gary > > ________________________________ > From: jean-marc Mercier [jeanmarc.mercier(a)gmail.com] > Sent: Friday, December 06, 2013 9:37 AM > To: Huband, Gary W *HS > Cc: basex-talk(a)mailman.uni-konstanz.de > Subject: Re: [basex-talk] BaseX Evaluation for Big Data > > I meant I am NOT a baseX member ! sorry for the mistyping ! > > > 2013/12/6 jean-marc Mercier <jeanmarc.mercier(a)gmail.com<mailto: > jeanmarc.mercier(a)gmail.com>> > Hi Gary > > I am a BaseX team member, but have you sized up your JVM to run "Big Data" > ? > > See the files BaseX/basex*.bat. I am currently using set VM=-Xmx6g > > Hope this helps > > Jean-Marc > > > 2013/12/6 Huband, Gary W *HS <GWH2SJ(a)hscmail.mcc.virginia.edu<mailto: > GWH2SJ(a)hscmail.mcc.virginia.edu>> > > I'm evaluating BaseX to use in a project that involves 10s of TB of xml > data. Our goal is to be able to return a small amount of data from a query > within a few seconds. Is BaseX capable of handling this much data? > > My initial evaluation of 1GB of data met our requirements. But, when I > evaluated BaseX using about 20GB of data I get an out of memory message > when I run a query. > > I'm running Windows 7 Pro on a Core i7, 8GB memory, and using the BaseX > GUI. > > Thanks for your time > > Gary > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk(a)mailman.uni-konstanz.de<mailto: > BaseX-Talk(a)mailman.uni-konstanz.de> > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > > > >

1 1

Node Insertion through XQJ and XSD Validation
by Ando Roy 06 Dec '13

06 Dec '13

Greetings, I've just started reading through the materials on XQJ and would like to ask the following: Let's say I have a simple XML file (I'll use the W3Schools Xquery tutorial): 1. Can I have an example query of how I could insert another book node into this file? 2. If I would like to perform schema validation through XSD, how should I change the code? - eg. (if I have set the maxOccurs attribute set as 1), will XQJ throw some exception? <bookstore> <book category="COOKING"> <title lang="en">Everyday Italian</title> <author>Giada De Laurentiis</author> <year>2005</year> <price>30.00</price> </book> </bookstore> Regards, Roy

2 1