Try adding the following to your db2-ds.xml <new-connection-sql>set schema whatever</new-connection-sql>
Regards, Adrian On Mon, 2003-12-08 at 07:56, forge wrote: > Hello, everyone > > > > I developed a J2EE project by jbuilder9 + jboss 3.2.2, > > The deployment has succeeded but when I tested, > > it reported "SQL: DB2ADMIN.user undefined name" error. > > > > The user table has been created but its schema name is "employee", > > I am using DB2 as my database and account is db2admin. > > I think jboss use my login account as schema name. > > > > I want to specify a different schema than the one that is defaulted > > to by my login. I don't see any where that I am able to specify > > a different schema. Any suggestions will help. > > > > Thanks in advance > > Forge > > > > > > --http://www.eyou.com > --ÈÉÄ Ê ÆÇ æ...Î > > --http://vip.eyou.com > --ÂVIP ×à > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IBM Linux Tutorials. > Become an expert in LINUX or just sharpen your skills. Sign up for IBM's > Free Linux Tutorials. Learn everything from the bash shell to sys admin. > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user -- xxxxxxxxxxxxxxxxxxxxxxxx Adrian Brock Director of Support Back Office JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
