Ibatis is most likely not the problem. The database needs to be configured
to accept unicode characters. What database are you using?
On Fri, Jul 24, 2009 at 12:22 PM, Ashish Kulkarni <
ashish.kulkarn...@gmail.com> wrote:
> HiHas anyone noticed issue with inserting japanese characters in databa
WebSphere encodes the password using XOR in an xml file which is not the
same an encrypting.
I am not sure if you have this figured out already, but I use Websphere and
DB2, and a couple years ago we were trying to understand if a read
transaction needed to be committed. Apparently it does for the connection
to be returned to the connection pool and Websphere does it implicitly as we
late
Yes, it does.
select nextval for
from sysibm.sysdummy1
On Tue, Jan 6, 2009 at 2:28 PM, Niels Beekman wrote:
> This looks like a sequence/increment-value to me, doesn't DB2 have
> something like this? That would probably be a lot safer as well in a
> concurrent environment.
>
>
>
> Niels
> -
I *think* Webpshere 6.x will call rollback on the connection if you return
it to the pool without calling commit or rollback yourself. (Check your
SystemOut.log for warnings) Also, I remember looking into this six months
ago and found that when you call setAutoCommit(true), for example, before
re
Your originally query should work. I ran a similar query that worked in db2
v9. What was the explicit db2 sql exception?
You could also try the timestampdiff scalar function (4 = minutes)? For
example,
where (sysfun.timestampdiff(4,char(CURRENT_TIMESTAMP - INSERTTIME)) <=
#duration#)
On Thu
There shouldn't be any problems with it. I do it all the time. Can you
give us an example of your scenario that doesn't seem to work?
On Wed, Feb 20, 2008 at 11:01 AM, Alexey Kalmykov <
[EMAIL PROTECTED]> wrote:
> Hi all,
>
>
>
> I am trying to evaluate iBATIS as an ORM solution for my project
The syntax looks correct. How is it not working? Are you getting an
exception or an empty result set?
On Feb 1, 2008 12:37 PM, ppakk <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am using ibatis with DB2 and am doing a
> query to see if a row of data has been created
> in the past 24 hours. This quer
Do you have the same table in multiple schemas? If so, make sure ibatis is
reading from the correct schema.
On Jan 22, 2008 4:37 PM, Randall Svancara <[EMAIL PROTECTED]> wrote:
> I have used Ibatis for numerous projects and never had a problems with
> returning back a result set. I have other f
Can you turn on logging for java.sql? Then you can see more of what ibatis
is doing with the prepared statement and its parameters.
On Jan 22, 2008 10:45 AM, Krenek, Robert <[EMAIL PROTECTED]> wrote:
> Hi All,
>
>
>
> I'm running into an issue that I cannot resolve. If you can provide any
> as
ix, but it doesn't trim the string so I still get
> whitespace padding... :-(
>
> Jason
>
>
>
> Stephen Boyd-3 wrote:
> >
> > Why don't you change your select clause to this?
> >
> >select *trim(sm_issue_symbol) as sm_issue_symbol*,
> >
Why don't you change your select clause to this?
select *trim(sm_issue_symbol) as sm_issue_symbol*,
tm_id
from
sec_master,
category_security,
tier_mast
where sm_secid = cs_secid
and cs_tierid = tm_id
and sm_issue_symbol
Can you use a db function to trim the value before it reaches ibatis? I am
not familiar with informix, but in db2 I use the rtrim() function. I am
sure there must be something similar.
On Jan 18, 2008 2:01 PM, novotny <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm using an informix database and
I don't think so. If this has changed, I would like to know as well.
The way I had to workaround it was to include the constant in the result
set.
For example,
select a, b, c, "M" as range
from someTable
On Jan 18, 2008 2:45 AM, Shirad Mashura <[EMAIL PROTECTED]> wrote:
> Can a string be used
Probably because you are inserting only one bind variable which is a string
of four number separated by commas. Is that the correct datatype of
condition_id?
The quick fix would be to change #value# to $value$. However, the proper
way to pass in the list of numbers is with a java.util.List and u
This should be handled in your type handler callback if you have one
implemented.
On Jan 9, 2008 8:28 PM, topgd <[EMAIL PROTECTED]> wrote:
>
> I am using a TypeHandlerCallback to map a Boolean property to a DB2
> character(1) field that contains 'T' or 'F'.
>
> I cannot get the nullValue proper
What version of Spring are you using? I *think* they fixed it in 2.0.5.
On Jan 9, 2008 6:15 PM, Warren <[EMAIL PROTECTED]> wrote:
> I just got done switching the Ibatis DAO to Spring DAO per the
> instructions
> written by Larry. Everything is working fine except whenever I use
> SqlMapClient e
what version of db2? I have not seen a sqlstate of F before with db2
v8+
On Jan 2, 2008 2:49 AM, Curro <[EMAIL PROTECTED]> wrote:
> Hi and happy new year for everyone...
>
> This is one of the querys that is failing
>
>
>
>
>
>
>
>
>
>
>
>
> SELECT
> imagen.ID_IMAGEN,
>
Have you tried
C064ID=#id[].*name*#
On Jan 3, 2008 1:46 PM, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
> Hi
> I have a class like below with get and set method
> public ColorClass
> {
> private String name, desc;
>
> public void setName(String _name)
> {
> this.name = _name;
> }
> public Str
Turn on debug for java.sql.Connection and make sure all the parameters are
being passed correctly.
On Dec 20, 2007 12:32 PM, KWeisser <[EMAIL PROTECTED]> wrote:
>
> I'm currently running a Web project in RSA 7.0 using Ibatis.
>
> When I start my local server, I'm able to successfully retrieve a s
You need to set currentFunctionPath=PERMIT on the datasource. It is a
custom property that can be set on the jdbc url. For example,
jdbc:db2://host:port/dbname:currentFunctionPath=PERMIT;currentSchema=PERMIT;
If you are running in websphere, setting this can be done in the custom
properties of
If I reuse prepared statements in nested queries and statement caching is
on, then I potentially will have results sets closed prematurely. The
reason is that the PreparedStatement.executeQuery() will close any
previously opened result sets. Are there many people out there using these
types of re
22 matches
Mail list logo
