JCONNECT option check

[jmtorres]

Hello,

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

Regards

Jose

[tayeb_hadjou · Accepted solution]

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%'  ;

procedures:

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:

commit;

alter database upgrade JCONNECT ON ;

commit;

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

Hope this helps.

Regards, Tayeb.

[jmtorres · Accepted solution]

Tayeb,

Thanks a lot

Regards

Jose

[Gisung]

Hi,

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:

JDKVersion

JavaHeapSize

JavaNSSize

---Database server properties:

IsJavaAvailable

JavaGlobFix

==

Gi-Sung  Jang

[jmtorres]

Gi-Sung  Jang

Thanks for the update!

Regards

Jose