jboss AS + hibernate + mysql

[nitm]

hi,

i want to use hibernate with the jboss AS while using mysql.
i'm using:
- jboss AS 4.2.2
- hibernate 3.2
- mysql server 5.0

i first want to check that the jboss AS can work with mysql in a proper way so i'm trying to make mysql the default datasource.
i went through this article a step at a time:
http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpMysqlAsDefaultDS
and when i try to connect to the datasource i get: DefaultDS not bound
here's how i'm trying to connect:

InitialContext initialContext = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)initialContext.lookup("java:/DefaultDS");
conn = ds.getConnection();

what can be the problem? i did everything in that article, except for the part about changing the standardjaws.xml since i can't find it anywhere in the jboss AS directory...

any ideas?
thanks, nitzan.

[nitm]

forgot to add that when i change the datasource to java:/MySql instead of java:/DefaultDS it works great...

thanks, nitzan

[jaikiran]

There are 2 ways of changing the default database in JBoss. In the approach that you followed, you have changed the jndi-name of the default datasource. However, if you want to lookup the datasource using java:DefaultDS then you will have to follow the Approach#1 mentioned at http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQDB