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
(2016)
Issue with Processing Instruct...
(1)
problem converting json to XML...
(2)
Problem base64 decoding string...
(3)
Problems posting multipart for...
(5)
trouble with download of price...
(2)
Problem with http-post not bei...
(3)
path problem, xps_file:writeAl...
(9)
Xquery update support?
(2)
problem with Stylus studio try...
(5)
adding dtd reference to xml ou...
(4)
xquery escaping ambarsand when...
(3)
Whitespace problem when return...
(5)
Problem with namespace prefix ...
(5)
Sending via SFTP returns unexp...
(1)
Query and Sftp clent
(4)
xquery and try - catch
(3)
Query + ddtek:http-post optio...
(5)
Example files referenced in do...
(3)
Automatic Error Detection and ...
(3)
Working with result of ddtek:h...
(2)
[1-20]
[21-40]
[41-60]
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.