[jboss-user] [JCA/JBoss] - Re: org.jboss.resource.JBossResourceException: Could not cre

[eduacsp2]

"vicky.kak at jboss.com" wrote : anonymous wrote : when i use pure jdbc, everything is fine.
  | This is strange , the Jboss code which is failing here is 
  | 
  |   | private LocalManagedConnection getLocalManagedConnection(Properties props,Properties copy) 
  |   |    		throws JBossResourceException
  |   |    {
  |   | 	   try
  |   | 	   {
  |   | 		   String url = getConnectionURL();
  |   | 		   Driver d = getDriver(url); 
  |   | 		   Connection con = d.connect(url, copy);
  |   | 		   if (con == null)
  |   | 			   throw new JBossResourceException("Wrong driver class for this connection URL");
  |   | 
  |   | 		   return new LocalManagedConnection(this, con, props, transactionIsolation, preparedStatementCacheSize);
  |   | 	   }
  |   | 	   catch (Exception e)
  |   | 	   {
  |   | 		   throw new JBossResourceException("Could not create connection", e);
  |   | 	   }
  |   |    }
  |   | 
  | This is from 
  | http://anonsvn.jboss.org/repos/jbossas/trunk/connector/src/main/org/jboss/resource/adapter/jdbc/local/LocalManagedConnectionFactory.java
  | 
  | d.connect(url, copy);  seems to be failing .
  | 
  | Can you use the Driver.connect(...) to get the connection in your stand alone application and see if it works ?
  | Also make sure that you are using the same Oracle driver for running the stand alone application which is present in the Jboss server .
  | 
  | 
  | 

Right now i use this code, and everything is fine:


  | 		Connection con = null;
  | 		try{
  | 			Class.forName("oracle.jdbc.driver.OracleDriver");
  | 			con =DriverManager.getConnection("jdbc:oracle:thin:@xx.x.x.xx:1521:Gd13","xxxx","xxxx");
  | 		}catch(ClassNotFoundException e){
  | 			throw new SQLException(e.getMessage());
  | 		}
  | 		return con;
  | 

and...yes...the oracle jdbc driver is in the lib jboss folder.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4114152#4114152

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4114152