Hi all,
I created a web based application using JDeveloper, and when I try to add, update, or delete from web interface using the sql statement, I can't coz of Encoding problem. the log as follow:
8NOV2007:10:16:48.232 When JavaApp(1) in "JAVAAPP"(0) tried to EXECUTE DELETE FROM ETSS.ETSS_SECTORS WHERE SECTOR_ID =
2 BY SQLVIEW:
ERROR: SQL passthru expression contained these errors: ERROR: File ETSS.ETSS_SECTORS cannot be updated
because its encoding does not match the session encoding or the file is in a... .
18NOV2007:10:17:11.484 When JavaApp(1) in "JAVAAPP"(0) tried to EXECUTE UPDATE ETSS.ETSS_SECTORS SET SECTOR_Desc_L =
'sfdfs ' , SECTOR_Desc_S = ' ddd' WHERE SECTOR_ID = 2 BY SQLVIEW:
ERROR: SQL passthru expression contained these errors: ERROR: File ETSS.ETSS_SECTORS cannot be updated
because its encoding does not match the session encoding or the file is in a... .
18NOV2007:10:17:18.656 When JavaApp(1) in "JAVAAPP"(0) tried to EXECUTE UPDATE ETSS.ETSS_SECTORS SET SECTOR_Desc_L =
'sfdfs ' , SECTOR_Desc_S = ' ddd' WHERE SECTOR_ID = 2 BY SQLVIEW:
ERROR: SQL passthru expression contained these errors: ERROR: File ETSS.ETSS_SECTORS cannot be updated
because its encoding does not match the session encoding or the file is in a... .
18NOV2007:10:17:19.090 When JavaApp(1) in "JAVAAPP"(0) tried to EXECUTE UPDATE ETSS.ETSS_SECTORS SET SECTOR_Desc_L =
'sfdfs ' , SECTOR_Desc_S = ' ddd' WHERE SECTOR_ID = 2 BY SQLVIEW:
ERROR: SQL passthru expression contained these errors: ERROR: File ETSS.ETSS_SECTORS cannot be updated
because its encoding does not match the session encoding or the file is in a... .
18NOV2007:10:17:19.513 When JavaApp(1) in "JAVAAPP"(0) tried to EXECUTE UPDATE ETSS.ETSS_SECTORS SET SECTOR_Desc_L =
'sfdfs ' , SECTOR_Desc_S = ' ddd' WHERE SECTOR_ID = 2 BY SQLVIEW:
ERROR: SQL passthru expression contained these errors: ERROR: File ETSS.ETSS_SECTORS cannot be updated
because its encoding does not match the session encoding or the file is in a... .
18NOV2007:10:17:19.850 When JavaApp(1) in "JAVAAPP"(0) tried to EXECUTE UPDATE ETSS.ETSS_SECTORS SET SECTOR_Desc_L =
'sfdfs ' , SECTOR_Desc_S = ' ddd' WHERE SECTOR_ID = 2 BY SQLVIEW:
ERROR: SQL passthru expression contained these errors: ERROR: File ETSS.ETSS_SECTORS cannot be updated
because its encoding does not match the session encoding or the file is in a... .
WARNING: Some character data was lost during transcoding in the dataset ETSS.ETSS_HEADER.
WARNING: Some character data was lost during transcoding in the dataset ETSS.ETSS_HEADER.
18NOV2007:10:21:10.632 When JavaApp(1) in "JAVAAPP"(0) tried to EXECUTE INSERT INTO ETSS.ETSS_ATTRIBUTES_GROUPS (Group_ID,
Group_Desc) Values ( 1 ,'zzzzzzzzzzz') BY SQLVIEW:
ERROR: SQL passthru expression contained these errors: ERROR: File ETSS.ETSS_ATTRIBUTES_GROUPS cannot
be updated because its encoding does not match the session encoding or the... .
your support is appreciated