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
0
votes
0 answers
Hibernate Stored procedure Invalid Column Name Exception
I'm trying to solve an error of "Invalid Column Name Exception" after calling Stored Procedure from java with hibernate.
My Procedure select data from two tables, ari_immatricule , art_article. both of them has a column called code_art. but the…
StraightforwardDev
- 81
- 1
- 9
0
votes
1 answer
Java using Jconnect
Good day!
In order to access the mysql server, I used the JConnect and my code is as follows:
public AddBooks() {
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/catalog";
…
newbie
- 14,582
- 31
- 104
- 146
0
votes
0 answers
Can setFetchSize and setObject work together for jConnect driver?
I'm programing against a sybase IQ database, and get weird error when combining setFetchSize together with setObject.
sybase IQ server version: 16.0
jdbc driver: jconn4 16.0
java 8
Let's say we have following code snippet:
String sql = "SELECT *…
hero2008
- 611
- 6
- 16
0
votes
1 answer
c3p0 compatibility with jconnect 4
I am trying to upgrade from jconn2 to jconn4. The issue that i am facing is that c3p0 is notworking as expected. Quick online search says that it supports jconn4 completely, but i get the below exception.
com.sybase.jdbc4.jdbc.SybSQLException: SQL…
Prateek
- 35
- 1
- 7
0
votes
1 answer
Wildfly 10.1 MySQL Driver in Domain mode installation
It seems there is a bug of some sort regarding the installation of a the mysql jconnector driver for wildfly domain mode. In wildfly standalone all is fine. Tried it in wildfly 9 as well - same results.
Anyway, managed to get it working, after so…
hrs
- 379
- 4
- 12
0
votes
2 answers
Query with column called "date" in SQL Anywhere 11
I have a table on a SQL Anywhere 11 DB where one of the columns is called "date". I am using jconnect JDBC drivers to connect to the DB from my Java code. I have quoted the "date" column with double quotes as shown below.
SELECT inv."date" FROM…
Parikshit Iyengar
- 37
- 6
0
votes
1 answer
Connector/J error after upgrade mysql to version 8
Problem:
I upgraded mysql to newest version:
127.0.0.1$ mysql -V
mysql Ver 14.14 Distrib 8.0.0-dmr, for Linux (x86_64) using EditLine wrapper
Now I cannot connect with mysql by jdbc using driver connector/j in program mathematica. When I am…
Daniel
- 7,684
- 7
- 52
- 76
0
votes
1 answer
NullPointerException thrown with Spring boot application when jconn4.jar is added in the build path
I'm new to Spring boot and I'm trying to use it to develop a web application.As I need to connect to a Sybase database in my app, I have to include jconn4.jar in my build path. However I keep getting below NullPointerException right after I added…
Alice
- 21
- 5
0
votes
1 answer
"Invalid SQL statement or JDBC escape, terminating '}' not found." with jTDS and Sybase
I'm calling a stored procedure via ibatis. It works, and has worked, when using the jconn2.jar (5.5). When I swap it out for the jtds jar (1.2.5) I get an exception "Invalid SQL statement or JDBC escape, terminating '}' not found."
For more…
Spencer Kormos
- 8,381
- 3
- 28
- 45
0
votes
2 answers
Sybase SQLAnywhere jConnect routines?
I have a database which is part of a closed system and the end-user of the system would like me to write some reports using the data contains in a Sybase SQL Anywhere Database. The system doesn't provide the reports that they are looking for, but…
jr.
- 4,503
- 7
- 44
- 62
0
votes
3 answers
NullPointerException at while(rs.next())
I have a simple program that executes a query agains a Sybase ASE DB using jconnect6 .
the program throws a NullPointerException after iterating for 603 records of the ResultSet
public ResultSet exec()
{
ResultSet rs = null;
try {
…
Amr Nassar
- 155
- 2
- 9
0
votes
1 answer
using readXML into a JCO.table after the XML was created using JCO
I created a JCO.table and transformed it into XML using myTable.writeXML (JCO method)
now I'm trying to re-load the XML into a JCO.table and work with the table created from the XML.
I tried to use myNewTable.readXML (another JCO method) but I need…
me.
- 1
- 1
0
votes
1 answer
Cannot store binary files with JPA and Sybase ASE
A user should be able to change the contents of an entity which contains a byte array, mapped to an image column in the DB. Please note that I cannot use LOB functionality, since Sybase does not support it.
When when I try to persist or merge the…
kostja
- 60,521
- 48
- 179
- 224
0
votes
1 answer
jConnect4 pooled connection does not work as documented
Official Sybase jConnect Programmers Reference suggests following way to use pooled connections:
SybConnectionPoolDataSource connectionPoolDataSource = new SybConnectionPoolDataSource();
...
Connection ds =…
user2260755
- 51
- 3
0
votes
1 answer
Error inserting in remote table using jconnect
When I do a insert in a remote tabke using jconnect it gives me the following error:
Unexpected exception : java.sql.SQLException: This transaction has been rolled back, rather than only the current statement.
, sqlstate =…
aF.
- 64,980
- 43
- 135
- 198