[JBoss-user] [Persistence CMP/JBoss] - Re: More than one datasource possible?
Thanks, I will try that. Is it possible, to set different transaction levels for every data source? The (old) Inprise specific DD looks like this (only ds-part): inprise-specific | datasource | jndi-namejdbc/MTBDataSource/jndi-name | urljdbc:oracle:thin:@xx.xx.xx.xx:1521:memos/url | usernamexxx/username | passwordxxx/password | isolation-levelTRANSACTION_READ_COMMITTED/isolation-level | driver-class-nameoracle.jdbc.driver.OracleDriver/driver-class-name | /datasource | datasource | jndi-namejdbc/MTB1DataSource/jndi-name | urljdbc:oracle:thin:@xx.xx.xx.xx:1521:memos/url | usernamexxx/username | passwordxxx/password | isolation-levelTRANSACTION_SERIALIZABLE/isolation-level | driver-class-nameoracle.jdbc.driver.OracleDriver/driver-class-name | /datasource | datasource | jndi-namejdbc/MTBSecondSource/jndi-name | urljdbc:oracle:thin:@xx.xx.xx.xx:1521:memos/url | usernamexxx/username | passwordxxx/password | isolation-levelTRANSACTION_NONE/isolation-level | driver-class-nameoracle.jdbc.driver.OracleDriver/driver-class-name | /datasource | /datasource-definitions | /inprise-specific You see, the different data soures are more a cosmetic way, to deal with the transaction/isolation level. Honestly, I don't know, how to set up the transaction level for a data soure in JBoss. lefou View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3855707#3855707 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3855707 --- 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: More than one datasource possible?
You can define datasources for the individual entity beans in the jbosscmp-jdbc.xml file or for each deployment unit using the default clause in the same file. I have no personal experience with this but it is listed in one of my books, JBoss 3.0 Deployment and Administrator handbook published by wrox. Thus you at least have a starting point to find information on the subject. Hope this is of help. regards, Anders View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3855584#3855584 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3855584 --- 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: 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