I have this code:
....
try {
conn = ((Session) this.getEntityManager().getDelegate()).connection();
cs = conn.prepareStatement( "insert into acdsys.Vmiseam values (null, 4, sysdate, 28, 31, ?,'D222','A333')" );
cs.setString(1, test2);
cs.executeUpdate();
....
i see in the debugger, that the varable has a right value! (a mix of cyrillic with german-umlaute "Ö","Ä" etc)
If i set the Unicode directly in my Oracle-database, e.g.:
update acdsys.Vmiseam set v1 = UNISTR('\041F\0435\0442\044F') where id = 32
it is shown absolutely correct in my web-application! But the insert (see upper) losts the non-standard characters! (= can't write it as unicode properly!)
I've tried things like this:
Properties connProps = conn.getClientInfo();
connProps.setProperty("oracle.jdbc.defaultNChar","true");
conn.setClientInfo(connProps);
but they doesn't work: :-(
Who can help my please with this issue?
Comments