Message from mrs Most recent post: 1/28/2007 2 authors and 2 replies. ------=_Part_28322_17747153.1169134878979 GOOD NEWS! DO CONTACT ALAN J. BREWER We are glad to inform you that your E-mail address appears as the confirmed Winner of our last [E.U.I.L] email lottery program held on the 17th of January. 2007. Your e-mail address attached to Reference number SLUK-216-365-787 lucky numbers 32-15-54-35-47, which consequently won in the 2nd category. You've therefore been approved for a lump sum payment of EUR 500.000 Euros. [Five hundred thousand euros only] CONGRATULATIONS!!! This draw is sponsored by Microsoft managements to encourage our customers for using our products and services. This promotional program takes place every year. All participants were selected through Microsoft computer ballot system from over 200,000 companies and 50,000, 000 individual email addresses and names from all over the world. In order to avoid unnecessary delays and complications please remember to quote your reference number and lucky numbers in all correspondence. We ask that you should keep your winning information confidential until your claim has been processed and your money remitted to you. To file for your claim or for further details please contact our agent: CONTACT NAME: Alan J. Brewer FREE SERVICE NUMBER: 0031-619-134-645 EMAIL: claimdirectorc@xxxxxxxxxxx In respect of our commitment towards helping the less privileged, we ask that you voluntarily contribute 1% of your Global winnings to any charity organization yo read more about GOOD NEWS! DO CONTACT ALAN J. BREWER
Message from ProgDario Most recent post: 9/19/2006 2 authors and 6 replies. Hi, I'm using JAVA 5 with connector/j 3.1.13. I've a stupid query with two string parameters. When I set the parameters and execute the query, it simply does not work, and the worst is that it does not show throw any exceptions. The result set is empty. If I do not use the preparedstatement, it works. I'm really get frustrated with this. Any hint?Thanks!!Dario read more about Connector/j PreparedStatement DOESn't work
Message from Doug Most recent post: 3/9/2006 2 authors and 2 replies. Hello I can not believe it at the whole thimg. Trying to establish a connection. Clearly I am doing something wwrong. here it is I've a jar file I am trying to execute. It contains : Class-Path: /home/dkr/lib/jdom.jar /home/dkr/lib/mysql-connector-JAVA-3.0.17-ga-bin.jar Which finds the jdom.jar but return : class not found JAVA.lang.ClassNotFoundException: org/gjt/mm/mysql/Driver.class When I run: Class.forName(Parameters.getDbmDriver ()); Any body out there have any idea how I ****** this u? Thanks for your time. dkr read more about trying to "connect"
Message from rdifalco Most recent post: 2/25/2006 2 authors and 2 replies. Is there a way to lift the restriction on how much data can be written to a LOB in MySQL from JDBC? R.-- MySQL JAVA Mailing List For list archives: http://lists.mysql.com/JAVA To unsubscribe: http://lists.mysql.com/JAVA?unsub=3Dmysql-JAVA@xxxxxxxxxxx read more about DataTrunctation error when BLOB/CLOB greater than 64K
Message from "CalAmity!" Most recent post: 2/17/2006 2 authors and 6 replies. Scenario: ========= Data Query --------> --------> [Web Brower] [Apache Tomcat] [mySQL] <-------- <-------- Display Results* Web Server hosts servlets and JSP. * Web browser connects to Web Server fetches query parametrs from the user. * Once parameters are submitted, Data is sent to WebServer. * Webserver runs servlets write an appropriate query and fetch data from mySQL. * Result is displayed on user's browser.Question: ========= The table I query is a Downloads Log. So for some queries a very large amount of data may be returned (say about 800- 1000 rows). I need to display this data systematically 50 records at a time in the web browser. If anyone out there a solution to this problem then please reply back. Thanks in advance :) read more about Handling numerous rows from SQL query
Message from pwallace Most recent post: 11/11/2005 2 authors and 2 replies. ------_=_NextPart_001_01C5B735.E89B9367 Hi, I am having trouble inserting and retrieving Asian characters in my DB. I've set up my table thus: =20 CREATE TABLE `messages` ( `id` int(10) unsigned NOT NULL auto_increment, `message_body` text NOT NULL, `sender_number` text NOT NULL, `shortcode` text NOT NULL, `image` longblob, PRIMARY KEY (`id`) ) CHARACTER SET utf8 TYPE=3DMyISAM;=20 =20 and am inserting using a PreparedStatement - pstmt.setString(indexOfColumnInQuestion, asianTextString); to insert in to message_body. However, when viewing the column in Query Browser, and retrieving it from a ResultSet, it reads ????????????? ??? ???? and so on (I am attempting to insert Thai characters in this instance). =20 Am I not doing all to spec? =20 thanks and regards =20 Paul. ------_=_NextPart_001_01C5B735.E89B9367-- read more about Unicode insertion in 4.1
Message from gokhan.demir Most recent post: 4/22/2005 2 authors and 2 replies. Hi, I've just downloaded the mysql 3.1.8 driver. After reading the manual, I have seen that I can use the new, specific exception sorter and connection validity checkers classes for JBoss. Since com.mysql.jdbc.integration.jboss package isn't in the 3.1.8 jar file, I manually added the two jboss specific classes to the jar and then updated my connection cache xml file to reference the two classes. On start, JBoss complains that it cannot find the classes although I doubly made sure I've correctly put the two classes in the 3.1.8 jar file and copied it to the correct jboss servername/lib folder. What am I doing wrong and hence failing to make this work? Best Regards, Gokhan P.S.: Here is part of what is logged by JBoss 4.0.1sp1 startup: 17:57:04,039 WARN [LocalManagedConnectionFactory] Exception trying to create connection checker (disabling): JAVA.lang.ClassNotFoundException: No ClassLoaders found for: com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker at org.jboss.mx.loading.LoadMgr3.beginLoadTask(LoadMgr3.JAVA:198) at org.jboss.mx.loading.RepositoryClassLoader.loadClassImpl(RepositoryClassLoad er.JAVA:464) at org.jboss.mx.loading.RepositoryClassLoader.loadClass(RepositoryClassLoader.j ava:374) at JAVA.lang.ClassLoader.loadClass(ClassLoader.JAVA:235) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidC onnection(BaseWrapperManagedCon read more about 3.1.8 and JBoss exception sorter & validity checker classes
Message from ankush1711 Most recent post: 2/22/2005 2 authors and 2 replies. Hey, We are trying to use mysql with Jdeveloper(9.0) build.When ever we try to run the jdeveloper to execute the program we get the following error. Error creating table: You've an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '@xxxxxxxxxxx (autoid BIGINT not null primary ) The user has the right to access the database from any machine in the LANand also we've created primary key on the table but the problem persists..What changes we've to make so that we are able to execute programs in jdeveloper accessing mysql database. Mysql is on debian and I can access the same database with query browser and even the connection with jdeveloper shows success. Thanks & Regards Ankush Grover -- MySQL JAVA Mailing List For list archives: http://lists.mysql.com/JAVA To unsubscribe: http://lists.mysql.com/JAVA?unsub=mysql-JAVA@xxxxxxxxxxx read more about mysql + jdeveloper
Message from axelmuench Most recent post: 2/9/2005 2 authors and 2 replies. Hi, Since we upgraded our staging server from Connector/J 3.0.14+ to Connector/J 3.1.16 ( on mysql 4.1.17) we receive for any SQL PreparedStatements ending in "LIMIT ?,?" a JAVA.sql.SQLException: You've an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?,?' at line 1 Example: private static final String PRODUCT_BY_RANGE_LIMIT = "SELECT * FROM Product LIMIT ?,?"; ~cut prepStmt.setInt(1, index); prepStmt.setInt(1, range); ~cut Anybody else came across this problem? Thanks, Axel-- MySQL JAVA Mailing List For list archives: http://lists.mysql.com/JAVA To unsubscribe: http://lists.mysql.com/JAVA?unsub=mysql-JAVA@xxxxxxxxxxx read more about Connector/J 3.1.16 LIMIT Exception
Message from lbrtchx Most recent post: 6/17/2004 5 authors and 5 replies. Hi, I, as a JAVA developer, find myself constantly switching among different DBMS. The JDBC easies it greatly, but I am thinking about a Portable DATA Layer kind of functionality to aliviate the problems when you must do that. Notice I am not talking aobut connection pooling or persistence manager! Here are some of the problems I'd like to rid of my mind: 1._ A change of DBMS should only require a one-line change in a properties files DataLayer DL = new DataLayer("_.propeties"); 2._ SQL statements should be declared outside the code entirely, so that admin people and DBAs can look at the damage we devs are doing :-) 3._ Changes in the SQL statements ('We' constantly change the Data Tables and Structures during dev) I do not want to have to touch the code if I change the Data layer. Say, a new column is included in the Table 4._ I'd love to query a DBMS like you call a method, without having to worry about getInt's, and getString's things; something like: ResultSetRecordsObjs[] RSO02 = DL.preparedStat("SELECT ...").getRecordObjects(); Then you'd simply go: . Request.setAttribute("RSO02Ar", RSO02); . grab the array of objects containing the returned records information in a jSP and display the results. Notice that only the JSP would've to be changed possibly by a knowledgable designer. Do you know of something like that already out there (preferably open source :-))? read more about Portable JAVA Data Layer based on JDBC
Message from lbrtchx Most recent post: 5/3/2004 4 authors and 5 replies. I was wondering about ways to kinda standardize the non SQL92 compliant MySQL-specific "LIMIT" clause http://dev.mysql.com/doc/ with JDBC. Say you only need to SELECT a given number of records at a time. I think (and I am NOT a DB speciallist) that you ease the DB engine's work if you just tell it: 'I only need the next 3 records'; since it might optimally be a one-time operation. Maybe this is very QOI (quality of implementation) issue, but I think, if you iterate over a ResultSet object and then break out of the look when you've the number of records you need you might tax the DB eng. more than if you just tell it how many records you need beforehand. Am I correct? Are there ways to stream line this other than simply using MySQL or a DB that supports it :-)? What'd you suggest? read more about MySQL's LIMIT with JDBC
Message from mufaddal Most recent post: 1/28/2004 2 authors and 2 replies. --Apple-Mail-1-197792120 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Hi, I am using mysql-connector-JAVA-3.0.8-stable-bin.jar and mysql version 4.0.16. I am using the connection pooling mechanism to create connections to 3 databases. (30 connections each .. therefore 90 connections total.) When I try to increase this to 50 connections per database I get exceptions that there are too many connections. Is there a way to tell mysql to allow 1. unlimited amount of connections OR 2. a particular number of connections. I used mysqld --help and saw that the: max_connections 100 max_tmp_tables 32 max_user_connections 0 So how do I increase or make the number of connections unlimited? Also if this is possible what other values do I've to adjust? Thanks. --Apple-Mail-1-197792120-- read more about Number of connections ... how to increase?
Message from chitrapandian Most recent post: 1/25/2004 2 authors and 2 replies. We are facing problem in starting mysql [MySQL 3.23.58] in Solaris 8 platform and exception is thrown 'Fatal error: can not change to run as user 'mysql' ; Please check that the user exists!'. I've tried using using either root or specific user. If I check MySQL logs by viewing /opt/mysql/data/<hostname>.err040119 09:34:32 mysqld started Fatal error: can not change to run as user 'mysql' ; Please check that the user exists! 040119 9:34:32 Aborting 040119 9:34:32 /opt/mysql/bin/mysqld: Shutdown Complete 040119 09:34:32 mysqld endedI have tried several times to install it, but still get the same error. Any clue on that problem ?Any help to solve this problem is really appreciated. Regards, Chithuu ..! read more about [SOLARIS - MySQL 3.23.58] Fatal error: can not change to run as user 'mysql' ;
Message from mufaddal Most recent post: 1/22/2004 2 authors and 2 replies. Select * from user where username = 'Alex'; The above query'd return a result set in which alex, ALEX, Alex , aLEx etc appears. In other words its not a case sensitive operation. What do I do in order to make a case sensitive comparison? Thanks.-- MySQL JAVA Mailing List For list archives: http://lists.mysql.com/JAVA To unsubscribe: http://lists.mysql.com/JAVA?unsub=mysql-JAVA@xxxxxxxxxxx read more about case sensitive comparison ?
Message from lopes Most recent post: 1/22/2004 2 authors and 2 replies. I'm trying to make an updatable JdbcRowSet, I already read a previuos question in this mailing list and follow the sugested items but I cant make it work. my table has a primary key, in my select statement I only select one table (no joins), I force the JdbcRowSet to be CONCUR_UPDATABLE but it doesnt work. What I would like is somebody tell me what an I doing wrong, give an example or tell me wich class do I have to hack, patch or something like that to make it create an updatable resulset by default like 2.x driver did. (i know this isn't jdbc compilant) My code is: Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1/adatabase","root",""); rowset = new JdbcRowSetImpl(conn); rowset.setType(ResultSet.TYPE_SCROLL_SENSITIVE); rowset.setConcurrency(ResultSet.CONCUR_UPDATABLE); rowset.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); rowset.setCommand("SELECT * FROM atable"); rowset.execute(); rowset.moveToInsertRow(); In the last line I get the Exception: Result Set not updatable.This result set must come from a statement that was cre ated with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, and must select all primary keys from that table. See the JDBC 2.1 API (application programming interface)Specification, section 5.6 for more details. But I set the JdbcRowSet to ResultSet.CONCUR_UPDATABLE, my query slect only one table, m read more about Updatable JdbcRowSet
Message from kate Most recent post: 12/30/2003 2 authors and 2 replies. ------_=_NextPart_001_01C3CE75.536836A0 Content-Type: text/plain; charset="iso-8859-1" MySql Version: 4.1.1-alpha MySql Connector/J Version: 3.0.9-stable I was using 4.0 before, and I was able to connect using JDBC. I switched to 4.1 alpha, and I'm getting the following exception: ConnectionFailure: JAVA.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user: <mailto:'dba'@xxxxxxxxxxx'localhost'> 'dba'@xxxxxxxxxxx'localhost' (Using password: YES)" I created a user called dba: grant all privileges on mysql.* to 'dba' identified by 'dba'; I'm using the same exact JAVA code to connect as I was using with mysql version 4.0. Thanks for your help, Kate ------_=_NextPart_001_01C3CE75.536836A0-- read more about Access denied in 4.1.1
Message from chitrapandian Most recent post: 10/22/2003 2 authors and 2 replies. Dear All, Database product version=3.23.41 Database driver name=MySQL-AB JDBC Driver Database driver version=3.0.8-stable ( $Date: 2003/05/19 00:57:19 $, $Revision: 1.27.2.18 $ ) Our application is an Multi-Threaded JAVA based application and uses 6 MySQL connections to do various database transactions, and also we maintain PreparedStatement cache (200 per Connection), meaning we cache the PreparedStatement based on the SQL in a cache and use that cached PS for subsequent db operations. We are sure that, all are "SELECT" SQLs executed using executeQuery methos, no other SQLs and also Database Connection are in normal state only. Now, we are continously facing this after running our for 2-3 hrs., we aren't sure where the problem is, following are the various exceptions thrown continously and the complete database is corrupted with invalid data, now the only way to recover from this is to reinitialise and restart our application. This is an highly critical issue. Kindly, guide us to debug the problem @xxxxxxxxxxx the earliest. ----------------------------------------------- 22:33:39:995 PM JAVA.sql.SQLException: Column Index out of range ( 3 > 1). 22:33:39:995 PM at com.mysql.jdbc.ResultSet.getString(ResultSet.JAVA:1749) 22:33:39:995 PM at com.adventnet.nms.store.relational.RelationalObject$ForUserPropGet.fillUserProperties(RelationalObject.JAVA:1761) 22:33:39:995 PM at com.adventnet.nms.store.relational.RelationalObject.getObject(RelationalO read more about Exception : ResultSet is from UPDATE. No Data
Message from mufaddal Most recent post: 10/16/2003 2 authors and 2 replies. I had posted a message earlier yesterday and I realized that the result I was trying to get wont be the result of the query I was writing. Could someone help me on this please - I've table survey: +----+----------+---------+ | ID | NAME | ENABLED | +----+----------+---------+ | 1 | Survey1 | 1 | | 2 | Survey2 | 1 | | 3 | Survey3 | 1 | | 4 | Survey4 | 1 | | 5 | Survey5 | 1 | +----+----------+---------+ table res: +----+--------+------+------------------+ | ID | USERID | TYPE | SURVEYID | +----+--------+------+------------------+ | 1 | 1 | 1 | 1 | | 2 | 1 | 1 | 2 | | 3 | 1 | 1 | 3 | +----+--------+------+------------------+ I want all the survey records that follow the rule -- survey.id isn't in res.surveyId. For example considering the example data in the two tables, when I run the query the result should've (4, survey4, 1) and (5, survey5, 1). Could someone help me formulate the query ? Thanks.-- MySQL JAVA Mailing List For list archives: http://lists.mysql.com/JAVA To unsubscribe: http://lists.mysql.com/JAVA?unsub=mysql-JAVA@xxxxxxxxxxx read more about question ....
Message from Hengeltje Most recent post: 8/17/2003 2 authors and 2 replies. I'm just getting started and I already have a problem:( I inserted several rows by inserting an txt-file, but the tabs weren't correct. So I want to delete all rows in the table. Unfortunatelly I can not find information about how to delete the rows. Who can help me? read more about Delete row
Message from rhino1 Most recent post: 8/4/2003 2 authors and 2 replies. Can anyone sent me or point me to an example of a program that inserts a = file like a JPEG or GIF into a Blob column of a MySQL table via a JAVA = program? I've several years of experience with DB2 and can do this task in a = JAVA program that talks to DB2 but the same program, modified to insert = data into a MySQL table, does not seem to be working. There are no error = messages but when I look at the table row, instead of a long string of = hex digits, I get a few characters, like =FF=D8=FF=E0, and nothing else. = That makes me believe that my insert failed for some reason. If I look = at the DB2 table after I insert the same Blob, I get a long string of = hex digits like x'A9B4C3' .... etc. etc. Can anyone help me with a working example of inserting a Blob? That = should help me figure out what needs to be done differently for MySQL = than DB2. Or'd you prefer that I post my code so that you can help = me figure out what I'm doing incorrectly? Rhino --- rhino1 AT sympatico DOT ca "If you want the best seat in the house, you will have to move the cat." read more about Insert Blob Example