I am using PreparedStatement to update a table. In the debug phase, I want to see the sql statement string, does anyone know how I am able to see the sql string? That is, in below ***** area, what should I add to show the sql statement ? Thanks in advance.A sample code ...

Hello!My situation is this: I have a J form with buttons and text boxes as my GUI, and i have another class which makes the connection to the database. I'm doing CRUD operations with my GUI, but the only problem is with the select. I have a text box that accepts the employee ID, so when i press ...

My simple questions is how can I deal with an apostrophy when I trying to save to the table, here is an example in how I am saving. 'Sandr'as Casa' this gives me an error message. I have to do it like thisStrings.replace("Sandr'as Casa"," ' "," ' ' "), a package functionSQLDesFollow = ...

Hello, I'm new to java and have a few questions when running sql. I have no problems connecting to the Oracle 9i database, but my questions are these:(1) I have a CREATE TABLE statement. How do I check to see if the table was actually created? SQL returns the statement "table created" if it was ...

I have rattled my brain on this now for a few days. i have searched hi and low, and cant find an example on creating a server for the Data base HSQLdb, there is the code that i am using, the problem is it always returns as the discriptor "shutdown" and i dont know what i am doing wrong, thus NO ...

Hi,I have a problem where I have implmented batch updating in my application. However, we need to include a timeout feature that will execute a batch after a specified amount of time. For example, if we implement so that we add 25 statements to a batch before executing the batch, if there is a ...

I have created a Database Application in Java and display all the records in tabular format of one Table. This table have Millions of Rows, If I run Select * from Table, then my Machine not responding, so Now I wants to add paging of 1000 rows at one time.Is there are any option to read block of ...

Hi there guys,I have a problem running my java appplication from an exported .jar file. In fact, when i'm running my prog on bluej(Java IDE) it runs correctly with no probs or exceptions. But when it comes to export my application into a .jar file, i get the exception "No suitable driver found ...

Hi there guys,I have a problem running my java appplication from an exported .jar file. In fact, when i'm running my prog on bluej(Java IDE) it runs correctly with no probs or exceptions. But when it comes to export my application into a .jar file, i get the exception "No suitable driver found ...

Hi, Ihave to compare 2 columns in a given table Table_Test in oracle database . if the column1 > = column2 then "True" is displayed and if the column1< column2 then "False " is displayed. if i use the Decode() funtion then it just checks the Equality but not "<" or ">" . if you have any clue ...

Dear all, I wrote a program is as the follow:import java.io.*;import java.sql.*;public class handleExcel {Connection con = null;Statement stmnt = null;public handleExcel() {String excel = ...

Hi,Is there some way to check the number of applications connected to a mysql database?I have two different Java applications that will be using the same instance of MySQL.My requirement is that, I want to close the MySQL instance while closing the Java application.But before doing so, I want to ...

i have created a webapplication using java, struts and hibernate3.0my database is oracle9ii have netbeans 4.1 as IDEiam using sunjava webapplication server for my deployment purposes.My webapplication was working fine until recently when i restarted my system where the applicationserver was ...

i have created a webapplication using java, struts and hibernate3.0my database is oracle9ii have netbeans 4.1 as IDEiam using sunjava webapplication server for my deployment purposes.My webapplication was working fine until recently when i restarted my system where the applicationserver was ...

Hi all,i've a thread that open a jdbc thin connection on oracle db in every instance of it.for explain something like this:public void run(){........ Connection conn=null; try{ ....................< log lines 1>conn=DriverManager .getConnection();conn.setAutocommit(false);................< ...

Can I share Connection and Statement (PreparedStatement) objects between threads?I have some concurrent processing that is inserting records using the same SQL syntax and I would like to create a PreparedStatement to improve the performance. The statement needs to be accessed by multiple threads to ...

Hi, I want to create an instance of a BLOB(MySQL-DB). I use the MySQL-jdbc-driver. The problem is, that the constructor of the BLOB-class is not public. And i don't see any Factory-methods for creating a BLOB-object. The reason is - i want to store pictures in a DB. But i don't want to use ...

<p>what is better OCI or thin?</p><p>thanks</p>

I've got a problem returning a large resultset (approx 1.2-1.5 million rows), in that sometimes the query doesn't run to completion because either I'm pretty sure the client keels over, dies, you get the picture. I've usedstmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, ...

i am trying to view records from a database upon clicking the NEXT buttun in order to bring in the next record. Before that i click SHOW ALL which brings me all the records. However, it only shows me the first and last. I did a system.out.println and it shows me all the records inside the ...

<p>Can anybody tell me a good site or link on struts & database ?</p>

Hi, In a oracle database table i have a colum that gives the value from 0 to 2359. I want to convert Number to time in Oracle. Any i dea on the query for this. I have tried SELECT TO_CHAR('2342','HH:MI') "Time" FROM dual; but it is not ...

Hi All,I am working on a Data Warehousing Product and generating Web Reports.These Web Reports are JSPs.The basic architechture used for this is :1. Get the inputs required for Report Generation through a Web GUI2. Validate and Process (If Valid) the inputs so that it can be applied on the Data in ...

<p>I'm restoring my MySQL database from java code.</p><p>I use Process for running a batch file and i need to roleback if there were any exceptions.</p><p>How can I track the exceptions?</p><p>Is there any way doing it with jdbc "Statements"?</p>

hi,i am developing a website .i would like to know if it is safe to use servlet+jdbc to insert large data like blob/clob in MYSQL 5.0.i also anticipate large nuber of transactions like dtaa retrival and data storing by users.Is it fin efor me to use MY sql 5.0 and servlets to do this process.please ...

Hai AllsrcSmt=srcCon.prepareStatement("select * from main_info, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);srcRst=srcSmt.executeQuery();There is no records in the table "main_info", but the srcRst.next() method return true? . and it shows "invalid cursor state error" .Why i got ...

Hello everybody,I have a question about a problem that I have.I have a sql procedure that is running. This procedure is very long, sometime one hour.But in some case, we must stop it in order to run another procedure more important.For this emergency, I do two threads : main thread that launch ...

Hello all!I'm having problems with the PreparedStatement in my class.. This method is going to insert data into the DB with parameters passed from another class. This is the error that Netbeans provides when i compile :-symbol : method PreparedStatement(java.lang.String)location: interface ...

I'm trying to connect to the snp_mart_45 database in Ensembl (port number 3316) with the following config:final String ENSEMBL_CONNNECTION = "jdbc:mysql://martdb.ensembl.org/snp_mart_45:3316?user=anonymous";However, I get a socket exceptionMESSAGE: java.net.ConnectException: Connection refused: ...

Hi My application has some dynamic tables where we are generating table names and the columns based upon client requirements,for this dynamic tables we are using jdbc and the rest is hibernate .here i am unable to propagate the same transation from hibernate to jdbc.When something fails in middle i ...

<p>Hi,</p><p>I'm trying to execute a specific query by clicking a button.I was trying to use inside actionperformed code different Statement and resultSets but every time throws errors.I'll be appreciated if someone give me an example similar to the previous description.</p><p>Thanks</p>

Hi,I am trying to insert bulk records into table using addBatch & executeBatch. while inserting through executeBatch if any one of records throws exception remaing records are not updated (for example if i am inserting 10 records if 5th record fails to insert into table i want remaining 6 to 10 ...

HiI am trying to set up a connection to the javadb database. I have created the database via the netbeans IDE and have a simple table. The table is located in C:\javadb\database.My iReport connection settings are:JDBC Driver - org.apache.derby.jdbc.EmbeddedDriverJDBC URL - ...

while i try to connect to the database i'm getting the foollowing errorjava.security.AccessControlException: access denied (java.lang.RuntimePermission accessClassInPackage.sun.jdbc.odbc)the part of my code which is used to connect to the database is as follows/* <applet code="Part1" width=500 ...

Hi,I have a question. I made a complete J2EE application on top of a mysql database. When I delete or insert or update a table in my application the changes show instantly. In my application I use PreparedStatement.The problem is when I want to edit some data in the database using the mysql command ...

<p>hi to all..</p><p>i'm new to oc4j .. i used to work on tomcat.. and i know that i used to put the war file inside /webapp folder .. now in oc4j where shall i put it...</p>

Hi!I trying to code for Report using jasperReport.I need to pass two different data source to the jasper report.But jasperReport support only one datasource.Both the datasource will be decided in runtime.One of my datasource is SQL and other is XML these datasource has different Numbers of Row.(I ...

my code:<%@ taglib prefix="c" uri=" http://java.sun.com/jstl/core_rt" %><%@ taglib prefix="sql" uri=" http://java.sun.com/jstl/sql_rt" %><%@ page import="javax.sql.DataSource" %><sql:setDataSource var="jdbc/myoracle2" driver="oracle.jdbc.OracleDriver" ...

When entering a date into a MySQL database through hibernate, the date is eventually changed to be one day before the one originally entered. I can't think of anything that might be doing this, could someone offer a suggestion as to a solution? I find this problem very odd, and don't know where ...

Hi,I have a DB2 db as source and an Informix DB as target db. I have something like this:String sourceSql = "SELECT x FROM y";ResultSet rs = ...;Connection targetConn = ...;PreparedStatement ps = null;while(rs.next()) { Long x = rs.getLong("x"); String targetSql = "INSERT INTO y (x) VALUES (?)"; ps ...

Hi ...in one of my methods there's this query executing...the query is executed perfectly, but whenever i want to check if the result set coming from it, if it's null or not, i get SQLException,, i have the same problem in another method...here's a snap of the method..ResultSet resultSet2 = ...

Hello to all:I've encountered a tough problem with CachedRowSet. I need to construct a dynamic CacheRowSet reusable later without updating his data Source: I've tried moveToInsertRow(); and insertRow to add a new line but it seems to me that my new rowset can not be read when I do "rs.next()" who ...

<p>how can i insert a string which contains a single quote in to database... anyone help</p><p>Message was edited by: </p><p>sijo_james</p>

<p>hi frnds, i have created my own connection pooling class,i need to implement this class in my struts application i dont where to initialise my connection pooling class.... can anyone tel me the suggestion to do that...?</p>

Hi ,I have a problem with ROWSET.I have a table with 6 columns and approximately more than 200 records.I reterive them in a ResultSet and resultset gets populated.But I populate Rowset with that ResultSet then it hangs for atleast 1 minuate and then it comes back to its original state.Can anyone ...

Hello shlumph and SoulTech2012.thanks for the reply. Im wondering do any of you have links to web pages that include tutorials and source code on using JCheckBox, JButton and JTextArea with JDBC. would any of you who have experience with using JCheckBox, JButton, JTextArea and JDBC together be able ...

Hi,I have a performance problem with record set object. Is it true using RecordSet object as argument to the method will cause any perfomance degradation?here is my code.finStmtList = selectFinancialStatements(rs, shortFormat, latestOnly, true);I changed the code by populating the recordset in the ...

Guys,we have developed a java application with SQL-Server as backend, under Windows platform.now, we are converting that to Linux platform.In Linux, i am getting problem with using the same driver for database connectivity, which i used under Windows.do we need the linux version of that same ...

hi folk.i'm considering some examples of jboss, "jbossatwork" http://www.jbossatwork.com/downloads.html. i somehow understand first 4, but i'm now stuck in 5th.as i get, the problem is in binding hibernate. see, in 4th example (ch04) it binds through JDBC (JDBCCarDAO), and in 5th (ch05/05a-list) ...

select col1,col2,col3,col4,col5 from TABLEwhere col1 between 816 and 18644 and col2 between 0.19 and 8.02 and col3 between 'D' and 'Q' and col4='FL' or col4='VVS1' or col4='VVS2' or col4='VS1' or col4='VS2' or col4='SI1' or col4='SI2' or col4='SI3' or col4='I1' or col4='I2' ...