• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Configuring Datasource to use a default schema

 
Cindy Jones
Ranch Hand
Posts: 66
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How can I configure the datasource in db2-ds.xml to also include the database schema name? Right now, I have to add the schma name as part of the query and I dont want to do that.
If this is not possible, what alternative do I have? I am using JDBC and not Hibernate.

Thanks!
 
Subhash Bhushan C
Ranch Hand
Posts: 106
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is an excerpt from db2-ds.xml.



Correct me if I am wrong, but dont you specify the schema name and password as part of user-name and password parameters shown above?
[ April 22, 2008: Message edited by: Subhash Bhushan ]
 
Cindy Jones
Ranch Hand
Posts: 66
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My user name is not the same as my schema name. So I cant replace the user name with the schema name.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic