You are right!
I replace on:
//Properties env= (Properties)context.lookup( "java:comp/env");
creation= (String)context.lookup( "java:comp/env/createCalcSQL");
deletion= (String)context.lookup( "java:comp/env/deleteCalcSQL");
And all works fine I think...
But how about my Oracle connection? I've got following exception after find
invocation:
java.rmi.ServerException: RemoteException occurred in server thread; nested
exception is:
java.rmi.ServerException: exception occured while invoking finder method;
nested exception is:
javax.ejb.EJBException: Table not found: CALC in statement [select kf_a
from calc where zaka='test1']--this statement from environment all works
fine.
java.rmi.ServerException: exception occured while invoking finder method;
nested exception is:
javax.ejb.EJBException: Table not found: CALC in statement [select kf_a
from calc where zaka='test1']
javax.ejb.EJBException: Table not found: CALC in statement [select kf_a from
calc where zaka='test1']
at
sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteC
all.java:245)
at
sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:220)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:122)
at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker_Stub.invokeHome(Unkno
wn Source)
at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:221)
at $Proxy0.findByPrimaryKey(Unknown Source)
at a.main(a.java:14)
Exception in thread "main"
This means that Hypersonic DB used in place of Oracle and console show
that:
[Console logging] Logging started
[Classpath] Added directory:file:/C:/jboss/log/
[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/activation.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/awt.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/classes12.zip
[Classpath] Added library:file:/C:/jboss/lib/ext/dynaserver.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/ejb.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/ejxeditor.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/ejxejb.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/hsql.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/idb.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/jboss.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/jdbc2_0-stdext.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/jmxtools.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/jndi.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/jnpserver.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/jpl-util-0_5b.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/jta-spec1_0_1.jar
[Classpath] Added library:file:/C:/jboss/lib/ext/mail.jar
[JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
[JDBC] Loaded JDBC-driver:jdbc.idbDriver
[JDBC] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver
[Webserver] Initializing
[Webserver] Initialized
[Hypersonic] Initializing
[Hypersonic] Server 1.4 is running
[Hypersonic] Database started
[Hypersonic] 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
[DataSource] Initializing
[DataSource] Connection pool for jdbc:oracle:oci8:@SCDB bound to
SCentre--------------------- My datasource
[DataSource] Initialized
[DataSource] Initializing
[DataSource] Connection pool for jdbc:idb:../conf/instantdb.properties bound
to
InstantDB
InstantDB - Version 3.12
[DataSource] Copyright (c) 1997-1999 Instant Computer Solutions Ltd.
[DataSource] Initialized
[XADataSource] Initializing
[XADataSource] Initialized
[Container factory] Initializing
[Container factory] Temporary directory set to:C:\jboss\tmp\deploy
[Container factory] Initialized
[Auto deploy] Auto-deploying 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
[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=ML
et
[Configuration] URL set to jdbc:HypersonicSQL:hsql://localhost in
DefaultDomain:
service=XADataSource,name=Hypersonic
[Configuration] JDBCUser set to sa in
DefaultDomain:service=XADataSource,name=Hy
personic
[Configuration] MaxSize set to 0 in
DefaultDomain:service=XADataSource,name=Hype
rsonic
[Configuration] ShrinkPercent set to 0.33 in
DefaultDomain:service=XADataSource,
name=Hypersonic
[Configuration] GCEnabled set to false in
DefaultDomain:service=XADataSource,nam
e=Hypersonic
[Configuration] TimestampUsed set to false in
DefaultDomain:service=XADataSource
,name=Hypersonic
[Configuration] Blocking set to false in
DefaultDomain:service=XADataSource,name
=Hypersonic
[Configuration] GCMinIdleTime set to 1200000 in
DefaultDomain:service=XADataSour
ce,name=Hypersonic
[Configuration] InvalidateOnError set to false in
DefaultDomain:service=XADataSo
urce,name=Hypersonic
[Configuration] MinSize set to 0 in
DefaultDomain:service=XADataSource,name=Hype
rsonic
[Configuration] ShrinkMinIdleTime set to 600000 in
DefaultDomain:service=XADataS
ource,name=Hypersonic
[Configuration] ShrinkingEnabled set to false in
DefaultDomain:service=XADataSou
rce,name=Hypersonic
[Configuration] Format set to [{2}] {4} in
DefaultDomain:service=Logging,type=Co
nsole
[Configuration] Port set to 8083 in DefaultDomain:service=Webserver
[Configuration] VerifyDeployments set to true in
EJB:service=ContainerFactory
[Naming] Starting
[Naming] Started
[Hypersonic] Starting
[Hypersonic] Started
[DataSource] Starting
[DataSource] Started
[DataSource] Starting
[DataSource] Started
[Transaction manager] Starting
[Transaction manager] Started
[XADataSource] Starting
[XADataSource] XA Connection pool Hypersonic bound to Hypersonic
[XADataSource] Started
[Container factory] Starting
[Container factory] Started
[Auto deployer] Starting
[Auto deploy] Auto deploy of file:/C:/jboss/deploy/
[Container factory] Deploying:file:/C:/jboss/deploy/
[Container factory] Loading ejb-jar.xml :
file:/C:/jboss/deploy/META-INF/ejb-jar
.xml
[Container factory] Loading standardjboss.xml :
jar:file:/C:/jboss/lib/ext/jboss
.jar!/org/jboss/metadata/standardjboss.xml
[Container factory] file:/C:/jboss/deploy/META-INF/jboss.xml found.
Overriding d
efaults
[Verifier] Verifying file:/C:/jboss/deploy/
[Verifier] CalculationBean: Verified.
[Container factory] Deploying CalculationBean
[Container factory] Container Invoker Optimize='false'
[Container factory] java.lang.ClassNotFoundException: class
org.jboss.security.E
JBSecurityManagerDefaultImpl
[Container factory] Using default
DataSource:Hypersonic-------------------------------Why? I was asking for
Oracle...
[Container factory] Bound CalculationBean to CalculationBean
[Container factory] Deployed application: file:/C:/jboss/deploy/
[Auto deployer] Started
[Security manager] Starting
[Security manager] Started
[Simple Realm Mapping] Starting
[Simple Realm Mapping] Started
[Webserver] Starting
[Webserver] Codebase set to http://localhost: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] 18 services and 4 other MBeans started.
[Default] Shutdown hook added
[Default] jBoss 2.0 BETA-PROD-01 Started
-----------------------------------------------------------------
in jboss.conf:
<MLET CODE = "org.jboss.jdbc.DataSourceImpl"
ARCHIVE="jboss.jar,classes12.jar" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="jdbc:oracle:oci8:@SCDB">
<ARG TYPE="java.lang.String" VALUE="SCentre">
<ARG TYPE="java.lang.String" VALUE="oracle.jdbc.driver.OracleDriver">
<ARG TYPE="java.lang.String" VALUE="scott">
<ARG TYPE="java.lang.String" VALUE="Escorial">
</MLET>
in jboss.xml:
<resource-managers>
<resource-manager res-class="org.jboss.ejb.deployment.JDBCResource">
<res-name>SCTest</res-name>
<res-jndi-name>SCentre</res-jndi-name>
</resource-manager>
</resource-managers>
in ejb-jar.xml:
<resource-ref>
<description>A jdbc connection for the BMP
bean</description>
<res-ref-name>jdbc/SC1</res-ref-name>
<resource-name>SCTest</resource-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Thnk you.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
