220 Topics
 | |
| | Hello there! I've been trying to import data from csv file to remote postgre database with no luck. Locally i can do it with simple COPY query, but that only works because i'm superuser. \COPY command also works when i run it in psql. So the question is: how can … |
| | I want to output results from a postgresql table into a csv file. I can do this however its also copying over headers and a row count. Im using \o /path then my sql query; Is there a way to get rid of the headers so i just have the … |
| | I'm stumped on a query filter I'm trying to put together. Here's what I need it to do: 1. Run a query that populates a table with order information to be gathered for regular invoices. 2. A user can filter date ranges, location, client and payment status. The options in … |
 | OK, so, as many of you are aware, the new version of Daniweb is approaching. However, I need to warn you about something in advance, so that you have some time to prepare. I've decided to allow posting in ALL forums including top-level categories. I really was getting incredibly tired … |
 | Hello friends, I am working an a section of application which needs to Parse CSV Logs generated by PostgreSql server. - The Logs are stored C:\Program Files\PostgreSQL\9.0\data\pg_log - The Server version in 9.0.4 - The application is developed in C Sharp * The basic utility after Parse the Log is … |
| | Hi, We are developing a software in j2ee/jboss appserver. I have designed a login page the source code of which is given below, loginpage.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>index of third eye</title> <link rel="stylesheet" href="stylepage.css"> <meta http-equiv="Content-Type" content="text/html; …  |
| | I have this Code... ifsDAO.java [CODE]package source; import java.sql.*; import java.sql.SQLException; import java.util.*; public class ifsDAO { private Database database; public ifsDAO(Database database) { this.database = database; } public List<ifsBean> list() throws SQLException { Connection connection = null; PreparedStatement statement = null; ResultSet resultSet = null; List<ifsBean> ifs_array = new …  |
| | How to connect postgresql database using eclipse in java. i can able to connect with using "localhost" or "127.0.0.1" but I am not able to connect with "IP address" or "host name(system name)" on the same machine(local system). Please do this needful request. Thanks in advance!!! |
 | Hello, I want to reinstall postgreSQL. I uninstaled via control panel and then try to run the installer. I get error meesage that the service name postgresql 8.4 already exists, try diffrernt name. But I don't know how to change the name, it does not give any field to enter … |
| | Dear All, I am currently working on a small project whereby I want to use a SOAP client to insert Customer Values in a database. The connection to database class is working, the only problem is that it seems that the Web Service wont communicate with this class. In the … |
| | I set up a MySQL databse following this tutorial: [URL="http://www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/"]http://www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/[/URL] Here is what I did: [CODE]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51a-3ubuntu5.1 (Ubuntu) Type 'help;' or '\h' for help. Type … |
| | Hi everyone. Suppose I have my database in postgresql, with around 100 tables. I would like to know if there is any way to know which table(s) is affected after running a specific query. For example, if I add a new row, that software for example, should be able to …  |
| | hi i want to use hibernate in java+postgresql but when i run it receive NullPointerException [code]import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import org.postgresql.Driver; public class FirstExample { public static void main(String[] args) { Session session = null; try{ SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory(); session =sessionFactory.openSession(); Transaction tx = … |
| | Hello , i'm new in web devellopement , u just could make a web page using kompozer called testconnexionpage1.php (this page contain entries to input name, date ... , and i created a database in PostgreSQL , i just know how could i insert my datas into my database from … |
 | I have a very simple wish, to dump all databases so I can lock up a backup of the databases, tables, users and so on. It looked like [CODE]mysqldump -v --all-databases -u root -p secret > "${directory2}""$h"_mysql_dumpall.sql[/CODE] worked, however the file contained a little error message telling me I had … |
 | I want to write a wrapper around MySQL but I will in future extend it to support other databases. I will cover only nasic useful features (commons) but it should be extensible in future with minimal change. I want to write an interface but I cannot get good tutorial to … |
 | A new version (9.0) of [URL="http://www.postgresql.org"]PostgreSQL[/URL] is in beta and ready for public testing. If version 9.0 lives up to its proposed [URL="http://www.postgresql.org/about/featurematrix"]feature list[/URL], then it is serious competition for MySQL. PostgreSQL proponents have long suggested that PostgreSQL has always enjoyed superiority over MySQL. I beg to differ but that … |
| | Ok so i have a little problem which i cant seem to figure out this is what i have: The constructor loads my method that loads a list of employee to show in jTable, but when i place that method in my button it doesn't do anything This is my … |
| | I have run into an interesting problem. I have inherited a database for daemon process that polls and accepts reports from remote embedded systems. Each site that has one of these systems can monitor over a dozen different fuel tanks. (In practice, most monitor 2, 3 or 4 tanks.) When …  |
| | I have 3 tables. [CODE]product ----------------------------------------------- product_code | product_header ----------------------------------------------- 12345 | Wilson Pro-staff Grip plus Glove product_attribute --------------------------- product_code | attribute_id --------------------------- 12345 | 1 12345 | 2 product_attribute_types ----------------------------- attribute_id | attribute_name ----------------------------- 1 | Size 2 | Colour[/CODE] This is the output that I would like to … |
| | Ive been working on a web map application with OpenLayers as a client side library, geoserver and Postgresql as database.I am a newbie in OpenLayers and javascript as well.I need to commit the features added on the map into the database.Is there a way i can specify the table in … |
| | Does postgreSQL-IE perform indexing before searching for IMAGE data type? I am developing a CBIR system for social media. i have xml files of about 1 million flickr images. if i get to know of a DBMS supporting indexing on searches my work would become alot easier. kindly help me … |
| | Alright, I have a members area, area.php, and I used mysql to find the userlevel and display content depending on the userlevel, 1 for user, 2 for admin. I made it, but it displays both the user and admin for 1, and 2. [CODE]<?php // Members Area // session_start(); $usernamee … |
| | I hope the title made sense. ok ive got a table in a PostgreSQL database that has a few coloumns in it. What im tryting to do is the following: [CODE]<?php $totaltimetodayresult = pg_query($link, "SELECT SUM(acctsessiontime) AS totaltime FROM radacct WHERE acctstarttime LIKE '%".$today."%'"); while($totaltimetodayarray = pgfetch_array($totaltimemonthresult)){ $totaltimetoday = $totaltimetodayarray['acctsessiontime']; … |
| | Hi all. my code is below: [code] <script type="text/javascript"> function gu_gid() { var ggid = document.getElementById("gid"); if(ggid.value != "" && ggid.value != "select") { $().ready(function() { $("#autocomplete").autocomplete("test.jsp?gid=" + ggid.value, { max: 50, width: 300, matchContains: true, selectFirst: false }); }); } } </script> . . . <form action="#" autocomplete="on"> <div> … |
| | I have follwed the tutorial on [I]JSP database connectivity according to Model View Controller (MVC) Model 2[/I] for login servlet. I use ServletConfig servlet and init- parameters from web.xml according to the tutorial. I am using Netbeans IDE. Bu I receive this exception whan I try to use login form. …  |
| | kindly give vb.net code samples for connecting crystal report and postgresql Also give information about how to add tables to a crystal report from a postgresql database using ODBC or any other method. |
| | hello everyone i want to know how i can store the image in my database(PostGreSql pgadmin iii) using jsp and glassfish as a server. i have the following code but it go to exception at pst.setBytes(2,b)....... thnx [code] con = getConnection(); String exsistingFileName= "C:\\temp\\myimage.gif"; File file = new File(exsistingFileName); FileInputStream …  |
| | I am Rishikeshan :) I am 14 years old. :) I am a student. :) I live in Trincomalee, Sri Lanka. Hair : Black. Eyes : Black. I know to program using c (opengl, libcurl, stdlib, tinythreads++), c++ (opengl, libcurl, stdlib, tinythreads++), vb, vbdos, vb.net, sql (postgresql, mysql), apache web … |
| | Hi All, I am trying to start writing a wiki-ish CMS I've been contemplating for a while now. the content will include pics, html content, and should be stored in a database (the current pick is postgres) A few questions for the more experienced folk 'round here: 1. how do … |
| | I have no idea what's wrong, I googled but I couldn't find the answer :/ it's probably really obvious but i'm rather new to PSQL Statement: [CODE] INSERT INTO drop_users VALUES ('John_Bucky','John_Bucky','a83b3735814aa577651a55b7c838a6a0',02-04-2011_02:20:55,'object', DEFAULT,DEFAULT,13,DEFAULT,DEFAULT[/CODE] Thanks for your time! ~Josh |
| | I am working on a application for which i need to connect it to a database. I have chosen postgreSQL. But i cannot connect it to java. Can somebody help. I tried this [url]http://www.faqs.org/docs/ppbook/x20856.htm[/url] but i don't know how to set classpath.I am currently working with windows xp. |
| | I am working on a psycopg2 application for a customer. I first used: SELECT * from table which worked fine with 'cursor.fetchone()'. But due to some technical details between the customer's database and the database on my company's side where I could not depend on the order of the fields, … |
| | 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"; } … |
 | Good day, i am creating a component, with an enum property for the property grid. [CODE] // The DataSources enumeration. public enum DataSources { MSSQL = 0, MYSQL = 1, POSTGRESQL = 2, ORACLE = 3, DSN = 4, EXCEL = 5, ACCESS = 6, } private DataSources m_DataSources; /// … |
| | 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 … |
| | 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 … |
 | Hi there, I have started working on a new C# app which will be installed directly onto our customers' computers to access our services remotely. I'm still in the phase of planning how everything will fit together. I normally use PostgreSQL for our back-end database needs, but I can't think … |
| | 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 … |
| | 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 … |
| | 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 … |
The End.