[dear_hari]

while running my already configured project with MyEclipse , it is giving error like

HTTP Status 500 –

exception

javax.servlet.ServletException: Servlet.init() for servlet IPCLoginServlet threw exception
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
java.lang.Thread.run(Thread.java:534)

root cause

java.lang.UnsatisfiedLinkError: no ocijdbc8 in java.library.path
java.lang.ClassLoader.loadLibrary(ClassLoader.java:1517)
java.lang.Runtime.loadLibrary0(Runtime.java:788)
java.lang.System.loadLibrary(System.java:834)
oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:228)
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:249)
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
com.roguewave.jdbtools.v2_0.jdbc.JDBCConnectionHandle.open(JDBCConnectionHandle.java:115)
com.roguewave.jdbtools.v2_0.jdbc.JDBCConnectionImpl.open_(JDBCConnectionImpl.java:45)
com.roguewave.jdbtools.v2_0.impl.ConnectionImpl.open(ConnectionImpl.java:61)
com.roguewave.jdbtools.v2_0.jdbc.JDBCServer.createConnection(JDBCServer.java:39)
com.roguewave.jdbtools.v2_0.ConnectionPool.getConnection_(ConnectionPool.java:433)
com.roguewave.jdbtools.v2_0.ConnectionPool.getConnection(ConnectionPool.java:110)

plz let me know, how to solve this problem, and let me know database configuration setting in myeclipse

thank you

regards

Hari Krishna

dear_hari@myway.com

[Haris Peco]

Hari,

You use oci jdbc driver and you have to add oci native library in system environment.Library is in ORACLE_HOME/lib and you have to add this directory in system classpath – it is different for different operating system, but you have add options
-Djava.library.path in VM args when you start eclipse

However, better way is that you use thin driver – this is pure java driver and you can access to database from some machine in network (oci driver can use only loacl system).For setting thin driver you have to change URL defintion in MyEclipse conection profile from :

jdbc:oracle:oci8:<database>

to

jdbc:oracle:thin:@<YOUR_SERVER>:<YOUR_PORT>:<YOUR_SID>

where YOUR_SERVER is name (or IP) your server, port is usually 1521 and SID is default orcl or XE for oracle express (you can ask your administartor for correct url).

Best regards

[Author]

Posts