1. Weblogic Error - Method not supported : Statement.cancel stackoverflow.comI am running an application on Weblogic 9.2 MP3, currently having problem with connection pool. |
2. Help - Statement error! coderanch.com |
3. error while creating a statement coderanch.com |
4. Select statement error coderanch.comHi all, am trying to select information from a few tables, and because some of the tables have overlapping fieldnames e.g. name etc, I am trying to reference them in my sql statment like this... sqlString = "select myTable1.name, myTable2.name from myTable1, myTable2 where .... and so on and so on this unfortunately does not work and I am told that ... |
5. Statement Closed Error - please help coderanch.comHi Friends, I have two queries to run from one class.I send the queries to another class,which send me back the resultset to cook.For one query its running fine,but i don't know why for two queries ,its throwing error as "statement closed".Can you please tell me where i am going wrong??? In first method i have: ResSet qt = new ResSet(); ... |
6. Somtimes I get an unique constraint error on an update statement coderanch.comAre you trying to update a record's Primary Key to equal an existing value? -- Yes Does your database allow any unique constraints on non-key fields? -- The db is Oracle, so I would say yes. If so, are you breaking that rule by trying to update a field to an existing value? If I have 15 columns (2 are primary ... |
7. OutOfMemory Error and Statement.close() coderanch.comWe have a standalone application which does intense DB update operations. Pseudo code below Class JBDCCon{ Connection m_con; Statement m_stmt; .... execute(){//This method will be called only once m_con = ...//Create Connection while(moreMessages) runQuery();//Munmer of messages > 200000 m_con.close(); } runQuery(){//This method will be called based on number of messages m_stmt = m_con.create.....//New Statement Object for each call of this runquery ... |
8. error on statement coderanch.comThis code generates are error, having something to do with using the "Statement" twice in a row. If I utilized "Statement2" it has no error and works correctly. Do I need to close out the recordset or the statement to utilize the statement again in another query? The error is posted at the bottom. connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/database01", "SMART", "password"); statement = ... |
9. Statement Error coderanch.com |
10. Statement Error coderanch.com |
11. error in SQL statement coderanch.com |
12. Statement is already closed error coderanch.comHi, I'm trying to get the output parameter of a stored procedure as in the below code. However, after calling callableStatement.execute(), the callableStatement object gets closed, causing the call to getInt() to throw an SQLException saying, "java.sql.SQLException: Statement has already been closed". I'd like to know what I need to look at for me to get this to work. I'm fairly ... |
13. error while using sql update statement coderanch.comwhile running the following program i got a runtime error: exception [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. import java.io.*; import java.sql.*; public class database { public static void main(String args[])throws IOException { Connection con=null; Statement stmt=null; // ResultSet rs=null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:Access" ); //String s="SELECT * FROM CUSTOMER"; stmt=con.createStatement(); String s1 = "insert into CUSTOMER values('adf','dsf')"; ... |
14. SQL Statement error forums.oracle.com |
15. Pleasse help me with this error in SQL statement forums.oracle.com |