[Installation, Configuration & DEPLOYMENT] - Configuration more than one datasource
by allanrj
Hi guys
i need to do 3 datasources on jboss. i need to specify 3 xmls:
datasource1-ds.xml, datasource2-ds.xml, datasource3-ds.xml ?
Another question... in ejb-jar.xml this is correct ?
put <resource-ref > 3 times ?
| <session >
| <description><![CDATA[Bean implementation class for Enterprise Bean: SitesSB]]></description>
| <display-name>SitesSB</display-name>
|
| <ejb-name>SitesSB</ejb-name>
|
| <home>br.com.gcm.ejb.sb.SitesSBHome</home>
| <remote>br.com.gcm.ejb.sb.SitesSB</remote>
| <ejb-class>br.com.gcm.ejb.sb.SitesSBBean</ejb-class>
| <session-type>Stateless</session-type>
| <transaction-type>Container</transaction-type>
|
| <resource-ref >
| <res-ref-name>jdbc/MARLIN</res-ref-name>
| <res-type>javax.sql.DataSource</res-type>
| <res-auth>Container</res-auth>
| <res-sharing-scope>Shareable</res-sharing-scope>
| </resource-ref>
| <resource-ref >
| <res-ref-name>jdbc/APAESP</res-ref-name>
| <res-type>javax.sql.DataSource</res-type>
| <res-auth>Container</res-auth>
| <res-sharing-scope>Shareable</res-sharing-scope>
| </resource-ref>
| <resource-ref >
| <res-ref-name>jdbc/GCM2</res-ref-name>
| <res-type>javax.sql.DataSource</res-type>
| <res-auth>Container</res-auth>
| <res-sharing-scope>Shareable</res-sharing-scope>
| </resource-ref>
|
| </session>
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4131882#4131882
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4131882
18 years, 1 month
[EJB/JBoss] - Re: ejb application
by allanrj
Well , ejb has been deployed and the class client run ok too. No problem for now, thank a lot, but a i dont understand the reason of program runs normally
2008-02-25 11:49:49,156 DEBUG [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] SitesSB cannot be Bound, doesn't have local and local home interfaces
| 2008-02-25 11:49:49,172 DEBUG [org.jboss.proxy.ejb.ProxyFactory] (re-)Binding Home comp/env/ejb/br/com/gcm/ejb/sb/SitesSB
| 2008-02-25 11:49:49,172 INFO [org.jboss.proxy.ejb.ProxyFactory] Bound EJB Home 'SitesSB' to jndi 'comp/env/ejb/br/com/gcm/ejb/sb/SitesSB'
| 2008-02-25 11:49:49,172 DEBUG [org.jboss.system.ServiceController] starting service jboss.j2ee:service=EJB,plugin=pool,jndiName=comp/env/ejb/br/com/gcm/ejb/sb/SitesSB
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4131874#4131874
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4131874
18 years, 1 month
[JCA/JBoss] - Re: autocommit question
by amit4uall
I am still getting the exception even after changing
<local-tx-datasource>
to
<no-tx-datasource>
My oracle-ds.xml looks like:
<?xml version="1.0" encoding="UTF-8"?>
<no-tx-datasource>
<jndi-name>jdbc/syfact</jndi-name>
<connection-url>jdbc:oracle:thin:@172.16.90.112:1521:syfactge</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>abc</user-name>
xyz
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<type-mapping>Oracle9i</type-mapping>
</no-tx-datasource>
and the exception is:
java.sql.SQLException: You cannot commit with autocommit set!
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcComm
it(BaseWrapperManagedConnection.java:545)
at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConne
ction.java:334)
at com.syfact.core.util.DBConduit.endTransaction(DBConduit.java:1500)...
Thanks and Regards,
Amit
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4131873#4131873
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4131873
18 years, 1 month