hello, I am trying to run an application developed on another machine where it was perfectly running, so it should have something to do with the configurations on the machine I am trying to run it on now. I'm using netbeans 6.9, tomcat 6.0.26 and maven. When I try to run it, it gives me the following error: Sep 19, 2010 12:51:02 AM or...
In the Oracle JDBC driver, there is an option to cache prepared statements. My understanding of this is that the prepared statements are precompiled by the driver, then cached, which improves performance for cached prepared statements. My question is, does this mean that the database never has to compile those prepared statements? Does ...
hi I am trying to insert some rows in to a table... I am using postgressql-7.2.jar. I get the following exception org.postgresql.util.PSQLException: No results were returned by the query. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) I have already Googled and the possible reasons su...
We're currently using ojdbc14.jar, should we be using ojdbc6.jar ? Update: Oracle 10g being used ...
Currently I'm using the ojdbc14.jar Oracle 10g thin driver to access an Oracle 10g database. I would like to upgrade the driver to the thin ojdbc6.jar Oracle 11g driver ahead of the actual upgrade of the DB server occurs. Using an 11g driver against the 10g DB seems fine in testing so far, but I'm wondering if anyone can confirm this O...
When trying to spy on the jdbc connection to a hsqldb database it doesn't work. It looks like the org.hsqldb.jdbcDriver is not deregistered. ...
Is anybody has tried JDBC type 5 driver. Is it faster than JDBC 4 driver? ...
I am trying to use H2 to connect to a database in Java (using Eclipse as the IDE). The sample does (below) throws a ClassNotFoundException. The thing is, I did add the h2 jar file to the system CLASSPATH. I have even checked it's there several times via 'printenv' in the console. Am I omitting a step? CODE: import java.sql.*; public c...
Hi, I read somewhere that in order to use JTA and Tomcat (I'm also using Hibernate) you need to use a JTA version of the JDBC driver. Is this true? If so, does this driver include JTA support? Thanks, Ittai ...
Our java class calls PLSQL proc which returns date in default format which is defined by NLS_DATE_FORMAT. Our application sets its own Locale for internationalization but I want the date format to remain just 'DD-MON-RR' which is en_US Locale NLS_DATE_FORMAT. Due to the change in locale oracle's fetched Date string differs and subsequent...
I have my java application and try to connect with mysql database.But i can't able to get the output,i am getting the Exception error.I think i am not able to connect with the driver.My OS is Linux(Ubuntu). nikki@nikki-laptop:~$ java -version java version "1.6.0_20" OpenJDK Runtime Environment (IcedTea6 1.9) (6b20-1.9-0ubuntu1) OpenJD...
Hi all, I wanted to use read and write mdb file (Ms Access file) and I am completely new in using ODBC in Qt. So can anyone help me to know whether should i need to download the drivers and if yes then from where can i download ? and if you know about connectivity then any help would be appriciated. ...