Java Database Connectivity (JDBC) is a Java standard that provides the interface for connecting from Java to relational databases.
0
votes
1answer
26 views
Why decrease the wait_timeout configuration parameter in MySQL?
Question
I'm working on an application that uses a connection pool in Apache Tomcat to communicate with MySQL. I was wondering why would you want to use a smaller wait_timeout than the default of ...
2
votes
0answers
16 views
Wanted: Android versions of JDBC drivers for common RDMBSes
I've got a Java-based application library I'm trying to port to Android. The package presently supports:
Oracle
Informix
DB2
Postgres
Sybase
...And can easily be configured to use any other SQL92 ...
4
votes
4answers
129 views
Oracle 11g delete by unique key slow
We have been plagued by a deadlock issue for quite some time that relates to deletes and inserts on the same table. It happens sporadically, but had been increasing in frequency. It would manifest ...
0
votes
1answer
16 views
Why isn't my includeThreadNamesAsStatementComment JDBC parameter working?
The JDBC API lists a includeThreadNamesAsStatementComment parameter that seems to indicate it will prefix all queries with the Java thread ID. I thought this would be useful in tying back DB activity ...
2
votes
1answer
72 views
LoadBalancing JDBC DataSource Connect without URL
When using JDBC I like the new DataSource-way to establish the connection. Further I like the isolated set-Methods for the properties like setUser, setPassword, setDriverType, setServerName, ...
1
vote
2answers
1k views
Connect to Postgresql 9.2 from Eclipse Data Tools Platform
GOAL:
My goal is to write sql code within Eclipse to query a Postgresql database. The reason I want to write my queries within Eclipse is to then write R or Python code to perform statistical analysis ...
1
vote
1answer
167 views
Retrieving data from inner join using LIMIT and OFFSET
These are my two tables:
table1
qid[PK] |gid[PK] |abcd | xyz | date
---------------+---------+---------+------+------------
00001 | qwe | 54 | a | 1994-11-29
00002 ...
1
vote
2answers
495 views
jdbc+mysql: “Deadlock found when trying to get lock; try restarting transaction”
After recovering from a disk-full problem, I started getting these errors in my logs:
java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
at ...
2
votes
2answers
758 views
java.sql.SQLException: Login failed for user 'sa'
I am having trouble connecting to my SQL Server database through a jtds connection:
Connection conn = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/MnA;instance=SQLEXPRESS", ...
0
votes
1answer
114 views
jdbc: does setAutoCommit(true) commits past executions?
I would like to execute some statements, and commit the entire batch at the end. I've tried the following approach:
connection.setAutoCommit(false); // Don't commit for each statement
...
1
vote
2answers
138 views
Derby/SQL - How to increase performance when left joining and retrieving varchar columns
Through trial and error I found that if I do a left join such as:
SELECT
firsttable.id,
secondtable.id,
secondtable.varcharColumn
FROM
firsttable
LEFT JOIN
secondtable
ON
...
0
votes
1answer
179 views
Sybase ASE doing showplan for all requests
We have a strange situation where we are seeing showplan information in packets returned from a Sybase ASE 12.5 database server to a JDBC client. ie using tcpdump we see showplan output being sent ...
0
votes
1answer
402 views
java.sql.SQLException: Login failed for user 'sa'
I am having trouble connecting to my Microsoft SQL Server database through a jTDS connection:
Connection conn = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433
...
5
votes
4answers
7k views
Why does MySQL say I'm out of memory?
I was trying to execute a fairly large INSERT...SELECT in MySQL with JDBC, and I got the following exception:
Exception in thread "main" java.sql.SQLException: Out of memory (Needed 1073741824 bytes)
...
4
votes
1answer
326 views
Session in “Sql*net message from client”, but is active
I've Googled around, and my impression is that
Sql*net message from client
suggests the Oracle DBMS is waiting for the client to send new commands to the DBMS, and therefore any time spent in ...
0
votes
0answers
100 views
Connecting to a remote production MS-Access 2003 database that has Workgroups with SquirrelSQL?
I'm trying to connect to an MS-Access 2003 database using SQuirrelSQL and the JDBC-ODBC Driver.
I have the database shared on a network share mounted on drive D:
In SQuirrelSQL, I add an Alias like ...
9
votes
1answer
268 views
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
Background: I'm working on http://sqlfiddle.com (my site), and am trying to prevent one avenue of abuse possible there. I'm hoping that by asking about a problem I'm currently addressing, I don't ...
1
vote
1answer
174 views
Postgres shared_buffers and pooled processes
I have read several articles (including Postgres docs) that suggest setting the shared_buffer's config value to 25% of your total physical memory.
Using my 4 GB memory as an example... If I ...
1
vote
2answers
475 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 ...
3
votes
1answer
2k views
Oracle 11g hunting down the deadlock, maybe foreign key?
I am trying to understand why a deadlock occurs in my database. The trace tells me that two updates on the same table are locking. In table is the first table to be written to in an transaction, only ...
0
votes
1answer
2k views
What is the JDBC URL for Oracle's Data Guard Fast-Start Failover?
Currently I have...
url=
"
jdbc:oracle:thin:@
(
DESCRIPTION=
(
ADDRESS_LIST=
(LOAD_BALANCE=OFF)
(FAILOVER=ON)
(
ADDRESS=
(PROTOCOL=TCP)
...
2
votes
1answer
400 views
Are there any good database management applications for JDBC/Java databases?
I am working with an Apache Derby/JavaDB database via JDBC. Before have I been working with MySQL and used phpMyAdmin as a good Database Management tool.
Is there any good desktop application for ...
