Sign Up
Search
Options
search
Chat
Help
News
Log in
Not Logged in
Home
»
Boards
»
Stylus Studio Developer Network
»
XQuery Help and Discussion
»
postgresql
Conferences
Stylus Studio Feature Requests
(1192)
Stylus Studio Technical Forum
(14621)
Website Feedback
(249)
XSLT Help and Discussion
(7625)
XQuery Help and Discussion
(2017)
Better way to do this?
(3)
Get output line by line!!
(2)
Use of if-then-else
(2)
Manipulation of XQuery output!...
(4)
Subtract times
(6)
Using xQuery to call a Convers...
(3)
How to add a custom class to t...
(3)
How to get rid of multiple occ...
(2)
Problem with conditional JOINi...
(8)
XQuery editor whitin Stylus St...
(3)
Get rid of spaces in returned ...
(4)
Can XQuery be embeded in a Jav...
(2)
Need help on converting <br...
(3)
postgresql
(3)
postgresql
postgresql
No format-number functionsupp...
(4)
Swapping elements using XQuery...
(2)
Trying to contact DataDirect d...
(3)
External Java functions with b...
(5)
Looking for xQuery help
(6)
Built-in processor & filtered ...
(2)
Previous
[181-200]
[201-220]
[221-240]
Next
Stylus Studio FAQs
(159)
Stylus Studio Code Samples & Utilities
(364)
Stylus Studio Announcements
(113)
Topic
next
Subject:
postgresql
Author:
andy standley
Date:
07 Oct 2008 09:51 PM
Running build 1050g
I am trying to connect to postgresql using jdbc in xquery
In the RelationalDB in file explorer I create a new server
I use the classpath postgresql-8.0-322.jdbc3.jar
I enter the url (it becomes jdbc:postgres://XX.XX.X.XXX/mydb
and I get shown the database and schema and tables
but when I try and drag the schema into an xquery mapper I get
FATAL: database "mydb;DatabaseName=mydb" does not exist
so it looks like it is appending to the url wrongly as shown in the details:
org.postgresql.util.PSQLException: FATAL: database "mydb;DatabaseName=mydb" does not exist
at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:444)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:99)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:29)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:386)
at org.postgresql.Driver.connect(Driver.java:260)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.stylusstudio.DataDirectDDXQStub.connect(DataDirectDDXQStub.java:84)
at com.stylusstudio.DataDirectDDXQStub.getConnection(DataDirectDDXQStub.java:120)
I can get DB2 working fine!!
andy
next
Subject:
postgresql
Author:
Ivan Pedruzzi
Date:
08 Oct 2008 10:11 AM
Hi Andy,
If I remeber correclty the PostreSQL JDBC URL requires a question mark at the end. Could you try the following?
//XX.XX.X.XXX/mydb?
Hope this helps
Ivan Pedruzzi
Stylus Studio Team
top
Subject:
postgresql
Author:
andy standley
Date:
08 Oct 2008 04:46 PM
Ivan - you are a marvel! Thanks, and sorry for not picking this up somewhere in the guides.
andy
Powered by
Stylus Studio
, the world's leading
XML IDE
for
XML
,
XSLT
,
XQuery
,
XML Schema
,
DTD
,
XPath
,
WSDL
,
XHTML
,
SQL/XML
, and
XML Mapping
!
Go to Conference:
Select Conference
Stylus Studio Feature Requests
Stylus Studio Technical Forum
Website Feedback
XSLT Help and Discussion
XQuery Help and Discussion
Stylus Studio FAQs
Stylus Studio Code Samples & Utilities
Stylus Studio Announcements
go
Log In Options
Username:
Password:
Site Map
|
Privacy Policy
|
Terms of Use
|
Trademarks
Stylus Scoop XML Newsletter:
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.