• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
  • Paul Clapham
Sheriffs:
  • paul wheaton
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Piet Souris
Bartenders:
  • Mike London

Configuring a JNDI datasource along with schema name

 
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All,
How to configure a JNDI datasource in spring along with schema name. I am using spring and Ibatis. Though i am aware of placing the schema name in properties fiile and referring that in sql maps. I am not interested to do that as it needs 100s of sql maps to be modified with 1000s of queries.

Let me know if there is any other way of doing this.

Am really in need of help on this.

Thanks in advance.


-Shyam.
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You are asking how to lookup a DataSource that is JNDI into your Spring app?

If so, use

<jee:jndi-lookup> tag

Which uses the
JndiObjectFactoryBean

Mark
 
vShyam Sundar
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Mark,
My question is not related to using data sources. Instead my question is how to use the schema name appended to my sql queries
written in Ibatis config files. Is there any way to append the schema name to all queries with spring configuration while defining the data source.

Thanks,
Shyam.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic