Hi all,
I am using jrun4 , and trying to connect to oracle database. macromedia_drivers.jar is
in the classpath. what can be the reason for the Exception. I am able to connect to
the oracle server using datadirect connect jdbc driver directly. i am failing to
connect when i use the macro media driver. please help.
Thanks in advance
Ganti Sreenivas
<%
try{
Class.forName("macromedia.jdbc.oracle.OracleDriver");
Connection
con=DriverManager.getConnection("jdbc:macromedia:oracle://servername:1521","user","pass"
);
out.println(con);
}catch(Exception exp){exp.printStackTrace();
byte b[]=null;
try{
java.io.ByteArrayOutputStream bos=new java.io.ByteArrayOutputStream();
java.io.PrintStream pr=new java.io.PrintStream(bos);
exp.printStackTrace(pr);
b=bos.toByteArray();
}catch(Exception exp1){}
String s=new String(b);
out.println(exp.getMessage() + s );}
%>
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-02248: invalid
option for ALTER SESSION
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.oracle.OracleImplConnection.open(Unknown Source)
at macromedia.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at macromedia.jdbc.base.BaseConnection.open(Unknown Source)
at macromedia.jdbc.base.BaseDriver.connect(Unknown Source)
at macromedia.jdbc.MacromediaDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:523)
at java.sql.DriverManager.getConnection(DriverManager.java:183)
at jrun__test2ejsp9._jspService(jrun__test2ejsp9.java:59)
at jrun.jsp.runtime.HttpJSPServlet.service(HttpJSPServlet.java:43)
at jrun.jsp.JSPServlet.service(JSPServlet.java:106)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=8
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=8
Get the JRun Web Application Construction Kit - the only book written specifically for
JRun developers.
http://www.amazon.com/exec/obidos/ASIN/0789726009/houseoffusion
