NuoDB is a cloud-based distributed SQL server.
Questions tagged [nuodb]
42 questions
0
votes
1 answer
Spring Batch application sqlcode -4499 sqlstate 08001
Requirement:
Read from the file containing 100K records.
For each records, retrieve data from IBM DB2 database table and then retrieve data from NuoDB database table.
At last, insert the updated records in the NuoDB database table.
Design…
Pratim Singha
- 569
- 2
- 10
- 33
0
votes
1 answer
Will the SELECT Query be able to retrieve 200K records in Spring Batch
PROBLEM:
We have a below query to be triggered in a database that may have 200K records in TABLE.
SELECT a.* from TABLE a inner join ( SELECT f.COLUMN1, f.COLUMN2, f.COLUMN3, MAX(f.DATECOLUMN4) as LATEST_DATE FROM TABLE f WHERE f.DATECOLUMN5 >=…
Pratim Singha
- 569
- 2
- 10
- 33
0
votes
1 answer
Among the multiple columns in where clause, one column is not indexed - Nuo Database
Please consider a table "TABLE" in a NuoDB database that consists of 70 million records.
Also consider the columns present in the "TABLE" is column_1, columne_2, column_3, column_4 and column_5.
Among the above columns, column_1 is the Primary…
Pratim Singha
- 569
- 2
- 10
- 33
0
votes
1 answer
NuoDB Stored Procedure call with Multilevel Parameters from Java
Has anyone tried to call NuoDB Stored Procedure with Multilevel List Parameters from Java?
Any working example how to do it? Please share if anyone achieved this.
sanssan
- 305
- 1
- 3
- 12
0
votes
1 answer
Centos: Failed to start LSB: Start the NuoDB Admin
I've installed NuoDB on Centos 8 and I'm trying to start nuoadmin using this command in cmd:
sudo service nuoadmin start
but it throws error:
Starting nuoadmin (via systemctl): Job for nuoadmin.service failed
because the control process exited…
aasdwd
- 1
- 1
0
votes
2 answers
Is it possible to assign a value to already declared variable in NuoDB
Is it possible to assign a value to a variable in NuoDB after the variable is created.
I've tried:
VAR $test string;
$test = 'test';
But it says:
[Code: -1, SQL State: 42000] syntax error on line 1
$test = 'test'
^ expected statement got…
Sergey Ch
- 91
- 1
- 5
0
votes
1 answer
It is possible to configure Storage Manager(SM) and Archive directory location of SM in different machines?
Installed NuoDB 3.0 Linux version in one machine and while creating database it is possible to give archive directory location is Amazon s3 buckets storage ?
Here SM is running on one machine and archive location is pointing to Amazon s3…
Yellappa
- 403
- 1
- 5
- 16
0
votes
1 answer
Nuodb Memory and CPU usage reached high
While accessing NuoDB database from Java application, In Task manager tool getting CPU and Memory usage reached 99% almost and I tired with NUODB 2.4 ,2.5 and 2.6 versions but finally i am getting same issue.
Present my windows server hardware…
Yellappa
- 403
- 1
- 5
- 16
0
votes
2 answers
Update existing sequence values form starting with 1?
Can I update existing sequence values form staring with 1.
Example : In table one sequence column starting the sequence form 5001 but i want change that value form starting with 1.
If it is possible how can approach?
Yellappa
- 403
- 1
- 5
- 16
0
votes
1 answer
NuoDB setup on Docker for MacOS. Connection to NuoDB failed. [08S01] Could not connect to any host
I have set up NuoDB locally using docker image.
It works fine and I can access a database console and run queries by accessing http://localhost:8888/explorer.jsp.
But when I'm trying to connect to the database using JDBC I got error:
Connection to…
Bullet-tooth
- 782
- 1
- 10
- 16
0
votes
1 answer
nuodb sql syntaxe validator
I need an online nuodb sql query syntax validator. I searched online but didn't find anything good.
Xiayidan Alimu
- 1
- 1
- 2
0
votes
1 answer
How to restart nuodb managed database after OS crash
I'm using nuodb-ce 2.4
I created a empty managed database (called testdb) using automation console (template Single Host), however when OS crash (or restart) database disappear.
I checked ls /var/opt/nuodb/production-archives/testdb/
1.atm 12.cat …
Kakawait
- 3,929
- 6
- 33
- 60
0
votes
1 answer
Failed to create database issue with 2.4.1.2. version?
hen creating database in middle of the process giving the archive directory path then finally i will submit the button and i will get the below issue :
Failed to introduce local node: Starting process [Node SM db=[SampleSuiteDev] pid=4064 id=-1…
Yellappa
- 403
- 1
- 5
- 16
0
votes
1 answer
Nuodb - is there encryption option for data storage?
Is encryption supported within nuodb?
I was trying to get that from manaual.
I need to fulfill some security requirements -> encryption.
profesor79
- 9,213
- 3
- 31
- 52
0
votes
1 answer
How do I restart a NuoDB database?
How do I start the Community edition of NuoDB (on any of the supported systems: Linux, Windows, MacOS, EC2, Ubuntu)
http://dev.nuodb.com/download-nuodb/request/download
Tracy Chen
- 21
- 1