Hi,I'm looking for a free database to use with a java application. Ideally the database would be widely hosted by cheaper web-hosting companies (it is largely for my own practice but I would like it to be able to grow if all goes well).My ideal choice would be mySQL, which I had assumed was ...

dear all i have one problem with jdbc by orcale when i connect to databae which has some error message by db connection? the driver and connect which is correct if i setup code and db in same machine , but if in diff mechine which indicte that java.sql.SQLException: IO error: The Network ...

dear all i have one problem with jdbc by orcale when i connect to databae which has some error message by db connection? the driver and connect which is correct if i setup code and db in same machine , but if in diff mechine which indicte that java.sql.SQLException: IO error: The Network ...

i'm trying to find out the day of the week from a date stored in a database.i am using smallsql for my database.s.executeQuery("select * from results");ResultSet result=s.getResultSet();result.next();day=result.getString(1);System.out.println(day); sql="select dayofweek({d "+day+"}) from ...

Dear all, I am failry versed with java and jdbc. I did a lot of google and searched a lot of forums but no one gave me all the details. I have done a lot of oracle jdbc. I would appreciate if some one could give me all the details please. I dont even know which jar files should be in the ...

WellI had a problem with the sun's CachedRowSet and oracle's Clobs/Blobs (IT'S A BUG AND I ALREADY REPORTED TO SUN)As a workaround somebody suggested using the OracleCachedRowSet but how can i put this to work....... if it realy works......can somebody help with this?There is another way of ...

st.execute("insert into user values"+newUser+","+newPass);i am trying to take the values from awt there newuser and newPass are the values taken from the textboxes of the awt

HiWont the MYSQL Jconnector jar file that we use on windows work for linux too?Is there ny separate MYSQL Jconnector for linux?plz hepl

Hi, I am trying to store an ImageIcon in a database:inserting the Icon works fine using this code:(rs is a ResultSet) rs.updateObject("PICTURE", new ImageIcon("D:/test.jpg")); rs.insertRow();when I try to retrieve the icon using:ImageIcon icon = ((ImageIcon) rs.getObject("PICTURE"));I get a ...

Hi All, I am using my Sql 5.5 for database. While connecting using JDBC i am getting connection failed exception ....Please see blow code. and exception...Please help me to resolve this issue..... try {Class.forName("com.mysql.jdbc.Driver"); Connection con = ...

i have a table with 5 fields in it.i want to get field say accountno to be incremented each time when a new record is to be inserted by checking whether number is not duplicated. how to get max value in accountno column and incremented by 1 or 2 in MS-Access database....please help me!!!!Thanks ...

I'm trying to access a database which has some data in chinese language. So when I try to connect to the database I get the following error:Unsupported VM Encoding MS936where MS936 is the code for chinese.I tried alot of things including installing some internationaliztion support version of ...

I am trying to develop JSF - MySQL application with ...

Hi,I am a new user in this forum..I have just installed tomcat and mysql and jdbc fresh on my new system..first of all here is what i have done...i have installed mysql integrated in xampp at c:\xampp\mysqli have installed my tomcat at C:\Programme\Apache Software Foundation\Tomcat 5.5i have ...

Hello firends,i have a problem regarding Creating two Statement objits not allowing me to do<%! Statement stmt1; Statement stmt1; Connection con; dbcon db;%><% db=new dbcon(); (its database connection class which m importing) try{con= db.getDbCon();(method of dbcon ...

I have a windows Xp system with Microsoft SQL Server 2005 setup and using java 1.6I'm using the JDBC-ODBC Bridge and also setup the DSN and that works fine.The following code worked fine a few days back but now every time I enter a row of data and if the data type of a variable is varchar or ...

Hi....Can I specify the encoding with ResultSet.getBytes("columnName") method.If not then how can I specify the desired encoding while fetching the values from DB?Thanks

How can I retrieve data of NVARCHAR data type from Sql Server 2000.Do I have to user ResultSet.getCLOB() or ResultSet.getBLOB() ?thx

hi all,I have a problem....I have Oracle9i R2 db on my PC....Firstlywhich of the following do i use to load my driver..Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");OR Class.forName("oracle.jdbc.driver.OracleDriver");Secondly In the above code i assume "JdbcOdbcDriver" and "OracleDriver"...are ...

Hi,I want access a Postgres Database from a java program. The database is running on remote mahine. I have access to that Database. it can be accessed from computers within networkThe problem is the firewall doesnt allow TCP connections from outside network to specific port DB is running on.Can ...

hi,please, a need a good site for c++ forum. Please, any help?Emeka

[nobr]PreparedStatement ps=cnn.prepareStatement(query);ps.setString(1, coemail);rs=ps.executeQuery();if(rs.next()){r_id=rs.getInt(1);co_id=rs.getInt(2);if(!coemail.equals(rs.getString(3))){out.println("<br><br><br><center><font color=red size=3><b>Access ...

Hi,I want to know what is exact query execution time which excludes network access, constructing results. Please suggest me.Thanks in advance,Satish.G

Hi,I'm working on a JDBC performance impovement project. Researching JDBC best practices it's my understanding that you should avoid getObject behavior and use type specific methods (getInt, getFloat, etc) I'm finding that in some instances that performance is worst when I use the type ...

I have sql that uses a like clause instead of == or in. The like values do NOT have wildcards associated with them. Do they perform as quickly as == or in claues?

Hello community,I hope this forum is the right one to post my request.I wonder if Hibernate or any other "ORM framework" makes sense when using only VIEWs and STORED PROCEDURES. I want to avoid direct INSERT, UPDATE, .... - statements executed by the "ORM framework" to increase flexibility. I ...

[nobr]In my Tomcat 4.1.27 container I am trying to get the finally block to work where it closes the MySQL database connection.Here is my attempt which will not compile:package packone;import java.io.*;import java.text.*;import java.util.*;import javax.servlet.*;import ...

i am new to java programming...I am using NetBeans IDE 5.0 and have been trying to connect to database through Derby...so far i am successful but i whenever i try to create a new database from "Tools -> Derby Database -> Create Database" i get this error..." An error occurred while ...

Hi,I need to create a Connection pool in weblogic to access a mdb file(MS Access) .Iam not able to see any precoded drivers in weblogic for accessing MS Access.Let me know if anyone has details on this.Thanks.

hi i have folwing HQL query for updating a table but it doesnt run would b great if somone can help urgent thanks session.createQuery("update BusRefAccessValues brav set brav.busRefAccessEndDate =:currentdate" +" where brav.id.busRefId =:busrefid" +" and brav.id.busRefAccessLabel='CLIENT UNIT ...

hi am fresh in databases...can any one plz post a complete code of connecting to remotemax db from java desktop application...and if it needs any special configurations plz tell me about it?!!thx in advancecontact me at ...

Right now I use sql to get data from an excel spreadsheet sent to us from a vendor. Inside of this sheet there is 9 cells in a row that have pricing information and the column headings change because the column heading is the week the price is valid. So I use column numbers to select instead of ...

Hi All , i am developing a struts based web-application with JBoss 4.0.5 as Application Server and Oracle 10g Express edition . I am configuring my application for connection pooling . I have tried following methods : 1. Oracle Connection Pooling following thius link ...

Hello All,I'm trying to come up with a way to check for the existence of two temp tables and if they are there, drop them. I tried this, but temp tables don't work the same with db metadata I think, so I get an exception trying to query the resultset:DatabaseMetaData dbm = ...

Hi Group,I am using DBCP provided connection pool in my web applications. For each re-deployment of my web application, connection pools are not reused so connections are just increased. This forces me to restart my live application in every month. Is there any way, I can reuse connections in ...

Hi ,I have a Unicode String String uni = " \u0627\u0633\u0644\u0627\u0645\u0020\u0622\u0628\u0627 ";This is Urdu Language Unicode string.I want to save it and retrieve it to display Urdu in JTextArea.I have tried numerious solutions but not yet successeded.What is the best solution to do ...

hi... im encountering an exception whenever i click the cancel button on downloading of file but when i click open the program runs good...here's the stackTrace[5/23/07 14:47:20:859 CST] 17dd17dd SystemErrR java.net.SocketException: Connection reset by peer: socket write error[5/23/07 ...

hi,PreparedStatement stmt = con.prepareStatement("Insert into uQuestions values(?,?)");stmt.setInt(1,2);//stmt.setString(2,s.trim());Reader rd=new StringReader(s.trim());stmt.setCharacterStream(2, rd );System.out.println( stmt.executeUpdate() );stmt.close();Resultjava.sql.SQLException: ...

hai....i am using simple java file with MS-Access db...i want to know whether is it possible to return more than one value using return stmt?for example in bank database after user created his account ...it has to return his new account no and pin no...plz...help me...Thanks in ...

Hi All ,I am new to JDBC Programming ....can someone provide me ...a JDBC insert program in which i insert data through variables .......(i.e i do not know the data ....it is captured from user input ...and then place in the insert statement....like insert into emp values (var1,var2....etc ...

HiThank you for reading my postI have name of a savepoint in my method and connection which that savepoint belongs to.Now what i need it to rollback to that savepoint but problem is that Connection object rollback method does not accept savepoint name and it just accept savepoint Object to ...

hai... i am having this error..java.sql.SQLException:[Microsoft][ODBC Microsoft Access Driver]invalid descriptor index. I am doing RMI application..while i am trying to insert i got this error...here i paste my code....can anyone help me in finding out ...

any1 know where i can find a page with all the sql commands on it? thnx

Can someone make this program for me?Make a Java-webapplication containing a few webpages (html-files and servlets, but NO jsp's). With this application you can get bankdata from a database, for example:page 1: html-file: Welcome on the website, type your bankaccount and passwordpage 2: error ...

Hi everyone i need to insert data from csv file in to the SQL server .The problem is the data will be given as parameter to the store procedure which will insert data in to different table in database.So if there will be 10,000 records so should i execute the stored procedure 10,000 times or is ...

HiI am facing some problems with configuration of connectionPool with oracle.I am using J2EE app server 8.1.While configuring I am giving following details:Datasource Classname:oracle.jdbc.pool.OracleConnectionPoolDataSourceResource type: ...

I searched extensively to try and figure out where my error lies, but I am about stumped. I am trying to make a JDBC connection from a web service to an Oracle 10g database using Tomcat 6.0 enabled with Apache AXIS for SOAP implementation. Here is the relevant information:=== EDMSService.xml ...

Hi guys. I have successfully connected to an Access database and have now started a new project which aims to load these Access database attributes into Text box fields. Unfortunately I'm having a bit of trouble. I have a class called FormClass, of which the public FormClass constructor calls ...

hi ,can anyone suggest me how to use the setDate method from Preparedstatement.....my req isPreparedStatement updateSales = connection.prepareStatement("Insert into emp1 (empno,ename,dob) values (?,?,?)");int n =7;updateSales.setInt(1,n);updateSales.setString(2, "TEST");Date d = 18/12/2000 ...

Hi,I have to insert a blob data in to database . I wrote the code . I'm having a ClassCastException problem in the line oracle.sql.BLOB blob = oracle.sql.BLOB.createTemporary(st.getConnection(), false,oracle.sql.BLOB.DURATION_CALL); while trying to store a BLOB value I'm using Oracle 9i. ...