JDBC will not put more then 8k into an SQLserver "text type" field

Hi;

We are running some JSPs both on JRun and Tomcat.

We are trying to deposit some text into an SQLServer database.

The datatype of the field we are trying to pass this information into is of "text type".

Interestingly, we can only pass 8K worth of the data in.  It gets truncated otherwise( no error messages ).

We can retrieve more then 8K of data out of this field just fine.

Any ideas on what the problem is and how to get around it?

Steve
Steve34Asked:
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.

sfotexCommented:
Are you using prepared statments? I've had good luck with them with longer inserts, etc.
0

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
jerelwCommented:
Yes, for SQLServer, you need to use prepared statements for large amounts of data.

0
Venci75Commented:
I am not sure - but I think that this is a limitation of the "text field" - not a limitation of the JDBC
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Steve34Author Commented:
That did the trick, along with an updated driver and piping in some TSQL
0
Venci75Commented:
0
CleanupPingCommented:
Steve34:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
jimmackCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept sfotex's comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jimmack
EE Cleanup Volunteer
0
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

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.