You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » tOracleOutput additional columns generate codes without double quotes
Post a reply
Topic review (newest first)
- yunbo
- 2008-04-10 10:11:59
Thanks for your answer.
The thing is that I have 40-50 tOracleOutput in my project, do I really have to add the quotes manuelly for all of them? Is there a version who can do this automatically?
I tried the V2.2.1, it generates correct codes. But when I export my project and then import it under V2.3.2, it didn't work just as before.
- mhirt
- 2008-04-09 21:19:00
M1 means MileStone version. These are testing versions.
There are no guarantee of compatibility between testing / unstable versions and stable versions.
These modification was due to correction of [Bugtracker] bug 1877
As you have nearly discovered, you have to modify your component configuration
Name SQL Expression Position Reference column
"ID" "seq_actor.nextval" replace ID
Thanks for your support,
- yunbo
- 2008-04-09 19:20:44
I have the tOracleOutput component's Additional columns configuration like this:
Name SQL Expression Position Reference column
ID seq_actor.nextval replace ID
and it generates the following codes:
java.sql.PreparedStatement pstmt_tOracleOutput_1 = conn_tOracleOutput_1
.prepareStatement("INSERT INTO "
+ tableName_tOracleOutput_1
+ " ("
+ ID
+ ",DATEEXPLOITATION,IDSTEP,IDTYPECHRONIQUE,JOUR,COURANT) VALUES ("
+ seq_actor.nextval
+ ",?,?,?,?,?)");
ID and seq_actor.nextval don't have double quotes which produce the compilation error.
I have migrated this project from version 2.2.0M1 and it generated the code correctly but why the new version (V2.3.2) can't?