Hello,I am using stored procedure.It returning me a result set.How can i get that result set from java program.

HiI use Sybase SQL Anywhere 5.x, Apache Server, Apache Jserver.(WINNT)I must to write servlet, which connects to Sybase database using JConnect.When database is on the same host as Apache server, and my servlet i run services:Open Server Gateway (dbos50.exe <server_name>), where ...

I'm working with Application Server WebLogic 5.1. In my Servlet or JSP why can't I invoke the ResultSet methods getRow, afterLast, beforeFirst when the method next works?My error message is:Servlet failed with Exception java.lang.AbstractMethodError

*********** PLEASE HELP? **************88888888 Why the "Invalid handle? 8888888888 private synchronized void remove_Q_firstElement(StringURLRmve){try{statement = connection.createStatement();if(!Q_ToSearch_isEmpty()) {String query = "DELETE FROM QToBSearch WHERE URLToBSearch = '" +URLRmve+"' ...

Hai i want to export and import the ms-word document to Sql server.it is like sending attachment and downloading attachment with e-mail.please help me how can i do this.if u have example please give me.what data type i have to take for that coloumn.thank u in advance. ...

I was trying to use preparedstatement like'select * from tbale where column in (?)'ps.setString(1, 'value1','value2');It doesn't reurn any rows.ThanksSrinivas

If I have a PreparedStatement or CallableStatement, and I want to get the sql that was specified when I created the statement from the connection, how do I get it?

Iam working on Windows 95 and trying to connect to MS-Access 97 database using the following code:String url = "jdbc:odbc:MS Access 97Database;DBQ=c:\\utuGatewayCtl\\HEM0000101.MDB";Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection con = DriverManager.getConnection(url);and Iam getting ...

Hi, are any known problems when using the JDBC/ODBC bridge, with MS_SQL and then using PreparedStatements with LIKE. We where going to do this, we had something like : PreparedStatement pstmt = conn.prepareStatement("Select * from Employees where LastName like ? ");pstmt.setString(1, 'A%');rs ...

How to "CREATE VIEW" by using JDBC? Thanks.

I have a small problem.I have been using the rowID in oracle to identify rows that do not have a primary key. I know ROWID is an oracle specific datatype, but is there anything in the JDBC framework that provides a similar functionality. Obviously the ResultSet objects have a pointer into rows ...

Hey Everyone!!Is there anything in Java's API, that I can use to develop a standalone database? I can connect to MSAccess and MySQL via JDBC.... but I want to develop a standalone application that has it's own database, rather than making sure every system this is installed on has some ...

Hi,By creating Result Set I want to go forward and backward on ResultSet(I want use methods absolute(), first(), last() and s.w.)But I get an ErrorJZ0BT: The first() method is not supported for ResultSets of type TYPE_FORWARD_ONLY.Thanks

Hi, I have my application running on Win NT. This application connects to MS Access 2000 using JDBC-ODBC. We need to shift to Windows 2000. Will it affect anything? Do I need to take any care or make changes to code/drivers etc. after OS change?thanks,Shaili

Hi.In my application I would like to debug the SQL's sent to my DBMS.Is there any way to see the SQL in a PreparedStatement AFTER I dynamic have set all values?, except go through the DBMS debugging?/Andreas

I'm using the JDK 1.3 trying to get a table name of a column from a result set. Regardless of what driver I'm using (ODBC Bridge/Oracle) I always get a null returned. Does this method work? If not, if I'm doing an SQL query that uses more than 1 table and each table has a return of the same ...

Hi to everyone,I am encountering with an exception "ResultSet is closed", as i was inserting fields into database with one of the field as null value.Can anybody helps me out with this.Thanx in advance.khiz_eng

Hello All,Can I execute an procedure defined inside an Oracle package using jdbc?Are the procedures defined inside Oracle packages are same as stored procedures ?Any help would be grately appreciated.regards,Abhishek.

Hi,My requirement is to read data from an Excel file, play around with the extracted data, and write the result back into another Excel file. I don't want to mess around with BIFF8 formats and stuff like that.Is there any readymade tool available (i mean an API set) which provides me with the ...

Hi,I am having some problem with the result that is returned after executing a preparedstatement. The preparedstatement works fine as long as there is no null value in the result but if there is a null column once, all subsequent queries using the same preparedstatement will return a null for ...

Hi guys i am having problem with the insertion of a record in to a Access database!!!!It is not given any exceptions or errors but simply does not insert it!!!Here is my code!!import java.sql.*;class access{public static void main(String a[]){ // Set default values for the command line ...

i am writing a JDBC application. There will only be one user for this application.I want to know whether i am doing it the right way.Main program sets the connection to database and provides a static method getDBConnection() which returns a Connection object .All other programs have a public ...

Does anyone know where I can find the wrapper.properties file?

hi, i have this problem i am new to JDBC and i wrote a sample program to try out , when i complied the program it compiled fine but when i ran the program java progname i got a class not defined error , below is my sample code please can anybody tell me where the problem is import ...

Hi , I am using the iPlanet ApplicationServer 6.0 SP2 for development & testing of an internet application.I am facing a problem when I am trying to connect to MS SQL SERVER via the native jdbcodbc driver (obdc32.dll). The error is something like this : [26/Jul/2001 11:50:35:7] warning: ...

I have created a custom tag that does inserts. While it works on most every other table that I have dealt with, I keep getting this error for a particular table. I have created another table on an entirely different database, but get the same error.Is anyone familiar with this error? I'm ...

Hello,I'm getting the error "No suitable driver" when I connect to Oracle 8.06 database with Oracle JDBC 8.1.7 driver from Java client program on Windows' NT. i use the commands Class.forName ("oracle.jdbc.driver.OracleDriver");DriverManager.registerDriver (new ...

Hi allRight now I am developing a web application in J2SDKEE1.2.1 using Cloudscape databse.But my project specs says that I have to use MySql for this application.I need to know what steps I have to take to replace Cloudscape with MySql.Please help.Thanks RajaniP.S I am using CMP to communicate ...

I am using MySQL. After I manually logged in, I mean, using "mysql -u username -p passward",I tried to CREATE VIEW by using the following command:mysql> CREATE VIEW csclass AS SELECT * FROM CSGRADE10;Here, CSGRADE10 is the table already been created.The error message is:ERROR 1064: You have ...

hi,im a newer of java program...and write out my first database programm by using jdbc. everything runs fine except it's much slow than those program i'v wroted withVB or VC. im trying to trace it and found that the problem is that every time the connection with the database(SQL Server) spend ...

someone please tell me whether freetds driver works on win 98 or not

Hello all,Now that I've got your attention with the $$$ how about we get down to the fun part :-) Why is it that I'm getting the following exception? More importantly (I think)is it because I've open and Not properllly close my n number of ResultSet objects?Any ...

hi has someone ever connected MS sql server installed at webserver from client application using JdbcOdbcDriverplease tell me if it is possible or not.

Hi everyone, Can anybody assisst me, how i can sort my table (which is in MS-Access) in ascending order through my java application.Please provide me as soon as possible.Thanx in advance.Khiz_eng

I am using following code to connect to the MS SQL database:Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");connection = DriverManager.getConnection("Provider=SQLOLEDB.1;" + "Integrated Security=SSPI;" + "Persist Security Info=False;" + "Initial Catalog=Northwind;" + "Data ...

I wrote code to insert data into a database using servlets and jdbc. The code works fine but I am having problems with certain users. I am getting the following error:com.sybase.jdbc2.jdbc.SybSQLException: rnd_ref_tbl not found. Specify owner.objectname or use sp_help to check whether the ...

I've been trying for 3 days to do that but nothing worked ...Not setBinaryStream(x, new ByteArrayInputStream(anArrayWith10KBytes), anArrayWith10KBytes);nor setBytes(x, myArray), or setObject(x, myArray).Is there any way to store Blobs to Oracle 8.1.6 using the thin driver ?Please help ... ...

Hi, I have a stored procedure in oracle 8 that has a Table as an out parameter. the table is declared as type RulesArray is table of alert_rec; The procedure declaration is like this PROCEDURE using_array (rule_array out RulesArray);How can i retrieve this in my java program. I am using jdbc ...

Hello,I have created a Java client NT application on Visual Age which interacts with Oracle database thru JDBC driver.when i give import oracle.jdbc.driver.*;the visual age editor is not able to find the above package, whereas when i export the same application and execute it on DOS environment ...

hi allcan any body give me steps to create a connection pool in weblogic6.0. and Datasource. i have created and trying to connecting but i am getting error unable to resole "mypool" it is a connectin pool name.can any body give me the steps to do.thanksparuchuri ...

hi, does anybody know how to use the setLogWriter(PrintWriter ) and getLogWriter() which are static methods in DriverManager class .These methods can be used to create log files of ur database operationsthanksraghav

Hello everyone, I'm new to programming java, but have done developement in C/perl. I'm trying to access this Oracle8i db on the network. The DB is on Irix 6.1 and i'm running win2K, the tnsnames.ora is already set and the db is refered to as mmx. We are running oracle 8.1.6 on it. I went to ...

My code is: <%@ page info="Company Master" import="java.sql.* " session="true" %> <html> <head> <script language="javascript"> function f1() { var x=document.company.code.value.toUpperCase(); if(x!=null) document.company.code.value=x; } </script> </head> ...

If I retrieve a lot of records from database. I want to Display those records on multiple html files. I Mean show maximum 25 records per page. Tell me how to distribute among several pages.Thanx in AdvanceASgherasgher@lww.org

hi,freinds,below given code gives me some problems.i have 3 table namely input, reaction, prss. for (int i=0; i<10 ; i++){query="select * from input"; ResultSet input=st.executeQuery(query);input.next();m=input.getDouble(1);b=input.getDouble(2);query="select * from reaction"; ResultSet ...

Has anyone encountered a limit to the number of jdbc connections that can be pooled within one process. We are using Java 12205a, Weblogic 5.1sp9, and Oracle's 8.1.6.0 OCI drivers for our application on a Solaris 7 box. We have noticed that our application becomes unstable and in some cases ...

Hello,I am running a Java program which handles the UDB connections on SunOs5.6. I am getting the following exceptions.Exception : (Class COM.ibm.db2.jdbc.app.DB2Exception ) [IBM][CLI Driver]SQL1032N No start database manager commandwas issued. SQLSTATE=57019 First 10 Connection are sucessfully ...

I wanted to know how to make the transactions wait till another transaction completes on the same row of the table.This is happeneing in primarykey generation. i try to retrieve the value from the same table, it is giving Locked time out exception, if more than one request is being sent to ...

Hello,I'm trying to use the Sun Jdbc-Odbc bridge with MS J++.if I import the rt.jar file to the classpath of my project in j++, as I run or debug the project, I get the following error message: "Unable to locate system class: java/lang/String"How do I use the sun Jdbc-Odbc bridge, on the MS - ...

Hi all! I need some help down here, since I don't have any idea of what is happening.I'm trying to execute a query (one that is generated dinamically and that have nested SELECT into the WHERE clause). I'm getting the Invalid Cursor State message from the ODBC driver. That happens when teh ...