[JBoss-user] [Persistence CMP/JBoss] - Re: More than one datasource possible?
We are using JBoss 3.2.x, and are currently connecting to two different databases in our EJB project. I believe that at JBoss 3.2.x only requires that the file containing your data sources be names as *-ds.xml. This file needs to be accessible from whereever your JBoss server scans for deployments. For example, we use the following mssql-ds.xml (for MS SQL Server), but again the name doesn't matter as long as it ends in -ds.xml: | datasources | local-tx-datasource | jndi-nameMSSQLDS-WMS/jndi-name | connection-urljdbc:microsoft:sqlserver://10.0.0.20:1433;DatabaseName=WMS;SelectMethod=Cursor/connection-url | driver-classcom.microsoft.jdbc.sqlserver.SQLServerDriver/driver-class | /local-tx-datasource | | local-tx-datasource | jndi-nameMSSQLDS-CUST/jndi-name | connection-urljdbc:microsoft:sqlserver://10.0.0.21:1433;DatabaseName=CUST;SelectMethod=Cursor/connection-url | driver-classcom.microsoft.jdbc.sqlserver.SQLServerDriver/driver-class | /local-tx-datasource | /datasources | Note that our datasource declarations do not have username and password, but you can add those as well (we store username / password elsewhere). Hope this helps. Todd View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3855622#3855622 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3855622 --- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: Transaction isolation on 3.2.x with CMT (not CMP) using
Does anyone have any advice for me on my previous post? I guess I could have been imagining things, but I know there have been other posts about this problem. The posts I remember are older (stating that tx isolation levels could only be set at the data source level I believe). Right now we are just using the database's default level (READ COMMITTED) but will need repeatable reads for a few EJB methods. Thanks again. Todd View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3855683#3855683 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3855683 --- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Transaction isolation on 3.2.x with CMT (not CMP) using stra
I need to be abe to declare per-method transaction isolation levels in JBoss 3.2.x using container managed transactions but with bean managed persistence (we are using CMT but with a typical DAO pattern using JDBC under the covers). I think I remember reading somewhere that starting with one of the 3.2.x releases the ability to declare transaction isolation levels per EJB method was made available, but I can't find any reference to it now. Is this true or was I just dreaming? I have searched through the paid-for documentation, these forums, and the internet in general and can't seem to find an answer - so any help would be greatly appreciated. Thanks. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3855441#3855441 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3855441 --- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user