I have to move data between 2 tables and i was wondering if anyone knew the best way to do so from java. I am doing the following:select 1000 (made up this number) records at a timeinsert those records in other tabledelete from current tableThe problem that i get is that the select is very slow ...

We have a problem with the jdbc driver and jdk 1.3. We are required to use 1.3. However, the following will NOT load the oracle jdbc driver. Classes12.zip is in the path.try { Class.forName("oracle.jdbc.driver.OracleDriver"); out.println("Oracle driver loaded successfully.");}catch (Exception ...

Hi I want download JdbcOdbcDriver from java home pageBut I can't find the product(I use windows 2000)Please tell me how to do or detail url.Thanks a lot David

I have a class which has methods a)to create a connection and a statement b)execute a query then returns the resultset, and c)executes update. I put the closing of the stmt and connection in the finalize method. I then have other classes use the executequery method of the above class and ...

I have read a lot of article about this errorI m also having this problem with 8.1.6.0 or 8.1.6.1 oracle db ( and classes112 jdbc drivers ) and my applicationI have checked that I close every statment,preparedstatment,recordset and connection ( connections are closed every 30 sec by a dbpool ...

Can anybody provide solution for me, can it be possible for me to use JDBC Driver other than type 1 i.e JDBC-ODBC for MS-Access, i want to improve performance.As i want to trans fer data to and fro from Web Server.Thanks in advance.Khiz_eng

Hello,I have a small SQL problem...I am designing an online bank using servlets for a university project and it allows customers to view their statements. They select which of their account numbers they want to view the statement for and the start and end date of the statement.The problem lies ...

I am trying to access a SQL Server using a trusted Windows NT group that has been established. I have set up the group in the database's security and assigned it to the appropriate prepared statements but I'm not sure how to access it using Java for authentication of the connection. I can ...

Hi I am passing vector in session between two jsp'sIn the first jsp I have session.setAttribute("serialnumber_Vect",serialno_Vect);In the recieving jsp I have the followingVector serial_Vect = (Vector)session.getAttribute("serialnumber_Vect"); But i am not able to see the values in the ...

Hi Folks,Following is my JDBC code using Oracle 8.1.7:<code>p= conn.prepareStatement(stmt,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);rs= p.executeQuery();crset = new ...

I am trying to figure out how to make transactions serializable, but with little success. I am experimenting with a simple example, where two tables(XTable(x), and YTable(y)), each of which has a single row. One transaction tries to read x, then set y as y=x+1. The other tries to read y, then ...

I would be the most grateful if you help me to chose the best FREE Object/Relational Mapping tool/code library.Any suggestion is welcome.Thanks.

can we set the Isolation level of the UserTransaction in case of bean managed transaction or in case where we are handeling transaction in servlets (I am trying to do it in servlets by geting Javax.Transaction.UserTransaction through JNDI in weblogic). UserTransaction only have few methods and ...

JDBC for oracle 8.1.7 connect to oracle8.1.5 for NT successfully. But When it connect to oracle8.1.7 for solaris , it report that:" Io exception: The Network Adapter could not establish the connection.".I do not know why.

My plan is to make a program that transfers data from one database to an other, those databases can be in different computers. What I was wondering is if it is right to do this in Java and if maybe there's allready some bean for that.Thanx in advance!

Hi all !I try to connect to Oracle database using jdk 1.3, and defining classpath = classe12.jar.There's no problem at compilation but errors runtime.Thanks, it's urgent !!!!!!The source:import java.sql.*;import oracle.jdbc.driver.*;public class OracleConnection{public static void main ...

I have a standalone java program which calls methods on 2 java classes (c1, c2) These are Non-EJB/non-RMI/non-CORBA plain java classes. the method in c1 updates table t1 in database db1the method in c2 updates table t2 in database db2I would like to use JTA for conducting a 2PC based ...

Wehn I try to connect to DB2 in my java class,I receive the following exception:COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030But I am sure that I have close all connection.why?The following is ...

Hello I'm doing a JFC -Swing Application ProjectI wan't to make printing reports on database fieldslike crystal reports. Is there any tool available for this?How can Integrate these reports with java Application?If there is no Visual Report designer exists for javathen what methods I should ...

Hi,I have just downloaded the j2sdkee1.2.1. I have been able to configure it and try out couple of example until the example "accounts", I tried start cloudscape use command:cloudscape -startthe error message is like following... Can anyone help me with this? Thanks a lot!! Sat Sep 15 17:55:53 ...

Hi,i had always been using window control panel ODBC feature to add my database. Then use jdbc:odbc:dbname to make a connection to the database. Is there another to do a jdbc odbc connection other than doing the setting in control panel? Please help me i am quite new to this.

HiI am developing a database software. one of SQL command is getting double data type info from JTextField that can hold even empty value. It works fine but when the field is empty, exception occurs. Any help is welcomemortoza

Hello, i am trying to retrieve the value of a column which can be null but i get a very general message:java.sql.SQLException.this is the code i use: try { Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection( "jdbc:odbc:hospital","doctor", ...

Im new to most of this ,so please bare with me. I have a tablewith email addresses. And I would like to delete a record if it is no longer in use. How would I write this would it be something like this "DELETE [Email Address] FROM [Email Addresses] WHERE[Email Address] LIKE '" + emailString + ...

i get this result when i run the code below: Driver Loaded Exception- java.lang.NullPointerException error=null [code]try { Class.forName("com.internetcds.jdbc.tds.Driver"); System.out.println("Driver Loaded"); String url = "jdbc:freetds:sqlserver://ws125/pubs"; String user = "sa"; String ...

It seem to me that my previous post was unsuccessful.My problem is: i bought a web storage for my website at Webvision. I need to do JSP using JDBC:ODBC to connect/bridge my MS Access database.I normally register my database at ODBC 32bit in the control panel, now the server is not mine, how do ...

i have connected ms access database using JDBCODBC in applet it is working fine in appletviewer but not showing anything in IE. whereas java console is showing classnotfoundexceptionthanks mussarat

Hello all I am trying to connect to Oracle 8.1.7 using thn driver.My connection string is on=DriverManager.getConnection("Jdbc:oracle:thin:@ip:port:SID","userid","passwd"); I am getting the error SQL EXCEPTION : Protocol Violation Can some one suggest ...Regardsankur bahl ...

For our Web application , we are using Apache,Tomcat,MySQL on both windows and Linux OS.In Some pages we have to do more than 100 queries. This takes so much of time (about 70 secs ) to display the resulting jsp page. In Oracle we use Stored Procedure so it takes 2-3 secs. But MySQL/MS Access ...

Hi therecan anyone tell me what the syntax of the query is when creating a table and you want a sequential, ascending identifier as one column? This is somehthing like the identity property in SQLServer, but i want to implement this in MySQL..any help appreciated, cheers,MB ...

Hello all,I have been programming in Java for a couple of years, however, I am fairly new to WebLogic server. I was able to install it and to create a connection pool to my database, using oracle.jdbc.driver.OracleDriver as a driver and jdbc:oracle:thin:@hostname:port:dbserver for url. The pool ...

I want to send the result of a query from the servlet back to the applet. There is only one column, but more than one row. What is the most efficient way to send it?

hi,Im developing an application using Java2.0 and ColdFusion 4.5. Im using the Java class to lock a record by using "select from table for update". My application is like lock the records the user has selected and use the same connection object to update the database when he makes a request ...

Hi all,I need to validate request.getParameterNames() against the actual fields in a particular table but I can't figure out how to query the DB for just the field names...SHOW columns FROM myTable; returns too much junk...I just need the field(column) names.There must be an SQL statement ...

hi,I have a problem inserting values to oracle database. when i use ms-access with JDBC-ODBC driver it works fine.I am using JWS, copied .html into Public_html and .class into Servlet directory everything is working. what changes should i do when i use microsoft odbc driver for oracle. The ...

Hi Developers,I have a question about copying of a resultset object into another ResultSet object. To make it much clear of what I am trying to do, I am retreiving a particular row by using absolute(int) method in a given Scrollable ResultSet object(rs1).Now I want to store somehow the values ...

Hello all...I had a question and didn't know exactly how to go about it...I have a sql database with about 5 columns and one of those columns being a "beat" consisting of codes. What I would like to do is this:In a separate table i have the "beats" along with the matching zip codes of a ...

Hello,I'm trying to limit the number of rows that my application receives to a user-specified value. The user is asked how many accounts they want returned and I want to limit my ResultSet to this amount. I'd prefer to set up the SQL to do this if possible rather than waste time returning ...

I am trying to insert a value of type date time into an access database. What is the format needed to insert the date/time.Thanks,-Amos

hi all,how can i convert this update statement to a prepared statement...? // this will append 'newData' // to the current value of colName UPDATE table SET colName = colName + 'newData' WHERE colID = 1 // i tried using this, as the tutorial says that // just replace your values with a ...

Hi, How to encrypt data while using JDBC connecting to the DATABASE? Thanks in advance!Tao2001/09/17

Hi!Has anyone an example code for inserting BLOBs into MS Access tables? How can i store and retrieve these objects into MS Access? Anyone a clue?thanks

Could anyone give a roundabout decent time for inserting or updating 1000 rows of data in a 15-column table via JDBC? I mean, what's a good rows-per-sec or rows-per-minute number? I'm using Oracle.

Hi, Does anyone know how to create a search engine using JSP/Servlets and MySQL (any DB actually it doesn't matter). If you know where I can find a good article on this please point me to it. Been searching high and low. Can't find it. ThanksRahul

Is there a page listing the common data types in the latest SQL standard implemented in most current DB systems?For instance, MS SQL Server has "nvarchar" but MySQL has "text"... Is it possible to use the CREATE command w/o any proprietary data types?

Is there any way to access the ODBC Control Panel information to retrieve the System DSN's that have been setup by a user?Any help would be appreciated, thanksRick

I am tasked with implementing XADataSource, XAConnection, and XAResource for a data source that does NOT support suspending and resuming transactions via a single connection in behalf of multiple threads.Under what conditions will a TM attempt a suspend?How do I handle a suspend if it does?Will ...

Im storing information in a talble (Invoice), and atthe end; the table is generating a number(Invoice #).ie im trying to generate an invoice # which is unique. I know how to save the info, but my problem is how to retrieve this number. Is there a way to read the Invoice # column prior to ...

Is there a way to limit the number of rows that a ResultSet keeps in memory? I am working with very large ResultSets that will not always fit in memory.I am considering using setFetchSize(), but I do not like the description of this method as only a "hint" to the driver. Has anyone tried out ...

Hello everyone!Does anybody tryed to estblished direct connection form Java application running on Linux to MS SQL Server database running on Windows NT?I just started to dealing with this problem, and find out that i need to install JDBC driver type 4 on the mashine to have connection. But i ...