You can't perform another db operation while you are getting rows.
This is a limitation of the driver that I hope will be addressed.
I'm still hopefull that I will be able to come up with a couple
thousand dollars for anyone willing to rewrite/update the Informix
driver, but I thought that almost a year ago also.
Keith
|
|Hi Keith,
|
|I have question about ns_db getrow. When I try to use multiple cursors, I
|get the error message. Did you use multiple cursors? Does Informix driver
|supports these?
|
|Here are the details about my code and error message:
|
|My code looks like:
|.
|.
|foreach { db0 db1 } [ns_db gethandle informix_pool 2] {}
|....
|...
|..
|set row [ns_db select $db0 "select first 5 * from TABLE_X"]
|while { [ns_db getrow $db0 $row] ==1 } {
| ...
| ...
| set sysnm [ns_set value [ns_db 0or1row $db1 "select sys_nm from TABLE_Y
|where sys_id = '6';"]]
| ...
| ...
| ...
| }
|
|ERROR:
|02/Dec/2002:10:04:08][2205.382][-conn26-] Error: [IX000] (-480) A descriptor
|with the same name already exists.
|[02/Dec/2002:10:04:08][2205.382][-conn26-] Error: dbinit:
|error(dbname_tcp:dbname,A descriptor with the same name already exists.):
|
|Any idea?
|
|Thanks a lot, Keith
|
|-Durga
|
|-----Original Message-----
|From: AOLserver Discussion [mailto:[EMAIL PROTECTED]]On Behalf
|Of Keith paskett
|Sent: Friday, November 22, 2002 4:52 PM
|To: [EMAIL PROTECTED]
|Subject: Re: [AOLSERVER] Informix Drivers
|
|
||
||Keith,
||
||It works geat!!..I re-configured the AOL web server to look at Internal
||driver (iusid.so). Right now, I am able to access the data from Informix
||database. I have a question, though. Can I use all ns_** functions that
||provided by AOL web server? I have a error message when I tried to use
||ns_getrow function. Any ideas?
|
|
|Is ns_getrow new to 3.5, or did you mean ns_db getrow? I'm using 3.3 and
|ns_db getrow works fine.
|
|----
|set selection [ns_db select $db "select * from test_tab"]
|
|while { [ns_db getrow $db $selection] } {
| #Data is in the ns_set $selection
| ...
|}
|----
|
|-Keith
|
||
||Thanks a lot!..I really appreciate your help.
||
||-Durga
||
||
||-----Original Message-----
||From: AOLserver Discussion [mailto:[EMAIL PROTECTED]]On Behalf
||Of Keith Paskett
||Sent: Thursday, November 21, 2002 6:09 PM
||To: [EMAIL PROTECTED]
||Subject: Re: [AOLSERVER] Informix Drivers
||
||
||For what it's worth I never got the external driver working.
||I don't remember what the issues were but I didn't spend much
||time on it because I really wanted the internal driver iusid.so
||
||Keith
||
||On Thu, Nov 21, 2002 at 10:06:55AM -0700, Durga wrote:
||> Thanks, Keith, Pete.
||>
||> Here is the information about my system:
||>
||> * Operating System: SunOS 5.7 Generic_106541-18 sun4u sparc SUNW,Ultra-1
||> * Informix: Informix Dynamic Server Version 9.30.UC3 -- On-Line -- Up
||1
||> * AOL server: 3.5
||> * tcl: 8.4b2
||> * AOL server and Informix are on same machine.
||>
||> I have checked the /etc/services and $INFORMIXDIR/etc/sqlhosts,
|everything
||> is set as you mentioned.
||>
||> nsd.tcl - AOL config file:
||>
||> # Database drivers
||> ns_section "ns/db/drivers"
||> ns_param informix_driver nsext.so;
||>
||> ns_section "ns/db/driver/informix_driver"
||> ns_param localdaemon iuspd;
||>
||> ns_section "ns/db/pools"
||> ns_param informix_pool "Informix Pool";
||>
||> ns_section "ns/db/pool/informix_pool"
||> ns_param driver informix_driver
||> ns_param datasource pmdb_tcp:pmdb
||> ns_param user www
||> ns_param password ******
||> ns_param connections 1
||> ns_param logsqlerrors true
||> ns_param verbose false
||> ns_param maxidle 600
||> ns_param maxopen 3600
||>
||> ns_section "ns/server/${servername}/db"
||> ns_param pools *
||> ns_param defaultpool informix_pool
||>
||> Also, in aolserver bin directory:
||> /users/WWW/AOL/aolserver_3.5$ ls -l bin
||> -rw-r--r-- 1 www www 2255 Oct 24 14:18 install-sh
||> -rwxrwxrwx 1 www www 30989 Nov 19 23:38 iusid.so
||> -rwxrwxrwx 1 www www 2124918 Nov 19 23:39 iuspd
||> -rwxrwxrwx 1 www www 115928 Oct 24 14:19 nscgi.so
||> -rwxrwxrwx 1 www www 95296 Oct 24 14:19 nscp.so
||> -rwxrwxrwx 1 www www 81724 Oct 24 14:19 nsd
||> -rwxrwxrwx 1 www www 143344 Oct 24 14:19 nsext.so
||> -rwxrwxrwx 1 www www 99016 Oct 24 14:19 nslog.so
||> -rwxrwxrwx 1 www www 116724 Oct 24 14:19 nsperm.so
||> -rwxrwxrwx 1 www www 102344 Oct 24 14:19 nssock.so
||> -rwxrwxrwx 1 www www 96000 Oct 24 14:18 nsthreadtest
||> -rwxr-xr-x 1 www www 6540 Oct 21 14:45 tclsh8.4
||> -rwxrwxrwx 1 www www 7388 Nov 4 16:35 wish8.4
||>
||> Is byte size looks normal for both "iusid.so" and "iuspd"? I did have
|some
||> problem while I was compiling this driver software, but they were just
||> syntax error's so changed them and then installation completed
||successfully.
||> I have used "gcc" and "gmake" to compile.
||>
||> I don't think it's a "gmake" problem. I already fixed that.
||>
||> -Durga
||>
||> -----Original Message-----
||> From: AOLserver Discussion [mailto:[EMAIL PROTECTED]]On Behalf
||> Of Keith paskett
||> Sent: Thursday, November 21, 2002 8:31 AM
||> To: [EMAIL PROTECTED]
||> Subject: Re: [AOLSERVER] Informix Drivers
||>
||>
||> Durga,
||>
||> It would help to know what your configuration is.
||> What version of Informix? Is it installed locally. How are you
||> authenticating
||> the user.
||>
||> Here's the configuration that works for me (Solaris 8 & 9).
||>
||> I'm accessing a remote Informix with the informix client software
||> installed in /usr/local/informix. I don't think the configuration
||> changes much if Informix is installed on the same box as AOLserver.
||> Unfortunately the Informix client software does not come with any way
||> to test the connection. So if you are accessing a remote server, it
||> is hard to know if failures are due to the AOLserver Informix driver
||> or the client installation / configuration.
||>
||> In /etc/services, you should have something like
||> soc1 1525/tcp #Informix data do not
||remove
||>
||> In /usr/local/informix/etc/sqlhosts, something like:
||> ids_eo_sun ontlitcp informixhost.your.domain soc1
||>
||> I'm running ACS which uses Oracle but have hacked the ACS code so I can
||> access other databases (Informix and PostgreSQL) without interfering
||> with the way ACS gets database handles.
||>
||> Relevant sections of the AOS config file:
||>
||> -----
||> # Datasource is of the form "connection:database"
||> # where connection is from /usr/local/informix/etc/sqlhosts
||> # User and Password are not used to authenticate (in our Informix setup)
||> # The user that AOLserver is running as needs to be authenticated
||> # in oracle without prompting for username and password.
||> ns_section ns/db/pool/noacs_eoffice
||> ns_param Driver informix
||> ns_param Connections 3
||> ns_param DataSource "ids_eo_sun:eoffice"
||> ns_param User nsadmin
||> ns_param Password bogus
||> ns_param Verbose Off
||> ns_param LogSQLErrors On
||>
||> ns_section ns/db/pools
||> ns_param main main
||> ns_param subquery subquery
||> ns_param log log
||> ns_param noacs_pg1 noacs_pg1
||> ns_param noacs_eoffice noacs_eoffice
||>
||> ns_section ns/server/$servicename/db
||> ns_param Pools main,subquery,log,noacs_pg1,noacs_eoffice
||> ns_param DefaultPool main
||>
||> -----
||>
||> Since I'm using ACS, I've written procedures that match the functionality
||> of the ACS db_* procs and my test.tcl looks like the following.
||> Just use the ns_db procs instead of my nadb_* procs.
||>
||> --
||> if [catch {ns_db gethandle noacs_eoffice} db] {
||> set eoffice_avail 0
||> } else {
||> set eoffice_avail 1
||> }
||>
||> if {$eoffice_avail} {
||> set sql "select value from test_table where id = 1"
||> nadb_string $db $sql -default ""
||> } else {
||> ...
||> }
||>
||> --
||>
||> I'm only able to use one db hanldle in a page. You can get two handles
||> but you can't do an 'ns_db select' with handle2 in a loop that is using
||> 'ns_db getrow' to retrieve rows from an 'ns_db select' that used handle1.
||>
||>
||> Hope this helps.
||> Keith
||>
||>
||> |
||> |Now I have different ERROR message:
||> |
||> |************************
||> |invoked from within chunk: 0 of adp: /pub/Pages/PM/TCL/web_example.adp
||> |[20/Nov/2002:15:24:34][1753.10][-keepalive-] Notice: keepalive:
|keepalive
||> |thread starting
||> |[20/Nov/2002:17:16:24][1753.25][-conn1-] Notice: dbdrv: opening database
||> |'informix_driver:pmdb_tcp:pmdb'
||> |[20/Nov/2002:17:16:25][1753.25][-conn1-] Error: exec: process 6534
|exited
||> |from signal: 11
||> |[20/Nov/2002:17:16:25][1753.25][-conn1-] Error: exec: process 6534
|dumped
||> |core
||> |[20/Nov/2002:17:16:25][1753.25][-conn1-] Error: dbdrv: failed to open
||> |database 'informix_driver:pmdb_tcp:pmdb'
||> |[20/Nov/2002:17:16:25][1753.25][-conn1-] Error:
||> |could not allocate 1 handle from pool "informix_pool"
||> | while executing
||> |"ns_db gethandle"
||> | invoked from within chunk: 0 of adp:
||/pub/Pages/PM/TCL/web_example.adp
||> |*************************
||> |
||> |Any ideas?
||> |
||> |Thanks
||> |-Durga
||> |
||> |-----Original Message-----
||> |From: Durga [mailto:[EMAIL PROTECTED]]
||> |Sent: Wednesday, November 20, 2002 3:57 PM
||> |To: AOLserver Discussion
||> |Subject: RE: [AOLSERVER] Informix Drivers
||> |
||> |
||> |Thanks, Doosy.
||> |
||> |I did compile and install the driver software for Informix, and
||configured
||> |the AOLserver config file - nsd.tcl. However, I am not able to connect
|to
||> |database. I get the error message as: "ns_db is not enabled"
||> |
||> |Any ideas?
||> |
||> |Thanks,
||> |-Durga
||>
||> ------
||> Keith Paskett [EMAIL PROTECTED]
||> Space Dynamics Laboratory PGP or GPG encrypted mail preferred
||> 1695 North Research Parkway 435-797-4195
||> Logan, Utah 84341
|
|------
|Keith Paskett [EMAIL PROTECTED]
|Space Dynamics Laboratory PGP or GPG encrypted mail preferred
|1695 North Research Parkway 435-797-4195
|Logan, Utah 84341
------
Keith Paskett [EMAIL PROTECTED]
Space Dynamics Laboratory PGP or GPG encrypted mail preferred
1695 North Research Parkway 435-797-4195
Logan, Utah 84341
