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

learn more… | top users | synonyms

1
vote
3answers
4k 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: ...
0
votes
1answer
387 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
2answers
472 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 ...
2
votes
1answer
1k 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
1answer
69 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 ...
3
votes
1answer
903 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 ...
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+ ...
1
vote
1answer
181 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
1answer
110 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
1answer
254 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 ...
1
vote
1answer
475 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
1answer
601 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? ...
2
votes
1answer
685 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 ...
0
votes
5answers
7k 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(); ...
-1
votes
1answer
394 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
2answers
652 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
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
2answers
2k views

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 ...
14
votes
9answers
103k 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 ...
2
votes
1answer
725 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 ...
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 ...
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 ...
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
723 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 ...
7
votes
1answer
56k 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 ...