[postgresql] Forum Topics

Hi, guys! My project is to create a chat software in Java. For security i must use Digital signatures+ Java Postgre sql... How to do it? Steps, codes, references, etc... HELP ME!

Hi.. I had successfully connected MySQL database usng ADODB.But I could not connect Using PostgreSQL database with ADODB.I had used the following code for connection. [CODE] <?php include("adodb/adodb.inc.php"); $db = NewADOConnection('postgres'); $c=$db->Connect("localhost", "postgres", "postgres", "dbname"); $db->debug = true; if(!$c) { echo "not connected"; } else { echo "successfully Connected"; } …

am trying to connect a jsp page to a postgress database i have created a jdbcconnects.java file and compiled it with jsp_api.jar from my apache..../lib directory i have placed the class file in root/WEB-INF/classes folder the code of my class file is [CODE] import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public …

Hi I am attempting to insert into a remote PostgreSqL database as a novice. I am using C# 2008 Express, on Windows 7. I have made a connection through a connection string which works well. So far I have this code placed after the connection code. string insertString = @"Insert …

i am having some connectivvity issues i am using postgres 9.0 sql db i have installed a dns localhost using the postgres sql driver also i have the jdbc jar files in the lib dir of the tomcat my code is [CODE] <%@ page language="java" import="java.sql.*" %> <% Class.forName("org.postgresql.Driver"); Connection …

i tried to make a new server registration suing pgAdmin3. i filled up the form with this name: test host: localhost port: 5432 Mantainance DB: postgres Username: test the rest i left it empty. but i got an error, [QUOTE]An error has occurred: Error connecting to the server: FATAL: database …

Hi. Im having a difficult time to figure out how to connect all the claass and jsp as well as the .xml. (I am working on a web application project, and these codes are for the registration module oly. Im using ECLIPSE EUROPA for my IDE, Apache Tomcat 6.0 for …

I am trying to code a form that has multiple textbox without refershing page using ajax, then after each textbox threre will be link called add which POST call the other php called addnew.php. In addnew.php data will we added to database(postgres). But I am geting problem while getting the …

Can we call a single trigger for multiple tables.... say I have two identical tables a and b. now we have a trigger that is needed to be called by each table. It is possible in POSTGRESQL using Triggers function.... these functions allow to call a single trigger function from …

I want to store data that user inputs [form based using xml] into a postgres database, so i would like to know is it wise to develop a web service or just it is better to use a jdbc connection As I am new to this environment please help me …

I want to store data that user inputs [form based in form of xml] into a postgres database, so I would like to know is it wise to develop a web service or how do I transfer data. I am completely clueless how to head on with the problem

I know many will start with ODBC, but slow down ;) I have searched for ODBC and all I find is UnixODBC. Is this the same as ODBC? Also how stable it is? I will be happy to know some apps/companies behind it! I need support for MySQL, PostGreSQL, DB2, …

Hi. I am working on a visual C++ app and I was wondering if it is possible to use PostgreSQL for database interaction instead of the default SQL Server? I saw a connector for .NET but it's written in C#, will that work for a C++ app also? Or is …

hello, I'm kind of new to the PHP-scene and I'm having difficulties with my first php-site the situation: I'm making a website were people view newsitems, these newsitems are stored in a database ("postgresql") every newsitem is stored in a category. i would like to create a list of every …

Hi everyone, I'm Dee :) I'm new here so please excuse me if I'm asking this in the wrong area. I must admit that I also know very little about PHP and techie stuff :$ so I'm after some help and guidance if possible. I'm getting an enormous database driven …

Hi there all Don't know if I'm at the wrong place, but I'll take that chance. I am fed up battling with importing txt files to sql server 2005. I am re-writing a vb6 based application, that uses text files, to a c# based application that uses sql server 2005 …

hello, I'm new to the PHP-scene and I'm having difficulties with creating a log in system. The login system writes to a postgresql database. when I try to run the page I receive this error: [CODE]Warning: pg_num_rows(): supplied argument is not a valid PostgreSQL result resource in /var/ftpdirs/512544/PHP/login/adduser.php on line …

Hi I want to upload and retrieve image using [B]JSP[/B] and the database am using is [B]PostgreSQL[/B],after storing image in byte streams and want to retrieve the image and i want to store the image in the hard disk and then i want to display the image by specifying the …

i have a project in c# code with 3 leyer; and all of database code are in data leyer, which method is better? 1- send sql string statementto data base for select or update? 2 - using stored procedure? in databases with larg scale wich is better? pleas help me?!

Hi, I am using postgresql as my DB. My problem is quite silly but its ruining my time. I am trying to populate my table with the data base table values. I am able to do it. This is the case for existing tables. Now i am creating a new …

Hi, I have just downloaded PostgreSQL and would like to add it into my new projects. I have never used PostgreSQL before so I don't know any of its technical details yet. I have registered the PostgreSQL provider using regsvr32 pgoledb.dll or something like that on my Winows partition, everything …

hi..I am really new in Java software development..I am trying to make sure that the JXTable will refresh or update the data after the save button is clicked which means that the JXTable will display the lastest data that retrieved from the database..as what I had googled through the methods …

I'M reading the book "Simply SQL" and I need to use the files for the book. It was suggested to be to use postgreSQL and now I've got it up and running on my Ubuntu machine. But I'M having a little bit of trouble getting started. When I first start …

hello everybody, I'm new to jsp.I have to develope web portal for my company but i had problem with my login page. I hope that you can help this problem. Here is the code: <%@ page contentType="text/html" import="java.sql.*, java.util.Date, java.io.*" %> <%! String CheckLogin(String Login, String Password) throws Exception { …

I just got postgresql & pgAdmin III up and running. I'M trying to start the book "Simply SQL" so how do I go about getting to .sql files for the book into pgAdmin? Thanks for any and all replies.

Hello everyone, I am trying to retrieve some data from PostgreSQL using jQuery and PHP. I should be able to enter a date as input -e.g, as 2010-08-09 and retrieve all the data that is dated August 9th- however, when I execute my javascript, all I get as an output …

I am getting so much errors in php. I couldn't understand why. I re-checked all code but I am getting strange errors. The code below is provided to you under mit/x11 license for modification and distribution. ALL DERIVATIVES ARE WELCOME! :) Here is the code: [code=php] <html><head><link href="style.css" rel="stylesheet" type="text/css" …

Anyone installed miachat on postgres? I changed the config to postgres7 but it did not work. Is there any non-copyleft chat scripts for php?

please help with my connection i'm getting error("exception: org.postgresql.util.PSQLException: The connection attempt failed.The connection attempt failed.") this is my code.. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %> <%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %> <%@ page language="java" import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML …

please help with my connection i'm getting error("exception: org.postgresql.util.PSQLException: The connection attempt failed.The connection attempt failed.") this is my code.. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %> <%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %> <%@ page language="java" import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML …

I'm trying to write a CGI script as part of a web technology programme I am undertaking. There's a challenge with getting form data to concatenate into my SQL strings to populate my database which is in Postgre. This is my HTML form: [CODE="HTML"] <form action="review_input.cgi" method="post"> <input type="hidden" id="cdid" …

How to check whether two tables in SQL are the same using vb.net? Would u mind giving me the code? Thank you so much!!!

somebody help me how to open connection postgresql with vb.net ..

There are 2 questions that I have. After banging my head with mysql server for more than 4 hours, I've given up. The mysql server will start mysql service on windows 7, but will not start another service. (Is this somehow related to admin rights of 7. I am an …

I new to python . I created the one console application in python for that i used two data bases IBM_DBI and POSTGRESQL8.4. I converted the console application into windows exe for that i used py2exe. It is created, while running the exe it coudn't connect with DB2 data base …

We are planning to make a commercial GUI based software (for both desktop and mobile) targeting individual users. We plan to have good web 2.0 like rich application features (Google like dynamic auto suggest, drag and drop, browser based look and feel etc) and lot of user controls (trees, grids, …

How could I like programming ? When you spend 2 days on one single, pointless line and the only thing you get to see is an ERROR-response. It`s really inhuman and I cant imagine who would want this voluntarily. Nevertheless, what am I yammering about is following error, that is …

hi all does anybody here knows a good safe way to work with sql stored function with zend framework? i can do so with prepared statement but i'm sure that there is safer way to do so... i'm using postgreSql but i don't think that there's any different. thanks!

Alright, let's try this again. I've started over from scratch and we have got the basic functions working. Everything so far has checked out, but I am still trying to get it to pull the right credentials. I can get it to pull one of the rows out of the …

Hey, I need help with setting up an authentication code. I am currently working on a project to build a blog server in python for an intro level python course. We are using the PESTO and POSTGRESQL wsgi and sql clients respectively. I am trying to authenticate against a user …

Hi all I'm new to PostgreSql i'm trying to write a simple function [code] CREATE OR REPLACE FUNCTION insert_tmp_pswd2 (int4, varchar) RETURNS int4 AS ' DECLARE tmp VARCHAR; BEGIN insert into "ExAfrica".test2 values($1, $2,now());select 1; END; ' LANGUAGE 'sql'; [/code] i really dont know why he doesnt want to declare …

hi, i want to insert the values into the postgresql database using jsp code.first i have to retreive the values from one table which will be displaying in combo box.And i have to store it in another table which is having the auto increment data. hope u understand.... can anyone …

Hi, I have a script which is meant to use all of my servers cpu but mysql will only use one core. I have 8 cores but only 1 core is being used. Does anybody know how to allow mysql to use multiple cores? -------- Second question How do I …

Please forgive the long post, but I thought it best to be thorough, even if I'm only looking for pointers. I am working on a schema for a PostGreSQL dbase that is meant to contain all the metadata for all our Digital assets that are for distribution on online: audio, …

I am sitting with a situation that I have to combined (3 years) for 26 site of 29000 database files where there is 1 table in each data base called RECDATA, I need to combined all that data Into one database file called RECDATA For example there is a database …

Hi it's probably a very basic question but I just wonder if it is ok to restrain foreign key to more than one column, e.g. there is a hypothetical situation where a company collects fruits, let say apples , from farmers. So, a database builts up, and there is a …

can anyone help me to backup/restore my database file by using jsp code??? im using postgres sql... please its urgnt..tnx in adv. i am using fedora 11 i got this code from an article. but i know it will not wrk.. pls help me if any one hav any idea. …

Hey all, How can we create a new PostgreSQL database using a shell script?

I have 3 tables. Locations, Units and phases. Each location can have multiple units and each unit will have multiple phases. Hence my database structure consists of foreign key associations as follows. 'Units.location_id' references 'Locations.id' 'Phases.unit_id' references 'Units.id' When I delete a Location, all associated Phases of the Location and …

I have a postgresql view on which I'm running the following query : [CODE]select count(*) AS "Assigned Calls" ,to_timestamp(createdon)::date from vw_issues where to_timestamp(createdon)::date>='11/10/2009' and to_timestamp(createdon)::date<'11/11/2009' group by to_timestamp(createdon)::date order by to_timestamp(createdon)::date[/CODE] when run in phppgadmin the result is displayed as Assigned Calls to_timestamp 20 2009-10-12 13 2009-10-13 etc... I need …