Re: Application Servers

2007-01-29 Thread Larry Meadors
No. :) On 1/29/07, André Rodrigues Pena <[EMAIL PROTECTED]> wrote: HI all, I just need to know if iBatis have some restriction regarding application servers. I know the answer is probably "no". But I want to be sure before starting a project thanks -- André Rodrigues Pena

Re: Can I use Map or XML result in mapping complex properties

2007-01-29 Thread roan
Hi, I have been trying to do the same with XML resultMaps, and I *think* I figured it out. Have not tested this exhaustively, but got expected results from last couple of junit's I ran. Key is the "xmlCollection" type alias, which is registered in com.ibatis.sqlmap.engine.builder.xml.SqlMapConfi

Application Servers

2007-01-29 Thread André Rodrigues Pena
HI all, I just need to know if iBatis have some restriction regarding application servers. I know the answer is probably "no". But I want to be sure before starting a project thanks -- André Rodrigues Pena

Re: Problems compiling

2007-01-29 Thread André Rodrigues Pena
Jeff, your ConnectionURL property saved my life. As Chris said, the "cant find main class" was a false message due to misconfiguration. Thank you all guys. You have been so useful and kind. On 1/29/07, Jeff Butler <[EMAIL PROTECTED]> wrote: See here: http://msdn2.microsoft.com/en-us/library/m

output parameters (register output parameters failed).

2007-01-29 Thread Diego Umpierre
Hi all, My problem is: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in br/com/lojasrenner/logistica/legadoebs/dao/integra_nt/mapping/ProcExecEbsDAOintegra_nt.xml. --- The error occurred while executing query procedure. --- Check the {call RN_AR_001_P(?,?,?, ?)}.

Re: Problems compiling

2007-01-29 Thread Jeff Butler
See here: http://msdn2.microsoft.com/en-us/library/ms378428.aspx I think it will be this value in your case: jdbc:sqlserver://localhost:1455;databaseName=PDV Jeff Butler On 1/29/07, André Rodrigues Pena <[EMAIL PROTECTED]> wrote: Jeff, thanks for replying I really skipped ConnectionURL

Re: Problems compiling

2007-01-29 Thread André Rodrigues Pena
Jeff, thanks for replying I really skipped ConnectionURL property because the DataSource component that comes with the JDBC driver I'm using does ask for connection URL and I don't know how to set it. On 1/29/07, Jeff Butler <[EMAIL PROTECTED]> wrote: You are missing the JDBC.ConnectionURL pro

Re: Problems compiling

2007-01-29 Thread André Rodrigues Pena
And another question: In the transaction manager mapping file, I have to define JDBC properties. My question is: How can I know what properties are available for setting? For instance, in the DOC it mentions some properties like username and password but what about the others? How can I know if

Re: Problems compiling

2007-01-29 Thread Jeff Butler
You are missing the JDBC.ConnectionURL property in your datasource configuration. SIMPLE datasource is documented in the iBATIS developers guide. Jeff Butler On 1/29/07, André Rodrigues Pena <[EMAIL PROTECTED]> wrote: Brandon, thanks, in this moment I'm seeing some of the material you sugge

Re: Problems compiling

2007-01-29 Thread André Rodrigues Pena
Brandon, thanks, in this moment I'm seeing some of the material you suggested me Chris, thanks but my project seems ok. As you know, After the application initializes it crashes with that message: "Could not find the main class. The program will exit". I did'nt mentioned it yet. May be it will he

RE: ORDER BY on multiple columns

2007-01-29 Thread Tuan.Le2
Hi Niels - Thanks very much for pointing out my mistyped. Tuan From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: Monday, January 29, 2007 11:03 AM To: user-java@ibatis.apache.org Subject: RE: ORDER BY on multiple columns Use: AND ra.job_number = #

RE: ORDER BY on multiple columns

2007-01-29 Thread Niels Beekman
Use: AND ra.job_number = #jobNumber# From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: maandag 29 januari 2007 20:00 To: user-java@ibatis.apache.org Subject: ORDER BY on multiple columns Hi, It seems that I missed some things very obvious b

ORDER BY on multiple columns

2007-01-29 Thread Tuan.Le2
Hi, It seems that I missed some things very obvious but I couldn't figure out what caused the error. I have a multiple columns in the ORDER BY clause as defined in the query below SELECT td.category AS "category", td.description AS "description",

Re: Problems compiling

2007-01-29 Thread Chris Lamey
On Mon, 2007-01-29 at 09:26 -0700, Chris Lamey wrote: > On Mon, 2007-01-29 at 11:43 -0200, André Rodrigues Pena wrote: > > > >Is Tests your Main-Class in the mainfest? > > > > I don't have a MANIFEST file because I'm not packaging it into a JAR. > > I'm just compiling and executing it locally :)

Re: Problems compiling

2007-01-29 Thread Chris Lamey
On Mon, 2007-01-29 at 11:43 -0200, André Rodrigues Pena wrote: > >Is Tests your Main-Class in the mainfest? > > I don't have a MANIFEST file because I'm not packaging it into a JAR. > I'm just compiling and executing it locally :) Sounds like a CLASSPATH issue. Here's what I would do. - Select

Re: column vs columnIndex

2007-01-29 Thread Koka Kiknadze
On 1/28/07, Clinton Begin <[EMAIL PROTECTED]> wrote: PS: Yes you can use column names with the resultMaps too, which should add very little overhead. But it's up to the driver at that point. Yes, you are definitely right. Drilled down to see that difference arises because OracleResultSet ge

Re: Problems compiling

2007-01-29 Thread Brandon Goodin
A few links should be of great help to you: http://ibatis.apache.org/ SQL Map Doc: http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf SQL Map Tutorial: http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2-Tutorial_en.pdf Hope that helps, Brandon On 1/29/07, André Rodrigues Pena

Re: Problems compiling

2007-01-29 Thread André Rodrigues Pena
Hi Graeme, thanks for replying FYI http://jtds.sourceforge.net/ The DataSource and driver provided by Microsoft are working fine. The problem is that, during the mapping process in the XML, I dont know what properties are available for setting. I don't know exactly how it works Is Tests your

Re: troubleshooting selectKey

2007-01-29 Thread Robert Campbell
That was it! Damn copy-paste bites me in the ass again. Thank you VERY much! On 1/29/07, Larry Meadors <[EMAIL PROTECTED]> wrote: Are you sure you are calling insert() and not update()? Larry On 1/29/07, Robert Campbell <[EMAIL PROTECTED]> wrote: > I've used iBatis for a while, and selectKe

Re: Problems compiling

2007-01-29 Thread Graeme J Sweeney
On Mon, 29 Jan 2007, Andr? Rodrigues Pena wrote: I'm new to iBatis, this is my first project. I'm trying to use it with a JDBC driver provided by Microsoft to access MS SQL 2005. Every time I try to FYI http://jtds.sourceforge.net/ run it on Eclipse I get the same error message: "Could not f

Re: troubleshooting selectKey

2007-01-29 Thread Larry Meadors
Are you sure you are calling insert() and not update()? Larry On 1/29/07, Robert Campbell <[EMAIL PROTECTED]> wrote: I've used iBatis for a while, and selectKey without trouble. For some reason, however, the following code won't work. It never calls setId() on the object passed in as a paramet

Re: How to handle null objects in nested ResultMaps

2007-01-29 Thread Stefan Langer
Larry Meadors wrote: On 11/30/06, Stefan Langer <[EMAIL PROTECTED]> wrote: I wonder if this is a feature other people might want so that it is worth filing an enhancement request. I'm thinking along the lines of a special flag on the result node that specifies whether to create an object if a sp

Problems compiling

2007-01-29 Thread André Rodrigues Pena
Hi all, I'm new to iBatis, this is my first project. I'm trying to use it with a JDBC driver provided by Microsoft to access MS SQL 2005. Every time I try to run it on Eclipse I get the same error message: "Could not find the main class. Program will exit". This error is often retrieved when you

troubleshooting selectKey

2007-01-29 Thread Robert Campbell
I've used iBatis for a while, and selectKey without trouble. For some reason, however, the following code won't work. It never calls setId() on the object passed in as a parameter. Basically i'm getting an Oracle error telling me id can't be null.. so selectKey isn't calling setId() before the Ins

Passing Custom Object to Oracle Procedure

2007-01-29 Thread francesco77
Hi to all, I have created this ORACLE package : CREATE OR REPLACE PACKAGE EXTRACT AS Type LIST is table of VARCHAR2(50); Type BEAN IS Record( CCF_START DATE, FUEL LIST LIST, FILENAME VARCHAR2(50) ); PROCEDURE receiveBeanFromJava(FORMBEAN BE