Re: JSP/JDBC question
Looks like you put a statement intended for preparation into a regular statement. [EMAIL PROTECTED] 01-19-2005 18:23 I'm getting the following error when my JSP form POSTs: 17:15:23,500 INFO [STDOUT] -SQLException- 17:15:23,500 INFO [STDOUT] SQLState: 42000 17:15:23,500 INFO [STDOUT] Message: Syntax error or access violation message from server: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, Subscriber = ?, RenewalDate = ?, SubscriptionExpired = ?, Cuisine = ?, ChefsN' at line 1 17:15:23,500 INFO [STDOUT] Vendor: 1064 17:15:23,500 INFO [STDOUT] access: on I'm running eclipse 3.0.1 and MySQL on the same machine. Is there a way to display the exact contents of the POST that the form submits? I've tried using TcpMon from the Axis project but can't get anything to show up. Thanks, Jack - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
JSP/JDBC question
I'm getting the following error when my JSP form POSTs: 17:15:23,500 INFO [STDOUT] -SQLException- 17:15:23,500 INFO [STDOUT] SQLState: 42000 17:15:23,500 INFO [STDOUT] Message: Syntax error or access violation message from server: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, Subscriber = ?, RenewalDate = ?, SubscriptionExpired = ?, Cuisine = ?, ChefsN' at line 1 17:15:23,500 INFO [STDOUT] Vendor: 1064 17:15:23,500 INFO [STDOUT] access: on I'm running eclipse 3.0.1 and MySQL on the same machine. Is there a way to display the exact contents of the POST that the form submits? I've tried using TcpMon from the Axis project but can't get anything to show up. Thanks, Jack - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
JNDI JDBC Question
I have a Class Not Found Exception error I am not certain how to fix. I have a file called jt400.jar in my CATALINA_HOME/common/lib . My servlets access the classes in this jar with no problem. One of the classes in this jar is my JDBC Driver class. Again it works fine from a servlet making direct connections using this driver. However when trying to use the connect pooling, this same driver can not be accessed by the JNDI services. My servlet gets the error Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver()' , but tomcat's stdout records that the real problem is: Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver()' java.lang.ClassNotFoundException: com/ibm/as400/access/AS400JDBCDriver() at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:140) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:523) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:312) at org.apache.jsp.jsp.JDBCTest2_jsp. _jspService(JDBCTest2_jsp.java:56) Why can my servlets find the driver, but the connection pool cannot? -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
Re: JNDI JDBC Question
Are you writing the driver class name this way: 'com.ibm.as400.access.AS400JDBCDriver()'? when you configure the BasicDataSource...? I think the problem may be that you must not use the '()' at the end of the class name. --- Brian Kautz [EMAIL PROTECTED] wrote: I have a Class Not Found Exception error I am not certain how to fix. I have a file called jt400.jar in my CATALINA_HOME/common/lib . My servlets access the classes in this jar with no problem. One of the classes in this jar is my JDBC Driver class. Again it works fine from a servlet making direct connections using this driver. However when trying to use the connect pooling, this same driver can not be accessed by the JNDI services. My servlet gets the error Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver()' , but tomcat's stdout records that the real problem is: Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver()' java.lang.ClassNotFoundException: com/ibm/as400/access/AS400JDBCDriver() at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:140) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:523) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:312) at org.apache.jsp.jsp.JDBCTest2_jsp. _jspService(JDBCTest2_jsp.java:56) Why can my servlets find the driver, but the connection pool cannot? -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
Re: JNDI JDBC Question
I've been staring at this for two weeks and didn't see that. Thanks for the spare set of eyes. That's it. |-+--- | | Ricardo Moral | | | ricardo_moral@y| | | ahoo.com | | | | | | 11/05/2002 09:41| | | AM | | | Please respond | | | to Tomcat Users| | | List | | | | |-+--- ---| | | |To: Tomcat Users List [EMAIL PROTECTED] | |cc: | |Subject: Re: JNDI JDBC Question | ---| Are you writing the driver class name this way: 'com.ibm.as400.access.AS400JDBCDriver()'? when you configure the BasicDataSource...? I think the problem may be that you must not use the '()' at the end of the class name. --- Brian Kautz [EMAIL PROTECTED] wrote: I have a Class Not Found Exception error I am not certain how to fix. I have a file called jt400.jar in my CATALINA_HOME/common/lib . My servlets access the classes in this jar with no problem. One of the classes in this jar is my JDBC Driver class. Again it works fine from a servlet making direct connections using this driver. However when trying to use the connect pooling, this same driver can not be accessed by the JNDI services. My servlet gets the error Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver()' , but tomcat's stdout records that the real problem is: Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver()' java.lang.ClassNotFoundException: com/ibm/as400/access/AS400JDBCDriver() at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:140) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:523) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:312) at org.apache.jsp.jsp.JDBCTest2_jsp. _jspService(JDBCTest2_jsp.java:56) Why can my servlets find the driver, but the connection pool cannot? -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
RE: JDBC question
is that one method really named "deGet" ??
-Original Message-
From: Bo Wang [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:15 PM
To: [EMAIL PROTECTED]
Subject: Re: JDBC question
Thanks for your help, here attached my servlet.
I'm using win98 with Access 97, and set up a system DSN "Northwind" without
userID and password.
After I run this servlet, I got NullPointException.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JDBCServlet extends HttpServlet
{
Connection dbConn;
public void init ( ServletConfig config ) throws ServletException
{
super.init( config );
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
dbConn = DriverManager.getConnection( "jdbc:odbc:Northwind" );
}
catch ( ClassNotFoundException e )
{
System.out.println( "*JDBC-ODBC bridge not found" );
return;
}
catch ( SQLException e )
{
System.out.println( "*SQL exception thrown in init" );
return;
}
}
public void deGet( HttpServletRequest req, HttpServletResponse resp )
throws ServletException, IOException
{
try
{
resp.setContentType( "text/html" );
PrintWriter out = resp.getWriter();
Statement stat = dbConn.createStatement();
ResultSet customers = stat.executeQuery( "select CustomerID,
CompanyName, City, Country from " + "Customers" );
out.println( "html" );
out.println( "headtitleCustomer List/title/head" );
out.println( "body" );
out.println( "h2Customer List/h2" );
out.println( "table border=1" );
out.println( "trthCustomer ID/th" );
out.println( "thCompany Name/th" );
out.println( "thCity/th" );
out.println( "thCountry/th/tr" );
while ( customers.next() )
{
out.println( "tr" );
out.println( "td" + customers.getString( "CustomerID" ) +
"/td" );
out.println( "td" + customers.getString( "CompanyName" ) +
"/td" );
out.println( "td" + customers.getString( "City" ) +
"/td" );
out.println( "td" + customers.getString( "Country" ) +
"/td" );
out.println( "/tr" );
}
out.println( "/table" );
out.println( "/body/html" );
customers.close();
stat.close();
dbConn.close();
}
catch ( Exception e )
{
e.printStackTrace();
}
}
}
- Original Message -
From: "RameshBabu R Muthuvel" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 12:25 PM
Subject: Re: JDBC question
Hi
There are numerous issues.
Some are:
1) either ur dsn is not there
2) Your tables datatype doesn't match with the value passed or accessed
from
servlet etc...
send ur servlet, to find out what really happens
ramesh
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: JDBC question
I believe that's supposed to be doGet.
-Original Message-
From: Jann VanOver [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Wednesday, April 18, 2001 2:40 PM
Subject: RE: JDBC question
is that one method really named "deGet" ??
-Original Message-
From: Bo Wang [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:15 PM
To: [EMAIL PROTECTED]
Subject: Re: JDBC question
Thanks for your help, here attached my servlet.
I'm using win98 with Access 97, and set up a system DSN "Northwind" without
userID and password.
After I run this servlet, I got NullPointException.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JDBCServlet extends HttpServlet
{
Connection dbConn;
public void init ( ServletConfig config ) throws ServletException
{
super.init( config );
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
dbConn = DriverManager.getConnection( "jdbc:odbc:Northwind" );
}
catch ( ClassNotFoundException e )
{
System.out.println( "*JDBC-ODBC bridge not found" );
return;
}
catch ( SQLException e )
{
System.out.println( "*SQL exception thrown in init" );
return;
}
}
public void deGet( HttpServletRequest req, HttpServletResponse resp )
throws ServletException, IOException
{
try
{
resp.setContentType( "text/html" );
PrintWriter out = resp.getWriter();
Statement stat = dbConn.createStatement();
ResultSet customers = stat.executeQuery( "select CustomerID,
CompanyName, City, Country from " + "Customers" );
out.println( "html" );
out.println( "headtitleCustomer List/title/head" );
out.println( "body" );
out.println( "h2Customer List/h2" );
out.println( "table border=1" );
out.println( "trthCustomer ID/th" );
out.println( "thCompany Name/th" );
out.println( "thCity/th" );
out.println( "thCountry/th/tr" );
while ( customers.next() )
{
out.println( "tr" );
out.println( "td" + customers.getString( "CustomerID" ) +
"/td" );
out.println( "td" + customers.getString( "CompanyName" )
+
"/td" );
out.println( "td" + customers.getString( "City" ) +
"/td" );
out.println( "td" + customers.getString( "Country" ) +
"/td" );
out.println( "/tr" );
}
out.println( "/table" );
out.println( "/body/html" );
customers.close();
stat.close();
dbConn.close();
}
catch ( Exception e )
{
e.printStackTrace();
}
}
}
- Original Message -
From: "RameshBabu R Muthuvel" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 12:25 PM
Subject: Re: JDBC question
Hi
There are numerous issues.
Some are:
1) either ur dsn is not there
2) Your tables datatype doesn't match with the value passed or accessed
from
servlet etc...
send ur servlet, to find out what really happens
ramesh
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: JDBC question
Hi There are numerous issues. Some are: 1) either ur dsn is not there 2) Your tables datatype doesn't match with the value passed or accessed from servlet etc... send ur servlet, to find out what really happens ramesh _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: JDBC question
Thanks for your help, here attached my servlet.
I'm using win98 with Access 97, and set up a system DSN "Northwind" without
userID and password.
After I run this servlet, I got NullPointException.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JDBCServlet extends HttpServlet
{
Connection dbConn;
public void init ( ServletConfig config ) throws ServletException
{
super.init( config );
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
dbConn = DriverManager.getConnection( "jdbc:odbc:Northwind" );
}
catch ( ClassNotFoundException e )
{
System.out.println( "*JDBC-ODBC bridge not found" );
return;
}
catch ( SQLException e )
{
System.out.println( "*SQL exception thrown in init" );
return;
}
}
public void deGet( HttpServletRequest req, HttpServletResponse resp )
throws ServletException, IOException
{
try
{
resp.setContentType( "text/html" );
PrintWriter out = resp.getWriter();
Statement stat = dbConn.createStatement();
ResultSet customers = stat.executeQuery( "select CustomerID,
CompanyName, City, Country from " + "Customers" );
out.println( "html" );
out.println( "headtitleCustomer List/title/head" );
out.println( "body" );
out.println( "h2Customer List/h2" );
out.println( "table border=1" );
out.println( "trthCustomer ID/th" );
out.println( "thCompany Name/th" );
out.println( "thCity/th" );
out.println( "thCountry/th/tr" );
while ( customers.next() )
{
out.println( "tr" );
out.println( "td" + customers.getString( "CustomerID" ) +
"/td" );
out.println( "td" + customers.getString( "CompanyName" ) +
"/td" );
out.println( "td" + customers.getString( "City" ) +
"/td" );
out.println( "td" + customers.getString( "Country" ) +
"/td" );
out.println( "/tr" );
}
out.println( "/table" );
out.println( "/body/html" );
customers.close();
stat.close();
dbConn.close();
}
catch ( Exception e )
{
e.printStackTrace();
}
}
}
- Original Message -
From: "RameshBabu R Muthuvel" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 12:25 PM
Subject: Re: JDBC question
Hi
There are numerous issues.
Some are:
1) either ur dsn is not there
2) Your tables datatype doesn't match with the value passed or accessed
from
servlet etc...
send ur servlet, to find out what really happens
ramesh
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
RE: JDBC question
Hello,
Are you getting any HTML output at all? Try to leave more messages to see
where it is breaking down.
Try
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ).newInstance();
This "newInstance()" is often necessary.
I don't use access so I don't know about the drivers or URL.
It looks like everything is there.
Good Luck,
Craig
-Original Message-
From: Bo Wang [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:15 PM
To: [EMAIL PROTECTED]
Subject: Re: JDBC question
Thanks for your help, here attached my servlet.
I'm using win98 with Access 97, and set up a system DSN "Northwind" without
userID and password.
After I run this servlet, I got NullPointException.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JDBCServlet extends HttpServlet
{
Connection dbConn;
public void init ( ServletConfig config ) throws ServletException
{
super.init( config );
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
dbConn = DriverManager.getConnection( "jdbc:odbc:Northwind" );
}
catch ( ClassNotFoundException e )
{
System.out.println( "*JDBC-ODBC bridge not found" );
return;
}
catch ( SQLException e )
{
System.out.println( "*SQL exception thrown in init" );
return;
}
}
public void deGet( HttpServletRequest req, HttpServletResponse resp )
throws ServletException, IOException
{
try
{
resp.setContentType( "text/html" );
PrintWriter out = resp.getWriter();
Statement stat = dbConn.createStatement();
ResultSet customers = stat.executeQuery( "select CustomerID,
CompanyName, City, Country from " + "Customers" );
out.println( "html" );
out.println( "headtitleCustomer List/title/head" );
out.println( "body" );
out.println( "h2Customer List/h2" );
out.println( "table border=1" );
out.println( "trthCustomer ID/th" );
out.println( "thCompany Name/th" );
out.println( "thCity/th" );
out.println( "thCountry/th/tr" );
while ( customers.next() )
{
out.println( "tr" );
out.println( "td" + customers.getString( "CustomerID" ) +
"/td" );
out.println( "td" + customers.getString( "CompanyName" ) +
"/td" );
out.println( "td" + customers.getString( "City" ) +
"/td" );
out.println( "td" + customers.getString( "Country" ) +
"/td" );
out.println( "/tr" );
}
out.println( "/table" );
out.println( "/body/html" );
customers.close();
stat.close();
dbConn.close();
}
catch ( Exception e )
{
e.printStackTrace();
}
}
}
- Original Message -
From: "RameshBabu R Muthuvel" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 12:25 PM
Subject: Re: JDBC question
Hi
There are numerous issues.
Some are:
1) either ur dsn is not there
2) Your tables datatype doesn't match with the value passed or accessed
from
servlet etc...
send ur servlet, to find out what really happens
ramesh
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
JDBC question
Hi, all, I wrote a JDBC servlet follow an example from a servlet book, which calls an MS Access database, but when I run it, I got the following error message: java.lang.NullPointerException at java.lang.ClassLoader.resolveClass0(Native Method) at java.lang.ClassLoader.resolveClass(ClassLoader.java:588) at org.apache.tomcat.loader.AdaptiveClassLoader.loadClass(AdaptiveClassLoader.j ava:430) at org.apache.tomcat.loader.AdaptiveServletLoader.loadClass(AdaptiveServletLoad er.java:174) at org.apache.tomcat.core.ServletWrapper.loadServlet(ServletWrapper.java:265) at org.apache.tomcat.core.ServletWrapper.init(ServletWrapper.java:289) at org.apache.tomcat.core.Handler.service(Handler.java:254) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79 7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Thread.java:484) Does anybody has an idea what I did wrong? Thanks in advance. Bo
servlet-jdbc question
Hi, Not sure this message got through the first time. I'm new to tomcat/apache and servlets in general. - Installed fine (both tomcat and mysql) - I've been able to add examples servlets. - Ported jdbc application to use mysql and all works fine. - Ported a generic dbexport (jdbc application) to a HttpServlet and no go. - Added the appropriate CLASSPATH's to various scripts. - Nope still doesn't work - Added (and updated) the server.xml file to include mysql stuff. - Nope, not yet. I get this error: "HTTP Status 500 - /examples/servlet/httpdbexport The server encountered an internal error (/examples/servlet/httpdbexport) that prevented it from fulfilling this request. " Any ideas? thanks, Kerry -- Kerry M Finn Sun Microsystems Inc 1 Network Drive Burlington, Ma. 01803 [EMAIL PROTECTED] Work Email 781-442-0408Work Phone [EMAIL PROTECTED] SMS Messaging 781-492-1051Cell Phone - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
Re: servlet-jdbc question
Randy Layman wrote: Question 1: Does it work in just Tomcat, without Apache? I'm only running Tomcat (catalina 4.0 - needed to support http1.1). Question 2: Do you see anything relevant in your log files? Here is the most relevant message: 2001-01-25 11:42:48 StandardWrapper[/examples:org.apache.catalina.INVOKER.httpdbexport]: Marking servlet org.apache.catalina.INVOKER.httpdbexport as unavailable 2001-01-25 11:42:48 invoker: serveRequest.load javax.servlet.ServletException: Error instantiating servlet class httpdbexport When I've added similar apps (without JDBC) to the examples directory they worked fine. Seems like there's some type of intialization error when loading the class. This app works as stand alone (with main). -Original Message- From: kerry finn [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 11:26 AM To: [EMAIL PROTECTED] Subject: servlet-jdbc question Hi, Not sure this message got through the first time. I'm new to tomcat/apache and servlets in general. - Installed fine (both tomcat and mysql) - I've been able to add examples servlets. - Ported jdbc application to use mysql and all works fine. - Ported a generic dbexport (jdbc application) to a HttpServlet and no go. - Added the appropriate CLASSPATH's to various scripts. - Nope still doesn't work - Added (and updated) the server.xml file to include mysql stuff. - Nope, not yet. I get this error: "HTTP Status 500 - /examples/servlet/httpdbexport The server encountered an internal error (/examples/servlet/httpdbexport) that prevented it from fulfilling this request. " Any ideas? thanks, Kerry -- Kerry M Finn Sun Microsystems Inc 1 Network Drive Burlington, Ma. 01803 [EMAIL PROTECTED] Work Email 781-442-0408Work Phone [EMAIL PROTECTED] SMS Messaging 781-492-1051Cell Phone - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
