hello friends ,i have created a database in mysql.also i created an applet.when i checked it with appletviewer, it ran successfully by retrieving data from the database and displayed the data. but theproblem is that retrieval from the databse wont work when the applet is run in a web browser ...

Hi all, Could any one tell me how to release a connection that has been used by a backened procedure.For instance, if i create a connection and use a callable statement to execute a routine at backened Then is there any way to release this connection from backened for other important ...

Hi,I have a package ConnectionManager, I make an instance of it using <jsp:usebean id="CM" class="db.ConnectionManager" scope="request"/>I am trying to call a global fuction in my jsp which returns a string. When I call path(someFilename) then this global function try to use instance CM ...

Hello,I am working on a java program which connects to database and update some rows periodically.The program starts 5 threads and each thread use one database connection. So at max only 5 database connection will be open. Also after the job is done the database connection is closed. Now the ...

The following failure occurs when we perform insert operation using a connection which has the auto commit set to false.Operating System: IBM AIX Application Server: WAS Express 6.1.0.7 (WAS 6.1 applied update pack 6.1.0.7)JDK: IBM JDK 1.5.0 (Shipped with WAS Express 6.1.0.7)JDBC Driver: Oracle ...

I'm trying to read the Data that is present in abc.txt.The code that I wrote is given below.import java.io.*;import java.util.*;class test{public static void main(String args[]){ StringBuffer sb=new StringBuffer();int rows=0;int totalvalues=0;int columns=0;String s[];try{//scanner is used to ...

Hell there,I am extremely new to Java, and basically I'm trying to create a basic GUI app to keep track of my DVDs. Basically, I am having trouble connecting the app to the MS Access Database so that i can add/delete/update.So I was wondering for a simple or proper way to connect to an Access ...

dear friends...i connected oracle with jdk1.5 while connecting i give IP address... its very slow. instead of this i gave ' localhost' its very fast.... how can i connect thro network......(because oracle & tomcat server are in different machine)is there any problem in driver or my ...

Hi, guys. I no have a problem with my database application. I don't imagine how i can connect to db on ms sql server 2000, Just now I have downloaded an MSSQL JDBC Driver. Then How should i register,install this driver and can someone help me with the code, on how to connect to sql

pls how do i go about adding or storing pics to the database using java at my front end the code if possible

I am loking for recommernded tool, better if open source but not must, for monitoring and tracing DB. I am using MySql DB.

Is it possible to use oracle hint along with qblock query. I have /*+FIRST_ROWS+/ as hint in my query. Also used qblock to get the total no. of records. Getting "internal error code, arguments..." Any suggestions would be very useful...Thanks in Advance

Hi all,I try to connect to db2 and retrive the values from database. But it gives the exception as Unsupported Character encoding for resultset column. What does this mean. I am using java1.5.0_11.Expecting a help at the earliest.Thanks in advance.

[code]--context.xml--<Context path="/WebApplication1"> <ResourceLink global="jdbc/myoracle2" name="jdbc/myoracle2" type="javax.sql.DataSource"/></Context>web.xml ...

Hello allIn my postgres database, I have many tables (>100 tables). I want to check all these tables to see if the first field of these tables are correct type and default value. E.g. I want to check the first field is type "int4" and default value is something likeitem_id int4 NULL DEFAULT ...

Hi friends,Recently, I have downloaded Netbeans and JDK1.6. I have made a DSN from control panel connecting to oracle databse HR (sample database provided with Oracle XE 10g) and the connection tests to be successful.However, when in the netbeans, I try to connect to the HR database using ...

Hi I have made one Statement and 3 UPDATE for 3 different tables, which are one after oder.The first UPDATE works, but the oder 2 doesn't. Why?

HiHow to extract data from table and then transform to other database's table?I am using simple select and insert queries for each row of result set. is this efficient? or JDBC provides us such function? Please give helpful suggestions.

Hi allI've encuontered 3 error msg that I'm not sure how to rectify or go about to even start troubleshooting it. Someone kindly shows me how to rectify the problem, please.Thanks.[02/07/2007 09:23:44][ERROR] CBOFillOrder::UpdateAverageFilledPrice: Exception Caught: [SERVERERROR] ORA-00001: ...

my code isprivate void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {try {Class.forName("org.apache.derby.jdbc.ClientDriver");} catch (ClassNotFoundException ex) {ex.printStackTrace();}try {con = DriverManager.getConnection("jdbc:derby://localhost:1527/go", "go", "go");} catch ...

Hi,I am using JTable to represent the data in DB. Fething all the rows in tier-2(EJB) and sending result set as vector to Tier-1and rendering to JTable. If there are large number of rows in db, user has to wait for some time. Is there any way (PATTERN ) that speeds-up the process like what AJAX ...

Hi,Since the PreparedStatement is a Precompiled Statement , can i use it for normal SQL statements where i need to pass a parameter for a select statement like:-Instead of this:- "Select name from employee where empId= "+empIdShall i use :-PreparedStatement ps=con.prepareStatement( "Select name ...

Hi, while i configure with OCI Connection Pooling i face java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path at java.lang.ClassLoader.loadLibrary exception. Could any one suggest where from i can download ocijdbc10.jar & ocijdbc10.so files.

Hi,My program is updating one record in a table, and updated its related tables. This may takes much time(around 30 minutes).I am not using AutoCommit.If my program quits suddenly during execution (power cut, or process killed), the record it is trying to update is locked, and can't be updated ...

I want to return a ResultSet which basically handles some query i.e.public ResultSet doSomething(int chr, int startPos, int endPos, int strainsThreshold, float minGeneDensity) throws SQLException {String someQuery = "";// this should force incremental streaming of a large result setif(conn != ...

Hello All,I'm returning a resultset from a db call using:<code>String value = rs.getString(columnName);<code>What I'm seeing are values like: .00031565 and .0003629975 coming back in scientific notation. as in 3.1565E-4 for example. Is this a jdbc thing to automatically convert ...

Please tell me how can i delete a row from two table for example : i have tables(1) Department(2) Loginwhere Department table has fields like i) deptID (PK)ii) deptNameand Login table has fields likei) deptID (FK)ii) passwordand both these table have relationshipNow what i want to do is to ...

I am able to connect to the database through Rapid SQL from my local machine but not from any Java application I am getting following Exception If I Use Database name java.sql.SQLException: JZ006: Caught IOException: java.net.UnknownHostException: SYDB20at ...

Hi AllI am very new to Java with MySQL and to SQL language in general. I am trying to create a very simple program that takes a user id and password and 'authenticates' the user using a table in an SQL DB.I looking for some help as to how best to do this. Can I simply use:CREATE TABLE users ( ...

Hi there. Im new to j2me, thus i would like to know what is the best way to connect a midlet with the backend rational databases, is it any midp api for thta or it has to go through a middleware? thank you

I'm having a heck of a time getting this to work. please note that this is my first step into SQL, JSP, ORACLE, and JDBC.I have a database that contains a table DETAIL. in that table there are fields that i need to populate:SURVEY_Q1, SURVEY_Q2, SURVEY_Q3, SURVEY_Q4, SURVEY_Q5, CALL_BACK, ...

I'm working on a project that involves changing the database engine for an application.I downloaded an open source application that was implemented using HSQLDB, and I want to change it to Java DB.The challenge now is that Java DB seems to not have provision for storing and retrieving Boolean ...

I wrote a class to connect to an ORACLE database to select employer names.The proper drivers gets loaded but when the connection is made, I get an "array out of bounds" error message.Here is part of the code:import java.sql.*;=========================================================/** * * ...

I'm having a problem with PreparedStatement.setTimestamp. I'm trying to set a timestamp in a MSSQL table using GMT timezone, so I'm using the version of setTimestamp that lets me specify a calendar (void setTimestamp(int parameterIndex, Timestamp x, Calendar cal)).The problem I'm having is ...

I adapted the following code:petrotrin is the domain and PC5033 is my workstation where I have MySQL installed. When I execute I get: "Cannot connect to the database server". Somebody please tell me what is wrong b4 I go crazy. I love VB so simple.Statement stmt;try {String userName = ...

I'm using ojdbc14.jar from Oracle 10g, JDK 1.4.2_13.When I try and run the following code I do not get any exceptions, but no data is deleted:Bad CodePreparedStatement deleteStatement = null;try{String sql = "DELETE FROM myTable WHERE StrVal1 = ? "+ " AND StrVal2 = ? AND StrVal3 = ? AND ...

URGENT PleaseI am facing problem in updating oracle database with java date through resultset.updateDate() method. Can anybody help me pleasefollowing code is saving wrong date value (dec 4, 2006 instead of java date jul 4, 2007) in database:ResultSet rs = stmt.executeQuery("SELECT myDate FROM ...

Hi...,When I call a Oracle package I get this error message.java.sql.SQLException: ORA-01948: identifier's name length (39) exceeds maximum (30)ORA-06512: at "SYS.DBMS_PICKLER", line 18ORA-06512: at "SYS.DBMS_PICKLER", line 58ORA-06512: at line 1There is not way we can change the package name. ...

My applications are Java based Client Server Applications. The clients have been developed using Java Swings API.(JDK 1.5) The Database server is Oracle 9i. The clients are connecting to server through Oracle JDBC thin drivers(classes12.jar -- recently tried upgrading to ojdbc14.jar also). We ...

Hi all, I've created a connection pool on Tomcat 5 and during testing realised that I couldn't run more than 1 query to my web app i.e. I opened up multiple windows and ran each query at the same time. Is there any way (out of interest) of setting up the connection pool so that a user can be ...

hi, i want to make connection pool for postgresql database, currently i am using normal connection like that:Class.forName("org.postgresql.Driver");Connection connection = DriverManager.getConnection("jdbc:postgresql://localhost/dbname", "user","1234");Statement select = ...

I know why this exception is generated, but I can not go through all the code and figure out where the connections, statements and resultsets are not properly closed because I had been given a task to figure out some one else's problem and the code is composed of 736 jsp and couple of hundred ...

Hello,For a small company I need to create a large, but quite simple (almost no business logic) database frontend as java applet - but I simply don't know which tool I should use.I did this some time ago for a small frontend by hand (hand coded swing, hand-coded jdbc/sql) but I never ever ...

Hi,I want to store a byte-array in a db. The problem is that the method to insert values into a database need a string.So if i make something like execute("insert into table test values('" + byteArray + "')"); the stored values is not equal with the original byte-array.Any ideas?Message was ...

HelloIn my computer, I have some databases for different applications. I want to check a database to see whether it has tables that I need or not. If there are needed tables, I will create a connect to that database. If not, no connection is created.How I can do ...

Hi,I got problems trying to connect to database using JDBC. Problem is following:Code:String sql = "select * from table";Connection conn = null;try{String url = "jdbc:sqlserver://dbserver:1433/databasename";Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");conn = ...

Hi,I am using Three tier Architecture. that is MS-Access as a Database, JAva Web Server as a server and HTML as a frontend.I always getting error during the execution of JSP code.Coding in JSP:<%@ page import="java.sql.*"%><%java.sql.Connection con;java.sql.PreparedStatement ...

Would like to connect my MS Access Database tables to my Java Application. Initially I want to simply display a field value from an Access database table on the screen. (Say - database file name: school.mdbtable name: student_detailsfield name: First Name, Last Name, Roll No, City)I'm very new ...

Hi Guys,My application is throwing 'invalid cursor exception' when it does DB operations. Because of this, application is not able to fetch any data from the table. I thought this may be because of maximum cursors set in the DB will be less for the application and doubled it(to 300) then the ...

there Is java application which is connected oracle database with jdbc driver. Between oracle db and java application is tomcat. Java has a own session when it executes some query to oracle db , and oracle has the own. I need to correspond java session to oracles session, so oracle session ...