2 Replies Latest reply on Jul 7, 2006 1:07 PM by lucluc

    Embedded EJB3: NO TX DATASOURCE setup

    lucluc

      Hi, does anyone knows how to set up a non transactional datasource inside embedded ejb3?

      While it is possible to define a org.jboss.resource.adapter.jdbc.local.LocalTxDataSource to bootstrap a TX DS, I still haven't found how to set up a non transactional datasource like the way I'm used to do with xml node <no-tx-datasource> in *-ds.xml inside the container.

      Any help will be appreciated.
      regards
      F

        • 1. Re: Embedded EJB3: NO TX DATASOURCE setup

          Have you resolved this issue? I'm having the same problem.

          • 2. Re: Embedded EJB3: NO TX DATASOURCE setup
            lucluc

            Nope.
            I also tried to do it myself starting from source, but it was too difficult for my skills.

            I want to share my experience:
            my application (same .jar) can run either (1) on thick client (container embedded), or (2) distributed server (Tomcat + container embedded), or (3) company servers (Tomcat + jboss as + ejb3). Ejb3 makes it possible!

            I decided not to use multiple datasources (or databases) within solution 1 & 2. This is not a workaround because every table can hosted by the same database as there are not scalability or performance issues. Doing so I get also a better manageability.
            Where I need multiple database is within the third solution, where there will be lots of records.
            I'm using mysql, so myisam performance gains are visible only within the third solution.

            So, just think on what you really need.

            In every case the original question is still open.

            bye
            F