--- 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]
