I tried to retrieve data from oracle database. I got the following error message. I did compile the files without error. but when I run index.jsp I got the following error message. is it related with taglib Directives ? HTTP Status 500 -type Exception reportmessagedescription The server ...

Hi,I have some problem regarding SQL Server 2000 connection with Netbeans IDE. if someone give me his/her email address i will send you a doc file with screen shots where i explained every thing.it's very urgent and important becoz i am doing my final project ...

Hello Folk,I'm writing a simple database using NetBean 5.5.1. The database is MySQL. When I tested my code, I got the error stated above in the Subject line. Please help me out here. Below is my code.public class sharedConnection {// Declare variable to established a Connection to the DBstatic ...

If you'd like a stored procedure to return a value, what's the difference between returning it as an out parameter (SELECT returnValue INTO outParameter ...) or as the ResultSet of the stored procedure (SELECT returnValue ...)In either case, the value you need is returned correctly. Are there ...

hello frnds,i am new to hibernate,how to write join qurey on 2 related tables..if any one knows then please reply me sooon...thanx and regards PanDev84

Hi all,I have to synchronize two different databases in my application.Since this operation has many queries to execute, it will take lot time to complete. Once the operation is complete i have to redirect my page to some other page. The application will time out before redirecting(for some ...

Hi all,I have one connectivity program, in which in the code shown below,ResultSet rs = stmt.executeQuery(" ");within double quotes I gave a sql query, which is very big, so I gave it in multiline but it is not accepting. its showing error...please help me in this...Thanks in ...

why can抰 the following code do the job of 搇ocate, load, and link?which Class.forName(Driver name) is used to perform? org.gjt.mm.mysql.Driver driver = new org.gjt.mm.mysql.Driver();This would locate , load and link by executing the static ...

Hi frnds ....is id field is required to unique for that table...please any one have idea then reply me...thanx in advance..PanDev84

i have an applicaiton and my problem is this,i am creating a resultset (rs) with type_scroll_sentive and concur_updatable attributes and executing it to list the contents of a table. then dbmeta = conn.getMetaData();rs = dbmeta.getColumns(" "," "," ", "%");this rs is the same resultset which is ...

i want to connect to multiple schema's on the same data base using hibernate...my hbm.xml looks like this<hibernate-mapping><class name="SampleClass" table="SampleTable" schema="DynamicSchema">.....</hibernate-mapping>i need to enter the schema name as parameter and change it ...

i m getting the error in jsp working with Apache Tomcat HTTP Status 500 - --type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperExceptionat ...

i m getting the error in jsp working with Apache Tomcat HTTP Status 500 - --type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperExceptionat ...

Hi everybody, as the title, i have a pl/sql funtion, like below:type t_record is record ( ...);type t_table is table of t_record;function() return t_table is ...Is there any way for java get to know this data type? so that in java code, we can do some thing like below or similiar:resultset rt = ...

i have to retrieve data from a mysql database to then display it in input text boxes on a web page. but i cant retrieve all the data in a particular field. for example if the field value is 'united kingdom' only 'united' is being displayed. i can only retrieve the first word thats in the ...

I am trying to work on joining two tables. The part that has thrown me for a loop is that the two tables don't have one unique item that makes a row unique. It is accomplished by using several rows. Suppose I have tableOne and tableTwo. On a unique index tableOne has the columnns tableOne.colA ...

In Oracle, to find the date seven days ago, you can do a select sysdate -7 from dual, Is there an equivalent in JavaDb?Thanks,Dave

Hi I want to ask thae while connecting with SQL server do we need the "Data Source Name" or just the "Database Name" in our java code. Actually I made the connectivity using ms access but now I want to connect with the Sql ServerCan anybody explain me the required changes.if someone explain it ...

Hello All,I have observed that when u use jre 1.5 that comes with with windows XP 2006 , the application has login failures. I tested yhis for sybase.Has anyone encountered this? How did you solve it?ochomo

Hi,I have a small doubt in getting JDBC Connection. why we use DriverManager.getConnection for getting connection object, why dont we use parmeterConstructor of the driver class for getting Connection Object using that driver Object. Can any please explain what is the reason behind getting ...

i know we can get that info via calling a server function like now() in MySQL or getDate() in MsSQL.since the function name can be different between servers, we can not depend on that to build (database) portable application. so with java api which support cross platform (cross environtment), ...

Hi I am facing a problemi want to connect to database named cns in my server using connection string in jsp: here is the code===============================================Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //Make the Connection to the database. //Replace IP, Name, ...

Hi guysI'm not an expert in java, so sorry if i'm doing a simple question ;)I have a java applet that use the postgres jar file to connect to a database, my question is: how can the applet know the database location? if it was a static location would be embuted inside code, but could be any ...

Hi friends....I want to upload data in excel to MS sql data base..but i have to do that from front end(jsp)....please any one help me please....

I am confuse about jdbc versions. Now currently we have jdbc 4.0. we study jdbc in java EE. But the API is SE. I read that java1.4 supports jdbc2.0,2.1 and jdbc 3.0 but optional jdbc2.1how do i change optional 2.0 version JDBC 3One thing that java 5 features tell us that java 5 supports ...

Hi =)I've my execQuery method here that returns a ResultSet of results.I would like to know the rows returned, but I cannot find a count, lenght or size method in the ResultSet class.縃oy can i count the number of Rows affected by a query? public ResultSet execQuery(String consulta){/** ...

Hello,I seem to have a problem with the following code. It throws the following exception at the while statement if there is morethan one row returned from the first query:java.sql.SQLException: Operation not allowed after ResultSet closedtry{result = statement.executeQuery(query1);String ...

so,i have problem with: drop typei have 2 new Objects typ : Student ref Profand Prof ref Studentso how can i drop these Object?

Hi All, I have a serious problem while running java process all the day. Sometimes I get following errors: 1. (***ERROR) java.sql.SQLException: OALL8 is in an inconsistent state. 2. (***ERROR) java.sql.SQLException: Io exception: Broken pipe(***ERROR) java.sql.SQLException: Io exception: ...

what is a java heap? what is a saveabend file?what is singal 11 error? what may cause it? how to avoid it?

Hi,normally we keep the database open always. why ?why we are not opening the db whenever we want to insert the data or retrieve the data from the db?what is the basic reason behind this?

Hi Alli would like to know how to change a procedure (or routine) into a trigger?Currently i have a procedure that works when there is an insertion of data during a specific time.... how do i change it into a trigger so that whenever my java application run every 5 sec in a loop, and the ...

Hello!If I install ODBC driver on my Win XP for *.xls (Excel file) is there any way to connect to the database per JDBC-ODBC bridge and change the path name of the database (*.xls file) ? I have to make an appliaction that reads excel tables and changes some values. But the file excel file ...

I'm new to database connectivity through beans when i use the follwing code in my jsp file ====================================<%@ page language="Java" import="java.sql.*" %> <jsp:useBean id="db" scope="request" class="sqlbean.DbBean" /> <jsp:setProperty name="db" property="*" ...

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, ...

Hello All,A Java/Netbeans Rookie question..(tried Google can't find answer)..Trying a New DB connection to MS SQL 2000 through Netbeans.Followed the instructions found HERE-> http://www.netbeans.org/kb/50/using-netbeans/dbconn.html#73418Runtime-->Drivers>New connectionI added the ...

I am having problem obtaining proper Resultset from a excuteQuery() method.i can successfully create a JDBC connection to local oracle database (on my computer) and excute a query on a table named "emp" which contains two records; however when i print out my Resultset using getInt(String ...

Hello I've been working on a project and have run into a slight problem I have a MySql database up and running and have my Java program connecting to it (with some help from this forum) but whenever i connect to the database I get a Stack Overflow Error from the DefaultListSelectionModel here ...

Hi all,I had developed the application in swing, where i am connecting to oracle 10g. Previously i had used Thin driver to connect to Oracle. It is working fine.But When i am trying to connect to oracle using OCI driver. It is giving the error like below.Exception in thread "AWT-EventQueue-0" ...

On two computers i have the same Java apllication. Every of these two apllications has its own database (Oracle 8). Few days ago I had a problem with starting one aplication. From then in log file of the aplication with a problem there is a message:INFO cleanup connection: RMI TCP ...

i have written a procedure in oracle which returns a cursor, now when i am trying to get that cursor data inot a result set it's giving an exception -" java.sql.SQLException: ORA-01003: no statement parsed"....i also goggled for this error but and there it is wriiten something like, you have ...

Hello..I have oracle 9i on my comp...the problem is that i cannot connect the jdbc driver for my local host..i m pretty new to this concept of database managment.....I cannot resolve the porper URL for my comp,bcz either Exception in thread "main" java.sql.SQLException: No suitable driverat ...

Helloi'm using tomcat 5.x -> 5.5.12and editor: Textpadwhen compiling: these are the errors:C:\Documents and Settings\Michelle & Bastiaan\Bureaublad\261139bl\Controller.java:3: package javax.servlet does not existimport javax.servlet.*;^C:\Documents and Settings\Michelle & ...

When I try to cennect to a mysql database I get this error:No suitable driver found for jdbc:mysql:127.0.0.1:3306/rehber/rehberThe Code is here:CN = DriverManager.getConnection("jdbc:mysql:" + Adresse + "/" + DataBase + "/rehber", UserName, Password);Error comes as exception:int a;try {CN = ...

I'm trying to connect to my oracle8i db, but it just cant succeed. I'm using the thin driver and I have registered classes12.zip in the classpath(Classpath = C:\oracle8i\jdbc\lib\classes12.zip)It failes in the ClassNotFoundException which means that it Failed to load JDBC driver. What have I ...

Is there a way to convert an ArrayList to sql.Array? I need to pass this to the setArray method of prepare statement. Is there a class which implements the sql.Array interface? I tried using createDescriptor which is in oracle.sql but that is for oracle. I am using Sybase. Can someone help me ...

Hello, I am having two threads run an update statement. The statement is update someTable set status = 'In Progress' where ID = ? and statusDate = ? and status = ?Java code : int numberOfRowsUpdated = ps.executeUpdate();if (numberOfRowsUpdates > 0) {//This thread succesfully updated the ...

hi, I have java 6 installed as well as Oracle 10.2 on my windows XP. I am trying to write very simple app using jdbc connection. Sofirst I load jdbc driver : Class.forName(driverName); Where do we get the driver name from. I went as far as copying all the jars from ORACLE_HOME to JRE_HOME/lib ...

hi, i have seven queries with the set of three query together, then two and then two with the single connection. now i want that first three queriest need to be executed, then next two.. If any exception is generated from these two queries then both these two queries should be rollback. After ...

Hi allWhen i used to get values from SQL database using result set it gives me an error saying that ResultSet is closed. I used the following code for that.Statement st;ResultSetrs;rs=st.executeQuery(queryStr);Is it ok if i open the resultSet before i use it? If that so then How can i open the ...