If your code is changing from sql stored procs to oracle stored procs, i
dont think your mapping files will have to change very much. However, if you
do have a good object model that you can reuse, I guess u can inherit the
same on to your xml and make the same be returned when you call the store
I would use distributed cache and write my own cache controller. Jboss cache
works well for me.
On Fri, Jul 31, 2009 at 9:21 AM, sirmak wrote:
>
> but the code needed for tasks like the cache invalidation on data change in
> a
> concurrent distributed environment is is not seem easy,...
>
> chee
or you could select * from (select rownum as ro, * from XXXView) where ro
between 1 and 1000.
If you had rownum as part of your view, I guess you could use that as the ID
and Ibatis queryForList might work too.
On Mon, Jul 27, 2009 at 11:30 AM, Clinton Begin wrote:
> Larry,
> He's doing a join,
Original Message-
> From: Jeff Butler [mailto:jeffgbut...@gmail.com]
> Sent: July-16-09 2:15 AM
> To: user-java@ibatis.apache.org
> Subject: Re: Force cache refresh + precaching
>
> Why not just execute the query in some startup process, this would
> prime the cache?
I havent implemented this particular case, but I wud have to suggest you go
with other technologies in conjunction, maybe comet or something like that.
Am not sure if hibernate / hibernate cache handles this case but i wud look
to check up with their dev team too.
On Wed, Jul 15, 2009 at 1:25 PM,
Count is a keyword. it might not be accepted. Try something else.
Did u execute this query directly
On Fri, Jun 12, 2009 at 7:44 AM, DelGurth wrote:
> To me that COUNT seems like an alias for the result of COUNT(CD) as in
> SELECT COUNT(CD) AS COUNT
>
> But, what is the error?
>
> DelGurth
>
>
Did u try stepping in through the Ibatis code to see what might actually be
happening when u make the call?
On Tue, Jun 2, 2009 at 1:03 PM, Nathan Modrzewski
wrote:
> I'm still having problems with this and have not been able to figure it
> out. Anybody have any ideas?
>
> Thanks,
> -- Nathan
>
My guess is that you are trying to access a column index (rs.get(index)) for
something that doesn't exist. If you could send out what exactly you are
doing and more pieces of your stacktrace, including an ORA #, that should
help more.
-Sundar
On Wed, May 27, 2009 at 9:29 PM, Bhaarat Sharma wrote
I guess you can use the same kinda code to catch exception. I batis does
throw SQLException for errors. If you are using Spring, then it is wrapped
to something else (DAOException, I think). You could throw back custom
exception or a new SQLException when the size doesnt match ur need.
I would hav
As far as I know, U cant do multiple cursor returns with Ibatis. I remember
having tried it way before and was unsuccessful. Am not sure if the later
versions have them.
-Sundar
On Mon, May 4, 2009 at 12:33 PM, Bhaarat Sharma wrote:
> I am trying to mold my code so it works with oracle stored p
I would have used a stored proc or something to do that in the DB itself.
Personally I dont wanna transfer a million records over the network and then
do some logic to fetch one out of it.
I dont know what your situation is, may be if you explain more, there might
be a more elegant way, some of th
I have had OOM, when there was too much of data being retrieved by Ibatis.
with 2000+ statements, I see that as one of the possibility. My heap was
holding up for X amount of data, and I had a hack to loop it when more than
X was there. Increasing the heap helped me too.
-Sundar
On Wed, Mar 11, 2
I have just used the parameterMap way of things and it works absolutely
fine. The implementation of using Parameter map is given in the
documentation on page 21
-Sundar
On Wed, Mar 4, 2009 at 1:58 PM, Sundar Sankar wrote:
> My guess is u will have to define the full path of the projectPa
My guess is u will have to define the full path of the projectParam class.
The error seems to be class not found.. The id and class variables have been
interchanged.
On Wed, Mar 4, 2009 at 1:53 PM, bpamarti wrote:
>
> Hi Gurus:
> Can anyone of you please tell me what am I doing wrong here...sp
This is something I pulled out of google. I havent worked much on abator.
Guys correct me if I have misguided Vivek here.
http://ibatis.apache.org/docs/tools/ibator/configreference/table.html
Example
This element specifies that we always want to generate code for a table
called MYTABLE in schema
Wow,
Jeff, is there an order of schema that Ibator does or does it leave that to
the database to handle it?
On Thu, Feb 19, 2009 at 12:08 PM, Jeff Butler wrote:
> This means that there are two versions of the table (in different
> schemas). The versions do not match. You should probably specif
If you do search for "How to debug" for your IDE on google, You would get an
idea on how debugging has to be done. It is very simple and am guessing you
didnt do it right. The program execution would stop in your breakpoint and
you could check for values of variables, method returns etc and see how
Hey Rahul,
PPL are volunteering to reply, They arent obliged to u in
any way. You gotto be patient if u need reply. Please do watch what you say
please
-Sundar
On Thu, Feb 12, 2009 at 10:00 AM, Rahul Saluja wrote:
>
>
> Does anybody care to reply.
>
>
>
>
>
> Please.
> -
Hi Rahul
check this website out
http://ibatis.apache.org/docs/java/user/com/ibatis/sqlmap/client/SqlMapClient.html
.
It seems to say that it will return the number of rows inserted.
Though I understand you have no test bed but I would still suggest you some
how test it with a rollback enabled and
+1. Support to all databases is definitely a great plus to have.
-Sundar
On Fri, Jan 23, 2009 at 12:05 PM, Clinton Begin wrote:
> Hi everyone,
>
> A group of developers have approached us with a contribution of code
> to patch iBATIS so that it supports SQLJ.
>
> If you've never heard of SQLJ,
nection to get available in the pool is just caused
>> by your hardware (CPU) beeing busy, so why add extra latency with extra pool
>> code...
>>
>> Again, of course the logic can not applyed to long running transactions
>> when CPU is idling in the midst of transaction wai
the pool is just caused by your
> hardware (CPU) beeing busy, so why add extra latency with extra pool code...
>
> Again, of course the logic can not applyed to long running transactions
> when CPU is idling in the midst of transaction waiting for e.g. extra user
> input.
>
>
Hi Clinton,
I apologize ahead, if I am missing or not getting
something right. As far as my understanding goes, arent number of
connections in a pool in relation to the number of parallel users that
access the application than the number of CPU cores in a database?
Regards
S
On
The effort should also include handling batch cruds !
On Mon, Jan 12, 2009 at 4:11 PM, Sundar Sankar wrote:
> Can I put it across this way,
>
> You would wanna perform Crud using Ibatis, what would be your design to use
> Ibatis. If you could define what tasks(patterns or code) yo
, Jan 12, 2009 at 3:58 PM, Rick wrote:
> On Mon, Jan 12, 2009 at 4:50 PM, Sundar Sankar
> wrote:
> > By reinventing I was talking of , connection pool / management,
> transaction
> > management etc etc.
>
> Transaction demarcation in Spring is sort of nice. I will
I guess I missed this one. But why do u need to use
applicationContext.getBean. Those are ancient man. With Spring Annotations
(check the 2.5+ documentation), U hardly need xmls and all of this crappy
code.
I am not sure if that and the need for those huge amounts of xmls worried u
about Spring as
this is the right forum to talk about Spring
any more and I feel there would be better answers if you posted the same on
the Spring forum too.
Good luck with your project!
-Sundar
On Mon, Jan 12, 2009 at 2:21 PM, Rick wrote:
> On Mon, Jan 12, 2009 at 4:08 PM, Sundar Sankar
> wrote:
> &
and waste time and money
on writing code and more so on testing the same for something that is
already available and well tested.
-Sundar
On Mon, Jan 12, 2009 at 1:23 PM, Rick wrote:
> On Mon, Jan 12, 2009 at 2:44 PM, Sundar Sankar
> wrote:
> >
> > The way I see it, Instea
Rick,
You dont have to force yourself to using Spring at all. I have used Spring
and I know it makes your job easier. I would assume, using spring shouldnt
change your architechture too much. You might need to port in a few extra
jars but you get a lot of added advantage with it. I just dont see wh
; From: Larry Meadors [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 13, 2008 12:44 PM
> To: user-java@ibatis.apache.org
> Subject: Re: iBATIS with Tomcat vs JBoss
>
> So the B in EJB stands for Beer? :-D
>
> Larry
>
>
> PS: It's not even Friday yet, either
The biggest problem I had when I did "some" development with ejb3, more that
year or so back was that, most of the exception was hibernate specific. I
understood it was build on top of hibernate, but since ejb3 was throwing
back hibernate exceptions, google could hardly help us in solving us some
c
2k parallel users.. Hmm, I dont see a need for you to think beyond tomcat.
But I would still vouch for jboss, cos it can get you support if you wanted.
I am hearing a lot of organizations talk about it these days and if you are
in one them or could be impacted by that clause later. yeah. Or else it
English please!!
2008/10/21 Carlos de Luna Saenz <[EMAIL PROTECTED]>
> No te entendÃ, si quieres mandame a mi correo personal un mail y veo si
> puedo ayudarte.
> saludos.
>
> - Mensaje original
> De: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> Para: user-java@ibatis.apache.org
> Enviado:
HI Ankit,
I would do a loop, fetching lesser number of rows each time.
I had a similar requirement, when I had to do a bulk fetch (basically a
nightly job which had to create a lucene index) and I saw Ibatis was caching
all the rows and not freeing up the cache which resulted in an O
Hi,
Do you feel it would be difficult to persist the "Old Object". I am not
sure if you are confusing yourself with Ibatis thinking if it will work like
Hibernate. The way of saying "Old Object" Seems to remind me of just that.
If thats the case, I dont think Ibatis needs you to have the Old "
If you carefully design your resultmaps, the "extends" property of the
result map could help you. The only precaution you might have to take is
that, The order of declaration should be the order of definition in the
sqlmap file.
On Thu, Sep 25, 2008 at 4:11 PM, Daniel Henrique Alves Lima <
[EMAI
> hashCode = hashCode*i;
> }
> } catch (SQLException e) {
> // TODO Auto-generated catch block
> e.printStackTrace();
> }
> return hashCode;
> }
>
>
>
>
>
> }
>
> Then you can specify it as an A
Please read the Ibatis documentation and you will find similar examples
there.
On Fri, Sep 12, 2008 at 6:33 AM, my screen1 <[EMAIL PROTECTED]>wrote:
>
> Hi,
>
> I am calling a procedure from ibatis layer, where the procedure returns a
> result set ( as normal select ) and an output parameter.
>
>
Hi Kyunam
The exception seems to suggest that
$filter.columnValuePairs[] is not defined as a List. Can you let us know
what you have declared it as in your pojo. Ibatis expects it to be of Type
extending List or Array.
The error should be this line I guess.
$filter.columnValue
Hi Kiran,
If I remember right, isnt the previous and next of a cached
rowset used to traverse through the cursor of the result set fetched. I
think all cached rowset does if caches the resultset and gives the data to
the user so that the there is no hard connection between the appli
I thought you can pass table names dynamically using a $table_name. My best
bet would be to create the table name at your dao layer and pass it as a
param to the query.
On Thu, Aug 21, 2008 at 11:31 AM, Nicholoz Koka Kiknadze <[EMAIL PROTECTED]
> wrote:
> To be honest in the first place I'd ask
Did you go through the Spring reference pdf. They have these explained. Even
google would direct you the HTML chapter of the PDF.
On Thu, Aug 21, 2008 at 1:10 PM, bala r <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have to implement TransacationManager in my module using Spring with
> Ibatis.
>
> Here
Check this site out. It gives u description of the ORA number
>
> http://www.techonthenet.com/oracle/errors/ora06502.php
>
> It looks like the param u are looking at is a number and u r trying to pass
> a string. You have to change the procedure to take a default value or do
> something else inste
Check this site out. It gives u description of the ORA number
http://www.techonthenet.com/oracle/errors/ora06502.php
It looks like the param u are looking at is a number and u r trying to pass
a string. You have to change the procedure to take a default value or do
something else instead of throw
Do verify if the types of your IN params are correct. You might wanna verify
what each param maps to in the database. Can you pass "0" as the value and
see if it runs and the try and pass "foo" and see if you get the same error.
On Tue, Aug 19, 2008 at 1:50 PM, Vinaya Tirikkovalluru <
[EMAIL PROTE
Did u try and execute the procedure stand alone on your SQL Plus. It looks
like you might need to handle NULL or "" param case .
On Tue, Aug 19, 2008 at 1:44 PM, bala r <[EMAIL PROTECTED]> wrote:
> I am using ParameterMap to map StoredProcedure IN parameters.
> If all parameter have value then
Hey Brian,
Please dont reply when you have to ask the community on a new
issue. Please create a new email and write down the issue there. This is to
prevent thread hijacking.
http://en.wikipedia.org/wiki/Thread_hijacking
Thanks
-Sundar
On Mon, Aug 18, 2008 at 12:59 PM, Brian Parkin
Could you send your Ibatis configs. I am having data like those successfully
processed.
On Tue, Aug 12, 2008 at 2:57 PM, Jeff Stahl <[EMAIL PROTECTED]> wrote:
> iBATIS seems to have a problem with handling RefCursors as OUT parameters
> in stored procedures. I don't know how you're attempting to
for Hibernate 2, they had something called as hibernate tools(which
apparently had a eclipse plug-in too) which could generate xmls and bean
classes. Am not sure if there is an upgraded version for hibernate 3 to get
the annotations in place in the bean class.
On Wed, Aug 6, 2008 at 1:44 PM, Fidel
Hi ,
Hibernate and Ibatis comparison is like comparing apples and oranges.
Bothe serve different purposes. This is what I told folks at my company b4
we decided to go in with Ibatis instead of Hibernate.
Pros of Ibatis
===
1. Stored procedure support is out of the world.
2. Not pure OR
Hey Samuel
I have the same problem happening in stored procs though.
Specifying a null value in the xml for an "IN Parameter" doesnt help too.
The only way out that I was able to find was to add this to the input map
with a default value. Example if the property is of type String,
Hi,
Has any body noticed this behaviour? Is there a solution for this?
-S
On Thu, Jul 17, 2008 at 4:12 PM, Sundar Sankar <[EMAIL PROTECTED]> wrote:
> Hi,
> I happened to notice this pattern of logging that Ibatis was defecting
> on.I am surprised it hasnt been mentioned e
Hi David,
Like Clinton said, that is a bad design. We had similar
requirements and the way we did it was,
1. For upper case ;
public String getLastName()
{
return this.name.toUpperCase();
//or
/*
if(this.name!=null)
{
return this.name.toUpperCase()
}
else
return null;
*/
}
2. for d
Hi,
I happened to notice this pattern of logging that Ibatis was defecting
on.I am surprised it hasnt been mentioned earlier. Anyways, this is the
situation, Say you are calling a procedure that returns a ref-cursor. Your
resultMap for the refcursor is something like this
Hi,
I have a refcursor returned out of my procedure. The data that comes out
of it is like this
col1 has either value 1 or value 2
and there are other column data
I wanna put data mapped to col1=value1 in a object and col1=value2 in a
object. Is there a way to do this with Ibatis.
Regards
Su
custom out oracle parameters in
> iBatis. I did the investigation in the 2.3.0 code, the fix was not too
> hard. I'll try to create an issue in Jira and attach a patch, but I
> can't promise anything.
> Giovanni
>
> On Wed, Jul 16, 2008 at 7:04 PM, Sundar Sankar <[EMAIL PRO
Hi All,
I am using Typehandler for Oracle user defined databases. The
typehandler seems to be invoked when the mode is "IN" and never called when
the mode is "INOUT". I saw a post mentioning a similar issue
http://www.mail-archive.com/user-java@ibatis.apache.org/msg07216.html
I tried La
Hi,
I have custom TypeHandlers for accessing user defined data types
defined in our oracle database. I have codes like
ArrayDescriptor desc = ArrayDescriptor.createDescriptor("STRARRAY",
underLyingConnection);
parameter = new ARRAY(desc, underLyingConnection,
arr.toArray());
n: Invalid column type
-S
On Tue, Jul 15, 2008 at 2:50 PM, Larry Meadors <[EMAIL PROTECTED]>
wrote:
> I've not tried this...but you may be able to do it with an anonymous
> pl/sql block.
>
> Larry
>
>
> On Tue, Jul 15, 2008 at 3:37 PM, Sundar Sankar <[EMAIL PROTECTE
Hi,
I have a stored procedure that takes an in parameter of an Oracle
object (varchar col1, varchar col2, float col3). How do I call such a stored
proc from Ibatis.
Any help is appreciated.
Thanks
Sundar
Hi Andrew,
One problem I have had in past with pagination at client end is
memory glitches. If there is usually too much of data in the client end,
sometimes you tend to run out of memory while caching these. You might just
wanna be wary of this. I usually wud wanna hit the database multi
9:29 AM, Sundar Sankar <[EMAIL PROTECTED]>
> wrote:
>
>> Just following up on the question. Doesnt Ibatis cache out params of
>> stored procs. If it does, whats the way to do it.?
>>
>>
>> On Tue, Jun 17, 2008 at 5:07 PM, Sundar Sankar <[EMAIL PROTECTED
Just following up on the question. Doesnt Ibatis cache out params of stored
procs. If it does, whats the way to do it.?
On Tue, Jun 17, 2008 at 5:07 PM, Sundar Sankar <[EMAIL PROTECTED]> wrote:
> Hi,
>I tried to cache the data returned by my stored proc and I am seeing
>
Hi,
I tried to cache the data returned by my stored proc and I am seeing
that the data fetched from the procedure is not cached at all. Am I doing
wrong here. I tried to use OSCache and Memory. Both dont seem to work at all
for me.
My configurations are
I am not aware of the usage of memcache. But googling on it tells me that it
simply stores data in memory and you hit the database only when the data
isn't available in memory cache.
Ibatis does provide you with a cache type called "MEMORY". I guess it does
something similar. You may wanna read thr
rote:
> If you have a clear DAO layer, can't you do it there?
>
> If not, you might be able to use some AOP magic to do it (since you're
> already using spring).
>
> Larry
>
>
> On Thu, May 22, 2008 at 5:34 PM, Sundar Sankar <[EMAIL PROTECTED]>
> wr
t; On 5/22/08 5:22 PM, "Sundar Sankar" <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> > I am using Spring and Ibatis in our application and we have a
> > requirement where an audit procedure needs to be called every time an
> update
> > procedure is called. I
Hi,
I am using Spring and Ibatis in our application and we have a
requirement where an audit procedure needs to be called every time an update
procedure is called. Is there a way in Ibatis where I can specify such a
thing. I can take care of naming the update procedure in a particular way or
fo
Hi,
When using Hibernate, I have tested the same using rolling back one
session and committing the second one and vice versa. If you observe, The
value u get after the transaction is over will be greater than both the
sequence Id's. That is, if first ones id is X and seconds is X+1, no matter
Use a type handler. Look at the example code below as a start.
public class StringArrayTypeHandler implements TypeHandlerCallback {
/* (non-Javadoc)
* @see
com.ibatis.sqlmap.client.extensions.TypeHandlerCallback#getResult(com.ibatis.sqlmap.client.extensions.ResultGetter)
*/
publ
Jason,
This is what you will have to do,
1. Map an object to the columns being returned from the cursor in your
sq-map-config file. i.e you should have an entry like this
2. You would have mapped your input Parameter in a map and passed it to
getSQLMapClientTemplate.queryForList("Proc
I found a way to insert a table of Strings. But I am still working on
inserting a table of objects. The code for inserting the table table of
String is
1. We have to use a type handler for this. Create a typeHandler like this
* * * ** ** ** * * ** * * ** ** *
*package* some.package*;*
*import* j
Hi,
I have a custom type variable in oracle that I am using in my stored
proc.
CREATE OR REPLACE TYPE strarray IS TABLE OF VARCHAR2(75);
What would be my corresponding jdbctype be or how would I use tyhandler for
this case.
Regards
Sundar Sankarnarayanan
The parameterMap id was procParam. and not one I have mentioned below. Sorry
about that.
On Jan 10, 2008 9:17 AM, Sundar Sankar <[EMAIL PROTECTED]> wrote:
> I am new to accessing stored procs as such. I don't know how I would do
> it JDBC. I had an example with Springs jdbc
et in values to all the
properties explicitly, leaving nothing null.
Regards
Sundar Sankarnarayanan
On Jan 10, 2008 9:04 AM, Larry Meadors <[EMAIL PROTECTED]> wrote:
> How would you do it with JDBC?
>
> Larry
>
>
> On Jan 10, 2008 9:00 AM, Sundar Sankar <[EMAIL PROTECTED]
Hi,
I have a stored procedure that takes rowtype, an instance of a table,
in my database. How do you create the mapping for such kind of case. Does
Ibatis support this?
Regards
Sundar Sankarnarayanan
76 matches
Mail list logo