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

learn more… | top users | synonyms

0
votes
1answer
68 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
795 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
160 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
101 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
246 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
408 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
528 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
667 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
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(); ...
-1
votes
1answer
359 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
620 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
991 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
1k 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 ...
12
votes
9answers
81k 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
659 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
704 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
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 ...