Hi,

I am trying to deal with inserting/reading international text into ms sqlserver2000. MS documentation specifies that I will need to add the letter 'N' before any value inserted/read from the database in Unicode. is there a way to specify that this happen in the hibernate mapping file? I have been looking at the formula property for the property tag. How is that tag used? Has anyone done this before?

Thanks...

I will reword my question I guess. How does one use teh "formula" property in the property element in class? The documentation was not so clear on what it can be used for.

Thanks...

The formula attribute on the property tag allows you to define a sql expression that is used to create a value which is virtual/computed. For example, one real property might be the count value of female children and another count value of male children so you can then have a computed value that is the total number of children, eg, the sum of the two real fields.

I believe this is usually taken care of by the driver (atleast that appears to be the case with my setup). I am using the jTDS driver, and it seems to be doing this for me automatically. I don't see it in the hibernate logging because (I assume) the driver is converting it internally. I just ran SQL Server Profiler to see what was actually being sent to the database.

Joe

Type conversion form the SQL database type to the Java type is JDBC action so yes you are correct but unless I miss-understood the question, it was refering to a property option that allows a property to be set that does not (necessarily) exist as a field in the database, eg, use multiple fields to calculate something. This allows the data to be set at record creation time (hence db does processing) rather then you including Java code to do the calculation (hence middletier server processing).

Thanks for your replies. David, thanks for the information and examples on the formula attribute. I will give it a spin. jfifield, thanks for the reply. I will look into the profile to the database and see what it sends in. That is exactly what I am looking for to see what is moving in and out of my db.

Peace...