import javax.sql.DataSource; -----Original Message----- From: Lyra Marcos [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 12:38 PM To: [EMAIL PROTECTED] Subject: RES: JDBC in WEBLOGIC error
from what class comes DataSource? -----Mensagem original----- De: Godbey, David [mailto:[EMAIL PROTECTED]] Enviada em: segunda-feira, 10 de dezembro de 2001 13:51 Para: [EMAIL PROTECTED] Assunto: Re: JDBC in WEBLOGIC error This is how I get connections thru the Weblogic connection pool. I'm still using WL 5.1. In weblogic.properties file, define a Connection pool like this: weblogic.jdbc.connectionPool.IpmsDevPool=\ url=jdbc:weblogic:oracle,\ driver=weblogic.jdbc.oci.Driver,\ loginDelaySecs=1,\ initialCapacity=1,\ maxCapacity=5,\ capacityIncrement=1,\ allowShrinking=true,\ shrinkPeriodMins=15,\ refreshTestMinutes=10,\ testTable=dual,\ props=user=WL_POOL;password=WL_POOL;server=ipmsherc weblogic.jdbc.DataSource.IpmsPool=IpmsDevPool weblogic.allow.reserve.weblogic.jdbc.connectionPool.IpmsDevPool=\ everyone In my Java code, get a connection thru the pool like this. // Get data source via Context else if (appServerType.equals("WebLogic")) { Hashtable ht = new Hashtable(); ht.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory"); ht.put(Context.PROVIDER_URL,"t3://localhost:7001"); ctx = new InitialContext(ht); ds = (DataSource) ctx.lookup(connPoolName); } // Get connection conn = ds.getConnection(); I hope this helps. Dave -----Original Message----- From: Lyra Marcos [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 10:06 AM To: [EMAIL PROTECTED] Subject: JDBC in WEBLOGIC error Hi, I need to access an oracle database by using WebLOGIC connection pools in a Servlet. The following code shows my dilema: queryLeitura = "SELECT NUM_IF FROM OPER.PRECO where NUM_ID_PRECO < 575002 "; try { Driver myDriver = (Driver)Class.forName("weblogic.jdbc.pool.Driver").newInstance(); Connection conn = myDriver.connect("jdbc:weblogic:pool:oraclePool",null); Statement stmt = conn.createStatement(); stmt.execute(queryLeitura); ResultSet rs = stmt.getResultSet(); rs.next(); s=rs.getInt("NUM_IF"); stmt.close(); conn.close(); return (s);} catch(SQLException ex) { System.err.println("SQLException: " + ex.getMessage()); } I got an error that says: " Does not support SQL execution with no Global transaction" Please, What am I missing? Regards ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
