Base API which enables interacting with SQL database servers by executing SQL statements using the Java programming language
Questions tagged [jdbc]
90 questions
1
vote
2 answers
What's needed to enable JDBC or ODBC to MySQL database?
I have a MySQL server on my Scientific Linux 6.2 system. Right now I know how to create a new database, and set up users.
I need to setup LibreOffice Base to connect to the MySQL server, via either ODBC or JDBC (ideally over SSL).
How do I do this?…
hpy
- 835
- 3
- 18
- 28
1
vote
1 answer
Performance factors in remote database access
I have a Java application which accesses a database. I tested it on my local machine with local database and it works just fine. But when I test it in our test environment where the application server and database server are differnt, the…
Bhushan
- 151
- 9
1
vote
1 answer
Tomcat - how to store sessions in DB immediately?
I'm experimenting with tomcat JDBCStore-based session persistence and wonder whether there is a way to make tomcat store sessions in DB as soon as possible?
I've tried to play with minIdleSwap and maxIdleSwap values, but I guess I just don't…
shabunc
- 87
- 1
- 2
- 12
1
vote
0 answers
Intermittent java.sql.SQLException: ORA-03120: two-taskconversion routine: integer overflow exception
I get the following error intermittently when my spring app starts up. I am using oracle with dbcp pooling as my datasource bean in spring.
Caused by: org.apache.commons.dbcp.SQLNestedException: Errorpreloading the connection pool
at…
Abe
- 111
- 3
1
vote
2 answers
How to best debug JDBC connection leaks on Glassfish v2?
Does anyone have any good tips on debugging connection leaks on GlassFish?
I am currently debugging a GlassFish server which contains an application that has memory leaks sporadically, eventually leading to having to restart the server to free the…
Chris Dale
- 1,553
- 2
- 12
- 22
1
vote
1 answer
web application can't connect to database
I have a web application which accesses MySQL using Hibernate as a JPA provider. Though all is well on my development rig, once I deploy the WAR to my server I get the following error:
org.springframework.web.util.NestedServletException: Request…
reve_etrange
- 111
- 6
1
vote
1 answer
Enabling JMX for proxool with tomcat
I am trying to get proxool's MBeans available so that I can see/manipulate them with jconsole. I have jconsole working, but I don't see anything related to proxool.
The system is using Sun Java 1.5.0_17 (I know, I know... I'm working with the…
dialt0ne
- 3,027
- 17
- 27
1
vote
1 answer
MySQL Federated Tables Escaped Table Names
I am trying to use MySQL federated tables. The problem is that the documentation specified at http://dev.mysql.com/doc/refman/5.0/en/federated-use.html says that a federated table should be created using the following format for the CONNECTION…
Gordon
- 131
- 1
- 4
1
vote
1 answer
mysql Data loss after server restart
Possible Duplicate:
mysql data loss after server crash
After the server restarted due to a power cut, we lost all data saved in the database during the morning (client records created in the website). A few minutes before the crash, I was able to…
Hooligan
- 195
- 1
- 2
- 10
1
vote
0 answers
Getting the connection pool properties
I have set up a connection pool in tomcat's server.xml and context.xml.
I am using the below code to establish a connection.
DataSource ds = (DataSource) context.lookup("jdbc/TestDB");
ds.getConnection();
Now I want to get the properties like…
Vinayak
- 73
- 7
0
votes
3 answers
Tomcat's connection pool opens only 20 connections to mysql
I have a java application with following line in context.xml
None
0
votes
2 answers
How to make a JDBC connect to Crystal Reports with Postgres
I want to create a new report using Crystal Reports. I downloaded the Postgres driver but when I want to create the connection, it shows an error "JDBC Driver not found"
How can I solve it?
Thanks :)
Alberto
0
votes
2 answers
SQL Server 2014 enabling TLS 1.1 along with TLS 1.2
I have a Windows Server 2012 R2 which is a DC with SQL Server 2014 (Express) updated to the latest SP2 with CU10 12.2.5571.0 (testing environment).
I disabled all protocols except TLS1.1 and TLS1.2 by setting the registry keys in the path:
HKLM…
Bemipefe
- 95
- 1
- 11
0
votes
0 answers
encypted pasword for Tomcat server.xml JDBC Datasource
I have certain JDBC resources configured in my Tomcat server.xml file. Using those, I can connect remote databases.
For example
Suyash Jain
- 241
- 2
- 9
0
votes
0 answers
MySQL Communications link failure periodically every 61 minutes
Interesting, strange problem.
Have a production system running an application distributed across multiple servers, which all read and write to a, separate, MySQL Server.
MySQL Server version 5.6.31
CentOS 7
After running for a few hours, the…
aola1433
- 1
- 1