2,627 Topics
 | |
| | Hi, I am tryin to insert values entered by user into oracle db.I am using jsp and java beans for this.request.getParameter() works fine for string parameters but what should i use for fields such as date?..thx  |
| | hi, i am using oracle 9i as by database. my front end is vb.net. i want to generate the report according to the field that i select from the combobox. crystal report should display only the field that i select in the combobox. can any one kindly guide me to … |
| | i am doing a project in asp.net2.0.i have used oracle8i.i have a taken a gridview.i retreive all data in a gridview using oracle database .but when i want to retreive data using where condition e.g.select * from tablename where tid=?it does not give anything.but when i again configure data it … |
| | Hello Dear Experts! I need Oracle and EnterpriseDB comparison in detail. kindly help me.  |
| | All, Your help is greatly appreciated in advance. I am having trouble packaging Oracle 10G for a batch file deployment. Everything is done except for getting the DSN created which is causing me major problems. We am working with the Oracle 10G R2 10.2.0.1.0 Client on Windows XP Professional SP2. … |
| | Hi, Im writin the followin code to connect with oracle `database.im` also using toad .I keep geetin errors even if i declare `private String AQC1_UID = "";` and so on.. import java.sql.*; public class Login { public static void main(String[] args) { String AQC1_UID = ""; String AQC1_USER_PWD = ""; … |
| | Hi everyone!! please help me....working new in oracle forms 10g..... its web application (using forms 10g front end, oracle 10g back end)....I try to call crystal report in my forms....how can i call the report...please give some ideas.....but i did Database connection......where should i specify URL in my forms....anybody know … |
| | Hi everybody! i working in oracle 10g forms and reports.... i try to use this crystal report in 10g... please help me how to call this report in application.....my application server remote how will i call the remote server in my crystal report.......please help me.... thank you, saravanarajan... |
| | i need a simple mini project using oracle 9i and java connectivity pls suggest me some topics and ideas ...give some other ideas than usual hotel ,hospital ,student managements ...pls i am in desperate need of it!! |
| | hi, i need urgent help as i am facing problems in copying database oracle from one hard drive to another hard drive,please give me step by step instructions on how to do it,also please suggest a software which can transfer the database and the settings, thanks in advance |
| | I have successfully installed RH AS 2.1 as a guest on XP using VMWare 4 Workstation. The Linux directory structure I need is extensive as I will be installing Oracle 9i on it. This is as follows: -home -usr -swap -u01 -u02 -u03 -u04 The virtual machine starts and AS … |
| | How to insert the Oracle 9i FIELD NAME into VB6.0 COMBO BOX eg : desc customer; This table have 3 fields : CustomerId, CustomerName & CustomerAddress CombCust --> The above field names should be displayed while drop down of combo box Thank you in advance |
| | For the past 5 years I been using DSN connections to connect to Oracle in my Cold Fusion. Is there any other way to connect in Cold Fusion MX 7 without using DSN? <CFQUERY NAME="query_name" DATASOURCE="db_name"> SQL statements </CFQUERY> Maybe instead of System admins creating DSN, I can create the … |
| | Hi All - I'm a new guy here, and I'm hoping perhaps you can expand my knowledge a bit when it comes to our industry. I've been developing .NET and SQL since the inception of .NET 1.0 when it was released in beta. SQL-wise, I've been developing both Oracle and … |
| | hi, can you please give a step by step procedure on how to connect oracle database with jsp. I am new to the language and cant quite figure a way out.My first page is a user login and therafter username is used.How do i use sessions for this? Thanks in …  |
| | thx..my first page is a login.in that user name and password are to be accessed from oracle database and then matched on button click.if match occurs then user proceeds to next page. So please help me out.I m getting very confused as to where to put what code..ryt from db … |
| | friends i got problem in connection between oracle and jsp as given in cracking codes in j2me in following codes <?xml version="1.0"?> <jsp:root xmlns:jsp="http://java.sun.com/products/jsp/dtd/jsp_1_0.dtd"> <main> <title>Branch Info</title> <%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");%> <%java.sql.connection db=java.sql.DriverManager.getConnecton("jdbc:odbc:master","sa","amrit");%> <%java.sql.Statement st=db.createStatement();%> <%java.sql.ResultSet rs;%> <%rs=st.executeQuery("select item_code,quantity,unit_price form stock_mast;");%> <%while(rs.next(()){%> <%String name=rs.getString("item_code");%> <%int aId=rs.getInt("quantity");%> <%int uPrice=rs.getInt("unit_price");%> <item_code><%=name%><quantity><%=aId%></quantity><unit_price><%=uPrice%></unit_price></item_code> <%} %> <%rs.close();%> </main> … |
| | Hi: I am trying to implement a distributed database application with Postgres similar to one that I've in Oracle. I can't find an equivalent Oracle DATABASE LINK in Postgres. Does any one know how to connect two remote sites in Postgres? Thank You. [email]fvillavi@yahoo.com[/email] |
| | hi my name is Anna and i have got this problem i am trying to practice sql queries using following database relational modell i know most simple ones but with these ones i got trouble it is about book lybrarry database using oracle. The primary keys are underlined. The foreign … |
| | I am new to .Net and this forum. I am using Visual Studio 2005 and Oracle as a DB. I am creating a Web page Using Gridview from the Query [COLOR="Red"][/COLOR] Select Name,Sex,Country from Emp [COLOR="red"][B]Now I want to create a Stored Procedure from the above query in Oracle.[/B][/COLOR]How will … |
| | When submitting a page via the internet, I get a 500 error and the name of the file. Are you able to help?? Basically I have an expense system implemented with JSP in JBuilder 4 using Oracle 9i and SQL Plus. When submitting any pages in the system, I get …  |
| | Hi, iam developing a small application using vb6, oracle 8i and crystal reports 9 my problem is i placed crystal report control on MDI form and named it as CRT but in CRT properties iam not getting CRT.Sqlquerry property and .windowsmaximised properties.. why it is happening is it requires any … |
| | Hi all this is my problem: description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: Exception in JSP: /DAO.jsp:16 13: 14: Class.forName("oracle.jdbc.driver.OracleDriver"); 15: 16: conn = DriverManager.getConnection("jdbc:oracle:thin:vincenzom86@localhost:1521:XE","xxx","xxx"); 17: 18: Statement st = conn.createStatement(); 19: Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) root cause … |
| | Hi All - I'm Tim, and I've been a .NET/SQL/Oracle developer for about 15 years now. I've been doing almost exclusively web applications for about the past 3 years, but it seems that every project I do has a SQL component that allows me to keep my T-SQL skills sharp. …  |
| | Hi I'm just trying to create an appliation in java that can hold my expenses and save it to review every month or end of the year.The problem with it is how can i hold the data of everyday expense into it.this could be with help of oracle or MS … |
| | Hi I am trying to develop a project in Java as per the following requirements: 1. I need to store fingerprints in The oracle database, taken by any fingerprint scanner. 2. I need to access data using fingerprint matching process. 3. I donot know how to match the patterns using … |
| | I need to query a database on a server. As a first step, I have written the following Java code to just make sure I can access the database. I thought that the Try-Catch blocks would take care of the exception problem, but apparently they do not because when I … |
| | I'm trying to connect to Oracle Dbase using VB.net and I don't know how. I'm more familiar with Visual Foxpro 9.0 which is a lot easier. I did not find a way to connect VF to Oracle so I'll try VB.Net . 5 years ago, I am a little familiar … |
| | Hello all. I'm trying to find a GOOD server for a small business of about 10 people (i.e. 10 - 11 machines, desktops and notebooks) and growing. The only server that I've been able to find is IBM system x3xxx. Could anyone please point me in the direction of any … |
| | Hi, I'm trying to load a plain archive (txt) to an Oracle table with SQL Loader, but we are having problems when the field is a Date + time. Only Date gets saved into the field of the table, ignoring the time included. When creating the archive the date + … |
| | Hi all, Can you help me in finding the best and most known Web Development company in India ? I need a professional B2C Website that should have Oracle or MS SQL database and animated maps in Flash or something else. It should be built from A to Z and … |
| | Hi to All , I am getting this type of error while running the Sql through JDBC. java.sql.SQLException: Invalid column index java.sql.SQLException: Invalid column index at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.OraclePreparedStatement.setIntInternal(OraclePreparedStatement.java:4635) at oracle.jdbc.driver.OraclePreparedStatement.setInt(OraclePreparedStatement.java:4627) at weblogic.jdbc.wrapper.PreparedStatement.setInt(PreparedStatement.java:536) I am implementating the Paging in jsp. I m using The TYPES. parameterList.add( … |
| | hi all i was installed jdk1.5 and oracle 10g. i got a runtime error like this. i want to compile and run the same program in command prompt and eclipse also . import java.sql.*; public class Oapp2 { public static void main(String args[]) { try{ Class.forName("oracle:jdbc:driver:OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger"); System.out.println("connected"); } … |
| | Hi I am Vinu, a software engg from HYD,India. M working in an MNC as Oracle developer.... but thats not my interest area....m looking for news n technology related to network security n web development ....hope m in a right place........... Abt me....."i am a bad habit n u just … |
| | hi guys, i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.:sad: |
| | I am working on an ASP.net 2.0 application written in C#, pulling data from an Oracle 10g database on a remote server (i.e. the application and database are on different servers). The data is pulled via a SqlDataSource control. When I run small, quick queries, everything works fine, but when … |
| | I am working on an ASP.net 2.0 application written in C#, pulling data from an Oracle 10g database on a remote server (i.e. the application and database are on different servers). The data is pulled via a SqlDataSource control. When I run small, quick queries, everything works fine, but when … |
| | probably, all of you have seen this scenario a lot when entering customerID into a large database it takes AGES to bring back one simple record of a single customer === let's say, this has been DONE already , for tuning performance separate the CUSTOMERS table into 2 TBLcustomer1 -- …  |
| | I have my PHP inserting into Oracle 9i. But how do I prevent duplicate record entries? I only have 3 fields in the insert in the action page and my below attempt doesnt output anything or insert anything even if not a duplicate: [code=php] <?php $c=OCILogon("scott", "tiger", "orcl"); if ( … |
| | Hello, This is my first post here, so Hi everyone :). I was advised to come to this site by a friend regarding a query that I have, so here I am. So we have the E-Commerce subject in this semester. One of the case studies given to us involves … |
| | Hi: I have a network with 80 users and 8 servers. Like 2 day ago 6 of this servers collaps. All that they show is an error message saying "Generic Host process" error. When I check the system errors logs each server has a diferent .dll file with problems but … |
| | Im a noob in vb.net 2003 and oracle...and I desperately need the expert help regarding a problem that I face.... Im working on a web based system and the system is connected to oracle. In oracle there are 4 tables and Im facing problem with one of the tables. In … |
| | I need to read simple tables from a stream. The tables are created as: CREATE TABLE ny1.allinsured1 ( pol_no numer(120, ... ) / I see the tables are streaming from source db to destination db BUT I cannot seem to access the tables from an OCI streams interface. How can … |
| | Hello Seasoning Greating! Hello to you all i am a student in a college and we are in a group we are giving the task to choice a project topic to write on VB and the project should be related to what is in our environment such as! 1) sending … |
 | Hello DBA, Can any one help me this? The table TEST contains CNAME CNO EXTRA ------------------------------ ---------- ---------- bijaya 645896 mantri 525896 mantri12 525126 testing for null My requirement is to find the column which contains all the rows null(null column) I have created the following procedure to accomplish this … |
| | Does anyone know where to get a skeleton of perl scripts written for Oracle backup and recovery? |
| | I want to put together a set of packages to help in unit testing PL/SQL code - does anyone know of any software ( commercial or not ) or books which I could look at for some inspiration. Thanks Nige |
| | Hi friends, I m experiencing a problem in a pro*c module. Its a function in a pro*c file which is opening a cursor, and the equivalent of this pro*c code is a block in parse.cpp file line number : 1255 which is sqlcxt(&ctx1, &sqlctx, &sqlstm, &sqlfpn); the module got down … |
| | If you intersted to work in Qatar, fnincail company looking for Database Administrator – senior as following: - Experience in MS. Sql server , Oracle Database - knowledge of writing stored procedures of moderate to high complexity. - Backup, recovery, performance tuning and optimize databases - Configure, administrate cluster is … |
| | Hi guys This is my first post and I must say that this forum has quite a professional feel to it. I am currently in my final semester to achieve my B.Sc in Information Systems and as such I have a project module to complete. I have a personal mission … |
The End.