Rich Knight

Thanks a lot Jamie and prabhat, it works! Hind sight is 20/20 but I can't believe I went on that wild goose chase! Yall have been a huge help. As I get more into java I hope that I can be as much of a help to others. Thanks again!

Jamie,
Yes, it was my initial thought to just use Statement, however I got an "Invalid column name" exception when I tried to access the returned value via the "<%=rs.getString("id")%>" expression below (commenting it out removes the error, but of course that renders the page useless). I'll give your suggestions a try. Thanks.
<% String strQuery = "SELECT myFunc(id) FROM users WHERE upper(login_name) = upper('joe')"; Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(strQuery); %> <%=rs.getString("id")%> // invalid column name exception thrown here
[ February 21, 2002: Message edited by: Rich Knight ]

Thanks a lot. I follow you, and see my mistakes. I now realize that I didn't pose my initial question accurately. 'myFunc' is a function that decrypts an ID. So when I pass it in 'joe' it decrypts Joe's ID and returns that value. What I'm confused about is how to build my statement incorporating the query, ie., how to tell 'myFunc' what table 'joe' resides ('users') in and what field ('id') of joe's record to decrypt. Does that make sense, or am I just totally missing it?
Thanks for your patience, here's the code for the function in question if it would help matters.
function myFunc(v_in in varchar2) RETURN varchar2 AS p_name varchar2(100) := 'MYFUNC ::> '; l_in varchar2(2048); l_out varchar2(2048); l_byte_size number; l_new_byte_size number; -- raw_input RAW(128) := UTL_RAW.CAST_TO_RAW(l_in); key_string VARCHAR2(16) := 'scrambledata1234'; raw_key RAW(128) := UTL_RAW.CAST_TO_RAW(key_string); encrypted_raw RAW(2048); encrypted_string VARCHAR2(2048); decrypted_raw RAW(2048); decrypted_string VARCHAR2(2048); error_in_input_buffer_length EXCEPTION; PRAGMA EXCEPTION_INIT(error_in_input_buffer_length, -28232); INPUT_BUFFER_LENGTH_ERR_MSG VARCHAR2(100) := '*** DES INPUT BUFFER NOT A MULTIPLE OF 8 BYTES - IGNORING EXCEPTION ***'; double_encrypt_not_permitted EXCEPTION; PRAGMA EXCEPTION_INIT(double_encrypt_not_permitted, -28233); DOUBLE_ENCRYPTION_ERR_MSG VARCHAR2(100) := '*** CANNOT DOUBLE ENCRYPT DATA - IGNORING EXCEPTION ***'; -- BEGIN -- BEGIN -- If v_in is null Then l_out := null; Return l_out; End If; -- l_in := v_in; /* dbms_output.enable; dbms_output.put_line('Input String : '||l_in); */ -- dbms_obfuscation_toolkit.DESDecrypt(input_string => l_in, key_string => key_string, decrypted_string => decrypted_string); -- l_out := decrypted_string; -- /* dbms_output.put_line('Successfully Decrypted!'); dbms_output.put_line('Output String : '||l_out); */ -- EXCEPTION WHEN others THEN l_out := to_char(sqlcode)||'::'||sqlerrm; dbms_output.put_line(p_name||' '||l_out); END; -- Return rtrim(l_out); -- END UnScramble;

Giving things a try, I tried the following code and it returned a "null" value for "returnVal". Am I in the ballpark? Thanks.
CallableStatement funcnone = con.prepareCall("SELECT myFunc(?) FROM users where upper(login) = upper('joe')"); // register the in and out parameters funcnone.setString(1, "id"); funcnone.registerOutParameter (2, Types.VARCHAR); // execute the procedure funcnone.execute (); // get the return values String returnVal = funcnone.getString(2);

Thanks for your replies.
prabhat,
Thanks for posting the code. If I have to call a function with parameters I use the setXXX(), correct? However, I don't see where I place my actual SQL query. I'm new to SQL so forgive me if it's obvious.

Hello,
I need to run the following query in my JSP:
SELECT myFunc(id) FROM users WHERE login = 'joe'
Where myFunc is a function stored in my Oracle database. When I execute the query in Toad, it provides the expected results. The Java API says to use CallableStatement, however, I'm totally confused on how to use it, if it is indeed the answer. CallableStatement seems to be for stored procs and not for stored functions? Any help would be appreciated, this is the last piece of my app and it's due tomorrow.
Thanks,
RK
[ February 20, 2002: Message edited by: Rich Knight ]

I'm able to boot up fine now, but when I try to login to my JSP I get the following error generated in my log file. The error is only generated if the user actually exists in the database, so I'm sure I'm connecting and accessing the info. Thanks :
JDBCRealm[/myApp]: Exception performing authentication java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:829) at oracle.jdbc.dbaccess.DBConversion.failUTF8Conv(DBConversion.java:1746) at oracle.jdbc.dbaccess.DBConversion.utf8BytesToJavaChars(DBConversion.java:1585) at oracle.jdbc.dbaccess.DBConversion.utf8BytesToString(DBConversion.java:1445) at oracle.jdbc.dbaccess.DBConversion.CharBytesToString(DBConversion.java:384) at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:2571) at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:305) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:379) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:326) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:263) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107) at java.lang.Thread.run(Thread.java:484)
[ February 20, 2002: Message edited by: Rich Knight ]

Thanks for the reply,
Yes I am using classes12.zip, and I renamed it to .rar. Same results .

Hi,
I'm trying to use Tomcat 4's JDBCRealm to authenticate users. When I ran
tests with mySQL, everything went fine. However now that I need to move the
JSP application to production I have to connect to an Oracle 8i database. I
set everthing up the same way by editing the server.xml file, but now Tomcat
won't start. I even tested getting the connection and accessing the
database in one of my jsp's and it works fine, so I don't believe it's the
connectionURL. It gives me the error that I pasted below. Please help,
this unforseen dip has placed me behind schedule at work.
Code added to server.xml (worked fine using mySQL):
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc :-o racle:thin:test/test@lumbar:1521:testDB?user=test;passw ord=test" userTable="users" userNameCol="login" userCredCol="pass" userRoleTable="roles" roleNameCol="admin" />
Error when I attempt to launch Tomcat:
Catalina.start: LifecycleException: Exception opening database connection: jav a.sql.SQLException: oracle.jdbc.driver.OracleDriver LifecycleException: Exception opening database connection: java.sql.SQLExcepti on: oracle.jdbc.driver.OracleDriver at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3 345) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.start(StandardHost.java:614) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343 ) at org.apache.catalina.core.StandardService.start(StandardService.java:3 88) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) ----- Root Cause ----- java.sql.SQLException: oracle.jdbc.driver.OracleDriver at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3 345) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.start(StandardHost.java:614) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343 ) at org.apache.catalina.core.StandardService.start(StandardService.java:3 88) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)

Hi,
I'm trying to use Tomcat 4's JDBCRealm to authenticate users. When I ran
tests with mySQL, everything went fine. However now that I need to move the
JSP application to production I have to connect to an Oracle 8i database. I
set everthing up the same way by editing the server.xml file, but now Tomcat
won't start. I even tested getting the connection and accessing the
database in one of my jsp's and it works fine, so I don't believe it's the
connectionURL. It gives me the error that I pasted below. Please help,
this unforseen dip has placed me behind schedule at work.
Code added to server.xml (worked fine using mySQL):
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc :-o racle:thin:test/test@lumbar:1521:testDB?user=test;passw ord=test" userTable="users" userNameCol="login" userCredCol="pass" userRoleTable="roles" roleNameCol="admin" />
Error when I attempt to launch Tomcat:
Catalina.start: LifecycleException: Exception opening database connection: jav a.sql.SQLException: oracle.jdbc.driver.OracleDriver LifecycleException: Exception opening database connection: java.sql.SQLExcepti on: oracle.jdbc.driver.OracleDriver at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3 345) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.start(StandardHost.java:614) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343 ) at org.apache.catalina.core.StandardService.start(StandardService.java:3 88) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) ----- Root Cause ----- java.sql.SQLException: oracle.jdbc.driver.OracleDriver at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3 345) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.start(StandardHost.java:614) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343 ) at org.apache.catalina.core.StandardService.start(StandardService.java:3 88) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)

Hi,
I'm trying to use Tomcat 4's JDBCRealm to authenticate users. When I ran tests with mySQL, everything went fine. However now that I need to move the JSP application to production I have to connect to an Oracle 8i database. I set everthing up the same way by editing the server.xml file, but now Tomcat won't start. I even tested getting the connection and accessing the database in one of my jsp's and it works fine, so I don't believe it's the connectionURL. It gives me the error that I pasted below. Please help, this unforseen dip has placed me behind schedule at work.
Code added to server.xml (worked fine using mySQL):
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc :-o racle:thin:test/test@server:1521:testDB?user=test;password=test" userTable="users" userNameCol="login" userCredCol="pass" userRoleTable="roles" roleNameCol="admin" />
Error when I attempt to launch Tomcat:
Catalina.start: LifecycleException: Exception opening database connection: jav a.sql.SQLException: oracle.jdbc.driver.OracleDriver LifecycleException: Exception opening database connection: java.sql.SQLExcepti on: oracle.jdbc.driver.OracleDriver at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3 345) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.start(StandardHost.java:614) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343 ) at org.apache.catalina.core.StandardService.start(StandardService.java:3 88) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) ----- Root Cause ----- java.sql.SQLException: oracle.jdbc.driver.OracleDriver at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3 345) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.start(StandardHost.java:614) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343 ) at org.apache.catalina.core.StandardService.start(StandardService.java:3 88) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
[ February 20, 2002: Message edited by: Rich Knight ]

Thanks,
I just compared the session time to the current time and it produced the required results.
RK

Hi,
I know that you can set in the web.xml the session time-out. However, it refers to idle-time. Is there a way to set the session to be a set amount of time, for example give someone10 min to answer a quiz?
Thanks,
RK

Hi,
I'm attempting a simple Form-Based login to authenticate a user and give access to my site. I authenticate their username and password against a database and based on the role they have (also stored in the database) I grant them access. I'm using Tomcat 4's JDBCRealm to authenticate.
Unfortunately my results are very inconsistent. Sometimes I'm able to login and sometimes I get 404(Resourse not found) errors. In the address bar I notice it reads: "<myApp>/j_security_check" when it should be forwarding it to "<myApp>/index.jsp". Also I sometimes get a 401 (Invalid Redirect) error. Below is the relevant code to my login page, taken straight from tutorials. Any help would be appreciated.
Thanks
RK
Login Page <form method="POST" action="j_security_check"> Username: <input type="text" name="j_username"> Password: <input type="password" name="j_password"> <input type="submit">