Random Notes - DB and JDBC work

Doing DB tasks after a while gave me a feeling that I am learning few things again..
happens.. ! I guess.
Just to make sure it doesn't happen again,

Random Notes

- I was able to use the Hibernate Toolkit for creating Callable Statement.
- Passing String array is okay, make sure to implement the annonymus class Array
- Don't use commas as separators within an array element
Postgres treats commas as field separators
- Debugging is a challenge, if you have insert statements within, you cannot use commit. Have the inserts inside begin .. end; and from java client, beginTransaction and then commit. The log lines will not appear without commit.
- For substring, use substr (, );
- If you have create temp table, use create temp table without oid and EXECUTE
that statement.
For any inserts or other transactions on the temp table, use EXECUTE again.
Otherwise java client or any client will error out saying table with OID not
found.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

chiplunkar

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today