MySQL Forums - Java

One specific Query doesn't run (1 reply)

Francisco Pastrana — Tue, 02 Apr 2013 16:25:09 +0000

Hi!

I have an issue running a group of querys on my app, but it really makes me headache that one specific query doesn't run. Here a brief explanation.

I'm converting Excel sheets into mysql tables, here everithing is allright.
then I declare a variable called "fecha", I use this variable several times in different querys and everything goes cool. but one specific query I'm sure is not working, worst there is no error message.

Here part of the code.

st.executeUpdate("UPDATE terminales_temporal a inner join (SELECT e.estatus, e.terminal,DATEDIFF('"+fecha+"',t.fecha_alta) FA FROM terminales_temporal t INNER JOIN estatus_terminales e ON t.terminal=e.terminal WHERE t.con_mov IS NULL AND e.mes=IF(t.mes=1,t.mes+11,t.mes-1)) b ON a.terminal = b.terminal SET a.estatus=1, a.descripcion_estatus = 'Sin Start' WHERE b.estatus = 1 AND FA >=0;");
st.executeUpdate("UPDATE terminales_temporal a inner join (SELECT e.estatus, e.terminal,DATEDIFF('"+fecha+"',t.fecha_alta) FROM terminales_temporal t INNER JOIN estatus_terminales e ON t.terminal=e.terminal WHERE t.con_mov IS NULL AND e.mes=IF(t.mes=1,t.mes+11,t.mes-1)) b ON a.terminal = b.terminal SET a.estatus=5, a.descripcion_estatus='Inicio de Inactividad' WHERE b.estatus in (2,3,4);");
st.executeUpdate("UPDATE terminales_temporal a inner join (SELECT e.estatus, e.terminal,DATEDIFF('"+fecha+"',t.fecha_alta) FROM terminales_temporal t INNER JOIN estatus_terminales e ON t.terminal=e.terminal WHERE t.con_mov IS NULL AND e.mes=IF(t.mes=1,t.mes+11,t.mes-1)) b ON a.terminal = b.terminal SET a.estatus=6, a.descripcion_estatus='Continua sin Operacion' where b.estatus in (5,6);");
==> this one is nor working st.executeUpdate("UPDATE terminales_temporal c inner join (SELECT d.terminal,DATEDIFF('"+fecha+"',d.fecha_alta) as FA FROM terminales_temporal as d WHERE d.con_mov IS NULL AND d.estatus IS NULL AND d.fecha_primer_mov IS NULL) as e on c.terminal = c.terminal SET c.estatus=1, c.descripcion_estatus = 'Sin Start' WHERE e.FA >=0;"); <====
st.executeUpdate("UPDATE terminales_temporal a inner join (SELECT terminal FROM terminales_temporal WHERE con_mov IS NULL AND fecha_cancel<>'0000-00-00') b on a.terminal = b.terminal SET estatus=7, descripcion_estatus='Cancelada';");

Any advice will be very apreciated, I don't know what else to show you.

Accessing MySQL database through EJB and JPA entity and Assigning Security Control (no replies)

Victor Ronda — Tue, 12 Mar 2013 10:52:58 +0000

Dear All. Good day! I trust this catches you well.

I am developing an EJB application, a project here in my company. Because this is the very first time we work with EJBs I can't help but have 2 important questions, about which your kind assistance is highly appreciated.

(1) How can I insert data in database tables by calling the EJB from a Java SE client main method? By way of test I wrote a simple EJB and Java code. Here is the snippet:

@Stateless
public class insertRecordBean implements insertRecordRemote {

@PersistenceContext(unitName = "EJBDB-ejbPU")
private EntityManager em;

@TransactionAttribute(TransactionAttributeType.REQUIRED)
public void createTest(int id, String name) {

em.getTransaction().begin();
Testejb ts = new Testejb();
ts.setTId(id);
ts.setNome(name);
em.persist(ts);

and Java client main method:

public class Main {
@EJB
private static insertRecordRemote insertRecordBean;

@Resource
static UserTransaction ut;

/**
* @param args the command line arguments
*/
public static void main(String[] args) {
// TODO code application logic here
System.out.println("Establishing connection to the bean...");
try{

InitialContext initialContext = new InitialContext();
insertRecordBean = (insertRecordRemote) initialContext.lookup
("server.insertRecordRemote");

ut.begin();

int id = 2;
String nome = "Flavia";

insertRecordBean.createTest(id, nome);
ut.commit();

// End of code snippets

A call similar to the above results in a simple EJB that does not access mysql db. What is missing,please?

(2) Each Java client will access some tables on the mysql db, with some privileges. If they were accessing the database from, say, mysql command-line shell they would have to enter username and password. How can I do a similar authentication in the java client main method? so that a user enters his credentials before doing any operations?

Looking forward to hear from you,
Thanks a million,
Victor

Classes in Java (no replies)

helen786 Angel — Thu, 21 Feb 2013 06:04:57 +0000

Can anyone share how Java classes are helpful in mobile technology? I want to do a project in Java and want to introduce mobile technology in Java. Share your ideas about this project.

detect datetime's precision (no replies)

Ben Zhou — Sat, 16 Feb 2013 20:38:40 +0000

Anybody knows how to use resultsetmetadata to detect a table's column's datetime precision?

e.g. I have a table 'A', and table 'A' has a column 'login', which is datetime type. I want to use resultsetmetadata in my java application to see if the 'login' column has been defined as datetime or datetime(6).

By the way, datetime (0-6) is supportted from mysql 5.6.4

Thanks,
Ben

Zero results returned when results expected (1 reply)

Tarran Benson-West — Fri, 18 Jan 2013 20:01:40 +0000

Hey guys,

We are currently experiencing an issue in our production environment whereby we are seeing queries being returned with zero results when there should always be at least one row returned.

The query is incredibly simple:

SELECT * FROM TABLE WHERE ID = ?;

We have set up some simple test java apps to isolate the issue from our application layer and to test for different scenarios such as using different connection pools / drivers etc and different configurations.

We are running mysql 5.6.5m8 but this was also an issue in our old 5.1 percona release.

There doesn't seem to be any trend to this and it doesn't appear to coincide with any of our other processes.

On the test box we are executing the query every 50ms and have 12 different java test apps running the same query.

I turned on the slow_query_log and set it to log all queries that take less than one microsecond to complete, however when I did this the issue seemed to go away. Perhaps slowing down the server introduced a 'fix' to the issue. I am now testing again with the slow_query_log turned off. (this had been running for a few hours with the slow log off and I haven't seen any zero results since the change).

The mysql box is running on innodb, has 12GB of ram and 16 cores. It is a 64-bit environment.

The table I am querying has 1.9m rows but is indexed and normally returns a resultset in under a second.

The box also isn't under any load apart from the testing that is being carried out.

Any ideas on this would be appreciated as I'm stumped right now?

i want make java application (no replies)

oth tah — Thu, 13 Dec 2012 06:44:30 +0000

i want make java application and i want to konw how i do it
i want make it licke this site : http://www.arbsb.com

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed (1 reply)

Praveen Kumar — Tue, 11 Dec 2012 16:01:50 +0000

Hi i am getting the following error sometimes. What does it mean?

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2631)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1548)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1659)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3112)
at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5209)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.begin(LocalManagedConnection.java:135)
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:650)
at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1196)
at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:649)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:437)
at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:323)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:502)
.
.
.
.

** END NESTED EXCEPTION **

Last packet sent to the server was 16 ms ago.

STACKTRACE:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2631)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1548)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1659)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3112)
at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5209)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.begin(LocalManagedConnection.java:135)
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:650)
at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1196)
at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:649)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:437)
at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:323)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:502)
.
.
.
.

Dot NET Failure Error (1 reply)

Jugal Thakkar — Tue, 11 Dec 2012 16:03:15 +0000

I was using MySQL WorkBench 5.2 from many months....
Suddenly Some Error Occured and Stop Responding for Starting....
Now it is not Starting.....
I had Un-installed it and Re-Installed it From Computer....

Also Debugger wont find anything for the same.....

Help Me on this........
Thanks In Advance....

Jugal

Java Class Diagram to MySQL Database Table Help (1 reply)

Kevin Khan — Fri, 16 Nov 2012 02:51:14 +0000

Please see this link http://djhirecork.com/project/classDiagram.jpg for a class diagram that i have created. I am looking to design a normalised database for this project that i am doing for college.

Here is what i have come up with so far.
Can anyone tell me if this is correct or not?

Dj Booking table
id
customerID
venue
Price
eventDate
StartTime
FinishTime
dateOfBooking
PlaylistURL
Occasion
BookingType
Note Status

Equipment Booking table
customerID
Price
venue
status
dateOfBooking
BookingType
Note
Status
Category
equipmentReturned
needsToBeDroppedOf
EquipmentIDs

Customer Table
name
contactNo
address
email
sourceOfContact
dateOfContact

DJ Table
name
contactNo
address
email
sourceOfContact
dateOfContact

Corporate Customer Table
name
contactNo
address
email
sourceOfContact
dateOfContact
companyName

EquipmentTable
name
category (should i have another table called category and have this field categoryid???)
price
dateOfPurchase
serielNumber
operational

sql query issue (1 reply)

Suleman Butt — Fri, 12 Oct 2012 16:39:11 +0000

Hi all,
I am finding it difficult to build one mysql query.

I have a table messages_stats_analysis_ota, with 4 columns: [brand_code, date_time_from, date_time_to, success_count].

I want the value inside 'success_count' against individual 'brand_code', which lie within the last 7 days from the current date.

u2, 01.10.2012, 07.10.2012, 100
u2, 02.10.2012, 08.10.2012, 100
u2, 03.10.2012, 07.10.2012, 100
u2, 08.10.2012, 14.10.2012, 50
fr, 01.10.2012, 07.10.2012, 200

Now lets assume, the current date is 08.10.2012.

I want only the follwoing 2 rows to be retrieved:

u2, 01.10.2012, 07.10.2012, 100
fr, 01.10.2012, 07.10.2012, 200

I tried to build this query:

SELECT * FROM messages_stats_analysis_ota WHERE date_time_from >= DATE_SUB(CURDATE(), INTERVAL 7 DAY);

but it gives me, the follwoing, which i dont want:

u2, 01.10.2012, 07.10.2012, 100
u2, 02.10.2012, 08.10.2012, 100
u2, 03.10.2012, 07.10.2012, 100
fr, 01.10.2012, 07.10.2012, 200

Assumtpion is current date is: 08.10.2012.

Coudl someone please help me out?

Thanks.

Resource 'kill.exe' not found (no replies)

Alex Barchuk — Tue, 18 Sep 2012 09:17:26 +0000

I need to use mxj library for an embedded database.
I get an exception when use mysql-connector-mxj-5.0.12.jar.
There is an exception when I call the shutdown() method from MysqldResource:

Exception in thread "main" java.util.MissingResourceException: Resource 'kill.exe' not found
at com.mysql.management.util.Streams.getResourceAsStream(Streams.java:124)
at com.mysql.management.util.Streams.getResourceAsStream(Streams.java:108)
at com.mysql.management.util.Streams$1.inner(Streams.java:140)
at com.mysql.management.util.Exceptions$VoidBlock.exec(Exceptions.java:129)
at com.mysql.management.util.Streams.createFileFromResource(Streams.java:153)
at com.mysql.management.util.ProcessUtil.getWindowsKillFile(ProcessUtil.java:71)
at com.mysql.management.util.ProcessUtil.(ProcessUtil.java:60)
at com.mysql.management.MysqldResource.issueNormalKill(MysqldResource.java:385)
at com.mysql.management.MysqldResource.shutdown(MysqldResource.java:316)
at com.mysql.management.driverlaunched.ServerLauncherSocketFactory.shutdown(ServerLauncherSocketFactory.java:219)
at com.mysql.management.driverlaunched.ServerLauncherSocketFactory.shutdown(ServerLauncherSocketFactory.java:210)
at coza.healthbridge.collections.ConnectorMXJUrlTestExample.main(ConnectorMXJUrlTestExample.java:47)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:120)

I looked through the old versions of mysql-connector-mxj and there is 'kill.exe' file in jar.
Why there is no 'kill.exe' file in mysql-connector-mxj-5.0.12.jar?

Java access to native MySQL Geometry (no replies)

Simon Greener — Wed, 29 Aug 2012 23:34:05 +0000

Folks,

Not sure where to ask this question.

If anyone can point me to better places to do so...

I am investigating whether it is possible to access MySQL's GEOMETRY data natively via Java. I do not wish to access the data via WKT or WKB if I can avoid it.

Does anyone know of any open source Java resources that could help me do this?

regards
Simon

Are there MySQL versions which are more robust and suitable for a multi-threaded Java EE, Hibernate and Ehcache application? (3 replies)

Lars Gustafsson — Thu, 30 Aug 2012 17:08:55 +0000

Are there MySQL versions which are more robust and suitable for a multi-threaded Java EE, Hibernate and Ehcache application? The Servletcontainer is Jetty.
Right now I think we're using MySQL v5.1.50 under FreeBSD and I'm getting:
********************************************************************************
********************************************************************************
********************************************************************************
********************************************************************************
2011-09-05 16:55:18,350 WARN [org.hibernate.util.JDBCExceptionReporter] -
2011-09-05 16:55:18,350 ERROR [org.hibernate.util.JDBCExceptionReporter] -
2011-09-05 16:55:18,352 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] -
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:304)
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:198)
at $Proxy38.flush(Unknown Source)

******************************************************************************
******************************************************************************
******************************************************************************
******************************************************************************
AND

2011-06-23 11:19:25,910 ERROR [org.hibernate.util.JDBCExceptionReporter] -
2011-06-23 11:19:25,967 ERROR [adx.main] -
javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:226)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:198)
at $Proxy37.persist(Unknown Source)
********************************************************************************
********************************************************************************
********************************************************************************
********************************************************************************
Every now and then and I'm having to restart the mysql server. That used to fix it. But now I'm getting more and more of it. A cell in the database gets corrupt and merely trying to alter the contents of that row it in PhpMyAdmin doesn't work. It tries for a long time and then exits with an errormessage. After a restart of the mysql-server it usually works. Now I'm getting more and more of these incidents. Now even the single threaded Java EE servlet are experiencing these problems. We have 2 different physical servers running Java EE Webapplications against the same MySQL server. Synchronization in the sense of one Hibernate cache not knowing that a row has been modified by the other Java server or PHP has not been an issue. A dirty flag is set and everyone knows that the row is dirty.

Will upgrading to MySQL v5.5 solve these problems? Or are there other more robust versions of MySQL?

Communications link failure (18 replies)

Dionisio Agouarakis — Sat, 06 Apr 2013 01:10:27 +0000

Hi all!

I'm having quite a hard time setting up my project connection with mysql. I did it all the usual way, installed the jdk, mysql (the proper version according to my OS) and added the jar file to my eclipse/netbeans (tried both) IDE.

The workbench works just fine, without any problems. I'm able to connect, create tables, make queries and the like. - OK

The console works too, I am able to connect to the DB, use a show tables command, create tables, etc. - OK

My JDBC connection DOES NOT WORK in any way. I just wrote the standard connection factory code, it succeeds with the driver, Class.forName("com.mysql.jdbc.Driver"), but it fails when it comes to run the getConnection.

I am using:

getConnection(url,user,password)

url = "jdbc:mysql://localhost:3306/teste";
user = "root"
password = my password

it returns:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsExceptions: Communications link Failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

My system specs:

Windos 7 - 64
Java 1.7
mysql 5.5.27

Thanks!!

Getting "javax.net.ssl.SSLException: Unsupported record version Unknown-0.0" (no replies)

Vishal Bansod — Tue, 31 Jul 2012 04:50:13 +0000

I'm trying to connect to MySQL server using JDBC client using TLSv1.

JDBC URL:
jdbc:mysql://server_IP:3306/test?noDatetimeStringSync=true&useSSL=true

MySQL server:
5.5.25a community edition

Connector Used:
mysql-connector-java-5.1.21-bin.jar

Certificates used:
self signed certs created using OpenSSL on linux box

Resulting exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 84 milliseconds ago. The last packet sent successfully to the server was 82 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:105)
at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:5126)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1666)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1244)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2397)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2430)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2215)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:813)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
.
.
.
.
.
.
.
Caused by: javax.net.ssl.SSLException: Unsupported record version Unknown-0.0
at com.sun.net.ssl.internal.ssl.InputRecord.readV3Record(Unknown Source)
at com.sun.net.ssl.internal.ssl.InputRecord.read(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.waitForClose(Unknown Source)
at com.sun.net.ssl.internal.ssl.HandshakeOutStream.flush(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.sendChangeCipherSpec(Unknown Source)
at com.sun.net.ssl.internal.ssl.ClientHandshaker.sendChangeCipherAndFinish(Unknown Source)
at com.sun.net.ssl.internal.ssl.ClientHandshaker.serverHelloDone(Unknown Source)
at com.sun.net.ssl.internal.ssl.ClientHandshaker.processMessage(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.processLoop(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.process_record(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:90)
... 37 more

I have seen many bugs releted to this exception and many have status as fixed. But I'm still getting this exception.

Here is the network log captured on MySQL server machine using MS Network Monitor

mysqld.exe 164.99.135.140 164.99.135.57 TLS TLS:TLS Rec Layer-1 HandShake: Client Hello. {TLS:5458, SSLVersionSelector:5457, TCP:5454, IPv4:15}
mysqld.exe 164.99.135.140 164.99.135.57 TLS TLS:TLS Rec Layer-1 HandShake: Certificate. Client Key Exchange. {TLS:5458, SSLVersionSelector:5457, TCP:5454, IPv4:15}
mysqld.exe 164.99.135.140 164.99.135.57 TLS TLS:TLS Rec Layer-1 HandShake: Certificate Verify. {TLS:5458, SSLVersionSelector:5457, TCP:5454, IPv4:15}
mysqld.exe 164.99.135.140 164.99.135.57 TLS TLS:TLS Rec Layer-1 Cipher Change Spec {TLS:5461, SSLVersionSelector:5460, TCP:5459, IPv4:15}

MySql Notifications (3 replies)

Ivan Acog — Mon, 23 Jul 2012 16:50:31 +0000

Good day!
I am developing an application that uses java and mysql as back end. My problem is, I want the application to be notified when changes to the database occurs. I google this many times and found some answers like using JMS and others. I need some help how to obtain this functionality.

JPA Error when new entities added without drop andcreate (1 reply)

Buddhika Ariyaratne — Tue, 29 May 2012 16:01:48 +0000

I am developing a J2EE application with JSF, EclipseLink2 as JPA installation and mySQL as the back-end database with Netbeans. Application works fine except when I add new attributes to existing entities, or create new Entities. If I select the dropandcreate option in Persistance.xml file, the application runs again without errors, but it deletes the whole data base with previous entries. When I go to production, I can not afford to lose data of the database when I add a new entity. Is there any way to overcome this. I tried to use a database schema, but could not figure how to do it. Thanks in advance.

Text type bugs javascript, varchar is fine (1 reply)

ddl449 ddl449 — Tue, 29 May 2012 16:08:51 +0000

Hi, Newbie here

I have integrated a php loop inside a javascript so as I get different results from the database.

The problem is when I choose "text" in the database for a row and it has a different "row", the javascript doesn't run.

Namely:
I choose "text" or "varchar" as type and inside the cell i have the following:
"some text here"
The script will work

If I have "text" type and inside the cell:
"some
text
here"
That will not make the javascript run

The problem seems to be the change in "row"
Can you please explain me why this is happening? (or just link me to some revelant documentation)
And of course how can this be fixed?

Thanks

Cannot create JDBC driver of class '' for connect URL 'null' (2 replies)

Feliks Berig — Tue, 26 Jun 2012 09:23:52 +0000

Hi All.

I am new to MySQL. I am developing java application using Tomcat server(7) and trying to connect to MySQL DB.

here is my code in Context.xml:
maxActive="100" maxIdle="30" maxWait="10000" username="bruser" password="bruser123"
driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/businessreferral"/>

Also the code in Web.xml:
MySQL Test App

DB Connection

jdbc/businessreferral

javax.sql.DataSource

Container

Also I coppied mysql-connector-java-5.1.19-bin.jar to Tomcat lib folder.
And Finally here my code:

try {
initCtx = new InitialContext();
DataSource ds = (DataSource) initCtx.lookup( "java:/comp/env/jdbc/businessreferral" );
Connection conn = ds.getConnection();
...... }

And I getting ecception on ds.getConection().

Can you please point what I am doing wrong?

Thank you,
Feliks.

Search in mysql db (no replies)

Siddharth Das — Fri, 13 Apr 2012 15:22:51 +0000

I'm implementing a shopping website similar to ebay, i can'r understand how to proceed for the search function in the website where i need to search the keyword specified by user, I'm using mysql database, but the table structure is dynamic based on categories and subcategories added by the admin user, so i don't know the table name and table structure then how can i implement the search functionality.
I'm using Struts 2 As platform

Guidance on making a 'Track and Trace' application (no replies)

Fahad Hassan — Fri, 30 Mar 2012 05:31:04 +0000

I have to create a 'Track and Trace' application for a company and now I am stuck in the middle of the whole process. The application, which will be put up on the websites front page, will be like this that a visitor will enter his/her tracking number in the application and then click on the 'submit' button. Next, the visitor will be redirected to a new page and all the data that has been stored in the MySQL database according to that tracking number will be shown to him. My first question is that, how can I create such an application? I am already done with creating the MySQL database. Also, I have installed this software called Netbeans IDE using which we can create JAVA Applications and it sort of looks promising to me. Can I create a 'Track and Trace' application using Netbeans IDE? Secondly, how can I connect my MySQL database to the application which will be created? Please help me as soon as poosible. Thanks.

P.S An example of the 'Track & Trace' application can be seen on this website http://www.seagoldlimited.com/ (right side).

Java fax - help? (no replies)

Suzanne Williams — Mon, 26 Mar 2012 14:57:35 +0000

Hi all, I have a question regarding java fax in SQL. There are some services that enable you to code a simple fax send/receive service for a fee. I find myself in the occasional need of sending or receiving a fax, and I thought whether I can use java - with or without SQL - can enable me to do so (obviously, for no charge).

Thanks for any comments. I'm self-taught so I might be confusing things...

Communications link failure error in mysql 5.1 (3 replies)

Jeetendra Garg — Mon, 26 Mar 2012 18:27:55 +0000

Hi,

I am using mysql 5.1 with my java application. Once in a day I get this error, whenever I access the application after a long interval(few hours). Let say, my last hit to database through application was in the night and in the next morning I access the application again, I get this error

----------------------------------------------------------
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 1 ms ago.
----------------------------------------------------------

I changed the interactive_timeout variable to from 8 hours to 24 hours, but it did not work.

Can anyone provide me the solution for this?

Thanks in advance.
Jeetendra

I have stored an image in MYSQL using the BLOG datatype. I am able to retrieve image from JSP but when I use CHROME r FIREFOX browser I am unable to view the IMAGE. It is displaying in an encrypted format. (1 reply)

venkat santosh — Fri, 10 Feb 2012 16:31:14 +0000

I have stored an image in MYSQL using the BLOG datatype. I am able to
retrieve image from JSP but when I use CHROME r FIREFOX browser I am
unable to view the IMAGE. It is displaying in an encrypted format.

Stored Procedures + multiple Clients (no replies)

Marco Hübers — Mon, 19 Dec 2011 14:57:00 +0000

Hello,

actually i got trouble with Stored Procedures.
i made a program in java which runs for 10 minutes and calls a stored procedure by a callablestatement (cs.execute() and direct commit each loop)

this program is run from two clients where each client runs the program 5 times simultaneously. unless i commit every loop iteration i get deadlocks! but if a commit everytime the performance is equal to normal statements...

so.. how do i increase the performance with stored procedures (obviously for 1 client its faster when i do just one commit, but for multiple clients there will be deadlocks)

thank you for help, if u need database informations or something just ask!

i need a scrip can any onehelp me (no replies)

abdo boutahar — Fri, 09 Dec 2011 13:48:44 +0000

hey every body i made a new blog on blogger its about windows 8
you can see it here : http://full-windows8.blogspot.com/

fir this i need a scrip can let make a banner from my blog and give it to odeers to put it in there bligs....can any one do it for me plz

No suitable driver ... (1 reply)

Andrew Coleman — Mon, 30 Jan 2012 08:37:39 +0000

Running an application from NetBeans consistently gives "No suitable driver found for jdbc:mysql://localhost:3306/csc224".

Accessing the database csc224 through the same driver name in NetBeans Services window works fine.

Application project libraries show the driver as being present.

Any suggestions about what's missing appreciated ...

No suitable driver found (8 replies)

Rasmikanta Guru — Thu, 10 Nov 2011 04:21:03 +0000

Hi,
can any solve this
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/glink
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
st.hib.RetrieverServlet.doGet(RetrieverServlet.java:27)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96

web and software development (no replies)

himanshu manshu — Tue, 08 Nov 2011 05:54:07 +0000

N-Xperts Solutions is Premier company that provide Website Designing,Website Designing Rajkot,Java J2EE Development,Offshore Development,Web Design,Web Design Rajkot,Iphone Apps. Development Rajkot,Web Development,Web Development Company Rajkot,Offshore Development,PHP Web Development Rajkot,.Net Web Development Rajkot,Java Web Development Rajkot,Gujarat,India,Rajkot

for more information please visit http://www.nxsol.com

MySQL Query with 2 database on multiple servers (1 reply)

ppk ppk — Tue, 08 Nov 2011 21:37:43 +0000

Hi,

I have a requirement in which I need to select tables (data) from one MySQL database on one server and insert into a large number of similar databases on N number of servers (more than 100).

Is there any way to write such a query. This is what I want to write (or end result to be)

REPLACE INTO server1.db1.table SELECT * FROM centralserver.db2.table WHERE db2.timestamp1 > db2.timestamp2

This will select all rows from db2 based on a condition and insert into db1.

server1 can be upto 100 and i will write a dynamic query for that. But I just want to know how to achieve this.

federated table may be an option, but not sure how it will work on 100 servers.

kindly help!!!!