RE: JAVA Developer

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <jobmiller@xxxxxxxxx>, <Laimutis.Nedzinskas@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 8 Jan 2007 16:11:03 -0500

'no need for interfacing with you stored procedures' - is a good thing?

 

Joel Patterson 
Database Administrator 
joel.patterson@xxxxxxxxxxx 
x72546 
904  727-2546 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Job Miller
Sent: Monday, January 08, 2007 1:19 PM
To: Laimutis.Nedzinskas@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: JAVA Developer

 

just for some fun..

 

if he is a good productive java developer, he probably doesn't bother with all 
that type of stuff..  he says that's what the java container and/or O/R Mapping 
tools do for you..

 

He will say, I use Oracle's toplink/ADF BC or hibernate and I map objects to 
tables, and it generates the SQL with all the bind variables.  no need for 
interfacing with your stored procedures, no need for worrying about pagination 
(it does that).

 

Be prepared for that type of thing and don't immediately dismiss the O/R 
mapping tools as a viable means for mundane persistence or the preferred J2EE 
developers approach.

 

those tools (toplink anyway), supports stored procedures, so you can still 
reign in those kind of folks if you need to.  :)

 

ADF  BC (the follow-on java framework that replaces forms), is another 
bind-variable, pagination database friendly framework for retrieving/persisting 
data.

 

Job

 

 



Laimutis Nedzinskas <Laimutis.Nedzinskas@xxxxxxxxxxxxx> wrote:

        Ask if he has heard about strong typing. Is he going to use strings for 
dates? Does he actualy know there is a date datatype in most of rdbms'es ? Does 
he suspect that date may be a datetime in some of them? Is he going to rely on 
implicit conversion or he already knows there is a function to convert string 
to/from date ? May be he even knows that format mask can be explicitely 
specified ?

         

        Ask if he has heard about bind variables to start with. Then ask how he 
is going to implement them. Ask to show (pseudo)code samples.

         

        The ask some more advanced questions like what he thinks how rdbms 
finds one particular row out of 100T rows? Does he suspect that "where like 
'%java%'" can be tricky? May be he even has an idea how rdbms can order rows? 
May be he suspects that condition (b=1 or a=2) can be a culprit? 

         

        May be he has some idea that statement.execute means some network 
roundtrips to the server?

         

         

         

         

         

         

        
         

        
________________________________


        From: oracle-l-bounce@xxxxxxxxxxxxx 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joel.Patterson@xxxxxxxxxxx
        Sent: 8. janúar 2007 16:36
        To: oracle-l@xxxxxxxxxxxxx
        Subject: JAVA Developer

        We are getting ready to hire a JAVA Developer, and I was asked if I 
wanted to ask some questions relating to the database.... or to see if we get 
along.

         

        Connection pooling comes to mind, not imbedding code that would become 
a cpu issue, etc.   

         

        Not having much experience with Java, do anyone have questions I could 
entertain?  Some of you may have had such an experience already, and could pass 
on a couple questions you wish you had asked, or would ask next time.

         

        Joel Patterson 
        Database Administrator 
        joel.patterson@xxxxxxxxxxx 
        x72546 
        904  727-2546 

        
        Fyrirvari/Disclaimer
        http://www.landsbanki.is/disclaimer 
<http://www.landsbanki.is/disclaimer> 

 

 __________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Other related posts: