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, [EMAIL PROTECTED], 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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
