[Installation, Configuration & DEPLOYMENT] - SQLException
by jotnarta
Hi All
I posted my problem in all Java and J2EE forums, I hope I can find a solution here. I am trying to test DataSource in JBoss; so, I defined the mysql-ds.xml file:
|
|
| <?xml version="1.0" encoding="UTF-8"?>
|
| <datasources>
|
| <local-tx-datasource>
|
| <jndi-name>DefaultDS</jndi-name>
|
| <connection-url>jdbc:mysql://localhost:3306/project</connection-url>
|
| <driver-class>com.mysql.jdbc.Driver</driver-class>
|
| <user-name>root</user-name>
|
| <password>admin</password>
|
| <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
|
| <metadata>
|
| <type-mapping>mySQL</type-mapping>
|
| </metadata>
|
| </local-tx-datasource>
|
| </datasources>
|
and this is my jsp file:
| <%@page import="java.util.*,javax.naming.*,javax.sql.DataSource,java.sql.*"%>
| <%
| DataSource ds = null;
| Connection con = null;
| //Statement st = null;
| InitialContext ic;
|
| try {
| ic = new InitialContext();
| ds = (DataSource) ic.lookup("java:/DefaultDS");
| con = ds.getConnection();
| Statement st = con.createStatement();
| ResultSet rs = st.executeQuery("select * from quest_choices;");
|
| while(rs.next()) {
| out.println("<br> " + rs.getString("ID"));
| }
| rs.close();
| st.close();
|
| out.println("DONE");
| } catch (Exception e) {
| out.println("Exception thrown " + e );
| //e.printStackTrace();
| } finally {
| if (con != null) {
| con.close();
| }
| }
| %>
|
I got the following error:
Exception thrown java.sql.SQLException: Table not found in statement [select * from quest_choices]
Any help pleeeeeeeeeeeeeeeease????
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4210456#4210456
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4210456
17 years, 2 months
[Beginners Corner] - Re: SQLException
by jotnarta
Thank you Peter. I removed the file called hsql-db.xml, I changed my mysql-db.xml datasource to be MyDB, and I changed my jsp file.
mysql-ds.xml file:
| <?xml version="1.0" encoding="UTF-8"?>
|
| <datasources>
|
| <local-tx-datasource>
|
| <jndi-name>MyDB</jndi-name>
|
| <connection-url>jdbc:mysql://localhost:3306/project</connection-url>
|
| <driver-class>com.mysql.jdbc.Driver</driver-class>
|
| <user-name>root</user-name>
|
| <password>admin</password>
|
| <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
|
| <metadata>
|
| <type-mapping>mySQL</type-mapping>
|
| </metadata>
|
| </local-tx-datasource>
|
| </datasources>
|
I changed my jsp file to be:
| try {
| ic = new InitialContext();
| ds = (DataSource) ic.lookup("java:/MyDB");
| con = ds.getConnection();
| Statement st = con.createStatement();
| ResultSet rs = st.executeQuery("select * quest_chices");
|
| while(rs.next()) {
| out.println("<br> " + rs.getString("ID"));
| }
| rs.close();
| st.close();
|
| out.println("DONE");
| } catch (Exception e) {
| out.println("Exception thrown " + e );
| //e.printStackTrace();
| } finally {
| if (con != null) {
| con.close();
| }
| }
|
and guess what?? When I run the jsp file i got Exception thrown javax.naming.NameNotFoundException: MyDB not bound ...
What i noticed here, is that when I change my datasource other than DefaultDS, I'll get NameNotFoundException>>>>
Any help please??
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4210420#4210420
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4210420
17 years, 2 months