[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): | | jdbc/MTBDataSource | jdbc:oracle:thin:@xx.xx.xx.xx:1521:memos | xxx | xxx | TRANSACTION_READ_COMMITTED | oracle.jdbc.driver.OracleDriver | | | jdbc/MTB1DataSource | jdbc:oracle:thin:@xx.xx.xx.xx:1521:memos | xxx | xxx | TRANSACTION_SERIALIZABLE | oracle.jdbc.driver.OracleDriver | | | jdbc/MTBSecondSource | jdbc:oracle:thin:@xx.xx.xx.xx:1521:memos | xxx | xxx | TRANSACTION_NONE | oracle.jdbc.driver.OracleDriver | | | 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=bb&op=viewtopic&p=3855707#3855707 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=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?
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: | | | MSSQLDS-WMS | jdbc:microsoft:sqlserver://10.0.0.20:1433;DatabaseName=WMS;SelectMethod=Cursor | com.microsoft.jdbc.sqlserver.SQLServerDriver | | | | MSSQLDS-CUST | jdbc:microsoft:sqlserver://10.0.0.21:1433;DatabaseName=CUST;SelectMethod=Cursor | com.microsoft.jdbc.sqlserver.SQLServerDriver | | | 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=bb&op=viewtopic&p=3855622#3855622 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=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: 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=bb&op=viewtopic&p=3855584#3855584 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=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