Questions tagged [jdbc]
15 questions
3
votes
1 answer
How to set up the jdbc driver to connect to hsqldb from libreoffice?
I am trying to "split" a LibreOffice .odb file into a HSQL database and an OpenOffice document containing forms and macros. I am trying to follow the instructions from this thread:
Within a few minutes you can convert your embedded HSQLDB to a…
rumtscho
- 4,084
2
votes
5 answers
Sqldeveloper /as sysdba connection
I'm a total newbie in Oracle.
I installed Oracle 11g XE R2.
Also I installed SqlDeveloper 3.2.20.09 version.
I generated auto connections, and I have 2 connections.
One is: /as sysdba
and another: system-XE
I successfully connect to system-XE,…
enigmaticus
- 141
2
votes
1 answer
What basic linux command-line utility can I use to test a JDBC connection?
I'm troubleshooting an issue with importing data to Apache Solr from a MS SQL Server database via a JDBC connection. Solr is hosted on a CentOS linux machine, and SQL Server is (of course) on a seperate Windows Server box.
I can see the login…
STW
- 1,908
1
vote
2 answers
Reading an Access database from Java (Eclipse)
I'm using Windows 7 (64-bit). I installed 64-bit versions of Eclipse and JRE, but when I tried to read from Access I got problems.
The only way to use ODBC seems to be by using a 32-bit variant, but it doesn't match. It looks like Java needs to run…
Lena
- 19
- 1
- 3
1
vote
0 answers
DBCP Connections pool connection stuck after no using
We stuck with a strange issue in java with Oracle connections pool
If java program gets new data all the time no issue discovered. But if for a long period no requests to DB, and we try make a request it's stuck for 15 minutes. Only after 15 minutes…
Ilya Li
- 11
1
vote
3 answers
Can I interrogate the Linux operating system through a SQL interface?
E.g. for crontab. I don't want to parse it. I want to run a sql query vs (as a minimum) a jdbc-compliant connection (automagically provided provided by Linux, that returns exactly that).
But I mean - not just for crontab. The more the merrier.…
lucid_dreamer
- 115
0
votes
2 answers
Strange error from Easy Tomcat 7 connecting to MySQL database
I'm fairly new to Java servlet and web app development, but this is puzzling. I have built a project in Eclipse (Mars) that consists mostly of static HTML pages with one JSP that contains a form that does a POST to a servlet. This servlet simply…
0
votes
1 answer
WEB-INF/web.xml displays mysql credentials?
I found web.xml in /WEB-INF/ on a domain I'm associated with. In said xml file, I see it displays:
jdbc/mysql
com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
…
0
votes
1 answer
How do I compare database values in JMeter
I am setting some values in database using REST request via JMeter and I want to verify the set values are committed into database. I'm able to access mysql database using JDBC driver in JMeter however I don't know how to compare the output? The…
TusharG
- 1,422
0
votes
1 answer
SQL SERVER 2000 JDBC DRIVER
I am trying to find the SQL SERVER 2000 JDBC Driver to use in extracting data from SQL SERVER and also carrying out several operation implemented in Java/JSF. Any idea where I could get my hands on the driver? It is no surprise that Microsoft.com…
sys_debug
- 103
0
votes
0 answers
Remove the severity of the error from error message send by Postgresql
Is there a way to remove the "ERROR:" from the error message that postgresql sends? Adding a sample error message :
ERROR: insert or update on table "bonus" violates foreign key constraint "bonus_cust_id_fkey"
Detail: Key (cust_id)=(1998) is not…
Abhinash Jha
- 101
0
votes
0 answers
R can't connect to Druid cluster only on rstudio-server
I'm running these lines to get R connected to a Apache Druid cluster:
> library("RJDBC")
> conn_string = "jdbc:avatica:remote:url=http://:8082/druid/v2/sql/avatica-protobuf/;serialization=protobuf"
> drv <-…
0
votes
1 answer
MySQL apparently running but not listening on TCP, jdbc can't connect
I am running MySQL on Ubuntu. mysql cli, as does http://localhost/phpmyadmin, but I cannot connect using java.sql.DriverManager.getConnection:
java.net.SocketException: Network is unreachable (connect failed)
ps tells me the service is…
spraff
- 2,458
0
votes
1 answer
Yugabyte - how to set JDBC connection string
On Yugabyte DB, could not find in any documentation how to deal with connection string (JDBC specifically) to make sure App (re)connects to any of surviving cluster nodes in case one node fails? All references I found shows single IP address what…
0
votes
2 answers
MySQL access denied for user connection with JDBC
I just did a new install on Ubuntu 16.04 and MySQL 5.7. Im able to connect on the command line by my application running in Tomcat is getting access denied for the same user. Here is how I created my user:
create user 'myuser'@'localhost'…
Daniel Cosio
- 133