|
|
 next
|
  Subject: Exception in generated java code
Author: (Deleted User)
Date: 10 Sep 2007 04:24 PM
|
Vincent,
Sorry for the delay.
You seem to have found a bug in my code.
The generated java file contains a line like this:
m_DDXQCollectionSet.add("sqlserver_null_localhost1433", "jdbc:xquery:sqlserver://localhost:1433", null, "", true, "full");
The collection url in your xquery seems to be missing a userid. It is a little bit of a mystery to us right now how that could happen.
Our first question is: Are you using Windows integrated security to access the database, or the builtin database security?
If you are using Windows integrated security, the jdbc: url should contain a field AuthenticationMethod=Type2
If you are not using Windows integrated security, then you must supply a userid when you first connect to the database using the Stylus Studio file explorer docking windows.
We would like to know exactly how you are connecting to the database in Stylus Studio.
Anyway, as a temporary workaround to fix the java program, you can replace the first null parameter with a valid userid like this:
m_DDXQCollectionSet.add("sqlserver_null_localhost1433", "jdbc:xquery:sqlserver://localhost:1433", "myuserid", "", true, "full");
, or replace it with "" and add the ;AuthenticationMethod=Type2 field to the jdbc url in the java file. It will look something like this:
m_DDXQCollectionSet.add("sqlserver_null_localhost1433", "jdbc:xquery:sqlserver://localhost:1433;AuthenticationMethod=Type2", "", "", true, "full");
Please let us know how this works out so we can fix our code generator
Thanks very much.
Clyde Kessel
Stylus Studio development team.
|
|
|
|
test.pipeline
select_from_db.xquery
top