I am having trouble deploying a CMP entity bean using the JBoss BETA-PROD02
binary. My intent is to have an entity bean persist its info in a Microsoft
SQL Server 7.0 database via the Sun JDBC-ODBC bridge.
(NOTE: I do realize the JDBC-ODBC bridge has "issues" making it
inappropriate for high-end use, but I thought it would at least be suitable
for basic deployment testing.)
I am not sure whether I have configured something incorrectly or if a bug is
biting me. The JBoss server.log (below) indicates the following two errors
for which I cannot find any documentation:
[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'
Also, trace files I have generated at the ODBC layer indicate the username
being used by JBoss to access the database server is a "string of garbage
characters" rather than the username "jboss_server" that I am expecting.
This seems consistent with the first error message listed above.
Would someone please help me understand all this?
Thanks!
Mark H. McLain
Systems Developer
Sybron Laboratory Products Corporation
~~~~~~~~~~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:org.hsql.jdbcDriver
[JDBC] Loaded JDBC-driver:jdbc.idbDriver
[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/tmpejbjar21922.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 (***** This table is really not being 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
~~~~~~~~~~jboss.conf (relevant section only) ~~~~~~~~~~
<MLET CODE="org.jboss.jdbc.XADataSourceLoader"
ARCHIVE="jboss.jar,c:\jdk1.3\jre\lib\rt.jar" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="mssqlserverpool">
<ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
~~~~~~~~~~jboss.properties~~~~~~~~~~
# System properties
# These will be loaded and set by jBoss
#java.rmi.server.useLocalHostName=true
#java.rmi.server.hostname=localhost
#java.rmi.server.codebase=http://localhost:8080/
jdbc.drivers=org.hsql.jdbcDriver,jdbc.idbDriver,sun.jdbc.odbc.JdbcOdbcDriver
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]
