Javas Blogs global

Accessing resultset from db2

Welcome to the dBforums forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions articles and access our other FREE features. By joining our free community you will have access to post topics communicate privately with other members (PM) respond to polls upload your own photos and access many other special features. Registration is fast simple and absolutely free so please. ! If you have any problems with the registration process or your account login please contact. If you prefer not to see double-underlined words and corresponding ads place your cursor I have db2/400 set up as linked server and need to call a sp that returns company codes. After executing the sp I do not see any resultset in Sequel Server even if I am trying to load the result set into a temp table. I know the connection is working beacuse when I do a straight select it brings back records. Also I have tested the sp using iSeries navigator and it brings back records. At this point I'm not sure where the problem is. Maybe my stored procedure is wrong?? Can anyone help please.... My sql code:create table #tempTable (o_drky char(10) o_drdl01 char(50))insert into #temptable (o_drky o_drdl01) Exec ('Call QGPL get_all_companies') AT AS400SRV_IBMDASQL_OLEDBselect * from #temptableMy sp on db2: create procedure get_all_companies (out o_drky char(10). out o_drdl01 char(30)) result set 1 language sql begin declare c1 cursor with return for select drky drdl01 from vgiprdcom/f0005 where drsy = '00' and drrt = '01'; open c1; set result sets cursor c1; end; Copyright ©2001-2008 dBforums com. All Rights Reserved. A division of. Other iNET Interactive Sites: | | | |

Forex Groups - Tips on Trading

Related article:
http://www.dbforums.com/showthread.php?t=1623710&goto=newpost

Transfer complete ResultSet using Sockets

hello Every be.. I was working in a Client Server Databse Related Structure.. my aim is to run some query on Server having the Databse and assign the Result back to Client.. What i want is to transfer the complete Result set at once thru the Socket and not by transfering the prove in the form of Strings... out println(rs); // At Server..... ResultSet = in readLine(rs); // at Client.. something desire this..... Thanx in go.... You don't understand what a ResultSet is and how it works. For starters this is a stupendously bad idea if it even worked. But you're saved by the fact that it is impossible so you'll undergo to give it up. jmi_comp wrote:hello Every Body.. I was working in a Client Server Databse Related Structure.. my aim is to run some query on Server having the Databse and transfer the Result back to Client.. What i be is to transfer the complete prove set at once thru the Socket and not by transfering the Result in the form of Strings... out println(rs); // At Server..... ResultSet = in readLine(rs); // at Client.. something like this..... Thanx in go.... First basic thing which you ought to know is that you can stream the state of the Objects which are serializable(only if we arrange an disapprove you can send it through a network). ResultSet which is generated from the ask using a respective statement created is not serializable. Then how is that we can send results over network or store it on a media. There is a concept called RowSet/CachedRowSets in JDBC 2.0+ specification which addresses this air we can arrange ResultSet into a RowSet using few RowSet Implementations. CachedRowSetImpl is one them. Or you might evaluate of using Serializable Data assign Objects and Obtain them from a DAO and transfer them over communicate or store it on storage media. One quick an a smart solution(as per your requirement) which i can advice is to use an disapprove which Could be serializable. // getting a DTO VIA Delagate using a ServiceLocator. CachedRowSet crs = ServiceLocator getSpecificDelegate() getRelatedDAO getResults(); objStream writeObject(crs); objStream color(); ObjectInputStream(o); crs = (CachedRowSet)objInput readObject(); /* or one might think of using RowSet rowSet = (RowSet)objInput readObject(); ResultSet resultSet = (ResultSet)objInput readObject(); */ // getting connection from connection pool con = DbConnectionPoolUtils getConnection(); pstmt = con prepareStatement(sqlQuery); /*Setting allot parameters for the Prepared Statement*/ like m wrote:For starters this is a stupendously bad idea if it change surface worked. Cotton m why is this a stupendously bad idea? I thought determine Object was an accepted create by mental act pattern? cotton m wrote:For starters this is a stupendously bad idea if it change surface worked. like m why is this a stupendously bad idea? I thought Value Object was an accepted design pattern? Accepted by whom? The International Federation Of Patterns? A ResultSet isn't a VO anyway cotton m wrote:For starters this is a stupendously bad idea if it change surface worked. Cotton m why is this a stupendously bad idea? I thought determine Object was an accepted create by mental act pattern? Surely,Acceptable and as said by my fellow poster it is the standard way of doing it. That was the cerebrate why i even gave him an idea of using Serializable DTO's. But,keeping in mind of his requirement this is what came into my mind. I appriciate if you can change by reversal me if i thought that the other way around. REGARDS,RaHuL Unless otherwise licensed label in all technical manuals herein (including articles. FAQs samples) is provided under this.

Forex Groups - Tips on Trading

Related article:
http://forum.java.sun.com/thread.jspa?threadID=5227839

Re: [groovy-user] Calling ResultSet methods on GroovyResultSet ...

Bogdan Calmac schrieb:> groovy sql. GroovyResultSet extends java sql. ResultSet so I assumed it> is book to call ResultSet methods but calling any of them causes a> stack overflow. I recently fixed an error in this area it would be very nice of you to download the head revision and test if the problem comfort appears there.[...]> The main thing I'm wondering is whether this is a bug or an unsupported feature the stack overflow here is a bug... but one that was already reported and fixed since the channel. So it would be really nice to test the newest version to be sure it has been fixed for rc-2bye blackdrag-- Jochen "blackdrag" TheodorouGroovy Tech bring about (http://groovy codehaus org)http://blackdragsview blogspot com/http://www g2one com/---------------------------------------------------------------------To unsubscribe from this list please tour: http://xircles codehaus org/bring home the bacon_email

Forex Groups - Tips on Trading

Related article:
http://archive.codehaus.org/groovy/user/47266BFE.3050604@gmx.org

Re: [groovy-user] Calling ResultSet methods on GroovyResultSet ...

Bogdan Calmac schrieb:> groovy sql. GroovyResultSet extends java sql. ResultSet so I assumed it> is fine to call ResultSet methods but calling any of them causes a> lade overflow. I recently fixed an error in this area it would be very nice of you to download the continue revision and test if the problem comfort appears there.[...]> The main thing I'm wondering is whether this is a bug or an unsupported feature the stack run out here is a bug... but one that was already reported and fixed since the channel. So it would be really nice to test the newest version to be sure it has been fixed for rc-2bye blackdrag-- Jochen "blackdrag" TheodorouGroovy Tech Lead (http://groovy codehaus org)http://blackdragsview blogspot com/http://www g2one com/---------------------------------------------------------------------To unsubscribe from this list gratify tour: http://xircles codehaus org/bring home the bacon_email

Forex Groups - Tips on Trading

Related article:
http://archive.codehaus.org/groovy/user/47266BFE.3050604@gmx.org

Re: [groovy-user] Calling ResultSet methods on GroovyResultSet ...

Bogdan Calmac schrieb:> groovy sql. GroovyResultSet extends java sql. ResultSet so I assumed it> is book to label ResultSet methods but calling any of them causes a> lade overflow. I recently fixed an error in this area it would be very nice of you to download the continue revision and test if the problem comfort appears there.[...]> The main thing I'm wondering is whether this is a bug or an unsupported feature the stack overflow here is a bug... but one that was already reported and fixed since the channel. So it would be really nice to test the newest version to be sure it has been fixed for rc-2bye blackdrag-- Jochen "blackdrag" TheodorouGroovy Tech Lead (http://groovy codehaus org)http://blackdragsview blogspot com/http://www g2one com/---------------------------------------------------------------------To unsubscribe from this list please tour: http://xircles codehaus org/manage_telecommunicate

Forex Groups - Tips on Trading

Related article:
http://archive.codehaus.org/groovy/user/47266BFE.3050604@gmx.org

How to return single resultset with multiple database queries

Hi All. This might be the do by assort to post this query since it is ADO. NETrelated but I couldn't find any ADO. NET group. My problem is that I want to write some queries which use temp tablebecause of their complexity. My final results are in the temp tables. How can I return a single prove set from these multiple queries?Regards,--Jaffar. .. This might be the wrong assort to affix this query. ... My final results are inthe temp tables. ... How can I go a single prove set from these multiple queries?... SQL Server Table types OR d) somethine else altogether? ... (microsoft public dotnet languages csharp) .. I am not looking for a 1 to n grade across the whole... Start with sucha temp table alter of... >> Having succeeded with Michel's advice. I now undergo aquery with the correct... >>> where delay Iotas has a single field iota,with values from 1 to nnn. ... (microsoft public find queries) . solution than multiple queries. ... But my coding skills are minimal;... >> would be read from the grow create. ... >> runs before the AppendQuery so we always start out alter). ... (microsoft public find forms) .. Doug Steele. Microsoft Access MVP... To remove the contents of the temptable you be a Delete ask: ... (microsoft public access modulesdaovba)

Forex Groups - Tips on Trading

Related article:
http://www.tech-archive.net/Archive/DotNet/microsoft.public.dotnet.languages.csharp/2007-11/msg00547.html

New release: DBIx::Class::ResultSet::Data::Pageset returns ...

This is a simple way to accept you to get a Data::Pageset object for paging rather than the standard Data::Page disapprove. Listed below are links to blogs that reference this entry: . TrackBack URL for this entry: http://perlbuzz com/cgi-bin/mt/mt-tb cgi/87 (If you haven't left a comment here before you may need to be approved by the site owner before your mention will appear. Until then it won't appear on the entry. Thanks for waiting.)

Forex Groups - Tips on Trading

Related article:
http://perlbuzz.com/cpan-watch/2007/09/new-release-dbixclassresultsetdatapageset-returns.html

about resultSet

I am writing a schedule in which I be to execute an SQL ask while processing results of an already executed query. But when I kill the 2nd query the resultSet object of the first one is lost. Is there some way to kill the 2nd query without loosing the resultSet of the first one. The requirements is that for both queries I have to use the same statement disapprove. Thanks. The requirements is that for both queries I have to use the same statement disapprove. No that's not a requirement that's the problem !? ( or gratify describe why... )Or you first alter the resultSet into an Object[ ][ ] arrange... By requirements I do not convey that it is a restriction imposed by the language or let say the clients. I simply wanted to know if we can do this task using same statement object the solution that I had in my mind was to keep a compose with you of the resultSet before executing the 2nd ask but I be to know some alternative. Thanks. Normally a jdbc driver works desire this:---Only one ResultSet per Statement can be open at any point in time. Therefore if the reading of one ResultSet is interleaved with the reading of another each must have been generated by different Statements. All statement kill methods implicitly close a statment's current ResultSet if an change state one exists.---You probably be to reuse the Connection settings ;) save your resultset to cachedresultset cachedresultset can command the produced resultset and alter the connection close so even if you use same statements to query your result in cachedresultset stays. I rather have the idea that you're not aware of the SQL capabilities of your database and that this all can just be done in 1 query. construe about Joins and if necessary Functions in the SQL manual of your DB. Otherwise you indeed have to map the ResultSet to something anonymous and reuseable. Collection<DTO> for example.

Forex Groups - Tips on Trading

Related article:
http://forum.java.sun.com/thread.jspa?threadID=5213411

about resultSet

I am writing a program in which I be to kill an SQL query while processing results of an already executed query. But when I execute the 2nd query the resultSet object of the first one is lost. Is there some way to kill the 2nd query without loosing the resultSet of the first one. The requirements is that for both queries I have to use the same statement object. Thanks. The requirements is that for both queries I have to use the same statement object. No that's not a requirement that's the problem !? ( or please exposit why... )Or you first fill the resultSet into an Object[ ][ ] array... By requirements I do not mean that it is a restriction imposed by the language or let say the clients. I simply wanted to experience if we can do this assign using same statement object the solution that I had in my mind was to keep a compose with you of the resultSet before executing the 2nd ask but I want to know some alternative. Thanks. Normally a jdbc driver works like this:---Only one ResultSet per Statement can be change state at any point in time. Therefore if the reading of one ResultSet is interleaved with the reading of another each must have been generated by different Statements. All statement execute methods implicitly change state a statment's current ResultSet if an change state one exists.---You probably be to reuse the Connection settings ;) save your resultset to cachedresultset cachedresultset can command the produced resultset and alter the connection change state so change surface if you use same statements to query your result in cachedresultset stays. I rather undergo the idea that you're not aware of the SQL capabilities of your database and that this all can just be done in 1 query. construe about Joins and if necessary Functions in the SQL manual of your DB. Otherwise you indeed have to map the ResultSet to something anonymous and reuseable. Collection<DTO> for example.

Forex Groups - Tips on Trading

Related article:
http://forum.java.sun.com/thread.jspa?threadID=5213411

ResultSet and Date problem

Hi,Can any one give reason for the following issue. I got the following lie of codeString outputTime =RS getString(fieldsTime get(z) toString());where RS is the ResultSet object and the column it is referring is go out in Oracle DBThe problem isin my environment outputTime is displayed as 22/08/2007 05:50:06in client environment outputTime is displayed as 2007-08-22 05:50:06.0which is creating problems for me what is the cerebrate for this one You can comfort show that in the environment specific change but when dealing with it (numerically ?) you are much better off with the correct data write instead of a arrange. I can do that but i be it in String and also i have to do some modifications on that after that line of label i just want to experience why that piece of code is behaving like that I can do that but i be it in arrange and also i haveto do some modifications on that after that line ofcode i just want to know why that conjoin of label isbehaving desire that I am guessing that you are getting different Strings for different locale settings. i just want to know why that piece of label is behaving desire that Because the user want to see dates in that change Perhaps they are not aware of this but that's java's impression ;)It's set in the current user's regional options. See java text. DateFormat to eventually override the user's preference by a different locale.

Forex Groups - Tips on Trading

Related article:
http://forum.java.sun.com/thread.jspa?threadID=5213079