Köll & Sam Classroom Blog

[Dököll]

Hello Dudes and Dudettes!

I am excited to announce I am embarking on a new Journey, JAVA baby. This is a new arena for me, hope I survive and able to muscle through it.

Will post articles within three months from now.

Wish me luck!

Köll

[Dököll]

Greetings, Jos!

Thanks for replying... Below was an attempt to increment columns each time the program reads database columns and found addtional columns next marker, loops until there are none, I am probably reading it wrong:-)

 
for(int i=1; i<columnCount+1; i++) {
    resultsMetaData.getColumnName(i);
    }
 
 

But to answer your question, the code runs fine and fires a .jsp file, but when I run program using the actual code above, MetaData seems to be an issue.

I'll look at te loop again, and post the error.

Hey, have a good Friday...

In a bit!

Dököll

I'll just add it now Jos, will try the loop later and will yu know:

 
    at HelloWorld.showTable(HelloWorld.java:64)
    at HelloWorld.doGet(HelloWorld.java:48)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Unknown Source)
 
 

[JosAH]

The getColumnName(int i) method simply returns the name of column i;
your loop retrieves them all and simply ignores them. You could've taken that
entire loop out of your program because all it does is consuming a bit of time.
Read the API documentation for the ResultSetMetaData class.

kind regards,

Jos

[Dököll]

The getColumnName(int i) method simply returns the name of column i;
your loop retrieves them all and simply ignores them. You could've taken that
entire loop out of your program because all it does is consuming a bit of time.
Read the API documentation for the ResultSetMetaData class.

kind regards,

Jos

Unbelievable, making more work for myself, thanks for pointing out API documentation for the ResultSetMetaData class, keep you posted.

Köll

[JosAH]

Unbelievable, making more work for myself, thanks for pointing out API documentation for the ResultSetMetaData class, keep you posted.

Köll

AAMOF *all* the classes you can use in Java SE are (heavily) documented. See
the Articles Index in the Java 'Howtos' section for a link from where you can
download the entire documentation; it's only a couple of mega bytes. Always
check the docs first for any class you want to use no matter whether or not you
think you already know that class; it pays back big times if you do so.

If you don't you might end up as lots of others who think the entire programming
world should be visual basic and be surprised again and again that Java doesn't
have a ClearScreen command or something else silly.

kind regards,

Jos

[Dököll]

Works like a charm, the API documenatation for both Database and ResultSet helped a great deal, the loop has since been reconsructed, I think I would have had issues beyond the API info:

 
    for (int i = 1; i <= colCount; ++i) {
          out.println("<th>" + resultSetMetaData.getColumnName(i) + "</th>");     
} 
          out.println("</tr>");
   while (resultSet.next()) {
          out.println("<tr>");
   for (int i = 1; i <= colCount; ++i)
          out.println("<td>" + resultSet.getString(i) + "</td>");
          out.println("</tr>");
            }
 
 

Thanks a million for your help Jos...

We'll see you in a bit, I have a couple of question, I must fetch it from an email...

[Dököll]

Hello again!

In crystal reports, one can drag fields onto reports. Fields can be text,
date time, numbers, etc. I know they support html. I need to know if they
support all the html tags(eg: bgcolor, tables, etc).

Also, can you point me to a turtorial for calling Crystal reports from Java servlets
using simple java classes to provide data, I can't seem to find a sound document, an easy to understand one to follow, perhaps it cannot be done.

Would you know if integrating the Crystal reports viewer with an
application server like websphere/tomcat is doable?

Will keep searching meanwhile and will post my findings.

In a bit!

Dököll

[JosAH]

Works like a charm, the API documenatation for both Database and ResultSet helped a great deal, the loop has since been reconsructed, I think I would have had issues beyond the API info:

 
    for (int i = 1; i <= colCount; ++i) {
          out.println("<th>" + resultSetMetaData.getColumnName(i) + "</th>");     
} 
          out.println("</tr>");
   while (resultSet.next()) {
          out.println("<tr>");
   for (int i = 1; i <= colCount; ++i)
          out.println("<td>" + resultSet.getString(i) + "</td>");
          out.println("</tr>");
            }
 
 

Thanks a million for your help Jos...

You're welcome of course; but what would you do if that ResultSet contains, say,
1,000,000 rows or so?

kind regards,

Jos

[JosAH]

Hello again!

In crystal reports, one can drag fields onto reports. Fields can be text,
date time, numbers, etc. I know they support html. I need to know if they
support all the html tags(eg: bgcolor, tables, etc).

If Crystal Reports is Java (and I think it is) the following from the API docs apply:

The Swing JEditorPane text component supports different kinds of content via a plug-in mechanism called an EditorKit. Because HTML is a very popular format of content, some support is provided by default. The default support is provided by this class, which supports HTML version 3.2 (with some extensions), and is migrating toward version 4.0. The <applet> tag is not supported, but some support is provided for the <object> tag.

Also, can you point me to a turtorial for calling Crystal reports from Java servlets
using simple java classes to provide data, I can't seem to find a sound document, an easy to understand one to follow, perhaps it cannot be done.

Would you know if integrating the Crystal reports viewer with an
application server like websphere/tomcat is doable?

I'd have to google for that but I don't assume you live in a googleless area :-)

kind regards,

Jos

[Dököll]

If Crystal Reports is Java (and I think it is) the following from the API docs apply:






I'd have to google for that but I don't assume you live in a googleless area :-)

kind regards,

Jos

Oh no, Google's our friend, it's surely out there, thanks for your input... Just wondered if you had an idea, thanks for replying:-)

Getting an error though, I was coming over to bug you again:

Server Tomcat v6.0 Server at localhost failed to start.

Did I do something weird, it worked flawlessly before, well at least to some degree, if you remember the last post Jos... I must have done something to it, it's just not firing. Any ideas, googling it momentarily (does not seem to be coming up for me though)... probably beat you to it...hope some posted something:-)

Again thanks for your help...

[Dököll]

Oh no, Google's our friend, it's surely out there, thanks for your input... Just wondered if you had an idea, thanks for replying:-)

Getting an error though, I was coming over to bug you again:

Server Tomcat v6.0 Server at localhost failed to start.

Did I do something weird, it worked flawlessly before, well at least to some degree, if you remember the last post Jos... I must have done something to it, it's just not firing. Any ideas, googling it momentarily (does not seem to be coming up for me though)... probably beat you to it...hope some posted something:-)

Again thanks for your help...

I was fooling around with one of my xml files... all is well now...

This one's for the newbies, if you have this problem, look at your log file for Tomcat: C :\ Program Files\Apache Software Foundation...\...logs, it'll tell you where the problem is...

Later,

Dököll

[JosAH]

I was fooling around with one of my xml files... all is well now...

This one's for the newbies, if you have this problem, look at your log file for Tomcat: C :\ Program Files\Apache Software Foundation...\...logs, it'll tell you where the problem is...

Later,

Dököll

There's an entire chapter devoted to logging in Tomcat's documentation;
everybody can find the details there.

kind regards,

Jos

[Dököll]

There's an entire chapter devoted to logging in Tomcat's documentation;
everybody can find the details there.

kind regards,

Jos

Yes, I started reading, not about logging in Tomcat, but of file transfers from system to system, and lo and behold my system at home has all the old stuff and does not play nice with stuff at work.

For now I'll simply recreate stuff, when I get any bright ideas away from work, I send them there via email. But will definitely check into the tomat doc, there aere things I was able to do, like simply firing form my browser that I cannot do, will give it a shot.

I have started using NetBeans and Eclipse, side by side, just to see what the real differences are, NetBeans seems to be winning:-)

In a bit, really it's the way that NetBeans builds JSF pages seamlessly, thus far... will try to post problems side by side...

[Dököll]

I have started using NetBeans and Eclipse, side by side, just to see what the real differences are, NetBeans seems to be winning:-)

In a bit, really it's the way that NetBeans builds JSF pages seamlessly, thus far... will try to post problems side by side...

Alright!

Here's the scoop, I have either lost my marbles or something else but for the past couple of days I have been trying to find libraries specific to below, to no avail:

<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
 

import javax.faces.*; is not legal...

Where are these libraries stored?

NetBeans is having the same issues firing JSF, I suspect JSF is handled differently, so the seamless find was seeminglya NetBeans-specific engine that fires JSFs, at least that's what I think is happening, nonetheless, no joy there, it may mean no fooling around differentl IDEs and expext likely results...

Do such tag libraries exist, they must but I am blind thus far:

<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
 

[Dököll]

Alright!

Here's the scoop, I have either lost my marbles or something else but for the past couple of days I have been trying to find libraries specific to below, to no avail:

<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
 

import javax.faces.*; is not legal...

Where are these libraries stored?

NetBeans is having the same issues firing JSF, I suspect JSF is handled differently, so the seamless find was seeminglya NetBeans-specific engine that fires JSFs, at least that's what I think is happening, nonetheless, no joy there, it may mean no fooling around differentl IDEs and expext likely results...

Do such tag libraries exist, they must but I am blind thus far:

<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
 

I was searching wrong:

http://java.sun.com/javaee/javaserve...ocs/index.html I think I'll find what I need here, stop me if this is the wrong area. This latest search was my bgest shot. Thanks in advance:-)

[Dököll]

I was searching wrong:

http://java.sun.com/javaee/javaserve...ocs/index.html I think I'll find what I need here, stop me if this is the wrong area. This latest search was my bgest shot. Thanks in advance:-)

1 of 2 resolved; now, even though I am no longer having a build error, the page did not load, what do you make of it? I will be installing rational to just have everything installed at once, but how does one fix this if running Eclipse...

 
Project name:
Group name:
Programming:
Date:
Owner:
Legal:
 
 
<%@ page contentType="text/html"%>
 
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f"%>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h"%>
 
<f:view>
    <html>
    <head>
                <title>Employee Login</title>
                </head>        
    <body>
    <h:form>
    <table>
    <tr>
    <td>
                 <h:outputText value="Please add Office ID: " />
                </td>
<td><h:inputText id="loginspecificid" value="#{LoginEmpOfficeID.loginspecificid}" /></td>
    </tr>
                <tr>                        <td><h:outputText value="Please your Employee ID: " /></td>
<td><h:inputSecret id="employeeid" value="#{LoginEmpOfficeID.employeeid}" /></td>
                </tr>
    <tr>
    <td>&nbsp;</td>
<td><h:commandButton value="Login" action="#{LoginEmpOfficeID.CheckMate}" /></td>
    </tr>
    </table>
    </h:form>
    </body>
   </html>
</f:view>
 

I get an HTTP ERROR: 200, clearing unhappy with something, what's the deal there?

By the way, another way remedying the previous problem I had (not having the proper lib being called!) is to simply load Eclipse Ganymede which comes complete with reports abilities no Birt but also adds further functionality with Sun's JSF lib access. Hope this helps anyone having just that part of the problem...

Any help you can procide with the above HTTP ERROR: 200 glitch is helpful, even though I may fix this with proper software installed, it's food for brain, I think... good for others who wish to fix Eclipse - Europa/Ganymede problems also.

Thanks again good people!

Dököll

[Dököll]

1 of 2 resolved; now, even though I am no longer having a build error, the page did not load, what do you make of it? I will be installing rational to just have everything installed at once, but how does one fix this if running Eclipse...

 
Project name:
Group name:
Programming:
Date:
Owner:
Legal:
 
 
<%@ page contentType="text/html"%>
 
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f"%>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h"%>
 
<f:view>
    <html>
    <head>
                <title>Employee Login</title>
                </head>        
    <body>
    <h:form>
    <table>
    <tr>
    <td>
                 <h:outputText value="Please add Office ID: " />
                </td>
<td><h:inputText id="loginspecificid" value="#{LoginEmpOfficeID.loginspecificid}" /></td>
    </tr>
                <tr>                        <td><h:outputText value="Please your Employee ID: " /></td>
<td><h:inputSecret id="employeeid" value="#{LoginEmpOfficeID.employeeid}" /></td>
                </tr>
    <tr>
    <td>&nbsp;</td>
<td><h:commandButton value="Login" action="#{LoginEmpOfficeID.CheckMate}" /></td>
    </tr>
    </table>
    </h:form>
    </body>
   </html>
</f:view>
 

I get an HTTP ERROR: 200, clearing unhappy with something, what's the deal there?

By the way, another way remedying the previous problem I had (not having the proper lib being called!) is to simply load Eclipse Ganymede which comes complete with reports abilities no Birt but also adds further functionality with Sun's JSF lib access. Hope this helps anyone having just that part of the problem...

Any help you can procide with the above HTTP ERROR: 200 glitch is helpful, even though I may fix this with proper software installed, it's food for brain, I think... good for others who wish to fix Eclipse - Europa/Ganymede problems also.

Thanks again good people!

Dököll

I guess you could say I am close, but no cigar yet...

As it turns out, rational comes complete with the proper packages/utils, whereas Eclipse needs certain jars added to see added packages:

(1) jsf api/imp jar files
(2) jstl jar file
(3) Others, depending on what you are doing

Without these jar files, you will not be able to load JSP/JSF form-specific tags, essential to firing JSF-enabled pages and reap the benefits of good descent web sites:-)

[Dököll]

I guess you could say I am close, but no cigar yet...

As it turns out, rational comes complete with the proper packages/utils, whereas Eclipse needs certain jars added to see added packages:

(1) jsf api/imp jar files
(2) jstl jar file
(3) Others, depending on what you are doing

Without these jar files, you will not be able to load JSP/JSF form-specific tags, essential to firing JSF-enabled pages and reap the benefits of good descent web sites:-)

The jar files did the trick, no longer having a problem:-)