XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Mihai  FrimuSubject: My table crashes java Runtime
Author: Mihai Frimu
Date: 02 Mar 2009 05:45 PM
Originally Posted: 02 Mar 2009 05:31 PM
Hello,

When I click on a particular table and select Read Structure the Java Runtime crashes. Of course it is one of the two tables I need to use, and of course other 4 tables work fine. Some tables don't get any results when the Read Structure is invoked.

Why such eratic behaviour.

Dissapointed...

Michael



JAVA VERSION:
1.6.0_12 Java HotSpot(TM) Client VM Sun Microsystems Inc.
debug mode port:8000

ERROR:
------
com.ddtek.xquery3.XQException: [DataDirect][XQuery]Error getting metadata from the database: [XQuery][SQLServer JDBC Driver]Error writing data to client-side row cache. Verify that the directory specified by the java.io.tmpdir property exists and the current user has permission to read from and write to that directory..
--
java.lang.RuntimeException: com.ddtek.xquery3.XQException: [DataDirect][XQuery]Error getting metadata from the database: [XQuery][SQLServer JDBC Driver]Error writing data to client-side row cache. Verify that the directory specified by the java.io.tmpdir property exists and the current user has permission to read from and write to that directory..

at com.stylusstudio.DDXQFileSystem$DDXQFile.runQuery(DDXQFileSystem.java:371)

at com.stylusstudio.DDXQFileSystem$DDXQFile.getInputStream(DDXQFileSystem.java:379)

Caused by: com.ddtek.xquery3.XQException: [DataDirect][XQuery]Error getting metadata from the database: [XQuery][SQLServer JDBC Driver]Error writing data to client-side row cache. Verify that the directory specified by the java.io.tmpdir property exists and the current user has permission to read from and write to that directory..

at com.ddtek.xquery3.xqj.Util.createXQException(Util.java:238)

at com.ddtek.xquery3.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:519)

at com.ddtek.xquery3.xqj.DDXQExpression._executeQuery(DDXQExpression.java:96)

at com.ddtek.xquery3.xqj.DDXQExpression.executeQuery(DDXQExpression.java:117)

at com.stylusstudio.DDXQFileSystem$DDXQFile.runQuery(DDXQFileSystem.java:368)

... 1 more

Caused by: com.ddtek.xquery.util.XQueryException: [EX6020][DataDirect][XQuery]Error getting metadata from the database: [XQuery][SQLServer JDBC Driver]Error writing data to client-side row cache. Verify that the directory specified by the java.io.tmpdir property exists and the current user has permission to read from and write to that directory..

at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.getBestRowIdentifier(ExtractorMetaData.java:2289)

at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.lookupTableDescription(ExtractorMetaData.java:1242)

at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.lookupTables(ExtractorMetaData.java:910)

at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.getCollectionsFromStaticContext(ExtractorMetaData.java:258)

at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.syncStaticContext(ExtractorMetaData.java:211)

at com.ddtek.xquery.mediator.metadata.MediatorMetaData.syncStaticContext(MediatorMetaData.java:81)

at com.ddtek.xquery.mediator.ContextFactory.prepareQuery(ContextFactory.java:236)

at com.ddtek.xquery3.xqj.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:512)

... 4 more

Caused by: java.sql.SQLException: [XQuery][SQLServer JDBC Driver]Error writing data to client-side row cache. Verify that the directory specified by the java.io.tmpdir property exists and the current user has permission to read from and write to that directory.

at com.ddtek.xquery.jdbc.sqlserverbase.BaseStatement.postProcessExceptionFromCommonExecute(Unknown Source)

at com.ddtek.xquery.jdbc.sqlserverbase.BaseStatement.commonGetNextResultSet(Unknown Source)

at com.ddtek.xquery.jdbc.sqlserverbase.BaseStatement.executeQueryInternal(Unknown Source)

at com.ddtek.xquery.jdbc.sqlserverbase.BaseStatement.executeDatabaseMetaDataQuery(Unknown Source)

at com.ddtek.xquery.jdbc.sqlserverbase.BaseDatabaseMetaData.getBestRowIdentifier(Unknown Source)

at com.ddtek.xquery.extractor.metadata.ExtractorMetaData.getBestRowIdentifier(ExtractorMetaData.java:2283)

... 11 more

Postnext
Tony LavinioSubject: My table crashes java Runtime
Author: Tony Lavinio
Date: 02 Mar 2009 06:22 PM
Could you tell us please which version of Stylus Studio you are using?
You can get the version and build number from Help > About.

Postnext
Mihai  FrimuSubject: My table crashes java Runtime
Author: Mihai Frimu
Date: 03 Mar 2009 07:28 AM
Just downloaded the Trial from your website. The only thing I thought about is that I'm connecting to a MS SQL 2008 server. However the table that crashes Stylus is nothing special...

Thanks,

Mihai

Postnext
Ivan PedruzziSubject: My table crashes java Runtime
Author: Ivan Pedruzzi
Date: 04 Mar 2009 11:33 AM
Hi Mihai,

What happens if you drag & drop this table into the XQuery XML to XML mapping source panel?
Are you able to see the columns there?

Which OS are you running?

Do you have sufficient privileges to create temp files in the windows temp directory?

Ivan Pedruzzi
Stylus Studio Team

Posttop
Ivan PedruzziSubject: My table crashes java Runtime
Author: Ivan Pedruzzi
Date: 04 Mar 2009 03:08 PM

Could you please confirm that the tables affected make use of nvarchar type in a primary key?

Thanks!
Ivan Pedruzzi
Stylus Studio Team

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.