I am using the following SQL query: Select * from table1 as t1, table2 as t2 where t1.id = t2.col but my problem is that both the tables have fields with same name, place. So how can I select the column with name place from table2 in my PHP code? I want to use the following php code while($row_records = mysql_fetch_array($result_rec...
I'm having trouble trying to use $stmt->store_result() after executing a prepared statement. The manual says "Transfers a result set from a prepared statement", but to where? I would ideally like to use it, all nice an buffered in memory, like mysqli->query() returns. The php documentation examples make it seem like the only good reaso...
We are running a websphere commerce site with an oracle DB and facing an issue where we are running out of db connections. We are using a JDBCHelper singleton for getting the prepared statements and cosing the connections. public static JDBCHelper getJDBCHelper() { if (theObject == null){ ...
I've got 2 queries I'd like to merge into 1 result set without using union. Query 1 select datepart(yy,dateclosed)as 'Year', datepart(mm,dateclosed) as 'Month', count(*)as 'Total' from bug where projectid = 44 and ifclosed = 1 and isnull(createdbyperson,1) <> '-1111111110' and datepart(yy,dateclosed) > '2000' group by datep...
I want to validate a value against values retrieved from a result set's first column. I have to do the same validation operation approximately 1000 times. So, I want to decrease the time complexity of this comparison from O(n) to constant. Is there some function through which I can put all of the values of result set's column into a ...
What is the best way to skip ahead to a specific record number in a Java JDBC resultset? ...
I have a stored procedure that has multiple result sets. How do I advance to the 2nd result set in mysqli to get those results? Let's say it's a stored proc like: create procedure multiples( param1 INT, param2 INT ) BEGIN SELECT * FROM table1 WHERE id = param1; SELECT * FROM table2 WHERE id = param2; END $$ The PHP is something li...
Hey everyone, I am writing a program that will query an MS access database, return the query as a result set, and then I want to ultimately convert that result set into a String array, so that I can pass it into the constructor of a Swing JComboBox - so the ComboBox will list the items returned by the query. I have been able to store t...
Hey there, The problem is, that after displaying the ResultSet with h:dataTable, the connection is left open. If I close it, it closes the ResultSet too. I'm thinking about copying the ResultSet data into some HashMap/ArrayList combo. Is there a good way to deal with this problem? Thanks in advance, Daniel ...
Hi I am doing the following in my SampleServlet.java //Fill resultset from db ..... try { ArrayList Rows = new ArrayList(); while (resultSet.next()){ ArrayList row = new ArrayList(); for (int i = 1; i <= 7 ; i++){ row.add(resultSet.getString(i)); } Rows.add(row); } reques...
I a problem in JDBC driver for SQLite. I am executing a query with SELECT statement. If I get an empty resultset (0 rows) then I see a "Closed ResultSet" exception thrown when checking GetString(1). Without much prior JDBC experience, my theory (which I could not confirm via JavaDocs for ResultSet) is that GetString(1) does NOT work...
I've got a class that implements Iterator with a ResultSet as a data member. Essentially the class looks like this: public class A implements Iterator{ private ResultSet entities; ... public Object next(){ entities.next(); return new Entity(entities.getString...etc....) } public boolean hasNext(){ ...
I have situation where a 3rd party open source product I am using is running out of cursors in Oracle and receiving the error: java.sql.SQLException: ORA-01000: maximum open cursors exceeded My maximum cursors is set to 1000 and I am trying to figure out if the code that is reaching this limit is doing something incorrectly, or if I sim...
I'm trying to understand MySQL Stored Procedures, I want to check if a users login credentials are valid and if so, update the users online status: -- DROP PROCEDURE IF EXISTS checkUser; DELIMITER // CREATE PROCEDURE checkUser(IN in_email VARCHAR(80), IN in_password VARCHAR(50)) BEGIN SELECT id, name FROM users WHERE email = in_emai...
I have a crashed table which I am unsure how to repair with. Here is the dump of my error trace. Warning: mysql_query(): Unable to save result set in C:\Users\programmer\workspace\DBMigration\functions.php on line 10 MySQL Query Failed! 1194: Table 'exp_weblog_titles' is marked as crashed and should be repaired ...
Hi, I have a stored procedure in an Oracle 10g database, in my java code, i call it with: CallableStatement cs = bdr.prepareCall("Begin ADMBAS01.pck_basilea_reportes.cargar_reporte(?,?,?,?,?); END;", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); cs.setInt(1, this.reportNumber); cs.registerOutParameter(2, Oracle...
see this http://javascript.internet.com/forms/multiple-search-engine.html . i wonder how to open the search result in new window. help me! ...
Hello, My first post here with 2 questions. Question 1 I am new to SSRS environment and have been looking to get architectural information to explain me how rdl is processed and rendered. For e.g. all datasets executed and resultsets cached, then all tables rendered... etc. So if someone has any link that would give me an overview, i...
Hi, I had a look on the site and on Google, but I couldn't seem to find a good solution to what I'm trying to do. Basically, I have a client server application (C#) where I send the server an SQL select statement (Connecting to SQL Server 2008) and would like to return results in a CSV manner back to the client. So far I have the follo...
I want to use scrollable resultset, so when I use two lines of code: rs.setFetchDirection(ResultSet.TYPE_SCROLL_SENSITIVE); rs.absolute(12); in my DAOimpl, I get exception, plz help to solve them, thank in advance. import oracle.jdbc.OracleTypes; import org.springframework.jdbc.core.CallableStatementCallback; import org.spr...