THIS PROBLEM ONLY RELATES TO SYBASE, NOT E.G. MS SQL SERVER and this problem has lower priority for me
Hello, I created linked table to Sybase Adaptive Server 12.5.x running on AIX OS as CREATE LINKED TABLE IF NOT EXISTS local_XXX(...) READONLY Nice, created without errors. Then I run command SELECT TOP 10 * FROM local_XXX Nice, result is as I expect. But when I try to run the second time this identical select, it frozes without answer and exception. Even shutdown of H2 is unsuccessfull. So it looks like H2 hangs completely. When I kill H2 process and start it again, I am able to do again only one select (link is already created from the first run), the second identical select again freezes. I am starting H2 as %JAVA% -Xmx512m -classpath %LIB% org.h2.tools.Server -tcp - tcpAllowOthers -tcpPort 9093 -tcpPassword "password" -baseDir ./ databaseData -ifExists and I am using the latest H2 1.1.107 and I am connection to H2 using SQuirreL 2.6.4 with local copy of H2 1.1.107 as JDBC driver - it is my usual way of interactive working with H2 untill now without such problems. All on Sun Java 1.6.0_10-b33 and MS Windows 2000. But if I do the same but connected to MS SQL Server 2005 (both Sybase and MS SQL Server are remote servers accessed by the same JDBC jTDS driver 1.2.2) all is OK as expected. Has someone any hint, why this error with Sybase occurs? I know, that Sybase is not mainstream detabase and 12.5.x is out-of-date, but if someone using Sybase 12.5.x can try it, it would be nice to now it. Otherwise, this is at least notice, that this problem can exist. Stepan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
