Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

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
0
Steve34
Asked:
Steve34
1 Solution
 
sfotexCommented:
Are you using prepared statments? I've had good luck with them with longer inserts, etc.
0
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now