permaculture playing cards*
The moose likes JDBC and the fly likes Sybase Procedure and Driver problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Sybase Procedure and Driver problem" Watch "Sybase Procedure and Driver problem" New topic

Sybase Procedure and Driver problem

vijay yadav

Joined: Aug 20, 2007
Posts: 8
I am a salient member of this forum.
I am using Sybase as database on Linux.
Can any body sugget me Best JDBC driver for Sybase.
And i am getting one problem while creating below procedure.
i have given Procedure and Error i am getting.


1. create procedure sp_tktdetailsinsert (@tktno nvarchar(50), @priority nvarchar(10), @phno nvarchar(50), @subject nvarchar(50),

@details nvarchar(50), @strdate nvarchar(50), @email nvarchar(50), @status nvarchar(50), @repliedby nvarchar(50), @file1 image,

@filename varchar(50), @filesize numeric) as
insert into ticketdetails (ticketid, priority, phonenumber, subject, details, tktdate, emailid, status,

repliedby, file1, filename1, filesize1) values (@tktno, @priority, @phno, @subject, @details, @strdate, @email, @status, @repliedby,

@file1, @filename, @filesize)


Could not execute statement TEXT, and UNITEXT datatypes are invalid for parameters or local variables
Sybse error code=2739,SQLState="ZZZZZ"

Vijay Kumar.
I agree. Here's the link:
subject: Sybase Procedure and Driver problem
Similar Threads
with Java: how to update a row in sybase with string having a single quote
JDBC Error MSSQL Uniqueidentifier
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
Type 2 and Type 4 Drivers for DB2
how to use logic:iterator tag inorder to iterate ArrayList consisting of HashMap