<div>
Use ResultSetMetaData to get your max sizes, and then truncate your varchar to to 'fit' in your field.<br />
<br />
Or use static longs to limit your data to the size of your fields.
</div>


Use ResultSetMetaData to get your max sizes, and then truncate your varchar to to 'fit' in your field.

Or use static longs to limit your data to the size of your fields.

<div>
No comment has been added lately, so it's time to clean up this TA.<br />
<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
<br />
- points to Neutron<br />
<br />
Please leave any comments here within the<br />
next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !<br />
<br />
girionis<br />
Cleanup Volunteer
</div>


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:

- points to Neutron

Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

girionis
Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
I am inserting data into an SQL Server database from a coarse-grained EJB. When a string is inserted into a VARCHAR field in the database, the string is taking up the full length of the VARCHAR field, rather than just the length of the string - any ideas? <br />
<br />
This problem does not occur with my fine-grained EJBs which use stored procedures to insert data.<br />
<br />
Thanks in advance.
</div>
</div>


I am inserting data into an SQL Server database from a coarse-grained EJB. When a string is inserted into a VARCHAR field in the database, the string is taking up the full length of the VARCHAR field, rather than just the length of the string - any ideas? 

This problem does not occur with my fine-grained EJBs which use stored procedures to insert data.

Thanks in advance.

JDBC VARCHAR problem

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.