Skip site navigation (1) Skip section navigation (2)

problem with Chinese

From: root <malix(at)263(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: problem with Chinese
Date: 2001-10-18 14:26:59
Message-ID: 3BCEE6B3.5070303@263.net (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,
I have downloaded binary JDBC Driver from both postgresql.org and
jdbc.postgresql
it's version is jdbc7.1-1.2/jdbc7.1-1.1. It always give a message like this

Exception in thread "main" java.sql.SQLException: ERROR:Unterminated
quoted string

 at org.postgresql.Connection.ExecSQL(Connection.java:533)
 at org.postgresql.jdbc2.Statement.execute(Statement.java:294)
 at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59)
 at Test.main(Test.java:20)

I have also tride to rebuild the source code with
./configure --prefix=/opt --enable-locale --enable-multibyte=EUC_CN
--with-CXX -with-java -with-openssl=/usr
1)for JDBC it can complete compilation, but use JDBC with problem
2)for libpq--> input.c -->on_exit() :

gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/interfaces/libpq -I../../../src/include -I/usr/include-
c -o input.o input.c
input.c: In function `initializeInput':
input.c:157: warning: passing arg 1 of `on_exit' from incompatible
pointer type
input.c:157: too few arguments to function `on_exit'

3) my table customer is very simple : cno char(10),cname varchar(50)
my source code :

import java.sql.*;
import java.io.*;

class Test{
 public static void main(String args[]) throws Exception {
 System.out.println("input :");
 BufferedReader in=new BufferedReader(
 new InputStreamReader(
 System.in
 )
 );
 String t1=in.readLine(); //here i can enter some Chinese
string
 System.out.println("your input are :"+t1);
 Class.forName("org.postgresql.Driver");
 Connection dbconn=DriverManager.getConnection(
 "jdbc:postgresql:redauto","postgres","");
 Statement st = dbconn.createStatement();
 String str_sql="SELECT * FROM customer where cname='"+t1+"'";
 System.out.println(str_sql);
 ResultSet rs = st.executeQuery(str_sql);
 while(rs.next()) {
 System.out.println(rs.getString(1)+"\t"+rs.getString
(2)+"\n");
 }
 rs.close();
 st.close();
 dbconn.close();
 }
}



I am shade to have disturbed you.
you are kind for me if you can give any sugestion.
Thanks very much.

malix
shanghai china


Responses

pgsql-jdbc by date

Next:From: rootDate: 2001-10-18 14:32:38
Subject: complementarity for my JDBC Problem
Previous:From: Vianen, Jeroen vanDate: 2001-10-18 08:20:30
Subject: Re: [PATCHES] Ant configuration

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group