You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Fred Janon <fj...@yahoo.com> on 2006/09/25 04:35:04 UTC
JavaScript + iBATIS
Hi Clinton,
I am very interested in seeing what you did with JavaScript & iBATIS. I
am working on a Javascript framework and iBatis seems an appealing
option to do the peristence part of it
Fred
--- Clinton Begin <cl...@gmail.com> wrote:
> Hi there,
>
> I don't have any plans. But I just did my iBATIS/Ajax demo in a talk
> at
> NFJS yesterday. It is pretty cool. I may put together a more
> complete
> example to publish somewhere. I'd be interested in knowing if people
> would
> considering building apps this way...
>
> Think just JavaScript + iBATIS.
>
> Clinton
>
> On 9/24/06, levan Dvalishvili <ad...@amostudio.com> wrote:
> >
> > Hi Clinton, I saw list of events on the website, is there any
> plans
> > visiting New York, in near future,monthly meetings of
> www.*nyjavasig*
> > .com/would be good place to give speech, "Ibatis Does AjAX
> presentation "
> > would be a bliss. (please J )
> >
> >
> >
> >
> >
> > *From:* nando.dev [mailto:nando.dev@gmail.com]
> > *Sent:* Saturday, September 23, 2006 3:41 PM
> > *To:* user-java@ibatis.apache.org
> > *Subject:* Re: question with boolean types..
> >
> >
> >
> > Hi Esperanza, the problem do you have is the type boolean of pl/sql
> isn´t
> > standard of JDBC, so do you have to write a wrapper to this
> function.
> >
> > 2006/6/26, Esperanza.Echeverria@steria.es
> <Esperanza.Echeverria@steria.es
> > >:
> >
> >
> > please, can anyone help me?
> > my problem is calling a stored procedure in ibatis and this
> functioncalled in pl/sql returns a boolean and i don´t know what are
> the correct
> > types in this case to be put in for no obtain an error ...
> >
> > <parameterMap id="misParametros" class="java.util.HashMap" >
> > <parameter property="parametro1" jdbcType="VARCHAR" javaType="
> > java.lang.Boolean" mode="OUT"/>
> > <parameter property="parametro2" jdbcType="VARCHAR" javaType="
> > java.lang.String" mode="IN"/>
> > <parameter property="parametro3" jdbcType="VARCHAR" javaType="
> > java.lang.String" mode="IN"/>
> > <parameter property="parametro4" jdbcType="VARCHAR" javaType="
> > java.lang.String" mode="IN"/>
> > <parameter property="parametro5" jdbcType="VARCHAR" javaType="
> > java.lang.String" mode="IN"/>
> > </parameterMap>
> > <procedure id="ejecutaTieneDuplicados"
> parameterMap="misParametros" >
> > {? = call report.tiene_duplicados(?,?,?,?)}
> > </procedure>
> >
> > the out parameter tells me an error :
> > DEBUG - {conn-100021} Connection
> > DEBUG - {pstm-100022} PreparedStatement: {? = call
> report.tiene_duplicados
> > (?,?,?,?)}
> > DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep,
> VCENTRO=90101,
> > 19-06-2006]
> > DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> > java.lang.String, java.lang.String]
> > DEBUG - Initializing,
> config='org.apache.struts.action.LocalStrings',
> > returnNull=true
> > 06/06/26 08:47:37 DaoException
> > ERROR - Ha ocurrido un error con la base de datos
> > com.ibatis.dao.client.DaoException: Failed to execute
> queryForObject - id
> > [ejecutaTieneDuplicados], parameterObject
> [{parametro4=VCENTRO=90101,
> > parametro2=JOSELUIS, parametro3=sip97.rep , parametro1=true,
> > parametro5=19-06-2006}]. Cause:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in
> > com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the Lis.misParametros.
> > --- Check the statement (update procedure failed).
> > --- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
> > PLS-00382: el tipo de la expresión no es correcto
> > ORA-06550: línea 1, columna 7:
> > PL/SQL: Statement ignored
> >
> >
> >
> > *Esperanza Echeverría de Miguel*
> > Steria España http://www.steria.es
> > C/Menéndez y Pelayo,3 bis 46010 Valencia
> > Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> > esperanza.echeverria@steria.es
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
Re: JavaScript + iBATIS
Posted by Clinton Begin <cl...@gmail.com>.
If you do decide to implement XML support, I don't recommend doing it this
way.... :-)
Instead, I'd add a couple of methods:
.QueryForXML()
Which would allow the mapping to still be to a Hashtable or a Domain Class,
but it would translate the properties or Dictionary key/value pairs into the
XML document structure.
The way that it's implemented for iBATIS for Java right now is cool, but it
is somewhat limiting and creates the need for duplication if you want both
XML and Beans or Maps. It also creates problems with lists of results and
the semantics for retrieving . Right
In any case, hope that helps.
Cheers,
Clinton
On 9/26/06, Gilles Bayon <ib...@gmail.com> wrote:
>
> No
>
> On 9/26/06, Rahul Singh ( Anant ) <ra...@anant.us> wrote:
> > Has this functionality filtered down to the .NET version yet?
> >
> > Rahul
> >
>
> --
> Cheers,
> Gilles
>
> <a href="http://www.amazon.com/gp/registry/6JCP7AORB0LE">Wish List</a>
>
Re: JavaScript + iBATIS
Posted by Gilles Bayon <ib...@gmail.com>.
No
On 9/26/06, Rahul Singh ( Anant ) <ra...@anant.us> wrote:
> Has this functionality filtered down to the .NET version yet?
>
> Rahul
>
--
Cheers,
Gilles
<a href="http://www.amazon.com/gp/registry/6JCP7AORB0LE">Wish List</a>
Re: JavaScript + iBATIS
Posted by "Rahul Singh ( Anant )" <ra...@anant.us>.
Has this functionality filtered down to the .NET version yet?
Rahul
On 9/25/06, Clinton Begin <cl...@gmail.com> wrote:
>
> Yep. XML it is. The JavaScript/DOM APIs are pretty simple for processing
> results from XML. JSON is good too...but XML is supported more widely and
> by more tools.
>
> In iBATIS it's as simple as:
>
> <select id="GetEmployeeXML" parameterClass="string" resultClass="xml">
>
> No beans, no maps, nothing. You can also use xml as a parameter or a
> string as a result depending on how simple or complex your needs are.
>
> Cheers,
> Clinton
>
> On 9/25/06, Levan Dvalishvili <dv...@verticali.com> wrote:
> >
> >
> > Don't want to go into off topic but I would prefer more feature
> > full Yahoo
> > UI over GWT.
> >
> > anyways, the reason I think Ibatis will do AJAX well in XML vs JSON is
> > :
> > I could get my persistence layer to give me XML ( which is possible with
> >
> > Ibatis, P.S Never tried it but documentation says so :))
> > for example if I get domain Object "A" in so and so XML format, I don't
> > even
> > need JSON, this XML (as is or transformed ) can hit as full or partial
> > AJAX
> > respond back to client . so Unless Ibatis can return JSON, as yet
> > another
> > alternative to Bean and/or XML, I would say XML format is quite enough
> > and
> > suitable already, so there is no need to "jsonize" bean or xml I think I
> > am
> > even thinking there s no need for JSON at all. Am I on right thinking
> > path
> > ? :)
> >
> > Levan .
> >
> >
> > -----Original Message-----
> > From: Rinaldo [mailto:rbonazzo@sardiniapoint.it ]
> > Sent: Monday, September 25, 2006 11:54 AM
> > To: user-java@ibatis.apache.org; lmeadors@apache.org
> > Subject: R: JavaScript + iBATIS
> >
> > You can find some json example using gwt
> >
> > http://code.google.com/webtoolkit/documentation/examples/
> >
> > Rinaldo
> >
> > -----Messaggio originale-----
> > Da: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] Per conto
> > di
> > Larry Meadors
> > Inviato: lunedì 25 settembre 2006 17.37
> > A: user-java@ibatis.apache.org
> > Oggetto: Re: JavaScript + iBATIS
> >
> > One approach that I have seen with good results is working with JSON to
> > create javascript objects with jsp.
> >
> > Larry
> >
> >
> > On 9/25/06, Levan Dvalishvili <dv...@verticali.com> wrote:
> > > I would say returning XML instead of java bean and sending it to
> > > client would be one of the straight forward ways to do it would not
> > > it? Maybe running a little XSL filter prior ?
> > >
> > >
> > > Levan Dvalishvili
> > > Support LeadUS
> > > Verticali,Inc
> > > (646) 736 - 6075
> > >
> > >
> > > -----Original Message-----
> > > From: Fred Janon [mailto:fjanon@yahoo.com]
> > > Sent: Sunday, September 24, 2006 10:35 PM
> > > To: user-java@ibatis.apache.org
> > > Subject: JavaScript + iBATIS
> > >
> > > Hi Clinton,
> > >
> > > I am very interested in seeing what you did with JavaScript & iBATIS.
> > > I am working on a Javascript framework and iBatis seems an appealing
> > > option to
> > do
> > > the peristence part of it
> > >
> > > Fred
> > >
> > > --- Clinton Begin <cl...@gmail.com> wrote:
> > >
> > > > Hi there,
> > > >
> > > > I don't have any plans. But I just did my iBATIS/Ajax demo in a
> > > > talk at NFJS yesterday. It is pretty cool. I may put together a
> > > > more complete example to publish somewhere. I'd be interested in
> > > > knowing if people would considering building apps this way...
> > > >
> > > > Think just JavaScript + iBATIS.
> > > >
> > > > Clinton
> > > >
> > > > On 9/24/06, levan Dvalishvili < admin@amostudio.com> wrote:
> > > > >
> > > > > Hi Clinton, I saw list of events on the website, is there any
> > > > plans
> > > > > visiting New York, in near future,monthly meetings of
> > > > www.*nyjavasig*
> > > > > .com/would be good place to give speech, "Ibatis Does AjAX
> > > > presentation "
> > > > > would be a bliss. (please J )
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > *From:* nando.dev [mailto:nando.dev@gmail.com]
> > > > > *Sent:* Saturday, September 23, 2006 3:41 PM
> > > > > *To:* user-java@ibatis.apache.org
> > > > > *Subject:* Re: question with boolean types..
> > > > >
> > > > >
> > > > >
> > > > > Hi Esperanza, the problem do you have is the type boolean of
> > > > > pl/sql
> > > > isn´t
> > > > > standard of JDBC, so do you have to write a wrapper to this
> > > > function.
> > > > >
> > > > > 2006/6/26, Esperanza.Echeverria@steria.es
> > > > <Esperanza.Echeverria@steria.es
> > > > > >:
> > > > >
> > > > >
> > > > > please, can anyone help me?
> > > > > my problem is calling a stored procedure in ibatis and this
> > > > functioncalled in pl/sql returns a boolean and i don´t know what are
> >
> > > > the correct
> > > > > types in this case to be put in for no obtain an error ...
> > > > >
> > > > > <parameterMap id="misParametros" class="java.util.HashMap" >
> > > > > <parameter property="parametro1" jdbcType="VARCHAR" javaType="
> > > > > java.lang.Boolean" mode="OUT"/>
> > > > > <parameter property="parametro2" jdbcType="VARCHAR" javaType="
> >
> > > > > java.lang.String" mode="IN"/>
> > > > > <parameter property="parametro3" jdbcType="VARCHAR" javaType="
> > > > > java.lang.String" mode="IN"/>
> > > > > <parameter property="parametro4" jdbcType="VARCHAR" javaType="
> > > > > java.lang.String" mode="IN"/>
> > > > > <parameter property="parametro5" jdbcType="VARCHAR" javaType="
> >
> > > > > java.lang.String" mode="IN"/>
> > > > > </parameterMap>
> > > > > <procedure id="ejecutaTieneDuplicados"
> > > > parameterMap="misParametros" >
> > > > > {? = call report.tiene_duplicados(?,?,?,?)}
> > > > > </procedure>
> > > > >
> > > > > the out parameter tells me an error :
> > > > > DEBUG - {conn-100021} Connection
> > > > > DEBUG - {pstm-100022} PreparedStatement: {? = call
> > > > report.tiene_duplicados
> > > > > (?,?,?,?)}
> > > > > DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep,
> > > > VCENTRO=90101,
> > > > > 19-06-2006]
> > > > > DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> > > > > java.lang.String, java.lang.String] DEBUG - Initializing,
> > > > config='org.apache.struts.action.LocalStrings ',
> > > > > returnNull=true
> > > > > 06/06/26 08:47:37 DaoException
> > > > > ERROR - Ha ocurrido un error con la base de datos
> > > > > com.ibatis.dao.client.DaoException: Failed to execute
> > > > queryForObject - id
> > > > > [ejecutaTieneDuplicados], parameterObject
> > > > [{parametro4=VCENTRO=90101,
> > > > > parametro2=JOSELUIS, parametro3=sip97.rep , parametro1=true,
> > > > > parametro5=19-06-2006}]. Cause:
> > > > > com.ibatis.common.jdbc.exception.NestedSQLException:
> > > > > --- The error occurred in
> > > > > com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> > > > > --- The error occurred while applying a parameter map.
> > > > > --- Check the Lis.misParametros.
> > > > > --- Check the statement (update procedure failed).
> > > > > --- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
> > > > > PLS-00382: el tipo de la expresión no es correcto
> > > > > ORA-06550: línea 1, columna 7:
> > > > > PL/SQL: Statement ignored
> > > > >
> > > > >
> > > > >
> > > > > *Esperanza Echeverría de Miguel*
> > > > > Steria España http://www.steria.es C/Menéndez y Pelayo,3 bis 46010
> > > > > Valencia
> > > > > Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> > > > > esperanza.echeverria@steria.es
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> >
> >
>
--
Rahul Singh
CEO, Anant
http://www.anant.us
Office: 7033723268
Mobile: 7036555652
Re: JavaScript + iBATIS
Posted by Larry Meadors <lm...@apache.org>.
Yeah, we just need to make queryForList return a list in a document,
not a list of documents.
I think it'd also be a reasonably trivial exercise to make a bean/map
-> json converter, too.
Larry
On 9/25/06, Clinton Begin <cl...@gmail.com> wrote:
> Yep. XML it is. The JavaScript/DOM APIs are pretty simple for processing
> results from XML. JSON is good too...but XML is supported more widely and
> by more tools.
>
> In iBATIS it's as simple as:
>
> <select id="GetEmployeeXML" parameterClass="string" resultClass="xml">
>
> No beans, no maps, nothing. You can also use xml as a parameter or a string
> as a result depending on how simple or complex your needs are.
>
> Cheers,
> Clinton
>
>
> On 9/25/06, Levan Dvalishvili <dv...@verticali.com> wrote:
> >
> > Don't want to go into off topic but I would prefer more feature full
> Yahoo
> > UI over GWT.
> >
> > anyways, the reason I think Ibatis will do AJAX well in XML vs JSON is :
> > I could get my persistence layer to give me XML ( which is possible with
> > Ibatis, P.S Never tried it but documentation says so :))
> > for example if I get domain Object "A" in so and so XML format, I don't
> even
> > need JSON, this XML (as is or transformed ) can hit as full or partial
> AJAX
> > respond back to client . so Unless Ibatis can return JSON, as yet another
> > alternative to Bean and/or XML, I would say XML format is quite enough and
> > suitable already, so there is no need to "jsonize" bean or xml I think I
> am
> > even thinking there s no need for JSON at all. Am I on right thinking
> path
> > ? :)
> >
> > Levan .
> >
> >
> > -----Original Message-----
> > From: Rinaldo [mailto:rbonazzo@sardiniapoint.it ]
> > Sent: Monday, September 25, 2006 11:54 AM
> > To: user-java@ibatis.apache.org; lmeadors@apache.org
> > Subject: R: JavaScript + iBATIS
> >
> > You can find some json example using gwt
> >
> > http://code.google.com/webtoolkit/documentation/examples/
> >
> > Rinaldo
> >
> > -----Messaggio originale-----
> > Da: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] Per conto di
> > Larry Meadors
> > Inviato: lunedì 25 settembre 2006 17.37
> > A: user-java@ibatis.apache.org
> > Oggetto: Re: JavaScript + iBATIS
> >
> > One approach that I have seen with good results is working with JSON to
> > create javascript objects with jsp.
> >
> > Larry
> >
> >
> > On 9/25/06, Levan Dvalishvili <dv...@verticali.com> wrote:
> > > I would say returning XML instead of java bean and sending it to
> > > client would be one of the straight forward ways to do it would not
> > > it? Maybe running a little XSL filter prior ?
> > >
> > >
> > > Levan Dvalishvili
> > > Support LeadUS
> > > Verticali,Inc
> > > (646) 736 - 6075
> > >
> > >
> > > -----Original Message-----
> > > From: Fred Janon [mailto:fjanon@yahoo.com]
> > > Sent: Sunday, September 24, 2006 10:35 PM
> > > To: user-java@ibatis.apache.org
> > > Subject: JavaScript + iBATIS
> > >
> > > Hi Clinton,
> > >
> > > I am very interested in seeing what you did with JavaScript & iBATIS.
> > > I am working on a Javascript framework and iBatis seems an appealing
> > > option to
> > do
> > > the peristence part of it
> > >
> > > Fred
> > >
> > > --- Clinton Begin <cl...@gmail.com> wrote:
> > >
> > > > Hi there,
> > > >
> > > > I don't have any plans. But I just did my iBATIS/Ajax demo in a
> > > > talk at NFJS yesterday. It is pretty cool. I may put together a
> > > > more complete example to publish somewhere. I'd be interested in
> > > > knowing if people would considering building apps this way...
> > > >
> > > > Think just JavaScript + iBATIS.
> > > >
> > > > Clinton
> > > >
> > > > On 9/24/06, levan Dvalishvili < admin@amostudio.com> wrote:
> > > > >
> > > > > Hi Clinton, I saw list of events on the website, is there any
> > > > plans
> > > > > visiting New York, in near future,monthly meetings of
> > > > www.*nyjavasig*
> > > > > .com/would be good place to give speech, "Ibatis Does AjAX
> > > > presentation "
> > > > > would be a bliss. (please J )
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > *From:* nando.dev [mailto:nando.dev@gmail.com]
> > > > > *Sent:* Saturday, September 23, 2006 3:41 PM
> > > > > *To:* user-java@ibatis.apache.org
> > > > > *Subject:* Re: question with boolean types..
> > > > >
> > > > >
> > > > >
> > > > > Hi Esperanza, the problem do you have is the type boolean of
> > > > > pl/sql
> > > > isn´t
> > > > > standard of JDBC, so do you have to write a wrapper to this
> > > > function.
> > > > >
> > > > > 2006/6/26, Esperanza.Echeverria@steria.es
> > > > <Esperanza.Echeverria@steria.es
> > > > > >:
> > > > >
> > > > >
> > > > > please, can anyone help me?
> > > > > my problem is calling a stored procedure in ibatis and this
> > > > functioncalled in pl/sql returns a boolean and i don´t know what are
> > > > the correct
> > > > > types in this case to be put in for no obtain an error ...
> > > > >
> > > > > <parameterMap id="misParametros" class="java.util.HashMap" >
> > > > > <parameter property="parametro1" jdbcType="VARCHAR" javaType="
> > > > > java.lang.Boolean" mode="OUT"/>
> > > > > <parameter property="parametro2" jdbcType="VARCHAR" javaType="
> > > > > java.lang.String" mode="IN"/>
> > > > > <parameter property="parametro3" jdbcType="VARCHAR" javaType="
> > > > > java.lang.String" mode="IN"/>
> > > > > <parameter property="parametro4" jdbcType="VARCHAR" javaType="
> > > > > java.lang.String" mode="IN"/>
> > > > > <parameter property="parametro5" jdbcType="VARCHAR" javaType="
> > > > > java.lang.String" mode="IN"/>
> > > > > </parameterMap>
> > > > > <procedure id="ejecutaTieneDuplicados"
> > > > parameterMap="misParametros" >
> > > > > {? = call report.tiene_duplicados(?,?,?,?)}
> > > > > </procedure>
> > > > >
> > > > > the out parameter tells me an error :
> > > > > DEBUG - {conn-100021} Connection
> > > > > DEBUG - {pstm-100022} PreparedStatement: {? = call
> > > > report.tiene_duplicados
> > > > > (?,?,?,?)}
> > > > > DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep,
> > > > VCENTRO=90101,
> > > > > 19-06-2006]
> > > > > DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> > > > > java.lang.String, java.lang.String] DEBUG - Initializing,
> > > > config='org.apache.struts.action.LocalStrings ',
> > > > > returnNull=true
> > > > > 06/06/26 08:47:37 DaoException
> > > > > ERROR - Ha ocurrido un error con la base de datos
> > > > > com.ibatis.dao.client.DaoException: Failed to
> execute
> > > > queryForObject - id
> > > > > [ejecutaTieneDuplicados], parameterObject
> > > > [{parametro4=VCENTRO=90101,
> > > > > parametro2=JOSELUIS, parametro3=sip97.rep , parametro1=true,
> > > > > parametro5=19-06-2006}]. Cause:
> > > > >
> com.ibatis.common.jdbc.exception.NestedSQLException:
> > > > > --- The error occurred in
> > > > > com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> > > > > --- The error occurred while applying a parameter map.
> > > > > --- Check the Lis.misParametros.
> > > > > --- Check the statement (update procedure failed).
> > > > > --- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
> > > > > PLS-00382: el tipo de la expresión no es correcto
> > > > > ORA-06550: línea 1, columna 7:
> > > > > PL/SQL: Statement ignored
> > > > >
> > > > >
> > > > >
> > > > > *Esperanza Echeverría de Miguel*
> > > > > Steria España http://www.steria.es C/Menéndez y Pelayo,3 bis 46010
> > > > > Valencia
> > > > > Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> > > > > esperanza.echeverria@steria.es
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> >
> >
>
>
Re: JavaScript + iBATIS
Posted by Clinton Begin <cl...@gmail.com>.
Yep. XML it is. The JavaScript/DOM APIs are pretty simple for processing
results from XML. JSON is good too...but XML is supported more widely and
by more tools.
In iBATIS it's as simple as:
<select id="GetEmployeeXML" parameterClass="string" resultClass="xml">
No beans, no maps, nothing. You can also use xml as a parameter or a string
as a result depending on how simple or complex your needs are.
Cheers,
Clinton
On 9/25/06, Levan Dvalishvili <dv...@verticali.com> wrote:
>
>
> Don't want to go into off topic but I would prefer more feature
> full Yahoo
> UI over GWT.
>
> anyways, the reason I think Ibatis will do AJAX well in XML vs JSON is :
> I could get my persistence layer to give me XML ( which is possible with
> Ibatis, P.S Never tried it but documentation says so :))
> for example if I get domain Object "A" in so and so XML format, I don't
> even
> need JSON, this XML (as is or transformed ) can hit as full or partial
> AJAX
> respond back to client . so Unless Ibatis can return JSON, as yet another
> alternative to Bean and/or XML, I would say XML format is quite enough and
> suitable already, so there is no need to "jsonize" bean or xml I think I
> am
> even thinking there s no need for JSON at all. Am I on right thinking
> path
> ? :)
>
> Levan .
>
>
> -----Original Message-----
> From: Rinaldo [mailto:rbonazzo@sardiniapoint.it]
> Sent: Monday, September 25, 2006 11:54 AM
> To: user-java@ibatis.apache.org; lmeadors@apache.org
> Subject: R: JavaScript + iBATIS
>
> You can find some json example using gwt
>
> http://code.google.com/webtoolkit/documentation/examples/
>
> Rinaldo
>
> -----Messaggio originale-----
> Da: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] Per conto di
> Larry Meadors
> Inviato: lunedì 25 settembre 2006 17.37
> A: user-java@ibatis.apache.org
> Oggetto: Re: JavaScript + iBATIS
>
> One approach that I have seen with good results is working with JSON to
> create javascript objects with jsp.
>
> Larry
>
>
> On 9/25/06, Levan Dvalishvili <dv...@verticali.com> wrote:
> > I would say returning XML instead of java bean and sending it to
> > client would be one of the straight forward ways to do it would not
> > it? Maybe running a little XSL filter prior ?
> >
> >
> > Levan Dvalishvili
> > Support LeadUS
> > Verticali,Inc
> > (646) 736 - 6075
> >
> >
> > -----Original Message-----
> > From: Fred Janon [mailto:fjanon@yahoo.com]
> > Sent: Sunday, September 24, 2006 10:35 PM
> > To: user-java@ibatis.apache.org
> > Subject: JavaScript + iBATIS
> >
> > Hi Clinton,
> >
> > I am very interested in seeing what you did with JavaScript & iBATIS.
> > I am working on a Javascript framework and iBatis seems an appealing
> > option to
> do
> > the peristence part of it
> >
> > Fred
> >
> > --- Clinton Begin <cl...@gmail.com> wrote:
> >
> > > Hi there,
> > >
> > > I don't have any plans. But I just did my iBATIS/Ajax demo in a
> > > talk at NFJS yesterday. It is pretty cool. I may put together a
> > > more complete example to publish somewhere. I'd be interested in
> > > knowing if people would considering building apps this way...
> > >
> > > Think just JavaScript + iBATIS.
> > >
> > > Clinton
> > >
> > > On 9/24/06, levan Dvalishvili <ad...@amostudio.com> wrote:
> > > >
> > > > Hi Clinton, I saw list of events on the website, is there any
> > > plans
> > > > visiting New York, in near future,monthly meetings of
> > > www.*nyjavasig*
> > > > .com/would be good place to give speech, "Ibatis Does AjAX
> > > presentation "
> > > > would be a bliss. (please J )
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > *From:* nando.dev [mailto:nando.dev@gmail.com]
> > > > *Sent:* Saturday, September 23, 2006 3:41 PM
> > > > *To:* user-java@ibatis.apache.org
> > > > *Subject:* Re: question with boolean types..
> > > >
> > > >
> > > >
> > > > Hi Esperanza, the problem do you have is the type boolean of
> > > > pl/sql
> > > isn´t
> > > > standard of JDBC, so do you have to write a wrapper to this
> > > function.
> > > >
> > > > 2006/6/26, Esperanza.Echeverria@steria.es
> > > <Esperanza.Echeverria@steria.es
> > > > >:
> > > >
> > > >
> > > > please, can anyone help me?
> > > > my problem is calling a stored procedure in ibatis and this
> > > functioncalled in pl/sql returns a boolean and i don´t know what are
> > > the correct
> > > > types in this case to be put in for no obtain an error ...
> > > >
> > > > <parameterMap id="misParametros" class="java.util.HashMap" >
> > > > <parameter property="parametro1" jdbcType="VARCHAR" javaType="
> > > > java.lang.Boolean" mode="OUT"/>
> > > > <parameter property="parametro2" jdbcType="VARCHAR" javaType="
> > > > java.lang.String" mode="IN"/>
> > > > <parameter property="parametro3" jdbcType="VARCHAR" javaType="
> > > > java.lang.String" mode="IN"/>
> > > > <parameter property="parametro4" jdbcType="VARCHAR" javaType="
> > > > java.lang.String" mode="IN"/>
> > > > <parameter property="parametro5" jdbcType="VARCHAR" javaType="
> > > > java.lang.String" mode="IN"/>
> > > > </parameterMap>
> > > > <procedure id="ejecutaTieneDuplicados"
> > > parameterMap="misParametros" >
> > > > {? = call report.tiene_duplicados(?,?,?,?)}
> > > > </procedure>
> > > >
> > > > the out parameter tells me an error :
> > > > DEBUG - {conn-100021} Connection
> > > > DEBUG - {pstm-100022} PreparedStatement: {? = call
> > > report.tiene_duplicados
> > > > (?,?,?,?)}
> > > > DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep,
> > > VCENTRO=90101,
> > > > 19-06-2006]
> > > > DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> > > > java.lang.String, java.lang.String] DEBUG - Initializing,
> > > config='org.apache.struts.action.LocalStrings',
> > > > returnNull=true
> > > > 06/06/26 08:47:37 DaoException
> > > > ERROR - Ha ocurrido un error con la base de datos
> > > > com.ibatis.dao.client.DaoException: Failed to execute
> > > queryForObject - id
> > > > [ejecutaTieneDuplicados], parameterObject
> > > [{parametro4=VCENTRO=90101,
> > > > parametro2=JOSELUIS, parametro3=sip97.rep , parametro1=true,
> > > > parametro5=19-06-2006}]. Cause:
> > > > com.ibatis.common.jdbc.exception.NestedSQLException:
> > > > --- The error occurred in
> > > > com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> > > > --- The error occurred while applying a parameter map.
> > > > --- Check the Lis.misParametros.
> > > > --- Check the statement (update procedure failed).
> > > > --- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
> > > > PLS-00382: el tipo de la expresión no es correcto
> > > > ORA-06550: línea 1, columna 7:
> > > > PL/SQL: Statement ignored
> > > >
> > > >
> > > >
> > > > *Esperanza Echeverría de Miguel*
> > > > Steria España http://www.steria.es C/Menéndez y Pelayo,3 bis 46010
> > > > Valencia
> > > > Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> > > > esperanza.echeverria@steria.es
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
>
>
>
RE: JavaScript + iBATIS
Posted by Levan Dvalishvili <dv...@verticali.com>.
Dont want to go into off topic but I would prefer more feature full Yahoo
UI over GWT.
anyways, the reason I think Ibatis will do AJAX well in XML vs JSON is :
I could get my persistence layer to give me XML ( which is possible with
Ibatis, P.S Never tried it but documentation says so :))
for example if I get domain Object "A" in so and so XML format, I dont even
need JSON, this XML (as is or transformed ) can hit as full or partial AJAX
respond back to client . so Unless Ibatis can return JSON, as yet another
alternative to Bean and/or XML, I would say XML format is quite enough and
suitable already, so there is no need to "jsonize" bean or xml I think I am
even thinking there s no need for JSON at all. Am I on right thinking path
? :)
Levan .
-----Original Message-----
From: Rinaldo [mailto:rbonazzo@sardiniapoint.it]
Sent: Monday, September 25, 2006 11:54 AM
To: user-java@ibatis.apache.org; lmeadors@apache.org
Subject: R: JavaScript + iBATIS
You can find some json example using gwt
http://code.google.com/webtoolkit/documentation/examples/
Rinaldo
-----Messaggio originale-----
Da: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] Per conto di
Larry Meadors
Inviato: lunedì 25 settembre 2006 17.37
A: user-java@ibatis.apache.org
Oggetto: Re: JavaScript + iBATIS
One approach that I have seen with good results is working with JSON to
create javascript objects with jsp.
Larry
On 9/25/06, Levan Dvalishvili <dv...@verticali.com> wrote:
> I would say returning XML instead of java bean and sending it to
> client would be one of the straight forward ways to do it would not
> it? Maybe running a little XSL filter prior ?
>
>
> Levan Dvalishvili
> Support LeadUS
> Verticali,Inc
> (646) 736 - 6075
>
>
> -----Original Message-----
> From: Fred Janon [mailto:fjanon@yahoo.com]
> Sent: Sunday, September 24, 2006 10:35 PM
> To: user-java@ibatis.apache.org
> Subject: JavaScript + iBATIS
>
> Hi Clinton,
>
> I am very interested in seeing what you did with JavaScript & iBATIS.
> I am working on a Javascript framework and iBatis seems an appealing
> option to
do
> the peristence part of it
>
> Fred
>
> --- Clinton Begin <cl...@gmail.com> wrote:
>
> > Hi there,
> >
> > I don't have any plans. But I just did my iBATIS/Ajax demo in a
> > talk at NFJS yesterday. It is pretty cool. I may put together a
> > more complete example to publish somewhere. I'd be interested in
> > knowing if people would considering building apps this way...
> >
> > Think just JavaScript + iBATIS.
> >
> > Clinton
> >
> > On 9/24/06, levan Dvalishvili <ad...@amostudio.com> wrote:
> > >
> > > Hi Clinton, I saw list of events on the website, is there any
> > plans
> > > visiting New York, in near future,monthly meetings of
> > www.*nyjavasig*
> > > .com/would be good place to give speech, "Ibatis Does AjAX
> > presentation "
> > > would be a bliss. (please J )
> > >
> > >
> > >
> > >
> > >
> > > *From:* nando.dev [mailto:nando.dev@gmail.com]
> > > *Sent:* Saturday, September 23, 2006 3:41 PM
> > > *To:* user-java@ibatis.apache.org
> > > *Subject:* Re: question with boolean types..
> > >
> > >
> > >
> > > Hi Esperanza, the problem do you have is the type boolean of
> > > pl/sql
> > isn´t
> > > standard of JDBC, so do you have to write a wrapper to this
> > function.
> > >
> > > 2006/6/26, Esperanza.Echeverria@steria.es
> > <Esperanza.Echeverria@steria.es
> > > >:
> > >
> > >
> > > please, can anyone help me?
> > > my problem is calling a stored procedure in ibatis and this
> > functioncalled in pl/sql returns a boolean and i don´t know what are
> > the correct
> > > types in this case to be put in for no obtain an error ...
> > >
> > > <parameterMap id="misParametros" class="java.util.HashMap" >
> > > <parameter property="parametro1" jdbcType="VARCHAR" javaType="
> > > java.lang.Boolean" mode="OUT"/>
> > > <parameter property="parametro2" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > <parameter property="parametro3" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > <parameter property="parametro4" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > <parameter property="parametro5" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > </parameterMap>
> > > <procedure id="ejecutaTieneDuplicados"
> > parameterMap="misParametros" >
> > > {? = call report.tiene_duplicados(?,?,?,?)}
> > > </procedure>
> > >
> > > the out parameter tells me an error :
> > > DEBUG - {conn-100021} Connection
> > > DEBUG - {pstm-100022} PreparedStatement: {? = call
> > report.tiene_duplicados
> > > (?,?,?,?)}
> > > DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep,
> > VCENTRO=90101,
> > > 19-06-2006]
> > > DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> > > java.lang.String, java.lang.String] DEBUG - Initializing,
> > config='org.apache.struts.action.LocalStrings',
> > > returnNull=true
> > > 06/06/26 08:47:37 DaoException
> > > ERROR - Ha ocurrido un error con la base de datos
> > > com.ibatis.dao.client.DaoException: Failed to execute
> > queryForObject - id
> > > [ejecutaTieneDuplicados], parameterObject
> > [{parametro4=VCENTRO=90101,
> > > parametro2=JOSELUIS, parametro3=sip97.rep , parametro1=true,
> > > parametro5=19-06-2006}]. Cause:
> > > com.ibatis.common.jdbc.exception.NestedSQLException:
> > > --- The error occurred in
> > > com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> > > --- The error occurred while applying a parameter map.
> > > --- Check the Lis.misParametros.
> > > --- Check the statement (update procedure failed).
> > > --- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
> > > PLS-00382: el tipo de la expresión no es correcto
> > > ORA-06550: línea 1, columna 7:
> > > PL/SQL: Statement ignored
> > >
> > >
> > >
> > > *Esperanza Echeverría de Miguel*
> > > Steria España http://www.steria.es C/Menéndez y Pelayo,3 bis 46010
> > > Valencia
> > > Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> > > esperanza.echeverria@steria.es
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
>
R: JavaScript + iBATIS
Posted by Rinaldo <rb...@sardiniapoint.it>.
You can find some json example using gwt
http://code.google.com/webtoolkit/documentation/examples/
Rinaldo
-----Messaggio originale-----
Da: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] Per conto di
Larry Meadors
Inviato: lunedì 25 settembre 2006 17.37
A: user-java@ibatis.apache.org
Oggetto: Re: JavaScript + iBATIS
One approach that I have seen with good results is working with JSON
to create javascript objects with jsp.
Larry
On 9/25/06, Levan Dvalishvili <dv...@verticali.com> wrote:
> I would say returning XML instead of java bean and sending it to client
> would be one of the straight forward ways to do it would not it? Maybe
> running a little XSL filter prior ?
>
>
> Levan Dvalishvili
> Support LeadUS
> Verticali,Inc
> (646) 736 - 6075
>
>
> -----Original Message-----
> From: Fred Janon [mailto:fjanon@yahoo.com]
> Sent: Sunday, September 24, 2006 10:35 PM
> To: user-java@ibatis.apache.org
> Subject: JavaScript + iBATIS
>
> Hi Clinton,
>
> I am very interested in seeing what you did with JavaScript & iBATIS. I am
> working on a Javascript framework and iBatis seems an appealing option to
do
> the peristence part of it
>
> Fred
>
> --- Clinton Begin <cl...@gmail.com> wrote:
>
> > Hi there,
> >
> > I don't have any plans. But I just did my iBATIS/Ajax demo in a talk
> > at NFJS yesterday. It is pretty cool. I may put together a more
> > complete example to publish somewhere. I'd be interested in knowing
> > if people would considering building apps this way...
> >
> > Think just JavaScript + iBATIS.
> >
> > Clinton
> >
> > On 9/24/06, levan Dvalishvili <ad...@amostudio.com> wrote:
> > >
> > > Hi Clinton, I saw list of events on the website, is there any
> > plans
> > > visiting New York, in near future,monthly meetings of
> > www.*nyjavasig*
> > > .com/would be good place to give speech, "Ibatis Does AjAX
> > presentation "
> > > would be a bliss. (please J )
> > >
> > >
> > >
> > >
> > >
> > > *From:* nando.dev [mailto:nando.dev@gmail.com]
> > > *Sent:* Saturday, September 23, 2006 3:41 PM
> > > *To:* user-java@ibatis.apache.org
> > > *Subject:* Re: question with boolean types..
> > >
> > >
> > >
> > > Hi Esperanza, the problem do you have is the type boolean of pl/sql
> > isn´t
> > > standard of JDBC, so do you have to write a wrapper to this
> > function.
> > >
> > > 2006/6/26, Esperanza.Echeverria@steria.es
> > <Esperanza.Echeverria@steria.es
> > > >:
> > >
> > >
> > > please, can anyone help me?
> > > my problem is calling a stored procedure in ibatis and this
> > functioncalled in pl/sql returns a boolean and i don´t know what are
> > the correct
> > > types in this case to be put in for no obtain an error ...
> > >
> > > <parameterMap id="misParametros" class="java.util.HashMap" >
> > > <parameter property="parametro1" jdbcType="VARCHAR" javaType="
> > > java.lang.Boolean" mode="OUT"/>
> > > <parameter property="parametro2" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > <parameter property="parametro3" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > <parameter property="parametro4" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > <parameter property="parametro5" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > </parameterMap>
> > > <procedure id="ejecutaTieneDuplicados"
> > parameterMap="misParametros" >
> > > {? = call report.tiene_duplicados(?,?,?,?)}
> > > </procedure>
> > >
> > > the out parameter tells me an error :
> > > DEBUG - {conn-100021} Connection
> > > DEBUG - {pstm-100022} PreparedStatement: {? = call
> > report.tiene_duplicados
> > > (?,?,?,?)}
> > > DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep,
> > VCENTRO=90101,
> > > 19-06-2006]
> > > DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> > > java.lang.String, java.lang.String] DEBUG - Initializing,
> > config='org.apache.struts.action.LocalStrings',
> > > returnNull=true
> > > 06/06/26 08:47:37 DaoException
> > > ERROR - Ha ocurrido un error con la base de datos
> > > com.ibatis.dao.client.DaoException: Failed to execute
> > queryForObject - id
> > > [ejecutaTieneDuplicados], parameterObject
> > [{parametro4=VCENTRO=90101,
> > > parametro2=JOSELUIS, parametro3=sip97.rep , parametro1=true,
> > > parametro5=19-06-2006}]. Cause:
> > > com.ibatis.common.jdbc.exception.NestedSQLException:
> > > --- The error occurred in
> > > com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> > > --- The error occurred while applying a parameter map.
> > > --- Check the Lis.misParametros.
> > > --- Check the statement (update procedure failed).
> > > --- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
> > > PLS-00382: el tipo de la expresión no es correcto
> > > ORA-06550: línea 1, columna 7:
> > > PL/SQL: Statement ignored
> > >
> > >
> > >
> > > *Esperanza Echeverría de Miguel*
> > > Steria España http://www.steria.es
> > > C/Menéndez y Pelayo,3 bis 46010 Valencia
> > > Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> > > esperanza.echeverria@steria.es
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
>
Re: JavaScript + iBATIS
Posted by Larry Meadors <lm...@apache.org>.
One approach that I have seen with good results is working with JSON
to create javascript objects with jsp.
Larry
On 9/25/06, Levan Dvalishvili <dv...@verticali.com> wrote:
> I would say returning XML instead of java bean and sending it to client
> would be one of the straight forward ways to do it would not it? Maybe
> running a little XSL filter prior ?
>
>
> Levan Dvalishvili
> Support LeadUS
> Verticali,Inc
> (646) 736 - 6075
>
>
> -----Original Message-----
> From: Fred Janon [mailto:fjanon@yahoo.com]
> Sent: Sunday, September 24, 2006 10:35 PM
> To: user-java@ibatis.apache.org
> Subject: JavaScript + iBATIS
>
> Hi Clinton,
>
> I am very interested in seeing what you did with JavaScript & iBATIS. I am
> working on a Javascript framework and iBatis seems an appealing option to do
> the peristence part of it
>
> Fred
>
> --- Clinton Begin <cl...@gmail.com> wrote:
>
> > Hi there,
> >
> > I don't have any plans. But I just did my iBATIS/Ajax demo in a talk
> > at NFJS yesterday. It is pretty cool. I may put together a more
> > complete example to publish somewhere. I'd be interested in knowing
> > if people would considering building apps this way...
> >
> > Think just JavaScript + iBATIS.
> >
> > Clinton
> >
> > On 9/24/06, levan Dvalishvili <ad...@amostudio.com> wrote:
> > >
> > > Hi Clinton, I saw list of events on the website, is there any
> > plans
> > > visiting New York, in near future,monthly meetings of
> > www.*nyjavasig*
> > > .com/would be good place to give speech, "Ibatis Does AjAX
> > presentation "
> > > would be a bliss. (please J )
> > >
> > >
> > >
> > >
> > >
> > > *From:* nando.dev [mailto:nando.dev@gmail.com]
> > > *Sent:* Saturday, September 23, 2006 3:41 PM
> > > *To:* user-java@ibatis.apache.org
> > > *Subject:* Re: question with boolean types..
> > >
> > >
> > >
> > > Hi Esperanza, the problem do you have is the type boolean of pl/sql
> > isn´t
> > > standard of JDBC, so do you have to write a wrapper to this
> > function.
> > >
> > > 2006/6/26, Esperanza.Echeverria@steria.es
> > <Esperanza.Echeverria@steria.es
> > > >:
> > >
> > >
> > > please, can anyone help me?
> > > my problem is calling a stored procedure in ibatis and this
> > functioncalled in pl/sql returns a boolean and i don´t know what are
> > the correct
> > > types in this case to be put in for no obtain an error ...
> > >
> > > <parameterMap id="misParametros" class="java.util.HashMap" >
> > > <parameter property="parametro1" jdbcType="VARCHAR" javaType="
> > > java.lang.Boolean" mode="OUT"/>
> > > <parameter property="parametro2" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > <parameter property="parametro3" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > <parameter property="parametro4" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > <parameter property="parametro5" jdbcType="VARCHAR" javaType="
> > > java.lang.String" mode="IN"/>
> > > </parameterMap>
> > > <procedure id="ejecutaTieneDuplicados"
> > parameterMap="misParametros" >
> > > {? = call report.tiene_duplicados(?,?,?,?)}
> > > </procedure>
> > >
> > > the out parameter tells me an error :
> > > DEBUG - {conn-100021} Connection
> > > DEBUG - {pstm-100022} PreparedStatement: {? = call
> > report.tiene_duplicados
> > > (?,?,?,?)}
> > > DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep,
> > VCENTRO=90101,
> > > 19-06-2006]
> > > DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> > > java.lang.String, java.lang.String] DEBUG - Initializing,
> > config='org.apache.struts.action.LocalStrings',
> > > returnNull=true
> > > 06/06/26 08:47:37 DaoException
> > > ERROR - Ha ocurrido un error con la base de datos
> > > com.ibatis.dao.client.DaoException: Failed to execute
> > queryForObject - id
> > > [ejecutaTieneDuplicados], parameterObject
> > [{parametro4=VCENTRO=90101,
> > > parametro2=JOSELUIS, parametro3=sip97.rep , parametro1=true,
> > > parametro5=19-06-2006}]. Cause:
> > > com.ibatis.common.jdbc.exception.NestedSQLException:
> > > --- The error occurred in
> > > com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> > > --- The error occurred while applying a parameter map.
> > > --- Check the Lis.misParametros.
> > > --- Check the statement (update procedure failed).
> > > --- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
> > > PLS-00382: el tipo de la expresión no es correcto
> > > ORA-06550: línea 1, columna 7:
> > > PL/SQL: Statement ignored
> > >
> > >
> > >
> > > *Esperanza Echeverría de Miguel*
> > > Steria España http://www.steria.es
> > > C/Menéndez y Pelayo,3 bis 46010 Valencia
> > > Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> > > esperanza.echeverria@steria.es
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
>
RE: JavaScript + iBATIS
Posted by Levan Dvalishvili <dv...@verticali.com>.
I would say returning XML instead of java bean and sending it to client
would be one of the straight forward ways to do it would not it? Maybe
running a little XSL filter prior ?
Levan Dvalishvili
Support Lead US
Verticali,Inc
(646) 736 - 6075
-----Original Message-----
From: Fred Janon [mailto:fjanon@yahoo.com]
Sent: Sunday, September 24, 2006 10:35 PM
To: user-java@ibatis.apache.org
Subject: JavaScript + iBATIS
Hi Clinton,
I am very interested in seeing what you did with JavaScript & iBATIS. I am
working on a Javascript framework and iBatis seems an appealing option to do
the peristence part of it
Fred
--- Clinton Begin <cl...@gmail.com> wrote:
> Hi there,
>
> I don't have any plans. But I just did my iBATIS/Ajax demo in a talk
> at NFJS yesterday. It is pretty cool. I may put together a more
> complete example to publish somewhere. I'd be interested in knowing
> if people would considering building apps this way...
>
> Think just JavaScript + iBATIS.
>
> Clinton
>
> On 9/24/06, levan Dvalishvili <ad...@amostudio.com> wrote:
> >
> > Hi Clinton, I saw list of events on the website, is there any
> plans
> > visiting New York, in near future,monthly meetings of
> www.*nyjavasig*
> > .com/would be good place to give speech, "Ibatis Does AjAX
> presentation "
> > would be a bliss. (please J )
> >
> >
> >
> >
> >
> > *From:* nando.dev [mailto:nando.dev@gmail.com]
> > *Sent:* Saturday, September 23, 2006 3:41 PM
> > *To:* user-java@ibatis.apache.org
> > *Subject:* Re: question with boolean types..
> >
> >
> >
> > Hi Esperanza, the problem do you have is the type boolean of pl/sql
> isn´t
> > standard of JDBC, so do you have to write a wrapper to this
> function.
> >
> > 2006/6/26, Esperanza.Echeverria@steria.es
> <Esperanza.Echeverria@steria.es
> > >:
> >
> >
> > please, can anyone help me?
> > my problem is calling a stored procedure in ibatis and this
> functioncalled in pl/sql returns a boolean and i don´t know what are
> the correct
> > types in this case to be put in for no obtain an error ...
> >
> > <parameterMap id="misParametros" class="java.util.HashMap" >
> > <parameter property="parametro1" jdbcType="VARCHAR" javaType="
> > java.lang.Boolean" mode="OUT"/>
> > <parameter property="parametro2" jdbcType="VARCHAR" javaType="
> > java.lang.String" mode="IN"/>
> > <parameter property="parametro3" jdbcType="VARCHAR" javaType="
> > java.lang.String" mode="IN"/>
> > <parameter property="parametro4" jdbcType="VARCHAR" javaType="
> > java.lang.String" mode="IN"/>
> > <parameter property="parametro5" jdbcType="VARCHAR" javaType="
> > java.lang.String" mode="IN"/>
> > </parameterMap>
> > <procedure id="ejecutaTieneDuplicados"
> parameterMap="misParametros" >
> > {? = call report.tiene_duplicados(?,?,?,?)}
> > </procedure>
> >
> > the out parameter tells me an error :
> > DEBUG - {conn-100021} Connection
> > DEBUG - {pstm-100022} PreparedStatement: {? = call
> report.tiene_duplicados
> > (?,?,?,?)}
> > DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep,
> VCENTRO=90101,
> > 19-06-2006]
> > DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> > java.lang.String, java.lang.String] DEBUG - Initializing,
> config='org.apache.struts.action.LocalStrings',
> > returnNull=true
> > 06/06/26 08:47:37 DaoException
> > ERROR - Ha ocurrido un error con la base de datos
> > com.ibatis.dao.client.DaoException: Failed to execute
> queryForObject - id
> > [ejecutaTieneDuplicados], parameterObject
> [{parametro4=VCENTRO=90101,
> > parametro2=JOSELUIS, parametro3=sip97.rep , parametro1=true,
> > parametro5=19-06-2006}]. Cause:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in
> > com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the Lis.misParametros.
> > --- Check the statement (update procedure failed).
> > --- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
> > PLS-00382: el tipo de la expresión no es correcto
> > ORA-06550: línea 1, columna 7:
> > PL/SQL: Statement ignored
> >
> >
> >
> > *Esperanza Echeverría de Miguel*
> > Steria España http://www.steria.es
> > C/Menéndez y Pelayo,3 bis 46010 Valencia
> > Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> > esperanza.echeverria@steria.es
> >
> >
> >
> >
> >
> >
> >
> >
> >
>