Below is the code used to find possible duplicate records across multiple columns. Below I am trying to find duplicate rows in col1, col2 combined eg.
Consider the following ERD :-
Table data:-
Here row 2 and 3 are duplicate and the following SQL detects and finds such rows:-
SELECT a.* FROM test a INNER JOIN(SELECT col1, col2 FROM test GROUP BY col1, col2 HAVING Count(*) >1) bON (a.col1 = b.col1AND a.col2 = b.col2)
I was working on Spring web services with Axis and I received this strange error related to my c3p0 connections:
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver [[oracle.jdbc.driver.OracleDriver]]
Could not get JDBC Connection nested exception is SQLException: No suitable driver
It seems this is because my bean was containing some white spaces since I had copied the settings from other project. Here is the correct configuration for c3p0 with Oracle 9i
<bean id="dataSourceC3PO" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass">
<value>oracle.jdbc.OracleDriver</value>
</property>
<property name="jdbcUrl">
<value>jdbc:oracle:thin:@SERVER:1521:07</value>
</property>
<property name="user">
<value>USERNAME</value>
</property>
<property name="password">
<value>PASSWORD</value>
</property>
<property name="initialPoolSize">
<value>3</value>
</property>
<property name="acquireIncrement">
<value>3</value>
</property>
<property name="minPoolSize">
<value>1</value>
</property>
<property name="maxPoolSize">
<value>15</value>
</property>
<property name="maxStatementsPerConnection">
<value>100</value>
</property>
<property name="automaticTestTable">
<value>oracle_server</value>
</property>
<property name="numHelperThreads">
<value>20</value>
</property>
<property name="preferredTestQuery">
<value>select * from oracle_server</value>
</property>
</bean>
Do not forget to include Oracle driver ojdbc14.jar and c3po jar c3p0-0.9.1.2.jar in the class path.
Also, for those who need DBCP settings here they are:-
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@SERVER:1521:07" />
<property name="username" value="USERNAME" />
<property name="password" value="PASSWORD" />
<property name="initialSize" value="2" />
<property name="maxActive" value="5" />
<property name="maxIdle" value="2" />
</bean>
11. <SOAP-ENV:Envelope
12. xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
13. <SOAP-ENV:Body>
14. <getAccountHolderName xmlns="http://account.sun.com/">
15. <acctNum>3</acctNum>
16. </getAccountHolderName>
17. </SOAP-ENV:Body>
18. </SOAP-ENV:Envelope>
11. SOAPMessage message = ...
12. SOAPBody body = message.getSOAPPart().getEnvelope().getBody();
13. Iterator i = body.getChildElements();
14. SOAPElement element = (SOAPElement) i.next();
15. System.out.println( element.getElementName().getLocalName() );
Netbeans also brought Glassfish Application Server as its official server. Glassfish is the the RI (Reference Implementation) from JEE 5, therefore it is the better choice when you want to work with EJB 3.
Keeping that in mind, I decided to list six Firefox extensions, which I use in my daily life and which have been extremely helpful in saving me a great deal of time. I hope you will find them useful too.
For anyone who is considering upgrading Netbeans, I wanted to mention a few things I found in my upgrade process. Feature Highlights
* JavaScript Support
o Semantic Highlighting
o Code Completion and Type Analysis
o Quick Fixes and Semantic Checks
o Refactoring
* Performance Enhancements
o Up to 40% faster startupo Smarter parsing so that code completion is faster
o Less memory consumption
* Spring Framework Support
o Bundled Spring Framework 2.5 libraryo Wizards for XML configuration files and Spring Web MVC controllers
o Code completion of bean names and Java classes and properties
o Spring Web MVC framework support in web project
* New MySQL Support in Database Explorer
o Register MySQL serverso View, create, and delete databases
o Easy launch of the administration tool for MySQL
* Java Beans Support
o BeanInfo Editoro Generate Bean Property* JSF CRUD Generator
o Bean Patterns in Navigator
o Quickly create a database application
o Supports one-to-one, one-to-many, and many-to-many entity relationships
* Ruby/JRuby Support
o Editor enhancements, including new hints and fixes* Javadoc Code Completiono Support for JRuby fast debugging
o Platform Manager
o Server and database integration improvements in Rails projects
o Supports standard tags: @param, etc.
o Code completion for parameters, exceptions, etc.
* Sharing Projects (AKA Sharable Libraries)
o More easily share projects with other members of your team through version control systems
o Specify libraries using relative library path for default Java, Web, and all Java EE project types
o Declare project dependencies with relative library paths
o Enable unattended builds for your projects
* New Update Center Modules
o ClearCase Support
o AXIS Support
o SOAP UI Support
