Stack Overflow
Stack Overflow

Questions tagged [nuodb]

NuoDB is a cloud-based distributed SQL server.

42 questions
212
votes
5 answers

How do you manually execute SQL commands in Ruby On Rails using NuoDB

I'm trying to manually execute SQL commands so I can access procedures in NuoDB. I'm using Ruby on Rails and I'm using the following command: ActiveRecord::Base.connection.execute("SQL query") The "SQL query" could be any SQL command. For example,…
Patrick Angodung
  • 4,625
  • 3
  • 14
  • 18
3
votes
2 answers

Could not determine Hibernate dialect for database name [NuoDB]!

I am trying to build a groovy project based on gorm, with NuoDB. But getting this error - Could not determine Hibernate dialect for database name [NuoDB]! The weird thing is that it works with mysql. So my initial suspect was database configuration…
shashi009
  • 720
  • 6
  • 23
3
votes
1 answer

Writing servlet using NuoDB

I am novice in using NuoDB. I've a task to redo my servlet-application to it can use NuoDB data base. So, this is my new doGet servlet method: protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException,…
pragmus
  • 3,513
  • 3
  • 24
  • 46
3
votes
1 answer

invalid UTF-8 code sequence

I'm trying to do a simple connect using a NuoDB database - import pynuodb connection = pynuodb.connect("DB", "servername", "adminaccount", "password", options={'schema': 'schemaname'}) cursor = connection.cursor() thedata = open('file.pdf',…
whoisearth
  • 4,080
  • 13
  • 62
  • 130
2
votes
1 answer

Hikari complains "Property user does not exist on target class: com.nuodb.jdbc.DataSource"

In my ubuntu, I successfully installed and developed JHipster Book Store application. Here, I preferred MySQL as database. Now, I am trying to connect to NuoDB (database) on JHipster. I had to face challenges which I resolved while connecting to…
user4398985
2
votes
1 answer

Calling Database Procedure From Ruby on Rails

I'm developing an application using Ruby on Rails and NuoDB and I'm trying to CALL procedures from the database. I'm testing it using the Rails console but I'm only getting a "TRUE" response when I call it using the following…
Patrick Angodung
  • 4,625
  • 3
  • 14
  • 18
2
votes
1 answer

Nuodb and HDFS as storage

Using HDFS for Nuodb as storage. Would this have a performance impact? If I understand correctly, HDFS is better suited for batch mode or write once and read many times, types of application. Would it not increase the latency for record to be fetch…
user1687711
  • 443
  • 1
  • 4
  • 13
1
vote
1 answer

How do I connect an Ado.Net client to my NuoDB on Linux Docker

I created the 3 necessary containers for NuoDB using the NuoDB instructions. My Docker environment runs on a virtual Ubuntu Linux environment (VMware). Afterwards I tried to access the database using a console application (C# .Net Framework 4.8) and…
Smooon
  • 13
  • 2
1
vote
1 answer

How to handle the result of SELECT query in chunks in Spring Batch

REQUIREMENT: A SELECT query may result to 200K records. We need to fetch the records, process it and write it in the database with processed results. Database Used: NuoDB PROBLEM: I have read in NuoDB documentation: Results of queries to the…
Pratim Singha
  • 569
  • 2
  • 10
  • 33
1
vote
0 answers

NuoDB query statistics

I'm currently doing a research using a TPC-H table and I'm trying to get the running time for 3 queries in NuoDB: SELECT * FROM LINEITEM SELECT * FROM LINEITEM WHERE L_PARTKEY BETWEEN 1 AND 80000 SELECT * FROM LINEITEM WHERE L_PARTKEY…
Yann Braga
  • 1,231
  • 1
  • 9
  • 15
1
vote
1 answer

Architectural challenge in NuoDB addressed?

Refer to this video: https://youtu.be/NsI51Mo6r3o?t=18m48s The video was dated in Sept. 2013. In technology term it is quite outdated. However, in the video it raised several challenges NuoDB had. I wonder did NuoDB improve on the aspects of: Race…
Howard Lee
  • 977
  • 1
  • 11
  • 20
1
vote
1 answer

NuoDB Equivalent to SQL Server CTE

What is the NuoDB equivalent to SQL Server's Common Table Expressions (CTE) if any? Maybe a temp table? I'm evaluating whether or not I can replace that functionality or not.
bbqchickenrobot
  • 3,592
  • 3
  • 45
  • 67
1
vote
1 answer

Could not log "sql.active_record" event. NoMethodError: undefined method `name'

I am currently developing an application using NuoDB and Ruby on Rails I am using the 'nuodb' gem and the 'activerecord-nuodb-adapter' to connect to the DB but I seem to be getting an error with the logs when executing commands. For example, when I…
Patrick Angodung
  • 4,625
  • 3
  • 14
  • 18
1
vote
2 answers

how nuodb manages the storage size increase

Say my data store is going to increase in size, if the data increases how storage manager would manage the data. Does storage manager split the data with different domain machines ( definitely that is not the case)? How exactly would the process…
user1687711
  • 443
  • 1
  • 4
  • 13
0
votes
1 answer

How to improve the performance of SELECT query to a table in NuoDB

Requirement: Please consider a spring batch application. Input is a file containing a column of values. The Spring Batch is designed as chunk oriented design. Chunk is designed to take 1000 records at a time Therefore, Reader reads 1000 records…
Pratim Singha
  • 569
  • 2
  • 10
  • 33
1
2 3