Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- oracle: how to "easily" divide two resultsets?
- Hi,I have the following two SQLs and their resultsets table names have been changed:PRODUCTS:select sum(q1), sum(q2), sum(q3), sum(q4) from product_history where technology_type = 'Stocked' and year = :year; Q1 Q2 ...
- Tags: v_legaspi, resultset, Stocked
- Discussion threads 2007-09-17
- Execute Stored Procedure in a Resultset
- I have a sql server resultset that returns productid numbers. I would like to loop thru this resultset and run a stored procedure using the productid as the input parameter. Any samples would be helpful. thanksIn T-SQLsome thing likeDeclare csr_Products cursor For insert your query hereDeclare...
- Tags: Congero, productID, resultSet, software, database, programming, cursor
- Discussion threads 2007-02-21
- java & oracle
- how to connect java with oracle databaseTry starting here:http://www.orafaq.com/faqjdbc.htm-- RLimport java.sql.*;public class MyConnection { /** * You need the oracle's driver jar (classes12.jar) */ public static void main(String args[]) { try { //Attempts to establish a...
- Tags: Java, Databases, Programming languages, database, JDBC, Connection
- Q&A 2006-06-19
- Implementing DbUtils
- JDBC code is one area of Java coding that leads to an amazing amount of repetitive code being written. On top of that, silly mistakes almost always plague JDBC code. Writing good JDBC code is not difficult yet can be quite painful.Adapted from:Pro Jakarta Commons, by Harshad Oak Publisher: Apress...
- Tags: Java, Databases, Harshad Oak, Implementing DbUtils, JDBC, closeQuietly, ResultSet
- Technical articles 2004-04-09
- Deciding between iterators and lists for returned values in Java
- The java.util.Iterator and java.util.List classes essentially do the same thing: They give you access to a sequence of objects. But a key difference gives iterators an edge in certain situations.The java.util.Iterator and java.util.List classes basically just provide access to a sequence of objects. However, they have one fundamental difference that...
- Tags: Ryan Brase, Java, iterator, ResultSet, hasNext
- Technical articles 2002-08-14
Additional Resources
- Data Binding
- Pls tell me if theirs any way i can bind a resultset created from a datasource to my datagridtablestyle in Windows Mobile 2005somethng like this :DataGrisTableStyle t=new DataGrisTableStyle);t.MappingName= resultsetname;
- Tags: Operating systems, sagar.aggarwal@...
- Discussion threads 2006-11-08
- JDataGrid Database Edition (zip)
- JDataTable provides a Java data grid component for database, support ResultSet and RowSet, column sorting, print and print preview and export file for multiple format and more. Insert, delete, update recorder. Print and Print Preview. JDataGrid Database Edition mainly used in the desk program and web browser program, JDBC technology,...
- Tags: Recorder, JDataTable, Java, Databases, Programming Languages, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2007-09-03
- Format Java-extracted data using DOM and XSL
- Java can extract data from any JDBC-compliant database, convert that data into a DOM object, and then use XSL to format that data in the desired fashion. In a previous article, we demonstrated how to programmatically extract the data from a database. Now, we'll look at how to build the...
- Tags: XML, John Charles Bell, Java, Document Object Model, columnCount, columnNames, JAXP XML processing, XSL
- Technical articles 2003-07-21
- Use JDBC to examine the structure of a database
- The next time you need to programmatically obtain information about the structure of your database, remember that JDBC has a solution. Follow these examples and learn about two objects that will allow you to examine your database's structure.No matter what development hats you wear, you're bound to run into situations...
- Tags: Storage, Databases, Lamont Adams, database, DatabaseMetaData, JDBC
- Technical articles 2001-12-18
- Crystal Reports Puzzle
- I have a Crystal Report that is reading a table for sales invoices where there may be for example 50 of a product sold (1st row for transaction in table) then 50 rows with the serial numbers of each.I print the sale line and then report the serial numbers, but...
- Tags: wayne@..., serial number
- Discussion threads 2006-10-17
- Export excel sheets to PDF documents with Aspose.Cells for Java
- Aspose.Cells is an XLS Java Spreadsheet SDK for spreadsheet reporting without using Microsoft Excel. Other useful features include formula settings, macros, VBA, unicode, hyperlinks, pivot tables, open encrypted excel files, importing data from JDBC ResultSet and supports all advanced features of data management, formatting, worksheet, charting and graphics. Aspose.Cells for...
- Tags: Programming languages, aspose_seo, Aspose.Cells, Adobe PDF, Java
- Discussion threads 2007-09-24
- Aspose.Cells is an XLS Java Spreadsheet SDK for spreadsheet reporting
- Aspose.Cells is an XLS Java Spreadsheet SDK for spreadsheet reporting without using Microsoft Excel. Other useful features include formula settings, macros, VBA, unicode, hyperlinks, pivot tables, open encrypted excel files, importing data from JDBC ResultSet and supports all advanced features of data management, formatting, worksheet, charting and graphics. Aspose.Cells for...
- Tags: PRODUCTIVITY, Databases, Java, aspose_seo, Aspose.Cells, XLS Java Spreadsheet SDK, SDK, spreadsheet
- Discussion threads 2007-09-24
- running sum in SQL
- I have a sorted table and I want to create another one that would contain a field that is a running sum. I cannot figure it out in SQL, I know it's possible in Excel, Access ...day total for day ...
- Tags: Programming languages, Databases, Microsoft Office, highlander718, SQL
- Discussion threads 2007-07-20
- Passing parameters from VB6 to SQL
- Dim intVal as Integerintval = 2020qconn.Execute("Select * from Table1 where userid=intval")The question is how can I make sql recognize or accept intval as a predefined variable in VB6 and run the query with resultset based on the value of intval?You need to ensure that the substitution takes place before the...
- Tags: Table1, SELECT
- Q&A 2005-11-10
- More Sybase XML basics
- Java and XML are the perfect tools for working with Sybase data. Learn how easy it is to create XML result sets with Sybase ASE.The ResultSetXml class is a generic subclass of the JXml class. This class is designed to create an XML result document from any valid SQL statement...
- Tags: Databases, Programming languages, ResultSetXml, XML, ResultSetXml document, ResultSetXml class, SQL, Sybase Inc.
- Technical articles 2002-07-17
- Use JDBC and help your applications and databases interact
- Looking for a way to make your applications interact with a database? Java DataBase Connectivity JDBC might be the answer. Find out how JDBC can help you connect to a database, retrieve data, and display the results.Database access makes up a major portion of Java applications development because at some...
- Tags: Databases, Java, Storage, Bill Detwiler, JDBC, database, ODBC
- Technical articles 2001-01-23
- Monitor system information with SQL Server 2005's default trace
- Sometimes it is difficult to diagnose problems on your SQL Server after they have occurred. So find out why you should use SQL Server 2005's default trace feature to monitor certain events.Introducing default traceA trace is an activity that is run in the background on a SQL Server machine that...
- Tags: Monitor, Microsoft SQL Server, Trace, Server, Microsoft SQL Server 2005, Tim Chapman
- Blog posts 2007-08-13
- Optimize SQL Server queries with these advanced tuning techniques
- More good inputThanks again Tim. I've been following this line of posts because the topic has been speed. Thanks for pointing out the STATISTICS IO option. This is one of those "nuggets" that I always look forward to discovering and now that I know about it, I...
- Tags: thisisfutile, technique, advanced tuning technique, Optimize SQL Server, subquery, server
- Discussion threads 2007-09-18
- Using correlated sub-queries in SQL Server
- Possessing the ability to use a correlated sub-query will allow you to solve problems that other database developers cannot. Tim Chapman discusses how to use this extremely useful programming construct. A sub-query is a SQL Server statement embedded inside of another SQL Server statement. The database engine treats...
- Tags: Microsoft SQL Server, Tim Chapman, Databases, server, sub-query, correlated sub-query, SQL Server Newsletter, Query, Database Engine, Execution Tree, Enterprise Software, Software, Data Management
- Technical articles 2006-07-31
- Getting started with data access using JDBC
- JDBC can be a little intimidating at first. Not to worry, though. This guided tour of Java's data access API will get you started.Unless you write only the most trivial applications, you're likely to need access to a database at some point during your Java programming lifetime. So it's probably...
- Tags: Databases, Programming languages, Storage, Lamont Adams, database, Java, JDBC, data access
- Technical articles 2001-11-26
- << Previous
- page 1 of 1
- Next >>
