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:[EMAIL PROTECTED] >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:[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. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>> >> >> > > > >
