Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    Pakistan
    Posts
    17

    Unanswered: -354 Incorrect database or cursor name format.

    Hello All,


    I am using IBM informix type 4 JDBC driver and Informix Dynamic Server Version 7.31.UD1 Installed on RedHat 7.2

    Please let me know why I am getting this error "Incorrect database or cursor name format"

    Please let me know if any other information required.

    Thanks in advance.
    Istikhar Ahmad
    ------------------
    Tel: (92-42) 111000911
    iahmad@i2cinc.com
    http://www.i2cinc.com

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    You should post the name of your INFORMIXSERVER,
    your database name and your JDBC Connect URL.

    This might help us solving the problem.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  3. #3
    Join Date
    Sep 2002
    Location
    Pakistan
    Posts
    17
    Thanks for the reply.

    Here is the JDBC URL:
    String url = "jdbc:informix-sqli://linux:1537:informixserver=ids_tsi;database=fastcas h;user=informix;password=informix";

    Infromix setting in LINUX are:
    ----------------------------------
    ----------------------------------


    1) Profile Entry.

    INFORMIXDIR=/u/informix;export INFORMIXDIR
    INFORMIXSERVER=ids_tsi;export INFORMIXSERVER
    ONCONFIG=onconfig_tsi;export ONCONFIG
    TERMCAP=/u/informix/etc/termcap ;export TERMCAP
    PATH=$PATH:$INFORMIXDIR/bin:.; export PATH
    #echo $PATH|grep -q $INFORMIXDIR/bin || PATH=$INFORMIXDIR/bin:$PATH; export PATH

    2) Onconfig File settings are
    ----------------------------------
    ----------------------------------

    #************************************************* *************************
    #
    # INFORMIX SOFTWARE, INC.
    #
    # Title: onconfig.std
    # Description: Informix Dynamic Server Configuration Parameters
    #
    #************************************************* *************************

    # Root Dbspace Configuration

    ROOTNAME rootdbs # Root dbspace name
    ROOTPATH /u/ids_space/rootdbs # Path for device containing root dbspace
    ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
    ROOTSIZE 2090000 # Size of root dbspace (Kbytes)

    # Disk Mirroring Configuration Parameters

    MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
    MIRRORPATH # Path for device containing mirrored root
    MIRROROFFSET 0 # Offset into mirrored device (Kbytes)

    # Physical Log Configuration

    PHYSDBS rootdbs # Location (dbspace) of physical log
    PHYSFILE 10000 # Physical log file size (Kbytes)

    # Logical Log Configuration

    LOGFILES 500 # Number of logical log files
    LOGSIZE 1000 # Logical log size (Kbytes)

    # Diagnostics

    MSGPATH /u/informix/online.log # System message log file path
    CONSOLE /dev/console # System console message path
    ALARMPROGRAM /u/informix/etc/log_full.sh # Alarm program path
    SYSALARMPROGRAM /u/informix/etc/evidence.sh # System Alarm program path
    TBLSPACE_STATS 1

    # System Archive Tape Device

    #TAPEDEV /dev/null # Tape device path
    TAPEDEV /u/bkup/data.bak # Tape device path
    TAPEBLK 128 # Tape block size (Kbytes)
    TAPESIZE 40960000 # Maximum amount of data to put on tape (Kbytes)

    # Log Archive Tape Device

    LTAPEDEV /u/bkup/llog.bak # Tape device path
    #LTAPEDEV /u/bk/llog.bak # Log tape device path
    LTAPEBLK 128 # Log tape block size (Kbytes)
    LTAPESIZE 40960000 # Max amount of data to put on log tape (Kbytes)

    # Optical

    STAGEBLOB # Informix Dynamic Server/Optical staging area

    # System Configuration

    SERVERNUM 1 # Unique id corresponding to a Dynamic Server instance
    DBSERVERNAME ids_tsi # Name of default database server
    DBSERVERALIASES ids_net_tsi # List of alternate dbservernames
    NETTYPE ipcshm,1,16,CPU # Configure poll thread(s) for nettype
    NETTYPE soctcp,1,16,NET # Configure poll thread(s) for nettype
    DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
    RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)

    MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor
    NUMCPUVPS 1 # Number of user (cpu) vps
    SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps to one

    NOAGE 0 # Process aging
    AFF_SPROC 0 # Affinity start processor
    AFF_NPROCS 0 # Affinity number of processors

    # Shared Memory Parameters

    LOCKS 100000 # Maximum number of locks
    BUFFERS 4000 # Maximum number of shared buffers
    NUMAIOVPS # Number of IO vps
    PHYSBUFF 64 # Physical log buffer size (Kbytes)
    LOGBUFF 64 # Logical log buffer size (Kbytes)
    LOGSMAX 500 # Maximum number of logical log files
    CLEANERS 1 # Number of buffer cleaner processes
    SHMBASE 0x82000000 # Shared memory base address
    SHMVIRTSIZE 8000 # initial virtual shared memory segment size
    SHMADD 8192 # Size of new shared memory segments (Kbytes)
    SHMTOTAL 128000 # Total shared memory (Kbytes). 0=>unlimited
    CKPTINTVL 300 # Check point interval (in sec)
    LRUS 8 # Number of LRU queues
    LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
    LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
    LTXHWM 50 # Long transaction high water mark percentage
    LTXEHWM 60 # Long transaction high water mark (exclusive)
    TXTIMEOUT 0x12c # Transaction timeout (in sec)
    STACKSIZE 32 # Stack size (Kbytes)

    # System Page Size
    # BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
    # To determine the page size used by Dynamic Server on your platform
    # see the last line of output from the command, 'onstat -b'.


    # Recovery Variables
    # OFF_RECVRY_THREADS:
    # Number of parallel worker threads during fast recovery or an offline restore.
    # ON_RECVRY_THREADS:
    # Number of parallel worker threads during an online restore.

    OFF_RECVRY_THREADS 10 # Default number of offline worker threads
    ON_RECVRY_THREADS 1 # Default number of online worker threads

    # Data Replication Variables
    # DRAUTO: 0 manual, 1 retain type, 2 reverse type
    DRAUTO 0 # DR automatic switchover
    DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
    DRTIMEOUT 30 # DR network timeout (in sec)
    DRLOSTFOUND /u/informix/etc/dr.lostfound.tsi # DR lost+found file path

    # CDR Variables
    CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
    CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
    CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
    CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)

    # Backup/Restore variables
    BAR_ACT_LOG /tmp/bar_act.log
    BAR_MAX_BACKUP 0
    BAR_RETRY 1
    BAR_NB_XPORT_COUNT 10
    BAR_XFER_BUF_SIZE 31

    # Informix Storage Manager variables
    ISM_DATA_POOL ISMData # If the data pool name is changed, be sure to
    # update $INFORMIXDIR/bin/onbar. Change to
    # ism_catalog -create_bootstrap -pool <new name>
    ISM_LOG_POOL ISMLogs

    # Read Ahead Variables
    RA_PAGES 2 # Number of pages to attempt to read ahead
    RA_THRESHOLD # Number of pages left before next group

    # DBSPACETEMP:
    # Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
    # that the Dynamic Server SQL Engine will use to create temp tables etc.
    # If specified it must be a colon separated list of dbspaces that exist
    # when the Dynamic Server system is brought online. If not specified, or if
    # all dbspaces specified are invalid, various ad hoc queries will create
    # temporary files in /tmp instead.

    DBSPACETEMP tempdbs # Default temp dbspaces

    # DUMP*:
    # The following parameters control the type of diagnostics information which
    # is preserved when an unanticipated error condition (assertion failure) occurs
    # during Dynamic Server operations.
    # For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

    DUMPDIR /tmp # Preserve diagnostics in this directory
    DUMPSHMEM 1 # Dump a copy of shared memory
    DUMPGCORE 0 # Dump a core image using 'gcore'
    DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic Server)
    DUMPCNT 1 # Number of shared memory or gcore dumps for
    # a single user's session

    FILLFACTOR 90 # Fill factor for building indexes

    # method for Dynamic Server to use when determining current time
    USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)

    # Parallel Database Queries (pdq)
    MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
    DS_MAX_QUERIES # Maximum number of decision support queries
    DS_TOTAL_MEMORY # Decision support memory (Kbytes)
    DS_MAX_SCANS 1048576 # Maximum number of decision support scans
    DATASKIP off # List of dbspaces to skip

    OPTCOMPIND 2 # To hint the optimizer

    ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
    LBU_PRESERVE 0 # Preserve last log for log backup
    OPCACHEMAX 0 # Maximum optical cache size (Kbytes)

    # HETERO_COMMIT (Gateway participation in distributed transactions)
    # 1 => Heterogeneous Commit is enabled
    # 0 (or any other value) => Heterogeneous Commit is disabled
    HETERO_COMMIT 0

    # Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
    OPT_GOAL -1

    # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
    DIRECTIVES 1

    # Status of restartable restore
    RESTARTABLE_RESTORE off
    CDR_LOGDELTA 30 # % of log space allowed in queue memory
    CDR_NUMCONNECT 16 # Expected connections per server
    CDR_NIFRETRY 300 # Connection retry (seconds)
    CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)


    Please help me out of this problem.
    Istikhar Ahmad
    ------------------
    Tel: (92-42) 111000911
    iahmad@i2cinc.com
    http://www.i2cinc.com

  4. #4
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    Your JDBC connection string seems to be
    incorrect:

    jdbc:informix-sqli://linux:1537:informixserver=ids_tsi;database=fastcas
    h;user=informix;password=informix

    The correct format is:

    jdbc:informix-sqli://ip_or_hostnameortnum/dbname: INFORMIXSERVER=servername;user=username;password=y ourpassword

    Check the IFMX JDBC documentation manual at:

    http://www-3.ibm.com/software/data/i...ry/jdbc_2.html

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •