This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 and Relational Databases
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
It's not a secret anymore!