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:[EMAIL PROTECTED]
>> Verzonden: donderdag, mei 31, 2007 11:36 PM
>> Aan: [email protected]
>> 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 <[EMAIL PROTECTED]> 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.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
>
