ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Maves" <nathan.ma...@gmail.com>
Subject Re: Please help me.
Date Thu, 31 May 2007 21:36:36 GMT
Pretty simple actually,

you can pass a string (non binding) variable into a sqlmap

example

<sqlmap ......>
   select * from $schema$.person where id = #id#
</sqlmap>

Note the use of $$ and ##.  The $$ uses a string substitution and not a jdbc
parameter.


On 5/31/07, Davy Pulinckx <davypulinckx@telenet.be> wrote:
>
>  Hellow
>
>
>
> I have a question on how I would change my application in the best
> possible way.
>
> I will first explain the situation.
>
> There is a web-application build with JBuiler, I use weblogic to deploy te
> application and I uses .xml properties files each different for each
> environment (integration, acceptation and production) and the database is
> db2
>
> At this time I uses JDBC and the sql query is written in the source file
> for example :
>
>
>
> private final String select1 = "SELECT * FROM "+ javaFile.schemaName +
> etc…..
>
>
>
> Now the problem is, the application uses properties files, in the
> properties file I store for example the db2 schema, url's, etc…
>
> My question is, how would I made this to ibatis
>
> -          How cane I get the name of the db2 schema stored in the xml
> propertie-file into Ibatis xml file sow I cane execute my sql file written
> in ibatis => SELECT * FROM "+ *javaFile.schemaName* + etc…..
>
> -          An other problem for me is, the application uses weblogic, in
> the console are datasources and connectionpools created. I read many
> examples and always I see username and password written in the .xml config
> file of ibatis. Butt is there a way to use the weblogic configuration
> (datasource, connectionpool).
>
>
>
> I now I ask mutch, butt I just changed to another employee the application
> is written during a few years thru another person, and now I must learn
> everything in a few months and I must migrate the application to ibatis in a
> few weeks, and I don't now what I must do to make this work, every help is
> good, examples, tutorials, etc….
>
> Would you please help me, please.
>
>
>
> Sorry for my English, I'm Dutch (Europe)
>
>
>
>
>
> Or is there another way to configurate this.
>
>
>
>
>
>
>

Mime
View raw message