Problem solve

Oracle Java and J2EE

• Unable to view Oracle tables in NetBeans

  I am very new to databases (Oracle 9.2 installed) and my problem is I'm not able to view tables in NetBeans 5.5 even after establishing the connection with the database via NetBeans. Continue Reading

• Why isn't Oracle user-friendly?

  Working with SQL Server is simple. Oracle is an enterprise database and powerful but why has it never been user-friendly? Continue Reading

• ORA-00904 error on select statement

  I am working in JDEVELOPER using JDBC. This program is working with objects. I am getting this error on a SQL statement: "java.sql.SQLException: ORA-00904: "R": invalid identifier." How do I fix this? It seems like object r is not connected to ... Continue Reading

• Better performance with varchar2(1) or number(1)?

  Since Oracle table structures do not support a boolean datatype, I am faced with a choice (make it a varchar2(1) or number(1)), with contents of Y,N or 1,0. Which provides better performance? Continue Reading

• Developing a performance monitoring tool

  I want to develop a performance monitoring tool for Oracle. What are the important parameters I should consider? This tool must be independent of any platform. Which language would you suggest to use? Continue Reading

• ORA-12571 error with Oracle 8i on Windows XP

  I am getting "ORA-12571: TNS:Packet writer failure" when I write tnsping [sid name] in the DOS prompt. I have installed Oracle 8i Enterprise on Win XP. I am able to create the database but unable to connect with Java using Oracle thin ...Continue Reading

• Generating XML from stored procedures

  What are the best ways to generate XML from stored procedures? I have tried using SQLX with version 9i and it works pretty nice. I would like to know if you can recommend any other ways of doing it and suggest which approach has to be taken in what ...Continue Reading

• Rolling back Oracle XSU

  Some of the Oracle XSU that I create contains several inserts/updates and I would like the opportunity to rollback if just one of those inserts/updates fails but this seems impossible as I only get the aforementioned int and not Exceptions thrown ...Continue Reading

• Using Java for Web-deployed Forms

  This tip explains why Java is a compelling solution when working with Web-deployed Forms, and how to work with pluggable Java components and Java methods.Continue Reading

• Calling a PL/SQL procedure or function from a Java program

  Continue Reading

• Oracle Java application performance, part 2: JDBC driver comparisons

  A comparison of the performance of OCI and thin drivers.Continue Reading

• Oracle Java application performance, part 1: Creating dynamic strings

  Tips about using dynamic strings in Oracle and how they can improve Java application performance.Continue Reading

• Application development: PL/SQL, Java or C++?

  Continue Reading