2,747 questions
-3
votes
1
answer
158
views
SQL Developer (Oracle): How to find total disk space size of a result set [closed]
I have a query that returns a one column result set and I would like to know the total space size, not count, of that result set. The result set has over one million records. I could export it and ...
- 330
2
votes
0
answers
226
views
Java ResultSet getByte throwing outside of valid range for type java.lang.Byte error
I am running a minor SQL extract from a MySQL DB table. The field in question is set up as char(2) and usually has values from 0 to 12, never > 15. When I run my SQL query, the ResultSet getByte(&...
- 69
0
votes
1
answer
604
views
Returning a table from RESULTSET in Snowflake
I have been all over the place looking for a solution to this and I have tried everything I have found. I have tried doing a declare of res in the declare, then the SQL query in the begin with the ...
- 21
0
votes
1
answer
39
views
Removing Results Tree entries based on text
Is possible to remove results in JMeter shown in the standard "View Results Tree" based on if certain text is present?
I am running the below, created via the BlazeMeter Chrome extension. ...
- 185
1
vote
2
answers
368
views
Chromadb: Why do results of collection.query() and collection.get() differ?
I am using Chromadb Version 0.5.23
print(collection.query(...))
produces something like:
{'ids': [['id1', 'id2', 'id3']], 'embeddings': None, 'documents': None, 'uris': None, 'data': None, 'metadatas'...
- 41
0
votes
1
answer
117
views
Methods to find/check objects representing SQL expressions like functions or complex operations in SQLGLOT OR PYSPARK
I am building a Streamlit app to translate SQL queries into PySpark. The app fails when the SQL query includes functions or complex operations in the JOIN condition. How can I correctly handle these ...
0
votes
0
answers
45
views
Why my ResultSet reflect the changes made externally, even though it's TYPE_SCROLL_INSENSITIVE?
Why my Java ResultSet showing updated data when I use TYPE_SCROLL_INSENSITIVE with an external database update ?
I'm working with a MySQL database in Java, and I have a ResultSet with ...
0
votes
1
answer
289
views
How to mitigate "No columns were selected" exception from GridReader
I am getting this exception from Dapper.SqlMapper.GridReader when calling
var resultSet = await SqlConnection.QueryMultipleAsync(query, parameters, commandType: CommandType.StoredProcedure);
var ...
- 2,097
1
vote
0
answers
77
views
Spring Boot with JdbcTemplate reading 100 column eventually turn into 'Resultset is closed'
Here are my code snippets
package com.org.repository;
import com.org.config.datasourceconfig.DataSourceConfig;
import com.org.domain.transformer.SimpleMapper;
import com.org.infra.projection....
0
votes
3
answers
111
views
How to get the number of rows written by CSVPrinter?
My code runs a SELECTstatement, and saves the entire ResultSet into a file with a single call to CSVprinter.printRecords(resultSet).
This works very nicely except, I'd like to know, how many records ...
- 4,362
0
votes
0
answers
63
views
SSIS Execute SQL Task not returning Result Set to string variable
Following YouTube example, but mine does not work. My Execute SQL Task is not assigning the selected string to User::FileName variable.
After building, tried to debug by right-click, Execute 'Get ...
- 15
-3
votes
1
answer
100
views
How do I create an object from a ResultSet? [closed]
I'm trying to write a method the recieves an id an returns an object from a database, but it keeps returning null instead.
public Seller findById(int id) throws SQLException {
Seller seller = ...
0
votes
0
answers
190
views
How to access the Results text that are generated in copilot post starting the search of a text? I am unable to locate its exact Xpath
I am trying to extract the results after commencing the web search for a keyword in copilot. I am able to locate the search bar, but I am unable to locate the search results on the website. I am ...
0
votes
1
answer
128
views
Unknown syntax error with Snowflake SQL procedure
I am writing a Snowflake SQL procedure to drop row access and masking policies from a database once it is cloned.
CREATE or REPLACE PROCEDURE DBMGT.DBADMIN.Q_DROP_MASKING_and_ROP_ON_BKP_DB("...
- 21
-1
votes
2
answers
484
views
"ResultSet is positioned before first row" Problem, unsure of how to solve it [duplicate]
I've highlighted the particular point of issue.
public void getCars(int uID) throws SQLException
{
int size = 0;
int userID = uID;
ResultSet temp2;
int numRows = 0;
int ...
0
votes
0
answers
34
views
Delete a specific record in JDBC ResultSet rs without going over record by record on rs
If you already have read record in a Java JDBC Resultset rs, suppose it has columns username, id, rollnum, now you want to delete record from Reseultset where username = ‘user1’, can you do it without ...
0
votes
0
answers
43
views
Get Foreign Key id of a table and make a list of the object ids assigned to it in a JComboBox
I want to the admin user to select an Id from a MySql database table and show an id list of the other columns that are assigned to the original Id that the person selected in a JComboBox and ...
-2
votes
1
answer
64
views
Only last entry of hashmap get added to nested hashmap and returned [closed]
HashMap<String,String> details=new HashMap<>();
switch(value){
case "approved":
if(rs!=null) {
int i = 1;
while(rs.next()) { ...
- 25
0
votes
0
answers
455
views
Limit data read from a table in Athena?
Is it possible to limit the number of rows read from a table with an Athena query, and if so how?
I looked at the LIMIT statement, but it seems LIMIT doesn't affect how many rows are scanned, but ...
- 1,624
0
votes
1
answer
120
views
Why 'ResultSet.next()' is return false?
Using Windows 11, OracleDB, IntelliJ, Lombok, Java
I'd like to know why rs.next() returns false in the following code and while() statement doesn't run.
//MemberDAO.java
import java.sql.*;
import ...
- 13
1
vote
1
answer
122
views
Why should I close a CachedRowSet object? [duplicate]
I have a CachedRowSet object in Java. Since CachedRowSet objects are disconnected from the DB, is there a need to close them, or put them in try-with-resources blocks? My IDE is suggesting I should.
...
- 843
-1
votes
2
answers
87
views
How to perform a select by sections since it contains many records using Java?
I have a table which contains approximately 100,000 records, I did a SELECT to obtain the total number of records because it can vary, I need to consult the table and obtain all the records of 4 ...
- 137
0
votes
1
answer
83
views
How RowSet works java?
I am trying to understand the internal workings of RowSet.
How does it set the properties data and create a connection?
RowSetFactory factory = RowSetProvider.newFactory();
JdbcRowSet jdbcRowSet = ...
- 3
0
votes
1
answer
360
views
KQL How to display default rows for every case even on no match
With KQL, is there a way to generate extra rows in the results table, for every possibility in a case statement, even if there were no matches from the dataset? This is to save the front end from ...
- 41
0
votes
1
answer
155
views
CodeIgniter4 query builder script calling getRowArray() only returns 1 row
I am trying to execute this query from an active record script in CodeIgniter 4.
SELECT pres.db_pem, COUNT(*) AS Count FROM pres GROUP BY pres.db_pem;
I have try with
public function countall()
{
...
- 11
1
vote
0
answers
84
views
Understanding of result memory for impala jdbc driver
I have written below code that get result set using prepared statement. We are using impala DB with jdbc driver.
private void writeToCSV(File resultFile, ResultSet resultSet) throws IOException, ...
- 36
0
votes
1
answer
109
views
i want to know accuracy of the geocoding results
I am using the TomTom Reverse Geocoding API to obtain an address based on a given latitude and longitude. However, I've noticed that the returned address may not always be an accurate match. Is there ...
- 11
1
vote
1
answer
747
views
Snowflake procedure with default datetime arguments
I'm looking to create a Snowflake procedure that would enable end user to create a table with a list of timestamps within defined period of specific interval.
Example
The end-user passing arguments:
...
- 18.9k
-1
votes
2
answers
275
views
Replace last 3 characters (at most) with asterisks for multiple elements in each result set row
I have this PHP code with MySQL database query and I would like to display a record from MySQL database such as first_name and last_name records, I would like only to display like PHP echo $row the ...
- 11
0
votes
0
answers
47
views
How can I avoid a closed result set exception
I am using below code
public List<Test> getData(String sectionNumber) {
String query = "SELECT FROM test WHERE section_number = ?";
log.info("Executing method {}", &...
1
vote
2
answers
463
views
SQL QUERY - Provide a student/parent list. Formatted child name, parent name 1, parent name 2. If a child doesn’t have a parent, just display null
I am working on an SQL problem for a class - "Provide a student/parent list. Formatted child name, parent name 1, parent name 2. If a child doesn’t have a parent, just display null."
The ...
- 33
0
votes
0
answers
239
views
JdbcTemplate provides empty ResultSet for RowCallbackHandler but a non-empty one for ResultSetExtractor
I am trying to transfer some data from a MS SQL Server database to a Postgres database. My plan is to write a Spring Boot application that reads records from one datasource (mssql) and inserts them ...
- 11
0
votes
2
answers
78
views
How to pass a 2d result set from a controller to a view file in CodeIgniter
at library/comment.php
function getSelectedOneFieldJoin2TblGroupOrder($select, $table, $where, $join_table1, $join_condition1, $join_table2, $join_condition2, $order_by=null)
{
$this->CI->db-...
- 15
0
votes
0
answers
54
views
How to access a column by name from ResultSet of an INNER JOIN - duplicate column names? [duplicate]
Using JDBC and SQLite, the ResultSet obtained from a SELECT with an INNER JOIN may contain duplicate column-names, e.g.
SELECT A.id, B.id FROM A
INNER JOIN B ON (A.id=B.ref)
How can I get the A.id ...
- 1,233
0
votes
1
answer
57
views
Pull values into one cell based on multiple criteria
trying to run a VBA that returns different cell values from a worksheet into another worksheet signle cell based on multiple criteria that matches (smth close to textjoin/filter function)
here is a ...
- 3
0
votes
1
answer
115
views
How to cast a javax.faces.model.ResultSetDataModel$ResultSetMap to java.util.HashMap
I am currently developing a web application using JSF. When I try to insert a hashmap from the datatable, it gives me an error, however it works when inserting a object into my function. I then try to ...
- 5
0
votes
1
answer
2k
views
Output result set in a PL/pgSQL script
I have a PL/pgSQL script (not a function or procedure), which does a bunch of work. Is it possible to display the output of a SELECT statement?
DO $$
BEGIN
SELECT * FROM my_table LIMIT 10;
END $$;
...
- 2,718
0
votes
1
answer
30
views
Align Monthly Results for the Same Control into One Row
I have 12 session results over the course of a year.
The results all relate to one control but the control is performed monthly. At the month the table displays as follows:
Control Table
I would like ...
0
votes
0
answers
182
views
java.sql.SQLException: Provider com.sun.rowset.RowSetFactoryImpl not found
I've asked a question on how to retrieve data from ResultSet before closing the connections.
JDK Version: jdk1.8.0_201
CachedRowSet class is suggested in an answer by someone in the above mentioned ...
1
vote
1
answer
395
views
Retrieve data from ResultSet before closing the Connections
I've created a method to fetch details from Database which returns an object of ResultSet by executing a callableStatement.
I want to close the Connection & CallableStatement. For performing this ...
1
vote
1
answer
682
views
How to do a INNER JOIN on multiple columns of the same table in MySQL
I have the following problem: I have three tables: log, media and users.
CREATE TABLE `users` (
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=...
-1
votes
1
answer
62
views
Two Java Applications behave differently when query from DB
I have two Java applications running on the same server, fetching data from the same Oracle DB. The data is updated in real-time. The first application reads directly from the updated tables, while ...
- 543
0
votes
1
answer
4k
views
Snowflake - How to add to RESULTSET in a loop
PROBLEM - I'm only getting the result set for last loop execution
QUESTION: How can I concatenate/add to resultset?
DETAILS
What I'm trying to do:
take patientID and Date from table 1 using CURSOR
...
- 23
0
votes
1
answer
467
views
JDBC- Will the Prepared Statement instantiated in try block and not accessible in finally block be closed once Conn is closed in finally block
It is said that when we close connection object, the preparedstatement, resultset everything gets closed. In existing project code I found that PreparedStatement is not closed explicitly and also it ...
- 3
1
vote
0
answers
366
views
How to JOIN tables in Spring JDBC?
I am creating a custom query in Spring using JDBC to join the tables that are in my Database, but when I check the endpoint in PostMan only the results one table appear. Any insight would be helpful.
...
- 33
0
votes
2
answers
2k
views
How to solve cannot access class com.sun.rowset.CachedRowSetImpl?
I'm trying to run a project in my local machine then I encountered this error.
"class org.springframework.jdbc.core.SqlRowSetResultSetExtractor (in
unnamed module @0x565b21bd) cannot access ...
- 11
0
votes
0
answers
73
views
Oracle sql query returning empty resultset in java code, but working fine in SQL developer
My Query is like this below.
select a.actl_empl_cd ,a.actl_yr_nb,a.actl_wk_nb
from eng_eplt.empl_actl_tm_sht a
where a.actl_yr_nb = (select to_number(to_char(sysdate, 'iyyy')) from dual)
AND a....
0
votes
1
answer
47
views
Not getting the desired output in PreparedSql statement (JAVA)
Im trying to pass a value to a query and save the result from the column.The value need to be passed using "single quotes"
Example:SELECT sales_order_id FROM mtl_sales_orders WHERE segment1 =...
0
votes
1
answer
490
views
How to read multiple results from stored procedure using c# in SAP B1
I'm having SAP HANA studio & developing an addon using C# in SAP B1. I want to know how to read multiple results from stored procedure? I used recordset
string Query = @"call ""...
- 23
0
votes
1
answer
131
views
Returning multiple rows manufactured in a LOOP in Postgres 14.7 stored function
Original Question
I'm writing a PL/PgSQL function to take an ltree and break out subtrees of various lengths. I'm going to run this against a sample of some real data to get frequency counts on ...
- 2,255