Re: Java Database connect
To: comp.lang.java.databases
On Nov 21, 7:53 pm, Yogi <yogeshkagra...@gmail.com> wrote:
On Nov 17, 8:17 pm, Yogi <yogeshkagra...@gmail.com> wrote:
On Nov 17, 6:02 pm, Yogi <yogeshkagra...@gmail.com> wrote:
On Nov 17, 5:57 pm, Sabine Dinis Blochberger <no.s...@here.invalid>
wrote:
Yogi wrote:
On Nov 17, 5:30 pm, Sabine Dinis Blochberger <no.s...@here.invali=
d>
wrote:
Yogi wrote:
On Nov 17, 2:30 pm, Sabine Dinis Blochberger <no.s...@here.in=
valid>
wrote:
Yogi wrote:
I am new to java and db connection pooling. I tried using=
Apache's
DBCP for connection pool for my web application. Was t=
rying to do
similar thing for a standalone server (not a web based). =
I tried
using DBCP but i am getting strange results. In my str=
ing variables,
i am getting "???" as output whereas for int variables i =
am getting
correct values when i m trying to read from database.
Make sure you use the correct encoding when connecting to t=
he databse,
for example, UTF-8. Refer to the manual of the database and=
JDBC driver
This could be only a display problem then - on your other envir=
onment
you don't have the correct locales installed.
I am using Eclipse to execute my program and getting "???" in
Eclipse's console. One of my friend suggested to check for dep=
endent
jars while using Apache's DBCP. But what I am bothered about i=
s, if
dependent jars are not available, it should not give me correct v=
alues
for integer placeholders as well. Any comments?
If you were missing libraries, you would get an Exception telling y=
ou
so.
Ok, from the Javadocs [0]:
"public void print(String s)
Prints a string. If the argument is null then the string "null" is
printed. Otherwise, the string's characters are converted into byte=
s
according to the platform's default character encoding, and these b=
ytes
are written in exactly the manner of the write(int) method.
Parameters:
s - The String to be printed"
Instead of using System.out.println, use a logging facility?
Or set your environments default character encoding to UTF-8 [1]?
[0]
<http://java.sun.com/javase/6/docs/api/java/io/PrintStream.html#pri=
nt(...)>
[1] <http://dev.eclipse.org/mhonarc/lists/aspectj-users/msg07331.ht=
ml>
Ok. This might be one of the issues. I will check your solutions a=
nd
will update you. Thanks a ton for your inputs. :)
Still no progress. Here is how I modified my Test class:
--------------
public static void main(String[] args){
Test t1 = new Test();
List <DInfo> dList = EngineDBManager.getDInfo(=
);
BufferedWriter out=null;
try {
out = new BufferedWriter(new FileWrite=
r("c:\\test.out"));
}catch(Exception e){
System.out.println("Not able to ope=
n file for writing");
}
OutputStreamWriter out1 = new OutputStreamWrit=
er(new
ByteArrayOutputStream());
System.out.println("Printing Encoding type here:=
" +
out1.getEncoding());
DInfo d = null;
if (dList == null){
System.out.println("DInfo is null");
}else{
for (int i=0;i < dList.size();=
i++){
) dList.get(i);
rintln("Id=" + d.getDID() + " Desc=" + d.getDDesc
te("\nId="+ d.getDID() + " Desc=" + d.getDDesc());
tion e){
out.println("error writing to file for=" +
dist.getDistrictID());
}
}
}
try{
out.close();
}catch(Exception e){
}
}
--------------------
I am getting "???" description. I changed encoding of Eclipse to UTF=
8.
I tried all possible ways but still no success. Any setting required
in eclipse or at db level? Any suggestions?
Hi Guys,
got it working. Its my stupidity that I did not include
"nls_classes12.jar" in my classpath. After doing that it is working
perfectly fine.
If you have Oracle installed, you will get this jar from $ORACLE_HOME/
jdbc/lib path. Hope this helps. :)
---
* Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24