Hi!
With the debug flag I meant changing
public static boolean debug = false;
to
public static boolean debug = true;
in
jboss/src/main/org/jboss/ejb/plugins/jaws/jdbc/JDBCCommand.java
before compiling jBoss.
Then you will see all JDBC commands before they are issued.
Bye,
Tobias
Honoria Sauciuc wrote:
>
> --- Tobias Frech <[EMAIL PROTECTED]> wrote:
> > Hi!
> > Could you activate the debug flag in
> > JDBCCommand.java and check if the
> > JDBC Driver (!!!) understands the command it should
> > handle (perhaps
> > write a small JDBC test with that command on your
> > own) ?! Note that
> > entering that command into the interbase console
> > does not tell you if
> > the JDBC driver can handle it or not!
> > I would be very interested in the results.
> >
> > Tobias
> >
> I am not sure I understand what Tobias meant. Can you
> be more specific?
> If you were wondering if it's a JDBC driver problem, I
> can assure you that I have worked with it for a while
> (using servlets) and I used delete, select, update and
> they work just fine. I needed to do an explicit commit
> from my JAVA code, though I heard it works without it
> to.
> About the debug flag, here is my log [File logging]
> Initialized
> [Classpath extension] Initializing
> [Classpath extension] Added
> directory:file:/D:/jboss/tmp/
> [Classpath extension] Initialized
> [Classpath extension] Initializing
> [Classpath extension] Added
> directory:file:/D:/jboss/db/
> [Classpath extension] Initialized
> [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 extension] Initializing
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/ejxejb.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/activation.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/ejb.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/jmxtools.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/spydermq.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/mail.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/awt.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/ejxeditor.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/hsql.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/dynaserver.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/jnpserver.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/idb.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/jms.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/tomcat-service.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/jpl-util-0_5b.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/jndi.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/jetty-service.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/jta-spec1_0_1.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/ejxjaws.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/ejxjboss.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/jboss.jar
> [Classpath extension] Added
> library:file:/D:/jboss/lib/ext/interclient.jar
> [Classpath extension] Initialized
> [JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
> [JDBC] Loaded
> JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
> [JDBC] Loaded JDBC-driver:interbase.interclient.Driver
> [Webserver] Initializing
> [Webserver] Initialized
> [Hypersonic] Initializing
> [Hypersonic] Initialized
> [Naming] Initializing
> [Naming] Naming started on port 1099
> [Naming] Initialized
> [Transaction manager] Initializing
> [Transaction manager] Initialized
> [JAAS Security Manager] Initializing
> [JAAS Security Manager] Initialized
> [Simple Realm Mapping] Initializing
> [Simple Realm Mapping] Initialized
> [Security manager] Initializing
> [Security manager] Initialized
> [InstantDB] Initializing
> [InstantDB] Initialized
> [DefaultDS] Initializing
> [DefaultDS] Initialized
> [Container factory] Initializing
> [Container factory] Initialized
> [Auto deploy] Watching D:\jboss\deploy
> [Auto deploy] Initializing
> [Auto deploy] Initialized
> [JMX RMI Adaptor] Initializing
> [JMX RMI Adaptor] Initialized
> [JMX RMI Connector] Initializing
> [JMX RMI Connector] Initialized
> [Configuration] Initializing
> [Configuration] Initialized
> [InterBase] Initializing
> [InterBase] Initialized
> [J2EE Deployer] Initializing
> [J2EE Deployer] Initialized
> [Tomcat] Initializing
> [Tomcat] Initialized
> [SpyderMQ] Initializing
> [SpyderMQ] Initialized
> [Configuration] MaxActiveClientCount set to 10 in
> Adaptor:name=html
> [Configuration] Port set to 8082 in Adaptor:name=html
> [Configuration] URL set to
> jdbc:interbase://localhost/d:/Borland/InterBase/bin/Account.gdb
> in DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] GCMinIdleTime set to 1200000 in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] JDBCUser set to sysdba in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] MaxSize set to 0 in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] Password set to masterkey in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] GCEnabled set to false in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] InvalidateOnError set to false in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] TimestampUsed set to false in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] Blocking set to true in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] GCInterval set to 120000 in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] IdleTimeout set to 1800000 in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] IdleTimeoutEnabled set to false in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] LoggingEnabled set to true in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] MaxIdleTimeoutPercent set to 1.0 in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] MinSize set to 0 in
> DefaultDomain:service=XADataSource,name=InterBase
> [Configuration] LibraryDirectory set to D:\jboss\bin
> in DefaultDomain:service=MLet
> [Configuration] TransactionTimeout set to 300 in
> DefaultDomain:service=TransactionManager
> [Configuration] Format set to [{2}] {4} in
> DefaultDomain:service=Logging,type=Console
> [Configuration] Port set to 8083 in
> DefaultDomain:service=Webserver
> [Configuration] Format set to [{2}] {4} in
> DefaultDomain:service=Logging,type=File
> [Configuration] LogName set to server in
> DefaultDomain:service=Logging,type=File
> [Configuration] URL set to
> jdbc:idb:../conf/default/instantdb.properties in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] GCMinIdleTime set to 1200000 in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] MaxSize set to 0 in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] GCEnabled set to false in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] InvalidateOnError set to false in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] TimestampUsed set to false in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] Blocking set to true in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] GCInterval set to 120000 in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] IdleTimeout set to 1800000 in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] IdleTimeoutEnabled set to false in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] LoggingEnabled set to false in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] MaxIdleTimeoutPercent set to 1.0 in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] MinSize set to 0 in
> DefaultDomain:service=XADataSource,name=InstantDB
> [Configuration] Port set to 1476 in
> DefaultDomain:service=Hypersonic
> [Configuration] Silent set to true in
> DefaultDomain:service=Hypersonic
> [Configuration] Database set to default in
> DefaultDomain:service=Hypersonic
> [Configuration] Trace set to false in
> DefaultDomain:service=Hypersonic
> [Configuration] URL set to
> jdbc:HypersonicSQL:hsql://localhost:1476 in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] GCMinIdleTime set to 1200000 in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] JDBCUser set to sa in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] MaxSize set to 10 in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] GCEnabled set to false in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] InvalidateOnError set to false in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] TimestampUsed set to false in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] Blocking set to true in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] GCInterval set to 120000 in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] IdleTimeout set to 1800000 in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] IdleTimeoutEnabled set to false in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] LoggingEnabled set to false in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] MaxIdleTimeoutPercent set to 1.0 in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] MinSize set to 0 in
> DefaultDomain:service=XADataSource,name=DefaultDS
> [Configuration] VerifyDeployments set to true in
> EJB:service=ContainerFactory
> [Configuration] MetricsEnabled set to false in
> EJB:service=ContainerFactory
> [Configuration] VerifierVerbose set to true in
> EJB:service=ContainerFactory
> [Configuration] Detected JMX Bug: Server reports
> attribute 'JDBCUser' is not writeable for MBean
> 'DefaultDomain:name=InterBase,service=XADataSource'
> [Configuration] Detected JMX Bug: Server reports
> attribute 'TimestampUsed' is not writeable for MBean
> 'DefaultDomain:name=InterBase,service=XADataSource'
> [Configuration] Detected JMX Bug: Server reports
> attribute 'JDBCUser' is not writeable for MBean
> 'DefaultDomain:name=InstantDB,service=XADataSource'
> [Configuration] Detected JMX Bug: Server reports
> attribute 'TimestampUsed' is not writeable for MBean
> 'DefaultDomain:name=InstantDB,service=XADataSource'
> [Configuration] Detected JMX Bug: Server reports
> attribute 'JDBCUser' is not writeable for MBean
> 'DefaultDomain:name=DefaultDS,service=XADataSource'
> [Configuration] Detected JMX Bug: Server reports
> attribute 'TimestampUsed' is not writeable for MBean
> 'DefaultDomain:name=DefaultDS,service=XADataSource'
> [Simple Realm Mapping] Starting
> [Simple Realm Mapping] Started
> [Webserver] Starting
> [Webserver] Codebase set to http://mzu:8083/
> [Webserver] Started webserver on port 8083
> [Webserver] Started
> [Tomcat] Starting
> [Tomcat] Testing if Tomcat is present....
> [Tomcat] OK
> [Tomcat] Starting Tomcat...
> [Tomcat] Starting tomcat. Check logs/tomcat.log for
> error messages
> [Tomcat] Started
> [Transaction manager] Starting
> [Transaction manager] Started
> [Hypersonic] Starting
> [Hypersonic] Server 1.4 is running
> [Hypersonic] Database started
> [Hypersonic] Started
> [Naming] Starting
> [Naming] Started
> [InterBase] Starting
> [InterBase] XA Connection pool InterBase bound to
> java:/InterBase
> [Hypersonic] Press [Ctrl]+[C] to abort
> [InterBase] org.jboss.minerva.xa.XADataSourceImpl
> created new Connection
> (interbase.interclient.Connection) with XAResource
> org.jboss.minerva.xa.XAResourceImpl and XAConnection
> org.jboss.minerva.xa.XAConnectionImpl.
> [InterBase] No transaction right now.
> [InterBase] Pool InterBase [0/0/Unlimited] gave out
> new object:
> org.jboss.minerva.xa.XAConnectionImpl@510a5c
> [InterBase] Pool InterBase [0/1/Unlimited] returned
> object org.jboss.minerva.xa.XAConnectionImpl@510a5c to
> the pool.
> [InterBase] Started
> [InstantDB] Starting
> [InstantDB] XA Connection pool InstantDB bound to
> java:/InstantDB
> [InstantDB] The Initial Developer of the Original Code
> is Lutris Technologies Inc.
> Portions created by Lutris are Copyright (C) 1997-2000
> Lutris Technologies, Inc.
> All Rights Reserved.
> [InstantDB] Started
> [DefaultDS] Starting
> [DefaultDS] XA Connection pool DefaultDS bound to
> java:/DefaultDS
> [DefaultDS] Started
> [JAAS Security Manager] Starting
> [JAAS Security Manager] Started
> [Container factory] Starting
> [Container factory] Started
> [J2EE Deployer] Starting
> [J2EE Deployer] No web container found - only EJB
> deployment available...
> [J2EE Deployer] Cleaning up deployment directory
> file:/D:/jboss/bin/../tmp/deploy/
> [J2EE Deployer] Started
> [Security manager] Starting
> [Security manager] Started
> [Auto deploy] Starting
> [Auto deploy] Auto deploy of
> file:/D:/jboss/deploy/account.jar
> [J2EE Deployer] Deploy J2EE application:
> file:/D:/jboss/deploy/account.jar
> [J2EE Deployer] Could not delete temporary file:
> /D:/jboss/bin/../tmp/deploy/copy1001.zip
> [J2EE Deployer] Create application account.jar
> [J2EE Deployer] Installing EJB package: account.jar
> [J2EE Deployer] Starting module account.jar
> [Container factory]
> Deploying:file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1002.jar
> [Container factory] Loading ejb-jar.xml :
> jar:file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1002.jar!/META-INF/ejb-jar.xml
> [Container factory] Loading standardjboss.xml :
> file:/D:/jboss/conf/default/standardjboss.xml
> [Container factory]
> jar:file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1002.jar!/META-INF/jboss.xml
> found. Overriding defaults
> [Verifier] Verifying
> file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1002.jar
> [Verifier] AccountEJB: Verified.
> [Container factory] Deploying AccountEJB
> [Container factory] Container Invoker RMI Port='4444'
> [Container factory] Container Invoker Optimize='true'
> [Container factory] Bound AccountEJB to MyAccount
> [Bean Cache] Cache policy scheduler started
> [Container factory] Deployed application:
> file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1002.jar
> [J2EE Deployer] J2EE application:
> file:/D:/jboss/deploy/account.jar is deployed.
> [Auto deploy] Started
> [SpyderMQ] Starting
> [SpyderMQ] Testing if SpyderMQ is present....
> [SpyderMQ] OK
> [SpyderMQ] Starting SpyderMQ...
> [SpyderMQ] Started
> [JMX RMI Adaptor] Starting
> [JMX RMI Adaptor] Started
> [JMX RMI Connector] Starting
> [JMX RMI Connector] Started
> [Default] 24 services and 4 other MBeans started.
> [Default] Shutdown hook added
> [Default] jBoss 2.0 FINAL Started
> [Auto deploy] Auto deploy of
> file:/D:/jboss/deploy/account.jar
> [J2EE Deployer] Stopping module account.jar
> [Container factory]
> Undeploying:file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1002.jar
> [Container factory] Undeployed application:
> file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1002.jar
> [J2EE Deployer] Destroying application account.jar
> [J2EE Deployer] deployment.cfg file deleted.
> [J2EE Deployer] Could not remove file:
> file:/D:/jboss/tmp/deploy/account.jar
> [J2EE Deployer] Deploy J2EE application:
> file:/D:/jboss/deploy/account.jar
> [J2EE Deployer] Could not delete temporary file:
> /D:/jboss/bin/../tmp/deploy/copy1003.zip
> [J2EE Deployer] Create application account.jar
> [J2EE Deployer] Installing EJB package: account.jar
> [J2EE Deployer] Starting module account.jar
> [Container factory]
> Deploying:file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1004.jar
> [Container factory] Loading ejb-jar.xml :
> jar:file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1004.jar!/META-INF/ejb-jar.xml
> [Container factory] Loading standardjboss.xml :
> file:/D:/jboss/conf/default/standardjboss.xml
> [Container factory]
> jar:file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1004.jar!/META-INF/jboss.xml
> found. Overriding defaults
> [Verifier] Verifying
> file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1004.jar
> [Verifier] AccountEJB: Verified.
> [Container factory] Deploying AccountEJB
> [Container factory] Container Invoker RMI Port='4444'
> [Container factory] Container Invoker Optimize='true'
> [Container factory] Bound AccountEJB to MyAccount
> [Container factory] Deployed application:
> file:/D:/jboss/bin/../tmp/deploy/account.jar/ejb1004.jar
> [J2EE Deployer] J2EE application:
> file:/D:/jboss/deploy/account.jar is deployed.
> [InterBase] Resource
> 'org.jboss.minerva.xa.XAResourceImpl@e4327' enlisted
> for 'org.jboss.minerva.xa.XAConnectionImpl@510a5c'.
> [InterBase] Pool InterBase [1/1/Unlimited] gave out
> pooled object:
> org.jboss.minerva.xa.XAConnectionImpl@510a5c
> [AccountEJB] endresources(0): state=1
> [Bean Cache] Resized cache for bean AccountEJB: old
> size = 1000, new size = 50
> [InterBase] org.jboss.minerva.xa.XADataSourceImpl
> created new Connection
> (interbase.interclient.Connection) with XAResource
> org.jboss.minerva.xa.XAResourceImpl and XAConnection
> org.jboss.minerva.xa.XAConnectionImpl.
> [InterBase] Resource
> 'org.jboss.minerva.xa.XAResourceImpl@226a77' enlisted
> for 'org.jboss.minerva.xa.XAConnectionImpl@5f48c4'.
> [InterBase] Pool InterBase [1/1/Unlimited] gave out
> new object:
> org.jboss.minerva.xa.XAConnectionImpl@5f48c4
> [AccountEJB] endresources(0): state=1
> [InterBase] org.jboss.minerva.xa.XADataSourceImpl
> created new Connection
> (interbase.interclient.Connection) with XAResource
> org.jboss.minerva.xa.XAResourceImpl and XAConnection
> org.jboss.minerva.xa.XAConnectionImpl.
> [InterBase] Resource
> 'org.jboss.minerva.xa.XAResourceImpl@60512a' enlisted
> for 'org.jboss.minerva.xa.XAConnectionImpl@25db4b'.
> [InterBase] Pool InterBase [2/2/Unlimited] gave out
> new object:
> org.jboss.minerva.xa.XAConnectionImpl@25db4b
> [AccountEJB] endresources(0): state=1
> [InterBase] org.jboss.minerva.xa.XADataSourceImpl
> created new Connection
> (interbase.interclient.Connection) with XAResource
> org.jboss.minerva.xa.XAResourceImpl and XAConnection
> org.jboss.minerva.xa.XAConnectionImpl.
> [InterBase] Resource
> 'org.jboss.minerva.xa.XAResourceImpl@30095d' enlisted
> for 'org.jboss.minerva.xa.XAConnectionImpl@29ac'.
> [InterBase] Pool InterBase [3/3/Unlimited] gave out
> new object: org.jboss.minerva.xa.XAConnectionImpl@29ac
> [AccountEJB] endresources(0): state=1
> [InterBase] org.jboss.minerva.xa.XADataSourceImpl
> created new Connection
> (interbase.interclient.Connection) with XAResource
> org.jboss.minerva.xa.XAResourceImpl and XAConnection
> org.jboss.minerva.xa.XAConnectionImpl.
> [InterBase] Resource
> 'org.jboss.minerva.xa.XAResourceImpl@18ce7e' enlisted
> for 'org.jboss.minerva.xa.XAConnectionImpl@126e90'.
> [InterBase] Pool InterBase [4/4/Unlimited] gave out
> new object:
> org.jboss.minerva.xa.XAConnectionImpl@126e90
> [AccountEJB] endresources(0): state=1
> [InterBase] org.jboss.minerva.xa.XADataSourceImpl
> created new Connection
> (interbase.interclient.Connection) with XAResource
> org.jboss.minerva.xa.XAResourceImpl and XAConnection
> org.jboss.minerva.xa.XAConnectionImpl.
> [InterBase] Resource
> 'org.jboss.minerva.xa.XAResourceImpl@354749' enlisted
> for 'org.jboss.minerva.xa.XAConnectionImpl@351404'.
> [InterBase] Pool InterBase [5/5/Unlimited] gave out
> new object:
> org.jboss.minerva.xa.XAConnectionImpl@351404
> [AccountEJB] endresources(0): state=1
> [Bean Cache] Passivated overaged bean AccountEJB with
> id = null
> import
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
