The SAS Output Delivery System and reporting techniques

access data base from web base

Reply
Contributor
Posts: 25

access data base from web base

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
SAS Super FREQ
Posts: 8,744

Re: access data base from web base

Hi,
This is not an ODS or Base Reporting procedure (PRINT, REPORT or TABULATE) question.

Your best bet for help with this issue and your application is to contact SAS Technical Support. To contact Tech Support, go to http://support.sas.com and on the left-hand navigation area, click on the link entitled "Submit a Problem".

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 132 views
  • 0 likes
  • 2 in conversation