Re: [JBoss-user] Call an EJB from an Oracle Java Stored Procedure

2003-06-09 Thread Stefano Maestri 
On Saturday 07 June 2003 01:20, Nicholas wrote:
 Stefano;


 The keys are the following:

 1. Defer resolution until the second pass. (set
 resolve=on)

Already done.

 2. Recompile all classes when you are done. You can
 generate a script to do this as follows:

 select 'ALTER JAVA CLASS USER NAME.' || object_name

 || ' COMPILE;' from ALL_OBJECTS where object_type in

 ('JAVA CLASS', 'JAVA SOURCE') and OWNER = 'USER
 NAME'

nothing changed. Class not compiled (resolved) in loading don't compile also 
after loading.


 Anyways, email me off line and I'll send you the Ant
 tasks, examples and doc.

Yes please. In particular some example.


 //Nicholas


Thanks a lot

-- 
--- all work and no play makes Jack a dull boy --- 
bye Stefano 
[EMAIL PROTECTED]
www.javalinux.it
MSN messanger: [EMAIL PROTECTED] 
ICQ uin: 122192578
Jabber: canezen
Yahoo MSN: canezen
#jedit IRC channel as maeste 


---
This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
thread debugger on the planet. Designed with thread debugging features
you've never dreamed of, try TotalView 6 free at www.etnus.com.
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] Call an EJB from an Oracle Java Stored Procedure

2003-06-07 Thread Guy Rouillier 
Nicholas and Stephano, I've tried to get this working numerous times in 
the past, but I'm still not there.  You can find my previous posts on 
this by searching the archives.

Nicholas, I can load the JBoss classes into the Oracle JVM using 
loadjava.  But whenever I try to run the simplest EJB invocation, I get 
all kinds of errors.  Have you successfully invoked a method on an EJB 
running under JBoss from within an Oracle stored procedure?  If so, I 
would very much like details on how you did this.  Would make a great 
HOWTO for this group.  Thanks.

Nicholas wrote:
Stefano;

I have had some luck loading classes using a custom
Ant task.  It is really just a wrapper for LoadJava
but easier to use if you are Ant inclined. It looks
like this:
patternset id=oracle.load.classes
include name=jbossall-client.jar/
/patternset
target name=LoadJBossToOracle
OracleLoadJava oci=on user=SCOTT/[EMAIL PROTECTED]
resolve=on debug=on force=on noverify=on
verbose=on noserverside=on schema=scott
synonym=on time=on
fileset dir=C:/jboss-3.2.0_tomcat-4.1.24/client
patternset refid=oracle.load.classes/
/fileset
grant name=scott/
/OracleLoadJava 
/target
The keys are the following:

1. Defer resolution until the second pass. (set
resolve=on)
2. Recompile all classes when you are done. You can
generate a script to do this as follows:
select 'ALTER JAVA CLASS USER NAME.' || object_name
|| ' COMPILE;' from ALL_OBJECTS where object_type in
('JAVA CLASS', 'JAVA SOURCE') and OWNER = 'USER
NAME'
Run the output as a SQL script. It will take quite a
long time...
Anyways, email me off line and I'll send you the Ant
tasks, examples and doc.
//Nicholas

--- Stefano Maestri [EMAIL PROTECTED]
wrote:
We are trying to write a java Stored procedure for
oracle that call a session 
bean. We are experiencing some troble because when
we set the InitialContext 
we get an error because
org.jnp.interfaces.NamingContextFactory is not 
present in Aurora. We tryied to load it (extracted
from jbossall-client.jar), 
but Oracle failed to resolve that class. We tryied
also to load all 
jbossall-client.jar with a lot of resolving error.
Ideas? Domeone had already did something like that.
We are using Jboss-3.2.1 
for the bean (and for the jabossall-client.jar) and
Oracle 9.2 on HP-UX for 
the DB.
Thanks a lot for the attention.

P.S.: We had not also javax.ejb in Aurora, but it
load correctly.
--
--- all work and no play makes Jack a
dull boy --- 
bye Stefano 
	[EMAIL PROTECTED]
	www.javalinux.it
   	MSN messanger: [EMAIL PROTECTED] 
   	ICQ uin: 122192578
   	Jabber: canezen
	Yahoo MSN: canezen
   	#jedit IRC channel as maeste 



---

This SF.net email is sponsored by:  Etnus, makers of
TotalView, The best
thread debugger on the planet. Designed with thread
debugging features
you've never dreamed of, try TotalView 6 free at
www.etnus.com.
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

=
Nicholas Whitehead
Home: (973) 377 9335
Cell: (201) 615 2716
[EMAIL PROTECTED]
Get Your News From The Crowbar: http://crowbar.dnsalias.com:443/crowbar/
---
This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
thread debugger on the planet. Designed with thread debugging features
you've never dreamed of, try TotalView 6 free at www.etnus.com.
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


--
Guy Rouillier


---
This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
thread debugger on the planet. Designed with thread debugging features
you've never dreamed of, try TotalView 6 free at www.etnus.com.
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

[JBoss-user] Call an EJB from an Oracle Java Stored Procedure

2003-06-06 Thread Stefano Maestri 
We are trying to write a java Stored procedure for oracle that call a session 
bean. We are experiencing some troble because when we set the InitialContext 
we get an error because org.jnp.interfaces.NamingContextFactory is not 
present in Aurora. We tryied to load it (extracted from jbossall-client.jar), 
but Oracle failed to resolve that class. We tryied also to load all 
jbossall-client.jar with a lot of resolving error.
Ideas? Domeone had already did something like that. We are using Jboss-3.2.1 
for the bean (and for the jabossall-client.jar) and Oracle 9.2 on HP-UX for 
the DB.
Thanks a lot for the attention.

P.S.: We had not also javax.ejb in Aurora, but it load correctly.

-- 
--- all work and no play makes Jack a dull boy --- 
bye Stefano 
[EMAIL PROTECTED]
www.javalinux.it
MSN messanger: [EMAIL PROTECTED] 
ICQ uin: 122192578
Jabber: canezen
Yahoo MSN: canezen
#jedit IRC channel as maeste 


---
This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
thread debugger on the planet. Designed with thread debugging features
you've never dreamed of, try TotalView 6 free at www.etnus.com.
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] Call an EJB from an Oracle Java Stored Procedure

2003-06-06 Thread Nicholas 
Stefano;

I have had some luck loading classes using a custom
Ant task.  It is really just a wrapper for LoadJava
but easier to use if you are Ant inclined. It looks
like this:
patternset id=oracle.load.classes
include name=jbossall-client.jar/
/patternset
target name=LoadJBossToOracle
OracleLoadJava oci=on user=SCOTT/[EMAIL PROTECTED]
resolve=on debug=on force=on noverify=on
verbose=on noserverside=on schema=scott
synonym=on time=on
fileset dir=C:/jboss-3.2.0_tomcat-4.1.24/client
patternset refid=oracle.load.classes/
/fileset
grant name=scott/
/OracleLoadJava   
/target

The keys are the following:

1. Defer resolution until the second pass. (set
resolve=on)
2. Recompile all classes when you are done. You can
generate a script to do this as follows:

select 'ALTER JAVA CLASS USER NAME.' || object_name
|| ' COMPILE;' from ALL_OBJECTS where object_type in
('JAVA CLASS', 'JAVA SOURCE') and OWNER = 'USER
NAME'

Run the output as a SQL script. It will take quite a
long time...

Anyways, email me off line and I'll send you the Ant
tasks, examples and doc.

//Nicholas


--- Stefano Maestri [EMAIL PROTECTED]
wrote:
 We are trying to write a java Stored procedure for
 oracle that call a session 
 bean. We are experiencing some troble because when
 we set the InitialContext 
 we get an error because
 org.jnp.interfaces.NamingContextFactory is not 
 present in Aurora. We tryied to load it (extracted
 from jbossall-client.jar), 
 but Oracle failed to resolve that class. We tryied
 also to load all 
 jbossall-client.jar with a lot of resolving error.
 Ideas? Domeone had already did something like that.
 We are using Jboss-3.2.1 
 for the bean (and for the jabossall-client.jar) and
 Oracle 9.2 on HP-UX for 
 the DB.
 Thanks a lot for the attention.
 
 P.S.: We had not also javax.ejb in Aurora, but it
 load correctly.
 
 -- 
 --- all work and no play makes Jack a
 dull boy --- 
 bye Stefano 
   [EMAIL PROTECTED]
   www.javalinux.it
   MSN messanger: [EMAIL PROTECTED] 
   ICQ uin: 122192578
   Jabber: canezen
   Yahoo MSN: canezen
   #jedit IRC channel as maeste 
 
 

---
 This SF.net email is sponsored by:  Etnus, makers of
 TotalView, The best
 thread debugger on the planet. Designed with thread
 debugging features
 you've never dreamed of, try TotalView 6 free at
 www.etnus.com.
 ___
 JBoss-user mailing list
 [EMAIL PROTECTED]

https://lists.sourceforge.net/lists/listinfo/jboss-user


=
Nicholas Whitehead
Home: (973) 377 9335
Cell: (201) 615 2716
[EMAIL PROTECTED]
Get Your News From The Crowbar: http://crowbar.dnsalias.com:443/crowbar/


---
This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
thread debugger on the planet. Designed with thread debugging features
you've never dreamed of, try TotalView 6 free at www.etnus.com.
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user