Problem with Oracle 11g

[hoantv]

Hi Sijms.
With oracle 12c, the lib worked perfectly. but when I used with oracle 11g. The error ORA-01882: timezone region not found. How to disable this parameter oracle.jdbc.timezoneAsRegion=false ?

[rongfengliang]

@hoantv i test with oracle 10g is ok ,maybe some sql query with time?

[hoantv]

@hoantv i test with oracle 10g is ok ,maybe some sql query with time?

the error occured when i create new connection, i hadn't yet made a query:
conn, err := go_ora.NewConnection("oracle://user:pass@server/service_name")

[sijms]

can you see the log file at define which step cause error

[hoantv]

can you see the log file at define which step cause error

Tomorrow i will send you the log :).

[hoantv]

After update lasted lib. It worked. Thank you.
By the way, could you add url.escapedQuery for password. Users dont have to add to thier code anymore.

[sijms]

what do you mean by url.escapedQuery can you give example

[hoantv]

I used it in mycode. User dont have to replace thier special characters

url := fmt.Sprintf("oracle://%s:%s@%s:%d/%s", instance.Username, url.QueryEscape(instance.Password), instance.Host, instance.Port, instance.Sid)

[sijms]

how can I add QueryEscape for password alone ?
this means I will parse the database url manually and extract password and escape It ?
sql interface need to pass database url like this
sql.Open("oracle", "oracle://user:pass@server:1521/service_name")

I think this is job of the programmer to pass correct url to the driver and actually your code is good solution.

if it is ok please close the issue

[hoantv]

Ok :)