Carl Zeigler

Hi, I am trying to use the formatNumber function to display a string value returned from a database via rs.getString(). I have been testing the formatNumber function and see how it works but I cannot figure out how to pass the string returned from the database into the value parameter of the formatNumber fucntion. Is there any way I can do this?

<%String currency = rs.getString("AmntOfFunding");%> <TD align=left nowrap><fmt:formatNumber value="<%=currency%>" type="currency" /></TD>

Thank you.

Hello,
I have installed the SQL Explorer plugin for Eclipse. I have the connection working OK but if I connect with a read only ID, I can only view a list of the database tables. The functions and procedure elements of the database structure view will not populate with the functions/procedures in the schema.

If I connect with an ID that has update permissions to the database, the function and procedure elements of the database structure view populate correctly.

I am connecting to an Oracle database (10.2.0.4.0) using the Oracle thin driver from oracle.jdbc.OracleDriver in ojdb6.jar. I am using version 3.5.2 of the Eclipse platform on a WinXP machine.

Incedentally, I tried to install the Toad plugin for Eclipse and have the exact same issue.

Can anyone please suggest a solution? I need to be able to use the read only ID in order to access or view database tables, procedures and functions in a production environment.

Thank you,
Carl

Hi,
I have been struggling with this all day.

I am using the most recent version of Eclipse, JDK 1.6, ojdb6.jar, and my database is Oracle 9.2.0.1.0.

I am trying to use a scrollable resultset but cannot call the resultset.beforeFirst() method. I have tried using classes12.jar, ojdbc4.jar and ojdbc6.jar. I have tried to make sure that all columns were included in the select statement to ensure there was not an issue with the primary key.

No matter what I do, I cannot get the resultset to use either TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE.

Any suggestions would be very much appreciated.



String url = "jdbc:oracle:thin:@dpsrd0.it.removed.com:1549:O01PSR0";//removed company subnet name Class.forName("oracle.jdbc.driver.OracleDriver"); CONN2 = DriverManager.getConnection(url, username, password); Statement stmtTrl = CONN2.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); PreparedStatement pstmtTrl = CONN2.prepareStatement(selectTrl);//selectTrl is type String ResultSet rsTrl = pstmtTrl.executeQuery(); int type = rsTrl.getType(); int cont = rsTrl.getConcurrency(); System.out.println(type);//prints 1003 System.out.println(cont);//prints 1007


This is what I am trying to use which is causing the exception below. I want to reset the cursor position before the break.

while (rs.next()) { if (rsTrl.getString("message_id").equals(MsgId)){ rtnString = rsTrl.getString("message_text").substring(50,55); //System.out.println(rtnString); rsTrl.beforeFirst(); break; } }

java.sql.SQLException: Invalid operation for forward only resultset : beforeFirst at oracle.jdbc.driver.BaseResultSet.beforeFirst(BaseResultSet.java:65) at aft.utils.Util.GetHdrCount(Util.java:36) at org.apache.jsp.ProcPtwldMessages_jsp._jspService(ProcPtwldMessages_jsp.java:270) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)

Thank you, thank you, thank you! I had to first remove src from the build path then I was able to select -> build path | use as source folder. Worked like a charm.

Carl

Hello and thank you in advance.

I am having a problem adding a new class and package (not default) to a dynamic web project in Eclipse. When I add the package, it is displayed under Java Resources: src as an expanded folder (not a package) in the package explorer window and the .java file is not compiled to a .class file when saved. I have "Build Automatically" checked in the project settings and the java build path settings for the source output folder look OK.

By comparison, using another test project (dynamic web) that I created, the new package is added to the project under Java Resources: src as a package (not a folder) and works just fine. The .java file is compiled to the build\classes directory and I am able to use the class in a JSP.

I am not able to determine what the difference is between the two projects that might be causing this issue.

Any suggestions are greatly appreciated.

Thanks,
Carl