Questions tagged [jdbc]
Base API which enables interacting with SQL database servers by executing SQL statements using the Java programming language
92
questions
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 ...