ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From davypulin...@telenet.be
Subject Re: Please help me.
Date Fri, 01 Jun 2007 06:08:31 GMT
Thank you,

That problem is solved.
Butt how do you think I must solve the problem with weblogic is it possible to get the configuration
out of weblogic and in to sqlmapconfig. In my connectionpool of weblogic I have configured
the driverclass name, url, password, etc….


Greetz
Davy


>----- Oorspronkelijk bericht -----
>Van: Nathan Maves [mailto:nathan.maves@gmail.com]
>Verzonden: donderdag, mei 31, 2007 11:36 PM
>Aan: user-java@ibatis.apache.org
>Onderwerp: Re: Please help me.
>
>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