Dear Friends,
This is not specific to jsp, still i proceed. I have to run a java class from a oracle
function. i am not able to use loadjava properly as it gives
********************
code of the class is as follows
*************************
/*
* Encrypt.java
*
* Created on March 7, 2001, 1:46 PM
*/
//package mumbai;
/**
*
* @author administrator
* @version
*/
public class Encrypt_1{
private String userId;
private String userPassword;
private String encryptedPassword;
/** Creates new Class */
public Encrypt_1() {
}
public String EncryptFunction(String userId, String userPassword){
this.userId = userId;
this.userPassword = userPassword;
int i = userId.hashCode();
int j = userPassword.hashCode();
return String.valueOf(3*i + 2*j);
}
public String EncryptPassword(){
int i = userPassword.hashCode();
return String.valueOf(i);
}
public String EncryptUserId(){
int i = userId.hashCode();
return String.valueOf(i);
}
}
*************************
after compiling the same and placing the class file in digital unix,
on the digital unix editor loadjava command was as follows
*********************************************
loadjava -oci8 -user mumbai/mumbai123@bombay Encrypt_1.class
Error while retrieving errors for mumbai/Encrypt_1
ORA-00904: invalid column name
*******************
and the oracle function is
*******************************
CREATE OR REPLACE function passEncryp
(
user in varchar2,
password in varchar2
)
return number
is LANGUAGE java
name 'Encrypt_1.EncryptFunction(java.lang.String,java.lang.String) return int';
*******************************
I hope my question is relevant. After many searches and other efforts i am unable to
do so. Some problem of classpath which i could not resolve.
hoping to hear soon on the same.
regards,
piyush.
_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
