Base API which enables interacting with SQL database servers by executing SQL statements using the Java programming language

learn more… | top users | synonyms

12
votes
9answers
83k views

Unable to connect to mysql through JDBC connector through Tomcat or externally

I've installed a stock mysql 5.5 installation, and while I can connect to the mysql service via the mysql command, and the service seems to be running, I cannot connect to it through spring+tomcat or ...
7
votes
1answer
51k views

Differences between classes12.jar, ojdbc14.jar, ojdbc5.jar and ojdbc6.jar

We are planning to upgrade our application servers to a new version of JRun which is carrying with it an upgrade from Java 1.4 to Java 1.6. As part of that, we have been testing various pieces of our ...
4
votes
1answer
2k views

HAProxy, client timeouts when connecting from JDBC pool

I have a webapp (Tomcat/Hibernate/DBCP 1.4) that runs queries against MySQL, and this works fine for a certain load, say 50 queries a second. When I route the same moderate load through HAProxy (still ...
4
votes
1answer
589 views

What is the best JDBC connection URI for AWS RDS instances?

When using an Amazon Web Services RDS instance from a Java application, what is the best JDBC connection string? It should tolerate the instance falling over to the standby. AWS handles flipping the ...
3
votes
1answer
806 views

Impact on SQL 2000 performance of JDBC selectMethod=cursor

(Posted first on SO, but its not getting any answers there. Cross-posting to reach a larger audience, since it is cross-discipline.) In the process of trying to help out an app dev team with some ...
2
votes
1answer
75 views

Does an SQL Server instance allow both secure and non-secure connections at the same time?

we have an application running MS SQL Server 2012. For one specific use case we'd like to SSL protect the jdbc connection. I've checked the following links: How to enable SSL encryption for an ...
2
votes
1answer
663 views

What are the negatives of setting a high wait_timeout setting in MySQL?

I'm looking at the possibility of increasing the wait_timeout on a MySQL server in an effort to avoid a streaming JDBC SELECT in a Solr Data Import Handler from timing out after the default 28800 ...
2
votes
1answer
669 views

Oracle 9i Session Disconnections

I am in a development environment, and our test Oracle 9i server has been misbehaving for a few days now. What happens is that we have our JDBC connections disconnecting after a few successful ...
2
votes
0answers
606 views

mysql client can't read query result?

So I have this machine running an XMPP server which connects to its MySQL database. When I start load-testing it, all goes fine up until after about 500s when I notice: Caused by: ...
2
votes
1answer
3k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
1
vote
2answers
1k views

how does odbc driver work?

I have an application hosted on jboss. use jdbc driver of oracle to connect to an oracle 10.2g database. Can anyone guide as to what happens when a session is established. Just trying to understand ...
1
vote
1answer
133 views

Is there a way to monitor /dev/random?

We're investigating some JDBC issues, and one of the possible problems is /dev/random being exhausted. The workaround is to switch the JVM to using /dev/urandom, but I wan't to try and determine ...
1
vote
1answer
300 views

GlassFish cluster-targeted jdbc is not enabled

I have a GlassFish cluster. When I tried to add node and a instance, DAS saids a bunch of error messages telling Resource [ jdbc/xxxx ] of type [ jdbc ] is not enabled ...
1
vote
2answers
393 views

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 ...
1
vote
1answer
1k views

Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?

I've and Oracle (11 Enterprise) schema with a table CREATE TABLE USER.WSP_BUNDLE ( NODE_ID RAW(16) NOT NULL, BUNDLE_DATA BLOB NOT NULL ); CREATE UNIQUE INDEX USER.WSP_BUNDLE_IDX ...
1
vote
1answer
355 views

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 ...
1
vote
3answers
3k views

Configuring jdbc-pool (tomcat 7)

i'm having some problems with tomcat 7 for configuring jdbc-pool : i`ve tried to follow this example: http://www.tomcatexpert.com/blog/2010/04/01/configuring-jdbc-pool-high-concurrency so i have: ...
1
vote
1answer
862 views

Command-line/NCurses based tool for browsing JDBC database

I need to manipulate a database from Linux command-line. I already have JDBC drivers for the database (specifically DerbyDB). Now I need some sort of command-line or NCurses based tool for Linux. I ...
1
vote
1answer
601 views

Can't get Glassfish 3.1.2.2 to use anything other than jdbc/__TimerService for the EJB Timer Service

I am trying to set up a Glassfish cluster (1 DAS with a cluster that has an instance running on an ssh-node). This is where I am: DAS running Cluster created asadmin create-cluster cluster Node ...
1
vote
2answers
604 views

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 ...
1
vote
1answer
163 views

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 ...
1
vote
0answers
1k views

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure between Java app & database VMs

Am getting increasingly frequent JDBC Communications link failure errors between a Glassfish 3 + Java 7 server VM and a MySQL 5.6 Both VMs are hosted on the same ESXi 5.5 enterprise host (as part of a ...
1
vote
1answer
1k views

MS SQL Server configured for secure (SSL) connection allows non-secure connection from JDBC Client

I need to connect to the MS SQL Server 2008 r2 using the secure communication. I have been able to do the same using the following connection string: jdbc:sqlserver://<<db server ...
1
vote
1answer
106 views

Solr list all records but fq matching records first

I’m using solr 4.0 with DIH jdbc connector. I have a field named code with multiple values separated by semicolon(;). I am trying to list the search results which matches the field query(fq) to be ...
1
vote
1answer
1k views

How to use JDBC Connection Pooling without JNDI DataSource? (in Apache Tomcat)

I have an Apache Tomcat 7 server. I have a quite complex Java Servlet application running on it which needs some MySQL queries per POST. Thus I need a MySQL Database connection to do the query. ...
1
vote
0answers
569 views

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: ...
1
vote
1answer
351 views

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: ...
1
vote
1answer
412 views

mysql Data loss after server restart [duplicate]

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 ...
0
votes
2answers
2k views

Newbie question: How do I connect to Oracle db from linux command line

I had experience with mysql before, but know completely nothing about Oracle DB. Recently, I'm assigned to add a simple feature to an existing system. Albeit simple, I need to connect to the db and ...
0
votes
4answers
6k views

How to connect to oracle server in java?

I am trying to connect to my friends Oracle server. But while connection I am getting error please help..... JDBC code Class.forName(oracle.jdbc.driver.OracleDriver).newInstance(); ...
0
votes
2answers
215 views

JDBC Connection Pool details on Glassfish

In the context of configuring Session Beans for Entity Classes, I can get some basic information from Glassfish v4 on Ubuntu about the JDBC connection pool from the CLI with asadmin, but would like to ...
0
votes
2answers
55 views

Configure MSSQL 2008 to use kerberos authentication

I would like to set my current mssql db (2008 and 2012) to authenticate using a linux kerberos server that I have in my environment . The windows station is in a workgroup and I would like to avoid ...
0
votes
1answer
161 views

Connection to Amazon AWS highly unreliable [closed]

I have a Java application that connects to MySQL on an Amazon EC2 (USA east region) instance with JDBC (using official latest Oracle drivers, location specified by IP). It also connects to S3 using ...
0
votes
3answers
1k views

JDBC Communication link failure. iptable setup

I have a java application that runs on my work machine, but wont connect on the production server. Heres the connection code: String db = "jdbc:mysql://localhost:3306/"+database+ ...
0
votes
1answer
139 views

Monitor Tomcat-JDBC connections

The company that I work for sells a java web application that runs in Tomcat. The primary problems we have are that the tomcat containers become unresponsive and need to be restarted and that the ...
0
votes
1answer
92 views

Installed JDBC drivers into Solr

I am running Solr4 on Jetty9 and I am trying to include the JDBC drivers for both MySQL and PostgreSQL. I'm a little confused about how I do this. I believe these to be the two files I need: ...
0
votes
2answers
148 views

Set up JDBC DataSource in LDAP

How do I create a JDBC DataSource in an OpenLDAP server? The problem is that jdbc/something is not a valid DN or RDN. But that is the format of the name that you are supposed to use for JDBC ...
0
votes
1answer
395 views

Setting up MySQL server on LAN to be used with JDBC

I'm creating an application with client-server architecture in java. What I'm trying to achieve is a simple client-server architecture connected via LAN with an ethernet switch, the server is having a ...
0
votes
1answer
109 views

ODSI + weblogic = JDBC problem

I'm currently developing a web service using ODSI through Oracle Workshop for WebLogic (ex AquaLogic). I created a datasource on weblogic using the driver "Oracle thin driver 10g", the test succeed on ...
0
votes
1answer
355 views

Frustrating JDBC MySQL Exception

So I'm setting up my new server after my old one had died of a server failure. The only boulder I've hit is the JDBC set up. My server runs a Java program that had originally worked fine with the old ...
0
votes
1answer
247 views

Does MySQL/JBOSS/Tomcat/JDBC have a 20 process limit?

Reason for asking this is that, I have been firing around 200 concurrent connections via SOAP to a web service, and in MySQL, I have never seen more than 20 connections being processed at a time. My ...
0
votes
1answer
532 views

how to connect and select data from a JDBC over RMI database in perl?

I have a 3rd party application that exposes in-memory data structures via a JDBC api over RMI. How can I get data out of that database api without having to run squirrel or similar GUI application? ...
0
votes
3answers
1k views

Tomcat's connection pool opens only 20 connections to mysql

I have a java application with following line in context.xml <Resource driverClassName="com.mysql.jdbc.Driver" maxActive="100" maxIdle="30" initialSize="10" maxWait="7000" ...
0
votes
1answer
2k views

Upgrade oralce jdbc driver in Weblogic 10

I found in Weblogic's documentation, "If you plan to use a different version any of the drivers installed with WebLogic Server, you can replace the driver file in WL_HOME\server\lib with an updated ...
0
votes
1answer
706 views

jdbc4 CommunicationsException

I have a machine running a java app talking to a mysql instance running on the same instance. the app uses jdbc4 drivers from mysql. I keep getting ...
0
votes
1answer
119 views

Elasticsearch River JDBC - Avoiding 'SELECT *'

I'd like to syncronize some MySQL tables to an ElasticSearch index, you know, for search. But almost every examples I can find show a big bad fat "SELECT * FROM", it's OK for an example, but I'm in ...
0
votes
0answers
90 views

Websphere 8.5 not instantiating jdbc connection in jndi

I am trying to create a basic connection to a remote oracle machine. I have the datasource configured in websphere console and when I test the connection, it comes back as tested good. But when I ...
0
votes
0answers
13 views

WLS: Identifying the managed server where a DB session originates from

We are using WLS servers, on which we configure data sources (DS) and managed servers. For failover reasons, our main application is depolyed on two separate managed servers (lets call them app_1 and ...
0
votes
0answers
343 views

java.lang.ClassNotFoundException: org.postgres.Driver when starting PuppetDB

When I start puppetdb I am getting the following error: cat /var/log/puppetdb/puppetdb.log 2014-08-06 11:29:50,558 ERROR [main] [utils.logging] Uncaught exception java.lang.ClassNotFoundException: ...
0
votes
1answer
130 views

Install Apache Derby on CentOS 6.4

I'm not a Java developer, my knowledge is very limited to this topic. I want to deploy a .war webservice on my Tomcat server, which fails most likely because of its Derby dependency (just a guess from ...