1. ORA-01008: not all variables bound error in WebLOgic connection pooling
I am getting "ORA-01008: not all variables bound" when using the
prepareStatement method when connected via connection pooling with an
OCI driver, but it works when using a direct connection with a thin
ORACLE JDBC driver (classes12.zip). This failure is on both NT and
Solaris 2.6.
Here's the relevant code snippets:
public static Connection conn;
...
Context myCtx = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)myCtx.lookup("Keown");
conn = ds.getConnection();
...
PreparedStatement myPs = null;
String myAgmntSQL = "select start_dt, end_dt " +
"from sma_agmnts " +
"where agmnt_sys_id = ?";
myPs = myConnect.conn.prepareStatement(myAgmntSQL);
If I hardcode a value like 767 instead of ?, there is no error.
I believe that the error is occurring in the prepareStatement method
as I've inserted system outs before and after it to pin down where it
was failing.
The weblogic.properties file contains this:
weblogic.jdbc.connectionPool.banana=\
url=jdbc:weblogic:oracle,\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=1,\
initialCapacity=1,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=pcm8744;password=password;server=dldv
weblogic.allow.reserve.weblogic.jdbc.connectionPool.banana=ba,guest
# Data Source definition for banana
weblogic.jdbc.DataSource.Keown=banana
--
Visit Caribbean Aviation:
http://www.caribbeanaviation.com/
2. SQL Windows???
3. ORA-01008: not all variables bound .
4. US-Multiple Cities-Needed: SAP Professionals
5. help!!- jdbc prepared statement=error ora-01008
6. Params limit on xml-sql template?
7. Urgent !!!! -- ORA-01008: not all variables bound
8. Simple SQL problem
9. ORA-01008 not all variables bound ?
10. sql loader and ora-01008 (cross posted to tools)
11. ORA-01008: not all variables bound
12. Ora-01008 from PL/SQL
by