0 Replies Latest reply on Sep 17, 2002 7:23 PM by Ryan Delano

    RE- Session bean using mySQL [sorry, can't post to orignal t

    Ryan Delano Newbie

      http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ I am missing something (aside from not knowing what JBoss/Tomcat versions you are running) I'd say you only need to do this:

      Change this:
      dataSource = (DataSource)ic.lookup("jdbc/Agency");

      To This:
      dataSource = (DataSource)ic.lookup("java:/agencyDS");

      I should note that in all my comparable examples and projects I DID NOT have any support in my ejb-jar.xml file. I also was not *required* to create jboss.xml so I didn't! (meaning it worked without one, so I didn't bother)

      I simply defined the datasource in mysql-service.xml and then used the exact name that is output when deploying that xml file. (Of course not as my first try, but it made sense and worked immediately when I did.) It seems you are all set on the -service.xml file, if not let me know and I can gather more info.

      As always, please post a follow up and let others know what works or what does not.

      thanks & good luck,