| ORA-00918: | column ambiguously defined |
| Cause: | A column name used in a join exists in more than one table and is thus referenced ambiguously. In a join, any column name that occurs in more than one of the tables must be prefixed by its table name when referenced. The column should be referenced as TABLE.COLUMN or TABLE_ALIAS.COLUMN. For example, if tables TEST1 and TEST2 are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in TEST1.DEPTNO or T.DEPTNO. |
| Action: | Prefix references to column names that exist in multiple tables with either the table name or a table alias and a period (.), as in the examples above. |
Labels
- Apache (10)
- Articles (4)
- BPM Tools (5)
- Glassfish (16)
- Hadoop (10)
- HP ALM (6)
- HP SOA Systinet (14)
- Issues (19)
- JAVA (85)
- JBoss (16)
- jQuery (4)
- Load Runner (37)
- Quality Center (49)
- Testing (24)
- Tips and Tricks (16)
- Tomcat (4)
- Usefull Links (18)
- Weblogic (41)
- WebSphere (2)
Friday, May 25, 2012
ORA-00918: column ambiguously defined in java
Thursday, May 24, 2012
The method getCharacterOutputStream() from the type CLOB is deprecated
This method is deprecated. Use setCharacterStream( 0L ).
- Oracle extension. Write Unicode stream to the CLOB.
-
- Returns:
- a Unicode character output stream.
- Throws:
java.sql.SQLException
Monday, May 21, 2012
Differences between classes12.jar, ojdbc5.jar,ojdbc6.jar and ojdbc14.jar
We need to addbelow jar'sin class-path based on JAVA version for getting correct result.
classes12.jar - for Java 1.2 and 1.3
ojdbc5.jar - for Java 1.5
ojdbc6.jar - for Java 1.6ojdbc14.jar - for Java 1.4 and 1.5
Monday, May 14, 2012
JBOSS App Server vs Glassfish App Server
Verify below URL
http://www.oracle.com/us/products/middleware/application-server/oracle-glassfish-server/comparing-glassfish-jboss-wp-117118.pdf
http://www.oracle.com/us/products/middleware/application-server/oracle-glassfish-server/comparing-glassfish-jboss-wp-117118.pdf
Thursday, May 10, 2012
German characters encoding issue
Issue:-We had faced a problem regarding German characters encoding in our application GUI editor.
When GUI inserts the values in database tables, it does not insert the German characters properly in the database and thus it is not able to retrieve those characters in proper format.
Solution:-Need to add below code in particular jsp
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"/>
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script
Issue:-The server encountered an internal error and was unable to complete your request. Error message:
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.
Solution:- We need to add BadUrlChars="" in Apache LocalConfig.conf file.
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.
Solution:- We need to add BadUrlChars="" in Apache LocalConfig.conf file.
Subscribe to:
Posts (Atom)