Enterprise JavaBeans :: JPQL Does TRIM Column Containing Only Blank Spaces Returns Null?
Oct 6, 2014
In Oracle SQL, when you do trim(column_name), if column_name is blank spaces only (say datatype is CHAR(8)), then "trim(column_name) is null" is true.
In JPQL, if you do "TRIM ( BOTH FROM p.column_name ) is null", does it evaluate to true just like in Oracle SQL?
The reason I'm asking, is my colleague wrote some code in JPQL like below:
... TRIM ( BOTH FROM CONCAT(p.column_name, '#@') ) = '#@'
He said he originally wanted to compare the TRIM result to empty String '', but the result is false, so he concat the column to some junk.
So if after the TRIM, the result is the same junk he added, then the column contains only blanks. I think this works but there could a simpler way to do it.
View Replies
ADVERTISEMENT
Feb 14, 2013
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?
View Replies
View Related
Oct 23, 2013
I have an stand alone client to use a remote ejb with some methods. All works fine, but when I pass an entity class as parameter from the stand alone client to the remote ejb, the entity class is received as null.
View Replies
View Related
Feb 23, 2013
I am doing this
@Startup
@Singleton
@ConcurrencyManagement(ConcurrencyManagementType.CONTAINER)
@Lock(LockType.READ)
public class ResourceBean {
[Code] ....
And I call this singleton bean from a stateless session bean like this
@Stateless
public class ClientBean {
@EJB
ResourceBean resource;
public String create(String r)
{
String res=resource.returnString(r);
return res;
}
}
But resource.returnString(r); gives a org.apache.jasper.JasperException: java.lang.NullPointerException I started the glassfish server in debug mode and found out that "resource" was null. but @PostConstruct in singleton does print which means singleton bean exists.
Can we call singleton beans with no interface in such a way form a session bean? I actually want to acquire instance of singleton bean when a client invokes method in Client bean...
View Replies
View Related
Feb 4, 2014
How can i make sure that when user enter value there is no space between words example :
NEW YORK MUST BE NEW YORK
View Replies
View Related
Jan 21, 2013
How to get messages from WebSphere MQ using ejb MDBs and I have to deploy this in Weblogic server.
View Replies
View Related
Jun 15, 2014
IDE: 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.
View Replies
View Related
Apr 22, 2014
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???
View Replies
View Related
Feb 14, 2013
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 .
View Replies
View Related
Mar 3, 2013
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 Related
Jun 7, 2013
I 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] .....
View Replies
View Related
Jul 5, 2013
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] ....
View Replies
View Related
Oct 22, 2008
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] .....
View Replies
View Related
Nov 28, 2014
I am trying to make a java code that reads in lines of text and returns the number of spaces in each line.I think i have made it but i can not compile it..
Here is my code:
class Mainh {
public static void main( String args[] ) {
System.out.print( "#Enter text : " );
String text = BIO.getString();
while ( ! text.equals( "END" ) )
[Code] ....
View Replies
View Related
Mar 19, 2013
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.
View Replies
View Related
Apr 1, 2013
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] ......
View Replies
View Related
Mar 9, 2013
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
View Replies
View Related
May 9, 2014
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] .....
View Replies
View Related
May 12, 2013
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?
View Replies
View Related
Jan 23, 2013
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 Related
Dec 30, 2013
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.
View Replies
View Related
Jul 5, 2014
Deploy 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?
View Replies
View Related
Mar 9, 2013
I am using EJB (Stateless) without any web service. I simply need to send a String from Client to Server
I can connect any Java SE Client with this EJB. But how I can connect an Android Client with this EJB (i.e. Using EJBRemote Interface) directly? I am using :
Glassfish Application Server
Netbeans IDE
View Replies
View Related
Jun 19, 2014
We have a J2EE business web application that runs in WebLogic. We noticed in application log files errors messages that seems like "No resource available in db pool", it means all the connection objects (to Oracle database) are used. Then the application is unstable and unseable.
I think the maximum number of connections configured in Weblogic pool has been reached due to an increase of users and activity. But when the workload decreases the application is still out of service. It seems connections objects are not relased to the pool. What can be the explanation for this issue ? Normally it is managed by the container (EJB3 for the business tier).
Once the limit of the pool is reached it is necessary to restart the server to solve this kind of error ?
View Replies
View Related
Feb 24, 2014
There is a weblogic server running at remote place and i need to access the API's in that remote method using JNDI lookup. My application is configured in Spring Tool Suite IDE with java 6 and tomcat 7 and I have used Spring to perform the jndi lookup of weblogic server. In spring i have used simpleremotestatelesssessionproxyfactorybean class to lookup a weblogic server using jndi and get the remote object. But somehow on doing it i'm getting the following error.
org.omg.CORBA.COMM_FAILURE: vmcid: SUN minor code: 203 completed: Maybe
at com.sun.corba.se.impl.logging.ORBUtilSystemException.writeErrorSend(Unknown Source)
at com.sun.corba.se.impl.logging.ORBUtilSystemException.writeErrorSend(Unknown Source)
at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.sendWithoutLock(Unknown Source)
at com.sun.corba.se.impl.encoding.BufferManagerWriteStream.sendFragment(Unknown Source)
[Code] ....
The exception is been thrown at com.sun.corba.se.impl.encoding.CDROutputObject method when calling writeTo(). Why I'm getting this error and can I do anything to remediate it. Irrespective of java this error occurs, i tried with java 5, 6 and 7 but still getting the same error.
View Replies
View Related
Mar 25, 2013
Trying to deploy the application with webService project fails with below error
weblogic.j2ee.dd.xml.AnnotationProcessException: [EJB:015001]Unable to link class oracle.apps.scm.productCollaboration.common.businessClasses.businessClassesService.applicationModule.
server.BusinessClassServiceImpl in Jar /scratch/software/mw_local/FMWTOOLS_11.1.1.7.0_GENERIC_121222.1001.2_PATCHES4FA_11.1.1.7.0_PLATFORMS/jcyril/mw_home_standalone/user_projects/domains/fusion_domain/servers/AdminServer/upload/ProductLifecycleManagementApp
[Code] ....
View Replies
View Related
