You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Odelya YomTov <od...@jpost.com> on 2009/07/14 18:40:56 UTC
problem with insert
Hi!
I am trying to insert data in Hebrew into the database
The table is set to utf-8.
But in the log file I see:
DEBUG [http-12091-Processor24] - Created connection 27901603.
DEBUG [http-12091-Processor24] - {conn-100000} Connection
DEBUG [http-12091-Processor24] - {pstm-100001} PreparedStatement: SELECT * FROM users WHERE NAME = ? AND PASSWORD = ?
DEBUG [http-12091-Processor24] - {pstm-100001} Parameters: [×ž× ×”×œ, ×ž× ×”×œ×™×œ×§×•×˜]
DEBUG [http-12091-Processor24] - {pstm-100001} Types: [java.lang.String, java.lang.String]
DEBUG [http-12091-Processor24] - {rset-100002} ResultSet
DEBUG [http-12091-Processor24] - Returned connection 27901603 to pool.
Which means that I receive rubbish.
What can I do to handle it?
My browser reads Hebrew all right (I wrote something in struts and I see that the messages that I get back for the user are in Hebrew)
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: problem with insert
Posted by Chris O'Connell <oc...@gorillachicago.com>.
Reading this, I'm not 100% sure I even know what your problem is. You state
that you are trying to insert data but the logging that you show is for a
'select' statement and no exceptions are shown in the log. You could have a
situation where you did an insert with one connection, but never committed,
so the data doesn't show up for a different connection. Can you isolate the
code in a test method that uses the same DataSource and try to replicate
this using plain old jdbc. Perhaps the encoding needs to be set for the
driver? This doesn't seem like the kind of thing that would bother iBatis
in either case, so if you can isolate and fix this without iBatis in the
picture, the problem will likely go away when you add iBatis back in.
Chris
FWIW, I see garbage characters in the email that I received with this, but
that doesn't mean that my mail reader just isn't correctly displaying
whatever characters you are sending over to me.
On Tue, Jul 14, 2009 at 2:00 PM, Odelya YomTov <od...@jpost.com> wrote:
> Hi!
>
> It's not the problem with the log file encoding.
>
> It's something is the connection between ibatis and mysql
>
>
>
>
>
> *From:* Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com]
> *Sent:* Tuesday, July 14, 2009 9:52 PM
> *To:* user-java@ibatis.apache.org
> *Subject:* Re: problem with insert
>
>
>
> Is it possible that you just did not set your log file encoding? Kind of
>
> log4j.appender.someappender.Encoding=UTF-8
>
>
>
>
>
> On Tue, Jul 14, 2009 at 8:40 PM, Odelya YomTov <od...@jpost.com> wrote:
>
> Hi!
>
> I am trying to insert data in Hebrew into the database
>
> The table is set to utf-8.
>
> But in the log file I see:
>
> DEBUG [http-12091-Processor24] - Created connection 27901603.
> DEBUG [http-12091-Processor24] - {conn-100000} Connection
> DEBUG [http-12091-Processor24] - {pstm-100001} PreparedStatement:
> SELECT * FROM users WHERE NAME = ? AND PASSWORD = ?
> DEBUG [http-12091-Processor24] - {pstm-100001} Parameters: [×ž× ×”×œ, מ×
> הלילקוט]
> DEBUG [http-12091-Processor24] - {pstm-100001} Types: [java.lang.String,
> java.lang.String]
> DEBUG [http-12091-Processor24] - {rset-100002} ResultSet
> DEBUG [http-12091-Processor24] - Returned connection 27901603 to pool.
>
> Which means that I receive rubbish.
>
> What can I do to handle it?
>
> My browser reads Hebrew all right (I wrote something in struts and I see
> that the messages that I get back for the user are in Hebrew)
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
>
>
>
>
> ************************************************************************************
> This footnote confirms that this email message has been scanned by
> PineApp Mail-SeCure for the presence of malicious code, vandals & computer
> viruses.
>
> ************************************************************************************
>
--
--
Chris O'Connell
Application Developer
Gorilla
312.243.8777 x19
RE: problem with insert
Posted by Odelya YomTov <od...@jpost.com>.
One with & a m p; and one with &
-----Original Message-----
From: Larry Meadors [mailto:larry.meadors@gmail.com]
Sent: Wednesday, July 15, 2009 4:20 PM
To: user-java@ibatis.apache.org
Subject: Re: problem with insert
It's early but those look identical to me.
Larry
On 7/15/09, Odelya YomTov <od...@jpost.com> wrote:
> Thank you
>
> The problem was that I had:
>
> useUnicode=yes&characterEncoding=utf8
>
>
>
> instead of:
>
>
>
> useUnicode=yes&characterEncoding=utf8
>
>
>
> in the url
>
>
>
> From: Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com]
> Sent: Tuesday, July 14, 2009 10:13 PM
> To: user-java@ibatis.apache.org
> Subject: Re: problem with insert
>
>
>
> Try this thread:
>
> http://www.mail-archive.com/user-java@ibatis.apache.org/msg13497.html
>
> Seems similar problem was solved there
>
> GL
>
> On Tue, Jul 14, 2009 at 11:00 PM, Odelya YomTov <od...@jpost.com> wrote:
>
> Hi!
>
> It's not the problem with the log file encoding.
>
> It's something is the connection between ibatis and mysql
>
>
>
>
>
> From: Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com]
> Sent: Tuesday, July 14, 2009 9:52 PM
> To: user-java@ibatis.apache.org
> Subject: Re: problem with insert
>
>
>
> Is it possible that you just did not set your log file encoding? Kind of
>
> log4j.appender.someappender.Encoding=UTF-8
>
>
>
>
>
> On Tue, Jul 14, 2009 at 8:40 PM, Odelya YomTov <od...@jpost.com> wrote:
>
> Hi!
>
> I am trying to insert data in Hebrew into the database
>
> The table is set to utf-8.
>
> But in the log file I see:
>
> DEBUG [http-12091-Processor24] - Created connection 27901603.
> DEBUG [http-12091-Processor24] - {conn-100000} Connection
> DEBUG [http-12091-Processor24] - {pstm-100001} PreparedStatement:
> SELECT * FROM users WHERE NAME = ? AND PASSWORD = ?
> DEBUG [http-12091-Processor24] - {pstm-100001} Parameters: [×ž× ×”×œ, מ×
> הלילקוט]
> DEBUG [http-12091-Processor24] - {pstm-100001} Types: [java.lang.String,
> java.lang.String]
> DEBUG [http-12091-Processor24] - {rset-100002} ResultSet
> DEBUG [http-12091-Processor24] - Returned connection 27901603 to pool.
>
> Which means that I receive rubbish.
>
> What can I do to handle it?
>
> My browser reads Hebrew all right (I wrote something in struts and I see
> that the messages that I get back for the user are in Hebrew)
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
>
>
>
> ************************************************************************************
> This footnote confirms that this email message has been scanned by
> PineApp Mail-SeCure for the presence of malicious code, vandals & computer
> viruses.
> ************************************************************************************
>
>
>
>
>
> ************************************************************************************
> This footnote confirms that this email message has been scanned by
> PineApp Mail-SeCure for the presence of malicious code, vandals & computer
> viruses.
> ************************************************************************************
>
>
--
Sent from my mobile device
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: problem with insert
Posted by Larry Meadors <la...@gmail.com>.
It's early but those look identical to me.
Larry
On 7/15/09, Odelya YomTov <od...@jpost.com> wrote:
> Thank you
>
> The problem was that I had:
>
> useUnicode=yes&characterEncoding=utf8
>
>
>
> instead of:
>
>
>
> useUnicode=yes&characterEncoding=utf8
>
>
>
> in the url
>
>
>
> From: Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com]
> Sent: Tuesday, July 14, 2009 10:13 PM
> To: user-java@ibatis.apache.org
> Subject: Re: problem with insert
>
>
>
> Try this thread:
>
> http://www.mail-archive.com/user-java@ibatis.apache.org/msg13497.html
>
> Seems similar problem was solved there
>
> GL
>
> On Tue, Jul 14, 2009 at 11:00 PM, Odelya YomTov <od...@jpost.com> wrote:
>
> Hi!
>
> It's not the problem with the log file encoding.
>
> It's something is the connection between ibatis and mysql
>
>
>
>
>
> From: Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com]
> Sent: Tuesday, July 14, 2009 9:52 PM
> To: user-java@ibatis.apache.org
> Subject: Re: problem with insert
>
>
>
> Is it possible that you just did not set your log file encoding? Kind of
>
> log4j.appender.someappender.Encoding=UTF-8
>
>
>
>
>
> On Tue, Jul 14, 2009 at 8:40 PM, Odelya YomTov <od...@jpost.com> wrote:
>
> Hi!
>
> I am trying to insert data in Hebrew into the database
>
> The table is set to utf-8.
>
> But in the log file I see:
>
> DEBUG [http-12091-Processor24] - Created connection 27901603.
> DEBUG [http-12091-Processor24] - {conn-100000} Connection
> DEBUG [http-12091-Processor24] - {pstm-100001} PreparedStatement:
> SELECT * FROM users WHERE NAME = ? AND PASSWORD = ?
> DEBUG [http-12091-Processor24] - {pstm-100001} Parameters: [×ž× ×”×œ, מ×
> הלילקוט]
> DEBUG [http-12091-Processor24] - {pstm-100001} Types: [java.lang.String,
> java.lang.String]
> DEBUG [http-12091-Processor24] - {rset-100002} ResultSet
> DEBUG [http-12091-Processor24] - Returned connection 27901603 to pool.
>
> Which means that I receive rubbish.
>
> What can I do to handle it?
>
> My browser reads Hebrew all right (I wrote something in struts and I see
> that the messages that I get back for the user are in Hebrew)
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
>
>
>
> ************************************************************************************
> This footnote confirms that this email message has been scanned by
> PineApp Mail-SeCure for the presence of malicious code, vandals & computer
> viruses.
> ************************************************************************************
>
>
>
>
>
> ************************************************************************************
> This footnote confirms that this email message has been scanned by
> PineApp Mail-SeCure for the presence of malicious code, vandals & computer
> viruses.
> ************************************************************************************
>
>
--
Sent from my mobile device
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
RE: problem with insert
Posted by Odelya YomTov <od...@jpost.com>.
Thank you
The problem was that I had:
useUnicode=yes&characterEncoding=utf8
instead of:
useUnicode=yes&characterEncoding=utf8
in the url
From: Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com]
Sent: Tuesday, July 14, 2009 10:13 PM
To: user-java@ibatis.apache.org
Subject: Re: problem with insert
Try this thread:
http://www.mail-archive.com/user-java@ibatis.apache.org/msg13497.html
Seems similar problem was solved there
GL
On Tue, Jul 14, 2009 at 11:00 PM, Odelya YomTov <od...@jpost.com> wrote:
Hi!
It's not the problem with the log file encoding.
It's something is the connection between ibatis and mysql
From: Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com]
Sent: Tuesday, July 14, 2009 9:52 PM
To: user-java@ibatis.apache.org
Subject: Re: problem with insert
Is it possible that you just did not set your log file encoding? Kind of
log4j.appender.someappender.Encoding=UTF-8
On Tue, Jul 14, 2009 at 8:40 PM, Odelya YomTov <od...@jpost.com> wrote:
Hi!
I am trying to insert data in Hebrew into the database
The table is set to utf-8.
But in the log file I see:
DEBUG [http-12091-Processor24] - Created connection 27901603.
DEBUG [http-12091-Processor24] - {conn-100000} Connection
DEBUG [http-12091-Processor24] - {pstm-100001} PreparedStatement: SELECT * FROM users WHERE NAME = ? AND PASSWORD = ?
DEBUG [http-12091-Processor24] - {pstm-100001} Parameters: [×ž× ×”×œ, ×ž× ×”×œ×™×œ×§×•×˜]
DEBUG [http-12091-Processor24] - {pstm-100001} Types: [java.lang.String, java.lang.String]
DEBUG [http-12091-Processor24] - {rset-100002} ResultSet
DEBUG [http-12091-Processor24] - Returned connection 27901603 to pool.
Which means that I receive rubbish.
What can I do to handle it?
My browser reads Hebrew all right (I wrote something in struts and I see that the messages that I get back for the user are in Hebrew)
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************
************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************
Re: problem with insert
Posted by Nicholoz Koka Kiknadze <ki...@gmail.com>.
Try this thread:
http://www.mail-archive.com/user-java@ibatis.apache.org/msg13497.html
Seems similar problem was solved there
GL
On Tue, Jul 14, 2009 at 11:00 PM, Odelya YomTov <od...@jpost.com> wrote:
> Hi!
>
> It's not the problem with the log file encoding.
>
> It's something is the connection between ibatis and mysql
>
>
>
>
>
> *From:* Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com]
> *Sent:* Tuesday, July 14, 2009 9:52 PM
> *To:* user-java@ibatis.apache.org
> *Subject:* Re: problem with insert
>
>
>
> Is it possible that you just did not set your log file encoding? Kind of
>
> log4j.appender.someappender.Encoding=UTF-8
>
>
>
>
>
> On Tue, Jul 14, 2009 at 8:40 PM, Odelya YomTov <od...@jpost.com> wrote:
>
> Hi!
>
> I am trying to insert data in Hebrew into the database
>
> The table is set to utf-8.
>
> But in the log file I see:
>
> DEBUG [http-12091-Processor24] - Created connection 27901603.
> DEBUG [http-12091-Processor24] - {conn-100000} Connection
> DEBUG [http-12091-Processor24] - {pstm-100001} PreparedStatement:
> SELECT * FROM users WHERE NAME = ? AND PASSWORD = ?
> DEBUG [http-12091-Processor24] - {pstm-100001} Parameters: [×ž× ×”×œ, מ×
> הלילקוט]
> DEBUG [http-12091-Processor24] - {pstm-100001} Types: [java.lang.String,
> java.lang.String]
> DEBUG [http-12091-Processor24] - {rset-100002} ResultSet
> DEBUG [http-12091-Processor24] - Returned connection 27901603 to pool.
>
> Which means that I receive rubbish.
>
> What can I do to handle it?
>
> My browser reads Hebrew all right (I wrote something in struts and I see
> that the messages that I get back for the user are in Hebrew)
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
>
>
>
>
> ************************************************************************************
> This footnote confirms that this email message has been scanned by
> PineApp Mail-SeCure for the presence of malicious code, vandals & computer
> viruses.
>
> ************************************************************************************
>
RE: problem with insert
Posted by Odelya YomTov <od...@jpost.com>.
Hi!
It's not the problem with the log file encoding.
It's something is the connection between ibatis and mysql
From: Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com]
Sent: Tuesday, July 14, 2009 9:52 PM
To: user-java@ibatis.apache.org
Subject: Re: problem with insert
Is it possible that you just did not set your log file encoding? Kind of
log4j.appender.someappender.Encoding=UTF-8
On Tue, Jul 14, 2009 at 8:40 PM, Odelya YomTov <od...@jpost.com> wrote:
Hi!
I am trying to insert data in Hebrew into the database
The table is set to utf-8.
But in the log file I see:
DEBUG [http-12091-Processor24] - Created connection 27901603.
DEBUG [http-12091-Processor24] - {conn-100000} Connection
DEBUG [http-12091-Processor24] - {pstm-100001} PreparedStatement: SELECT * FROM users WHERE NAME = ? AND PASSWORD = ?
DEBUG [http-12091-Processor24] - {pstm-100001} Parameters: [×ž× ×”×œ, ×ž× ×”×œ×™×œ×§×•×˜]
DEBUG [http-12091-Processor24] - {pstm-100001} Types: [java.lang.String, java.lang.String]
DEBUG [http-12091-Processor24] - {rset-100002} ResultSet
DEBUG [http-12091-Processor24] - Returned connection 27901603 to pool.
Which means that I receive rubbish.
What can I do to handle it?
My browser reads Hebrew all right (I wrote something in struts and I see that the messages that I get back for the user are in Hebrew)
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************
Re: problem with insert
Posted by Nicholoz Koka Kiknadze <ki...@gmail.com>.
Is it possible that you just did not set your log file encoding? Kind of
log4j.appender.someappender.Encoding=UTF-8
On Tue, Jul 14, 2009 at 8:40 PM, Odelya YomTov <od...@jpost.com> wrote:
> Hi!
>
> I am trying to insert data in Hebrew into the database
>
> The table is set to utf-8.
>
> But in the log file I see:
>
> DEBUG [http-12091-Processor24] - Created connection 27901603.
> DEBUG [http-12091-Processor24] - {conn-100000} Connection
> DEBUG [http-12091-Processor24] - {pstm-100001} PreparedStatement:
> SELECT * FROM users WHERE NAME = ? AND PASSWORD = ?
> DEBUG [http-12091-Processor24] - {pstm-100001} Parameters: [×ž× ×”×œ, מ×
> הלילקוט]
> DEBUG [http-12091-Processor24] - {pstm-100001} Types: [java.lang.String,
> java.lang.String]
> DEBUG [http-12091-Processor24] - {rset-100002} ResultSet
> DEBUG [http-12091-Processor24] - Returned connection 27901603 to pool.
>
> Which means that I receive rubbish.
>
> What can I do to handle it?
>
> My browser reads Hebrew all right (I wrote something in struts and I see
> that the messages that I get back for the user are in Hebrew)
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>