It doesn't look like there's any problem to me! The pool is
initialized, it successfully opens a connection, JAWS creates a
table... Why do you think it's not working?
Also, the DataSourceImpl is no longer supported so your
configuration is correct.
Aaron
On Thu, 12 Oct 2000, McLain, Mark wrote:
> Aaron-
>
> Here is the information you requested. Thanks for taking a look.
>
> While I have your attention, one other question comes to mind: The approach
> I am taking (detailed in the files below) is different from the jdbc-odbc
> approach posted to jboss-user by Steve Kwee on June 27, 2000 at 8:20pm. In
> his approach, the MLET is defined to use "org.jboss.jdbc.DataSourceImpl".
> My MLET is using "org.jboss.jdbc.XADataSourceLoader". Is his approach still
> valid, or does the XADataSourceLoader supersede the DataSourceImpl? (My
> implementation is derived from following the "Advanced Configuration"
> section of the "JBoss 2.0 Manual" in the "Getting Started" section of the
> JBoss website. I am not sure how Steve came up with his approach.)
>
> -Mark
>
>
>
>
> ~~~~~~~~~~Complete server.log~~~~~~~~~~
>
> [File logging] Logging started
> [Classpath] Added directory:file:/C:/JBoss/tmp/
> [Classpath] Added directory:file:/C:/JBoss/db/
> [Info] Java version: 1.3.0,Sun Microsystems Inc.
> [Info] Java VM: Java HotSpot(TM) Client VM 1.3.0-C,Sun Microsystems Inc.
> [Info] System: Windows 2000 5.0,x86
> [Classpath] Added library:file:/C:/JBoss/lib/ext/jta-spec1_0_1.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/jnpserver.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/ejxeditor.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/activation.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/mail.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/ejb.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/dynaserver.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/awt.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/idb.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/jmxtools.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/hsql.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/ejxejb.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/jpl-util-0_5b.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/jndi.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/jdbc2_0-stdext.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/ejxjaws.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/ejxjboss.jar
> [Classpath] Added library:file:/C:/JBoss/lib/ext/jboss.jar
> [JDBC] Loaded JDBC-driver:sun.jdbc.odbc.JdbcOdbcDriver
> [Webserver] Initializing
> [Webserver] Initialized
> [Naming] Initializing
> [Naming] Naming started on port 1099
> [Naming] Initialized
> [Transaction manager] Initializing
> [Transaction manager] Initialized
> [Simple Realm Mapping] Initializing
> [Simple Realm Mapping] Initialized
> [Security manager] Initializing
> [Security manager] Initialized
> [XADataSource] Initializing
> [XADataSource] Initialized
> [Container factory] Initializing
> [Container factory] Temporary directory set to:C:\JBoss\tmp\deploy
> [Container factory] Previous deployments removed
> [Container factory] Initialized
> [Auto deploy] Watching C:\JBoss\deploy
> [Auto deployer] Initializing
> [Auto deployer] Initialized
> [JMX RMI Adaptor] Initializing
> [JMX RMI Adaptor] Initialized
> [JMX RMI Connector] Initializing
> [JMX RMI Connector] Initialized
> [Configuration] Initializing
> [Configuration] Initialized
> [J2ee deployer] Initializing
> [J2ee deployer] no config file found...
> [J2ee deployer] Initialized
> [Configuration] MaxActiveClientCount set to 10 in Adaptor:name=html
> [Configuration] Port set to 8082 in Adaptor:name=html
> [Configuration] LibraryDirectory set to C:\JBoss\bin in
> DefaultDomain:service=MLet
> [Configuration] Format set to [{2}] {4} in
> DefaultDomain:service=Logging,type=Console
> [Configuration] Port set to 8083 in DefaultDomain:service=Webserver
> [Configuration] LogName set to server.log in
> DefaultDomain:service=Logging,type=File
> [Configuration] URL set to jdbc:odbc:jboss in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] GCMinIdleTime set to 1200000 in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] JDBCUser set to jboss_server in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] MaxSize set to 0 in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] Password set to boomvang in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] GCEnabled set to false in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] InvalidateOnError set to false in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] TimestampUsed set to false in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] Blocking set to false in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] GCInterval set to 120000 in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] IdleTimeout set to 1800000 in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] IdleTimeoutEnabled set to false in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] LoggingEnabled set to false in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] MaxIdleTimeoutPercent set to 1.0 in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] MinSize set to 0 in
> DefaultDomain:service=XADataSource,name=mssqlserverpool
> [Configuration] VerifyDeployments set to true in
> EJB:service=ContainerFactory
> [Configuration] Detected JMX Bug: Server reports attribute 'JDBCUser' is not
> writeable for MBean
> 'DefaultDomain:name=mssqlserverpool,service=XADataSource'
> [Configuration] Detected JMX Bug: Server reports attribute 'TimestampUsed'
> is not writeable for MBean
> 'DefaultDomain:name=mssqlserverpool,service=XADataSource'
> [Naming] Starting
> [Naming] Started
> [Transaction manager] Starting
> [Transaction manager] Started
> [XADataSource] Starting
> [XADataSource] XA Connection pool mssqlserverpool bound to mssqlserverpool
> [XADataSource] Started
> [Container factory] Starting
> [Container factory] Started
> [J2ee deployer] Starting
> [J2ee deployer] No EmbededTomcat found - only EJB deployment available...
> [J2ee deployer] trying to redeploy all applications that were running before
> shutdown...
> [J2ee deployer] deployment state recovered.
> [J2ee deployer] Started
> [Auto deployer] Starting
> [Auto deploy] Auto deploy of file:/C:/JBoss/deploy/entity.jar
> [Container factory] Deploying:file:/C:/JBoss/deploy/entity.jar
> [Container factory] Loading ejb-jar.xml :
> file:/H:/jbosstest/entity/META-INF/ejb-jar.xml
> [Container factory] Loading standardjboss.xml :
> jar:file:/C:/JBoss/lib/ext/jboss.jar!/org/jboss/metadata/standardjboss.xml
> [Verifier] Verifying file:/C:/JBoss/tmp/deploy/tmpejbjar17886.jar
> [Verifier] sequence5: Verified.
> [Container factory] Deploying sequence5
> [Container factory] Container Invoker Optimize='false'
> [JAWS] Initializing JAWS plugin for sequence5
> [JAWS] Loading standardjaws.xml :
> jar:file:/C:/JBoss/lib/ext/jboss.jar!/org/jboss/ejb/plugins/jaws/metadata/st
> andardjaws.xml
> [JAWS] file:/H:/jbosstest/entity/META-INF/jaws.xml found. Overriding
> defaults
> [JAWS] Table joelull created
> [Container factory] Bound sequence5 to sequence5
> [Container factory] Deployed application: file:/C:/JBoss/deploy/entity.jar
> [Auto deployer] Started
> [Security manager] Starting
> [Security manager] Started
> [Simple Realm Mapping] Starting
> [Simple Realm Mapping] Started
> [Webserver] Starting
> [Webserver] Codebase set to http://USMI00200002:8083/
> [Webserver] Started webserver on port 8083
> [Webserver] Started
> [JMX RMI Adaptor] Starting
> [JMX RMI Adaptor] Started
> [JMX RMI Connector] Starting
> [JMX RMI Connector] Started
> [Default] 20 services and 4 other MBeans started.
> [Default] Shutdown hook added
> [Default] jBoss 2.0 BETA-PROD-02 Started
> [JMX RMI Adaptor] Stopping
> [JMX RMI Adaptor] Stopped
> [JMX RMI Adaptor] Destroying
> [JMX RMI Adaptor] Destroyed
> [JMX RMI Connector] Stopping
> [JMX RMI Connector] Stopped
> [JMX RMI Connector] Destroying
> [JMX RMI Connector] Destroyed
> [Webserver] Stopping
> [Webserver] Stopped
> [Webserver] Destroying
> [Webserver] Destroyed
> [Simple Realm Mapping] Stopping
> [Simple Realm Mapping] Stopped
> [Simple Realm Mapping] Destroying
> [Simple Realm Mapping] Destroyed
> [Security manager] Stopping
> [Security manager] Stopped
> [Security manager] Destroying
> [Security manager] Destroyed
> [Auto deployer] Stopping
> [Auto deployer] Stopped
> [Auto deployer] Destroying
> [Auto deployer] Destroyed
> [J2ee deployer] Stopping
> [J2ee deployer] Stopped
> [J2ee deployer] Destroying
> [J2ee deployer] Destroyed
> [Container factory] Stopping
> [Container factory] Stopped
> [Container factory] Destroying
> [Container factory] Destroyed
> [XADataSource] Stopping
> [XADataSource] XA Connection pool mssqlserverpool removed from JNDI
> [XADataSource] XA Connection pool mssqlserverpool shut down
> [XADataSource] Stopped
> [XADataSource] Destroying
> [XADataSource] Destroyed
> [Transaction manager] Stopping
> [Transaction manager] Stopped
> [Transaction manager] Destroying
> [Transaction manager] Destroyed
> [Naming] Stopping
> [Naming] Stopped
> [Naming] Destroying
> [Naming] Destroyed
> [Default] 20 services and 4 other MBeans stopped.
>
>
>
>
> ~~~~~~~~~~Complete 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.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.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,c:\jdk1.3\jre\lib\rt" CODEBASE="../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="mssqlserverpool">
> <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,ejxjboss.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>
>
> <MLET CODE = "org.jboss.deployment.J2eeDeployer"
> ARCHIVE="jboss.jar,../xml.jar" CODEBASE="../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="../tmp">
> </MLET>
>
>
> <!--
> -- Uncomment this to add Tomcat support. Be sure to set your
> 'TOMCAT_HOME'
> -- environment variable before starting JBoss.
> -- MLET CODE = "org.jboss.tomcat.TomcatService" ARCHIVE="jboss.jar"
> CODEBASE="../lib/ext/">
> -- /MLET>
> -->
>
> <!--
> -- Uncomment this to add Tomcat support.
> -- This service allows you to add and remove Tomcat contexts dynamically
> -- through JMX. Note that tomcat's server.xml file will not be processed:
> -- you can only use JMX to add contexts.
> -- 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.EmbededTomcatService" ARCHIVE="jboss.jar"
> CODEBASE="../lib/ext/">
> -- ARG TYPE="int" VALUE=8080>
> -- /MLET>
> -->
>
> <!--
> -- Uncomment this to add SpyderMQ support. Be sure to set your
> 'SPYDERMQ_HOME'
> -- environment variable before starting JBoss. You'll also need to copy
> the
> -- spyderMQ.properties file from your SpyderMQ installation to you JBoss
> -- installation conf dir.
> -- MLET CODE = "org.jboss.spydermq.SpyderMQService" ARCHIVE="jboss.jar"
> CODEBASE="../lib/ext/">
> -- /MLET>
> -->
>
>
>
>
> ~~~~~~~~~~Complete 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:\JBoss\bin</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=Logging,type=File">
> <attribute name="LogName">server.log</attribute>
> </mbean>
> <mbean name="DefaultDomain:service=XADataSource,name=mssqlserverpool">
> <attribute name="Properties"></attribute>
> <attribute name="URL">jdbc:odbc:jboss</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">jboss_server</attribute>
> <attribute name="MaxSize">0</attribute>
> <attribute name="Password">mypassword</attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">false</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>
> </mbean>
> </server>
>
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
