Raminder Singh

Hi,

I need some help on resolving below issue in hibernate queries (HQL) calling a stored Procedure (using MySQL DB).

Stored Procedure name is proc_name
Sample Query executing in procedure is:
SELECT tab01.*, 3*5.15 as distance FROM Table1 tab01 WHERE <some conditions>
Declaration in hibernate:
<sql-query name="callProc" callable="true"> <return alias="table1" class="Table1"/> <return-scalar column="distance" type="double" /> <![CDATA[CALL proc_name(:input1, :input2)]]> </sql-query>

Now issue is that:
- Return data from procedure is [all the columns from Table1] and [a additional scalar data].
- Used below code in java to execute procedure
Query query = session.getNamedQuery("callProc") .setParameter("input1", x) .setParameter("input2", y)
Now how to get the data back from query.list()?

- I am trying to create a new class Table2 extended from Table1 with a new property distance and then using query.setResultTransformer(Transformers.aliasToBean(Table2.class))
Is this correct? I'm getting an error for unknown id via hbm file? IfTable1.java is mapped to Table1 via hbm file do we still need to create a hbm for table2 which i doubt.

- how to use setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP) here?

- Can I directly use List<Table2> result = query.list();
and wish that both the data (columns of Table1 & additonal scalar data) will be available? I'm able to get 2 objects in list 'result' but casting from object to Table2 getting failed.

Please suggest the correct approach.


Regards,
Raminder Singh

Hi,

I need some help on resolving below issue in hibernate queries (HQL) calling a stored Procedure (using MySQL DB).

Stored Procedure name is proc_name
Sample Query executing in procedure is:
SELECT tab01.*, 3*5.15 as distance FROM Table1 tab01 WHERE <some conditions>
Declaration in hibernate:
<sql-query name="callProc" callable="true"> <return alias="table1" class="Table1"/> <return-scalar column="distance" type="double" /> <![CDATA[CALL proc_name(:input1, :input2)]]> </sql-query>
Now issue is that:
- Return data from procedure is [all the columns from Table1] and [a additional scalar data].
- Used below code in java to execute procedure
Query query = session.getNamedQuery("callProc") .setParameter("input1", x) .setParameter("input2", y)
Now how to get the data back from query.list()?

- I am trying to create a new class Table2 extended from Table1 with a new property distance and then using query.setResultTransformer(Transformers.aliasToBean(Table2.class)) Is this correct? I'm getting an error for unknown id via hbm file? IfTable1.java is mapped to Table1 via hbm file do we still need to create a hbm for table2 which i doubt.

- how to use setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP) here?

- Can I directly use List<Table2> result = query.list(); and wish that both the data (columns of Table1 & additonal scalar data) will be available? I'm able to get 2 objects in list 'result' but casting from object to Table2 getting failed.

Please suggest the correct approach.


Regards,
Raminder Singh

Hi,
I have just seen fee for SCDJWS(CX-310-230) at http://in.sun.com/training/catalog/courses/CX-310-230.xml and it lists around Rs.17,550.00 (ex. VAT) .

Is this correct one? Normally Oracle Exams are in the range of $125 .. now as Sun is under Oracle, do we expect decrease in the Java's certification fees in coming days?

Thanks
Raminder

yes. it is a web apps. Whats resolution for this? how to make sure.. log4j.properties is set properly and geting passed to classloader.??

Hi Jai,

I have set path to log4j.properties in classpath as D:\JavaWork\workingjava\src\log4j111\log4j.properties;

On providing that debug argument, It displays:
log4j: Trying to find [log4j.properties] using Class.getResource(). log4j: Trying to find [java/lang/log4j.properties] using ClassLoader.getSystemResource(). log4j: Trying to find [log4j.properties] using ClassLoader.getSystemResource(). log4j: Could not find resource: [log4j.properties]. File: null log4j:ERROR No appenders could be found for category (log4j111.PlanetDiameters111). log4j:ERROR Please initialize the log4j system properly.

Can you help.. why its not picking from classpath?

Hi,

We are facing problem in changes to be done for running our code on 1.2.8 version. Earlier it was working for 1.1.1 version.

In 1.1.1 version, Category class instance is initilized and log4j.properties is set as Category.DEFAULT_CONFIGURATION_FILE. (But we are getting this issue even in test code. We put log4j.properties file in classpath but still is says:
log4j:ERROR No appenders could be found for category (log4j111.PlanetDiameters111).
log4j:ERROR Please initialize the log4j system properly.

In 1.2.8, Logger is initilized as
private static final Logger logger128 = Logger.getLogger (PlanetDiameters128.class)

Can someone share thoughts on what could be missing here/or need to be done for getting Category instance replaced with Logger.

Codes are:
For 1.1.1

package log4j111; import java.util.Enumeration; import java.util.Hashtable; import org.apache.log4j.Category; public class PlanetDiameters111 { private static Category logger111 = Category.getInstance(PlanetDiameters111.class); static { System.setProperty("log4j.configuration", "file :mrgreen: :\\JavaWork\\workingjava\\src\\log4j111\\log4j.properties"); } public static void main(String args[]) { String names[] = { "Mercury", "Venus", "Earth", "Mars", "Jupiter", "Saturn", "Uranus", "Neptune", "Pluto" }; //Category.DEFAULT_CONFIGURATION_FILE = //"file :mrgreen: :\\JavaWork\\workingjava\\src\\log4j111\\log4j.properties"; //System.setProperty(Category.DEFAULT_CONFIGURATION_FILE, // "file:\\D:\\JavaWork\\workingjava\\src\\log4j111\\log4j.properties"); System.out.println("File: " + System.getProperty(Category.DEFAULT_CONFIGURATION_FILE)); float diameters[] = { 4800f, 12103.6f, 12756.3f, 6794f, 142984f, 120536f, 51118f, 49532f, 2274f }; Hashtable<String,Float> hash = new Hashtable<String,Float> (); for (int i = 0, n = names.length; i < n; i++) { hash.put(names[i], new Float(diameters[i])); } Enumeration<String> e = hash.keys(); Object obj; logger111.debug("Using logger111.debug....."); while (e.hasMoreElements()) { obj = e.nextElement(); logger111.debug(obj + ": " + hash.get(obj)); } } }
For 1.2.8
package log4j128; import java.util.Enumeration; import java.util.Hashtable; //import org.apache.log4j.Logger; public class PlanetDiameters128 { //private static final Logger logger128 = Logger.getLogger(PlanetDiameters128.class); public static void main(String args[]) { String names[] = { "Mercury", "Venus", "Earth", "Mars", "Jupiter", "Saturn", "Uranus", "Neptune", "Pluto" }; float diameters[] = { 4800f, 12103.6f, 12756.3f, 6794f, 142984f, 120536f, 51118f, 49532f, 2274f }; Hashtable<String,Float> hash = new Hashtable<String,Float> (); for (int i = 0, n = names.length; i < n; i++) { hash.put(names[i], new Float(diameters[i])); } Enumeration<String> e = hash.keys(); Object obj; //logger128.debug("Using logger128.debug....."); while (e.hasMoreElements()) { obj = e.nextElement(); //logger128.debug(obj + ": " + hash.get(obj)); System.out.println (obj + ": " + hash.get(obj)); } } }
log4j.properties
log4j.Category=A1 log4j.appender.A1=org.apache.log4j.ConsoleAppender log4j.appender.A1.layout=org.apache.log4j.PatternLayout log4j.appender.A1.layout.ConversionPattern=%-5p (%F:%L) - %m%n

Check by providing each <form> and <subview> tag as unique id name. Idea is to provide each component an id value.

Hi,
To upgrade from tomcat 5.0 to 5.5, source folders for both versions are checked and found that in 5.5 there are completly renamed & change of packages happen.



jakarta-tomcat-5.0.28-src:
jakarta-tomcat-5.0.28-src/jakarta-servletapi-5
jakarta-tomcat-5.0.28-src/jakarta-tomcat-5
jakarta-tomcat-5.0.28-src/jakarta-tomcat-catalina
jakarta-tomcat-5.0.28-src/jakarta-tomcat-connectors
jakarta-tomcat-5.0.28-src/jakarta-tomcat-jasper

apache-tomcat-5.5.26-src:
apache-tomcat-5.5.26-src/aservletapi
apache-tomcat-5.5.26-src/build
apache-tomcat-5.5.26-src/connectors
apache-tomcat-5.5.26-src/container
apache-tomcat-5.5.26-src/jasper
apache-tomcat-5.5.26-src/servletapi

I need some help on "jakarta-tomcat-catalina" package in 5.0 src which has a package "catalina\src\share\org\apache\coyote\tomcat5". Now this is not present in 5.5 src.

Also, in 5.0, jakarta-tomcat-connectors\coyote\src\java\org\apache\coyote package has some tomcat3+tomcat4 package. this is also present in 5.5 src.

My queries are:(we use source code to build tomcat)

1) Why catalina package (which present in 5.0 src) not in 5.5? How to get this for working with 5.5 code?

2) What tomcat3, tomcat4, tomcat5 for coyoteRequest signifies?

3) Can update/alias of these files (tomcat4) can be used in place of tomcat5 files which are missing?

4) Can it be refer from some where while building tomcat from src code for 5.5?

thanks
raminder

Hi,

Help me to proceed.

Scenario:
Main page has some tabs & sub tabs. It also have main form tag.
Each subtab in main page refer to an seperate JSP. JSP code of Subview has an subView tag.

Now how to pass control from page1 (tab01->subtab01) to page2( tab02->subtab02), Bean of page1 has action of page 2. In faces-config, each action has corresponding JSP. but diretly going to page02 says Form tag missing.

Is this case suitable for NavigationHandler? Can you share some more code/suggestions?

thanks

Hi,

Help needed for updating an list in jsp with values added as dynamic row.

detail: I have a table displaying data from list. It displays 2 rows. I have a button which on clicks added one more row ..blank row.. in which data is added. now on submit, i need to update list.

thanks.

If you learn Generics and collections as per 1.5, it will certainly provide you more confidence. These are not that complex. Just do some hand on practice and you will feel easy.

Well I was looking for some more feedback on importance of some basics PM skills for any software developer in terms of efficiency and productivity .

My concern here is how a new/or say 2+ years of exp. developer/programmer have an idea of PM practices/tasks? I was involved in managing team of 4 guys for 5 months after 5 year of my development exp. and truly saying that period opened my eyes to very basic things of PM. I must say ever programmer should have a basic understanding of importance of task allocations, code reviewing, test plans, development tasks and its dependencies, task priorities etc. What i got at end of that is more planned in my approach and having an fair idea of end-to-end vision of whole project/product development.

Is this book helps in filling this gap? I am confident in so. The teaching methodology by Head First is making things easy and fun to learn.

Any view/feedback?

Line 1 - initializing the class level set 'adverts' variable as blank.
Line 2 - When we going to make a category by parameterized constructor providing only title, then again initializing set as blank.
reg: Set, it is because 'A set with no nullable element columns. It will have a primary key consisting of all table columns (ie. key columns + element columns)' - http://www.hibernate.org/hib_docs/v3/api/org/hibernate/mapping/Set.html

Can anyone help me in understanding what are disadvantages of hibernate?

is it - Complex in learning mapping file having syntax for different relations?

or what can be others?