default_schema ignored in DB2?

ksp · **Joined:** Thu Feb 14, 2008 6:45 pm **Posts:** 1

Hi All,

I've been searching for a solution to the following problem but to no avail. I am using hiberate to interact with DB2 on iSeries/AS400. My configuration file uses the url: jdbc:as400:##.###.#.###/MYLIBA;prompt=false.

I then declare a default schema as MYLIBB. If I execute queries session.createSQLQuery(sql).list(), I get data from MYLIBA, not MYLIBB. If I remove MYLIBA from my connection to leave jdbc:as400:##.###.#.###/;prompt=false then Hibernate attempts to use my connection username as the schema.

Anybody have any ideas as to how I can get around this problem without dynamically generating the url to include the library I want to use?

Thanks in advance,
ksp

ratnesh_22 · **Joined:** Fri May 02, 2008 4:11 am **Posts:** 3

I hope proper connection url could help.

http://rmwebcafe.blogspot.com/search?q=using+hibernate