Questions tagged [tibero]

Tibero is the name of a relational databases and database management system utilities produced and marketed by TIBERO Corporation, part of South Korean owned TmaxSoft.

Tibero is the name of a relational databases and database management system utilities produced and marketed by TIBERO Corporation, part of South Korean owned TmaxSoft.

12 questions
1
vote
0 answers

when i connect unixodbc with node odbc 2.4.6 show "Segmentation fault (core dumped)"

I use OS ubuntu 18,node.js 14, unixodbc from doc Ubuntu/Debian: sudo apt-get install unixodbc unixodbc-dev. I can connect to database tibero with isql Tibero6 +---------------------------------------+ | Connected! | | …
1
vote
0 answers

How to resolve "JDBC-5072:Failure converting NUMBER to or from a native type" error in tibero?

We are getting two different execution response for the same kind of scripts in Tibero. It Accepts the below script without any error: Insert into ABCD(LINKNAME,NAME,VALUE) values…
0
votes
1 answer

SELECT COUNT query with many left JOIN clause is taking too long

This is the query to count the rows only SELECT COUNT(*) FROM INTERFACES.EAI_DJA_PAGU A LEFT JOIN INTERFACES.EAI_DJA_SATKER B ON B.KDSATKER = A.KDSATKER LEFT JOIN INTERFACES.EAI_DJA_UNIT C ON C.KDUNIT = A.KDUNIT LEFT JOIN…
Raymond Natio
  • 556
  • 3
  • 22
0
votes
0 answers

Spring Data JPA repository retrieves Entity with IdClass composite key as null from DB

I think the repository can read the records within the DB as requested (can count the records that meets the where clause condition) but there is a problem mapping the retrieved records into Entity. Here is my…
0
votes
0 answers

Is schema equivalent to user in tibero db like it is for oracle?

We have to initialize our application by pointing it to the current catalog and schema. Would it be appropriate to initialize it by pointing it to the current DB and user (from the current JDBC connection) respectively?
Dipankar Dey
  • 105
  • 1
  • 8
0
votes
1 answer

Tibero Create Database TBR-7067: Specified database name 'dbnewproj' doest not match parameter database name int tip file 'tibero'

I'm new to this Tibero database, the installation of this to a docker container is interesting. But upon creating a new database, that's where I'm struggling now. I'm trying to create a separate, new tibero database which we'll be using for a new…
leipzy
  • 11,676
  • 6
  • 19
  • 24
0
votes
1 answer

DatabaseType not found for product name: [Tibero]

While trying to setup a Spring boot - spring batch project, I am running into an error stating: I have checked the spring batch supported database but Tibero is not in the list. Is there any other way to make this work with pointing Tibero DB...…
0
votes
0 answers

how to replace java.sql.sqldata as it's unsupported in tibero

as java.sql.sqldata is not supported in tibero jdbc driver, we'd like to know how to modify it or any replacement is java.sql.Array a replacement of java.sql.sqldata? there's no code so far if we implement java.sql.sqldata in tibero, we will hit…
Joe Yang
  • 23
  • 6
0
votes
0 answers

What is the difference between odbcparameter and oledbparameter when adding char type values?

I'm migrating from Oracle to Tibero database using C#. Issue is when adding parameter of "CHAR" type using OleDbParameter, data can not be retrieved unless it is filled with following spaces according to DB column size. (Using OracleParameter or…
0
votes
1 answer

Multiple tables join and applying case when

I am trying to use case when phrase to change the result value while joining multiple tables. SELECT CASE WHEN CENSUS = '0' THEN 'SP_CENSUS0' END AS SP_RESULT FROM SP SELECT CASE WHEN CENSUS = '0' THEN 'SR_CENSUS0' END AS SR_RESULT FROM SR SP …
user8574635
0
votes
1 answer

How To make a branch Connect by's condition in Sql

Hi I am trying to make a query which draws the full call-graph of a code. the table's columns are caller class, caller method, callee class, callee method but some of callee classes starts with un-necessery words. so when it detected, I have to…
Ui-Gyun Jeong
  • 143
  • 1
  • 4
  • 14
0
votes
1 answer

How create oracle type object in tibero database

How in tibero databse create type object, here code of oracle Create or Replace Type tst_type As Object( param1 VarChar2(4000), param2 VarChar2(10), Static Function statfunc1 ( sctx In Out tst_type ) Return Number, Member Function memberfunc1 (…
ExcepOra
  • 117
  • 9