Tagged Questions

0
votes
1answer
30 views

Transfer regex from Java to PostgreSQL

How can I transfer the following regex from Java to PostgreSQL syntax: Pattern.compile("(?imu)(P\\W*Ř\\W*E\\W*D\\W*V\\W*O\\W*L\\W*Á\\W*N\\W*Í)")); I have tried: select regexp_matches('P Ř E D V O ...
1
vote
1answer
56 views

Java JAAS authentication requires database port number

Hi im using the this link for the Java JAAS form based authentication, implementation of JAAS login module validates the user entered user name and password with the database(postgresql) in JAAS We ...
0
votes
2answers
351 views

Hibernate startup very slow

For some reason, the startup of my hibernate application is unbarrably slow. (up to 2 min) I have been thinking that the c3p0 configuration is plain wrong (related question) but studying the logs ...
0
votes
2answers
172 views

How to read WAL files in pg_xlog directory through java

Am trying to read WAL files of the postgresql can any body tell me how to do that n what type of binary encoding is used in WAL binary files
1
vote
2answers
77 views

How to get meta data information of a sql query

I am using postgres 9.1 and java code for jdbc. I may use a order by clause in my sql query string I just want to get the meta data information of the query to find whether the query has order by ...
1
vote
1answer
200 views

Simple JPA to Postgresql 9.1 HibernateEx

Seems like a simple enough thing. I've used Hibernate sequences to MySQL and Oracle in the past but now using JPA2/Hibernate4 to Postgresql 9.1 and keep getting exceptions. Any ideas? I've tried ...
0
votes
1answer
64 views

Reach postgresql by using port 443 [closed]

My server ports are blocked by school except 80 and 443. So i don't reach postgreSQL by using 5432 out of the school. How can i reach port 5432 or postgreSQL by using port 443 ? My aim is connect ...
-1
votes
1answer
316 views

how to connect to pgAdmin using jdbc

I want to make a java program to access me database project which is made is pgAdmin 3 postgresql. So how to start with that? I am using windows.
2
votes
2answers
245 views

Java hibernate Joined inheritence (id not found)

Sorry for my English, it's not my native language and it's allready 2 o'clock, so can't think strait now. Now i have next problem while using hibernate with Java and PostgreSQL: I have entity Human ...
2
votes
2answers
169 views

How to ignore unique violation during insert list of objects which conatin set of object

I use PostgreSQL nad Spring data JPA with Hibernate. I have relation OneToMany with orphanRemoval = false because I very often add many childs to relation. Parent: @OneToMany(mappedBy = ...
1
vote
2answers
694 views

Retrieving file from bytea in PostgreSQL using java

Hi I'm using the below code to retrieve the file from the postgresql bytea using java, but inside the file I'm getting numbers like 314530413142313141 File file = new File("c:/test.doc"); ...
0
votes
2answers
242 views

convert Blob into a bytea in java

I'm working in postgresql database , i need to convert a MYSQL Blob datatype into a PostgreSQL bytea using java code only is there any way to do this?
-1
votes
2answers
305 views

PSQLException: ResultSet not positioned properly, perhaps you need to call next

public UserBean authenticate(String username,String password){ PostGresDAO pg=new PostGresDAO(); //creates new connection Connection conn=pg.getConnecion(); //return connection object ...
0
votes
2answers
482 views

Use of SERIAL and BIGSERIAL w/ EJB3 and Postgres

How to use Serial and bigSerial with ejb3 and PostgreSQL?
0
votes
1answer
798 views

insert Point(Geometry) value in database with postgresql/JDBC

Please give me code example to insert records containing sql statement: insert into TABLE (id, value1, value2, point, value3) values (1,'A', 'M', POINT (13.45646, 56.61782),5); in ...

1 2
15 30 50 per page