Guys I am developing a forum, the thing is i want to call the sql data base saved data according to user accessed order....Can any one help me out to solve this problem pls pls pls,,,,,,

hi, how to configure the pages in netbeans 5.5. i am developing SOA right now, but i don't know where i will configure or map the pages.... plz reply as soon as possibletnx

Hi all,I'm having a problem with utf8 character encoding. I followed steps from other thrads on this subject and did all the work in MySQL database, servlets and jsp pages, but I'm stuck now with struts-config file and connection url.After I add <set-property property="url" ...

I am trying to extract a file name and its data from the database. The file data is stored as HUGEBLOB in the table. The file contains data which I found by downloading it directly from table using TOAD. However when I try to fetch the data throughh Java code :Blob file = ...

Hi,I have now used a fair amount of time debugging, but am not able to find out what causes this problem. I am getting the old "No managed connection available within blocking timeout" error. The thing is that I have set up minimum of 5 and maximum of 30 connections in oracle-ds.xml. I am using ...

Help to solve MSSQL server connect problem.I downloaded msbase.jar, mssqlserver.jar and msutil.jar sp3 and have placed it in tomcat/common/lib.Connect String ...

I have a shared web hosting plan with a web hosting provider. They provide typical web server, PHP, MySQL, etc as well as the ability to SSH in to my account, but no JVM on the server. I have a web app on that server that stores a bunch of data in MySQL.I'd like to write a Java app, which I'd ...

import java.io.IOException;import java.io.PrintWriter;import java.io.StringWriter;import java.util.Vector;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class ...

i asking when we connect to data base results will come i want to print those result through print button ,,,,how to write code for that button......

Hey all,I have a java program that worked fine with MS Access, problem was I used the String representation of a date like: Saturday 12 May 2007 which worked fine. I could add new days and update certain days in the database.but I needed to change the String to a date object, particularly an ...

Dear everyone,I have a task, in which the datas to be inserted into two tables...ie in first table, i have**************** employee id*employee name*employee passwordi have second table, i have*********************** employee id*skillsprimary key is: employee ...

im learning about JBDC using suns tutorial but ive run into a problem. on this page here http://java.sun.com/docs/books/tutorial/jdbc/basics/retrieving.html about 1/7th of the way through they give u some code. but when i used it in my IDE (netbeans 5.5) i get 2 ...

how do you do a DB connection through a jar file?

Choose I I get this error after I hit returnError listing records: Unknown column 'empid' in 'field list'Choose 2 or 3 I get this error after I hit returnError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ...

I have a java application which access a mysql serverafter every 11mn of inactivity i loose the connection the mysql server variable timeout are 28800s somy question is why do i loose the connection after 11mn?Does java has any way to listen to object so that if the conn object state change to ...

hi All,i just wanna to ask, it is possible that i can set count of column depends on data/input.for example;in common, when 2 column, code sql like:String query3 = "INSERT INTO Sheet5(Rule, Weight)" + "VALUES ('"+ finalRule+"', '"+weight+"')";but if n column, how?anybody knows or give me ...

Hello All,I have an issue with OracleCallableStatement with a Ref Cursor. I have pasted my code and lines of concern below. I appreicate your help in advance. Oracle Stored Proc --- Hdr TYPE Email_Cursor is REF CURSOR;procedure PROC_EMAIL_RECEIVED( P_USERNAME INVARCHAR2, cursor_out ...

When i am executing my project that time indicate the following error:java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Object invalid or no longer set.How to solve Object invalid or no longer, this problem? Pls help me?Vijayakumar M

hi all, i'm new to jdbc. can anyone say me how to insert record into a table through stored procedure in sql sever 2000. this is the first time i'm using strore procedure. i can easily retrieve records from jdbc. i could not able to insert or update recs. plz help me with code related to ...

I'm trying to solve this: 1.create a standalone application that inserts a couple of records into the 憄rice?table of the 慺ly-four-less?database.2. When you add the new records, make sure the 慞C_ID?column is unique by issuing a query first,3.finding out the maximum 慞C_ID? and using the 搈aximum ...

I need some help with SQL and PreparedStatementI have add the PreparedStatement and I'm not to sure if I'm doing it correctly.When I do a test run on Choose 1 ,2 or 3 I now I get this error.Error - com.mysql.jdbc.Statementhere is my code belowimport java.sql.*;import java.util.*;import ...

Hi,I have 2 questions:1) When we create a data source in WebLogic Application Server, we specify the connection pool and JDBC , JNDI details in config.xml.Is that correct?If not, in which Deployment descriptor do we specify these details2) When we create a data source in WebSphere Application ...

Hii want to use database connction pool in my program without using container optionsi want to know is there any api or java program which can handle connection pooling without the help of container.

I 've got a table ,and I want to check for a unique column ,so that there is no dups in my mysql.So how is it done using jdbc ?

SQL> desc tablebee Name Null?Type -- -- - DEPID NOT NULL NUMBER DEPNAMEVARCHAR2(10)SQL> desc tableaa Name Null?Type -- -- - NAME NOT NULL VARCHAR2(10) ADEPID NUMBER AADEPIDNUMBERSQL> select * from tablebee;DEPID DEPNAME - -99 siva100 ram900 classa901 classbSQL> select * from tableaa ...

Number FoodItemQuantityPriceDescription**************************************************1Rice 1 bag5000Carbohydrate2Beans 1 bag4000Protein3Palm Oil 1 bottle500Fats & Oili have a table like this in my database,need help in populating my listwith "FoodItem" from the database when my GUI ...

Number FoodItemQuantityPriceDescription**************************************************1Rice 1 bag5000Carbohydrate2Beans 1 bag4000Protein3Palm Oil 1 bottle500Fats & Oili have a table like this in my database,need help in populating my listwith "FoodItem" from the database when my GUI ...

Hi,I'm getting the error 'Fetch Out of Sequence' in QA and Production servers but not in development server. Our QA and production servers are under AIX OS.The particular module was working fine in production server till our previous release, but in the last release it is not working though ...

Hi,I'm sending a few strings to the DB through a JDBC PreparedStatement, and it looks like it's sending them to the DB using a wrong character encoding. It's connecting to an Oracle i9 DB.Wondering, is there anyway to conifigure what encoding the driver uses in communictating to the DB? Is ...

Hello,I am looking for an efficient collection of java classes which construct sort of a "database" on the fly - so that I could make queries and iterate through objects according to a certain cut (I don't mind if I need to specify the kind of cuts ahead as long as I can dynamically add ...

hey alli am developing a java swing application that would connect to a mysql database and queries it and upgrade it and all this stuff...this application is to be installed on a client pc....my question is what is the professional way to deploy the database...should i download the mysql ...

Hi,I am using SUN ONE application server as my web server and connection pooling has been configured.I am wondering what is the best design to connect to database ( consider about the memory). From my reseach over the Internet. I saw a lot of ppls are using lookup of JNDI and storing the ...

Guys, I'm wondering is this statement "DELETE FROM USER_TABLE WHERE ID IN ('USER_32,USER_33')"works in Oracle? Is it compatible. I have a problem in deleting the multiple rows in oracle with this SQL statement. It doesn't work. Please advice.Ivan Brogalis

Hi, im trying to delete a rec from Access from java code.My SQL is: String query = "Delete from items where item_id='"+dbitem_id+"'";Where dbitem_id is a Double variable.Item_id in Access is a autonumber longintegerIm getting [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in ...

Hi. I'm trying to connect to a MySQL database remotely (located on the internet).I'm behind a proxy too.The code I use is:public class MysqlConnect{ public static void main(String[] args) {System.out.println("MySQL Connect Example.");Connection conn = null;String url = ...

Hi there!I've been struggling with this problem for a while.I have a database from which I need to read and display some data on a browser. (The database is set up for remote access).I'm using the following JSP/JDBC code to do that.-Class.forName ...

I am trying to create a trigger and the text includes a binding variable, well JDBC thinks it a binding variable, when in fact it is part of the DDL statement. java.sql.SQLException: Missing IN or OUT parameter at index:: 1How do I escape or turn the binding off? Should I use something besides ...

I'm trying to connect remotely to a MySQL database. The problem is that I'm using a http proxy server to filter my Internet connection.How can I tell JDBC that I'm behind a proxy.Any links or info are highly appreciated.Thank you

I know this is out of the Java scope but I am sure there are many SQL experts in this forum, I was just wondering whether anyone can point me to the right sources for learning how to write better SQL and hence faster execution.I tried google and mostly I get the standard fixing the index, ...

Hi all!I got a problem that I think you guys could help me with :)..I have installed JDBC to make it possible to link my Java programs with MySQL databases. The installation worked just fine.When I'm running my program with line:Connection connection = null;connection = ...

Hi,I have Netbeans 5.5 and Microsoft Sql Server 2005 driver downloaded. Now, I put the Microsoft Sql Server 2005 driver in the following path:C:\SQLDriver\sqljdbc_1.1\enu\sqljdbc.jarI started the Netbeans and coded lots of lines until I finished a snippet as shown:...Connection con = null;//try ...

statment.executeUpdate("DROP DATABASE IF EXISTS diy55;CREATE DATABASE IF NOT EXISTS diy55 DEFAULT CHARACTER SET utf8;GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX,USAGE on diy55.* TO 'diy55'@'localhost' identified by 'diy55';FLUSH PRIVILEGES;");Java seemes doesn't support ...

hi,i'm using oracle 8i and jdk 6protected int getItem(){int queue=0;str="select nvl(max(queueno),0) as queue from jobprocess";DBConnector dbcon=new DBConnector();try{ResultSet rs=dbcon.getStatement().executeQuery(str);if ...

Hi guys,I'm doing JSP paging. I have this SQL statement running on Oracle. "SELECT * FROM (SELECT * FROM USER_TABLE WHERE NAME = 'test1') WHERE ROWNUM > 0 AND ROWNUM <= 10"For the ROWNUM >0, the Oracle able to return the 10 records to be displayed in the page.For the ROWNUM >10, ...

Hi all,can anyone tell me how to find out which type of the driver is used in our application?Thanks in advance,Phoeniox

Hello,I'm having a problem to register my driver for mysql. I'm working in win xp, netbeans 5.0 and mysql 5.0. I've put in my classpath this:"C:\Archivos de programa\MySQL\mysql-connector-java-5.0.5"and my code:import java.sql.*;public class SerDatos {Connection conexion;Statement ...

hello every one:I am new to the ORM and looking to generate DAOs for one of my applications. A small search shows that there are many of this frame works for ORM and persistence. I am not looking to use persistence at this point. All I need is to generate DAOs from my existing mysql design. The ...

If the connection failed, how can I know it is due to the username or password invalid? Because I want to seperate the processing logic for different error. such asdbconn = DriverManager.getConnection(url,userid, password);if(.....)System.out.println("database username or password is ...

hi,I have two idetical database tables tableA and tableB.tabelA has 5columns and tableB has 7 coulumns.the first 5 coulmns in tableB are same as in tableA.Now my problem is tableA is having the updated data. I have to compare the tableB's data with tableA's data and upadate the tableB with ...

select * from tablename where joiningdate between '01/05/07' and'30/05/07' notworking . my database is sqlserver. only date part is compared but not the month or year. plaese help me.