jConnect is the Sybase high-performance JDBC driver. Use this tag for questions about programming with Sybase jConnect, and a tag for the DBMS implementation (e.g. MySQL, PostgreSQL, Oracle, MS SQL Server, IBM DB2, etc.) being used with the jConnect driver.
Questions tagged [jconnect]
49 questions
7
votes
2 answers
issue while executing Sybase procedure from JDBC
While executing Sybase procedure from JDBC, I am getting below error:
Execute cursor is declared on a procedure which contains a non-SELECT
or a SELECT with COMPUTE clause. for the declaration of this cursor to
be legal it should have a single…
user3891270
- 371
- 1
- 3
- 7
6
votes
0 answers
Sybase throws Exception "there is already another cursor with the name XXX" when Executing SELECT Query in multi-threading environment
I am using ApacheMetaModel to Extract the data from Sybase ASE 15.5 database that installed on Windows 7 machine. I am Extracting data into CSV in multi-threading environment. I using these open source libraries
…
Ashish Pancholi
- 4,569
- 13
- 50
- 88
5
votes
3 answers
Sybase IN and OUT parameters
I'm going nuts about how the Sybase JDBC driver handles stored procedures with mixed IN and OUT parameters. Check out this simple stored procedure:
CREATE OR REPLACE PROCEDURE p (IN i1 INT, OUT o1 INT, IN i2 INT, OUT o2 INT)
BEGIN
set o1 = i1;
…
Lukas Eder
- 211,314
- 129
- 689
- 1,509
3
votes
2 answers
How to connect to Sybase ASE using JDBC driver and SSL connection
I'm trying to establish an SSL connection to a Sybase ASE 15.7 using JDBC driver with no luck.
I tried the following options:
Using JTDS 1.25 driver (jtds-1.2.5.jar)
With the following connection string:…
zuckermanori
- 1,675
- 5
- 22
- 31
2
votes
1 answer
JConn4 sybase jdbc driver much slower than JConn2
Recently I upgraded from JConn2 Sybase driver to JConn4. My Java jdbc code repeatedly calls a proc. Each proc call is ~1000 times slower with JConn4. JConn2 the avg is ~2ms. With JConn4 it is ~2s.
The proc is called via CallableStatement.
Does…
user2879770
- 23
- 4
2
votes
2 answers
Why doesn't MySQL JDBC use "Start transaction" query to start transactions?
I have a Java app which uses JTA(Apache Geronimo) to manage transactions. The database in use is MySQL. App has a lot of begin and commit methods. However looking at the MySQL general log I could not find a single "Start transaction" query/command.…
Kumar
- 5,038
- 7
- 39
- 51
2
votes
0 answers
Aqua data studio return wrong count affected rows
I connected to Sybase Ase 15.0.3 with Aqua Data Studio.
Data base has drive version:
installjdbc ---- jConnect (TM) for JDBC(TM)/7.00(Build 26502)/P/EBF17821/JDK16/Tue Apr 6 11:59:33 2010
ADS has driver:
jConnect (TM) for JDBC(TM)/16.0 PL01…
Dmitry
- 21
- 2
2
votes
5 answers
What is the maven repository for jconn4.jar?
jConn3 is the only one I can find.
'com.sybase.jdbc3.jdbc:jconn3:6.05'
Andrew Sumner
- 793
- 2
- 12
- 29
1
vote
0 answers
Not able to connect to sybase DB over TLS 1.2 using jConnect JDBC driver
I'm having issues to connect to a sybase DB using TLSv1.2. It throws error:
javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
If I remove "TLSv1, TLSv1.1" from param…
Ga-M
- 11
- 2
1
vote
1 answer
Java and Jconn4 support for Sybase 16.3
I have got a project wherein my database going to upgrade to /sybase 16.3 version. My current applications has the either jconn2 and Jconn4 dependencies to connect to current Sybase version.
Can anyone help me to cover following points:
Is…
Ashish Chauhan
- 486
- 2
- 8
- 22
1
vote
0 answers
How to connect Sybase ASE with JDBC and SSL connection?
I'm trying to establish an SSL connection to a Sybase ASE 16.0 using JDBC driver. On the server, through interactive SQL, I am able to access the ASE server with SSL. I am using Jconnect 4 (jconn4.jar) and JDK 8 with the following connection string:…
kush
- 79
- 2
- 11
1
vote
1 answer
Downloading 7.0.7 - jconn-7.0.7.jar
I am trying to download jconnect-7.0.7.jar for Sybase Database from this URL [http://downloads.sybase.com/][1]. But getting error like the site is down. I searched a lot, but cannot find the jar anywhere.
Could anyone let me know where I can get the…
Kavitha
- 185
- 1
- 4
- 14
1
vote
2 answers
Can't connect to MySQL in IntelliJ IDEA
I have this problem:
This issue (cannot find specified file) appeared when I updated IntelliJ IDEA to version 2017.3.2.
IntelliJ IDEA 2017.3.2 (Ultimate Edition)
Build #IU-173.4127.27, built on December 25, 2017
JRE: 1.8.0_152-release-1024-b8…
excelsiorious
- 422
- 9
- 18
1
vote
1 answer
Unable to update multiple records in Sybase database via jconn4.jar/Sybase driver version 7 & Mybatis framework
I am using Mybatis framework for database persistence, connecting to Sybase database via Jconn4.jar and deploying my app on JBOSS 7 application server.
1) Mybatis mapper - CustomerMapper.xml
Karthik
- 1,302
- 5
- 25
- 56
1
vote
2 answers
Stored procedure 'XXX' may be run only in unchained transaction mode error in JBOSS 7 server/JCONN driver4
I am currently migrating apps from JBOSS 5 to JBOSS 7.0.4. I have also changed the Sybase driver from Jconn3 to Jconn4 as part of migration. I am getting the below error while executing a Sybase procedure in JBoss 7 with jconn4.jar:
2017.05.26…
Karthik
- 1,302
- 5
- 25
- 56