I wanto to run my JDBC-connection (either Oracle or MSSQL) through a proxy-server. Reason for this is to have additional controls of the traffic, especially for developing. I know, I could specify the proxy, which runs on my machine, and the port in the connection-string. But the specified connection-settings are only taken as some kind...
We are using an XA JDBC driver in a case where it is not required (read-only work that doesn't participate in a distributed transaction). Just wondering if there are any known performance gains to be had to switch to the Non-XA JDBC driver - if not it's probably not worth switching? FWIW we are using MySQL 5.1 ...
I am having a database in .dbf (FoxPro) format. How to retrieve data from FoxPro using Java? If the data can be migrated to MySQL, How to do the conversion? ...
HI I am getting this exception when I am calling any stored procedure from my J2EE app. Exception while calling stored procedure :Bigger type length than Maximum I am having Oracle 9.1.0.7, JDK1.4 and using ojdbc14.jar running on Weblogic 8.1 Please advise what could be the root cause ? Below is the manifest of my ojdbc14.jar ...
I'm developing a Spring(2.5.6)+Hibernate(3.2.6) web application to connect to a custom database. For that I have custom JDBC Driver and Hibernate Dialect. I know for sure that these custom classes work (hard coded stuff on my unit tests). The problem, I guess, is with the order on which things get loaded by Spring. Basically: Custom ...
According to their release notes, the Xerial SQLite JDBC driver supports foreign keys since version 3.6.20.1. I have tried some time now to get a foreign key constraint to be enforced, but to no avail. Here is what I came up with: public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("...
What is a JDBC type 5 driver? What are the benefits of such a driver? Can I get any links/tutorials about type 5 drivers? ...
I am having Oracle 10g installed on my laptop and have downloaded ojdbc14.jar driver for the same. The problem is, my operating system is Windows 7, and I'm not having option to create a Data Source for Oracle since I m not having oracles driver installed. I m having option to create a Data Source for SQL server 6, but I want to get conn...
I noticed the following difference but did not see it documented anywhere. I'm wondering if others have noticed the same thing or can point me to some documentations that proves the same. Env:- Oracle 11g, JDK 1.6, iBatis, PL/SQL Scenario:- ojdbc14.jar: if pl/sql returns a variable of type DATE and I try to put that in a java.sql.D...
I am using MySQL Connector/J (GPL licence) and bundle the jar as part of my distribution. So should I need to release my application under GPL also? ...
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) a...
We have an application provided by a third party which takes a stream of market data (provided by said third party), and writes it into a JDBC compatible database. The only configuration parameters it has are the JDBC connection string, plus settings allowing us to pick what pieces of data we'd like to be stored in this database. This ...
I'm trying to do some JDBC access from JavaScript using the Rhino included in Java 6. But I cannot make the DriverManager find the Driver I want to use. These two examples should be equivalent: Java: public class DbTest { public static void main(String[] argv) { java.sql.Connection c = null; try { java....
Hi there, I am using SQLite in Java code through Zentus. I need to map Java long primitive type in my database. For that I tried to create tables with the following statement: CREATE TABLE MY TABLE (...., LONG time, ...). Insertion into the database through Java with Zentus works perfectly but when retrieving the data, always through ...
I have added my Oracle JDBC driver to my Maven repository and everything is working fine however I am still receiving warnings whenever I package my project. E.g. [INFO] Unable to find resource 'com.oracle:ojdbc14:pom:10.2.0' in repository central (http://repo1.maven.org/maven2) How can I stop those warnings from showing up? ...
As ColdFusion datasource we are using the Oracle thin client to connect with the database. So, basically we are using a JDBC URL such as jdbc:oracle:thin:@... and as Driver Class oracle.jdbc.OracleDriver This works successfully however we would like to set encryption and integrity parameters as well. In Java this is done similarly by s...
In Upgrading to Oracle JDBC thin driver results in SQLException: Unexpected exception while enlisting XAConnection (WebLogic Server 10.0, oracle version ) we are getting the error listed below. We did follow Oracle's advice to change the global timeout in weblogic, i.e. For the JDBC Connection Pools set the XASetTransactionTimeout to ...
I'm using the Apache BasicDataSource for both commons DBCP and connection pool: org.apache.commons.dbcp.BasicDataSource and managing it through Spring: org.springframework.jdbc.datasource.DataSourceTransactionManager While using this combination with the Teradata JDBC driver if my database goes down or there is a network glitch I r...
I've been trying to get a java application connecting via the jtds jdbc to a couple of SQL servers. I have to connect via windows authentication. The connection string specified is: String connectionString = _"jdbc:jtds:sqlserver://"+server+":"+port+"/"+database+";domain="+domain;_ and I am getting the connection via: con = j...
hello i'm new to jboss, i wish to setup a development server on my local machine to be used with netbeans, under windows xp; I need to install the oracle jdbc driver on it. I've searched the web and all the articles i found say to copy the jar in the server default folder. Will it be visible also to all and minimal folder ? there's ano...