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 07:21:50 GMT
Thanks,

I will try it later this day.
I have difficulties to implement the first solution (passing paramerts  $schema1$ to the sql
statement) 


>----- Oorspronkelijk bericht -----
>Van: Zoran Avtarovski [mailto:zoran@sparecreative.com]
>Verzonden: vrijdag, juni 1, 2007 08:31 AM
>Aan: 'iBatis Java Mail List'
>Onderwerp: Re: Please help me.
>
>I'm not sure I'm clear on this. Have you set up your connection pool in
>Weblogic via JNDI if so it's a simple matter matter of using the JNDI name
>in your transaction manager
>
><transactionManager type="JDBC">
>
>    <dataSource type="JNDI">
>        <property name="DataSource" value="${JNDI_NAME}"/>
>    </dataSource>
> 
></transactionManager>
>
>
>Z.
>
>
>> 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