EJB / EE :: GenericJDBCException - Could Not Open Connection
Oct 3, 2014
I am new to EJB; I am writing EJB (3.1) program in JBoss 7.1 - I am using MySQL DB with JPA. While executing the program, I am facing the Generic JDBCException: Could not open connection. It is happening only for certain tables in the database; but NOT for all tables. My code is able to access few of the tables in the same database. Here is my full stack trace: -
Exception in thread "main" javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection
at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:166)
at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:230)
at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:304)
at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:190)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[code]....
View Replies
ADVERTISEMENT
Jun 25, 2015
What I have in my tnsnames.ora and verify it all works via sqlplus
CDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cdb1)
[Code] ....
I am trying to get RJDBC to work so I can connect to Oracle from R doing some data analysis..
This connection string works for my local db which I have it running in my Virtual Box
con <- dbConnect(drv, "jdbc:oracle:thin:@//localhost:1521/orcl", "demo", "demo")
However, it does not work when I do it for the remote db that I really need to pull data from...
> con <- dbConnect(drv, "jdbc:oracle:thin:@//ymsdbppr-scan:1522/YMQCTPRD", "user_read", "user_read")
Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1], :
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS: listener does not currently know of service requested in connect descriptor
View Replies
View Related
Oct 7, 2014
I have a simple method in Java through which I send commands to a machine over TCP. The problem is:
Machine can't accept more than two connections in 20 seconds.
I need to send 15-20 commands to the machine in 3 minutes.
This is my current method which is not working as it should, 2 commands get transmited but third command hangs because of the machine.
void sendCommand(String command) throws IOException {
String ipaddress = "192.168.0.2";
Socket commandSocket = null;
BufferedWriter out = null;
BufferedReader in = null;
BufferedWriter outToDetailFile = null;
[Code] .....
Basically what i need is:
1st: I need to open the connection by calling method
public void openConnection(String ipaddress, String port){
//Code to start the connection
}
2nd: I need to be able to send commands to the connection I have already opened (i will send multiple messages in time period of 5-10 minutes):
public void sendCommand(String message){
}
3rd: Close that connection
public void closeConnection(){
}
View Replies
View Related
Sep 1, 2014
I have created a JSP page, on click of a particular button, the control moves to the servlet "TestServlet".
This is the code under TestServlet:
import java.io.IOException;
import java.io.PrintWriter;
import java.security.Principal;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
[Code]...
Now, I have got a comment saying I should get the database connection from connection pool. And one more issue is that I have used the function System.getProperty("user.name") to get the username which i have logged in. But this code will be run on Unix which will not support this function. Any function where I can get the windows username. There is a function getUserPrincipal(), but this function returns a NULL. How to resolve this.
View Replies
View Related
Jan 11, 2015
I configured a connection pool in tomcat 7. For every database activity I get a connection from the pool. Do I have to close the connection like other regular connection after the database operation is done? If I close the connection will it have any effect on the connection pool?
View Replies
View Related
Jan 27, 2014
I downloaded JDK 7 file. But, I don't know how to use it. First of all, I even don't know how to open it.
There are some files in 'Java development kit', and the one I can play with is 'Java mission control'.
But it looks strange to me...and it looks it is not the way.. I want to compile files but, I can't find how to open java compiler.
View Replies
View Related
Feb 12, 2014
how to open a GUI on top of another GUI? I have built a GUI and have a button that when pressed I want to open a new GUI which is another java application within the project, it seems pretty straight forward and I just need to insert 'new [name of application]()'
Button btnEdit = new Button(shell, SWT.NONE);
btnEdit.addSelectionListener(new SelectionAdapter() {
@Override
public void widgetSelected(SelectionEvent e) {
new edit();
}
});
btnEdit.setBounds(76, 10, 75, 25);
btnEdit.setText("Edit");
View Replies
View Related
May 11, 2014
how to give URL Connection to this?
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.net.*;
import java.io.*;
import javax.swing.*;
import javax.swing.event.*;
public class WebBrowser
[code]....
View Replies
View Related
Jan 15, 2015
I was wondering if I could take the following code and somehow put the connection to database in it's own class without the "public static void main(String[] args)" method. That way I could call it anytime i want to open a connection to the database.
Java Code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Sample {
public static void main(String[] args) throws ClassNotFoundException
[Code] ....
View Replies
View Related
Oct 27, 2014
I'm using oracle 10g Database and Java 'jdk1.7.0_45' version.I have to a create program to insert data into a table.
View Replies
View Related
Apr 8, 2014
I'd like open a second GUI when I press a button that's on the first GUI, like a link in a website.
What I want to do is:
1- Open GUI_1;
2- Press a button on GUI_1; this button close GUI_1 and open another GUI (GUI_2).
How can I do it?
View Replies
View Related
Feb 27, 2015
i have an older file I was working on 2 months ago and when i try to open it in eclipse I get a message corruption error. I know this is not possible since I was just working on it a while back, and it's the same program version as what i am currently using..Or would I do a file import instead?
View Replies
View Related
Sep 13, 2012
Is there a way we can open a .chm file stored at server through jsp application without downloading the file and saving it to the local machine.
What I googled is : we cannot download .chm files from a web browser and simply click Open. Download the .chm file to your computer first, right-mouse click it in Windows Explorer and select Properties. Then click Unblock.
But I want my users to simply view the file without downloading it.
View Replies
View Related
Sep 16, 2014
I'm using JSF framework. I can let Netbeans to create the persistence unit and hardcodes connection parameters into the persistence.xml file or i can use resource tag in context.xml file or using another file like property file or class for holding connection parameters like username and password; what is the most secure way or expert way to use connection properties in my app or there is no difference?
View Replies
View Related
Mar 9, 2015
package com.dnex;
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
[code]....
I am getting the connection time out error in below line :-
System.out.println("response code"+httpConnection.getResponseMessage());
Note:-I need to pass user id and pwd in header parameter.and I am using https connection.
View Replies
View Related
Mar 15, 2015
I am trying to make a simple login using netbeans, derby database included in netbeans and tomcat server. I made everything nice and separated: I have a model package with a class called DbConnector that has the following method:
public Connection connect() {
try {
return DriverManager.getConnection(url, user, pass);
} catch (SQLException ex) {
return null;
}
}
Then i have another class, an userDAODB that has a password check method:
public boolean checkPassword(String user, String password) {
try (Connection con = new DbConnector().connect(); Statement stmt = con.createStatement()) {
//checks the password in the database
In the main method of this class i tested everything, it works very nice, logs me in, other methods work too, no problem what so ever.But then i go to my servlet:
public class LoginTest extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
String username = request.getParameter("username");
String pass = request.getParameter("pass");
UserDAODB userDAO = new UserDAODB();
boolean authe = userDAO.checkPassword(username, pass);
[code]....
So when i start the webpage and i try to click on the login button I get a NullPointerException com.model. UserDAODB. check Password (User DAODB. java:14) - so line 2 here
I have been googling a bit, i placed the derby.jar and the derbyclient.jar in the lib directory of tomcat, i tried to modify the context.xml of my application, but then it wouldn't even start anymore.
View Replies
View Related
May 13, 2014
I got the below exception .how to resolve this .It's receiving the data up to 10 min then suddenly below error happening. I have embedded the source code below
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at sun.nio.cs.StreamDecoder.readBytes(Unknown Source)
at sun.nio.cs.StreamDecoder.implRead(Unknown Source)
[Code] .....
View Replies
View Related
Nov 16, 2014
I am unable to connect my javafx scene to mysql database. I get a java.lang.NullPointerException every time. I tried searching everywhere possible but no answers available. This is the Person class (super class for Teacher class):
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
[code].....
View Replies
View Related
Jul 27, 2014
Below is a code of a simple file downloader in java. I want to detect an exception when the connection is broken in the middle of downloading a file. Now, I run the code and in the middle of downloading the file, i turn off my wifi with keyboard wifi off button. Doing this the program hangs forever without throwing any exceptions and without terminating. It seems it blocks forever.why is exception not thrown? Secondly, in the following code you can see this line //con.setReadTimeout(2000); which is currently commented out. Removing the comment and running the program, now if connection breaks in the middle by turning off wifi then it waits for 2 seconds and then if it cannot read then it terminates without throwing exception. So, again in this case why is it just terminating and not throwing any exception?
Java Code:
import java.io.FileOutputStream;
import java.net.URL;
import java.net.URLConnection;
import java.nio.channels.Channels;
import java.nio.channels.ReadableByteChannel;
import java.util.*;
[code]...
View Replies
View Related
Aug 5, 2014
I tried to connect oAuth2 with gmail. In command line, no problem. But with Javamail it failed.
The source of the exemple are here : [URL] ....
Last modified is in 2012 then, maybe, this code is obsolete.
In command line it works fine :
Java Code:
openssl s_client -crlf -connect imap.gmail.com:993
A002 AUTHENTICATE XOAUTH2
+
my_token_who_end_with__
Response : A002 OK myaddress@gmail.com ForName Name authenticated (Success) mh_sh_highlight_all('java');
For information :
- it failed with token and refresh token
- here are the logs :
Java Code:
DEBUG: getProvider() returning javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Oracle]
DEBUG IMAPS: mail.imap.fetchsize: 16384
DEBUG IMAPS: mail.imap.ignorebodystructuresize: false
DEBUG IMAPS: mail.imap.statuscachetimeout: 1000
DEBUG IMAPS: mail.imap.appendbuffersize: -1
DEBUG IMAPS: mail.imap.minidletime: 10
[Code] ...........
View Replies
View Related
Feb 16, 2013
I have noticed an error, that makes sometimes troubles, when downloading jars from https addresses, when there are many jars to download..
Best example is by opening Javas on Java version checker. [URL] ....
I get also following log...
network: Connecting https://www.java.com/jsp_utils/jreverification.jar with proxy=DIRECT
network: Connecting http://www.java.com:443/ with proxy=DIRECT
network: Connecting https://www.java.com/jsp_utils/jreverification.jar with cookie "JSESSIONID=22ABBA2BE9B5789629C276AC35BDF969; s_cc=true;
Even if the address is https, java try to access via http protocol on port 443, and that leads sometimes to problems..
I have noticed this, when I have used URLConnection(HttpURLConnection) for my self, as soon Java sends http link on https address, the jar gets sometimes not loaded, and i get error about missing class that get called..
On http addres it is not so bad, since same protocol is used, but evidently, that is evil for https..
As you see, that happens already when loading Jar by Applet Starter and at all, it happens each time on any URLConnection
###############################
Java Plug-in 10.13.2.20
Using JRE version 1.7.0_13-b20 Java HotSpot(TM) Client VM
User home directory = X:Usersadmin
----------------------------------------------------
c: clear console window
f: finalize objects on finalization queue
g: garbage collect
[Code] .....
View Replies
View Related
Jan 3, 2015
What does this error mean, and also, when I get it, the command line hangs so that I can't do anything else (Is there a way to recover from that?). I'm running Windows 7.
Jan 03, 2015 5:00:59 AM java.util.prefs.WindowsPreferences <init>
WARNING: Could not open/create prefs root node SoftwareJavaSoftPrefs at root 0
x80000002. Windows RegCreateKeyEx(...) returned error code 5.
View Replies
View Related
Oct 30, 2014
i dont know how to write main that would open the input file and read using this method...
[/package AssignmentSeven;
import java.io.*;
import java.util.Scanner;
public class Assignment7
{
public static void Towers(int nTowers, int fromTower1, int workTower2, int toTower3) {
if(nTowers == 1)
[code].....
View Replies
View Related
Jan 24, 2014
In Windows and Mac both, the following code works wonders:
Java Code: // openURL called from another method
openURL("http://www.google.com");
private void openURL(String URL)
{
[Code].....
The only OS I can get this to work on is Kubuntu or even Ubuntu for that matter.
View Replies
View Related
Jan 13, 2015
I was just wondering how would I create a jar file that would open 3 other jar files when I open the jar file with my batch file it and when I type stop in the batch file it will out put the stop command into all 3 of the other jar files.
This is for my Minecraft server so I can launch them all at the same time and inStead of having to enter the commands in all the server batch files I just have to do the command in 1 I know their is things like multi craft to do this but I want the code so I don't have to use multicraft.
View Replies
View Related
Jul 15, 2015
I'm using java FX-8 and JDK 1.8,Netbeans 8.0.2.I want to open pdf on button click in my JavaFXML Application.I have triued pdf viewer plugins and iText but it doesn;t work.I have to pass variable value in pdf too.
View Replies
View Related
