Try looking up
 
java:/MySqlDB
 
Should work..
 
Vinay

----- Original Message -----
From: Michael Baedorf
Sent: Thursday, May 03, 2001 3:06 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] not bound problem

Hello,

I´m a newbie and I have a problem getting a database connection.

I configured the following in the jboss.jcml:

  <mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
     <attribute name="Drivers">


org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,org.gjt.mm.mysql.Driver
     </attribute>
  </mbean>


   <mbean code="org.jboss.jdbc.XADataSourceLoader"
              name="DefaultDomain:service=XADataSource,name=MySqlDB">
    <attribute name= "DataSourceClass">

org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
    <attribute name="PoolName">MySqlDB</attribute>
    <attribute name="URL">jdbc:mysql://localhost:3306/gsfs</attribute>
    <attribute name="MinSize">10</attribute>
    <attribute name="MaxSize">100</attribute>
    <attribute name="JDBCUser">gsfs</attribute>
    <attribute name="Password">gsfs</attribute>
  </mbean>

In the standardjaws.xml I added:
    <datasource>java:/MySqlDB</datasource>
    <type-mapping>mySQL</type-mapping>

After starting the server I get the message:
   [MySqlDB] Starting
   [MySqlDB] XA Connection pool MySqlDB bound to java:/MySqlDB
   [MySqlDB] Started

JNDIView result:
java: Namespace
  +- MinervaXACMFactory (class:
      org.opentools.minerva.connector.jboss.MinervaXACMFactory)
  +- DefaultDS (class: org.opentools.minerva.jdbc.xa.XAPoolDataSource)
  +- SecurityProxyFactory (class:
org.jboss.security.SubjectSecurityProxyFactory)
  +- MySqlDB (class: org.opentools.minerva.jdbc.xa.XAPoolDataSource)
  ...

Now I try to look for the DB (not using a bean nor a servlet):
try {
   props = new Properties();
   props.setProperty
          ("java.naming.factory.initial",
"org.jnp.interfaces.NamingContextFactory");
   props.setProperty
          ("java.naming.provider.url", "localhost:1099");
   props.setProperty
          ("java.naming.factory.url.pkgs", "org.jboss.naming");

            ctx = new InitialContext(props);
            System.out.println("Got Context");

            objRef = ctx.lookup("MySqlDB");
            System.out.println("Got Reference");
   ...
} catch ...

Running the simple program only throw an exception:
    MySqlDB not bound

I included all packages mentioned in chapter 1 of the online documentation.

Can somebody tell me what´s the error?

Thanks.

--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net



--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



Get your FREE download of MSN Explorer at http://explorer.msn.com

Reply via email to