DriverManager not getting connection.

[prashanth chaitanya]

Hi,

I am having a strange problem when i am using DriverManager API of oracle.My classes12.jar is from oracle10G.Currently my problem is whem i am trying to import 1000 records from an external CSV file into database it is failing with the following stack trace.

12:17:28,312 ERROR [STDERR] java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
12:17:28,312 ERROR [STDERR] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
12:17:28,312 ERROR [STDERR] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
12:17:28,312 ERROR [STDERR] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273)
12:17:28,312 ERROR [STDERR] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327)
12:17:28,312 ERROR [STDERR] at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:360)
12:17:28,312 ERROR [STDERR] at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)
12:17:28,312 ERROR [STDERR] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
12:17:28,312 ERROR [STDERR] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
12:17:28,312 ERROR [STDERR] at java.sql.DriverManager.getConnection(DriverManager.java:582)
12:17:28,312 ERROR [STDERR] at java.sql.DriverManager.getConnection(DriverManager.java:185)
12:17:28,312 ERROR [STDERR] at com.vodafone.mpweb.csv.CSVDAO.getConnectionFromDriver(CSVDAO.java:75)
12:17:28,312 ERROR [STDERR] at com.vodafone.mpweb.csv.CSVDAO.getConnection(CSVDAO.java:46)
12:17:28,312 ERROR [STDERR] at com.vodafone.mpweb.csv.CSVFieldValidator.ruleRemoteValue(CSVFieldValidator.java:500)
12:17:28,312 ERROR [STDERR] at com.vodafone.mpweb.csv.CSVValidator.validateData(CSVValidator.java:317)
12:17:28,312 ERROR [STDERR] at com.vodafone.mpweb.csv.CSVParser.loadFile(CSVParser.java:33)
12:17:28,312 ERROR [STDERR] at com.vodafone.mpweb.csv.CSVParser.parseCSV(CSVParser.java:86)
12:17:28,312 ERROR [STDERR] at com.vodafone.mpweb.session.csv.MpwCsvFilesHome.startImportFromCSVProcess(MpwCsvFilesHome.java:97)
12:17:28,312 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor1263.invoke(Unknown Source)
12:17:28,312 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
12:17:28,312 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:95)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.util.Work.workInTransaction(Work.java:47)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:89)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103)
12:17:28,312 ERROR [STDERR] at com.vodafone.mpweb.session.csv.MpwCsvFilesHome_$$_javassist_6.startImportFromCSVProcess(MpwCsvFilesHome_$
$_javassist_6.java)
12:17:28,312 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor1262.invoke(Unknown Source)
12:17:28,312 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
12:17:28,312 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
12:17:28,312 ERROR [STDERR] at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
12:17:28,312 ERROR [STDERR] at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342)
12:17:28,312 ERROR [STDERR] at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58)
12:17:28,312 ERROR [STDERR] at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
12:17:28,312 ERROR [STDERR] at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
12:17:28,312 ERROR [STDERR] at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
12:17:28,312 ERROR [STDERR] at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.ja
va:88)
12:17:28,312 ERROR [STDERR] at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
12:17:28,312 ERROR [STDERR] at javax.faces.component.UICommand.broadcast(UICommand.java:387)
12:17:28,312 ERROR [STDERR] at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)
12:17:28,312 ERROR [STDERR] at org.ajax4jsf.component.UIDataAdaptor.broadcast(UIDataAdaptor.java:1364)
12:17:28,312 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:321)
12:17:28,312 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:296)
12:17:28,312 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:253)
12:17:28,312 ERROR [STDERR] at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:466)
12:17:28,312 ERROR [STDERR] at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
12:17:28,312 ERROR [STDERR] at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
12:17:28,312 ERROR [STDERR] at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
12:17:28,312 ERROR [STDERR] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:17:28,312 ERROR [STDERR] at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
12:17:28,312 ERROR [STDERR] at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
12:17:28,312 ERROR [STDERR] at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:368)
12:17:28,312 ERROR [STDERR] at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:495)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.web.HotDeployFilter.doFilter(HotDeployFilter.java:53)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:17:28,312 ERROR [STDERR] at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:17:28,312 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
12:17:28,312 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
12:17:28,312 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
12:17:28,312 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve
.java:126)
12:17:28,312 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.
java:70)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
12:17:28,312 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
12:17:28,312 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
12:17:28,312 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
12:17:28,312 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
12:17:28,312 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
12:17:28,312 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)


The point at which the exception is thrown is at the following statement "DriverManager.getConnection"

How ever the same works when i am importing 200 records.

I open and close the connection according to the validations to be done on each record of the csv file.I am not able to understand why this is happening.Please help me in this.

[Somnath Mallick]

Could you post your code as well. And please use code tags for codes and Error Stacks.

[prashanth chaitanya]

Properties dataProperties = new Properties();
dataProperties.load(getClass().getClassLoader().getResourceAsStream(
"CsvSqlProperties.properties"));
dataProperties.getProperty(CSVSqlConstants.DRIVER_NAME);
dataProperties.getProperty(CSVSqlConstants.DRIVER_NAME);
String driverName = dataProperties
.getProperty(CSVSqlConstants.DRIVER_NAME);
String url = dataProperties.getProperty(CSVSqlConstants.URL);
String username = dataProperties.getProperty(CSVSqlConstants.USERNAME);
String password = dataProperties.getProperty(CSVSqlConstants.PASSWORD);
Class.forName(driverName);
Connection connection = DriverManager.getConnection(url, username,
password);
connection.setAutoCommit(false);


I read the the database information from a properties file. Strange things observed were, it some times imports 300 records and gives exception i am not able to guess why it works perfectly for 200 records and only sometimes for 300 records.

[Somnath Mallick]

Please use code tags like this:

Properties dataProperties = new Properties();
dataProperties.load(getClass().getClassLoader().getResourceAsStream(
"CsvSqlProperties.properties"));
dataProperties.getProperty(CSVSqlConstants.DRIVER_NAME);
dataProperties.getProperty(CSVSqlConstants.DRIVER_NAME);
String driverName = dataProperties
.getProperty(CSVSqlConstants.DRIVER_NAME);
String url = dataProperties.getProperty(CSVSqlConstants.URL);
String username = dataProperties.getProperty(CSVSqlConstants.USERNAME);
String password = dataProperties.getProperty(CSVSqlConstants.PASSWORD);
Class.forName(driverName);
Connection connection = DriverManager.getConnection(url, username,
password);
connection.setAutoCommit(false); 

Is your url and IP like 10.xx.xx.xxx or something? Or are you using a DNS name?

[prashanth chaitanya]

I am sorry. I am completely new to java ranch.

I have used an URLwith IP(like 10.23.34.56) and then tried using the hostname(like localhost or systemABC).
But either way it didnt work.

[Somnath Mallick]

Check this link...
http://forums.sun.com/thread.jspa?threadID=284032

and see if the info helps.

[prashanth chaitanya]

Thanks for the link..

I had a look at all the posts in the forum. But my problem is a little different. i am able to conect to the Database and also perform the required operations but however the connection is good for 200 records and fails for 300 to 500 records.

I open a connection for each record and close it.

I need to do this to fire a select statement on the database.

Is there anything i am missing?

[Somnath Mallick]

That could be a heap issue.... Use the -xmx and -xms while running the code.

[Paul Sturrock]

My classes12.jar is from oracle10G

Why are you using this driver? Are you running your application on a 1.3 or lower JDK? And if so, why?

[prashanth chaitanya]

No, we are using JDK 1.6. But however we are using basic JDBC calls for validating the CSV files. Using EJB 3.0 and Hibernate doesnot give us the entire flexibility of all the checking to be made and more over entity beans are much heavier we feel.

[Paul Sturrock]

No, we are using JDK 1.6.

Then I would upgrade your driver.

Using EJB 3.0 and Hibernate doesnot give us the entire flexibility of all the checking to be made and more over entity beans are much heavier we feel.

Entity beans and EJB3.0? EJB 3.0 does not include Entity beans. Also, this is a bit of an aside, but you are aware Hibernate (and other ORMs) allow you to run native SQL? You may be throwing the baby out with the bathwater, as they say.