Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC) Questions
- UnsatisfiedLinkError
  Hi,I have Oracle 8.1.5 client installed on my machine and was able to get the JDBC thin driver up an...
  By developer
- JDBC driver 8.1.6.2.0 problems
  I've upgraded my JDBC client to use thelatest 8.1.6 driver (8.1.6.2.0).I upgraded my client sof...
  By developer
- Calling three different stored procedures through ...
  Can anybody help me for this problem:Is it possible in java that through one API, i can call more th...
  By snehlataa
- Connection/Statement question
  HI There,Quick question on connection objects and statements. Assume that weimplement a singleton cl...
  By simfox3_yahoo
- REF Cursor, Dynamic SQL and JDBC
  Hi - can anyone help. We are building an application which uses Java on the client and performs all ...
  By developer
- searching driver to connect to a Paradox 7.0 db
  hi all, i'm looking for a driver (may be Jdbc-Odbc) to connect my app to a Paradox 7.0 db.i have alr...
  By san_dro, 1 Comments
- Check the result set
  Hi,I want to know what is the difference between while(rs.next()) and if(rs.next())? I'm not sur...
  By ikasariwidiyanto, 2 Comments
- problem with inserting data in a same column using...
  hi,i am having a problem in inserting the data into database,i have 2 insert 4 rows into a column n ...
  By smylekhanna, 1 Comments
- recomend sql plugin for eclipse
  can anyone recomend a good sql-plugin for eclipse?thankspeter...
  By p_primrosea, 1 Comments
- SQL Server performace
  I have an application that intermintently slows down. I am trying to trac down the probblems.I hold ...
  By shawndesarkar, 1 Comments

Java Database Connectivity (JDBC): is the Category's subject.It's has 46,245 questions,this is No.2,313 pages.
JDBC DB2 Type 4
Hi,I want to know about JDBC DB2 Type 4 driver.I am written a test JSP. Can you please tell me if it confirms to Type 4 specification?<BODY><%try {Class.forName("com.ibm.db2.jcc.DB2Driver");String url= "jdbc:db2://MYDB.domain.com:446/MYDB";%><% java.sql.Connection connection = jav...
ratankumar, Sun, 14 Mar 2010 19:37:00 GMT, 675 bytes, 2 Answer
where ID = ?... how can i get the ID?!
i have this method used to update my contacts: public void updateContact(ContactPanel updatePanel){try{preparedStatement = connection.prepareStatement("update " + updatePanel.getName().toUpperCase().charAt(0) + " set NAME = ?, NUMBER = ?, EMAIL = ? where ID = ?");preparedStatement.setString(1, ...
alex1989a, Sun, 14 Mar 2010 09:07:00 GMT, 1,445 bytes, 27 Answer
JDBC 2.0, how do I know..
How do I know if the Oracle I'm using is JDBC 2.0 compliant. I'm assuming it isn't because whenever I make 2.0 calls I get fatal errors. We are using oracle 7.3.x Any help?!?Jan GonsalvesJan@icoms.com...
developer, Sun, 14 Mar 2010 01:57:00 GMT, 227 bytes
problem with UNION query
Hi frnds....i would like to know if java supports a result set containng a query of type UNION i.e. a query containng a UNION of two SELECT statementsi am askng this becoz, i want to create a JTable using such a query.The code which i have written to create a TableModel from the ResultSet has ...
vaibhavpinglea, Sat, 13 Mar 2010 21:33:00 GMT, 954 bytes, 4 Answer
problem with scrollable resultset
hii am trying to use scrollable resultset by using following code.Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);ResultSet rs = stmt.executeQuery("select empl_no from empmst");while(rs.next()){ System.out.println(rs.getString(1));}stmt.close();...
vrishalipal, Sat, 13 Mar 2010 15:58:00 GMT, 519 bytes
SQLJ REsupport Announcement
This is an announcement that SQLJ will be resupported, starting in 10.1.0.4 of the Oracle Database, and 10.1.3 of iAS. To help us make the product better, please let us know:1. What are the most useful portions of SQLJ?2. What would make developing with SQLJ easier?All of your thoughts will be h...
tjue, Sat, 13 Mar 2010 08:43:00 GMT, 359 bytes
Import Data from Excel File
Hi,I need to import data in excel file manually. But i cannot find the import option. I am using Microsoft SQL Server Management Express. Do this version have the import optionIf the Microsoft SQL Server Management Express does not have this option. Is there anyway to do ...
newbirda, Sat, 13 Mar 2010 05:30:00 GMT, 309 bytes, 1 Answer
JDBC - MYSQL Installation.
I have a Win98 machine. I want to MySql on it for my applications.I have downloaded mm.mysql.jdbc-2.0pre5.tar. and mysql-3.23.36-win.zip files from the MySQL site. I hope I have downloaded the correct files.Please help me what to do next.Thanx in advance ...
redam, Sat, 13 Mar 2010 04:55:00 GMT, 289 bytes, 1 Answer
Java stored proc: returning array?
Hi, I have had to implement a Java stored procedure that accepts a nested table as an argument from aPL/SQL package. The class must manipulate the data and then create an object or an array that can be returned to the package for subsequent interpretation and use. I'd assuemd that I could r...
kmg_merseymail, Sat, 13 Mar 2010 03:44:00 GMT, 1,002 bytes, 3 Answer
SQL Server vs Oracle
Hi,I want to know that while developing a java application, which would be a better choice for the database - SQL Server or Oracle?Thanks & Regards,Nidhi...
nidhisinghal, Sat, 13 Mar 2010 03:40:00 GMT, 177 bytes, 4 Answer
Kinda urgent Connection error messages
Websphere application for nurses license renewal application that hits our SQL Server 2000.This was the first error that we decided to stop and start the application:Unable to load SQL Server Data Driver driver.Unable to create database connection.[Microsoft][SQLServer 2000 Driver for JD...
jdnospam_hevanet_com, Sat, 13 Mar 2010 03:39:00 GMT, 2,064 bytes, 9 Answer
Java Stored Procedure
Hi,It will very helpful if someone could guide me with this problem.I am trying to execute a java stored procedure in Oracle Litelocal database. For example...1. After creating and loading the java class. I create the procedure as follows. CREATE OR REPLACE PROCEDURE drop_it ( obj_type VARCHAR2,...
porkc, Sat, 13 Mar 2010 02:42:00 GMT, 905 bytes, 2 Answer
Mysql installation
Hi alli need to install the Mysql 4.0.23 from a batch file.i can start installation and starting servicesi'm in Mysql> prompt but wat i written in bat file commands like creating database,tables are not working..How can i fix this..Help me...
chiruraj, Fri, 12 Mar 2010 21:53:00 GMT, 278 bytes, 1 Answer
commons DBCP problem
The commons DBCP doesn't work properly, the connection reuse is never done, i was trying the application with DBCP with initial connections set at 25 and when i hit the page 26th time, the page never shows up, the error cannot retrieve connection from the pool. Although my application always...
shankarnarayana, Fri, 12 Mar 2010 20:48:00 GMT, 827 bytes, 2 Answer
Transaction not rolling back
Hi, I'm having problems trying to rollback a transaction.I have to execute four functions that make some inserts and theymust be transactional. So, first, I set AutoCommit false, so Ican execute the rollback when an exception occurs. Then, I startexecuting my functions and everything is goi...
pdgimenez, Fri, 12 Mar 2010 08:27:00 GMT, 763 bytes
change in dropdown box should affect all the oher fields
When i change a value in a dropndown box then the according to the selected value in the drop down box, the values should be retrived from the database and should be displayed in the form. can you help me with this problem?...
minerva_7a, Fri, 12 Mar 2010 08:18:00 GMT, 230 bytes, 3 Answer
Sprinta SQL Driver and J2ee
I wrote a method, that make a simple query in my Databse, using JDeveloper and Sprinta SQL Driver 2000, and it`s work nice locally. But, when i created a Webservice with this Method and published it on the Oracle Application Server (j2ee) it doesn`t works. What i can do ?...
dak_certi_org_br, Thurs, 11 Mar 2010 18:11:00 GMT, 272 bytes
help
I have connected dbf file by java-odbc bridge,i can write and read records from dbf file,but can't delete records.Please tell me how can i delete record from dbf file by jdbc!...
lenonchena, Thurs, 11 Mar 2010 18:11:00 GMT, 204 bytes, 1 Answer
No driver found error while accessing SQL Server
Hi all,I am trying to connect to an SQL server (on my local machine)I downloaded the JDBC driver from the Microsoft site.I checked the SQL server version and also the driver, they are OK.the fragment of my java file that connects to DataBase server is file : "DBManager_SQL.java"..public ...
ayusman_dikshita, Thurs, 11 Mar 2010 18:11:00 GMT, 1,965 bytes, 2 Answer
oci OraOCIEI10.dll EXCEPTION_ACCESS_VIOLATION
I try to run a jdbc oci application in eclipse. I followed http://www.stanford.edu/dept/itss/docs/oracle/10g/java.101/b10979/instclient.htm#CHDDGJDJ to install instant client. I got the following message. It works in Jdeveloper... Please help.Thanks## An unexpected error has been detected by Hot...
jiaoyangs, Thurs, 11 Mar 2010 18:11:00 GMT, 971 bytes, 3 Answer
«««2303 2304 2305 2306 2307 2308 2309 2310 2311 23122313

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC) Questions