How can I insert korean to DS and to Grid ?

Hello ?

I’m testing grid with mysql database.

I have two problems.

I fetch the data successfly using grid.
but, I could not insert or update for korean language data.

[error_log]
=== 2007-04-01 20:06:11,907 [sor3] DEBUG RPCManager - Processing 1 requests.
=== 2007-04-01 20:06:11,907 [sor3] DEBUG RPCManager - Request #1 (DSRequest) payload: {
values:{phone:“043-296-410”, user_id:“choweek”, user_name:“청주대”, email:“choweek@kt.co.kr”,
regist_date:new Date(1175353200000),_selection_3:true},
operationConfig:{dataSource:“webzineUserDS”, operationType:“update”},
appID:“builtinApplication”,
operation:“webzineUserDS_update”,
oldValues:{phone:“043-296-410”, user_id:“choweek”, user_name:“p쿨1”, email:“choweek@kt.co.kr”,
regist_date:new Date(1175353200000),_selection_3:true},
criteria:{user_id:“choweek”}
}
=== 2007-04-01 20:06:11,947 [sor3] INFO IDACall - Performing 1 operation(s)
=== 2007-04-01 20:06:11,947 [sor3] DEBUG AppBase - [builtinApplication.webzineUserDS_update] No userTypes defined, allow
ing anyone access to all operations for this application
=== 2007-04-01 20:06:11,947 [sor3] DEBUG AppBase - [builtinApplication.webzineUserDS_update] No public zero-argument met
hod named ‘_webzineUserDS_update’ found, performing generic datasource operation
=== 2007-04-01 20:06:11,947 [sor3] INFO SQLDataSource - [builtinApplication.webzineUserDS_update] Performing update ope
ration with
criteria: {“user_id”:“choweek”} values: {“_selection_3”:true,“phone”:“043-296-410”,“user_id”:“choweek”,“user_nam
e”:“청주대”,“regist_date”:new Date(1175353200000),“email”:“choweek@kt.co.kr”}
=== 2007-04-01 20:06:13,610 [sor3] INFO SQLValuesClause - [builtinApplication.webzineUserDS_update] Ignored data for no
n-existent columns: [_selection_3]
=== 2007-04-01 20:06:13,620 [sor3] INFO SQLDriver - [builtinApplication.webzineUserDS_update] Executing SQL update on ’
webzine20’: UPDATE user SET phone=‘043-296-410’, user_id=‘choweek’, user_name=‘청주대’, regist_date=‘2007-04-01 00:00:00
.0’, email=‘choweek@kt.co.kr’ WHERE (user_id=‘choweek’)
=== 2007-04-01 20:06:14,130 [sor3] INFO SQLDriver - [builtinApplication.webzineUserDS_update] Execute of update: UPDATE
user SET phone=‘043-296-410’, user_id=‘choweek’, user_name=‘청주대’, regist_date=‘2007-04-01 00:00:00.0’, email=‘chowee
k@kt.co.kr’ WHERE (user_id=‘choweek’) on db: webzine20 threw exception: java.sql.SQLException: null, message from serve
r: “Data too long for column ‘user_name’ at row 1” - assuming stale connection and retrying update.
=== 2007-04-01 20:06:14,130 [sor3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.webzineUserDS_update] Driver
Manager fetching connection for webzine20 via jdbc url jdbc:mysql://localhost:3306/webzine20?user=root&password=mysql&se
Unicode=true&characterEncoding=utf-8
=== 2007-04-01 20:06:14,170 [sor3] ERROR IDACall - Error executing operation: webzineUserDS_update
java.sql.SQLException: null, message from server: “Data too long for column ‘user_name’ at row 1”
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1905)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:11 09)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1203)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 2090)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1680)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1527)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 01)
at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.ja va:317)
at com.isomorphic.sql.SQLDriver.update(SQLDriver.java :298)
at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriv er.java:371)
at com.isomorphic.sql.SQLDataSource.executeNativeUpda te(SQLDataSource.java:205)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDat aSource.java:642)
at com.isomorphic.sql.SQLDataSource.execute(SQLDataSo urce.java:161)
at com.isomorphic.application.AppBase.executeDefaultD SOperation(AppBase.java:704)
at com.isomorphic.application.AppBase.executeAppOpera tion(AppBase.java:664)
at com.isomorphic.application.AppBase.execute(AppBase .java:497)
at com.isomorphic.datasource.DSRequest.execute(DSRequ est.java:1081)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDA Call.java:146)
at com.isomorphic.servlet.IDACall.processRequest(IDAC all.java:106)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java :54)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:709)
at com.isomorphic.servlet.BaseServlet.service(BaseSer vlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:157)
at com.isomorphic.js.JSSyntaxScannerFilter.doFilter(J SSyntaxScannerFilter.java:251)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:157)
at com.isomorphic.servlet.CompressionFilter.doFilter( CompressionFilter.java:248)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invo keInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(Co yoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
=== 2007-04-01 20:06:14,180 [sor3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2007-04-01 20:06:14,180 [sor3] DEBUG RPCManager - non-DMI response, dropExtraFields: false
[/error_log]

the another question is DataSource’s korean title does not display in view page.

// datasource is ..

<DataSource ID="webzineUserDS"
serverType="sql"
tableName="user">
<fields>
<field primaryKey="true" name="user_id" title="아이디" type="text" />
<field name="user_name" title="이름" type="text" />
<field name="email" title="이메일" type="text" />
<field name="regist_date" title="등록일" type="date" />
<field name="phone" title="전화번호" type="text" />
</fields>
</DataSource>

// the error message..
no error..

but, the view page does not show the titile message…
maybe I think this problem is character set.

How can I fix it..

I think both of your problems have to do with character encoding. I recommend that you save your DataSource with UTF8 encoding and then set the contentType of the JSP that loads it to UTF8 like this:

<%@ page contentType="text/html; charset=UTF-8"%>
<%@ taglib uri="/WEB-INF/iscTaglib.xml" prefix="isomorphic" %>
<HTML><HEAD><isomorphic:loadISC/></HEAD><BODY>
<SCRIPT>
<isomorphic:loadDS name="webzineUserDS"/>

isc.ListGrid.create({
    dataSource: webzineUserDS,
    width: 400
});

</SCRIPT>
</BODY></HTML>

The above worked for me with your exact DataSource definition saved as UTF8 and placed in /shared/ds.

The Mysql error is probably related. In order to actually save non-ASCII data to Mysql, you need to tell the database to use UTF8 encoding at the server, table, or column level. Please see the overview here:

http://dev.mysql.com/doc/refman/5.0/en/charset.html

UTF-8 Encoding…

Thank you very much …