java.sql.SQLException: Error converting data type nvarchar to numeric

We have an application server (j2ee) that access either Oracle or DB2 database through jdbc
I now try to configure it so that it can access a MS/SQL database.
I put jdbc driver I found (jtds), configure it
The application starts, can access the database (I have a client that can ask for data manipulation to my application server
Now some operation (I don't know precisely which one yet) cause this exception : java.sql.SQLException: Error converting data type nvarchar to numeric
I wonder if there may be some incompatibility with datatype or something like that
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

For nvarchar the java object is String and the JDBC type is VARCHAR, from the docs so treat them accordingly

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
You must look at your database schema and check what type each field is. Pay attention to your casting in your entity bean, if you read in a varchar from the database, and casted it to an int for internal calculations and then tried to store it back via the ejbStore() you have to cast that back into a String, or the original format which you took it.
Mayank SPrincipal TechnologistCommented:
You're perhaps trying to hold an NVARCHAR in an integer. Do you call getInt () or getLong () somewhere?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java EE

From novice to tech pro — start learning today.