2

My Intersystem IRIS database contains multiple schema i.e. Each Developer has his own Schema. While accessing database from Spring boot application I am getting following error:

 [SQLCODE: <-30>:<Table or view not found>]\r\n[Location: <Prepare>]\r\n[%msg: < Table 'SQLUSER.ACCOUNT' not found>]; nested exception is java.sql.SQLException: [SQLCODE: <-30>:<Table or view not found>]\r\n[Location: <Prepare>]\r\n[%msg: < Table 'SQLUSER.ACCOUNT' not found>]"

This is due to that fact that I am not able to specify schema before table name. If I hard code it as schema.table_name in code then the code is working fine.

Is there any way to set this Schema at global level through properties files for mybatis.

Evgeny Shvarov
  • 468
  • 5
  • 17
DALJIT SINGH
  • 111
  • 1
  • 11
  • Aren't you supposed to specify it in the JDBC URL? According to the [documentation](https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=BJAVA_connecting#BJAVA_connecting_url_req), the URL syntax is ` jdbc:IRIS://:/` and the `` would be the part where you specify your 'schema'. – ave Jan 13 '21 at 05:00
  • here namespace refer to database name.. but I am taking about Schema name – DALJIT SINGH Jan 13 '21 at 06:25

1 Answers1

0

Unfortunately, there is no way to specify a current schema for the session. In InterSystems products supposed to use schema names all the time in all queries. And default schema for the whole system can be changed in settings.

DAiMor
  • 3,185
  • 16
  • 24