Aaron- One other thought: Will JBoss retain a table it has created if that table does not have any entity bean info (rows) persisted into it? In my case, I am deploying an entity bean, but have not created instances of the entity bean (rows in the table) yet. If I shutdown JBoss, should the table be persisted with no rows in it? I am assuming the answer is "Yes", but it appears in practice the answer is "No." It appears that the CREATE TABLE statement is successfully executed, but is perhaps being "rolled back" when JBoss is shutdown. Thanks! -----Original Message----- From: Aaron Mulder [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 12, 2000 4:05 PM To: jBoss Cc: Van Bruggen, Pete Subject: Re: [jBoss-User] CMP entity bean deployment inoperable using JDBC -ODBC bridge to Microsoft SQL Server 7 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] -- -------------------------------------------------------------- To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Problems?: [EMAIL PROTECTED]
