*
The moose likes JDBC and the fly likes  java.sql.SQLException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark " java.sql.SQLException" Watch " java.sql.SQLException" New topic
Author

java.sql.SQLException

Arun Giridharan
Ranch Hand

Joined: Sep 30, 2010
Posts: 290

Error:

18:25:09,828 ERROR [STDERR] java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
18:25:09,828 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
18:25:09,828 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
18:25:09,828 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
........

# TNSNAMES.ORA Network Configuration File: ....
# Generated by Oracle configuration tools.

XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin-41f89f35d)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin-41f89f35d)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


jdbc Code :


The Service_Name and the SID are the same XE , still i get this Exception! why?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException
 
Similar Threads
Problem to run Oracle9i after installed in Windows2000 professional?
invalid SQL url specified
Oracle database connection problem
Problem in connecting Oracle thru Java
ORA-12541: TNS:no listener