independent tables

2011-05-02 Thread Rocio Gomez Escribano
Everyone has his/her own driving license, and I need to know what kind of “person” (client or user) is. mysql> select userID, clientID from client, user where (clientCodeDrivingLicense= 321321321 || userCodeDrivingLicense = 321321321); ++---+ | userID | clientID | ++--

Re: problem

2011-05-02 Thread Carlos Proal
Swaroop: How are you handling the connections to db ? only one, with a pool, something adhoc ?. It looks like the connection is only one and expires after a time out and you get the error that there is no connection. Carlos On 5/2/2011 3:15 PM, Andrés Tello wrote: Seems more a java issue th

Re: problem

2011-05-02 Thread Andrés Tello
Seems more a java issue than a mysql issue... check for your parameters for any keepalive or persostent option... I think you wouldn't need to recompile just re-run or at leat, reboot the server.. On Mon, May 2, 2011 at 2:34 AM, swaroop jois wrote: > Hello friends, I have MySQL server versio

design question

2011-05-02 Thread shawn wilson
i'm just looking for rough ideas here... i've got a table that has 31 fields. most of them need to be there (entry time, exit time, entry lat, etc). however, i've got 4 fields that i query this db with that should generally be unique... well, really 3 fields that should be unique, because the 'nam

RE: Join based upon LIKE

2011-05-02 Thread Jerry Schwartz
>-Original Message- >From: Johan De Meersman [mailto:vegiv...@tuxera.be] >Sent: Sunday, May 01, 2011 4:01 AM >To: Jerry Schwartz >Cc: Jim McNeely; mysql mailing list >Subject: Re: Join based upon LIKE > > >- Original Message - >> From: "Jerry Schwartz" >> >> I shove those modified

problem

2011-05-02 Thread swaroop jois
Hello friends, I have  MySQL server version  " 5.0.51a-Ubuntu"  installed on Ubuntu 8.04 machine . I would describe briefly what we are doing . Basically we have built a server that listen to Gprs connection from client   and accepts data in form packets and inserts that data into MySQL database.I