Error=code=1153emfi=4
Contents |
This Site Careers Other all forums Forum: JDBC and Relational Databases JDBC - Connection Refused Error. Connecting (trying) to Oracle DB. Rembrandt Reyes Greenhorn Posts: 3 posted 7 years ago warning: greenhorn = me. I am getting
Connection Refused(description=(err=1153)(vsnnum=0)(error_stack=(error=(code=1153)(emfi=4)
the following error message in my log file whenever I run my Java app error=(code=305)(emfi=1) which makes connections to an Oracle DB: SQLException: Io exception: Connection refused (DESCRIPTION=(ERR=1153)(VSNNUM=169869568)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4) (ARGS='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.###.###)(PORT=1521))) (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))null))'))(ERROR=(CODE=303)(EMFI=1)))) I am sure the HOST is
Oracle Error Code 305
correct. I have also tried using the server name. Using google fu, I've found references to needing to use a driver called classes12.jar Although I'm not quite sure what to do with it (I've java sql sqlexception io exception connection refused place it in different locations of the app directory but it didn't do anything) Let me know what other information I can share to help me solve my problem. Background info, we've recently changed from using a single node to load balancing 2 nodes. That is when the problem started (and when I inherited this application). I should also warn that this is my first programming/DB assignment coming from ojdbc14.jar download a hardware backround. I miss the warm comforts of my switches and routers.... Thank you in advance. Remy Paul Campbell Ranch Hand Posts: 338 posted 7 years ago It is your Oracle JDBC driver. in your classpath would be a good spot for it. Rembrandt Reyes Greenhorn Posts: 3 posted 7 years ago - Thanks for the reply Paul. I've made sure the classes12.jar is in the ClassPath and it already was. D:\SystemApps\Oracle\ora92\jdbc\lib\classes12.jar I also added classes12.jar as a jar to my project and then redeployed the app. I'm still getting the same errors. - To make sure I understand this, classes12.jar is an oracle driver or what Java uses to communicate with the oracle database. By placing it in the environment variables, the system knows where to find the said driver (and the file does exist in the location above) - Do I need to do anything else with the file to get it to "be seen"? - More info: I've installed tomcat on my machine and deployed the code there. It works. No errors. I didn't have to change anything locally (server and local machine are both using Tomcat 5.5). I'm not sure how my local copy is able to talk
help others java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=169870080)(ERROR_STACK=(ERROR=(CODE=1153)( EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=XYZ2)(PORT=1522))'))(ERROR=(CODE=305)(EMFI=1)))) dbaforums.org | 1 year ago 0 mark Oracle DBA Forums > Connection problem with Oracle 10G RAC from Oracle 9i application server dbaforums.org | 1 year ago https://coderanch.com/t/431821/JDBC/databases/JDBC-Connection-Refused-Error-Connecting java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=169870080)(ERROR_STACK=(ERROR=(CODE=1153)( EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=XYZ2)(PORT=1522))'))(ERROR=(CODE=305)(EMFI=1)))) find similars oracle.jdbc.dbaccess Oracle jdbc Java RT com.evermind.sql Spring Framework 0 0 mark Connection problem with Oracle 10G RAC from Oracle 9i application server - Oracle DBA Forums dbaforums.org | 1 year ago java.sql.SQLException: https://samebug.io/exceptions/509752/java.sql.SQLException/io-exception-connection?soft=false Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=169870080)(ERROR_STACK=(ERROR=(CODE=1153)( EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=XYZ2)(PORT=1522))'))(ERROR=(CODE=305)(EMFI=1)))) find similars oracle.jdbc.dbaccess Oracle jdbc Java RT com.evermind.sql Spring Framework 0 0 mark oracle.ifs.common.IfsException: IFS-20102: Unab... | Oracle Community oracle.com | 1 year ago java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=169870080)(ERROR_STACK=(ERROR=(CODE=1153)( EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=XYZ2)(PORT=1522))'))(ERROR=(CODE=305)(EMFI=1)))) find similars oracle.jdbc.dbaccess Oracle jdbc Java RT com.evermind.sql Spring Framework 0 Speed up your debug routine! Automated exception search integrated into your IDE Test Samebug Integration for IntelliJ IDEA 0 mark oracle.ifs.common.IfsException: IFS-20102: Unable to start service Oracle Community | 1 decade ago | tnabil java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=169870080)(ERROR_STACK=(ERROR=(CODE=1153)( EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=XYZ2)(PORT=1522))'))(ERROR=(CODE=305)(EMFI=1)))) find similars oracle.jdbc.dbaccess Oracle jdbc Java RT com.evermind.sql Spring Framework 0 0 mark connection problem Oracle 10G RAC from Oracle 9i Application server Oracle Community | 8 years ago | 458900 java.sql.SQLException:
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=168821248)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) error up vote 2 down vote favorite Yesterday i was using oracle 9.1 with ojdbc 14 jdbc driver with following code for adding employee, it was working fine but now i am using oracle 10.1.0.2.0 with ojdbc14 but now it is giving following error Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=168821248)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) error Following is code for adding employee public static Connection getConnection() throws Exception { String driver = "oracle.jdbc.driver.OracleDriver"; String url = "jdbc:oracle:thin:@localhost:5500:globldb3"; String username = "scott"; String password = "tiger"; Class.forName(driver); Connection conn = DriverManager.getConnection(url, username, password); return conn; } public String addEmployee(){ Connection conn = null; PreparedStatement pstmt = null; boolean committed = false; try { conn = getConnection(); conn.setAutoCommit(false); String query = "INSERT INTO employee(e_id,e_name,e_f_name,e_desg,e_address,e_phone_no,"+ "e_salary,e_house_rent,e_conv_allow,e_email,d_name,e_hire_month,e_hire_year)"+ "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)"; pstmt = conn.prepareStatement(query); pstmt = conn.prepareStatement(query); // create a statement pstmt.setInt(1,this.eid); pstmt.setString(2,this.ename); pstmt.setString(3,this.efname); pstmt.setString(4,this.edesg); pstmt.setString(5,this.eaddress); pstmt.setLong(6,this.ephoneno); pstmt.setInt(7,this.esalary); pstmt.setInt(8,this.houserent); pstmt.setInt(9,this.convallow); pstmt.setString(10,this.eemail); pstmt.setString(11,this.edname); pstmt.setInt(12,this.ehmon); pstmt.setInt(13,this.ehy); pstmt.executeUpdate(); // execute insert statement conn.commit(); conn.setAutoCommit(true); committed = true; return "add-employee-msg.xhtml"; } catch (Exception e) { e.printStackTrace(); return "add-employee-ex.xhtml"; } finally { try{ if (!committed) conn.rollback(); if (pstmt != null) pstmt.close(); if (conn != null) conn.close(); }catch(Exception e){ e.printStackTrace(); } } } //addEmployee