Questions tagged [jdbc]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
507 views

WebLogic JDBC - Profile Harvest Frequency Seconds

In the company I'm providing consulting services, when the database is updated by a process outside Weblogic Web Application, the updated data is not refreshed at once. Googling a bit I've found the ...
0 votes
1 answer
403 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: http:/...
1 vote
1 answer
475 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 ...
0 votes
2 answers
841 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
1 answer
1k 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 com.mysql.jdbc.exceptions.jdbc4....
1 vote
2 answers
2k 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 ...
-2 votes
1 answer
753 views

Can't get jmeter-server to work correctly with jdbc:mysql driver

I am running jmeter-server on a remote database host (Centos, sun-java 1.6). I dropped the MySQL java jar in $JMETER_HOME/lib per the install instructions. When I try to run a job on my local system (...
-2 votes
1 answer
2k views

Alfresco couldn't start. Why?

I have alfresco on my VM. When I try to start alfresco I got an error "postgresql could not be started" such as following : /opt/alfresco/postgresql/scripts/ctl.sh : postgresql could not be started ...
2 votes
0 answers
2k 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: com.mysql.jdbc....
7 votes
1 answer
8k 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 ...
1 vote
1 answer
470 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 [#|2012-11-14T12:07:04.318+...
4 votes
1 answer
2k 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 ...
0 votes
2 answers
177 views

ColdFusion8 FusionReactor JDBC wrapper - bad driver jars?

I'm having trouble getting the JDBC wrapper tool to wrap my ODBC connections. Before the version that came out today, it wouldn't even run due to a compatibility issue with CF8. Now it's saying ...
1 vote
0 answers
921 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
2 answers
571 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 ...
2 votes
1 answer
4k 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 ...
0 votes
1 answer
1k 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
1 answer
162 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 ...
1 vote
1 answer
1k 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 ...
0 votes
2 answers
762 views

JDBC CLASSPATH Not Working

I'm setting up a simple JDBC connection to my working MySQL database on my server. I'm using the Connector-J provided by MySQL. According to their documentation, I'm suppose to create the CLASSPATH ...
0 votes
3 answers
2k 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" ...
1 vote
1 answer
2k 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: org....
0 votes
1 answer
308 views

Solr could not index my table from mysql

I have ubuntu server and mysql version 5.1.41-3ubuntu12.10-log. i need to run solr on my webserver. i have installed lucidworks-enterprise-installer-1.7 and mysql-connector-java-5.1.17-bin.jar on the ...
1 vote
1 answer
4k views

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....
1 vote
1 answer
294 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 ...
0 votes
2 answers
960 views

Where to install JDBC drivers in Hyperic Server

I have installed Hyperic Server 4.4.0 and I want to use an SQL plugin that connects to an Oracle database. To make this work on the Agent i had to download a JDBC driver for Oracle and put it in [...
0 votes
2 answers
14k 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 ...
2 votes
1 answer
2k views

Command-line/NCurses based tool for browsing JDBC database [closed]

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 ...
0 votes
1 answer
439 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
1 answer
83 views

JDBC not seeing updated table structure

I am using Coldfusion 8 which is connecting to SQL Server 2008, the problem is I have updated a table adding a new column in SSMS, but the JDBC connection is still 'seeing' the table prior to the ...
2 votes
1 answer
1k 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 ...
0 votes
3 answers
2k 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
1 answer
165 views

How to set JBOSS/JDBSC to cach the MySQL server settings?

Is it possible to set JBOSS/JDBC's MySQL connector to cache the server's settings so that I won't get a big bunch of "show variables" connection all the time? I think there is a similar settings ...
0 votes
1 answer
319 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 ...
2 votes
1 answer
742 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 ...
1 vote
1 answer
1k 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 the ...
0 votes
1 answer
965 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? ...
-1 votes
1 answer
608 views

MySql benchmark written in Java

I want to compare the performance of two MySql servers. Since we are accessing the database using Java/JDBC, the benchmark should be written in Java. It does not have to be MySql specififc, any ...
0 votes
2 answers
1k views

Building a jar with MySQL jdbc on solaris

Im building a java application that uses JDBC to connect to MySQL. I have an ant script that compiles my code and then packages it, along with log4j, junit, libshout-java and the mysql jdbc driver ...
0 votes
1 answer
3k 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 ...
2 votes
2 answers
3k 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 ...
10 votes
1 answer
85k 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 ...

1
2