DO NOT ANSWER JBOSS-USER ON THIS LIST
marc
|-Original Message-
|From: [EMAIL PROTECTED]
|[mailto:[EMAIL PROTECTED]]On Behalf Of Filip
|Hanik
|Sent: Wednesday, April 25, 2001 6:15 PM
|To: [EMAIL PROTECTED]
|Subject: RE: [JBoss-dev] Connection Pool - Help!
|
|
|it is the deployment descriptor
|http://www.jboss.org/documentation/HTML/ch01s10.html
|
|Filip
|
|~
|Namaste - I bow to the divine in you
|~
|Filip Hanik
|Software Architect
|[EMAIL PROTECTED]
|www.filip.net
|
| -Original Message-
| From: [EMAIL PROTECTED]
| [mailto:[EMAIL PROTECTED]]On Behalf Of Roman
| Brouk
| Sent: Wednesday, April 25, 2001 2:13 PM
| To: [EMAIL PROTECTED]
| Subject: RE: [JBoss-dev] Connection Pool - Help!
|
|
| thanks for the responce Filip...
|
| but i am not using jboss.xml. Should i be?
| If i should be where should it reside on my file system and what besides:
|
| resource-managers
| resource-manager res-class=
| res-nameMySQLDB/res-name
| res-jndi-nameMySQLDB/res-jndi-name
| /resource-manager
| /resource-managers
|
| should be in this file?
|
| -Original Message-
| From: [EMAIL PROTECTED]
| [mailto:[EMAIL PROTECTED]]On Behalf Of Filip
| Hanik
| Sent: Wednesday, April 25, 2001 1:52 PM
| To: [EMAIL PROTECTED]
| Subject: RE: [JBoss-dev] Connection Pool - Help!
|
|
| go through the archives, there was a change made - this is a copy
| of one of
| the emails
|
| A change will be required if you have a res-jndi-name element in your
| jboss.xml
| descriptor that is relying on the implied java:/ prefix being added. For
| example if
| your using:
| resource-managers
| resource-manager res-class=
| res-nameDefaultDS/res-name
| res-jndi-nameDefaultDS/res-jndi-name
| /resource-manager
| /resource-managers
|
| rather than:
| resource-managers
| resource-manager res-class=
| res-nameDefaultDS/res-name
| res-jndi-namejava:/DefaultDS/res-jndi-name
| /resource-manager
| /resource-managers
|
| the descriptor will be broken.
|
| ~
| Namaste - I bow to the divine in you
| ~
| Filip Hanik
| Software Architect
| [EMAIL PROTECTED]
| www.filip.net
|
| -Original Message-
| From: [EMAIL PROTECTED]
| [mailto:[EMAIL PROTECTED]]On
|Behalf Of Roman
| Brouk
| Sent: Wednesday, April 25, 2001 1:42 PM
| To: [EMAIL PROTECTED]
| Subject: RE: [JBoss-dev] Connection Pool - Help!
|
|
| oh... sorry i forgot to add i am not using CMP, i am aquiring
| connection in
| every entity bean with the following code in JAVA:
| Connection con = null;
| try{
| InitialContext jndiContext = new InitialContext();
| javax.sql.DataSource ds = (javax.sql.DataSource)
| jndiContext.lookup(java:/MySQLDB);
| con = ds.getConnection();
| }catch(javax.naming.NamingException exne)
| {
| System.out.println(*** + exne.getMessage());
| }
|
|
| -Original Message-
| From: [EMAIL PROTECTED]
| [mailto:[EMAIL PROTECTED]]On
|Behalf Of Roman
| Brouk
| Sent: Wednesday, April 25, 2001 11:56 AM
| To: [EMAIL PROTECTED]
| Subject: [JBoss-dev] Connection Pool - Help!
|
|
| Hello all,
|
| If anyone had this problem please help! I have to use
|connection pool in
| jboss in order to use Transactions(is that right?). I am using Java
| context.lookup to locate my connection pool(java:/MySQLDB) and
|i get the
| error of the poolname not beeing bound although when i start
|up jboss it
| says [MySQLDB] XA Connection pool MySQLDB bound to java:/MySQLDB.
|
| I am using mySQL database.
| here is what i did:
|
| in jboss.properties i added:
| jdbc.drivers=org.gjt.mm.mysql.Driver,oracle.jdbc.driver.OracleDriver
|
| in jaws file i added:
| jaws
| datasourceMySQLDB/datasource
| type-mappingmySQL/type-mapping
| /jaws
|
| in jboss.conf i added:
| MLET CODE=org.jboss.jdbc.XADataSourceLoader ARCHIVE=jboss.jar
| CODEBASE=../../lib/ext/
| ARG TYPE=java.lang.String VALUE=MySQLDB
| ARG TYPE=java.lang.String
| VALUE=org.jboss.minerva.xa.XADataSourceImpl
| /MLET
|
| in jboss.jcml i added (notice that PoolName is missing. for some reason
| although i add poolname as an attribute it will be deleted when
| i start up
| jboss):
| server
| mbean name=DefaultDomain:service=XADataSource,name=MySQLDB
| attribute name=GCMinIdleTime120/attribute
| attribute name=JDBCUser /
| attribute name=MaxSize0/attribute
| attribute name=Password /
| attribute
| name=URLjdbc:mysql://localhost/CogeniaDB/attribute
| attribute name=GCEnabledfalse/attribute
| attribute name=InvalidateOnErrorfalse/attribute
| attribute name=TimestampUsedfalse/attribute
| attribute name=Blockingtrue/attribute
| attribute name=GCInterval12/attribute
| attribute name=IdleTimeout180/attribute
| attribute name=IdleTimeoutEnabledfalse