I've got a database and I've got a Java program that I'm programming in Netbeans that is suppose to run queries to the database. how I will set about to connect the database with the Java program so that I can run the queries?
It is very important that I learn how to do this, else I am forced to go back to XP in order to finish this project on time.
I have recently installed Java in my Ubuntu 9.04 environment so that I can teach myself Java. Basic Java programs work, but I am having trouble connecting to a MySQL database. I installed these packages using Synaptic Package Manager.
1.gsfonts-x11
2.java-common
3.odbcinst1debian1
4.sun-java6-bin
5.sun-java6-jdk
6.sun-java6-jre
7.unixodbc
After these packages were installed, I was not sure if I needed to do this, but I downloaded the MySQL connector from MySQL :: MySQL Connectors and installed in a directory called /home/mark/mysql/.
I then did "sudo gedit /etc/environment" and added a CLASSPATH to where I installed the connector:
Code:
I found an example Java program from Using JDBC with MySQL, Getting Started and stripped it down even further to test the MySQL connection.
This is the program I am running:
Code:
Could not find the main class: Jdbctest. Program will exit. I am new to Linux, Ubuntu, Java and MySQL, so I have probably left out something that is very obvious.
I have created a database which stores students grades for different stages of a project. One of the stages of the project is the specification part. I have a simple bit of html code which is going to be used as the searching facility. I want the user to be able to enter their ID and then it will display only their results. At the moment, it is displaying the results for EVERY student because I cant seem to find the correct syntax for my statement.
Heres the HTML code
<html>
<head>
</head>
<body>
<body bgcolor="#6881bb">
<center>
[Code]....
At the moment when i click the button, no matter what I enter every students marks appear on the screen.
I think, but obviously dont know for sure because if i did i would know how to solve the problem, the code that i need to change is in green.
I need some piece of software that follows the requirements below. So here's the scenario:
1. I need some piece of software that will allow me to edit related articles in a wiki-like fashion. I will be the only one editing this "wiki" though.
2. I need to be able to do searches/queries on the wiki content in a very flexible but also very concise way:
- The usual search for an expression in all articles or only some category(ies) but also:
- Wiki links to other wiki pages based on configurable criteria, e.g. articles belonging to some category(ies): I mean something like right-clicking would open a sort of database form to perform a query that would use the said link as expression but would only be run after you'd chosen your other criteria.
- If anyway possible, do the above for any selected text on the page you were watching...
3. Ideally this would be one single application of course. But I'm perfectly alright with coupling two or even more together as long as they do integrate with each other flawlessly.
I have an access database and I would like to build a website on the slackware 12.2 server running apache 2.11.14 to let users query data from the MS Access database. I am thinking that I could just do it in jscript and make a jdbc connection and that should be good. What do you guys think.
View 2 Replies View RelatedAt work we have a Sybase Adaptiver Server 9.0 database running, it has to stay there for now, and we are developing a web application that will connect to it using PHP.I was already able to make it work using ODBC on Windows and using odbc_connect on PHP.But now we are moving to Ubuntu, and we are trying to get it to work on it.I already have Apache2 and PHP5 up and running.There are two ways (I can think of) we can do this, one is using ODBC and then use "odbc_connect" and the other is making "sybase_connect" work on PHP. Being the latter probably the best one since you wouldn't have ODBC as an intermediary.
Either way, as long as it works I'm happy. ODBC would be fine to meet our requirements for now.I already have ODBC Data Source Administrator but no idea how to create/include/add the Sybase driver.We also tried setting freetds up, but that didn't work either, we might be missing something.
Well i have got a problem with connecting to a mysql database using php. I used this package "mysql-noinstall-5.1.44-win32.zip" and extracted it to c:mysql and added c:mysqlin to the PATH variable and used the following command in command prompt to start mysql: c:mysqlinmysqld --standalone
well mysql did start and everything went well accessing mysql in command prompt. Well under the database "mysql" in the table "user" i created a new user "php" with a password="****" and hostname = "localhost" but when i try to access this database with a following php routine:
And when i accesses it with my browser using localtost/test.php, all i get is "localhost" displayed on screen, "Connected to mysql" never gets displayed not i get any error..i am using windows 7(32-bit-ultimate)and mysql 5.1.44.
I've just installed the Oracle Instant client using this: https://help.ubuntu.com/community/PHPOracle
The phpinfo() show me that oci8 is enable, but when I try to query that database I've got the following message:
PHP Code:
Code:
How to troubleshoot.
I get some trouble setting up good environment in linux.. i have problem regarding connecting php(under linux) to a sybase server(under windows),,, is there anyway connecting this two technologies?..
View 7 Replies View RelatedWe are hoping to build a central database server so that we can take all the singular instances of mysql off our web servers and have the data stored in one place (we also run a number of syslogging servers that use mysql, netflow servers that use mysql, and many other servers that have mysql tables that we would like to consolidate as well). Now I have run into the problem that requires all the customer web sites to change the configuration for their connection to the mysql server from a local connection to a remote connection, which is something we are trying to avoid. I am wondering if there is a software suite or a function of mysql itself that allows you to present the remote database information as local databases to a server, allowing customer configurations to remain intact, as if the mysql server never moved off the local machine? Or a different question, can you configure mysql server to take local requests and forward them to a central mysql server?
View 9 Replies View RelatedHow to connect to remote oracle database using perl?
This is what I tried.
Code:
But I am unable to connect.
I'm new to linux, and setting up the mysql database server.
Here are my situation:
OS: CentOS 6
mysql version: 5.5
I tried to use MySQL Administrator to connect to my database on the host 192.168.1.120
and my computer is under the same network with ip: 192.168.1.105
But it shows the error msg: Could not connect to MySQL instance at 192.168.1.120
Error: Can't connect to MySQL server on '192.168.1.120'(61)(code 2003)
On the server side I've tried:
Code:
skip_networking is off and I've set the port for it.
When I check the process in OS:
Code:
When I try netstat:
Code:
I thought it's the problem of firewall, so I have check it also:
Code:
I have installed open suse linux 11.3. I have mysql database and jdk 1.6.20.0. How do I connect from java to mysql database?
View 2 Replies View RelatedI have a jsp code. After executing that code, a Java program should be executed without refreshing the page. that is, my first page is a login page which is in jsp. After logging in the next page must be displayed which is a Java code. is that possible? Can we use applet for that?
View 1 Replies View RelatedTrying to get OpenbavoPOS to connect to my remote Postgresql database, but so far i've only been able to connect to the local postgres installation. I _am_ able to access the remote databases with psql. I've read literally dozens of pages, and am pulling my hair out. I'm trying jdbc:derby.//192.168.15.10:5432/bravo I get back java.sql.SQLException no suitable driver found for jdbc:derby.//192.168.15.10:5432/bravo If I use jdbc:derby./root/bravo - all is OK, using a local database created in /root I have jdk installed on the client; does it need to be on the server also?
Server = CentOS 5.4 PostgreSQL version 8.1.21
Client = CentOS 4.8 PostgreSQL version 8.1.4
[code]....
Best one I've found so far is Glom, but it's extremely hard to use, anyone know of one better?
View 4 Replies View RelatedAn example of S5 database file: [URL] Can a file read/write such format (no psiconv!!) ?
View 1 Replies View RelatedI'm trying to write a simple program c++ to connect to Mysql database based in my 127.0.0.1 server:
int main (void) {
cout << "33[2J" << "33[0;0f";
MYSQL mysql;
MYSQL *conn;
[code]....
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
Unless your distro has taken care of it Centos 5.5, you'll need to create a user with a password and read/write privileges for program database. You can do this using the MySQL command line client if you are familiar with it. Well I am not familiar with it, so I wam wondering how to do it. As well when I run
mysql - p program </usr/share/program/mysql.sql>
It asks for a password. how do i find out this password.
How can i do Java programming on ubuntu.
i mean how to install java on ubuntu.
i tried but fail to install jdk.
How to make a shortcut to a program?
It's a Java program started by a shell script
#!bin/sh
java -jar LinShredder.jar
It starts okay in its original folder, but when I link to it from e.g. the desktop it doesn't work.
I have ubunto 10_4 X86-64 (I use putty to connect)
installed apps
screen
mysql server-client
my java program
open jdk* 64bit
apanche2 (the web server stuff)
and its aVPS machine
Xeon 2.0 64bit 4 GB ram
How can I make (or force) my java program to use more then 1 core? I would like it to be using just 5 of the 6 that I have. I use a .sh to run it this is the code for it.
Code:
#!/bin/bash
cd "${0%/*}"; java -Xshare:auto -Xmx2662M -jar craft.jar
I would like that my java program continues executing when I close the ssh connection, how can I do that? I suppose I have to create a service, but I have no idea how to do it!
View 3 Replies View RelatedI have a problem starting a java program.
I installed and am trying to run Antelope an ant file editor. When I try to start antelope I get the trace-back listed below.
When I first tried to start Antelope it asked me where ant/lib was located. I pointed it to /usr/share/ant/lib which has 3 jar files named ant.jar ant-bootstrap.jar and ant-launcher.jar.
I am running in Fedora14. With java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.7) (fedora-52.1.9.7.fc14-i386)
OpenJDK Client VM (build 19.0-b09, mixed mode) and javac 1.6.0_20
When I try to start it I get
Code:
I have tried it 2 ways, one with the environment variable ANT_HOME set to /use/share/ant/lib - which has some 3 jar files - and also to /home/knox/apache-ant-1.8.2/lib which has about 25 jar files. Same error message both ways.
Trying to use the html editor 'Arachnophilia'... here are the instructions on their website. ".Open a command console (Linux: shell console), move to the Arachnophilia program directory, type "java -jar Arachnophilia.jar" For convenience, this command can be made part of a shell script, and those using X windows can easily make a desktop icon." hoping someone can explain how to run this program.. using a new install of fedora 12 (which has java)...i'm a newbie, trying to go open source on a low end laptop - LOVE Fedora .[URL]..
View 14 Replies View RelatedI just got linux yesterday, ubuntu 9.1, with the wubi installer. I have no previous knowledge of linux and I am having a very hard time working out how to install or run any programs, at the moment I'm trying to get java to work.
View 4 Replies View RelatedI want to execute Linux commands using a Java program. I came to know that we can use Runtime.getRuntime().exec("commands") to execute the commands through the program. I'm new to both Linux and Java.
View 2 Replies View RelatedI run a program by executing this command in a terminal screen.Code:coco@coco-desktop:~/Escritorio/MO_1.10/MagnumOpus$ java -jar MagnumOpus.jarSince it is a bit tedious, I tried to create a launcher. I copied the above code into the Command box. The launcher is created, but fails to run the program. Instead I get an error message.
View 6 Replies View RelatedI have a java program with gui. I want to start this program in the start of system (rc3.d) and when I connect to the machine bring to front without open another time the program. I want to connect to opened program in the start of system.
View 1 Replies View Related