Porting my gweMysql JDBC Driver(Type4) to C# Driver!!
Hi, All I ported my gweMysql JDBC Driver(Type4) to C# Driver. :-) If you are interested in C# Driver, please check it out!! http://www.t3-jpn.com/work/jdbc/jdbcmysql.html -- I love Borland. TAKAHASHI, KEN, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Porting my gweMysql JDBC Driver(Type4) to C# Driver!!
Sorry, URL is wrong Please check it out http://www.t3-jpn.com/jdbc/jdbcmysql.html "TAKAHASHI, Tomohiro" wrote: Hi, All I ported my gweMysql JDBC Driver(Type4) to C# Driver. :-) If you are interested in C# Driver, please check it out!! -- I love Borland. TAKAHASHI, KEN, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with Delphi 5.0
Hi, Did you use dbexpmysql.dll(not dbexpmys.dll) ? Alexander Burbello wrote: I tryed to use Delphi 6.0 and dbExpress, but I didn't got. What component and what property I have to set for use correct?? Regards Alexander -- Mensagem Original -- Hi, Haroldo Is it first time to develop Database Application with Delphi? Do you know how to use DataAccess Component(e.g., TDatabase) and BDE(or BDE Administrator)? I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component which help you to develop Database Application very easily. (Note: dbExpress is able to connect to MySQL server directly, using Native Driver without ODBC Driver) Thanks. -- Borland Japan / Consulting Group TAKAHASHI, "KEN", Tomohiro José Haroldo Filho wrote: I've installed MyODBC and then I've set up ODBC and I saw the driver for MySQL DB, when I try to create a new alias wiht MySQL it does not apear to select the DB, acording a book wich is guiding it should has to appear. Can anybody help to set up the ALIAS with MySQL Thanks -- TAKAHASHI, "KEN", Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with Delphi 5.0
Hi, Haroldo Is it first time to develop Database Application with Delphi? Do you know how to use DataAccess Component(e.g., TDatabase) and BDE(or BDE Administrator)? I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component which help you to develop Database Application very easily. (Note: dbExpress is able to connect to MySQL server directly, using Native Driver without ODBC Driver) Thanks. -- Borland Japan / Consulting Group TAKAHASHI, "KEN", Tomohiro José Haroldo Filho wrote: I've installed MyODBC and then I've set up ODBC and I saw the driver for MySQL DB, when I try to create a new alias wiht MySQL it does not apear to select the DB, acording a book wich is guiding it should has to appear. Can anybody help to set up the ALIAS with MySQL Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql+jdbc+international character support
Hi, Both gweMySQL and MM.MYSQL support Unicode-Nativecode conversion. [gweMySQL Driver] http://www.t3-jpn.com/jdbc/jdbcmysql.html i.e. String url = "jdbc:mysql://server:3306/dbname?characterEncoding=EUC_JP"; [MM.MYSQL Driver] http://mmmysql.sourceforge.net/ Jan-Michael Ong wrote: Greetings, This will be my first post to this mailing list so please bear with me. We need to setup a database that is capable of handling "international characters" similar to Oracle. We plan to use MySQL and the latest JDBC drivers for MySQL. I've searched Google to see if MySQL has dedicated support for international characters but was less than satisfied with the results. So the question is: What version (if any) does MySQL support international characters? Does the latest JDBC driver support this as well? If it does support it are there resources that perhaps you can recommend that I can read up on? If it does not support international characters are there plans to in the next few releases? Thank you in advance and I look forward to your reply. -- I love Borland. Borland Japan / Consulting Group TAKAHASHI, "KEN", Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I store a image into MYSQL database
Hi, pwxgao I will suggest to use JBuilder6 EnterpriseEdition and Borland Enterprise Server. You will be able to build EJB(CMP2.0), which can persistent blob column, very easily without coding. :-) pwxgao wrote: I also interestig in this topic...I wanna know how to save a blob object , for example, an image, to the mysql database, while I use EJB. Another words, I have a object , which has a blob column, I wanna to save and retrive this object from mysql database via CMP or BMP...how to make that? -- Borland Japan / Consulting Group TAKAHASHI, "KEN", Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Probelm with MySQL for JDBC Realm
Hi, It seems JDBCRealm implementation calls Conneciton.setAutoCommit() method automatically. So your MySQL Server need to be able to accept SQL statements "SET AUTOCOMMIT=1;" or "SET AUTOCOMMIT=0;" Please check it with mysql console client. In my case, MySQL-Max(InnoDB) 3.23.49 and gweMysql JDBC Driver and Tomcat4.0.3, JDBCRealm works fine. Thanks. Anupam De wrote: I am using MySQL version 3.23.47 on Win ME with Apache Tomcat 4.0. I am using JDBC realm but the error reported is : java.sql.SQLException: Cannot disable AUTO_COMMIT at org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:396) at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:549) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) -- Borland / Japan TAKAHASHI,"KEN",Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JBuilder6 and mm.mysql-2.0.11
Hi, Lonnie Lonnie Wormley wrote: TAKAHASHI, Tomohiro wrote: Do you want to use mm mysql Driver with JB6's DataPilot? What kind of error does DataPilot say? Here is the stack trace: See com.borland.dx.dataset.DataSetException error code: BASE+82 com.borland.dx.dataset.DataSetException: The driver: org.git.mm.mysql.Driver could not be loaded. This could be a problem org.gjt.mm.mysql.Driver ^ Thanks. -- TAKAHASHI, "KEN", Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JBuilder6 and mm.mysql-2.0.11
Hi, Lonnie Wormley wrote: Is this the correct file to have in your class path? addpath /home/launi/JBuilder6/lib/mm.mysql-2.0.11/mm.mysql-2.0.11-bin.jar Yes, please add it into jdk.config. :) I have it in there and it still does not work. I have it in my .bash_profile and dbpilot.config and still no luck I also tried the addjars option and it still will not work in the data pilot. Do you want to use mm mysql Driver with JB6's DataPilot? What kind of error does DataPilot say? -- TAKAHASHI,"KEN",Tomohiro Borland -- Enabling a new digital world where our customers have the freedom of choice to develop, deploy, and integrate applications across the enterprise and the Internet. http://www.borland.com Don\'t miss the 13th Annual Borland$B%g(B Conference, May 18-22 in Anaheim, California. Hundreds of sessions are being offered to help you enable the new digital world with best-in-class solutions for Web Services, Java$BQ(Btechnologies, mobile and enterprise computing, cross-platform development, .NET$BQ(Band J2EE$BQ(B platform technologies, and more! Register today! http://www.borland.com/conf2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JBuilder6 and mm.mysql-2.0.11
Hi, Lonnie Wormley wrote: Is this the correct file to have in your class path? addpath /home/launi/JBuilder6/lib/mm.mysql-2.0.11/mm.mysql-2.0.11-bin.jar Yes, please add it into jdk.config. :) -- TAKAHASHI,"KEN",Tomohiro Borland -- Enabling a new digital world where our customers have the freedom of choice to develop, deploy, and integrate applications across the enterprise and the Internet. http://www.borland.com Don\'t miss the 13th Annual Borland$B%g(B Conference, May 18-22 in Anaheim, California. Hundreds of sessions are being offered to help you enable the new digital world with best-in-class solutions for Web Services, Java$BQ(Btechnologies, mobile and enterprise computing, cross-platform development, .NET$BQ(Band J2EE$BQ(B platform technologies, and more! Register today! http://www.borland.com/conf2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
gweMysql JDBC Driver Update!!
Hi, All I updated JDBC Driver i maintained. :-) http://www.t3-jpn.com/jdbc/jdbcmysql.html [New Features for only JDK1.4 ] Add New Property 'useNewIO' to use SocketChannel and DirectBuffer with JDK1.4's New I/O API. Please download gweMysqlJDBC_extra4.zip and set useNewIO true [New Features for both JDK1.3 and JDK1.4 ] Support ResultSet.TYPE_SCROLL_INSENSITIVE Add New Property 'add5CAfter5C' to solve Shift JIS 0x5C(\) problem. Please set add5CAfter5C true and call PreparedStatement.setString() -- Borland Japan / Consulting Group KEN TAKAHASHI, Tomohiro E-Mail:[EMAIL PROTECTED] http://www.borland.co.jp/ Borland -- Enabling a new digital world where our customers have the freedom of choice to develop, deploy, and integrate applications across the enterprise and the Internet. http://www.borland.com Don't miss the 13th Annual Borland® Conference, May 18-22 in Anaheim, California. Hundreds of sessions are being offered to help you enable the new digital world with best-in-class solutions for Web Services, Java technologies, mobile and enterprise computing, cross-platform development, .NET and J2EE platform technologies, and more! Register today! http://www.borland.com/conf2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: My JDBC does not work.
Hi,
Jianping Zhu wrote:
I have spend three days try to get jdbc for mysql work, but failed. I am
very frustrated. I will
be appreciated if somebody can help me out.
snip
} catch (Exception e) {
System.out.println("StocksMy: JDBC exception");
System.exit(1);
}
}
}
Please print Exception as below and check RDBMS configuration.
} catch (Exception e) {
System.out.println(e.getMessage());
e.printStackTrace();
System.exit(1);
}
--
TAKAHASHI, Tomohiro
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql with java
Hi, Denny wrote: Hi, Is there any examples on developing a java interface with mysql? Do you want to develope a JDBC API with MySQL? If no and you want to develope a Java Program using JDBC API with JDBC Driver for MySQL, please see this web site. http://java.sun.com/docs/books/tutorial/jdbc/index.html Developement with JDBC API dees not depend on RDBMS. Thanks. -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: API errors BORLAND Builder 5.0
Hi, What kind of API,Component do you use with C++Builder5? Alexander Omelanuk wrote: Hello , I have some problems with borland builder 5.0. I can't connect to mysql server via API. I have error in obj file -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
update gweMysql JDBC Driver
Hi, All gweMysql JDBC Driver Update!! $B!&(BSupport Borland Enterprise Server5.0 (EJB2.0) $B!&(BSupport JBuilder6 $B!&(BConnectionPoolDataSource support maxPoolSize property ( 0 means no-limit ) [WebSite] http://www.t3-jpn.com/jdbc/jdbcmysql.html [for Download] http://www.t3-jpn.com/jdbc/download/gweMysqlJDBC_extra3.zip gweMysql JDBC Driver for JDK1.4(JDBC3.0 spec) now in progress. :-) Thanks. -- Borland Japan / Consulting Group KEN TAKAHASHI, Tomohiro Home :[EMAIL PROTECTED] Office:[EMAIL PROTECTED] http://www.borland.co.jp/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: date comes out as '0000-00-00'
Hi, Could you tell me about your TABLE-definition and version number of your JDBC Driver? I will check that problem. "Stancescu, Catalina" wrote: I have a servlet in which I connect through a mysql driver to the database. The servlet has a string that represents the date in the format 'MM/DD/YY'. When I am trying to insert this date, I get sometimes the correct date, sometimes I get the '-00-00'. Here is the code: String sql_1 = "INSERT INTO bookmgr.copy (bookid, emp_purchaser, date_expensed, emp_holder) VALUES (?,?,?,?)"; ps = myConnection.prepareStatement(sql_1); // inserting records ps.setInt(1, bookid); ps.setInt(2, userId); ps.setString(3, expensed_date); ps.setInt(4, userId); ps.executeUpdate(); -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql Row Lock Problem
Hi, Amit
What kind problem do you have?
I can't understand your problem.
In JDBC API, Connection.commit() method does not return
affected row count.
Generally, Statement.executeUpdate(String) method returns
that count.
Thanks.
Amit Dilip Lonkar wrote:
HI
I am using java. i am fireing the following query ,after and insert or
update in Mysql through Java
int returnValue = backend.setQueryResult("commit");
where setQueryResult(String sql) is method that updates data in database.
i have set the connection.setAutoCommit(false). The "returValue" is
returned as "0" when the query is fired.
--
TAKAHASHI, Tomohiro
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: XML Import
Hi, XML-DBMS (Open Source) is the best solution for storing 'XML' and pulling 'XML' with RDBMS. http://www.rpbourret.com/xmldbms/ This is bundled with JBuilder5 or JBuilder6. "Sweeney, David" wrote: Is there a way to import XML files into MySQL? David Sweeney Adaptive Technology Services Texas AM University [EMAIL PROTECTED] -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC and MySQL problem, please help.
Hi, Michael Tam wrote: Hi All, I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47. I used m.mmysql.2.0.8 JDBC driver with the following config segment in my resin.conf: resource-ref res-ref-namejdbc/test/res-ref-name res-typejavax.sql.XADataSource/res-type init-param driver-name="org.gjt.mm.mysql.Driver"/ [snip] Do you use MySQL or MySQL-max? MySQL-max supports Transaction but MySQL does not support it. MySQL-max does not support Distributed Transaction(Two-Phase Commit). And "org.gjt.mm.mysql.Driver" is not for XADataSource. So "javax.sql.XADataSource" does not work fine. -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: java.sql.SQLException: Lost connection to server during query the error is here
Hi, What Application Server do you use? I think JDBC connection has been disconnected from MySQL because that connection has not used for a long time. This error depends on Application Server. shashidhara n wrote: hello we are running web application using apache as web server and mysql as databse. after running server for 6- 8 hr it will give the following error java.sql.SQLException: Lost connection to server during query the error is here if we restart apache server it will works i want to know why this problem occuring, any problem in mysql server or apache server please mail to -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Jdbc Help
Hi, Is it first time in using library(*.jar) with WebApplication? Put it in webappdir/WEB-INF/lib/ dir. This is a easiest way. Hari Yellina wrote: Hi Guys, I am using mm.mysql driver, to connect to mysql. I have placed in lid of tomcat and given classpath as well. But it says driver cannot be found. Can you guys help. -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection Pool
Hi, Please tell about your environment. What is MySQL(-max) version? What is PoolMan version? Thanks. GABRIELMORENO wrote: My problem was the next: I'm using Poolman to create a conecction pool in Tomcat 4 to access a MySql database, the driver that I'm using is org.gjt.mm.mysql.Driver, JDBC throws this exception: java.sql.SQLException: Transaction Isolation Levels are not supported. params: org.gjt.mm.mysql.Driver, jdbc:mysql://localhost/myDataBase. Please check your username, password and other connectivity info. java.sql.SQLException: Transaction Isolation Levels are not supported. My solution is the next: the problem is the MySql driver, I get a new version and the problem is over. The new version is 2.0.8. Gabriel -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection Pool
Hi,
My environmment is next
WindowsNT 4.0(SP5)
Tomcat 3.2.3
MySql-max 3.23.46
Driver MySql: mm.mysql-2.0.8-bin.jar or gweMysql.jar
Poolman 2.0.4
It works fine.
I will attach my SimpleServet and poolman.xml for testing connection
to Database below.
I think PoolMan2.1.-b1 does not work fine.
poolman.xml ---
?xml version="1.0" encoding="UTF-8"?
poolman
management-modelocal/management-mode
datasource
dbnametestdb/dbname
jndiNamejndi-testdb/jndiName
driverorg.gjt.mm.mysql.Driver/driver
!-- drivergwe.sql.gweMysqlDriver/driver --
urljdbc:mysql://:3306/x/url
usernamex/username
password/password
/datasource
/poolman
PoolmanDriverTest.java -
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class PoolmanDriverTest extends HttpServlet{
static String db_url = "jdbc:poolman://testdb"; // Virtual URL
static String driver = "com.codestudio.sql.PoolMan"; // PoolMan Driver
public void init() throws ServletException {
try{
Class.forName(driver).newInstance();
}
catch(Exception e){
e.printStackTrace();
}
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html; charset=Shift_JIS");
PrintWriter pw = res.getWriter();
pw.println("htmlbody");
pw.println("h2PoolmanDriverTest/h2");
Connection conn = null;
try{
conn = DriverManager.getConnection(db_url);
System.out.println("OK!");
}
catch (Exception e){
e.printStackTrace();
}
finally{
if( conn != null )
{
try {
conn.close();
}
catch(Exception e){}
conn = null;
}
}
pw.println("/body/html");
}
}
--
--
TAKAHASHI, Tomohiro
GABRIELMORENO wrote:
Hi, Takahshi
My environmment is the next:
Windows 2000 Advanced Server
Tomcat 4.0
MySql 3.23.44
Driver MySql: mm.mysql-2.0.8-bin.jar
Poolman 2.1.-b1
Regards
Gabriel
----
Subject: Re: Connection Pool
Date: Tue, 11 Dec 2001 20:28:53 +0900
From: "TAKAHASHI, Tomohiro" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
References: [EMAIL PROTECTED]
Hi,
Please tell about your environment.
What is MySQL(-max) version?
What is PoolMan version?
Thanks.
GABRIELMORENO wrote:
My problem was the next:
I'm using Poolman to create a conecction pool in Tomcat 4 to access a
MySql database, the driver that I'm using is org.gjt.mm.mysql.Driver,
JDBC throws this exception:
java.sql.SQLException: Transaction Isolation Levels are not supported.
params: org.gjt.mm.mysql.Driver, jdbc:mysql://localhost/myDataBase.
Please check your username, password and other connectivity info.
java.sql.SQLException: Transaction Isolation Levels are not supported.
My solution is the next: the problem is the MySql driver, I get a new
version and the problem is over. The new version is 2.0.8.
Gabriel
--
TAKAHASHI, Tomohiro
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Packet is Larger than max_allowed_packet from server configuration of 65536 bytes
Hi, Max allowed packet size of a SQL statement is 16MB. Its limit is from structure of MySQL packet. So, please set environment as below. --set-variable=max_allowed_packet=16M Thanks. Chris Stark wrote: Hi, I am having a problem with the configuration of the mysql server or client. I have a very large query that I need to send to MySQL from Java. The query has approximately 5000 individual items in the where clause. (i.e. WHERE i!='AP' AND i != 'J3' AND...to 5000). When I try to execute the Query I get the error: "Packet is Larger than max_allowed_packet from server configuration of 65536 bytes" I read the MySQL documentation and increased my max_allowed_packet to 24M on both the client and the Server in the my.cnf, but I still get the same errorIs there another variable I need to increase, because no matter what I change the value of max_allowed_packet to, I still get the 65535 bytes error?? Please help!! Thanks, Chris -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: EJB and MYSQL
Hi, [EMAIL PROTECTED] wrote: Hi all Which version of MySql can support J2EE well? I have ever used mysql with Jboss (open source of EJB implementation) , it feels some limitation in comparison with using oralce. Why mySQL haven't been support by the BEA weblogic or other main stream EJB implementation? If you want to use EJB with MySQL, you should MySQL which supports Transaction. -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection issue with Kylix to Mysql 3.23
Hi, Did you make contact with Borland Support? Did you post message in Borland Newsgroup, 'newsgroups.borland.com'? Edward Valentine wrote: I downloaded and installed the new patch from Borland that allows Kylix to use versions of MySQL 3.23 and newer. Most of the errors on connection stopped and it seems to connect. What I am getting now is a "username/password invalid" error. I have connected with Webmin, MySQL at a prompt and kmysql using the same me and password. I have checked on the web and found several others with the same issue but no answers. I am using Caldera 3.1 with updates and all of the software versions included with that distro. I would appreciate any help. Thanks. -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: java.sql.SQLException: Cannot disable AUTO_COMMIT exception
Hi, Basically, EJB require RDBMS which support Transaction. Please make sure that your MySQL support Transaction. "Dataware Consulting Inc." wrote: Hi, I am getting "java.sql.SQLException: Cannot disable AUTO_COMMIT" exception when using mySQL with Weblogic EJB (through org.gjt.mm.mysql.Driver JDBC driver). Can anybody help!!!!!! -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: number of connections keeps increasing
Hi,
How do you get JDBC Connection, named 'conn'?
It is from Driver Manger or Connection Pooling Utility?
Is 'conn' variable auto variable of method or instance variable of JSP?
Generally, JSP is called from multiple threads.
Do you lock 'conn' variable by synchronization?
I suggest we use try-catch-finally block to close resources related to
database, and watch whether 'conn' is closed with debug message as below
synchronized(conn) {
try {
...
}
catch(Excpetion ex) {
...
}
finally {
try{
conn.close();
System.out.println("closed!!");
}
catch(Exception ex){}
}
}
Thanks.
yilmaz wrote:
Hi takashi,
My environment is :
Win2000, jdk1.3, tomcat 4,
Well, i am sure i added a snippet which closes statemnt and the connection.
for example, below is the snippet from one of my pages content.jsp :
% if (stmt!=null) { // actually this is a curly left brace
stmt.close(); } // actually this is a curly right brace
if (conn!=null){ // stmt is a Statement object
conn.close(); // conn is a Connection object
} %
whenever i call this page , number of connections inreases by one
it seems that the connections can not be closed
Any idea or suggestions ?
thanks a lot in advance
best regards :)
--
TAKAHASHI, Tomohiro
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection timeout and pooling
Hi,
What is your Pooing Utility?
Generally, JDBC Connection is TCP/IP's Socket.
After the Socket has been disconnected, we can not detect it by JDBC
interface. So, we have to detect it before we return a Connection
to the client.
Please see a source of my util class for Pooling, below. :-)
[ Pseudo Code of My Connection Pooling Util Class ]
public Connection getConnection() {
put out 'Connection' as conn from pool;
try {
conn.setAutoCommit(false);
conn.setAutoCommit(true);
}
catch(Excepion e) {
Oh, it seems that conn has a problem!!
discard conn which was putted out;
create a new Connection, and return it;
}
it seems that conn has No Problem!!
return conn;
}
Thanks.
Sylvain Hamel wrote:
IDE : JBuilder 4 prof
I am using pooling in order to optimize database access. When everybody
leaves the office for the weekend all my connection timeout. This is
expected except I would like my connection pool to be able to test
connections before passing them back to the requester. Whats the best way to
do this? Cant say I like sending a (context dependent) query to the database
because it makes my class not re-usable across applications.
--
TAKAHASHI, Tomohiro
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Offtopic JDBC
Hi, 3360? 3306? Please try "jdbc:mysql//localhost:3306/..." ^^ Thanks. Othmar Stehlik wrote: Hi I run mySQl on a Win98 machine,and cant get a connection. My sql runs fine, but I can$B%((Bt connect to the database. I use the path jdbc:mysql//localhost:3360/...and so on. On win2k everything worked fine. Please give an advice! -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Update JDBC Driver (gweMysql Driver)
Hi, Michael Widenius wrote: Tomohiro, could you be kind and put a copy kind a put a link from the MySQL software portal to your page ? This way it will be easier for other MySQL users to find your software! http://www.mysql.com/portal/software/html/index.html Sure. Thank you so much. -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC: Losing precision when mapping doubles from Java
Hi, Document and License is included in gweMysqlJDBC_extra3.zip. It is Free. Thanks. P.S. I have sent e-mail to 'www.gwe.co.uk' admin 1 year ago. But They have not replyed me. ;-) Roland wrote: Hi, Roland Try my JDBC Driver. http://www.t3-jpn.com/jdbc/jdbcmysql.html http://www.t3-jpn.com/jdbc/download/gweMysqlJDBC_extra3.zip Thanks. Hello, thanks for the quick answer. Your page has a link to: http://www.gwe.co.uk/ which is not working. Is there some information in english? Sorry, but I can't read japanese :). I have downloaded your driver. And will try to test it ASAP(as soon as possible) -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql - java - jdbc
Hi, Sandra. Configure Library Setting of JBuilder IDE. Check IDE's menu out. Thanks. Sandra Rovena Frigeri wrote: Hi, I need some information about jdbc driver for mysql dbms (windows version 3.23.43) for use it with jbuilder (version 2 or 3.5). Thanks for any information. -- TAKAHSHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Update JDBC Driver (gweMysql Driver)
Hi, All I Fixed two bugs. 1. If LoginUser has empty password, Driver can not connect to MySQL. 2. Connection Pool does not work correctly. ;-) Check this URL out for new Driver. :-) http://www.t3-jpn.com/jdbc/jdbcmysql.html "TAKAHASHI, Tomohiro" wrote: I updated JDBC Driver i maintained. :-) [Download] JDBC Driver for MySQL JDBC2.0 J2EE http://www.t3-jpn.com/jdbc/jdbcmysql.html -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC: Losing precision when mapping doubles from Java
Hi, Roland Try my JDBC Driver. http://www.t3-jpn.com/jdbc/jdbcmysql.html http://www.t3-jpn.com/jdbc/download/gweMysqlJDBC_extra3.zip Thanks. Roland wrote: Hello, I'm losing precision when I send a double to a mysql database from a Java program trough JDBC. Code: stmt.setDouble(i+3,((Double)value).doubleValue()); I use a prepared statement. Now, if I print out the double in java before sending it to the MySql database this is what it looks like: 1277.00143924408 (11 decimal digits) When I look in the database, this is what the value looks like: 1277.00143924 (8 decimal digits) snip -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
