Pratik Thaker

Greenhorn
+ Follow
since Mar 12, 2015
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
1
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Pratik Thaker

We are trying to use Josso2 2.4.3 (installed by josso-ce-2.4.3-34-windows.jar) with oracle 18c. That means we have copied ojdbc8.jar to josso2/lib/jdbc folder We are using it with apache tomcat 8.0.27

We have provided connection parameters and authentication queries to the appliance added using josso UI.

But whenever user it trying to login, we are getting below exception in atricore.log

3 weeks ago
Can anyone please provide solution for this ?
Hi,

Is there a way to create typable combobox in the excel file (XLSX) using JAVA, where values will get filtered as user types ?

We are using Apache POI, we are able to show combobox but it is not typable. So is it possible to do it using POI or should we use any other library ?

Regards,
Pratik Thaker
Thanks Karthik for the reply.

So let me answer the question why I can't use Oracle for searching.
1. Since there are lot of insert / updates, Indexing columns will slow them down. Insert / Update is having higher priority in my case.
2. I am not sure if Oracle Text search will provide faster result then any other tool. Also will it allow joins and Like and range based search.
3. I am not sure what will be the infrastructural cost to replicate current database. Right now the DataBase VM is having more than 5 TB of disk space (More than 3.5 TB is already occupied by tables), 98 GB RAM, 8 CPU

Should I also consider evaluating ElastiSearch, Cassandra etc ?
Hi,

I am using Oracle 11g2 and we are having a schema where few tables are having more than 100 million rows (some of them are Varchar2 100 bytes). And we have to frequently do the LIKE based search on those tables. Sometimes we need to join the tables also. Insert / Updates are also happening very frequently for such tables (1000 insert / updates per second) by other applications.

So my question is, for my User Interface, should I use Apache Solr to let user search on these tables instead of SQL queries? I have tried SQL and it is really slow (considering amount of data I am having in my database).

My requirements are,

Result should come faster and it should be accurate.
It should have the latest data.
Can you suggest if I should go with Apache Solr, or another solution for my problem ?

Regards,
Pratik Thaker