Hi
This problem is not associated with JDBC instead this is problem
with SQL Server. Actually when you create resultset you have to fetch column
in same order in which they exist in resultset object. e.g following code
result in this error..
Resultset rs=stmt.executeQeury( "select name, address from client");
...
...address=rs.getString("address");
...name=rs.getString("name");
...
on the other hand code runs successfully.
Resultset rs=stmt.executeQeury( "select name, address from client");
...
...name=rs.getString("name");
...address=rs.getString("address");
...
----- Original Message -----
From: "sahaya ranialex" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 01, 2000 12:35 AM
Subject: jdbc error --invalid descriptor index
>
> Hi there,
>
> I am getting
> java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid
Descriptor
> Index
> at rs.getString("col_name");
> inside jsp code.
>
> The same code was successful when i was using MS Access.
>
> NOW i changed the url only for communicating with SQL server 7.0.
>
> i am using jdbc-odbc bridge.
>
> Does any one have any clue about this?
>
> Thanks.
> sahaya
>
>
>
> >From: "Moore, Jim" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: JRun-Talk <[EMAIL PROTECTED]>
> >Subject: RE: Multiple JRUN Servers-- HELP!!
> >Date: Thu, 30 Nov 2000 11:30:13 -0500
> >
> >we had a problem with this for a while here, but finally managed to solve
> >it. all you really have to do is be sure to not check "install as global
> >filter" when configuring the external web server. to fix things once we
had
> >screwed them up, i had to remove all the jrun.dll that were lying around
in
> >scripts directories, go into each web server as well as the global
> >properties for iis and remove all jrun isapi filters and mappigns. once
> >that
> >was all done, i re-configured each jrun server, being sure not to check
> >install as global filter. alos be sure to set different listening ports,
> >etc
> >for each jrun server in the properties file.
> >
> >--jim
> >
> >-----Original Message-----
> >From: Ajoy Singh [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, November 29, 2000 7:24 PM
> >To: JRun-Talk
> >Subject: Multiple JRUN Servers-- HELP!!
> >
> >
> >Hi,
> >I am trying to add multiple JRUN Servers on one box for development and
> >staging purposes.
> >The problem I am facing is as follows:
> >Scenario 1: One web Server IIS4.0 NT 4.0 SP6a, JRUN 3.0 SP1
> >JRUN Servers: Default and Staging
> >If I configure JRUN server to respond to external web server then
> >application
> >in one JRUN Server (Default) responds but other reports 404 Error.
> >
> >Scenario2: Two web servers bound to two ip addresses IIS4.0 NT 4.0 SP6a,
> >JRUN
> >3.0 SP1
> >Each web server has its own scripts directory.
> >If I configure first Default then Staging, Staging works fine. If I
> >configure
> >first Staging then Default, Default works fine.
> >
> >Allaire in there documentation mentions the need and eplains how to
install
> >multiple JRUN Servers but is silent on how to configure these multiple
> >JRUN
> >Servers to external web servers.
> >
> >Any help will be appreciated.
> >
> >
> >
> >
> >
> >Thanks,
> >Bob
> >
> >____________________________________________________________________
> >Get free email and a permanent address at http://www.amexmail.com/?A=1
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >Your ad could be here. Monies from ads go to support these lists and
> >provide
> >more resources for the community. http://www.fusionauthority.com/ads.cfm
> >
> >Archives: http://www.mail-archive.com/[email protected]/
> >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >Your ad could be here. Monies from ads go to support these lists and
> >provide more resources for the community.
> >http://www.fusionauthority.com/ads.cfm
> >
> >Archives: http://www.mail-archive.com/[email protected]/
> >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>
____________________________________________________________________________
_________
> Get more from the Web. FREE MSN Explorer download :
http://explorer.msn.com
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Your ad could be here. Monies from ads go to support these lists and
provide more resources for the community.
http://www.fusionauthority.com/ads.cfm
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
