I have 2 tables on 1 database
Table A, Table B
I need to evaluate a query by joining these 2 tables and then update the results in the 3rd table in another database. I need to use stateless session bean using JPA I believe. I need 3 Entities for each of the tables here.
I am trying to retrieve data from my database by joining my tables. So far i have managed to join my four tables in my database and retrieve all the information in that table. Now what i want to do is create a prepared statement in java that allows me to retreive certain data. Here is my joining query.
SELECT student.idNumber,student.names, student.surname,
course.description,
coursemarks.mark,
class.form,class.id
FROM `student`
LEFT JOIN `coursemarks` on student.idNumber = coursemarks.studentid
LEFT JOIN `course` on course.courseid = coursemarks.courseid
LEFT JOIN `class`on student.idNumber = class.studentID;
What I want is to select all the data depending on the class passed and the form passed, e.g a person might decide to select a certain form only or a certain form and class
I'm using EclipseLink with EJBs. In my Entity bean class, I defined a column for the ROWID column:
@Id
@Column(name = "ROWID")
public String getRowid() {
return rowid;
}
public void setRowid(String rowid) {
this.rowid = rowid;
}
This @Id column is part of a composite key in my Id class using multiple @Id columns.
After I selected records from DB and try to print out the value in log, I see something like:
oracle.sql.ROWID@12b012b0
In the above String, after the portion "oracle.sql.ROWID@", the value always consists of 2 repeated parts, in this case "12b0".
This is completely different from the value I see when run SQL directly in my DB tool (PL/SQL developer) to select ROWID column.
Also, selecting the same record again later in the application will give me a different rowid String value.
Using EntityManager method calls (em.find(), em.merge()....) will always fail since the ROWID value is incorrect.
My question is, is the java String type not suitable as receiver for Oracle ROWID?
Or is it simply Oracle ROWID cannot be used with EclipseLink, only JDBC?
Since I'm not using JDBC, we cannot use the oracle.sql.ROWID type as receiver.
We started learning about tables and have a little program. The teacher gave us an excercise and doesn't works (not running), I receive too many errors. So any simple java program with tables with 20 numbers, that is giving random numbers?
View Replies View RelatedUsing HQL I am fetching the rows , now i need to iterate through the list and convert each row in the list to a "string" and append the string to a buffer.... How to do it
View Replies View RelatedI am creating a portal using JSP and MySQL with eclipse IDE. I have a scenario where data is stored on draft table and is retrieved then stored on another table. I need the entry in the draft table to be deleted after the insertion. When I tried to run the code it redirects to success page but makes no impact on database(neither inserts not gets deleted).
<%@ page import="java.sql.*" %>
<%@ page import = "java.util.Date,java.text.SimpleDateFormat,java.text.ParseException"%>
<html>
<head>
<title>JSP Processing</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
[code]....
I am writing a class which formats console output as a table. It displays the type of an entry, the name of an entry, and the data for an entry. I am stuck on a required for loop which appends a tab character to a string, for formatting it as a table. It doesn't seem to be adding any of the tabs and I can't tell what I've done wrong. As far as I can tell the contents of the loop are never reached, and I can't make sense of it.
The ConsoleWriter class that contains the code that is in error...
Java Code:
package frontend;
public class ConsoleWriter {
private static String tabbedData(String data, int min) {
System.out.println(); //for debug
int tabcount = 0;
int len=8*min;
[code]....
Is there a way to inform the Entity Manager or force the JPA provider to reload data from the database? The scenario could be data being updated by a store procedure or direct SQLPlus maintenance, without restarting the Application Server, the JPA need to load the newly updated data from the database.
I think the current JPA API is not enough. The void refresh(java.lang.Object entity) from EntityManager need to pass in the Entity object, I will like to know how to refresh the entire JPA Entity data after the physical table data being update from backend.
I've been using a Java applet for sports tables.It has been very useful for me. However, the recent developments from the people at Oracle have made this program impossible to use. The point is that I need this program and I need it fast.I've been in touch with the person who once created this applet and he has no intentions at all to upgrade it or do anything to make it function. How to make the program works with their new updates.
View Replies View RelatedI am trying to use this program for reference but its not working ...
View Replies View RelatedHow to get messages from WebSphere MQ using ejb MDBs and I have to deploy this in Weblogic server.
View Replies View RelatedIDE: Netbeans 8.0.
Server ejb:
"@Stateless
public class ejb implements ejbRemote{
public String say(){
return "hello";
[Code] ....
When I run the Web project on the Server host, it's OK. But when I run it on another host it returns error. I can access 192.168.0.2:7676 in browser(returns some context string), so it may not be caused by firewall.
I think the problem is the initalContext is not generated from 192.168.0.2:7676 but from local JVM, because when when running it in the Server I change the ip address to random number it also is OK.
I have included the log4j.jar in libraries; added log4j.xml in the sources folder; but I am getting an error:
<Apr 22, 2014 11:07:50 AM PKT> <Warning> <EJB> <BEA-010065> <MessageDrivenBean threw an Exception in onMessage().
The exception is:
java.lang.NoClassDefFoundError: org/apache/log4j/Logger.
java.lang.NoClassDefFoundError: org/apache/log4j/Logger
at test.MyMessageBean.onMessage(MyMessageBean.java:39)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:575)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:477)
at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:375)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4855)
Truncated. see log file for complete stacktrace
how to resolve this???
I have a question about enumerations,
class Test{
public enum Gender{
Male, Female
}
@Enumerated(EnumType.STRING)
@Column(length=1)
private Gender gender;
}
My question is this correct? My goal is to keep only one character of the enumeration .
I am looking for the ability, on the server side, to run programs or "jobs" in a job queue, where the jobs are processed as first in first out. If you are familiar with the IBM iSeries, they have a built in job queue mechanism which accomplishes what I am looking for. The primary purposes for this would be to process and update large amounts of data in a thread safe environment.
View Replies View RelatedI tried to develop a sample project with reference to : [URL] .....
When I try to run the client, I get the following error
javax.naming.NameNotFoundException: ejb: not bound
at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)
at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)
at org.jnp.server.NamingServer.getObject(NamingServer.java:785)
at org.jnp.server.NamingServer.lookup(NamingServer.java:396)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[Code] .....
I am runing ejb3 in weblogic 10.3 and struts in tomcat server. both communication is not happening .
root dir
onlyenb6
account class
package ejb3.onlyejb;
import java.io.Serializable;
import javax.persistence.Entity;
import javax.persistence.Id;
[Code] ....
Get error
accno=44
na=hjhjhj
bal=777.0
enter in to if loop
jndi properties nuderprocess
jndi properties nuderprocess22
loading p file={java.naming.provider.url=t3://localhost:7001,
[Code] ....
I am using EJB 2.1 when i am tryinh to access another bean from one bean I am getting :
javax.ejb.ObjectNotFoundException:No such entity the full stack trace is given ...
javax.ejb.ObjectNotFoundException: No such entity!
09:06:05,795 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:46)
09:06:05,795 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity(JDBCStoreManager.java:591)
09:06:05,795 ERROR [STDERR]
[Code] .....
I'm deploying an EAR file on weblogic 10.3.4. The EAR file contains a war file and a jar file that implements web services using EJBs.
The application deploys and is functioning correctly. The application is available from the following URLs:
web application: [URL] ....
web services: [URL] ....
However, I would like configure the deployment to insert the "app1" string into the URL so the application is available like this:
web application: [URL] ....
web services: [URL] ....
I've been looking at some of the configuration options in deployment plans, but can't seem to get anything working.
I'm writing an enterprise application to familiarize myself with Glassfish 3.1.2 and EJB 3.1. I've created several local, stateless beans, and injected one into a JSF managed bean. The ejb and web modules compile fine, but when I launch the application with Glassfish I get the following startup error and the application does not deploy.
SEVERE: Exception while invoking class org.glassfish.ejb.startup.EjbDeployer prepare method
SEVERE: Exception while invoking class org.glassfish.javaee.full.deployment.EarDeployer prepare method
SEVERE: Exception while preparing the app
SEVERE: Unable to load the EJB module. DeploymentContext does not contain any EJB.
org.glassfish.deployment.common.DeploymentException: Unable to load the EJB module. DeploymentContext does not contain any EJB.
Check the archive to ensure correct packaging for D:DocumentsNetBeansProjectsTestdistgfdeployTestTest-war_war.
If you use EJB component annotations to define the EJB, and an ejb or web deployment descriptor is also used, please make sure that the deployment descriptor references a Java EE 5 or higher version schema, and that the metadata-complete attribute is not set to true, so the component annotations can be processed as expected :
at org.glassfish.javaee.full.deployment.EarDeployer.prepare(EarDeployer.java:166)
at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:871)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:410)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:240)
at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:389)
[Code] ......
How can I connect to multiple Databases (using @PersistenceContext) using an EJB? Did I need to connect various Entity Managers corresponding to the each database and simply send my Queries?
I am using Glassfish Application Server
Netbeans IDE
Java Derby Database
Oracle Database
Java Persistence API
Recently we updated out database and we changed our tables' and columns' names, I'm developing an adf application with EJB3.0 the question is that the new column names start with a number (eg. 001U_ID), its a kind of encoding the names of the tables so no one can modify the values.
When I create a query on the table it is throwing an exception:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'U_ID'.
I think the problem is that the EJB3.0 doesn't recognize column names starting with a number!!! What can I do to solve this issue?
I finish reading The EntityManager Interface in JEE tutorial. I know I can use container manager entity manager in EJB, but I want to explore how to use application managed entity manager in EJB.
Can I use application managed entity manager in EJB (container management JTA transaction is used)? Where do I should close entity manager if can?
The following is an example from JEE tutorial, but didn't find where to calose entity manager. and can I create mutiple EntityManagerFactory objects and Entity Manager objects to use them in a JTA transaction?
@PersistenceUnit
EntityManagerFactory emf;
EntityManager em;
@Resource
UserTransaction utx;
[Code] .....
Web Layer - JSP/Servlets
Business Layer - EJB 3
I want to develop separate projects for web layer (.war) and for Business layer (.jar). I want to deploy these layers on different Glassfish servers.
Here is my Approach -
1. Create a separate module for remote interfaces (.jar), use @remote annotations
2. Create a Web module using JSP/Servlets (.war) and use this remote interface jar in it.
3. Create a EJB module (.jar) and implement these remote interface in it.
4. Use JNDI in Web layer to access the EJB methods.
I want to know if this is the correct approach?
I'm using EJB 3.1 and JBOSS 7.1.. Is it possible to create and write a file(CSV) directly to SFTP server?
View Replies View RelatedDeploy sample J2EE app to WebLogic server
A getting started app is fine, need to understand of deploying a sample application to WebLogic server. Any particular configuration during WLS install?