Can anybody tell me how to install the MYSQL JDBC connector. I am getting error “java.sql.SQLException: No suitable driver “. I placed the driver in the java-jrelib folder also in the shared folder of tomcat 5.0. Even in the lib folder of WEB-INF. But I am getting the same error.
Answer Question | March 4, 2009 6:32 AM
Apache Tomcat, Database connectivity, Java, Java Database Connectivity, java.sql.SQLException, JDBC, JSP, Linux hosting, MySQL, Tomcat hosting, Web developers, Web development
I hosted my site and I got the mysql server. Now, I want to connect it with the jsp pages . I am not understanding how to use ip address in connection string and while creating DSN i used my local server that is tomcat. But my website is in linux server. Will it create [...]
Answer Question | February 25, 2009 5:43 AM
Apache Tomcat, Database connectivity, DSN, JSP, Linux servers, MySQL, Web development
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.
Answer Question | February 18, 2009 8:38 AM
Database programming, MySQL, MySQL Stored Procedures, SQL, SQL stored procedures, Stored Procedures
I have an agent that uses ADODB to connect and insert a row into a SQL Server database. I want to store the contents of the Body field in the memo (rich text) into a Memo field in the SQL Server database (or Blob field). I’m finding examples of reading this kind of data back [...]
Answer Question | February 2, 2009 7:40 PM
ADO, ADOdb, Binary Large Object, BLOB, Database programming, Memo fields, MySQL, SQL Server development
Hi Friends, I have been using navicat to connect MySql5.0 in my local evironment.I connect my java project to MySql database as backend. Now my problem is, I generated an sql script to backup my local database. I run the script in server. Tables were created. But in the case of stored procedure, I got [...]
Answer Question | January 27, 2009 12:31 PM
Database Backup, Error 1044, Java development, MySQL, MySQL Access Denied error, MySQL backup, MySQL Stored Procedures, Navicat, SQL stored procedures, Stored Procedures, Web development
Perhaps somebody can point me in the right direction. I have a MySQL database that I inadvertently deleted all records from. There is a regular backup I have which I can access, but I have no idea where the MySQL database tables reside in the system. I have the root password and complete access to [...]
Answer Question | April 24, 2012 7:33 PM
Linux, MySQL, MySQL Restore
Answer Question | April 23, 2009 11:44 PM
Do you guys know where CanI find specific details for mysql like max number of records, max number of connections, max size of databse etc etc? my version is Ver 14.12 Distrib 5.0.51a
Answer Question | December 9, 2008 1:39 AM
MySQL, MySQL documentation, Recommended reading
How to create database (not table) using java? For example, I want to create database in MSAccess, MySQL, Oracle etc.
Answer Question | May 11, 2012 2:53 PM
Database, Java, Java Database, Microsoft Access, MySQL
If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they’re cabable of or does it just change what front-end you use? Why would I need a WAMP stack [...]
Answer Question | February 27, 2011 4:34 PM
MySQL, SQL, SQL Small Business Server, WAMP Stack
Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both MySQL and Oracle are running on windows [...]
Answer Question | October 27, 2008 6:04 AM
Database connectivity, HSODBC, MySQL, ORA-02063, ORA-28545, Oracle, Oracle 10g, Oracle error messages, Solaris
how do multiple functions work
Answer Question | September 10, 2010 9:43 AM
MySQL, PHP, Web development
How can i get user input in any mysql query at runtime.
Answer Question | October 15, 2008 9:41 PM
MySQL, MySQL query, RunTime
How can i set table storage settings at table creation time or any existing table
Answer Question | October 15, 2008 9:38 PM
MySQL, Table storage engine
In the process of editing my database, I accidentally deleted the MySQL database. I thought I recovered it, but when I opened MySQL Query Browser, it was not there. Is there an easy way to recover it for good?
Answer Question | May 31, 2012 6:14 PM
MySQL, MySQL Query Browser, Recovery, SQL Server
We created a File with an Auto Increment Field using MYSQL statements through PHP. I have no Idea how to do this using DDS statements or settings.
Answer Question | May 4, 2010 2:58 PM
Auto increment, DDS, MySQL, PHP
I’m following the lynda.com video series on php with mySQL and have run into a hangup. When I install mysql and I’m checking to make sure it’s all running, pointing a browser to http://localhost gives me the apache is running page, but going to http://localhost/~(myusername)/, I get an error saying “Forbidden. You don’t have permission [...]
Answer Question | August 8, 2008 5:16 AM
Apache, Mac OS X, MySQL, PHP, Web development
Is there any function in MySQL that can create a query similar to crosstab query in MS Access???
Answer Question | August 5, 2008 3:06 PM
Microsoft Access, MySQL, SQL Query
hi, I have a number of variables that i pull from a mysql database. I want 1 of the variables to show as a link to a web page. i have tried the following code, which displays everything fine, except for the $url bit echo "<p>$djname $genre $biography <a href='/$url'> Profile</a>"; [/code] any help would [...]
Answer Question | June 30, 2008 3:21 PM
MySQL, PHP, PHP/MySQL
I am adding a URL within a table with PHP and a MySQL Database, my string doesn’t show all of the URL, it cuts it off.
Answer Question | June 21, 2008 10:43 PM
MySQL, PHP, Table Functions, URL