Skip to Content

JCONNECT option check


In IQ 15.4 , is there anyway to verify if the database was initially  created with option JCONNECT set to ON or OFF( within create database command) using  any command or log files? We do not have the db  creation  script or a tool to reverse engineer .

I've checked some SPs and system tables but haven't found anything yet..

Thank you



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 14, 2016 at 09:46 AM

    Hi Jose,

    When Database is created with jConnect ON (Default) then database should contain jConnect metadata objects.

    As consequence, query below should return results.

    Tables/view :

    select * from systab where lower(table_name) like '%jdbc%'  ;


    select * from sysprocedure where lower(proc_name) like '%jdbc%' ;

    Example of objects in the result.

    Tables: jdbc_function_escapes, spt_jdbc_conversion, ..

    Procedures:  sp_jdbc_tables,  sp_jdbc_stored_procedures, ..

    If results are empty, then jConnect is OFF for this database.

    If you need to enable jConnect, connect to database as DBA and execute:


    alter database upgrade JCONNECT ON ;


    Execute the queries above to check if jConnect medatadata are installed.

    Hope this helps.

    Regards, Tayeb.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13, 2016 at 10:56 PM


    We can see the value in IQ12.7 as follows.

    > select PropName from sa_eng_properties() where PropName = 'IsJavaAvailable'

    But In ASA 11.0.1 (IQ 15.x) and later versions, Unsupported properties Support has been removed for the following properties:

    --Database properties:




    ---Database server properties:




    Gi-Sung  Jang

    Add comment
    10|10000 characters needed characters exceeded