I'm writing an application for billing, and I need to be able to lock a row indefinately, but know that a row is locked. My statement was created using concur_updatable and scoll_sensitive. If I call recordset.updatexxx(), then recordset.updateRow, it will lock the row, but since the select ...

I'm having an OutOfMemory exception being thrown because the Vector cannot store all the information that I am retrieving.Here's what is known:There are 99,000 rows being returned with 8 columns of data being retrieved from the database. The memory appears to be jumping quite rapidly if I try ...

I have heard that a resource file can be used to assign an URL and DB2 driver to establish a connection.What is a resource file and how can this be done?We have several URL and DB2 drivers to assign depending on what server we are processing on.thanks

Hi I am looking for a jdbc driver for oracle for HPUX either type 2 or type 4 or both.I heard that Type 4 is platform independent does it mean I can go to www.oracle.com and download the Type 4 Oracle driver for Solaris?Please help

Hi,I unsuccessfull try to access AS400 tables throw JDBC.In my code, I only use unqualified table names and I set the driver "libraries" property to "mylib1, mylib2...".Nevertheless, only tables stored in the first library are accessibles.I know that it was possible by using ODBC, so maybe ...

hiI am writing a servlet which access a database using properties file.I can't able to find the properties file.Can any one please tell me where should i keep the properties file I am using jbuilder.when i gave complete path ,it is giving error null pointer exception.thanks ...

if i use a callable statement in a while loop do I need to create a new CallableStatement object and close it for every loop?any answer will be appreciated.thanks

Have anyone tried to store java Objects in Oracle and retrieved?Please help me on this!...

HI.I have a problem. In my programm I'm often use some methods with code:Statement stat=con.createStatement();ResultSet res=stat.executeQuery("...");And some time it says that "[ODBC SQL Server Driver] Connection is busy with results for another hstmt"Ok. Does exists some way check up are my ...

Ok here's the problem. I have a string object that I want to insert into a table column. However this string may/maynot have a " mark within it. If it doesn't it's no problem however if it does the DB sqeauls like a pig.I know why it's doing this and have tried escaping the quote every ...

This is not a question as such, but more of a comment.Why does JDBC realy on XOpen standards for SQLState in SQLExceptions. I would have thought that there were other SQLException classes inherited from SQLException for each state. The state that bothers me is record is locked, but I am sure ...

Hi,i'm trying to set up a little testapplet in our organisation.I have some questions about JDBC.My situation is : there is a websever in out company wich hosts a weppage and an Access database.Now the thing I want to succeed is that I can write and read from and into that database via a ...

Hi, I want to call an oracle stored procedure within a for loop in my servlet. I know how to call the plsql stored procedure within the java servlet. But I have to call the same procedure some 30 times passing a different value every time. It works fine now, but I want to wait for some kind of ...

I am pretty new to JTA, but I want to handle global transactions to multiple databases in my Java application. I am considering implementing JTA to accomplish this.If I implement JTA across a set of EJBs, utilizing XAResource objects atop WebLogic App Server 6.0 and a JDBC driver that supports ...

Hi.Can be ORACLE make a select from some tables on diferent database?.In my INFORMIX JDBC I can make a query to relation two Instances, usingDATABASE@INSTANCE:TABLEsomething like that:try {Class.forName(drv); connection = DriverManager.getConnection(url, user, pwd); stmt = ...

I'd like to save bulk amounts of data INTO a database. Getting the data OUT is easy -- I just use executeQuery to obtain a ResultSet -- but I'm looking for the best way to put data IN. Generating an INSERT statement for each row to be added seems cumbersome and inefficient. There IS a COPY ...

What are the options available to stored a Java Object in DataBase

Hi All,import java.io.*;import java.sql.Statement;import java.sql.ResultSet;import java.sql.Connection;import java.sql.SQLException;import InsureSuite.db.DBClass;import InsureSuite.db.DBConnection;public class testDB{public static void main(String arg[]){ResultSet rs = null;Connection conn = ...

Can any one let me know if any Free Type 4 JDBC driver for SQL Server 6.5 is available. Please provide the download link.Thanks

Hi,Can anyone tell me why can't i retrieve all values from DB?The 1st record is also ignored.I have tried to retrieve values from DB,but the 1st record is always ignored or i can't see it.For instance, i have 20 records in my DB,but 19 appears in table,except the 1st ...

I'm placing my DB properties in a property file db.properties then I am present calling l this property file in a program using something like this.. i.e.database.load(new FileInputStream(new File ("e:\\JavaCodes\\dbProperties.properties")));...but I don't want to use static directory ...

Hello, Is there any one out there know how to use the driver to connect to MySQL database? I had install the driver called mm.mysql.jdbc-1.2b. And followed the instruction to install such as setting class path ... The Class path is OK .... The problem is when i trying to getConnection() to the ...

hi,when doing a DB operation, the database might throw an exception. like if we try to insert another record with an already existing primary key. is it possible to get this error message and pass it on to the java program ?for example,insertRow( ) throws an SQL exception if a database access ...

I am trying to use the JDBC-ODBC bridge for a remote Sql DB (can I?). But I'm not shure about the url I may use in the getConnection method. I have to write the port of the computer? How? Like this:"jdbc:odbc:computername:port?database=db"?I get always the following ...

is there a way i can programatically determine whether the driver i am using is jdbc 2.0 compliant?

Dear java guru's,Is this possible month and year are variable which user will send .PreparedStatement ps=con.prepareStatement("SELECT * FROM fort WHERE month=? "+" AND year=? "+ " AND site=? "+" AND ...

Hi all,Any idea why I'm getting the following error message while compiling? Do I need to install the JdbcOdbcDriver separetly or will it come default with JDK1.4? BatchUpdate.java:20: unreported exception java.lang.ClassNotFoundException; must be caught or declared to be thrownClass.forName ...

Hey,Can anyone tell me why this happens/how to fix it?: -java.sql.SQLException: Internal Error: Unable to construct a Datum from the specified inputWhile trying to write a BLOB into an Oracle 8.1.7 database.Am using JDK1.3, Oracle 8.1.7 DB and JDBC Thin driversThanks,Glenn. ...

Does anyone know if columnName is case-sensitive?Thanks.

hi developers,I want to send an ResultSet object through socket but when I try to serialize my class object which contains ResultSet object some exception are rises. can anybody suggest, how can I serialize the object with ResultSet. I want to send resultset object over the network through ...

I'm using the same PreparedStatement object for many querys on a method, I think this is ok, isn't it? So... Do I need to call the PreparedStatement.close() method between every query? Can I call the close method many times without calling the executeQuery() method?ThanksEduardo Castor ...

haiI am trying to access MS access database through JSP My code:Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");java.sql.Connection connection = java.sql.DriverManager.getConnection("jdbc dbc:bill"); java.sql.Statement statement = connection.createStatement();Enumeration parameters = ...

I am trying to run the JDBC examples provided in the oracle/ora81/jdbc/demo/samples/oci8/basic-samples directory and the compiler cannot find the oracle.jdbc.driver package contained within the classes12.zip. I have also tried unzipping the file but to no progress. My classpath is correctly ...

hi I am having a problem with connecting to oracle by using odbc driver. On windows 95,NT I installed oracle 7.2 and tried to connect to it using odbc(Microsoft odbc driver for oracle) driver ,when i run my java application an window appears on the screen saying oracle client and network ...

Hi,when I am trying to connect to the Oracle database ( v 8.0.5) on Windows NT 4.0 using the JDBC drivers it gives an Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\orawin95\BIN\oci805jdbc.dll: One of the library files needed to run this application cannot be foundat ...

Hi,Do you have to close a connection in the exception handler ? That is if the connection can not be established (eg database connection creation timeout) is it necessary in the create connection exception handler to close the connection?CheersGreg

Hi Friends, I am in a great trouble!! I hv a procedure which has a print statement in it. Is it possible to capture or redirect the output of my print message? Say, my procedure is like create procedure MyProc asselect * from table1print "Hello World!!"go When I run my JDBC query thru ...

Hi all,Can anyone please tell me how to use jdbc with mysql.I have downloaded mysql_jdbc driver but ones I tried to connect my database it find the driver.Any help?JamesL

Hi I am experiencing a memory leak in a test application using the JDBC-ODBC bridge to access an MS Access DB.I close the result set, statement and connection objects after each query. Even then the memory allocated to the process increases by about 20K after each query.Is there anything else I ...

hi everybody?how are you doing?i have a small problemi hope helps me get rid of itthe problem is:i wrote a servlet which makes a connection to an MS access database and retreives a data.I am having an exception saying that one parameter is missing ?Can someone tell me what is wrong with this ...

I have a Java Application and a db2 database(SWDTEST) that reside on the same server. In the Application I want to connect to the database. What would I use to do this? When the application resides on a client machine I use the "sun.jdbc.odbc.JdbcOdbcDriver" driver and can get a connection. ...

Setup:MySQL 3.23.41/Jakarta Tomcat 3.2.3/Apache 1.3.20/ JDK1.3.1/Redhat Linux 7.1/ and Macromedia Ultradev for JSP development. JDBC driver: mm.MYSQL.jdbc.Driver version 1.2c also tried mm.mysql.2.0.1.bin.jar. Problem: JSP pages generated by Ultradev, to add, delete, and update records to a ...

Using the JDBC:ODBC bridge, I have connected to an MS ACCESS 2000 database. I can retrieve information fine, but whenever I execute an update query or try to edit data in a ResultSet, the changes are not reflected in the table. Delete, Update, and Insert SQL statements have been unsuccessful, ...

Are there any FREE Type 4 Microsoft Access drivers out there?

I have some problems with connecting DB in my program. I read many forms of creation of connectin string and writting programs. Can anybody help me? I need an example of writting simple program connecting MS SQL Db with JDBC.

Did anybody try to connect to SQL Server via Merant driver? Here are pieces of my code: driverClass = Class.forName(attrs.driver); Driver d = (Driver) driverClass.newInstance(); if (!d.acceptsURL(attrs.url)) { .... }where, attrs.url is :jdbc:sequelink//hostname:19996;databaseName=dband ...

Hi ,I am using the trial version of the i-net UNA 2000 driver version 3.03 for SQL server db7.0. Its working ok but what happens was once in a while I am geting the following error on the weblogic. My driver is on UNIX and my OS is also UNIX(Solaris). I do not understand which is causing this ...

hi, can anyone help?I'm using Access (95 - v.7), and the standard jdbcodbc driver.The more primitive method of adding/updating a record works fine (i.e. sending a SQL Insert or Update command), but when I create an updatable ResultSet I get an Exception on rs.InsertRow() or rs.UpdateRow().I ...

Hi,Oracle does not support server side cursors,if so how does jdbc fetch a set of records(set by setFetchSize(), which is 10 by default) each time I say rs.next().Does this mean Query is re-executed to fetch the next set of records? Can some body throw some light on this?thanx in advanceGnayan ...

the developers here are trying to access ORACLE(tm) (8 and 8i) and I've encountered the following problem: the jsp pages can connect to the databases as long as the bases are local to the pc where the jsp's are, but when trying to connect to servers outside the machine, the same .jsp's give ...