JBossDeveloper

sorry, i'm a french speaker.

j'ai rencontré le même problème ce matin et j'ai finalement pu le résoudre.
assurez vous que le fichier portal-*-ds.xml contient la bonne chaine de connexion à votre base de données. j'utilise jboss-4.0.2 et jboss-portal-2.0.2RC1.
Ma base est une base oracle(jbossportal) installée sur un serveur qui se nomme luanda, et j me connecte avec l'user portal/sinti
Le contenu de mon fichier portal-oracle-ds.xml est le suivant:

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

<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:oracle:thin:@luanda:1521:jbossportal</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>portal</user-name>
sinti
</local-tx-datasource>
<no-tx-datasource>
<jndi-name>NoTxPortalDS</jndi-name>
<connection-url>jdbc:oracle:thin:@luanda:1521:jbossportal</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>portal</user-name>
sinti
</no-tx-datasource>

il y a les balises password autour du mot de passe qui n s'affichent pas ds l message, mais el doivent effectivement figurer ds l fichier

i've been trying for 2 days to get this thing working to show my bosses that it is a good alternative to the current portal, but no luck. I've tried every combination of java->jboss->mysql->portal files to no luck. My error is the same as the original posters. I'm running SUSE 9.3, JDK 5.0, Mysql 4.1.10, Application Server 4.0.3sp1 (this time), and connector 3.1. I notice that the tables are created and populated, then farther down in the init (perhaps the hibernate portion) it says "cannot find jbossportal.XXXXX". The tables are there! Any help greatly appreciated.

My configuration is jboss-4.0.4RC1 and jboss-portal-2.2.1RC3-src

To remove both the "No transaction manager provided" error and also the "setObjectName" no such method exception, do what is advised here and edit the file "jboss-portal-2.2.1RC3-src/core/src/resources/portal-core-sar/META-INF/jboss-service.xml" so that you add the "depends" thing advised here and also comment out the line with setObjectName in it cos there really is no such method. This XML file doesn't conform to any DTD and looks unfinished (rant).

<injection id="MBeanServerType" setMethod="setMBeanServer"/>
 <!-- [ MCB 2006/03/24 -->
 <!-- <injection id="ObjectNameType" setMethod="setObjectName"/> -->
 <!-- ] MCB 2006/03/24 -->
...
 <attribute name="CacheMode">LOCAL</attribute>
 <!-- [ MCB 2006/03/24 -->
 <depends>jboss.jca:service=DataSourceBinding,name=PortalDS</depends>
 <!-- ] MCB 2006/03/24 -->

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
 <jndi-name>PortalDS</jndi-name>
 <connection-url>jdbc:mysql://localhost:3306/jbossportal</connection-url>
 <!-- <connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false</connection-url> -->
 <!-- <driver-class>org.gjt.mm.mysql.Driver</driver-class> -->
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>jbp</user-name>
 <password>hbo6541</password>
 <!-- <min-pool-size>2</min-pool-size> -->
 <!-- <max-pool-size>20</max-pool-size> -->
 <!-- <idle-timeout-minutes>5</idle-timeout-minutes> -->
 <!-- <valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name> -->
 <!-- <exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name> -->
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
 <metadata><type-mapping>mySQL</type-mapping></metadata>
 <!-- <type-mapping>mySQL</type-mapping> -->
 </local-tx-datasource>
</datasources>

Jboss 4.0.4CR2 with jboss-portal-2.2.1RC3 binary, confirm these modifications fixed my install as well.

-D

I have the same problem, with:

MySQL 5
latest DB connector
Jboss AS 4.0.3.SP1
Jboss Portal 2.2.1

mysql5: http://wiki.jboss.org/wiki/Wiki.jsp?page=AvoidMySQL5DataTruncationErrors

Thank you very much Roy, I am going to try it