[JBoss-user] [EJB/JBoss] - Re: Stateful Session bean and java.sql.Connection problem
Hi darranl, so... where's my reply with my problem? Esther View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3861639#3861639 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3861639 --- The SF.Net email is sponsored by: Beat the post-holiday blues Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. It's fun and FREE -- well, almosthttp://www.thinkgeek.com/sfshirt ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: Stateful Session bean and java.sql.Connection problem
The reply at the beginning of this page is not the one I post one Friday. I would like to know where it is And who wrote in my name with no permission! View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3861371#3861371 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3861371 --- The SF.Net email is sponsored by: Beat the post-holiday blues Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. It's fun and FREE -- well, almosthttp://www.thinkgeek.com/sfshirt ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: Stateful Session bean and java.sql.Connection problem
I had the same error, but I don't want to close the connection in my ejb
method, because if I do that, I can't work with my database. Is there any way
to keep the connection open and close it manually outside the ejb method?
Here's is my code:
index.jsp
| (...)
| Connection conn=null;
| String nombre_proceso=;
| try{
| InitialContext ctx = getInitialContext();
| paquetegestionDB.gestionDBHome home =
paquetegestionDB.gestionDBHome)ctx.lookup(gestionDB);
| paquetegestionDB.gestionDB the_ejb = home.create();
| conn=the_ejb.conectar();
| (...)
| ctx.close();
| the_ejb.remove();
| }
| catch(RemoteException e){
| (...)
| }
|
| finally
| {
| try
| {
| if (conn!=null)
| if (!conn.isClosed())
| conn.close();
| }catch(Exception ignore){ System.out.println(error...); }
| }
|
This is my ejb method conectar:
| public static Connection conectar()
| throws SQLException, RemoteException
| {
| System.out.println(Intentamos hacer la conexin);
| Context ctx = null;
| Hashtable ht = new Hashtable();
| Connection conn = null;
|
ht.put(Context.INITIAL_CONTEXT_FACTORY,org.jnp.interfaces.NamingContextFactory);
| ht.put(Context.PROVIDER_URL,localhost);
| //ht.put(Context.URL_PKG_PREFIXES,
org.jboss.naming:org.jnp.interfaces);
| try
| {
| ctx = new InitialContext(ht);
| //ctx = new InitialContext();
| DataSource ds = (DataSource)ctx.lookup(java:/OracleDS);
| conn = ds.getConnection();
| System.out.println(Se ha realizado la conexi\363n con
\351xito);
| return conn;
| }
| catch(Exception e)
| {
| System.out.println(Error: + e);
| e.printStackTrace();
| return null;
| }
| }
|
This is my oracle-ds.xml
| datasources
| local-tx-datasource
| jndi-nameOracleDS/jndi-name
| connection-urljdbc:oracle:thin:@ip:1521:schema/connection-url
| driver-classoracle.jdbc.driver.OracleDriver/driver-class
| user-name.../user-name
| password.../password
| metadata
| type-mappingOracle9i/type-mapping
| /metadata
| /local-tx-datasource
| /datasources
|
And my ejb-jar.xml
| ejb-jar
|enterprise-beans
| session
| display-namegestionDBEJB/display-name
| ejb-namegestionDB/ejb-name
| homepaquetegestionDB.gestionDBHome/home
| remotepaquetegestionDB.gestionDB/remote
| ejb-classpaquetegestionDB.gestionDBEJB/ejb-class
| session-typeStateless/session-type
| transaction-typeContainer/transaction-type
|
| resource-ref
| res-ref-nameOracleDS/res-ref-name
| res-typejavax.sql.DataSource/res-type
| res-authApplication/res-auth
| /resource-ref
|
| /session
|/enterprise-beans
|
|assembly-descriptor
| container-transaction
| method
| ejb-namegestionDB/ejb-name
| method-name*/method-name
| /method
| trans-attributeRequired/trans-attribute
| /container-transaction
|
| security-role
| descriptionUsers/description
| role-nameusers/role-name
| /security-role
|/assembly-descriptor
| /ejb-jar
|
And finally, my jboss.xml:
| jboss
| enterprise-beans
| session
| ejb-namegestionDB/ejb-name
| jndi-namegestionDB/jndi-name
| resource-ref
| res-ref-nameOracleDS/res-ref-name
| jndi-namejava:/OracleDS/jndi-name
| /resource-ref
| /session
| /enterprise-beans
| /jboss
|
And that's the error I get:
14:51:04,327 INFO [CachedConnectionManager] Closing a connection for you. Plea
se close them yourself: [EMAIL PROTECTED]
0
java.lang.Exception: STACKTRACE
at org.jboss.resource.connectionmanager.CachedConnectionManager.register
Connection(CachedConnectionManager.java:319)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
onnection(BaseConnectionManager2.java:477)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
nManagerProxy.allocateConnection(BaseConnectionManager2.java:838)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
erDataSource.java:102)
at paquetegestionDB.gestionDBEJB.conectar(gestionDBEJB.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
(..)
[JBoss-user] [EJB/JBoss] - Closing a connection for you. Please close them yourself
Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! I'm trying to make the connection pool with my database using an EJB and I get the following error: 14:51:04,327 INFO [CachedConnectionManager] Closing a connection for you. Plea se close them yourself: [EMAIL PROTECTED] 0 I've tried to close the connection in the same function where it's open and it works, but I don't want this solution because if I do that, I can't work with my database. I imagine the EJB can't keep the connection open. Is there any attribute to configure in ejb-jar.xml or jboss.xml that ables to close the connection manually at any place? Thanks in advance. Esther View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3860738#3860738 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3860738 --- The SF.Net email is sponsored by: Beat the post-holiday blues Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. It's fun and FREE -- well, almosthttp://www.thinkgeek.com/sfshirt ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - Connection Pool with EJB
Hello!
I'm trying to connect my database with an EJB and it doesn't work. That's what
I do:
1. I configure my jboss.xml in META-INF folder:
enterprise-beans
ejb-namegestionDB/ejb-name
jndi-nameejb/gestionDB/jndi-name
resource-ref
res-ref-namejdbc/OracleDS/res-ref-name
jndi-namejava:/OracleDS/jndi-name
/resource-ref
/enterprise-beans
2. I configure my ejb-jar.xml in META-INF folder
ejb-jar
enterprise-beans
display-namegestionDBEJB/display-name
ejb-namegestionDB/ejb-name
paquetegestionDB.gestionDBHome
paquetegestionDB.gestionDB
ejb-classpaquetegestionDB.gestionDBEJB/ejb-class
session-typeStateless/session-type
transaction-typeContainer/transaction-type
resource-ref
res-ref-namejdbc/OracleDS/res-ref-name
res-typejavax.sql.DataSource/res-type
res-authContainer/res-auth
/resource-ref
/enterprise-beans
assembly-descriptor
container-transaction
ejb-namegestionDB/ejb-name
method-name*/method-name
trans-attributeSupports/trans-attribute
/container-transaction
security-role
Users
role-nameusers/role-name
/security-role
/assembly-descriptor
/ejb-jar
3. I zip them and the classes in gestionDB.jar and store it in the deploy
folder.
4. That's my Oracle-ds.xml. I know it works cause I use it in an independent
servlet.
local-tx-datasource
jndi-nameOracleDS/jndi-name
connection-urljdbc:oracle:thin:@...:...PorDB2/connection-url
!--
Here are a couple of the possible OCI configurations.
For more information, see
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm
connection-urljdbc:oracle:oci:@youroracle-tns-name/connection-url
or
connection-urljdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))/connection-url
Clearly, its better to have TNS set up properly.
--
driver-classoracle.jdbc.driver.OracleDriver/driver-class
user-name.../user-name
...
!-- Uses the pingDatabase method to check a connection is still valid
before handing it out from the pool --
!--valid-connection-checker-class-nameorg.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker/valid-connection-checker-class-name--
!-- Checks the Oracle error codes and messages for fatal errors --
exception-sorter-class-nameorg.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter/exception-sorter-class-name
!-- sql to call when connection is created
new-connection-sqlsome arbitrary sql/new-connection-sql
--
!-- sql to call on an existing pooled connection when it is obtained
from pool - the OracleValidConnectionChecker is prefered
check-valid-connection-sqlsome arbitrary
sql/check-valid-connection-sql
--
!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
(optional) --
type-mappingOracle9i/type-mapping
/local-tx-datasource
5. gestionDBEJB.java makes the connection with Oracle using this function:
public static Connection conectar()
throws SQLException, RemoteException
{
Context ctx = null;
//Hashtable ht = new Hashtable();
Connection conn = null;
//ht.put(Context.INITIAL_CONTEXT_FACTORY,org.jnp.interfaces.NamingContextFactory);
//ht.put(Context.PROVIDER_URL,localhost);
//ht.put(Context.URL_PKG_PREFIXES,
org.jboss.naming:org.jnp.interfaces);
try
{
//ctx = new InitialContext(ht);
ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup(java:/OracleDS);
conn = ds.getConnection();
System.out.println(Se ha realizado la conexi\363n con \351xito);
return conn;
}
catch(Exception e)
{
System.out.println(Error: + e);
e.printStackTrace();
return null;
}
}
I do not know why but this does not work. Can anyone help me please?
Thanks in advance
Esther
View the original post :
http://www.jboss.org/index.html?module=bbop=viewtopicp=3860394#3860394
Reply to the post :
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3860394
---
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well,
[JBoss-user] [Beginners Corner] - Re: javax.ejb package
Hello darranl, thanks a lot for your information! Merry Christmas!!! ESther View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3859806#3859806 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3859806 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - javax.ejb package
Does any of you know where i can download javax.ejb package? If so, would you mind telling me? Thanks. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3859763#3859763 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3859763 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - Re: Create an application with Jboss
Hello! I made the changes you suggested in my servlet, that is, out = response.getWriter(); Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup(java:/comp/env); DataSource ds = (DataSource)envContext.lookup(java:/comp/env/jdbc/XAOracleDS); Connection conn = ds.getConnection(); String sql = SELECT nombre FROM candidatos WHERE id_cand=49851; and that's the error I get in Apache error: comp not bound and the ones i get in Jboss 16:44:07,480 INFO [STDOUT] javax.naming.NameNotFoundException: comp not bound 16:44:07,482 INFO [STDOUT] at org.jnp.server.NamingServer.getBinding(NamingServer.java:495) 16:44:07,697 INFO [STDOUT] at org.jnp.server.NamingServer.getBinding(NamingServer.java:503) 16:44:07,697 INFO [STDOUT] at org.jnp.server.NamingServer.getObject(NamingServer.java:509) 16:44:07,698 INFO [STDOUT] at org.jnp.server.NamingServer.lookup(NamingServer.java:253) 16:44:07,698 INFO [STDOUT] at org.jnp.server.NamingServer.lookup(NamingServer.java:256) 16:44:07,806 INFO [STDOUT] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:529) 16:44:07,807 INFO [STDOUT] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:508) 16:44:07,807 INFO [STDOUT] at servlet.DataBaseServlet.doGet(DataBaseServlet.java:41) 16:44:07,808 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) 16:44:07,922 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) 16:44:07,923 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) I've tried all the possible combinations, with no success. Is there any other way to solve my problem? What's exactly what I've to do to configure this connection pool? Thanks again, Esther View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3859616#3859616 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3859616 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - Re: Create an application with Jboss
I entered here to tell you I solved my problem when I see your answer. Finally, I changed my oracle-xa-ds.xml for the oracle-ds.xml defined in docs/examples/jca, changing the url, user and passwords. In my servlet, i made the connection in that way.. DataSource ds = (DataSource)initContext.lookup(java:/OracleDS); Connection conn = ds.getConnection(); as I found in I-don't-know-which forum. Then, an error appeared, telling me it wasn't able to find oracle.dms.consolo.DMSconsole class. So a friend of my sent me the file and it worked!!! Thanks for everything. I couldn't see where the mistake was without your help. I didn't realize I wasn't calling the ddbb with the appropiate name. You're the only one who has spent time with me... Thanks a lot!!! Huge kisses, Esther View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3859639#3859639 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3859639 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - Re: Create an application with Jboss
Hi redbeard!
Of course, classes12.jar contains the class I need
(oracle.jdbc.xa.OracleXADataSOurce).
That's my servlet:
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
public class DataBaseServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse
response)
throws ServletException, IOException {
PrintWriter out = null;
try {
out = response.getWriter();
Context initContext = new InitialContext();
Context envContext =
(Context)initContext.lookup(java:/comp/env);
DataSource ds =
(DataSource)envContext.lookup(jdbc/myoracle);
Connection conn = ds.getConnection();
String sql = SELECT nombre FROM candidatos WHERE
id_cand=49851;
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
out.println(MAXIM ID : + rs.getString(1));
}
} catch (Exception e) {
out = response.getWriter();
out.println(error: + e.getMessage());
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse
response)
throws ServletException, IOException {
doGet(request, response);
}
}
What error do you want me to post? The one which Apache shows or the one when i
call my servlet?
The first one is:
error: jdbc not bound
The second one:
15:41:53,444 INFO [STDOUT] javax.naming.NameNotFoundException: jdbc not bound
15:41:53,448 INFO [STDOUT] at
org.jnp.server.NamingServer.getBinding(NamingServer.java:495)
15:41:53,590 INFO [STDOUT] at
org.jnp.server.NamingServer.getBinding(NamingServer.java:503)
15:41:53,591 INFO [STDOUT] at
org.jnp.server.NamingServer.getObject(NamingServer.java:509)
15:41:53,591 INFO [STDOUT] at
org.jnp.server.NamingServer.lookup(NamingServer.java:253)
15:41:53,591 INFO [STDOUT] at
org.jnp.server.NamingServer.lookup(NamingServer.java:256)
15:41:53,652 INFO [STDOUT] at
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:529)
15:41:53,653 INFO [STDOUT] at
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:508)
15:41:53,653 INFO [STDOUT] at
servlet.DataBaseServlet.doGet(DataBaseServlet.java:41)
15:41:53,653 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
15:41:53,655 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
15:41:53,656 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
15:41:53,656 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
15:41:53,656 INFO [STDOUT] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
15:41:53,656 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
15:41:53,657 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
15:41:53,657 INFO [STDOUT] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
15:41:53,657 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:41:53,658 INFO [STDOUT] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
15:41:53,658 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
15:41:53,658 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
15:41:53,658 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:41:53,659 INFO [STDOUT] at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
15:41:53,659 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
15:41:53,659 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
15:41:53,659
[JBoss-user] [Beginners Corner] - Re: Create an application with Jboss
Thanks again for spending your spare time in helping me. Ifinally, I left the possibility of reusing the application I had with Tomcat. I've read the Startup Guide in jboss.org as you recomended and I tried to follow the steps: 1. I uncommented the Pad attribute in jboss-service.xml, 2. Add the classes12.jar at default/lib folder. 3. I created oracle-xa-ds.xml configuring the url, user and password. The process says the connection is created but when I try to execute the servlet which makes the connection appears the following error: 19:01:23,269 INFO [STDOUT] javax.naming.NameNotFoundException: jdbc not bound 19:01:23,271 INFO [STDOUT] at org.jnp.server.NamingServer.getBinding(NamingServer.java:495) 19:01:23,271 INFO [STDOUT] at org.jnp.server.NamingServer.getBinding(NamingServer.java:503) 19:01:23,271 INFO [STDOUT] at org.jnp.server.NamingServer.getObject(NamingServer.java:509) 19:01:23,272 INFO [STDOUT] at org.jnp.server.NamingServer.lookup(NamingServer.java:253) 19:01:23,272 INFO [STDOUT] at org.jnp.server.NamingServer.lookup(NamingServer.java:256) 19:01:23,272 INFO [STDOUT] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:529) 19:01:23,272 INFO [STDOUT] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:508) 19:01:23,273 INFO [STDOUT] at servlet.DataBaseServlet.doGet(DataBaseServlet.java:41) 19:01:23,273 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) 19:01:23,273 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) 19:01:23,273 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) That's my default/deploy/oracle-xa-ds.xml: - xa-datasource jndi-nameXAOracleDS/jndi-name track-connection-by-txtrue/track-connection-by-tx isSameRM-override-valuefalse/isSameRM-override-value xa-datasource-classoracle.jdbc.xa.client.OracleXADataSource/xa-datasource-class xa-datasource-property name=URLjdbc:oracle:thin:@192.168.30.99:1521:PorDB2/xa-datasource-property xa-datasource-property name=Userservijob/xa-datasource-property xa-datasource-property name=PasswordServi_Ds/xa-datasource-property - exception-sorter-class-name org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter /exception-sorter-class-name no-tx-separate-pools/ /xa-datasource - !-- mbean code=org.jboss.resource.adapter.jdbc.xa.oracle.OracleXAExceptionFormatter name=jboss.jca:service=OracleXAExceptionFormatter -- - !-- depends optional-attribute-name=TransactionManagerServicejboss:service=TransactionManager/depends -- !--/mbean-- What's more do I have to configure? Thanks, Esther View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3859324#3859324 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3859324 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - No Classloaders found for...
Hello! I hope you can help me, unless there're some people in this forum who think I'm lazy and don't work to solve my own problems. I'm trying to configure the connection pool with Oracle. 1.I uncomment the Pad attribute in jboss-servce.xml. 2.I put the jdbc drivers, that is, classes12.jar, in my default/lib folder. 3.Then, I create the /default/deploy/oracle-xa-ds.xml, which include xa-datasource jndi-name/jdbc/myoracle/jndi-name track-connection-by-txtrue/track-connection-by-tx isSameRM-override-valuefalse/isSameRM-override-value xa-datasource-classoracle.jdbc.xa.client.OracleXADataSource/xa-datasource-class xa-datasource-property name=URLjdbc:oracle:thin:@.../xa-datasource-property xa-datasource-property name=User.../xa-datasource-property xa-datasource-property name=Password.../xa-datasource-property exception-sorter-class-nameorg.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter/exception-sorter-class-name no-tx-separate-pools/ /xa-datasource depends optional-attribute-name=TransactionManagerServicejboss:service=TransactionManager But I keep having the following error... 17:05:48,748 ERROR [MainDeployer] could not create deployment: file:/opt/jboss-4.0.0/server/default/deploy/oracle-xa-ds.xml org.jboss.deployment.DeploymentException: No ClassLoaders found for: org.jboss.resource.adapter.jdbc.xa.oracle.OracleXAExceptionFormatter; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: org.jboss.resource.adapter.jdbc.xa.oracle.OracleXAExceptionFormatter) I can imagine it's not able to find a jar... but I don't know wthat's more I have to configure. I've followed the Startud guide and thst's all it says... Would you mind helping me? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3859053#3859053 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3859053 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: jboss 3.0.6: connection pool which oracle oci
Hello! I read you were able to configure Jboss with oracle thin driver. Would you mind explaining me what you did or where i can find this information? Thanks! Esther View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=385#385 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=385 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - Create a connection pool with Oracle
Sorry if I'm annoying somebody. Finally, I got my HelloWorld servlet running, but I still don't know how to make the connection pool with Oracle cause I do not which file I have to modify in my application and how to do it. Can anyone help me or tell me where i can find this information? I'm on the point of getting crazy! Save me! Esther View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3858892#3858892 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3858892 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - javax.naming.NameNotFoundException: jdbc not bound
I keep having this error. I've created oracle-ds.xml file, located it in deploy folder, copying in from examples, and just changing the url, user and password. I haven't done anything more. Is there any file I had to modify and I did'nt do? Thanks for your time! Kisses. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3858908#3858908 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3858908 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - Re: Create an application with Jboss
Hi! First of all, thanks for spending your time answering me. I've read the guide but it desn't help me as muach as I'd wish. Before reading your answer, I've got my html and jsp working, but I don't know how to make my servlet and connection pool run. My DataBase is Oracle and Duke's Bank is working with HSQL. I had my application running just with Tomcat. Why doesn't it work now? :_( I think I'll never get it... Maybe the problem is being a mathematician... That's not my job! Please, help me! Esther View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3858886#3858886 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3858886 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re:
I don't think there's any need to be rude with me. It's the first time I worked with Jboss. It's the first time I send a post in this forum, so I do not have to know the kind of information you need to answer my question. Any case: you don't have any obligation to answer it. I think you've spent more time being rude than the time you would have spent if you had answered me. Besides that, I don't agree with you in your disscuss. I'm not lazy. I've spent four hours today, and four hours more yesterday, searching for information. And I'm so sorry if I'm not as clever as you to find it. I'm mathematician, that's not my job, but I'm trying to do my best. I've read in forums that you have to modify web.xml, others say you don't have to touch it. I've installed my jbdc drivers and modified the oracle-ds.xml as suggested in the Startup Guide but it doesn't seem to be enough. I just wanted some help but if you're too proud to help me, let others who really want to do it. And if not, tell me what you need to know to solve my problem. Thanks a lot for your useless time. PD: And I'm a woman, if you don't mind. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3858942#3858942 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3858942 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - Create an application with Jboss
Well, I don't know how to start (Bad beginning) I was used to work with Tomcat 4.1.31 as a application server, but I've found it's not able to work with ejb and someone told me the need to use Jboss. I've downloaded from the web Jboss 4.0.0 and I want to create a application like I had with Tomcat. If I modify the file server.xml located in JBOSS_HOME/server/default/deploy/jbossweb-tomcat50.sar with the context I used to have in Tomcat, it doesn't work. I've been looking for information about this topic, but I did't find anything. Is there anybody who can help me please? Thanks for all your time. Esther View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3858694#3858694 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3858694 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
