dont use a parameter marker when i use ibatis ,i think it is not a
good idea for the security reason. or just catch the exception and
ignore it?
and can you give some advice for this situation.
really thank you.
2010/3/23 Mario Ds Briggs
ok... i will try to explain 1 more time.
t throw exception.
the db constraint the column's lenth but don't constraint the condition
parameter's.but in ibatis ,it runs like it also constraint the parameter's.
i don't know does i show the problem clear.
2010/3/23 Mario Ds Briggs
Hi Joson,
I guess you
Hi Joson,
I guess you figured the error out yourself i.e. length of the parameter
value is > than the column length (30).
It works fine in db2 client since there you are not using a parameter
marker but have value as a literal inside the SQL statement string.
cheers
Mario
Ok i see the point. BTW which reference architecture are you referring to -
the JasperReports reference architecture.
Prem75
Maybe there is a way and the ibatis devs can tell you how. But i will ask a
different question, why not use something like Spring JDBC templates or
similar technology ?
regards
Mario
Prem75
Based on the proof you have provided (the traces, the SQLSTATES of the
error & spring DAO exception - DataIntegrityViolationException) there is
nothing further you need to look at execpt values being inserted/updated.
SQL0406N A numeric value in the UPDATE or INSERT statement is not
within
when it succeeds it means u inserted a value which was in the range. When
it fails, u or user was try to insert a value that was not in the required
range.
adi203793
Nothing to do with ibatis. Look up the error definitions of SQLStates
SQL302 & SQL406 and you will understand why it occurs arbitarily :-)
The value that is trying to be inserted in out-of-range for the column in
the db.
Mario
Why dont u try it and if u ran into problems, ask that on the list
Kiran Kumar
To
Not really!!! The 'Current schema' register controls this, you can even
change it by executing a 'SET CURRENT SCHEMA = XXX'
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.ref.doc/doc/r0005877.html
Mario
If would suggest rather to remove the harcoding of schema in the SQL
statements now. In the long run this effort will be less than maintaining 2
sets of files
Mario
pczurak
The statement cache is configured on the Data Source properties in WAS. You
probably want to check with your WAS admin what's the minimal way of
flushing it without bouncing WAS itself ( bouncing the app alone wont help)
Mario
Well i could start by asking why u are using a type 2 driver instead of
type 4 , but i guess that doesnt take u any closer to you getting a
solution :-)
So simply turn on the driver tracing/logging ( in your case both the jdbc
driver and the cli driver traces) for the 2 scenarios you have i.e. iba
Pat,
looks like you are using a very old version of the DB2 JDBC driver (atleast
in the iBatis use-case u have detailed below)
a - which is not a type 4 JDBC driver
b - is a JDBC v1 driver.
The versions of DB2 i have seen, dont even ship with that JDBC driver
anymore. However here is a link t
What's SQL ERROR CODE in the exception. You want to look it up the DB2 on
AS400 docs
Ashish Kulkarni
To
t (being forced to false) with how autoCommit is being handled in
SIMPLE and DBCP. This is actual production code going against TEST data.
Below I've included more of the logs so you can see how autoCommit is being
handled before the qry.
Thanks! Jeff
>>> Deleted by MARIO <<
dstatem...@15db23e]
clearParameters () called
[ibm][db2][jcc][Time:12398864970
—--------END OF
SNIPPET-
>>> Mario Ds Briggs 4/15/2009 7:07 AM >>>
Did you do a compare of the JCC log for the same application run with
a - the glassf
Did you do a compare of the JCC log for the same application run with
a - the glassfish connection pool
b - the ibatis SIMPLE datasource
thanks
Mario
"Jeff Hibbs"
U probably have to get your hands on ibatis v3 for annotations support
Ivan Bojer
To
Aside to mysql identity semantics, in all cases iBatis will return the db
generated value as the return of the sqlmap.insert() call.
Additionally in your use case below, if the 'RegisteredUser' object has a
'ID' attribute, ibatis will set it to the db generated value. You can also
control the att
We see it as 'iBATIS uses JDBC', 'iBATIS can also use SQLJ'
Mario
Clinton Begin
To
thanks clinton. Graciously accepted.
>>
We welcome the contributors to either find a way to add this support
without modifying the iBATIS source code.
<<
Assumed following Jeff's suggestion, a simple 'Executor' registration
mechanism is acceptable.
thanks
Mario
s are aware of a few situations
where users faced this EITHER OR choice and the goal is to ensure it doesnt
have to be a EITHER OR choice anymore.
thanks
Mario
Mar
While i agreed to Jeff's request of seeing how this can be externalized
with some minimal refactoring to ibatis 2, FWIW i still thought it is fair
to the ibatis users/community (especially those who dont know anything
about SQLJ which one can safely assume is the majority) about what this
patch me
f the regular iBATIS code base.
It sounds like that may be easier to do with iBATIS3.
Is there some minimal change we could make to the iBATIS2 code to
allow you to supply this as a purely external tool?
Jeff Butler
On Fri, Jan 23, 2009 at 4:32 PM, Mario Ds Briggs
wrote:
> thanks Jeff for goin
thanks for the appreciation. FWIW we will provide the maintenance.
Brandon Goodin
To
thanks Jeff for going through the code.
Your explanation of the contributed source is correct.
>>
So you still have to have JDBC setup
<<
SQLJ and JDBC are not mutually exclusive. In fact both share the same
'java.sql.Connection' among other things. The SQLJ API itself allows you to
mix and match
Not sure about 600, but i have heard of cases where the connection pool
size was so large, it brought down the DB server when the pools were
intialized.
Clinton Begin
Is it possible that in your ibatis application, the insert statement and
the 'values IDENTITY' statement are executed on different connections.
LiborP
Michael,
multiple semicolon separated queries are not allowed by DB2. It is good
from a security viewpoint too.
thanks
Mario
"Michael Schall"
w that you never sent the source. You only sent a fully
compiled binary demo. We can't do much with that... ;-)
Clinton
On Mon, Nov 24, 2008 at 5:29 AM, Mario Ds Briggs <[EMAIL PROTECTED]>
wrote:
Hi Prakash,
Sometime last year i had made the offer on the dev list -
http://
Hi Prakash,
Sometime last year i had made the offer on the dev list -
http://www.mail-archive.com/[EMAIL PROTECTED]/msg02595.html and Clinton
responded positively. We did send him the demo, but he has been terribly
busy to get to it. In the meantime we too got stuck in some legalese.
However i ha
32 matches
Mail list logo
