Questions tagged [database-connectivity]
96 questions
0
votes
1 answer
TNSPING response time
I am connecting to a 12c database from my client machine using 12c oracle client. Below is my TNS entry.
PLMDEV1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sesbexa3-scan2.exadata.ericsson.se)(PORT = 1521))
(CONNECT_DATA =
…
srinivas
- 5
- 2
- 7
0
votes
1 answer
Passing data to a stored procedure that accepts Table Valued Parameter using pyodbc
Trying to send data to a stored procedure that accepts Table Valued Parameter. Getting following error:
[Error] ('HY004', '[HY004] [Microsoft][ODBC SQL Server Driver]Invalid SQL data type (0) (SQLBindParameter)')
I know it is due to datatype…
LCJ
- 22,196
- 67
- 260
- 418
0
votes
3 answers
I want to create a shared database c# windows form application?
This application that i am trying to create, whose "instances/copies" will be installed on multiple PCs of the client and are able to access the same database from another PC of the same client that has SQL server running all the time through the…
Alex Davidson
- 21
- 3
0
votes
1 answer
Java Sql Exception After End of Result Set
My code works fine but when I try to run the code it first shows java.sql.SQLException:After end of result set. I would like to know what is causing this and how to fix this as this is for a graded project.
public GenerateBill()
{
…
StarDragon23
- 3
- 3
0
votes
0 answers
How to move forward to next from login button to agent information form?
I want to open agent form after clicking on the button login, which I can't understand.
I have a table named agent having attributes User_Name, Password, First_Name and Last_Name.
I take input from user in User_Name and Password for login.
After…
Rahat Batool
- 17
- 7
0
votes
1 answer
Query regarding database connectivity in db4o
I'm creating a db4o object (namely Customer.yap) and if it is already created i just insert new objects into the existing object (namely Customer.yap) .
For both these operations i'm just using:
IObjectContainer db1 =…
Sreedhar Danturthi
- 7,119
- 19
- 68
- 111
0
votes
1 answer
HSQLDB never closes DB connection
I'm playing with this kind of database, and I've tried to close the HSQLDB connection after I used it, but it's still opened at the end.
Code:
//----This methods are in a specific connection class file
public static Connection conn = null;
…
Àlvaro
- 3
- 4
0
votes
0 answers
Why is this java code not saving data in database?
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
try{
try (Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/crm","root","")) {
PreparedStatement…
Aman Dhakal
- 29
- 4
0
votes
0 answers
How to Set A connection String before Building a c# Application so that it can be run on Client Computer
I Just made an application in C# using Visual Studio and create databases in SQL Server 2012. Now I have to Build the application and install in Client PC. The Problem is that Connection String is Set on my PC, How can I manage all the steps for…
Mubashar
- 1
- 1
0
votes
4 answers
What is the table name?
I am creating a Spring Boot application using the H2 database. I am constantly getting the following error:
Table "THINGS_TO_DO" not found; SQL statement:
insert into things_to_do (id, name, verified) values (1, 'TestUser1', 1) [42102-197]
And,…
P.K.
- 379
- 1
- 4
- 16
0
votes
1 answer
Teradata - Find the Teradata servers I can connect from linux
We have a Linux UAT machine on which our datastage, shell, teradata scripts are configured and we can execute jobs/scripts from this server. We have different Teradata environments(SIT, UAT, PAT, PROD - all are different servers). I can connect…
chill3chee
- 69
- 1
- 10
0
votes
1 answer
How can I have database connectivity for HTML5 for mobile applications to store data on a web server?
How can I have database connectivity for HTML5 for mobile applications to store data on a web server?
For now, I am trying for an Android device, but I will also be using it for iPhone. I am using the Eclipse editor.
Ishwari
- 1
0
votes
3 answers
Connecting to a Database with Java
I'm very confused about how to connect my Java application to a database, any database. I'm not sure where to start. Could anybody provide for me a simple example that might help me along?
pallavi
- 13
- 3
- 8
0
votes
0 answers
How to connect to Oracle database through my website using PHP? My data is hosted in AWS RDS
I am unable to connect to Oracle database hosted in AWS RDS through my website.
Do we need Oracle client for that? If yes, how to implement that at our end?
I have this code:
cggf cg m
- 1
- 2
0
votes
0 answers
Java - not supported yet error message
this is part of my code for one of my frames:
public Details(String abc) {
initComponents();
jLabel5.setText(abc);
}
//To change body of generated methods, choose Tools | Templates.
Details() {
//To change body of generated…
Valli Pichappan
- 21
- 5