This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with executeUpdate

 
beda meda
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I have this sql:
CREATE DOMAIN TYPE_TIME_ZONE_ID AS VARCHAR(40);
ALTER TABLE MAIN_HEADER ADD TIME_ZONE_ID TYPE_TIME_ZONE_ID DEFAULT 'Europe/Berlin' NOT NULL;

There are already data in table, so I want to add new column (not nullable) and set it's value to "Europe/Berlin" for all exsiting rows. If I run this directly in IB Expert, everything is OK. But when I run this from java using executeUpdate, the value in column is only "Eur". I can't figure out, why it is cut like this. Executed directly in database it works, so I suspect some problem between java and db. Or am I completely wrong and problem is somewhere else?

Thanks for any idea.
 
Carlo Moore
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would recommend printing the SQL from java before the executeUpdate is run, then running that SQL against IB.

Maybe post your java code so we can have a better idea of what's going on.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic