You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by Luke Poortinga <po...@clarkstate.cc.oh.us> on 2005/11/04 01:43:22 UTC

calling sql statements through string in code

Hi,

  I have looked in the reference manual but was unable to find an answer to my situation. It seems that it might leverage the IBatisNet.DataMapper.Configuration.Sql.Static.StaticSql class.
  I want to send a string sql statement database call from my code. I would like to use the configuration properties specified in my sqlmapper xml file. Is there anyway I can do this? Or is this property exposed so that I can modify it before I execute the statement?

Thanks,
Luke

Re: DLL ORACLE .NET

Posted by Mariano <ml...@yahoo.es>.
hi
thnks 
Gracias tío 
 --- Angel Valero <an...@yahoo.es> escribió:

> Hi Mariano, I'm using Microsoft.dll. Just add this
> in
> your "porviders.config":
> 
>     <provider
>         name="ms-oracle"
>         enabled="true"
>         assemblyName="System.Data.OracleClient,
> Version=1.0.5000.0, Culture=neutral,
> PublicKeyToken=b77a5c561934e089"
>        
>
connectionClass="System.Data.OracleClient.OracleConnection"
> 
>        
>
commandClass="System.Data.OracleClient.OracleCommand"
>        
>
parameterClass="System.Data.OracleClient.OracleParameter"
>        
>
parameterDbTypeClass="System.Data.OracleClient.OracleType"
>         parameterDbTypeProperty="OracleType"
>        
>
dataAdapterClass="System.Data.OracleClient.OracleDataAdapter"
>        
>
commandBuilderClass="System.Data.OracleClient.OracleCommandBuilder"
>         usePositionalParameters = "false"
>         useParameterPrefixInSql = "true"
>         useParameterPrefixInParameter = "false"
>         parameterPrefix=":" 
>     />
> 
> Saludos
> 
>  --- Mariano <ml...@yahoo.es> escribió:
> 
> > hi all
> > its possible to use dll of Microsoft to conect
> with
> > Oracle, o Ive to use the dlls of Oracle.
> > 
> > thkns
> >  --- Mariano <ml...@yahoo.es> escribió:
> > 
> > > thks
> > > ive installed the dll from ODP.NET , now its
> > working
> > > 
> > > 
> > >  --- Mario Chavez <ma...@gmail.com>
> > escribió:
> > > 
> > > > Mariano;
> > > > 
> > > > You need to install an Oracle client which
> will
> > > > install all the libraries
> > > > requiered to connect to a Oracle DB, besides
> > them
> > > > you need to install the
> > > > .NET Oracle Provider (ODP.NET
> <http://ODP.NET>).
> > > > 
> > > > You can find both libraries in otn.oracle.com
> > > > <http://otn.oracle.com>, just
> > > > keep in mind that the Oracle client size is
> > about
> > > > 300Mb.
> > > > 
> > > > On 11/7/05, Chad Humphries
> > > > <ch...@gmail.com> wrote:
> > > > >
> > > > > Mariano,
> > > > >
> > > > > I'm not sure on extras past the initial
> > > > distribution dlls.
> > > > > Unfortunately I don't have a machine handy
> at
> > > the
> > > > moment I can test
> > > > > and look this up on.
> > > > >
> > > > > -Chad
> > > > >
> > > > > On 11/7/05, Mariano <ml...@yahoo.es>
> wrote:
> > > > > > Thanks
> > > > > > how many dlls i need , because ive found
> > > > > > Oracle.DataAccess.dll , but now ask me
> > > > orapops9.dll
> > > > > >
> > > > > >
> > > > > > thnks
> > > > > > --- Chad Humphries
> > <ch...@gmail.com>
> > > > > > escribió:
> > > > > >
> > > > > > > Mariano,
> > > > > > >
> > > > > > > You should be able to get it here:
> > > > > > >
> > > > > >
> > > >
> > >
> >
>
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
> > > > > > >
> > > > > > > Chad Humphries
> > > > > > > http://tiredidea.com/
> > > > > > >
> > > > > > > On 11/4/05, Mariano <ml...@yahoo.es>
> > > wrote:
> > > > > > > > Hi
> > > > > > > >
> > > > > > > > Ive tried use Ibatis.NET with Oracle ,
> > but
> > > > ive a
> > > > > > > > problem with dll. Somebody know where
> > can
> > > i
> > > > > > > download
> > > > > > > > the dll
> assemblyName="Oracle.DataAccess,
> > > > > > > > Version=9.2.0.401, Culture=neutral,
> > > > > > > >
> > > > > > >
> > > > > >
> > > >
> > >
> >
>
PublicKeyToken=89b483f429c47342"(Oracle.DataAccess.dll)
> > > > > > > >
> > > > > > > >
> > > > > > > > thnks
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > ______________________________________________
> > > > > > > > Renovamos el Correo Yahoo!
> > > > > > > > Nuevos servicios, más seguridad
> > > > > > > > http://correo.yahoo.es
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > ______________________________________________
> > > > > > Renovamos el Correo Yahoo!
> > > > > > Nuevos servicios, más seguridad
> > > > > > http://correo.yahoo.es
> > > > > >
> > > > >
> > > > 
> > > > 
> > > > 
> > > > --
> > > > Mario Chavez
> > > > mario.chavez@gmail.com
> > > >
> http://mario-chavez.decisionesinteligentes.com/
> > > > 
> > > 
> > > 
> > > 
> > > 	
> > > 	
> > > 		
> > > ______________________________________________ 
> > > Renovamos el Correo Yahoo! 
> > > Nuevos servicios, más seguridad 
> > > http://correo.yahoo.es
> > > 
> > 
> > 
> > 
> > 		
> > ______________________________________________ 
> > Renovamos el Correo Yahoo! 
> > Nuevos servicios, más seguridad 
> > http://correo.yahoo.es
> > 
> 
> 
> 
> 		
> ______________________________________________ 
> Renovamos el Correo Yahoo! 
> Nuevos servicios, más seguridad 
> http://correo.yahoo.es
> 



		
______________________________________________ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es

Re: DLL ORACLE .NET

Posted by Angel Valero <an...@yahoo.es>.
Hi Mariano, I'm using Microsoft.dll. Just add this in
your "porviders.config":

    <provider
        name="ms-oracle"
        enabled="true"
        assemblyName="System.Data.OracleClient,
Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
       
connectionClass="System.Data.OracleClient.OracleConnection"

       
commandClass="System.Data.OracleClient.OracleCommand"
       
parameterClass="System.Data.OracleClient.OracleParameter"
       
parameterDbTypeClass="System.Data.OracleClient.OracleType"
        parameterDbTypeProperty="OracleType"
       
dataAdapterClass="System.Data.OracleClient.OracleDataAdapter"
       
commandBuilderClass="System.Data.OracleClient.OracleCommandBuilder"
        usePositionalParameters = "false"
        useParameterPrefixInSql = "true"
        useParameterPrefixInParameter = "false"
        parameterPrefix=":" 
    />

Saludos

 --- Mariano <ml...@yahoo.es> escribió:

> hi all
> its possible to use dll of Microsoft to conect with
> Oracle, o Ive to use the dlls of Oracle.
> 
> thkns
>  --- Mariano <ml...@yahoo.es> escribió:
> 
> > thks
> > ive installed the dll from ODP.NET , now its
> working
> > 
> > 
> >  --- Mario Chavez <ma...@gmail.com>
> escribió:
> > 
> > > Mariano;
> > > 
> > > You need to install an Oracle client which will
> > > install all the libraries
> > > requiered to connect to a Oracle DB, besides
> them
> > > you need to install the
> > > .NET Oracle Provider (ODP.NET <http://ODP.NET>).
> > > 
> > > You can find both libraries in otn.oracle.com
> > > <http://otn.oracle.com>, just
> > > keep in mind that the Oracle client size is
> about
> > > 300Mb.
> > > 
> > > On 11/7/05, Chad Humphries
> > > <ch...@gmail.com> wrote:
> > > >
> > > > Mariano,
> > > >
> > > > I'm not sure on extras past the initial
> > > distribution dlls.
> > > > Unfortunately I don't have a machine handy at
> > the
> > > moment I can test
> > > > and look this up on.
> > > >
> > > > -Chad
> > > >
> > > > On 11/7/05, Mariano <ml...@yahoo.es> wrote:
> > > > > Thanks
> > > > > how many dlls i need , because ive found
> > > > > Oracle.DataAccess.dll , but now ask me
> > > orapops9.dll
> > > > >
> > > > >
> > > > > thnks
> > > > > --- Chad Humphries
> <ch...@gmail.com>
> > > > > escribió:
> > > > >
> > > > > > Mariano,
> > > > > >
> > > > > > You should be able to get it here:
> > > > > >
> > > > >
> > >
> >
>
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
> > > > > >
> > > > > > Chad Humphries
> > > > > > http://tiredidea.com/
> > > > > >
> > > > > > On 11/4/05, Mariano <ml...@yahoo.es>
> > wrote:
> > > > > > > Hi
> > > > > > >
> > > > > > > Ive tried use Ibatis.NET with Oracle ,
> but
> > > ive a
> > > > > > > problem with dll. Somebody know where
> can
> > i
> > > > > > download
> > > > > > > the dll assemblyName="Oracle.DataAccess,
> > > > > > > Version=9.2.0.401, Culture=neutral,
> > > > > > >
> > > > > >
> > > > >
> > >
> >
>
PublicKeyToken=89b483f429c47342"(Oracle.DataAccess.dll)
> > > > > > >
> > > > > > >
> > > > > > > thnks
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > ______________________________________________
> > > > > > > Renovamos el Correo Yahoo!
> > > > > > > Nuevos servicios, más seguridad
> > > > > > > http://correo.yahoo.es
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> ______________________________________________
> > > > > Renovamos el Correo Yahoo!
> > > > > Nuevos servicios, más seguridad
> > > > > http://correo.yahoo.es
> > > > >
> > > >
> > > 
> > > 
> > > 
> > > --
> > > Mario Chavez
> > > mario.chavez@gmail.com
> > > http://mario-chavez.decisionesinteligentes.com/
> > > 
> > 
> > 
> > 
> > 	
> > 	
> > 		
> > ______________________________________________ 
> > Renovamos el Correo Yahoo! 
> > Nuevos servicios, más seguridad 
> > http://correo.yahoo.es
> > 
> 
> 
> 
> 		
> ______________________________________________ 
> Renovamos el Correo Yahoo! 
> Nuevos servicios, más seguridad 
> http://correo.yahoo.es
> 



		
______________________________________________ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es

Re: DLL ORACLE .NET

Posted by Mariano <ml...@yahoo.es>.
hi all
its possible to use dll of Microsoft to conect with
Oracle, o Ive to use the dlls of Oracle.

thkns
 --- Mariano <ml...@yahoo.es> escribió:

> thks
> ive installed the dll from ODP.NET , now its working
> 
> 
>  --- Mario Chavez <ma...@gmail.com> escribió:
> 
> > Mariano;
> > 
> > You need to install an Oracle client which will
> > install all the libraries
> > requiered to connect to a Oracle DB, besides them
> > you need to install the
> > .NET Oracle Provider (ODP.NET <http://ODP.NET>).
> > 
> > You can find both libraries in otn.oracle.com
> > <http://otn.oracle.com>, just
> > keep in mind that the Oracle client size is about
> > 300Mb.
> > 
> > On 11/7/05, Chad Humphries
> > <ch...@gmail.com> wrote:
> > >
> > > Mariano,
> > >
> > > I'm not sure on extras past the initial
> > distribution dlls.
> > > Unfortunately I don't have a machine handy at
> the
> > moment I can test
> > > and look this up on.
> > >
> > > -Chad
> > >
> > > On 11/7/05, Mariano <ml...@yahoo.es> wrote:
> > > > Thanks
> > > > how many dlls i need , because ive found
> > > > Oracle.DataAccess.dll , but now ask me
> > orapops9.dll
> > > >
> > > >
> > > > thnks
> > > > --- Chad Humphries <ch...@gmail.com>
> > > > escribió:
> > > >
> > > > > Mariano,
> > > > >
> > > > > You should be able to get it here:
> > > > >
> > > >
> >
>
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
> > > > >
> > > > > Chad Humphries
> > > > > http://tiredidea.com/
> > > > >
> > > > > On 11/4/05, Mariano <ml...@yahoo.es>
> wrote:
> > > > > > Hi
> > > > > >
> > > > > > Ive tried use Ibatis.NET with Oracle , but
> > ive a
> > > > > > problem with dll. Somebody know where can
> i
> > > > > download
> > > > > > the dll assemblyName="Oracle.DataAccess,
> > > > > > Version=9.2.0.401, Culture=neutral,
> > > > > >
> > > > >
> > > >
> >
>
PublicKeyToken=89b483f429c47342"(Oracle.DataAccess.dll)
> > > > > >
> > > > > >
> > > > > > thnks
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > ______________________________________________
> > > > > > Renovamos el Correo Yahoo!
> > > > > > Nuevos servicios, más seguridad
> > > > > > http://correo.yahoo.es
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ______________________________________________
> > > > Renovamos el Correo Yahoo!
> > > > Nuevos servicios, más seguridad
> > > > http://correo.yahoo.es
> > > >
> > >
> > 
> > 
> > 
> > --
> > Mario Chavez
> > mario.chavez@gmail.com
> > http://mario-chavez.decisionesinteligentes.com/
> > 
> 
> 
> 
> 	
> 	
> 		
> ______________________________________________ 
> Renovamos el Correo Yahoo! 
> Nuevos servicios, más seguridad 
> http://correo.yahoo.es
> 



		
______________________________________________ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es

Re: DLL ORACLE .NET

Posted by Mariano <ml...@yahoo.es>.
thks
ive installed the dll from ODP.NET , now its working


 --- Mario Chavez <ma...@gmail.com> escribió:

> Mariano;
> 
> You need to install an Oracle client which will
> install all the libraries
> requiered to connect to a Oracle DB, besides them
> you need to install the
> .NET Oracle Provider (ODP.NET <http://ODP.NET>).
> 
> You can find both libraries in otn.oracle.com
> <http://otn.oracle.com>, just
> keep in mind that the Oracle client size is about
> 300Mb.
> 
> On 11/7/05, Chad Humphries
> <ch...@gmail.com> wrote:
> >
> > Mariano,
> >
> > I'm not sure on extras past the initial
> distribution dlls.
> > Unfortunately I don't have a machine handy at the
> moment I can test
> > and look this up on.
> >
> > -Chad
> >
> > On 11/7/05, Mariano <ml...@yahoo.es> wrote:
> > > Thanks
> > > how many dlls i need , because ive found
> > > Oracle.DataAccess.dll , but now ask me
> orapops9.dll
> > >
> > >
> > > thnks
> > > --- Chad Humphries <ch...@gmail.com>
> > > escribió:
> > >
> > > > Mariano,
> > > >
> > > > You should be able to get it here:
> > > >
> > >
>
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
> > > >
> > > > Chad Humphries
> > > > http://tiredidea.com/
> > > >
> > > > On 11/4/05, Mariano <ml...@yahoo.es> wrote:
> > > > > Hi
> > > > >
> > > > > Ive tried use Ibatis.NET with Oracle , but
> ive a
> > > > > problem with dll. Somebody know where can i
> > > > download
> > > > > the dll assemblyName="Oracle.DataAccess,
> > > > > Version=9.2.0.401, Culture=neutral,
> > > > >
> > > >
> > >
>
PublicKeyToken=89b483f429c47342"(Oracle.DataAccess.dll)
> > > > >
> > > > >
> > > > > thnks
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> ______________________________________________
> > > > > Renovamos el Correo Yahoo!
> > > > > Nuevos servicios, más seguridad
> > > > > http://correo.yahoo.es
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > > ______________________________________________
> > > Renovamos el Correo Yahoo!
> > > Nuevos servicios, más seguridad
> > > http://correo.yahoo.es
> > >
> >
> 
> 
> 
> --
> Mario Chavez
> mario.chavez@gmail.com
> http://mario-chavez.decisionesinteligentes.com/
> 



	
	
		
______________________________________________ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es

Re: DLL ORACLE .NET

Posted by Mariano <ml...@yahoo.es>.
hi all

Its neccesary to use  Orcale the DLLs of Oracle or I
can use the dll of Microsoft with. 

thnks
 --- Mario Chavez <ma...@gmail.com> escribió:

> Mariano;
> 
> You need to install an Oracle client which will
> install all the libraries
> requiered to connect to a Oracle DB, besides them
> you need to install the
> .NET Oracle Provider (ODP.NET <http://ODP.NET>).
> 
> You can find both libraries in otn.oracle.com
> <http://otn.oracle.com>, just
> keep in mind that the Oracle client size is about
> 300Mb.
> 
> On 11/7/05, Chad Humphries
> <ch...@gmail.com> wrote:
> >
> > Mariano,
> >
> > I'm not sure on extras past the initial
> distribution dlls.
> > Unfortunately I don't have a machine handy at the
> moment I can test
> > and look this up on.
> >
> > -Chad
> >
> > On 11/7/05, Mariano <ml...@yahoo.es> wrote:
> > > Thanks
> > > how many dlls i need , because ive found
> > > Oracle.DataAccess.dll , but now ask me
> orapops9.dll
> > >
> > >
> > > thnks
> > > --- Chad Humphries <ch...@gmail.com>
> > > escribió:
> > >
> > > > Mariano,
> > > >
> > > > You should be able to get it here:
> > > >
> > >
>
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
> > > >
> > > > Chad Humphries
> > > > http://tiredidea.com/
> > > >
> > > > On 11/4/05, Mariano <ml...@yahoo.es> wrote:
> > > > > Hi
> > > > >
> > > > > Ive tried use Ibatis.NET with Oracle , but
> ive a
> > > > > problem with dll. Somebody know where can i
> > > > download
> > > > > the dll assemblyName="Oracle.DataAccess,
> > > > > Version=9.2.0.401, Culture=neutral,
> > > > >
> > > >
> > >
>
PublicKeyToken=89b483f429c47342"(Oracle.DataAccess.dll)
> > > > >
> > > > >
> > > > > thnks
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> ______________________________________________
> > > > > Renovamos el Correo Yahoo!
> > > > > Nuevos servicios, más seguridad
> > > > > http://correo.yahoo.es
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > > ______________________________________________
> > > Renovamos el Correo Yahoo!
> > > Nuevos servicios, más seguridad
> > > http://correo.yahoo.es
> > >
> >
> 
> 
> 
> --
> Mario Chavez
> mario.chavez@gmail.com
> http://mario-chavez.decisionesinteligentes.com/
> 



		
______________________________________________ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es

Re: DLL ORACLE .NET

Posted by Mario Chavez <ma...@gmail.com>.
Mariano;

You need to install an Oracle client which will install all the libraries
requiered to connect to a Oracle DB, besides them you need to install the
.NET Oracle Provider (ODP.NET <http://ODP.NET>).

You can find both libraries in otn.oracle.com <http://otn.oracle.com>, just
keep in mind that the Oracle client size is about 300Mb.

On 11/7/05, Chad Humphries <ch...@gmail.com> wrote:
>
> Mariano,
>
> I'm not sure on extras past the initial distribution dlls.
> Unfortunately I don't have a machine handy at the moment I can test
> and look this up on.
>
> -Chad
>
> On 11/7/05, Mariano <ml...@yahoo.es> wrote:
> > Thanks
> > how many dlls i need , because ive found
> > Oracle.DataAccess.dll , but now ask me orapops9.dll
> >
> >
> > thnks
> > --- Chad Humphries <ch...@gmail.com>
> > escribió:
> >
> > > Mariano,
> > >
> > > You should be able to get it here:
> > >
> > http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
> > >
> > > Chad Humphries
> > > http://tiredidea.com/
> > >
> > > On 11/4/05, Mariano <ml...@yahoo.es> wrote:
> > > > Hi
> > > >
> > > > Ive tried use Ibatis.NET with Oracle , but ive a
> > > > problem with dll. Somebody know where can i
> > > download
> > > > the dll assemblyName="Oracle.DataAccess,
> > > > Version=9.2.0.401, Culture=neutral,
> > > >
> > >
> > PublicKeyToken=89b483f429c47342"(Oracle.DataAccess.dll)
> > > >
> > > >
> > > > thnks
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > ______________________________________________
> > > > Renovamos el Correo Yahoo!
> > > > Nuevos servicios, más seguridad
> > > > http://correo.yahoo.es
> > > >
> > >
> >
> >
> >
> >
> > ______________________________________________
> > Renovamos el Correo Yahoo!
> > Nuevos servicios, más seguridad
> > http://correo.yahoo.es
> >
>



--
Mario Chavez
mario.chavez@gmail.com
http://mario-chavez.decisionesinteligentes.com/

Re: DLL ORACLE .NET

Posted by Chad Humphries <ch...@gmail.com>.
Mariano,

I'm not sure on extras past the initial distribution dlls. 
Unfortunately I don't have a machine handy at the moment I can test
and look this up on.

-Chad

On 11/7/05, Mariano <ml...@yahoo.es> wrote:
> Thanks
> how many dlls  i need , because ive found
> Oracle.DataAccess.dll , but now ask me orapops9.dll
>
>
> thnks
>  --- Chad Humphries <ch...@gmail.com>
> escribió:
>
> > Mariano,
> >
> > You should be able to get it here:
> >
> http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
> >
> > Chad Humphries
> > http://tiredidea.com/
> >
> > On 11/4/05, Mariano <ml...@yahoo.es> wrote:
> > > Hi
> > >
> > > Ive tried use Ibatis.NET with Oracle , but ive a
> > > problem with dll. Somebody know where can i
> > download
> > > the dll assemblyName="Oracle.DataAccess,
> > > Version=9.2.0.401, Culture=neutral,
> > >
> >
> PublicKeyToken=89b483f429c47342"(Oracle.DataAccess.dll)
> > >
> > >
> > > thnks
> > >
> > >
> > >
> > >
> > >
> > > ______________________________________________
> > > Renovamos el Correo Yahoo!
> > > Nuevos servicios, más seguridad
> > > http://correo.yahoo.es
> > >
> >
>
>
>
>
> ______________________________________________
> Renovamos el Correo Yahoo!
> Nuevos servicios, más seguridad
> http://correo.yahoo.es
>

Re: DLL ORACLE .NET

Posted by Mariano <ml...@yahoo.es>.
Thanks 
how many dlls  i need , because ive found
Oracle.DataAccess.dll , but now ask me orapops9.dll


thnks
 --- Chad Humphries <ch...@gmail.com>
escribió:

> Mariano,
> 
> You should be able to get it here: 
>
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
> 
> Chad Humphries
> http://tiredidea.com/
> 
> On 11/4/05, Mariano <ml...@yahoo.es> wrote:
> > Hi
> >
> > Ive tried use Ibatis.NET with Oracle , but ive a
> > problem with dll. Somebody know where can i
> download
> > the dll assemblyName="Oracle.DataAccess,
> > Version=9.2.0.401, Culture=neutral,
> >
>
PublicKeyToken=89b483f429c47342"(Oracle.DataAccess.dll)
> >
> >
> > thnks
> >
> >
> >
> >
> >
> > ______________________________________________
> > Renovamos el Correo Yahoo!
> > Nuevos servicios, más seguridad
> > http://correo.yahoo.es
> >
> 



		
______________________________________________ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es

Re: DLL ORACLE .NET

Posted by Chad Humphries <ch...@gmail.com>.
Mariano,

You should be able to get it here: 
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html

Chad Humphries
http://tiredidea.com/

On 11/4/05, Mariano <ml...@yahoo.es> wrote:
> Hi
>
> Ive tried use Ibatis.NET with Oracle , but ive a
> problem with dll. Somebody know where can i download
> the dll assemblyName="Oracle.DataAccess,
> Version=9.2.0.401, Culture=neutral,
> PublicKeyToken=89b483f429c47342"(Oracle.DataAccess.dll)
>
>
> thnks
>
>
>
>
>
> ______________________________________________
> Renovamos el Correo Yahoo!
> Nuevos servicios, más seguridad
> http://correo.yahoo.es
>

DLL ORACLE .NET

Posted by Mariano <ml...@yahoo.es>.
Hi

Ive tried use Ibatis.NET with Oracle , but ive a
problem with dll. Somebody know where can i download
the dll assemblyName="Oracle.DataAccess,
Version=9.2.0.401, Culture=neutral,
PublicKeyToken=89b483f429c47342"(Oracle.DataAccess.dll)


thnks


	
	
		
______________________________________________ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es

Re: calling sql statements through string in code

Posted by Ron Grabowski <ro...@yahoo.com>.
Something like this:

 mapper.QueryForObject("executeSql", "SELECT * FROM User");

 <select id="executeSql">
  $value$
 </select>

 mapper.QueryForObject("executeSql", "WHERE Age = 99");

 <select id="executeSql">
  SELET * FROM User $value$
 </select>

--- Luke Poortinga <po...@clarkstate.cc.oh.us> wrote:

> Hi,
> 
>   I have looked in the reference manual but was unable to find an
> answer to my situation. It seems that it might leverage the
> IBatisNet.DataMapper.Configuration.Sql.Static.StaticSql class.
>   I want to send a string sql statement database call from my code. I
> would like to use the configuration properties specified in my
> sqlmapper xml file. Is there anyway I can do this? Or is this
> property exposed so that I can modify it before I execute the
> statement?
> 
> Thanks,
> Luke
>