Questions tagged [sqldb]
39 questions
0
votes
1 answer
Mock Sql DB connection in Nodejs Unit test cases
In My NodeJS Application, Connecting to Sql-DB using tedious, I want to unit test the microservices related to DB.
During the unit test I don't want connect real database.
But I am getting the error
Error: Unable to connect database:…
Mu Muthukumar
- 1
- 3
0
votes
1 answer
ImportError: No module named flask_mysqldb ("from flask_mysqldb import MySQL")
I'm using python 3.10. I want to use MySQL database, but whenever I am trying to import the module it throws the error. I am using MAC OS. There are certain file for windows to import but I wasn't able to find solution for Mac OS.
ImportError: No…
Navanee_NV
- 1
- 1
0
votes
1 answer
Is there any Option to execute below SQL query's using PowerShell?
The below mentioned SQL queries we are doing manually using the Query Editor in Azure Portal SQLDB. But, we have to execute these using the PowerShell, and I was went through the couple of articles and unable to find a exact solution to perform this…
niranjan reddy
- 46
- 2
0
votes
1 answer
Use the same DB transaction in different DAOs
I have a use case in one of my Golang applications to update multiple tables in an API and in case one of the updates fails, I would want all the previous updates to roll back (Something that @Transactional in Java does).
I tried doing it in the…
I_dont_know
- 341
- 1
- 4
- 17
0
votes
0 answers
Increase data insert performance
We have created a code that loops in to CosmosDb records and inserts values to Sql db. But in the process, the data insertion perfomance is very slow. please help with suggestions, here is the code. This process is taking more than 4 hours for…
user14595824
- 1
- 1
0
votes
1 answer
Inserting Data to Sql Db from Cosmos Db
I am looking out for a help, I am trying to move data from Cosmos db to Sql db using .Net. So, in the process, I am facing issue here.
This cnnInsert.Close(), gets closed after every single insertion of record, how to avoid it from closing after…
Sai Akhil
- 11
- 5
0
votes
0 answers
External Org Access best approach on Azure AD
The mission is to give access to external organizations to our sql dbs, power bi and storage accounts (through AAD?), basically to consume our data. Here is a link to the external user access to AAD, have a look at the features available and let me…
Xam
- 1
0
votes
1 answer
Power BI SQL Connection
I have a Power BI desktop report which extracts data from the database server through SQL.
Once complete, is it possible for me to disconnect the SQL DB connection but retain the data already extracted in the tables (of course, without further…
emaichen
- 1
- 2
0
votes
1 answer
Oracle SQL Developer import wizard missing?
I am using this tool to import a csv file to a MS sql database. I've just downloaded the free package for version 18.1.0. I am new to the tool. My research shows that if I right-click on 'Tables' I should see an option to start the import wizard;…
Y. Eman
- 33
- 9
0
votes
1 answer
Setting web service xml to readable format
I work with K2 BlackPearl BPM tool. Currently at a Client site, and I need to consume web services to create my SmartObjects.
The web service that am calling has XML as its input and output.
So, what I need is a way of making the XML become readable…
kolmanuel
- 21
- 5
0
votes
1 answer
update a column in sqldb using node red and bluemix
I am using Node-RED to insert information into the included sqldb.
I am successful at entering the data but I can't seem to update it. I am unsure of the syntax. The table is called ITEMS and there are 2 columns ID and ITEMS. I want to keep updating…
Andrew Stallone
- 37
- 6
0
votes
1 answer
SQL Database + LOAD + CLOB files = error SQL3229W
I'm having trouble making loads of tables that have CLOBS and BLOBS columns in a 'SQL Database' database in Bluemix.
The error returned is:
SQL3229W The field value in row "617" and column "3" is invalid. The row was
rejected. Reason code:…
Gabriel
- 11
- 2
0
votes
2 answers
When using the SQLDB HA Premium Bluemix Service via JDBC, how can I reduce the connection and read timeouts?
The SQLDB Bluemix Service's Premium Plan enables DB2 High Availability. However, the default JDBC URL provided by service credentials uses more forigiving timeouts than I would like to use. Here is an example of the default JDBC…
Jim Hurne
- 7,187
- 4
- 44
- 44
0
votes
1 answer
Get IBM Bluemix SQL Database service credentials before I bind it to application, is it possible?
When I bind SQL Database service to an application I can see credentials from application panel. But in case I've created a service and would like to work with it before I'm binding to any application, is it possible? I haven't find a way to see…
Anatoly
- 5,056
- 9
- 62
- 136