Need to add OracleDriver to jboss.properties file. (I forget the full
classname, oracle.jdbc.driver.OracleDriver or something like that)
If you continue having issues posting console output + stack trace would be
helpful
> -----Original Message-----
> From: Thierry Templier [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 01, 2001 2:44 AM
> To: [EMAIL PROTECTED]
> Subject: [jBoss-User] Associate a jndi name to a datasource
>
>
> Hello,
>
> I have the following xml config files:
>
>
> // jboss.conf
>
> <MLET CODE = "org.jboss.logging.Logger" ARCHIVE="jboss.jar"
> CODEBASE="../../lib/ext/">
> </MLET>
>
>
> <MLET CODE = "org.jboss.logging.ConsoleLogging"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="Information,Warning,Error">
> <ARG TYPE="java.lang.String" VALUE="[{2}] {4}">
> </MLET>
>
> <MLET CODE = "org.jboss.util.ClassPathExtension"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="../../log/">
> </MLET>
>
>
> <MLET CODE = "org.jboss.logging.FileLogging"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String"
> VALUE="Information,Debug,Warning,Error">
> <ARG TYPE="java.lang.String" VALUE="[{2}] {4}">
> </MLET>
>
> <MLET CODE = "org.jboss.util.ClassPathExtension"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="../../tmp/">
> </MLET>
>
> <MLET CODE = "org.jboss.util.ClassPathExtension"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="../../db/">
> </MLET>
>
> <MLET CODE = "org.jboss.util.Info" ARCHIVE="jboss.jar"
> CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "org.jboss.util.ClassPathExtension"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="./">
> </MLET>
>
> <MLET CODE = "org.jboss.jdbc.JdbcProvider"
> ARCHIVE="jboss.jar,idb.jar,hsql.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "org.jboss.web.WebService"
> ARCHIVE="jboss.jar,dynaserver.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "org.jboss.jdbc.HypersonicDatabase"
> ARCHIVE="jboss.jar,hsql.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "org.jboss.naming.NamingService"
> ARCHIVE="jnpserver.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "org.jboss.tm.TransactionManagerService"
> ARCHIVE="jboss.jar,jta-spec1_0_1.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "org.jboss.security.JaasSecurityManagerService"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "org.jboss.security.SimpleRealmMappingService"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "org.jboss.security.EJBSecurityManagerService"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE="org.jboss.jdbc.XADataSourceLoader"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="InstantDB">
> <ARG TYPE="java.lang.String"
> VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> </MLET>
>
> <MLET CODE="org.jboss.jdbc.XADataSourceLoader"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="DefaultDS">
> <ARG TYPE="java.lang.String"
> VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> </MLET>
>
> <MLET CODE="org.jboss.jdbc.XADataSourceLoader"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="JetEngineDB">
> <ARG TYPE="java.lang.String"
> VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> </MLET>
>
> <MLET CODE = "org.jboss.ejb.ContainerFactory"
> ARCHIVE="jboss.jar,ejb.jar,jnp-client.jar,ejxeditor.jar,ejxjbo
> ss.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "org.jboss.ejb.AutoDeployer" ARCHIVE="jboss.jar">
> <ARG TYPE="java.lang.String" VALUE="../deploy/">
> </MLET>
>
> <MLET CODE = "org.jboss.jmx.server.JMXAdaptorService"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "org.jboss.jmx.server.RMIConnectorService"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <MLET CODE = "com.sun.jdmk.comm.HtmlAdaptorServer"
> ARCHIVE="jmxtools.jar" CODEBASE="../../lib/ext/"
> NAME="Adaptor:name=html">
> </MLET>
>
> <MLET CODE = "org.jboss.configuration.ConfigurationService"
> ARCHIVE="jboss.jar,../xml.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
> <!--
> -- The j2ee deployer can deploy jar,war and ear files. Its
> role is to
> -- split the archive and hand the parts (jars, wars) to the
> relevant
> -- deployers
> --
> -- Arguments: #1: where the j2eedeployer should store its
> config files
> -- #2: the jar deployer: currently only ContainerFactory
> -- #3: the war deployer: you can use tomcat
> (":service=EmbeddedTomcat")
> -- or jetty (":service=Jetty")
> -- See below to start these services
> -->
> <MLET CODE = "org.jboss.deployment.J2eeDeployer"
> ARCHIVE="jboss.jar,../xml.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="../tmp/deploy">
> <ARG TYPE="java.lang.String" VALUE="EJB:service=ContainerFactory">
> <ARG TYPE="java.lang.String" VALUE=":service=EmbeddedTomcat">
> </MLET>
>
>
> <!--
> -- Uncomment this to add "Stand-alone Stack Tomcat support".
> -- This means that JSP and Servlets will work with EJB in
> different stacks and
> -- communicate through network invocation. If you
> benchmark j2ee please use "integrated stack".
> -- Also note that you cannot use the J2EE deployer with
> Tomcat in this configuration.
> -- Be sure to set your 'TOMCAT_HOME' environment variable
> before starting JBoss.
> -- Note: this reads the server.xml configuration file of
> Tomcat, you can't use the j2ee deployer
> --
> -- MLET CODE = "org.jboss.tomcat.TomcatService"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> -- /MLET>
> -->
>
> <!-- WARNING: only one of the tomcat services can be
> configured, either "stand alone or integrated" -->
>
> <!--
> -- Uncomment this to add "Integrated Stack (fast) Tomcat support".
> -- This service allows you to integrate the stack of Tomcat
> and jboss.
> -- Invocations are not going through network but pass
> native pointers resulting in dramatic speed increases.
> -- This service allows the J2EE deployer to add and remove
> Tomcat contexts dynamically
> -- through JMX for you and in effect deploy EARs. Note that
> tomcat's server.xml file will not be processed:
> -- you can only use JMX to add contexts. Use the J2EE
> deployer to deploy full EARs on this stack
> -- Be sure to set your 'TOMCAT_HOME' environment variable
> before starting JBoss.
> --
> -- The ARG tag is the port to run tomcat on.
> --
> -- MLET CODE = "org.jboss.tomcat.EmbeddedTomcatService"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> -- ARG TYPE="int" VALUE=8080>
> -- /MLET>
> -->
>
> <!--
> -- Uncomment this to add Jetty support.
> -- This service allows you to add and remove Jetty contexts
> dynamically
> -- through JMX.
> -- Be sure to set your 'JETTY_HOME' environment variable
> before starting
> -- JBoss.
> -- Replace the ARG tag to give Jetty's XML configuration file.
> -- You can use JBOSS_HOME/conf/default/jetty.xml
> --
> -- MLET CODE = "org.jboss.jetty.JettyService"
> ARCHIVE="jetty-service.jar" CODEBASE="../../lib/ext/">
> -- ARG TYPE="java.lang.String"
> VALUE="file:/usr/jboss/conf/default/jetty.xml">
> -- /MLET>
> -->
>
> <MLET CODE = "org.jboss.spydermq.SpyderMQService"
> ARCHIVE="jboss.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
>
>
> <!--
> -- Add templth
> -- Specifique Oracle
> -->
>
> <MLET CODE="org.jboss.jdbc.XADataSourceLoader"
> ARCHIVE="jboss.jar" CODEBASE="../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="OracleDB">
> <ARG TYPE="java.lang.String"
> VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> </MLET>
>
>
> // jboss.xml
>
> <?xml version="1.0" encoding="Cp1252"?>
>
> <jboss>
> <secure>false</secure>
> <container-configurations />
>
> <resource-managers>
> <resource-manager
> res-class="org.jboss.ejb.deployment.JDBCResource">
> <res-name>java:/OracleDB</res-name>
> <res-jndi-name>OracleDB</res-jndi-name>
> </resource-manager>
> </resource-managers>
>
> <enterprise-beans>
> <session>
> <ejb-name>UserBean</ejb-name>
> <jndi-name>auth/User</jndi-name>
> <configuration-name></configuration-name>
> </session>
> </enterprise-beans>
> </jboss>
>
>
> // ejb-jar.xml
>
> <ejb-jar>
> <description>authuser application </description>
> <display-name>User</display-name>
> <enterprise-beans>
> <entity>
> <description>test username</description>
> <ejb-name>UserBean</ejb-name>
> <home>UserHome</home>
> <remote>User</remote>
> <ejb-class>UserBean</ejb-class>
> <persistence-type>Container</persistence-type>
> <prim-key-class>UserPK</prim-key-class>
> <reentrant>False</reentrant>
> <cmp-field><field-name>id</field-name></cmp-field>
> <cmp-field><field-name>username</field-name></cmp-field>
> <resource-ref>
> <res-ref-name>java:/OracleDB</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
> </entity>
> </enterprise-beans>
> </ejb-jar>
>
>
> // jboss.jcml
>
> <?xml version="1.0"?>
>
> <server>
> <mbean name="Adaptor:name=html">
> <attribute name="MaxActiveClientCount">10</attribute>
> <attribute name="Parser" />
> <attribute name="Port">8082</attribute>
> </mbean>
> <mbean name="DefaultDomain:service=MLet">
> <attribute
> name="LibraryDirectory">C:\Thierry\jBoss-2.0_FINAL\bin</attribute>
> </mbean>
> <mbean name="DefaultDomain:service=TransactionManager">
> <attribute name="TransactionTimeout">300</attribute>
> </mbean>
> <mbean name="DefaultDomain:service=Logging,type=Console">
> <attribute name="Format">[{2}] {4}</attribute>
> </mbean>
> <mbean name="DefaultDomain:service=Webserver">
> <attribute name="Port">8083</attribute>
> </mbean>
> <mbean
> name="DefaultDomain:service=XADataSource,name=JetEngineDB">
> <attribute name="Properties"></attribute>
> <attribute name="URL">jdbc:odbc:archeo</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">templ</attribute>
> <attribute name="MaxSize">0</attribute>
> <attribute name="Password">templ</attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="MinSize">0</attribute>
> </mbean>
> <mbean name="DefaultDomain:service=Logging,type=File">
> <attribute name="Format">[{2}] {4}</attribute>
> <attribute name="LogName">server</attribute>
> </mbean>
> <mbean name="DefaultDomain:service=XADataSource,name=InstantDB">
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc:idb:../conf/default/instantdb.properties</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser" />
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password" />
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="MinSize">0</attribute>
> </mbean>
> <mbean name="DefaultDomain:service=Hypersonic">
> <attribute name="Port">1476</attribute>
> <attribute name="Silent">true</attribute>
> <attribute name="Database">default</attribute>
> <attribute name="Trace">false</attribute>
> </mbean>
> <mbean name="DefaultDomain:service=XADataSource,name=OracleDB">
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc:oracle:thin:@192.168.100.2:1521:ispb</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">stage_master</attribute>
> <attribute name="MaxSize">0</attribute>
> <attribute name="Password">oracle</attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="MinSize">0</attribute>
> </mbean>
> <mbean name="DefaultDomain:service=XADataSource,name=DefaultDS">
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc:HypersonicSQL:hsql://localhost:1476</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">sa</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password" />
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="MinSize">0</attribute>
> </mbean>
> <mbean name="EJB:service=ContainerFactory">
> <attribute name="VerifyDeployments">true</attribute>
> <attribute name="MetricsEnabled">false</attribute>
> <attribute name="VerifierVerbose">true</attribute>
> </mbean>
> </server>
>
>
> With this config I can't access to the datasource with the
> jndi name OracleDB in a client application ( process java
> with main ). Is anyone have already this problem?
> Thanks for your help.
> Templ
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
This message (including any attachments) contains confidential, proprietary
or privileged information intended for a specific purpose and individual(s),
and is protected by law. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. Any unauthorized disclosure,
copying or distribution of any part of this message, or the taking of any
unauthorized action based on it, is strictly prohibited.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
