d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Help Please (sql Database To Jsp Page) > Paying Fg For Help!
Prev123Next
Add Reply New Topic New Poll
Views: 691Replies: 23Track Topic
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
#11
Nov 16 2015 08:55pm
here's an example to get you started then.

http://www.tutorialspoint.com/jdbc/jdbc-sample-code.htm

Come back after you added it. if you still have an exception, include the relevant code and the exception.
Member
Posts: 2,780
Joined: Dec 22 2008
Gold: 3,743.00
#12
Nov 16 2015 09:13pm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
　
<%@page
language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.*"%>
<html>
<head>
<title>Connect to Northwind_64 Bit SQL Server DSN</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
</head>
<body>
<%
//setup url (bridge-driver name + ODBC DSN), user, and password Strings
String dsn = “Northwind_64”;
String dbUrl = "jdbc:odbc:" + dsn;
String user = "";
String password = "";
Connection connection = null;
try
{
// try to load the JDBC-ODBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
out.print("About to try to connect to ODBC DSN: " + dbUrl + "<br /><br />");
//try to connect to database using the above Strings
connection = DriverManager.getConnection(dbUrl, user, password);
out.print("Connected to ODBC DSN: " + dbUrl + "<br /><br />");
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;​
//STEP 4: Execute a query
System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql;
sql = "SELECT ProductID, ProductName, UnitPrice FROM Employees";
ResultSet rs = stmt.executeQuery(sql);
//STEP 5: Extract data from result set
while(rs.next()){
//Retrieve by column name
int id = rs.getInt("UnitPrice");
int is = rs.getInt("ProductID");
String last = rs.getString("ProductName");
//Display values
System.out.print("ProductID: " + id);
System.out.print(", UnitePrice: " + is);
System.out.print(", ProductName: " + last);
}
//STEP 6: Clean-up environment
rs.close();
stmt.close();
conn.close();
}catch(SQLException se){
//Handle errors for JDBC
se.printStackTrace();
}catch(Exception e){
//Handle errors for Class.forName
e.printStackTrace();
}finally{
//finally block used to close resources
try{
if(stmt!=null)
stmt.close();
}catch(SQLException se2){
}// nothing we can do
try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}//end finally try
}//end try
System.out.println("Goodbye!");
}//end main
//end FirstExample​
%>
</body>
</html>
Member
Posts: 2,780
Joined: Dec 22 2008
Gold: 3,743.00
#13
Nov 16 2015 09:14pm
Quote (carteblanche @ Nov 17 2015 02:55am)
here's an example to get you started then.

http://www.tutorialspoint.com/jdbc/jdbc-sample-code.htm

Come back after you added it. if you still have an exception, include the relevant code and the exception.



Exception thrown by application class 'com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.translateJsp:568'
com.ibm.ws.jsp.JspCoreException: JSPG0049E: /Product.jsp failed to compile : JSPG0091E: An error occurred at line: 19 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 97 : “Northwind_64” cannot be resolved to a variable JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : void is an invalid type for the variable main JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : Syntax error on token "(", ; expected JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : Syntax error on token ")", ; expected JSPG0091E: An error occurred at line: 40 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 118 : ​ cannot be resolved to a type JSPG0091E: An error occurred at line: 43 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 121 : Syntax error on token ".", ; expected JSPG0091E: An error occurred at line: 66 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 144 : Syntax error, insert "}" to complete Block JSPG0091E: An error occurred at line: 75 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 153 : stmt cannot be resolved to a variable JSPG0091E: An error occurred at line: 76 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 154 : stmt cannot be resolved JSPG0091E: An error occurred at line: 80 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 158 : conn cannot be resolved to a variable JSPG0091E: An error occurred at line: 81 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 159 : conn cannot be resolved JSPG0091E: An error occurred at line: 87 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 165 : Syntax error on token "}", delete this token
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.translateJsp(AbstractJSPExtensionServletWrapper.java:568)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper._checkForTranslation(AbstractJSPExtensionServletWrapper.java:429)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.checkForTranslation(AbstractJSPExtensionServletWrapper.java:255)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.findWrapper(AbstractJSPExtensionProcessor.java:524)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.getServletWrapper(AbstractJSPExtensionProcessor.java:368)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:4469)
at [internal classes]
Exception thrown by application class 'com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.translateJsp:568'
com.ibm.ws.jsp.JspCoreException: JSPG0049E: /Product.jsp failed to compile : JSPG0091E: An error occurred at line: 19 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 97 : “Northwind_64” cannot be resolved to a variable JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : void is an invalid type for the variable main JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : Syntax error on token "(", ; expected JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : Syntax error on token ")", ; expected JSPG0091E: An error occurred at line: 40 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 118 : ​ cannot be resolved to a type JSPG0091E: An error occurred at line: 43 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 121 : Syntax error on token ".", ; expected JSPG0091E: An error occurred at line: 66 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 144 : Syntax error, insert "}" to complete Block JSPG0091E: An error occurred at line: 75 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 153 : stmt cannot be resolved to a variable JSPG0091E: An error occurred at line: 76 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 154 : stmt cannot be resolved JSPG0091E: An error occurred at line: 80 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 158 : conn cannot be resolved to a variable JSPG0091E: An error occurred at line: 81 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 159 : conn cannot be resolved JSPG0091E: An error occurred at line: 87 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 165 : Syntax error on token "}", delete this token
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.translateJsp(AbstractJSPExtensionServletWrapper.java:568)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper._checkForTranslation(AbstractJSPExtensionServletWrapper.java:429)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.checkForTranslation(AbstractJSPExtensionServletWrapper.java:255)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.findWrapper(AbstractJSPExtensionProcessor.java:524)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.getServletWrapper(AbstractJSPExtensionProcessor.java:368)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:986)
at [internal classes]
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
#14
Nov 16 2015 09:16pm
Quote (bizzy1999 @ Nov 16 2015 10:14pm)
Exception thrown by application class 'com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.translateJsp:568'
com.ibm.ws.jsp.JspCoreException: JSPG0049E: /Product.jsp failed to compile : JSPG0091E: An error occurred at line: 19 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 97 : “Northwind_64” cannot be resolved to a variable JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : void is an invalid type for the variable main JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : Syntax error on token "(", ; expected JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : Syntax error on token ")", ; expected JSPG0091E: An error occurred at line: 40 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 118 : ​ cannot be resolved to a type JSPG0091E: An error occurred at line: 43 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 121 : Syntax error on token ".", ; expected JSPG0091E: An error occurred at line: 66 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 144 : Syntax error, insert "}" to complete Block JSPG0091E: An error occurred at line: 75 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 153 : stmt cannot be resolved to a variable JSPG0091E: An error occurred at line: 76 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 154 : stmt cannot be resolved JSPG0091E: An error occurred at line: 80 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 158 : conn cannot be resolved to a variable JSPG0091E: An error occurred at line: 81 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 159 : conn cannot be resolved JSPG0091E: An error occurred at line: 87 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 165 : Syntax error on token "}", delete this token
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.translateJsp(AbstractJSPExtensionServletWrapper.java:568)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper._checkForTranslation(AbstractJSPExtensionServletWrapper.java:429)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.checkForTranslation(AbstractJSPExtensionServletWrapper.java:255)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.findWrapper(AbstractJSPExtensionProcessor.java:524)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.getServletWrapper(AbstractJSPExtensionProcessor.java:368)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:4469)
at [internal classes]
Exception thrown by application class 'com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.translateJsp:568'
com.ibm.ws.jsp.JspCoreException: JSPG0049E: /Product.jsp failed to compile : JSPG0091E: An error occurred at line: 19 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 97 : “Northwind_64” cannot be resolved to a variable JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : void is an invalid type for the variable main JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : Syntax error on token "(", ; expected JSPG0091E: An error occurred at line: 38 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 116 : Syntax error on token ")", ; expected JSPG0091E: An error occurred at line: 40 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 118 : ​ cannot be resolved to a type JSPG0091E: An error occurred at line: 43 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 121 : Syntax error on token ".", ; expected JSPG0091E: An error occurred at line: 66 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 144 : Syntax error, insert "}" to complete Block JSPG0091E: An error occurred at line: 75 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 153 : stmt cannot be resolved to a variable JSPG0091E: An error occurred at line: 76 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 154 : stmt cannot be resolved JSPG0091E: An error occurred at line: 80 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 158 : conn cannot be resolved to a variable JSPG0091E: An error occurred at line: 81 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 159 : conn cannot be resolved JSPG0091E: An error occurred at line: 87 in the file: /Product.jsp JSPG0093E: Generated servlet error from file: /Product.jsp C:\Users\cory.harmeier\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.etools.wdt.server.core\tmp0\usr\servers\defaultServer0\workarea\org.eclipse.osgi\bundles\53\data\temp\default_node\SMF_WebContainer\CIS249_Exercises\CIS249_Exercises\_Product.java : 165 : Syntax error on token "}", delete this token
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.translateJsp(AbstractJSPExtensionServletWrapper.java:568)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper._checkForTranslation(AbstractJSPExtensionServletWrapper.java:429)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.checkForTranslation(AbstractJSPExtensionServletWrapper.java:255)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.findWrapper(AbstractJSPExtensionProcessor.java:524)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.getServletWrapper(AbstractJSPExtensionProcessor.java:368)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:986)
at [internal classes]


your shit isn't compiling. move your code out of the html if that helps you figure out how to compile it.

if you look at your first error here:
Quote
“Northwind_64” cannot be resolved to a variable

you can see you have schmart quotes around it. fix it

This post was edited by carteblanche on Nov 16 2015 09:17pm
Member
Posts: 2,780
Joined: Dec 22 2008
Gold: 3,743.00
#15
Nov 16 2015 09:22pm
Quote (carteblanche @ Nov 17 2015 03:16am)
your shit isn't compiling. move your code out of the html if that helps you figure out how to compile it.

if you look at your first error here:

you can see you have schmart quotes around it. fix it


It has to be in jsp format. and I fixed the smart quotes Idk why they were like that.

This post was edited by bizzy1999 on Nov 16 2015 09:22pm
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
#16
Nov 16 2015 09:27pm
Quote (bizzy1999 @ Nov 16 2015 10:22pm)
It has to be in jsp format. and I fixed the smart quotes Idk why they were like that.


i dont care what the final format has to be in, and neither should you. if your code doesn't compile, then you got bigger problems to worry about. put it in a .java file and make sure it compiles and executes and gives the results you want. after it does what you want, then integrate it with the html. you're not gonna make any progress with the jsp if your java isn't compiling. i am not your compiler nor do i have interest in running your code. i can offer help but i'm not doing everything for you. you need to help yourself.

This post was edited by carteblanche on Nov 16 2015 09:28pm
Member
Posts: 2,780
Joined: Dec 22 2008
Gold: 3,743.00
#17
Nov 16 2015 09:30pm
okay.

This post was edited by bizzy1999 on Nov 16 2015 09:34pm
Member
Posts: 2,780
Joined: Dec 22 2008
Gold: 3,743.00
#18
Nov 16 2015 09:31pm
Quote (carteblanche @ Nov 17 2015 03:27am)
i dont care what the final format has to be in, and neither should you. if your code doesn't compile, then you got bigger problems to worry about. put it in a .java file and make sure it compiles and executes and gives the results you want. after it does what you want, then integrate it with the html. you're not gonna make any progress with the jsp if your java isn't compiling. i am not your compiler nor do i have interest in running your code. i can offer help but i'm not doing everything for you. you need to help yourself.


thx bud very good help
Member
Posts: 2,780
Joined: Dec 22 2008
Gold: 3,743.00
#19
Nov 16 2015 09:46pm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
　
<%@page
language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.*"%>
<html>
<head>
<title>Connect to Northwind_64 Bit SQL Server DSN</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
</head>
<body>
<%
//setup url (bridge-driver name + ODBC DSN), user, and password Strings
String dsn = "Northwind_64";
String dbUrl = "jdbc:odbc:" + dsn;
String user = "";
String password = "";
Connection connection = null;
try
{
// try to load the JDBC-ODBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
out.print("About to try to connect to ODBC DSN: " + dbUrl + "<br /><br />");
//try to connect to database using the above Strings
connection = DriverManager.getConnection(dbUrl, user, password);
out.print("Connected to ODBC DSN: " + dbUrl + "<br /><br />");
}
catch(Exception e)
{
out.print("Could Not Connect to ODBC DSN: " + dbUrl + "<br /><br />" + e.toString());
}

EXCEPTION BEING THROWN RIGHT HERE, SAYING DELETE THIS SYNTAX BUT THERE IS NOTHING TO DELETE!!!!
​
//STEP 4: Execute a query
System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql;
sql = "SELECT ProductID, ProductName, UnitPrice FROM Employees";
ResultSet rs = stmt.executeQuery(sql);
//STEP 5: Extract data from result set
while(rs.next()){
//Retrieve by column name
int id = rs.getInt("UnitPrice");
int is = rs.getInt("ProductID");
String last = rs.getString("ProductName");
//Display values
System.out.print("ProductID: " + id);
System.out.print(", UnitePrice: " + is);
System.out.print(", ProductName: " + last);
}
%>
　
</body>
</html>

This post was edited by bizzy1999 on Nov 16 2015 09:49pm
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
#20
Nov 16 2015 09:57pm
remove all your code and see if it compiles. if it does, then slowly add blocks of code back in until it no longer compiles. that should help you find/understand the compilation error.

i'll check back on this thread tomorrow night after work.

/edit: your variables are wrong. read your compile errors.

This post was edited by carteblanche on Nov 16 2015 10:12pm
Go Back To Programming & Development Topic List
Prev123Next
Add Reply New Topic New Poll

© 2003-2026 d2jsp  Contact