RE: Calling PL/PGSQL doesn't work?

2005-07-21 Thread Hendry
When I'm trying to set I got these errors.. com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance. --- The error occurred in the SQL Map Configuration file. --- Cause: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. Cause: org.xml.

RE: Calling PL/PGSQL doesn't work?

2005-07-21 Thread Hendry
-Original Message- From: Hendry Thanx for your suggestion, but the problem still exists. -Original Message- From: Larry Meadors Set This will force even queries to be committed. Larry -Original Message- From: Hendry Hi, I'm new to iBatis, I got stuck when calling fun

RE: Slow ibatis query

2005-07-21 Thread Greg Day
Im not exactly sure what you mean here. The sqlMapConfig is as follows: I must admit, i havent played with this much, but Ibatis has been working fine until this point. This is very bizarre, if anyone has any ideas, let me know! Otherwise

Can iBatis Map a script of DML (ALTER TABLE) with Anonymous PL/SQL block?

2005-07-21 Thread Mississippi John Hurt
Hi, I need to encapsulate some DML (such as ALTER TABLE DISABLE CONSTRAINT) as well as a long anonymous PL/SQL block of code (not compiled in the database) in Java objects.  Can I do this with iBatis?  If so how?  >From what I understand iBatis can only map SQL and a single stored procedure.  Ho

Re: M:N example

2005-07-21 Thread Clinton Begin
>From the wiki... http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem%3F ClintonOn 7/21/05, wilberto <[EMAIL PROTECTED]> wrote: HiSomebody know a link were i cant see and M:N example in the guide only isthe 1:N example.thank youWilberto

Re: DAO Objects - Hiding ?

2005-07-21 Thread Clinton Begin
Wow.  what a fantastic list of DAO resources.  Wiki anyone? Clinton On 7/21/05, Eric Blue <[EMAIL PROTECTED]> wrote: Steve, If I understand your question correctly, it seems that you want the POJO to know how to persist itself.  This certainly is one way to do it, however I would probably advise

Re: trouble mapping sybase stored procedure to object

2005-07-21 Thread Clinton Begin
Yes.  Although very disappointing that Sybase can't fix this problem (+1 for Open Source Software).  If you create a JIRA ticket, I'll create a switch to allow you to select the execution method. Cheers, ClintonOn 7/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote:Hi,On June 7, someone poste

Re: Resultset metadata

2005-07-21 Thread Clinton Begin
There currently is no way.  I always recommend ignoring the RSMD, and instead use the Java types for the information.  That is, introspect the bean and check the type (String, int, Double, Date etc.). Doing so will keep your application free of database dependencies. Cheers, ClintonOn 7/21/05, A

RE: Calling PL/PGSQL doesn't work?

2005-07-21 Thread Hendry
Thanx for your suggestion, I've just tried it and the problem still exists. Here how I config the sql map. Is there anything wrong here? I also already tried like this : -Original Message- From: Larry Meadors Set This will force even queries to be committed. Larry

Re: Estimating amount of memory need for cache

2005-07-21 Thread Clinton Begin
You could serialize the results it to disk.  That would give you a pessimistic estimation of the size it will be in memory.  That is, the cost of serialization will be higher than the amount of RAM used, so you can feel relatively confident that it will be smaller in memory. Cheers, ClintonOn 7/2

M:N example

2005-07-21 Thread wilberto
Hi Somebody know a link were i cant see and M:N example in the guide only is the 1:N example. thank you Wilberto --- EC Red Internet [EMAIL PROTECTED] Inscríbete en www.ec-red.com

Re: DAO Objects - Hiding ?

2005-07-21 Thread Eric Blue
Steve, If I understand your question correctly, it seems that you want the POJO to know how to persist itself.  This certainly is one way to do it, however I would probably advise against it.  If I recall, one of Scott Ambler's books (The Object Primer, 2nd edition) detailed an architecture simila

Re: Slow ibatis query

2005-07-21 Thread Tuncay Baskan
If your database server is SQL Server, Profiler can help to see what is going to database server. On 7/22/05, Ed Griebel <[EMAIL PROTECTED]> wrote: > You could try using p6spy to see what query(s) iBatis is sending along > and if it's what you expect. > > http://www.p6spy.com/ > > -ed > > On 7

Re: Slow ibatis query

2005-07-21 Thread Ed Griebel
Is it possible that you are relying on the "default" transaction handling for the different cases, and that the default is different for each one? I guess this doesn't make sense when it's a read-only select though! -ed On 7/21/05, Greg Day <[EMAIL PROTECTED]> wrote: > Thanks for that. > I have a

Estimating amount of memory need for cache

2005-07-21 Thread Nathan Maves
What is the best and most accurate way to calculate the space needed to cache a query. Say I have a query that returns 5 strings on average of 20 chars each. The query returns 5000 rows. I know this seems high but just humor me and remember I have access to big servers here at Sun :) Nath

RE: Slow ibatis query

2005-07-21 Thread Greg Day
Thanks for that. I have already done that, this is why I am so confused. The queries are exactly the same... I can cut out of the p6spy log, and run in through jdbc and its fine... the only difference as far as I can see is that one runs through ibatis, the other through jdbc. it is very very

Re: Slow ibatis query

2005-07-21 Thread Ed Griebel
You could try using p6spy to see what query(s) iBatis is sending along and if it's what you expect. http://www.p6spy.com/ -ed On 7/21/05, Greg Day <[EMAIL PROTECTED]> wrote: > > > Hi all > > I have a strange problem, we are using ibatis as our data access layer, and > everything generally

Slow ibatis query

2005-07-21 Thread Greg Day
Title: Slow ibatis query Hi all I have a strange problem, we are using ibatis as our data access layer, and everything generally goes fine. I recently added a query, which essentially does a "select * from X where primary_key = ?" This query is very fast (300ms) when run externally throu

Re: DAO Objects - Hiding ?

2005-07-21 Thread Zarar Siddiqi
I'm not too sure what you're getting at. Are you suggesting that it's OK to have a method called "update" or "create" inside your POJO which accesses a datasource? - Original Message - From: "Steve Webb" <[EMAIL PROTECTED]> To: Sent: Thursday, July 21, 2005 7:26 AM Subject: DAO Obj

Re: Re: synchronization between DB and ibatis sqlmaps

2005-07-21 Thread Larry Meadors
Wel, IMO this is not a :-( situation. Unit tests are valuable, and should be a part of your development process. Seriously, if you have not yet started doing unit testing, try it! Using tools like JUnit+EMMA make it actually kind of fun. More like a puzzle than work - "How the heck do I get tha

Re: Re: synchronization between DB and ibatis sqlmaps

2005-07-21 Thread Fabio Insaccanebbia
You're right, I hadn't thought of this... :-( 2005/7/21, Larry Meadors <[EMAIL PROTECTED]>: > Because of $substitution$ it is not possibile. We have no way of > knowing what you are going to drop in there. In addition to that you > have ${properties}, too - again there is no way of knowing what yo

Re: trouble mapping sybase stored procedure to object

2005-07-21 Thread tony
Hi, On June 7, someone posted a message regarding an incompatability between Sybase's jdbc driver and newer versions of iBatis. I'm currently having the same problem-- all of my code no longer works with newer versions of iBatis. The poster's workaround, was to comment out two lines in SqlExec

org.xml.sax.SAXParseException: Attribute

2005-07-21 Thread Joe Gaber
Any ideas about why I'm getting these errors? Tomcat stdout.log - Creating shared instance of singleton bean 'dataSource' - Creating shared instance of singleton bean 'sqlMapClient' - Destroying singletons in factory {org.springframework.beans.factory.support.DefaultListableBeanFactory defining

Resultset metadata

2005-07-21 Thread Abdullah Kauchali
What's the best way to obtain resultset metadata from queries executed through iBatis?

Re: Re: synchronization between DB and ibatis sqlmaps

2005-07-21 Thread Larry Meadors
Because of $substitution$ it is not possibile. We have no way of knowing what you are going to drop in there. In addition to that you have ${properties}, too - again there is no way of knowing what you are going to drop in there. Larry On 7/21/05, Fabio Insaccanebbia <[EMAIL PROTECTED]> wrote: >

Re: Calling PL/PGSQL doesn't work?

2005-07-21 Thread Larry Meadors
Set This will force even queries to be committed. Larry On 7/21/05, Hendry <[EMAIL PROTECTED]> wrote: > Hi, I'm new to iBatis, I got stuck when calling functions in PostgreSQL 8 > using SqlMap. Here is the part of my xml: > > > > > > > resultClass="java.lang.Stri

Re: .Net vs Java

2005-07-21 Thread Larry Meadors
...and hopefully get the xml formats closer. ;-) On 7/21/05, Clinton Begin <[EMAIL PROTECTED]> wrote: > > I expect we'll start discussing iBATIS 3.0 sometime in September. At that > time, we can consolodate features, design and also align the version > numbers. > > Cheers, > Clinton > > >

Re: .Net vs Java

2005-07-21 Thread Clinton Begin
I expect we'll start discussing iBATIS 3.0 sometime in September.  At that time, we can consolodate features, design and also align the version numbers. Cheers, ClintonOn 7/20/05, Gilles Bayon <[EMAIL PROTECTED]> wrote: The .NET and Java version don't followed the same roadmap as the .NET is youn

Re: Re: synchronization between DB and ibatis sqlmaps

2005-07-21 Thread Fabio Insaccanebbia
While I agree that a complete test suite of the application would solve the "unnoticed db change" problem, maybe there could be a more direct way to face this issue in iBatis. Probably it would be sufficient an XML file with a set of "test parameters": there could be a "ibatis test" ant task that

RE: Re: synchronization between DB and ibatis sqlmaps

2005-07-21 Thread Akins, Greg
>unit testing increases productivity! >you should unit test only if you are lazy or in a rush. > >Otherwise, if you bill by the hour don't unit test. If testing increases productivity, you should especially do it in a rush. I don't have any SqlMaps problems make it into my app because they're

DAO Objects - Hiding ?

2005-07-21 Thread Steve Webb
Before acting on this e-mail or opening any attachments you are advised to read The Caudwell Holdings group of companies' disclaimer at the end of this e-mail. === Hi there, I'm new to iBatis so excuse my lack of knowledge. I am currently looki

Calling PL/PGSQL doesn't work?

2005-07-21 Thread Hendry
Hi, I'm new to iBatis, I got stuck when calling functions in PostgreSQL 8 using SqlMap. Here is the part of my xml: {call spEntrySender(?, ?, ?)} And here how I call it from my application: String m = (String) sqlMap.queryForObject("spEntrySender", msg); The proble

Calling PL/PGSQL doesn't work?

2005-07-21 Thread Hendry
Hi, I'm new to iBatis, I got stuck when calling functions in PostgreSQL 8 using SqlMap. Here is the part of my xml: {call spEntrySender(?, ?, ?)} And here how I call it from my application: String m = (String) sqlMap.queryForObject("spEntrySender", msg); The proble