Comments for I'd rather play golf

Comment on NHibernate 3.3.0CR1 released by Glenn Paulley, Director, Engineering

Glenn Paulley, Director, Engineering — Tue, 15 May 2012 14:08:35 +0000

This problem has been identified as a compatibility issue between the 12.0.1 .NET provider and ASA 9, where the provider is casting strings to NVARCHAR but ASA 9, being much older, does not support national character sets using the NCHAR or NVARCHAR syntax. Complete details of this issue can be found in the SQL Anywhere online forum in this article.

Comment on SQL/RPR available for initial public review by Glenn Paulley, Director, Engineering

Glenn Paulley, Director, Engineering — Tue, 15 May 2012 10:54:20 +0000

This blog isn’t a technical support forum. I suggest you contact IQ technical support to assist you with your performance problem.

Comment on SQL/RPR available for initial public review by Anil

Anil — Tue, 15 May 2012 08:32:45 +0000

I am trying to load data from falt file source to Sybase IQ 15.1 destination using SSIS 2008. I am using ADO.NET destination component with Sybase IQ ODBC data provider to connect to the Sybase IQ db. Though the package is able to load the data, performance of the package is extremely slow. Its just loading 150 rows per minute. I am executing the package through SQL Server Agent. There are no data transformations in the package. Can any one please tell me how can i improve the performance?

Thanks in advance

Comment on SQL/RPR available for initial public review by Breck Carter

Breck Carter — Sat, 12 May 2012 13:48:54 +0000

Are you sure you should be talking about this? Will everything you say end up in Bluffdale, Utah?

“The NSA Is Building the Country’s Biggest Spy Center (Watch What You Say)”

http://www.wired.com/threatlevel/2012/03/ff_nsadatacenter/all/1

…that, together with THIS blog comment, may get you on the no-fly list

Comment on NHibernate 3.3.0CR1 released by Wayne

Wayne — Fri, 04 May 2012 02:52:54 +0000

Hi Glenn,

I have recently begun using NHibernate. I am using NHibernate-3.3.0.GA, SybaseSQLAnywhere12Driver, SybaseSQLAnywhere12Dialect, and iAnywhere.Data.SQLAnywhere.v4.0. Everything seems to work just fine until I try to use the Criteria functionality on a property of type String. When I do so, I get the below error message. No error occurs when I use the Criteria functionality on an Int property.

2012-05-03 08:48:49,697 ERROR Could not execute query: select counterpar0_.ID as ID6_, counterpar0_.CounterpartyCode as CounterpartyCode6_, counterpar0_.CounterpartyName as CounterpartyName6_ from Counterparty counterpar0_ where counterpar0_.CounterpartyCode=?
iAnywhere.Data.SQLAnywhere.SAException (0×80004005): Communication error
at iAnywhere.Data.SQLAnywhere.SACommand._ExecuteReader(CommandBehavior commandBehavior, Boolean isExecuteScalar, Boolean isBeginExecuteReader)
at iAnywhere.Data.SQLAnywhere.SACommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) in C:\OpenSource\NHibernate-3.3.0.GA-src\src\NHibernate\AdoNet\AbstractBatcher.cs:line 223

Comment on Whitepapers by Sybase - SQL Anywhere Performance – “How can I make it faster?” | Rows and Columns

Mon, 06 Feb 2012 15:07:27 +0000

[...] place to start learning about various aspects of performance is with some of the papers listed on Glenn Paulley’s blog, and from our webcast [...]

Comment on The state of TPC-E – part deux by pwehland

pwehland — Mon, 23 Jan 2012 12:12:31 +0000

Here we are 3+ years since your post and still not a TPC-E result from Sybase. (nor Oracle, nor IBM).

In those 3+ years have you developed any TPC-E expertise within Sybase?

Comment on SQL:2011 is published by Volker Barth

Volker Barth — Tue, 10 Jan 2012 16:13:54 +0000

@Breck: In case there are some Deutschmarks lying around as well – just wait and see:)

Volker, Euro-Zone-based

Comment on Reverse engineering SQL Anywhere with Hibernate Tools – part trois by Kiruthika

Kiruthika — Fri, 30 Dec 2011 11:07:09 +0000

Good one, it helped me in selecting few specific tables during reverse engineering.
Thanks for putting this up

Comment on Differences between jConnect and the iAnywhere JDBC driver – part trois by Rajkumar.D

Rajkumar.D — Thu, 29 Dec 2011 10:35:10 +0000

Hi,

I am getting the below error frequently in SUP server log. Please help me.

2011-12-20 13:54:05.535 ERROR DataServices Thread-150 [com.sybase.vader.mms.DataServiceImpl] a64c7500-2724-11e1-8000-ed14ad8bfe39 13366 d1_mbowfm.2_0 (Thread-150) com.sybase.vader.mms.DataServiceImpl::throwDSException:171 – SUP error code = 503
2011-12-20 13:54:05.535 ERROR MMS Thread-150 [com.sybase.djc.log.SystemExceptionLog] com.sybase.dataservices.DSException was thrown by transaction com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*\ncom.sybase.dataservices.DSException: com.sybase.djc.DataStoreException: Connection Failed: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
at com.sybase.vader.da.jdbc.JdbcDSExceptionBuilder.newDSException(JdbcDSExceptionBuilder.java:64)
at com.sybase.vader.da.jdbc.JdbcRootInteractionOperation.execute(JdbcRootInteractionOperation.java:136)