3 Replies Latest reply on Oct 24, 2005 10:15 AM by ccaprar

How can we tell JBoss, which database schema it should use?

amirsadri Jul 19, 2004 3:56 AM

We have a problem when connecting with JBoss to a IBM DB2 database.

We use JBoss 3.2.1 on Windows 2000 with a IBM DB2 8.1 database.
Our application is based on the EJB 1.1 spec.
When we want to connect to the database we have to provide not only
the user and the password but also the schema of the database.
(The database model and the naming and authorization conventions are not controlled by us.)

How can we tell JBoss, which database schema it should use?
It there a special keyword to provide the schema in the datasource configuration in the 'db2-ds.xml' file?

Thanks

1. Re: How can we tell JBoss, which database schema it should u

adrian.brock Jul 19, 2004 5:00 PM (in response to amirsadri)
http://www.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources
<new-connection-sql>set schema blah</new-connection-sql>
Actions
2. Re: How can we tell JBoss, which database schema it should u

amirsadri Jul 20, 2004 5:45 AM (in response to amirsadri)

Thanks Adrian
Everything works fine.
Actions
3. Re: How can we tell JBoss, which database schema it should u

ccaprar Oct 24, 2005 10:15 AM (in response to amirsadri)

Can someone add this set schema stuff to the DB2 datasource template (or in Wiki)? I could not find it there, only here on the forum :)
Actions

Go to original post