Hello there. I am using Hibernate 3.2.5 and Hibernate Annotations 3.3.1.GA as the JPA provider in a data loading application. I have configured Hibernate to use C3P0 for connection pooling. My database is: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production As there is no built in hibernate dialect for 11g, ...
I'm building a J2EE web apps with Oracle database. The app server uses JDBC connection pooling to Oracle database A (e.g. 20 connections max), and some of the queries performed use tables in remote Oracle database B via database link. If the App Server creates 20 connections to database A, and all queries are looking up data in datab...
For Blackfish for Windows which is included in Delphi 2009 I would like to write a Java client and use a JDBC connection. If I understand correctly, this is supported: http://edn.embarcadero.com/de/article/36851 The database clients and servers are interchangeable. Windows clients can connect to Java servers and Java clients ca...
Hi, at work we have to deal with several MS Access mdb files, so we use the default JdbcOdbcBridge Driver which comes with the Sun JVM and, for most cases, it works great. The problem is that when we have to deal with some larger files, we face several times exceptions with the message "Can't open any more tables". How can we avoid tha...
I am using a MySQL DB and a Java JDBC client to access it. I have a Table that contains session information. Each session is associated with a SessionToken. This token is a Base64 encoded String of a Hash of some of the session values. It should be unique. And is defined as varchar(50) in the db. When I try to lookup a session by its...
I a problem in JDBC driver for SQLite. I am executing a query with SELECT statement. If I get an empty resultset (0 rows) then I see a "Closed ResultSet" exception thrown when checking GetString(1). Without much prior JDBC experience, my theory (which I could not confirm via JavaDocs for ResultSet) is that GetString(1) does NOT work...
This method keeps throwing the exception in the title, and I cannot find a reason, I have created other tables through the connection and all the referenced tables have been created. I'm using embedded JavaDB. private void createEvidenceTable() throws SQLException { Statement evidenceTable = CONNECTION.createStatement(); evidenc...
I have a problem with DB2 databases that should store unicode characters. The connection is established using JDBC. What do I have to do if I would like to insert a unicode string into the database? INSERT INTO my_table(id, string_field) VALUES(1, N'my unicode string'); or INSERT INTO my_table(id, string_field) VALUES(1, 'my unicod...
I'm using using the sqljdbc4.jar (sqljdbc_2.0) version. I'm executing an insert + a select back to get the identity like this: BEGIN INSERT INTO DateRangeOptions (Description,Code) VALUES ('dateRange.quickPick.option.all','ALL'); SELECT SCOPE_IDENTITY() END and I get: com.microsoft.sqlserver.jdbc.SQLServerException: The state...
how to display multiple records from database having the same field value by using result set statement ...
I have a java web application which needs to upload files and we want to store these files on the filesystem rather than in the database. The database will store the document metadata only. The question is whether to just store the path as a string in Oracle, or as a BFILE locator? Can a BFILE locator point to a location which is on a d...
Hi, reading the ActiveMQ documentation (we are using the 5.3 release) I find a section about the possibility of using a JDBC persistence adapter with ActiveMQ. What are the bennefits? Does it provide any gain in performance or reliability? When should I use it? ...
I'm writing a database validation tool in Java and have preference screens so the user can define their database connections. The tool should be able to cope with DB2, Oracle, Postgresql and Mysql as a minimum. What I would really like is to be able to present the user with a list of their installed jdbc drivers as part of this process....
I've been writing a Library management Java app lately, and, up until now, the main Library database is stored in a .txt file which was later converted to ArrayList in Java for creating and editing the database and saving the alterations back to the .txt file again. A very primitive method indeed. Hence, having heard on SQL later on, I'm...
This is the question about JDBC. I have next task. I'm iterating through rows from table A and for some current row I want to execute some query against table B in context of current row from A. For example, if I have some query like SELECT B.description FROM A LEFT JOIN B ON A.ID = B.refId then I want to get all results where B.refI...
Can anybody explain me these classes and methods? DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); conn = java.sql.DriverManager.getConnection( "jdb:ocracle:thin:username/[email protected]:1234:dbSID"); Thanks ...
I'm using SimpleJdbcDaoSupport object to access DB resources. I have a query which is frequently executed against the database to locate a record with a specific key. for some reason after executing the same query several times I start to get an empty result even though the record exists in the database. Any ideas what can cause this b...
Hi all, we're currently working on testing JTA failure behaviour, on a system that receives messages using JMS, persists them, and sends results using another class. The whole thing is tied together using Spring. Current unit tests use HSQLDB, Apache ActiveMQ and Bitronix for transaction management. Success with this has been limited, ...
We are creating a small application that will be deployed to very limited machines. They have only 256mb of RAM. I would like to use JPA as it simplifies the code and removes the need for JDBC ResultSet code. However, will the overhead of JPA on such small machines be a factor? I am thinking of using Toplink at the moment, which comes i...
How to establish SQL 2005 database connectivity with Java application. Actually I don't know how to set path for JDBC. Any help would be great. ...