[Beginner's Corner] - JBoss:EJB is not creating table in MySQL DB
by Gurubg G
Gurubg G [http://community.jboss.org/people/gurubg] created the discussion
"JBoss:EJB is not creating table in MySQL DB"
To view the discussion, visit: http://community.jboss.org/message/580992#580992
--------------------------------------------------------------
Hello Folks,
I have a strange problem, I am not receiving any error when I deploy my http://www.coderanch.com/forums/f-11/EJB-JEE EJB project to http://www.coderanch.com/forums/f-63/JBoss JBoss . I have a single entity bean defined and expecting it to be created in MySQL DB. But strangely I do not see any table created . Has anyone faced the same problem before ?
I am using Eclipse IDE, MySQL server 51.1 and JBoss 5.0.1 server..
Please find the log attached ..
And I am posting the configuration files I have used.
|| *Peristence.xml* ||
| <?xml version="1.0" encoding="UTF-8" ?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="LessonDS-PU" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:/lessonds</jta-data-source>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<property name="hibernate.hbm2ddl.auto" value="create-drop"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
</properties>
</persistence-unit>
</persistence> |
|| *mysql-ds.xml* ||
| <?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: mysql-ds.xml 41017 2006-02-07 14:26:14Z acoliver $ -->
<!-- Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->
<datasources>
<local-tx-datasource>
<jndi-name>lessonds</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/lessonds</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>guru</password>
<!-- <connection-property name="autoReconnect">true</connection-property> -->
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources> |
I have placed the DB conenctor file mysql-connector-java-5.1.14-bin.jar in \server\default\lib folder ..
This is my code for Entity which I am trying to create
|| *Entity bean* ||
|
package com.lessonejb.entities;
import java.io.Serializable;
import java.util.Set;
import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.ManyToMany;
import javax.persistence.Table;
import javax.persistence.OneToMany;
//@SuppressWarnings("serial")
@Entity
@Table(name="lessonuser")
public class User implements Serializable {
private static final CascadeType[] ALL = null;
private String email;
private String password;
private String name;
private String surname;
private int role;
private long userID;
private Set <Course> coursesCreated;
private Set <Course> coursesEnrolled;
private Set <Test> testsCreated;
private Set <Test> testsTaken;
/**
* Gets the analysis unique identifier.
* This field is used as primary key for persistence.
* @return analysis unique identifier
*/
@Id
public String getEmail()
{
return email;
}
/**
* Sets the analysis unique identifier
* @param id unique identifier to set
*/
public void setEmail(String email)
{
this.email = email;
}
/** Password */
public String getPassword()
{
return password;
}
public void setPassword(String email)
{
this.password = password;
}
/** Name of the user */
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
/** Surname of the user */
public String getSurname()
{
return surname;
}
public void setSurname(String surname)
{
this.surname = surname;
}
/** Role of the user 1-Trainer, 2-Trainee, 3-Assistant*/
public int getRole()
{
return role;
}
public void setRole(int role)
{
this.role = role;
}
/** Role of the user 1-Trainer, 2-Trainee, 3-Assistant*/
public long getUserID()
{
return userID;
}
public void setUserID(long userID)
{
this.userID = userID;
}} |
But I do not see any table named "lessonuser" created in the "lessonds" database.
Can someone point out if I am going wrong somewhere ?
Thanks in advance ..
Guru
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/580992#580992]
Start a new discussion in Beginner's Corner at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 1 month
[JBoss Web Services] - Problems with missing minOccurs=" 1" in generated wsdl
by Mats Ekström
Mats Ekström [http://community.jboss.org/people/fghj5678] created the discussion
"Problems with missing minOccurs="1" in generated wsdl"
To view the discussion, visit: http://community.jboss.org/message/561764#561764
--------------------------------------------------------------
Hi!
We are using jboss soa platform 4.3.0 CP02 and when I annotate like this:
@XmlElement(nillable=false, required=true)
public void setProducer(String producer) {
public void setProducer(String producer) {
this.producer = producer;
}
this.producer = producer;
}In the generated wsdl (from the deploy), the element producer will look like this:
<xs:element name="producer" type="xs:string"/>
Where is the minOccurs="1"???
If I instead annotate at declaration of producer I get an exception:
@XmlElement(nillable=false, required=true)
private String producer;
java.lang.IllegalStateException: Cannot build JAXB context
...
Caused by: com.sun.xml.bind.v2.runtime.IllegalAnnotationsException: 1 counts of IllegalAnnotationExceptions
Class has two properties of the same name "producer"
this problem is related to the following location:
at public java.lang.String se.tullverket.texi.archive.bl.Trans.getProducer()
at se.tullverket.texi.archive.bl.Trans
at public se.tullverket.texi.archive.bl.Trans se.tullverket.texi.archive.bl.ArchiveTO.getTrans()
at se.tullverket.texi.archive.bl.ArchiveTO
at private se.tullverket.texi.archive.bl.ArchiveTO se.tullverket.texi.archive.bl.jaxws.Archive.arg0
at se.tullverket.texi.archive.bl.jaxws.Archive
this problem is related to the following location:
at private java.lang.String se.tullverket.texi.archive.bl.Trans.producer
And if I skip the annotation it looks like this:
<xs:element minOccurs="0" name="producer" type="xs:string"/>
Any ideas?
/Mats
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/561764#561764]
Start a new discussion in JBoss Web Services at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 1 month
[JBoss Tools] - BIRT Integration-Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda)
by Mike Baxley
Mike Baxley [http://community.jboss.org/people/mbaxley] created the discussion
"BIRT Integration-Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda)"
To view the discussion, visit: http://community.jboss.org/message/610705#610705
--------------------------------------------------------------
I created a Seam 2.2 + JBoss BIRT Integeration project (BIRT2.6). I want to use the Hibernate ODA datasource for my reporting.
In my test project I used the Birt Sample Classic Models database. I generated the entity bean for the employees table and then built a report design using the Hibernate ODS datasource and dataset. I was able to preview the data and report within the eclipse IDE.
When I run the application in JBoss 5.1, I can successfully run the test and test1 sample reports added with birt integration. I can also view the data witht the seam generated web pages. So it seems my birt installation works fine along with my hibernate entity manager.
When I try to run my report that uses the Hibernate ODA datasource i get the following message:
The following items have errors:
Table (id = 9):
+ An exception occurred during processing. Please see the following message for details:
Cannot find or process the org.jboss.tools.birt.oda driver's data source extension configuration.
Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda).
Check the workspace log file for any problems with loading the extension bundle and its dependencies.
The ReportEngine log shows this:
Jun 16, 2011 11:20:43 AM org.eclipse.birt.data.engine.odaconsumer.Driver doGetDriverManifest
SEVERE: Cannot find or process the ODA data source extension configuration.
java.lang.IllegalArgumentException: Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda).
Check the workspace log file for any problems with loading the extension bundle and its dependencies.
at org.eclipse.datatools.connectivity.oda.util.manifest.ManifestExplorer.getExtensionManifest(ManifestExplorer.java:200)
at org.eclipse.birt.data.engine.odaconsumer.Driver.doGetDriverManifest(Driver.java:150)
at org.eclipse.birt.data.engine.odaconsumer.Driver.findDataSourceExtensionConfig(Driver.java:126)
at org.eclipse.birt.data.engine.odaconsumer.Driver.getDriverExtensionConfig(Driver.java:78)
at org.eclipse.birt.data.engine.odaconsumer.Driver.getExtensionConfig(Driver.java:60)
at org.eclipse.birt.data.engine.odaconsumer.Driver.createNewDriverHelper(Driver.java:97)
at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getDriverHelper(DriverManager.java:111)
at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getNewDriverHelper(DriverManager.java:100)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:150)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
I grabbed the source code for ManifestExplorer and added some logging. It looks like the hibernate oda plugin is not being found. These are the plugins that are returned from the ExtensionRegistry:
org.eclipse.birt.report.data.oda.jdbc.dbprofile
org.eclipse.birt.report.data.oda.jdbc
org.eclipse.birt.report.data.oda.sampledb
org.eclipse.birt.report.data.oda.xml
org.eclipse.datatools.connectivity.oda.flatfile
org.eclipse.datatools.enablement.oda.ws
org.eclipse.datatools.enablement.oda.xml
org.jboss.tools.birt.oda is not listed. I do have the org.jboss.tools.birt.oda_1.2.0.v20110215-1225-H29-GA plugin in my plugins folder. I have tried using it both in a jar and exploded.
Any thoughts on how to make BIRT recognize the plugin? I also tried these same steps with my actual database with the identical results.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/610705#610705]
Start a new discussion in JBoss Tools at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 1 month
[JBoss Web Services] - Re: Jboss 6.0 WebService Client with SSL (Saaj)
by Fabiano Oss
Fabiano Oss [http://community.jboss.org/people/fabiano.oss] created the discussion
"Re: Jboss 6.0 WebService Client with SSL (Saaj)"
To view the discussion, visit: http://community.jboss.org/message/604247#604247
--------------------------------------------------------------
protected ByteArrayOutputStream sendMessage(URL urlWSDL, QName qService, QName qPort, String soapMessage) throws Exception {
MessageFactory factory = MessageFactory.newInstance(SOAPConstants.SOAP_1_2_PROTOCOL);
SOAPMessage message;
MimeHeaders header = new MimeHeaders();
header.addHeader("Content-Type", "application/soap+xml");
message = factory.createMessage(header, new ByteArrayInputStream(soapMessage.toString().getBytes()));
Service service = Service.create(urlWSDL, qService);
Dispatch<SOAPMessage> dispatch = service.createDispatch(qPort, SOAPMessage.class,Service.Mode.MESSAGE);
setSecurity(dispatch);
SOAPMessage res = dispatch.invoke(message);
ByteArrayOutputStream out = new ByteArrayOutputStream();
res.writeTo(out);
return out;
}
private void setSecurity(Dispatch<SOAPMessage> dispatch) throws KeyStoreException, NoSuchAlgorithmException, CertificateException, FileNotFoundException, IOException, InvalidKeyException, InvalidKeySpecException, UnrecoverableKeyException {
Client client = ((org.apache.cxf.jaxws.DispatchImpl) dispatch).getClient();
HTTPConduit http = (HTTPConduit) client.getConduit();
HTTPClientPolicy httpClientPolicy = new HTTPClientPolicy();
setProxy(security, http, httpClientPolicy);
http.setClient(httpClientPolicy);
TLSClientParameters tlsParams = new TLSClientParameters();
TrustManager[] trustMgr = addTrustManagers(security);
KeyManager[] keyMgr = addCertificado(security);
tlsParams.setKeyManagers(keyMgr);
tlsParams.setTrustManagers(trustMgr);
http.setTlsClientParameters(tlsParams);
}
private void setProxy(SegurancaDES security, HTTPConduit http,
HTTPClientPolicy httpClientPolicy) {
httpClientPolicy.setProxyServer("192.168.1.1");
httpClientPolicy.setProxyServerPort("3128");
http.getProxyAuthorization().setUserName("proxyUser");
http.getProxyAuthorization().setPassword("proxyPassword);
}
private KeyManager[] addCertificado(SegurancaDES security)
throws KeyStoreException, IOException, NoSuchAlgorithmException,
CertificateException, FileNotFoundException,
UnrecoverableKeyException {
KeyStore ks1;
ks1 = KeyStore.getInstance("PKCS12");
ks1.load(new FileInputStream(new File("file path")),"password".toCharArray());
KeyManagerFactory keyFactory = KeyManagerFactory.getInstance(KeyManagerFactory.getDefaultAlgorithm());
keyFactory.init(ks1, "password".toCharArray());
KeyManager[] keyMgr = keyFactory.getKeyManagers();
return keyMgr;
}
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/604247#604247]
Start a new discussion in JBoss Web Services at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 1 month
