Jeff Schuler

When I run the SP directly I do this:

exec dbo.SP_TT_USP_TMWSUITEPM_CREATE 0

When I run it from Java it's like this:

//Create the prepare statement String sql = "exec dbo.sp_tt_usp_tmwsuitepm_create ?"; ps = conn.prepareStatement(sql); // The debug value will always be set to 0 when called from the java interface ps.setInt(1, 0); //Run the Query rs = ps.executeQuery();


The connection info is:
TMSTMDBDEVClass=net.sourceforge.jtds.jdbc.Driver TMSTMDBDEVURL=jdbc:jtds:sqlserver://tmdbtst:1100/TFWUPG;sendStringParametersAsUnicode=false TMSTMDBDEVUsername=XXXXXXXX TMSTMDBDEVPassword=XXXXXXXX

The following SQL code is behaving differently when the SP is called from Java:

SET @SQL = N' UPDATE ' +@SSTRING+ 'expiration set exp_completed = ''Y'', exp_compldate = getdate() where exp_code = ''PRE'' AND exp_completed = ''N'' AND exp_id + exp_description not in ( select unitnumber + descrip from #psexpire as p where status = ''OPEN'' )' EXEC sp_executesql @SQL

The SP is updating a table from another database on another server. Does anyone know why the results would be different?

I am looking to get my foot in the door. I have been studying various aspects of Java technologies. I have an SCJP and SCWCD.

Let me know if anyone is looking for a Junior Java Developer. I will be happy to give you my resume.

I had a mock question that stated /WEB-INF/classes was required. Is this true? From what I have read only /WEB-INF/web.xml is required.

Is ${sessionScope.attribute.property} equal to ${sessionScope.["attribute"]["property"]}?

Hi,

I plan on taking the SCWCD exam in December. After taking the exam, I planned to build my own web application for practice (beyond the small apps covered in HFSJ). I want to build this web app in a manner that's it comparable to web apps built in the "real world". So I believe I need to go beyond what is taught for the SCWCD exam.

What would be your recommendations to make this happen?

I do plan to take the SCBCD exam sometime in the first half of next year since SCWCD and SCBCD are often linked together. For my exercise I will not be using EJB's though.

For example would it be important for me to learn Struts and/or JavaServer Faces frameworks. How about Javascript, CSS, and HTML?

Which additional technologies and concepts would an employer typically expect from a web developer that uses Servlets/JSP?

My situation:
- Created an application with Netbeans that uses the Java "Derby" database on my local machine.
- I can connect to the database fine on my machine by using the connect options in Netbeans.
- I don't want to use Netbeans to execute this program.
- I have the JAR file available. When I try executing the JAR file, it will fail because I'm not connected to the database.

My Questions:
How do I execute my program and connect to the database without using Netbeans? Should I be using a script to connect to the database and then executing the JAR file? Is there a better way?

Thanks,

Originally posted by Jeanne Boyarsky:
Jeff,
Does the other person running the app already have a database? If so, which one?

No they don't have the database. I would be giving them the already populated database. The database is the "Derby" database that comes with Netbeans. I'm not sure what's the best way for them to connect to it though.

I have a stand alone application that reads a database on my local machine. It's not setup on a server.

How do I move this application along with the database (Java database that comes with Netbeans) to another PC for someone to run effortlessly. The only confusing part to me is with the database. I can include the database file along with the JAR file in a zip file but how would they connect to the database? I have been using Netbeans to connect to the database.

Should I be writing a script to do this or is there a better way?

I take it I should be using J2EE 1.4 when preparing for this exam. Will J2EE 1.5 be fine as well when studying for this exam? Why does the Head First book tell me to install J2SE 1.4? Sorry about the newbie question but I'm unfamiliar to 'EE'.

Is it ok to both have JSEE 1.4 and J2SE 6 installed on the same Windows machine? I presumed I will just need to setup the classpath to point to the J2EE 1.4 version when preparing for this exam.

Originally posted by marc weber:

It does not set the e3.e reference to null. However, the object that e3.e is pointing to can no longer be reached, and this makes it eligible for garbage collection.

But there is a problem with this code. At runtime, it will throw a NullPointerException at the line e2.e = e1; At that point, e2 is already null, so e2 cannot be dereferenced to get to e2.e.

[ July 28, 2007: Message edited by: marc weber ]

Thanks for the reply. This question is referring to a question in K&B book chapter 3. It states that a single object is never eligible for GC even though there is one prior to the runtime exception.

class Eco { public static void main(String[] args) { Eco e1 = new Eco(); Eco e2 = new Eco(); Eco e3 = new Eco(); e3.e = e2; e1.e = e3; e2 = null; e3 = null; e2.e = e1; e1 = null; } Eco e; }

When "e3 = null;", does that set e3.e to null as well? If not why? It can no longer be referenced. So after "e3 = null;", isn't their one object available for GC?

I'm an rookie with regards to using databases with JDBC. I downloaded the JDBC driver for Microsoft SQL Server and I was able to register the driver using this statement:

try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); } catch (ClassNotFoundException e) { e.printStackTrace();}

I don't get any errors with the above line but I'm unsure how to open up a database connection. I used Windows Authentication when creating a database in MS SQL Server, so I didn't use a name or password. I tried a lot of things but couldn't get a connection. Can someone please provide an example how I would connect to the database?

Questions:
Since I didn't use a name and password when creating the database, can I connect without a name and password?
How does it know where the database exists on my system?

Here are several things that I tried:
"jdbc:datadirect:sqlserver://server1:1433;databaseName=Jeff;AuthenticationMethod=auto";" "jdbc:sqlserver://localhost:1433;databaseName=Jeff;user=mySystemUsername;password=mySystemPassword";
"jdbc:datadirect:sqlserver://server1:1433;AuthenticationMethod=auto";"

When I run the getConnection method I get unsuitable driver for the first example and a TCP/IP error on the second.

TIA

Originally posted by kathir vel:
In this sample program also the same logic...with out notify waiting thread can continue execution once it get the object lock again.

According to the K&B book the program will wait forever even if the lock is released. It does mention that sometimes the thread will sometimes start on it's own even without a notify() depending on the JVM. I wonder if this is the reason.

For the following code, I thought that the main thread would wait forever because the notify() statement is never run. Instead the "Total is" line was displayed. Does anyone know why?

class InterTest { public static void main(String[] args) { ThreadA t = new ThreadA(); t.start(); synchronized(t) { try { System.out.println("Waiting for t to complete..."); t.wait(); } catch (InterruptedException e) { e.printStackTrace(); } System.out.println("Total is: " + t.total); } } } class ThreadA extends Thread { int total; public void run() { try { sleep(2000); } catch (InterruptedException e) {} synchronized(this) { System.out.println("In ThreadA synch block"); for(int i=0; i < 100; i++) { total++; } //System.out.println("Send Notify"); //notify(); } } }

Originally posted by anil kumar:
Hi

Jeff Schuler


How can you assign a super class reference to a sub class reference ?

Here ArrayList is-A List


Have you Got it ?


Thanks

Anil Kumar

[ July 02, 2007: Message edited by: anil kumar ]

Thanks, I got it. I have to start reading the questions more carefully.