My application is working fine when going against the InstantDB, but when I
switch 
to SQLServer I get "Unable to create PreparedStatement"  This error occurs
when I 
either do a find or create on my beans.  I have tried both the INet and
Merant JDBC 
drivers.  I get the same error with both.

Any help would be greatly appreciated.
Please send any responses to [EMAIL PROTECTED]
Thanks,
Leonard Kierstead

The following shows the settings I use for both the InstantDB and SQLServer
JDBC driver and pools:

  <!-- Load only InstantDD JDBC driver --> 
  <mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
     <attribute
name="Drivers">org.enhydra.instantdb.jdbc.idbDriver</attribute>
  </mbean>

  <!-- Connection Pool for InstantDB driver -->
  <mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=Amstel1DB">
    <attribute name="PoolName">Amstel1DB</attribute>
    <attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
    <attribute name="Properties"></attribute>
    <attribute
name="URL">jdbc:idb:/amstel1/output/conf/data/amstel1.prp</attribute>
    <attribute name="GCMinIdleTime">1200000</attribute>
    <attribute name="JDBCUser" />
    <attribute name="MaxSize">10</attribute>
    <attribute name="Password" />
    <attribute name="GCEnabled">false</attribute>
    <attribute name="InvalidateOnError">false</attribute>
    <attribute name="TimestampUsed">false</attribute>
    <attribute name="Blocking">true</attribute>
    <attribute name="GCInterval">120000</attribute>
    <attribute name="IdleTimeout">1800000</attribute>
    <attribute name="IdleTimeoutEnabled">false</attribute>
    <attribute name="LoggingEnabled">true</attribute>
    <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
    <attribute name="MinSize">0</attribute>
  </mbean>

  <!-- Load only Merant JDBC driver 
  <mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
     <attribute
name="Drivers">com.merant.datadirect.jdbc.sqlserver.SQLServerDriver</attribu
te>
  </mbean>
  -->
  
  <!-- Connection Pool for Merant JDBC driver 
  <mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=Amstel1DB">
   <attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
   <attribute name="PoolName">Amstel1DB</attribute>
   <attribute name="URL">jdbc:sqlserver://localhost:1433</attribute>
   <attribute name="Properties">DatabaseName=Amstel1DB</attribute>
   <attribute name="JDBCUser">sa</attribute>
   <attribute name="Password">sa</attribute>
   <attribute name="MinSize">0</attribute>
   <attribute name="MaxSize">10</attribute>
   <attribute name="GCEnabled">false</attribute>
   <attribute name="GCMinIdleTime">1200000</attribute>
   <attribute name="GCInterval">120000</attribute>
   <attribute name="InvalidateOnError">false</attribute>
   <attribute name="TimestampUsed">false</attribute>
   <attribute name="Blocking">true</attribute>
   <attribute name="LoggingEnabled">true</attribute>
   <attribute name="IdleTimeoutEnabled">false</attribute>
   <attribute name="IdleTimeout">1800000</attribute>
   <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
  </mbean>
  -->

  <!-- Load only INet JDBC driver 
  <mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
     <attribute
name="Drivers">com.inet.tds.TdsDriver,org.hsql.jdbcDriver</attribute>
  </mbean>
  -->

  <!-- Connection Pool for INet JDBC driver 
  <mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=Amstel1DB">
   <attribute name="DataSourceClass">com.inet.tds.XDataSource</attribute>
   <attribute name="PoolName">Amstel1DB</attribute>
   <attribute name="Properties">host=localhost;
database=Amstel1DB</attribute>
   <attribute name="JDBCUser">sa</attribute>
   <attribute name="Password">sa</attribute>
   <attribute name="MinSize">0</attribute>
   <attribute name="MaxSize">10</attribute>
   <attribute name="GCEnabled">false</attribute>
   <attribute name="GCMinIdleTime">1200000</attribute>
   <attribute name="GCInterval">120000</attribute>
   <attribute name="InvalidateOnError">false</attribute>
   <attribute name="TimestampUsed">false</attribute>
   <attribute name="Blocking">true</attribute>
   <attribute name="LoggingEnabled">true</attribute>
   <attribute name="IdleTimeoutEnabled">false</attribute>
   <attribute name="IdleTimeout">1800000</attribute>
   <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
  </mbean>
  -->


Here is the log showing the error (using the Merant driver):

[Amstel1DB] Resource
'org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl@64160e' enlisted for
'org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f'.
[Amstel1DB] Pool Amstel1DB [1/1/10] gave out pooled object:
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f
[JAWS] findAllUnits command executing: SELECT id FROM UnitInfo
[Amstel1DB] Pool Amstel1DB [0/1/10] returned object
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f to the pool.
[UnitInfo] Activated bean UnitInfo with id =
com.cerulean.amstel1.UnitInfoPK@64
[Amstel1DB] Resource
'org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl@64160e' enlisted for
'org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f'.
[Amstel1DB] Pool Amstel1DB [1/1/10] gave out pooled object:
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f
[JAWS] Load command executing: SELECT
address,groupname,displayname,unitname,propstring,district,id FROM UnitInfo
WHERE id=?
[JAWS] java.sql.SQLException: Unable to create PreparedStatement!
[JAWS]  at
org.opentools.minerva.jdbc.xa.wrapper.XAClientConnection.prepareStatement(XA
ClientConnection.java:169)
[JAWS]  at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:158
)
[JAWS]  at
org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntity
Command.java:82)
...

Here is the complete log:
[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] Added
directory:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/tmp/
[Classpath extension] Added
directory:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/db/
[Classpath extension] Added
library:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/tomcat/lib/ant.jar
[Classpath extension] Added
library:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/tomcat/lib/jasper.jar
[Classpath extension] Added
library:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/tomcat/lib/jaxp.jar
[Classpath extension] Added
library:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/tomcat/lib/parser.jar
[Classpath extension] Added
library:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/tomcat/lib/servlet.jar
[Classpath extension] Added
library:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/tomcat/lib/webserver.jar
[Shutdown] Shutdown hook added
[Service Control] Registered with server
[Configuration] Port set to 8083 in DefaultDomain:service=Webserver
[Configuration] Port set to 1099 in DefaultDomain:service=Naming
[Configuration] TransactionTimeout set to 300 in
DefaultDomain:service=TransactionManager
[Configuration] SecurityManagerClassName set to
org.jboss.security.plugins.JaasSecurityManager in
Security:name=JaasSecurityManager
[Configuration] Drivers set to
com.merant.datadirect.jdbc.sqlserver.SQLServerDriver in
DefaultDomain:service=JdbcProvider
[Configuration] DataSourceClass set to
org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] PoolName set to Amstel1DB in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] URL set to jdbc:sqlserver://localhost:1433 in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] Properties set to DatabaseName=Amstel1DB in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] JDBCUser set to sa in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] Password set to sa in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] MinSize set to 0 in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] MaxSize set to 10 in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] GCEnabled set to false in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] GCMinIdleTime set to 1200000 in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] GCInterval set to 120000 in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] InvalidateOnError set to false in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] TimestampUsed set to false in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] Blocking set to true in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] LoggingEnabled set to true in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] IdleTimeoutEnabled set to false in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] IdleTimeout set to 1800000 in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] MaxIdleTimeoutPercent set to 1.0 in
DefaultDomain:service=XADataSource,name=Amstel1DB
[Configuration] VerifyDeployments set to true in :service=ContainerFactory
[Configuration] MetricsEnabled set to false in :service=ContainerFactory
[Configuration] VerifierVerbose set to true in :service=ContainerFactory
[Configuration] BeanCacheJMSMonitoringEnabled set to false in
:service=ContainerFactory
[Configuration] ProviderName set to DefaultJMSProvider in
:service=JMSProviderLoader,name=JBossMQProvider
[Configuration] ProviderAdapterClass set to
org.jboss.jms.jndi.JBossMQProvider in
:service=JMSProviderLoader,name=JBossMQProvider
[Configuration] PoolName set to StdJMSPool in
:service=ServerSessionPoolMBean,name=StdJMSPool
[Configuration] PoolFactoryClass set to
org.jboss.jms.asf.StdServerSessionPoolFactory in
:service=ServerSessionPoolMBean,name=StdJMSPool
[Configuration] DeployerName set to Default in J2EE:service=J2eeDeployer
[Configuration] JarDeployerName set to :service=ContainerFactory in
J2EE:service=J2eeDeployer
[Configuration] WarDeployerName set to :service=EmbeddedTomcat in
J2EE:service=J2eeDeployer
[Configuration] Deployer set to J2EE:service=J2eeDeployer in
EJB:service=AutoDeployer
[Configuration] URLs set to ../deploy in EJB:service=AutoDeployer
[Configuration] FactoryName set to MinervaNoTransCMFactory in
JCA:service=ConnectionManagerFactoryLoader,name=MinervaNoTransCMFactory
[Configuration] FactoryClass set to
org.opentools.minerva.connector.jboss.MinervaNoTransCMFactory in
JCA:service=ConnectionManagerFactoryLoader,name=MinervaNoTransCMFactory
[Configuration] FactoryName set to MinervaSharedLocalCMFactory in
JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
[Configuration] FactoryClass set to
org.opentools.minerva.connector.jboss.MinervaSharedLocalCMFactory in
JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
[Configuration] FactoryName set to MinervaXACMFactory in
JCA:service=ConnectionManagerFactoryLoader,name=MinervaXACMFactory
[Configuration] FactoryClass set to
org.opentools.minerva.connector.jboss.MinervaXACMFactory in
JCA:service=ConnectionManagerFactoryLoader,name=MinervaXACMFactory
[Configuration] MaxActiveClientCount set to 10 in Adaptor:name=html
[Configuration] Port set to 8082 in Adaptor:name=html
[Configuration] JNDIName set to Mail in :service=Mail
[Configuration] ConfigurationFile set to mail.properties in :service=Mail
[Configuration] User set to user_id in :service=Mail
[Configuration] Password set to password in :service=Mail
[Service Control] Initializing 22 MBeans
[Webserver] Initializing
[Webserver] Initialized
[Naming] Initializing
[Naming] Initialized
[JNDIView] Initializing
[JNDIView] Initialized
[Transaction manager] Initializing
[Transaction manager] Initialized
[JAAS Security Manager] Initializing
[JAAS Security Manager] Initialized
[JDBC provider] Initializing
[JDBC provider] Loaded
JDBC-driver:com.merant.datadirect.jdbc.sqlserver.SQLServerDriver
[JDBC provider] Initialized
[Amstel1DB] Initializing
[Amstel1DB] Initialized
[Container factory] Initializing
[Container factory] Initialized
[EmbeddedTomcat] Initializing
[EmbeddedTomcat] Initialized
[JBossMQ] Initializing
[JBossMQ] Initialized
[DefaultJMSProvider] Initializing
[DefaultJMSProvider] Initialized
[StdJMSPool] Initializing
[StdJMSPool] Initialized
[J2EE Deployer Default] Initializing
[J2EE Deployer Default] Initialized
[Auto deploy] Initializing
[Auto deploy] Initialized
[RARDeployer] Initializing
[RARDeployer] Found a temp directory left over from a previous run -
deleting it.
[RARDeployer] Initialized
[ConnectionManagerFactoryLoader] Initializing
[MinervaNoTransCMFactory] Initialized
[ConnectionManagerFactoryLoader] Initializing
[MinervaSharedLocalCMFactory] Initialized
[ConnectionManagerFactoryLoader] Initializing
[MinervaXACMFactory] Initialized
[JMX RMI Adaptor] Initializing
[JMX RMI Adaptor] Initialized
[JMX RMI Connector] Initializing
[JMX RMI Connector] Initialized
[Mail Service] Initializing
[Mail Service] Initialized
[Service Control] Initialized 22 services
[Service Control] Starting 22 MBeans
[Webserver] Starting
[Webserver] Codebase set to http://Timmy2:8083/
[Webserver] Started webserver on port 8083
[Webserver] Started
[Naming] Starting
[Naming] Naming started on port 1099
[Naming] Started
[JNDIView] Starting
[JNDIView] Started
[Transaction manager] Starting
[Transaction manager] Started
[JAAS Security Manager] Starting
[JAAS Security Manager] JAAS.startService, cachePolicy=null
[JAAS Security Manager] JAAS.startService,
SecurityProxyFactory=org.jboss.security.SubjectSecurityProxyFactory@849bc
[JAAS Security Manager] Started
[JDBC provider] Starting
[JDBC provider] Started
[Amstel1DB] Starting
[Amstel1DB] XA Connection pool Amstel1DB bound to java:/Amstel1DB
[Amstel1DB] org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl created
new Connection (com.merant.datadirect.jdbc.sqlserver.SQLServerConnection)
with XAResource org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl and
XAConnection org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl.
[Amstel1DB] No transaction right now.
[Amstel1DB] Pool Amstel1DB [0/0/10] gave out new object:
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f
[Amstel1DB] Pool Amstel1DB [0/1/10] returned object
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f to the pool.
[Amstel1DB] Started
[Container factory] Starting
[Container factory] Started
[EmbeddedTomcat] Starting
[EmbeddedTomcat] Starting EmbeddedTomcat....
[EmbeddedTomcat] Starting tomcat. Check logs/tomcat.log for error messages 
[EmbeddedTomcat] OK
[EmbeddedTomcat] Started
[JBossMQ] Starting
[JBossMQ] Server Version 0.8 Started
[JBossMQ] Started
[DefaultJMSProvider] Starting
[DefaultJMSProvider] JMS provider Adapter DefaultJMSProvider bound to
java:/DefaultJMSProvider
[DefaultJMSProvider] Started
[StdJMSPool] Starting
[StdJMSPool] JMS provider Adapter StdJMSPool bound to java:/StdJMSPool
[StdJMSPool] Started
[J2EE Deployer Default] Starting
[J2EE Deployer Default] Cleaning up deployment directory
[J2EE Deployer Default] Started
[Auto deploy] Starting
[Auto deploy] Watching C:\JBoss-2.2.1_Tomcat-3.2.1\jboss\deploy
[Auto deploy] Auto deploy of
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/deploy/tomcat-test.ear
[J2EE Deployer Default] Deploy J2EE application:
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/deploy/tomcat-test.ear
[J2EE Deployer Default] Create application tomcat-test.ear
[J2EE Deployer Default] inflate and install module tomcat-test.war
[J2EE Deployer Default] install module tomcat-test.jar
[J2EE Deployer Default] add all ejb jar files to the common classpath
[J2EE Deployer Default] Starting module tomcat-test.war
[Container factory]
Deploying:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/tmp/deploy/Default/tomcat-
test.ear
[Verifier] Verifying
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/tmp/deploy/Default/tomcat-test.ear/e
jb1002.jar
[Verifier] Optimized: Verified.
[Verifier] NonOptimized: Verified.
[Container factory] Deploying Optimized
[Container factory] Container Invoker RMI Port='Anonymous'
[Container factory] Container Invoker Client SocketFactory='Default'
[Container factory] Container Invoker Server SocketFactory='Default'
[Container factory] Container Invoker Optimize='true'
[Container factory] Deploying NonOptimized
[Container factory] Container Invoker RMI Port='Anonymous'
[Container factory] Container Invoker Client SocketFactory='Default'
[Container factory] Container Invoker Server SocketFactory='Default'
[Container factory] Container Invoker Optimize='false'
[Container factory] Mapped Container method remove HASH -1842617161
[Container factory] Mapped Container method getEJBHome HASH -993218923
[Container factory] Mapped Container method getHandle HASH 1182305581
[Container factory] Mapped Container method getPrimaryKey HASH -131865408
[Container factory] Mapped Container method isIdentical HASH 285457048
[Container factory] Mapped getMessage 2070904849to public java.lang.String
org.jboss.test.tomcat.ejb.bean.StatelessSessionBean.getMessage()
[Container factory] Mapping remove
[Container factory] Mapping remove
[Container factory] Mapping getEJBMetaData
[Container factory] Mapping getHomeHandle
[Container factory] Mapping create
[Container factory] JRMP 1.3 CI initialized
[Container factory] Mapped Container method remove HASH -1842617161
[Container factory] Mapped Container method getEJBHome HASH -993218923
[Container factory] Mapped Container method getHandle HASH 1182305581
[Container factory] Mapped Container method getPrimaryKey HASH -131865408
[Container factory] Mapped Container method isIdentical HASH 285457048
[Container factory] Mapped getMessage 2070904849to public java.lang.String
org.jboss.test.tomcat.ejb.bean.StatelessSessionBean.getMessage()
[Container factory] Mapping remove
[Container factory] Mapping remove
[Container factory] Mapping getEJBMetaData
[Container factory] Mapping getHomeHandle
[Container factory] Mapping create
[Container factory] JRMP 1.3 CI initialized
[Container factory] Bound NonOptimized to NonOptimized
[Container factory] Bound Optimized to Optimized
[Container factory] Deployed application:
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/tmp/deploy/Default/tomcat-test.ear
[J2EE Deployer Default] J2EE application:
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/deploy/tomcat-test.ear is deployed.
[Auto deploy] Auto deploy of
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/deploy/amstel.ear
[J2EE Deployer Default] Deploy J2EE application:
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/deploy/amstel.ear
[J2EE Deployer Default] Create application amstel.ear
[J2EE Deployer Default] inflate and install module web-war.war
[J2EE Deployer Default] added
jar:file:C:\JBoss-2.2.1_Tomcat-3.2.1\jboss\tmp\deploy\Default\copy1002.zip!/
ejb-client.jar to common classpath
[J2EE Deployer Default] install module ejb-jar.jar
[J2EE Deployer Default] add all ejb jar files to the common classpath
[J2EE Deployer Default] Starting module web-war.war
[Container factory]
Deploying:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/tmp/deploy/Default/amstel.
ear
[Verifier] Verifying
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/tmp/deploy/Default/amstel.ear/ejb100
4.jar
[Verifier] UnitInfo: Verified.
[Verifier] UserSession: Verified.
[Verifier] ActivateUnit: Verified.
[Verifier] ModifyUnit: Verified.
[Container factory] Deploying UnitInfo
[Container factory] Container Invoker RMI Port='4444'
[Container factory] Container Invoker Client SocketFactory='Default'
[Container factory] Container Invoker Server SocketFactory='Default'
[Container factory] Container Invoker Optimize='true'
[Container factory] Deploying UserSession
[Container factory] Container Invoker RMI Port='4444'
[Container factory] Container Invoker Client SocketFactory='Default'
[Container factory] Container Invoker Server SocketFactory='Default'
[Container factory] Container Invoker Optimize='true'
[Container factory] Deploying ActivateUnit
[Container factory] Container Invoker RMI Port='4444'
[Container factory] Container Invoker Client SocketFactory='Default'
[Container factory] Container Invoker Server SocketFactory='Default'
[Container factory] Container Invoker Optimize='true'
[Container factory] Deploying ModifyUnit
[Container factory] Container Invoker RMI Port='4444'
[Container factory] Container Invoker Client SocketFactory='Default'
[Container factory] Container Invoker Server SocketFactory='Default'
[Container factory] Container Invoker Optimize='true'
[Container factory] Mapped Container method remove HASH -1842617161
[Container factory] Mapped Container method getEJBHome HASH -993218923
[Container factory] Mapped Container method getHandle HASH 1182305581
[Container factory] Mapped Container method getPrimaryKey HASH -131865408
[Container factory] Mapped Container method isIdentical HASH 285457048
[Container factory] Mapped list 1747053952to public java.lang.String
com.cerulean.amstel1.ActivateUnitBean.list(java.lang.String)
[Container factory] Mapped activate -178746899to public java.lang.String
com.cerulean.amstel1.ActivateUnitBean.activate(java.lang.String) throws
javax.ejb.CreateException
[Container factory] Mapped deactivate -521630358to public java.lang.String
com.cerulean.amstel1.ActivateUnitBean.deactivate(java.lang.String) throws
javax.ejb.RemoveException,javax.ejb.FinderException
[Container factory] Mapping remove
[Container factory] Mapping remove
[Container factory] Mapping getEJBMetaData
[Container factory] Mapping getHomeHandle
[Container factory] Mapping create
[Container factory] JRMP 1.3 CI initialized
[Container factory] Mapped Container method remove HASH -1842617161
[Container factory] Mapped Container method getEJBHome HASH -993218923
[Container factory] Mapped Container method getHandle HASH 1182305581
[Container factory] Mapped Container method getPrimaryKey HASH -131865408
[Container factory] Mapped Container method isIdentical HASH 285457048
[Container factory] Mapped modify -1555274849to public java.lang.String
com.cerulean.amstel1.ModifyUnitBean.modify(java.lang.String) throws
javax.ejb.FinderException
[Container factory] Mapping remove
[Container factory] Mapping remove
[Container factory] Mapping getEJBMetaData
[Container factory] Mapping getHomeHandle
[Container factory] Mapping create
[Container factory] JRMP 1.3 CI initialized
[Container factory] JRMP 1.3 CI initialized
[JAWS] Initializing JAWS plugin for UserSession
[JAWS] Loading standardjaws.xml :
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/conf/default/standardjaws.xml
[JAWS]
jar:file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/tmp/deploy/Default/amstel.ear/ej
b1004.jar!/META-INF/jaws.xml found. Overriding defaults
[JAWS] Init SQL: CREATE TABLE UserSession (name VARCHAR(256),unitId
INTEGER,id INTEGER)
[JAWS] Destroy SQL: DROP TABLE UserSession
[JAWS] Exists SQL: SELECT COUNT(*) FROM UserSession WHERE id=?
[JAWS] Create SQL: INSERT INTO UserSession (name,unitId,id) VALUES (?,?,?)
[JAWS] Remove SQL: DELETE FROM UserSession WHERE id=?
[JAWS] Load SQL: SELECT name,unitId,id FROM UserSession WHERE id=?
[JAWS] Store SQL: UPDATE UserSession SET name=?,unitId=?,id=? WHERE id=?
[Amstel1DB] No transaction right now.
[Amstel1DB] Pool Amstel1DB [1/1/10] gave out pooled object:
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f
[Amstel1DB] Pool Amstel1DB [0/1/10] returned object
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f to the pool.
[JAWS] Table 'UserSession' already exists
[Container factory] JRMP 1.3 CI initialized
[JAWS] Initializing JAWS plugin for UnitInfo
[JAWS] Init SQL: CREATE TABLE UnitInfo (address VARCHAR(256),groupname
VARCHAR(256),displayname VARCHAR(256),unitname VARCHAR(256),propstring
VARCHAR(256),district VARCHAR(256),id INTEGER)
[JAWS] Destroy SQL: DROP TABLE UnitInfo
[JAWS] Exists SQL: SELECT COUNT(*) FROM UnitInfo WHERE id=?
[JAWS] findAllUnits SQL: SELECT id FROM UnitInfo
[JAWS] Create SQL: INSERT INTO UnitInfo
(address,groupname,displayname,unitname,propstring,district,id) VALUES
(?,?,?,?,?,?,?)
[JAWS] Remove SQL: DELETE FROM UnitInfo WHERE id=?
[JAWS] Load SQL: SELECT
address,groupname,displayname,unitname,propstring,district,id FROM UnitInfo
WHERE id=?
[JAWS] Store SQL: UPDATE UnitInfo SET
address=?,groupname=?,displayname=?,unitname=?,propstring=?,district=?,id=?
WHERE id=?
[Amstel1DB] No transaction right now.
[Amstel1DB] Pool Amstel1DB [1/1/10] gave out pooled object:
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f
[Amstel1DB] Pool Amstel1DB [0/1/10] returned object
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f to the pool.
[JAWS] Table 'UnitInfo' already exists
[Container factory] Bound ActivateUnit to ActivateUnitHome
[Container factory] Bound ModifyUnit to ModifyUnitHome
[Container factory] Bound UserSession to UserSessionHome
[Bean Cache] Cache policy scheduler started
[Container factory] Bound UnitInfo to UnitInfoHome
[Container factory] Deployed application:
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/tmp/deploy/Default/amstel.ear
[J2EE Deployer Default] J2EE application:
file:/C:/JBoss-2.2.1_Tomcat-3.2.1/jboss/deploy/amstel.ear is deployed.
[Auto deploy] Started
[RARDeployer] Starting
[RARDeployer] Started
[MinervaNoTransCMFactory] Starting
[MinervaNoTransCMFactory] Connection manager factory
'MinervaNoTransCMFactory bound to 'java:/MinervaNoTransCMFactory'
[MinervaNoTransCMFactory] Started
[MinervaSharedLocalCMFactory] Starting
[MinervaSharedLocalCMFactory] Connection manager factory
'MinervaSharedLocalCMFactory bound to 'java:/MinervaSharedLocalCMFactory'
[MinervaSharedLocalCMFactory] Started
[MinervaXACMFactory] Starting
[MinervaXACMFactory] Connection manager factory 'MinervaXACMFactory bound to
'java:/MinervaXACMFactory'
[MinervaXACMFactory] Started
[JMX RMI Adaptor] Starting
[JMX RMI Adaptor] Started
[JMX RMI Connector] Starting
[JMX RMI Connector] Started
[Mail Service] Starting
[Mail Service] DEBUG: not loading system providers in <java.home>/lib
[Mail Service] DEBUG: not loading optional custom providers file:
/META-INF/javamail.providers
[Mail Service] DEBUG: successfully loaded default providers
[Mail Service] 
DEBUG: Tables of loaded providers
[Mail Service] DEBUG: Providers Listed By Class Name:
{com.sun.mail.smtp.SMTPTransport=javax.mail.Provider[TRANSPORT,smtp,com.sun.
mail.smtp.SMTPTransport,Sun Microsystems, Inc],
com.sun.mail.imap.IMAPStore=javax.mail.Provider[STORE,imap,com.sun.mail.imap
.IMAPStore,Sun Microsystems, Inc],
com.sun.mail.pop3.POP3Store=javax.mail.Provider[STORE,pop3,com.sun.mail.pop3
.POP3Store,Sun Microsystems, Inc]}
[Mail Service] DEBUG: Providers Listed By Protocol:
{imap=javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun
Microsystems, Inc],
pop3=javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Sun
Microsystems, Inc],
smtp=javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Sun
Microsystems, Inc]}
[Mail Service] DEBUG: not loading optional address map file:
/META-INF/javamail.address.map
[Mail Service] Mail Service 'Mail' bound to java:/Mail
[Mail Service] Started
[Service Control] Started 22 services
[Default] JBoss 2.2.1 Started in 0m:6s
[Amstel1DB] Resource
'org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl@64160e' enlisted for
'org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f'.
[Amstel1DB] Pool Amstel1DB [1/1/10] gave out pooled object:
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f
[JAWS] findAllUnits command executing: SELECT id FROM UnitInfo
[Amstel1DB] Pool Amstel1DB [0/1/10] returned object
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f to the pool.
[UnitInfo] Activated bean UnitInfo with id =
com.cerulean.amstel1.UnitInfoPK@64
[Amstel1DB] Resource
'org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl@64160e' enlisted for
'org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f'.
[Amstel1DB] Pool Amstel1DB [1/1/10] gave out pooled object:
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f
[JAWS] Load command executing: SELECT
address,groupname,displayname,unitname,propstring,district,id FROM UnitInfo
WHERE id=?
[JAWS] java.sql.SQLException: Unable to create PreparedStatement!
[JAWS]  at
org.opentools.minerva.jdbc.xa.wrapper.XAClientConnection.prepareStatement(XA
ClientConnection.java:169)
[JAWS]  at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:158
)
[JAWS]  at
org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntity
Command.java:82)
[JAWS]  at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersistence
Manager.java:150)
[JAWS]  at
org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager
.java:341)
[JAWS]  at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchron
izationInterceptor.java:192)
[JAWS]  at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterce
ptor.java:186)
[JAWS]  at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[JAWS]  at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
[JAWS]  at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[JAWS]  at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:19
0)
[JAWS]  at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[JAWS]  at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:323)
[JAWS]  at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:482)
[JAWS]  at
org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.java:14
6)
[JAWS]  at $Proxy9.getUnitSessionId(Unknown Source)
[JAWS]  at
_0002fUnitInfoTestFind_0002ejspUnitInfoTestFind_jsp_5._jspService(_0002fUnit
InfoTestFind_0002ejspUnitInfoTestFind_jsp_5.java:176)
[JAWS]  at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
[JAWS]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS]  at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:177)
[JAWS]  at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
[JAWS]  at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
[JAWS]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS]  at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[JAWS]  at org.apache.tomcat.core.Handler.service(Handler.java:286)
[JAWS]  at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[JAWS]  at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
[JAWS]  at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
[JAWS]  at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:210)
[JAWS]  at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
[JAWS]  at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
[JAWS]  at java.lang.Thread.run(Thread.java:484)
[Amstel1DB] Pool Amstel1DB [0/1/10] returned object
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5e176f to the pool.
[UnitInfo] TRANSACTION ROLLBACK EXCEPTION:Load failed; nested exception is: 
        java.sql.SQLException: Unable to create PreparedStatement!; nested
exception is: 
        java.rmi.ServerException: Load failed; nested exception is: 
        java.sql.SQLException: Unable to create PreparedStatement!
[UnitInfo] java.rmi.ServerException: Load failed; nested exception is: 
[UnitInfo]      java.sql.SQLException: Unable to create PreparedStatement!
[UnitInfo] java.sql.SQLException: Unable to create PreparedStatement!
[UnitInfo]      at
org.opentools.minerva.jdbc.xa.wrapper.XAClientConnection.prepareStatement(XA
ClientConnection.java:169)
[UnitInfo]      at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:158
)
[UnitInfo]      at
org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntity
Command.java:82)
[UnitInfo]      at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersistence
Manager.java:150)
[UnitInfo]      at
org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager
.java:341)
[UnitInfo]      at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchron
izationInterceptor.java:192)
[UnitInfo]      at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterce
ptor.java:186)
[UnitInfo]      at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[UnitInfo]      at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
[UnitInfo]      at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[UnitInfo]      at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:19
0)
[UnitInfo]      at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[UnitInfo]      at
org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:323)
[UnitInfo]      at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:482)
[UnitInfo]      at
org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.java:14
6)
[UnitInfo]      at $Proxy9.getUnitSessionId(Unknown Source)
[UnitInfo]      at
_0002fUnitInfoTestFind_0002ejspUnitInfoTestFind_jsp_5._jspService(_0002fUnit
InfoTestFind_0002ejspUnitInfoTestFind_jsp_5.java:176)
[UnitInfo]      at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
[UnitInfo]      at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[UnitInfo]      at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:177)
[UnitInfo]      at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
[UnitInfo]      at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
[UnitInfo]      at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[UnitInfo]      at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[UnitInfo]      at org.apache.tomcat.core.Handler.service(Handler.java:286)
[UnitInfo]      at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[UnitInfo]      at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
[UnitInfo]      at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
[UnitInfo]      at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:210)
[UnitInfo]      at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
[UnitInfo]      at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
[UnitInfo]      at java.lang.Thread.run(Thread.java:484)

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to