[jboss-user] [Tomcat, HTTPD, Servlets & JSP] - portlet JSP JDBC problem
thatporguy
do-not-reply at jboss.com
Mon Aug 14 15:13:24 EDT 2006
Alright guys, I'm trying to create a JDBC connection (or jndi) connection to a mysql database, and for some reason i think hibernate is not letting me. I can create a jsp on tomcat and it works there but not on jboss.
here is the code
public String getDB(){
| String data = "";
|
| try{
| InitialContext ctx = new InitialContext();
| DataSource ds = (DataSource)ctx.lookup("mysqlDS");
| Connection conn = ds.getConnection();
| Statement statement = conn.createStatement();
| ResultSet rs = statement.executeQuery("SELECT * FROM test");
|
|
| try {
| while (rs.next()) {
| data += rs.getString("id") + " <br>";
|
| }
| } catch (Exception e) {
| // TODO Auto-generated catch block
| e.printStackTrace();
| }
|
| conn.close();
|
| }catch(Exception s){
|
| s.printStackTrace();
| }
|
| return data;
| }
Here is the DS file:
(note i removed the username and password when posting)
Pardon the junk code, but I'm just trying to get it working at the moment. <?xml version="1.0" encoding="UTF-8" ?>
- <!-- $Id: mysql-ds.xml,v 1.3.2.3 2006/02/07 14:23:00 acoliver Exp $
-->
- <!-- Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->
-
- <local-tx-datasource>
<jndi-name>mysqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jbossportal</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>****</user-name>
****
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
- <!-- should only be used on drivers after 3.22.1 with "ping" support
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
-->
- <!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
- <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->
- <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional)
-->
-
<type-mapping>mySQL</type-mapping>
</local-tx-datasource>
Now, When i tried this with a JDBC connection it simply said that it was a null pointer, but this returns nothing.
Here is the log output:
| 2006-08-14 14:56:26,183 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4733262996205589
| 2006-08-14 14:56:26,183 DEBUG [org.hibernate.cache.StandardQueryCache] checking cached query results in region: org.hibernate.cache.StandardQueryCache
| 2006-08-14 14:56:26,183 DEBUG [org.hibernate.cache.EhCache] key: sql: select 1 as col_0_0_ from jbp_cms_wsp_prop wspprop0_ where PROP_ID=?; parameters: 8b53c74f-878f-4f36-831f-83d61aaa9d24/{http://jboss.org/jcr/portalcms}language, ; named parameters: {}
| 2006-08-14 14:56:26,183 DEBUG [org.hibernate.cache.StandardQueryCache] Checking query spaces for up-to-dateness: [jbp_cms_wsp_prop]
| 2006-08-14 14:56:26,183 DEBUG [org.hibernate.cache.EhCache] key: jbp_cms_wsp_prop
| 2006-08-14 14:56:26,183 DEBUG [org.hibernate.cache.EhCache] Element for jbp_cms_wsp_prop is null
| 2006-08-14 14:56:26,183 DEBUG [org.hibernate.cache.StandardQueryCache] returning cached query results
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.jdbc.JDBCContext] successfully registered Synchronization
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4733262996271104
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.transaction.JTATransaction] Looking for UserTransaction under: UserTransaction
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.transaction.JTATransaction] Obtained UserTransaction
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.transaction.JTATransaction] begin
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.transaction.JTATransaction] commit
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.jdbc.JDBCContext] successfully registered Synchronization
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4733262996271105
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.transaction.JTATransaction] Looking for UserTransaction under: UserTransaction
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.transaction.JTATransaction] Obtained UserTransaction
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.transaction.JTATransaction] begin
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.transaction.JTATransaction] commit
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.engine.Collections] Collection found: [org.jboss.portal.identity.db.UserImpl.dynamic#1], was: [org.jboss.portal.identity.db.UserImpl.dynamic#1] (initialized)
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.engine.Collections] Collection found: [org.jboss.portal.identity.db.UserImpl.roles#1], was: [org.jboss.portal.identity.db.UserImpl.roles#1] (initialized)
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 2 collections
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.pretty.Printer] listing entities:
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.pretty.Printer] org.jboss.portal.identity.db.UserImpl{password=21232f297a57a5a743894a0e4a801fc3, dynamic=[1155580527652], key=1, userName=admin, enabled=true, registrationDate=2006-08-09 16:13:52, realEmail=admin at portal.com, viewRealEmail=true, fakeEmail=null, roles=[org.jboss.portal.identity.db.RoleImpl#1], givenName=null, familyName=null}
| 2006-08-14 14:56:26,199 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
|
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3965089#3965089
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3965089
More information about the jboss-user
mailing list