Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Product: Aqua Data Studio
Version: 12.0.0-beta-11
Build #: 29098
Build Date: 2012-Sep-05 09:42:55 AM
Operating Environment: Linux (3.2.0-29-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.7.0_06-b24
Memory: Max=3,819,634,688; Total=462,225,408; Free=201,867,896; CPUs=8
1. I get an exception while trying to connect to Sybase Anywhere Server Registrations 8, 9, 10 and 11 using Ubuntu 12.04 in ADS 12.0.0-beta-11
2. Able to connect using ADS 11.0 to the same Sybase Anywhere Server Registrations
3. Able to connect using Win Xp, Win 7 in 11.0 and 12.0
4. Able to connect using OSX in 11.0 and 12.0
Exception is
java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0TS: Truncation error trying to send \\...\\ .\\हिñçêČάй語简�?한\\.Cꐮ.
at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.handleSQLE(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.<init>(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.<init>(Unknown Source)
at com.sybase.jdbc4.jdbc.SybDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at \\...\\ .\\हिñçêČάй語简�?한\\.nͨ⡓ᝌꒆ.xw(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.nͨ⡓ᝌꒆ.getConnection(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.nͨ⡓ᝌꒆ.getConnection(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.eꅬ⣂ꂥꂰ this byte.process(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Cꐮᢁᡎꎚ.run(Unknown Source)
|
|
113 KB
|
|
32 KB
The problem does not occur with jConnect6 with binaries.
The problem does not occur with jConnect7 in development environment.
When connecting we do get this warning :
Warning: java.sql.SQLWarning: 010SL: Out-of-date metadata accessor information was found on this database. Ask your database administrator to load the latest scripts.
We might just need to update the jConnect scripts on the servers.
If you alter the server registration and click ok, the connection is established and the dialog closes.
In the schema tree if you right mouse click and "connect" it fails.
In the schema tree if you right mouse click and choose the Export Tool, the tool opens a connection and works.
The only difference seems to be that the Schema Tree->Connect spawns a thread. So, the problem seems to be specific to spawning a thread and connecting to Sybase Anywhere with jConnect7 on Ubuntu (that is pretty weird). It may just be a bug in the Linux JVM.
I've updated to the latest jConnect7 and the problem still exists. The problem also seems to be isolated to the binaries as in the Dev Env it works. Maybe obfuscation has an effect.
DevEnv : Ubuntu 12.04 - Java 1.7.0_06 - Works
DevEnv : Ubuntu 12.04 - Java 1.6.0_31 - Works
Binary : Ubuntu 12.04 - Java 1.7.0_06 - Does Not Work
Binary : Ubuntu 12.04 - Java 1.6.0_27 - Does Not Work
If you alter the server registration and click ok, the connection is established and the dialog closes.
In the schema tree if you right mouse click and "connect" it fails.
In the schema tree if you right mouse click and choose the Export Tool, the tool opens a connection and works.
The only difference seems to be that the Schema Tree->Connect spawns a thread. So, the problem seems to be specific to spawning a thread and connecting to Sybase Anywhere with jConnect7 on Ubuntu (that is pretty weird). It may just be a bug in the Linux JVM.
I've updated to the latest jConnect7 and the problem still exists. The problem also seems to be isolated to the binaries as in the Dev Env it works. Maybe obfuscation has an effect.
DevEnv : Ubuntu 12.04 - Java 1.7.0_06 - Works
DevEnv : Ubuntu 12.04 - Java 1.6.0_31 - Works
Binary : Ubuntu 12.04 - Java 1.7.0_06 - Does Not Work
Binary : Ubuntu 12.04 - Java 1.6.0_27 - Does Not Work
I have the same issues. Also for oracle, using java 1.6 wont connect, using java 1.7 does connect.
I have the same issues. Also for oracle, using java 1.6 wont connect, using java 1.7 does connect.
It seems that the jConnect7 drivers, when connecting to Sybase Anywhere, will try to send the name of the Thread class running when the connection is made. The default is the AWT Event Thread which works, but when we spawn our own thread, the name of the class is obfuscated and the driver chokes on it so it fails. I no longer obfuscate BackgroundThread.
It seems that the jConnect7 drivers, when connecting to Sybase Anywhere, will try to send the name of the Thread class running when the connection is made. The default is the AWT Event Thread which works, but when we spawn our own thread, the name of the class is obfuscated and the driver chokes on it so it fails. I no longer obfuscate BackgroundThread.
Occurs when trying to open a FluidShell connection to Sybase Anywhere in Ubuntu12.04 12.0.0-beta-54 and Build #: 29376 and Build Date: 2012-Sep-21 07:54:32 AM
Occurs when trying to open a FluidShell connection to Sybase Anywhere in Ubuntu12.04 12.0.0-beta-54 and Build #: 29376 and Build Date: 2012-Sep-21 07:54:32 AM
Issue #7528 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 12.0.0-beta-56 |
| No time estimate |
1 issue link |
relates to #7716
Issue #7716Sybase Anywhere Views - Edit in Table Data Editor gives Truncation Error |
The problem does not occur with jConnect6 with binaries.
The problem does not occur with jConnect7 in development environment.
When connecting we do get this warning :
Warning: java.sql.SQLWarning: 010SL: Out-of-date metadata accessor information was found on this database. Ask your database administrator to load the latest scripts.
We might just need to update the jConnect scripts on the servers.