I'm trying to use jRemote from C#. I can get a JSelectList to work
fine. If I try to use the createStatement and execute to produce a
jResultSet I get a null returned from the rs.getRow().
The documentation is limited with no examples so I guess it could be
the syntax of the select command!
We're using TAFC 9.0.0.11 with the excerpt of code below:
com.jbase.jremote.DefaultJConnectionFactory dcf;
com.jbase.jremote.JConnection con;
com.jbase.jremote.JStatement stmt;
com.jbase.jremote.JResultSet rs;
com.jbase.jremote.JDynArray row;
com.jbase.jremote.JFile file;
com.jbase.jremote.JSelectList jsl;
dcf = new DefaultJConnectionFactory();
dcf.Host = "xxx";
dcf.Port = 20002;
con = dcf.getConnection();
int i = 0;
try
{
stmt = con.createStatement();
stmt.setFetchSize(10);
rs = stmt.execute("SELECT F.USER USER.NAME @ID");
row = rs.getRow(); // row ends up null even though
there are plenty records...
while (rs.next())
{
row = rs.getRow();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.ToString());
}
return;
Below is the output from jDiag
jdiag - jBASE diagnostic '$Revision: 1.15 $'
System Information
==================
System : AIX cs7276-2 3.5 00C01E1E4C00
OS Release : 5.3.10.0
UNIX User : g371553 (uid 1028, euid 1028)
Tty name : /dev/pts/9
Time : Fri Oct 1 12:08:12 2010
Environment
===========
JBCPORTNO : Not Set
JBCRELEASEDIR : '/tafc/tafc9.0.0.11'
JBCGLOBALDIR : '/tafc/tafc9.0.0.11'
WARNING: JBCDATADIR is not set, Default '/tafc/tafc9.0.0.11/
jbase_data'
WARNING: JBCDATADIR is subdirectory of JBCGLOBALDIR
HOME : '/globus/gtis/bnk/bnk.run'
JEDIFILEPATH : '/globus/gtis/bnk/bnk.run'
JEDIFILENAME_MD : 'VOC'
JEDIFILENAME_SYSTEM : '/tafc/tafc9.0.0.11/src/SYSTEM'
SYSTEM File is (DICT) : '/tafc/tafc9.0.0.11/src/SYSTEM]D'
RELEASE Information : Major 09.0 , Minor 0.11 , Patch (Change
89884)
Spooler dir (JBCSPOOLERDIR) : '/jbase/jspooler'
JBCEMULATE : 'prime'
WARNING: Cannot access Executable path '/home/g371553/bin', error 2
Object path (JBCOBJECTLIST) : '/globus/gtis/bnk/bnk.run/
globuspatchlib:/globus/gtis/bnk/bnk.run/t24lib:/globus/gtis/bnk/
bnk.run/gdusgaaplib:/tafc/tafc9.0.0.11/lib:/globus/gtis/bnk/bnk.run/
lib:/globus/gtis/bnk/bnk.run/amllib:/globus/gtis/bnk/bnk.run/ibanlib'
jBASE Compiler Run-time : '/tafc/tafc9.0.0.11/config/
system.properties'
Program dir (JBCDEV_BIN) : '/globus/gtis/bnk/bnk.run/bin'
Subroutine dir (JBCDEV_LIB) : '/globus/gtis/bnk/bnk.run/lib'
Max open files : 65534
--
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to
Globus/T24
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
