portal-mysql-ds - Pentaho Community Forums

aquahellishSoftware and s/w Development

Dec 13, 2013 (3 years and 6 months ago)

83 views

portal
-
mysql
-
ds.xml


<?xml version="1.0" encoding="UTF
-
8"?>

<datasources>


<local
-
tx
-
datasource>


<jndi
-
name>PortalDS</jndi
-
name>


<connection
-
url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false</connection
-
url>


<driver
-
c
lass>org.gjt.mm.mysql.Driver</driver
-
class>


<user
-
name>portal</user
-
name>


<password>portalpassword</password>


</local
-
tx
-
datasource>


<no
-
tx
-
datasource>


<jndi
-
name>NoTxPortalDS</jndi
-
name>


<connection
-
url>jdbc:mysql://localhost
:3306/jbossportal?useServerPrepStmts=false</connection
-
url>


<driver
-
class>org.gjt.mm.mysql.Driver</driver
-
class>


<user
-
name>portal</user
-
name>


<password>portalpassword</password>


</no
-
tx
-
datasource>

</datasources>



hibernate.cfg.xml


<?xml version='1.0' encoding='utf
-
8'?>

<!DOCTYPE hibernate
-
configuration PUBLIC


"
-
//Hibernate/Hibernate Configuration DTD//EN"


"http://hibernate.sourceforge.net/hibernate
-
configuration
-
3.0.dtd">

<hibernate
-
configuration>


<session
-
factory


n
ame="java:portal/SessionFactory">


<property name="connection.datasource">java:PortalDS</property>



<property name="show_sql">false</property>



<!
--

Force the dialect instead of using autodetection
--
>


<!
--


<property name="dialect"
>org.hibernate.dialect.PostgreSQLDialect</property>


--
>


<!
--

changed this!!!!!

<property

name="dialect">org.hibernate.dialect.HSQLDialect</property>
--
>



<property name="dialect">org.hibernate.dialect.MySQLDialect</property>




<!
--

Mapping f
iles
--
>


<mapping resource="org/jboss/portal/core/impl/role/RoleImpl.hbm.xml"/>


<mapping resource="org/jboss/portal/core/impl/user/UserImpl.hbm.xml"/>


<mapping resource="org/jboss/portal/core/impl/user/UserPref.hbm.xml"/>


<mapping r
esource="org/jboss/portal/core/impl/user/UserPrefSet.hbm.xml"/>


</session
-
factory>

</hibernate
-
configuration>