About Hibernate 3 plugin for Maven

In one of my previous entries, I had something really cool on my POM, which basically generated the DataBase based on my Entyties (or Domain objects), and that was the Hibernate 3 plugin for Maven
As you will see on the official documentation for that plugin, you can do a bunch of things, but it doesn't says anything about, generating Java classes based on the Tables, right? In other words, if I want my model java files (obtained by reveng) compiled, you don't need to run hbm2hbmxml.
I found the solution to this issue (unfortunately is not documented, and that's why you see it here):

Plugin configuration <plugin> <groupId>org.codehaus.mojo</groupId> <artifactId>hibernate3-maven-plugin</artifactId> <version>2.2</version> <configuration> <components> <component> <name>hbm2java</name> <outputDirectory>src/main/java</outputDirectory> <implementation>jdbcconfiguration</implementation> </component> </components> <componentProperties> <!--Reverse Eng using hbm2java: ejb3 give us annotated classes --> <revengfile>/src/main/resources/reveng/model_reveng.xml</revengfile> <propertyfile>/src/main/resources/META-INF/hibernate.properties</propertyfile> <jdk5>true</jdk5> <ejb3>true</ejb3> <format>true</format> </componentProperties> </configuration> <dependencies> <!--Dependencia al driver jdbc de la bd a la que necesites trabajar --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.6</version> </dependency> <dependency> <groupId>cglib</groupId> <artifactId>cglib-nodep</artifactId> <version>2.1_3</version> </dependency> </dependencies> </plugin>
hibernate.properties

hibernate.connection.username=root
hibernate.connection.password=secretit0
hibernate.connection.url=jdbc:mysql://127.0.0.1:3306/little_store
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.default_schema=little_store

model_reveng.xml <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-reverse-engineering SYSTEM "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd"> <hibernate-reverse-engineering> <table-filter match-name=".*" package="YOUR PACKAGE GOES HERE"/> </hibernate-reverse-engineering>
Then the last step is executing Maven:

mvn hibernate3:hbm2java

And we're ready to roll! :)

Is your Computer boy or girl?

If you want to hear the voice of your Computer, what you can do is write this simple code into a notepad and save it with extension *.vbs
CreateObject("SAPI.SpVoice").Speak"Hello amigo"
And you'll hear your computer speaking :P

Reading text files on MS-DOS

In my previous entry, I was trying to process a text files (a CSV), using each line of that file as input for my SQL*Plus call.
But, what happens if you don't have a UNIX box where you can execute it??? :(
Let's write my shell script into a batch file (oh man!), and this is the result: @echo off for /f "tokens=1,2,3,4 delims=," %%a in (./input/dummy_shipped_orders.txt) do ( sqlplus CIDB/CIDB1234@CIDB @report.sql %%a %%b %%c %%d ) Where %%a is the first token, %%b the second one, and so on (until we'd reached the fourth token - as specified on tokens=1,2,3,4)
At the end, it was simple :D

Report in SQLPlus using spool to write a file

On my previous entry I'm reading a file and using each line as input to make an external call (call SQL*Plus for example) Well, this is my SQL (script) to be executed using SQL*Plus, in other words, I will execute this query for each line of a given file (shell script), each time that I call SQLPlus I'll append to the spool (output file) the result of my query (I'll pass as parameter to my query the parameter given on command call)

sqlplus CIDB/CIDB1234@CIDB @input_file.sql PRE11221000001

And this is my Query (my report, because I'm adding more stuff)
SET TERMOUT OFF SET SPACE 3 SET LINESIZE 500 SET NUMWIDTH 15 SET PAGESIZE 80 SET FEEDBACK OFF SET VERIFY OFF SET UNDERLINE = SET TRIMSPOOL ON ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; column date_column new_value today_var SELECT TO_CHAR(SYSDATE,'yyyy-mm-dd') date_column FROM DUAL; SPOOL output_file_&today_var APPEND; SELECT cust_id, acct_num, pos_order_id, pos_loc_cd, total_order_lines, order_state, order_state_date, cidb_order_id, add_lines_cnt, upg_lines_cnt, eqp_lines_cnt, pos_pre_order_id FROM CUST_ACCT_ORDER WHERE pos_pre_order_id = '&&1'; SPOOL off; EXIT;

&&1

is the first parameter after the script namde in command line, then the second param will be &&2 then the third one &&3 and so on

My output will be a file named: output_file_2011-02-04.LST

For more information and references please see the official Oracle web site for SQL*Plus:
Ref 1
Ref 2
Ref 3
Ref 4

Read File using Unix Shell

This is something really small which could be useful in case you want to read a comma separated file and use each line (on this case to call an external program passing as parameter each field value)
#!/usr/bin/env ksh93 fileName=/tmp/data.csv echo echo "################### $(date) #####################" echo [ ! -f ${fileName} ] && echo "ERROR: Exiting as ${fileName} not found!!" && exit 1 while read line; do field1=$(echo $line | awk -F "," '{print $1}') field2=$(echo $line | awk -F "," '{print $2}') field3=$(echo $line | awk -F "," '{print $3}') echo ${field1} ${field2} ${field3} ## external command goes here done < ${fileName}

Run a SQLPlus script and pass a parameter as input

Simple:
call sqlplus user/password@database @your_script.sql abc123 qwe890 <br />
Then your script:
begin dbms_output.put_line(&&1);
dbms_output.put_line(&&2);
end;
/