Creating SQL Server (jTDS) Pool failed

[Florian Schaetz-2]

Hi,

I'm using a (locally installed) Geronimo 2.1.4 with a Java JDK 1.6.0.12
and try to create a new "SQL Server (jTDS)" Pool with the web console (
Database Pools -> Using the Geronimo database pool wizard). I enter a
name, choose "SQL Server (jTDS)" and click on the "Next" button - and
find myself back at the "Database Pools" page, instead at the page where
I can edit the parameters.

I did add a JTDS driver, both manually within the repository and by
downloading it via Geronimo web console. Adding a new MySQL pool works
fine, btw.

There is no message in the console (neither web nor command), just this
text appears in the log file every time I try to do it:

2009-06-22 16:28:33,989 INFO  [SupportedModesServiceImpl] Portlet mode
'edit' not found for portletId: '/system-database.DBWizard!1134683811|0'
2009-06-22 16:28:33,989 INFO  [SupportedModesServiceImpl] Portlet mode
'help' not found for portletId: '/system-database.DBWizard!1134683811|0'
2009-06-22 16:28:34,005 INFO  [SupportedModesServiceImpl] Portlet mode
'edit' not found for portletId: '/system-database.RunSQLDS!1134683811|1'
2009-06-22 16:28:34,005 INFO  [XSRFHandler] Updated HTML content with
XSRF JavaScript for
requestURI=/console/portal//Services/Database%20Pools/__pm0x3system-database0x2DBWizard!1134683811|0_view/__rp0x3system-database0x2DBWizard!1134683811|0_adapterDisplayName/TranQL0x8Generic0x8JDBC0x8Resource0x8Adapter/__rp0x3system-database0x2DBWizard!1134683811|0_mode/rdbms

The strange thing is: Another coder, using the same geronimo version (as
we are working on the same project) has no problems creating a SQL
Server (jTDS) Pool on his local geronimo.

Has anyone got an idea what I'm doing wrong?

Flo

[Donald Woods-2]

What was the directory structure and filenames used when you added it to
the server repository (assuming you already tried the same structure
that worked for your the other coder) and what name did you use when
trying to create the datasource name (any special chars)?


-Donald


Florian Schaetz wrote:

> Hi,
>
> I'm using a (locally installed) Geronimo 2.1.4 with a Java JDK 1.6.0.12
> and try to create a new "SQL Server (jTDS)" Pool with the web console (
> Database Pools -> Using the Geronimo database pool wizard). I enter a
> name, choose "SQL Server (jTDS)" and click on the "Next" button - and
> find myself back at the "Database Pools" page, instead at the page where
> I can edit the parameters.
>
> I did add a JTDS driver, both manually within the repository and by
> downloading it via Geronimo web console. Adding a new MySQL pool works
> fine, btw.
>
> There is no message in the console (neither web nor command), just this
> text appears in the log file every time I try to do it:
>
> 2009-06-22 16:28:33,989 INFO  [SupportedModesServiceImpl] Portlet mode
> 'edit' not found for portletId: '/system-database.DBWizard!1134683811|0'
> 2009-06-22 16:28:33,989 INFO  [SupportedModesServiceImpl] Portlet mode
> 'help' not found for portletId: '/system-database.DBWizard!1134683811|0'
> 2009-06-22 16:28:34,005 INFO  [SupportedModesServiceImpl] Portlet mode
> 'edit' not found for portletId: '/system-database.RunSQLDS!1134683811|1'
> 2009-06-22 16:28:34,005 INFO  [XSRFHandler] Updated HTML content with
> XSRF JavaScript for
> requestURI=/console/portal//Services/Database%20Pools/__pm0x3system-database0x2DBWizard!1134683811|0_view/__rp0x3system-database0x2DBWizard!1134683811|0_adapterDisplayName/TranQL0x8Generic0x8JDBC0x8Resource0x8Adapter/__rp0x3system-database0x2DBWizard!1134683811|0_mode/rdbms
>
> The strange thing is: Another coder, using the same geronimo version (as
> we are working on the same project) has no problems creating a SQL
> Server (jTDS) Pool on his local geronimo.
>
> Has anyone got an idea what I'm doing wrong?
>
> Flo
>

[Florian Schaetz-2]

Donald Woods wrote:

> What was the directory structure and filenames used when you added it to
> the server repository (assuming you already tried the same structure
> that worked for your the other coder) and what name did you use when
> trying to create the datasource name (any special chars)?

I added it with repository/optitool/jtds/1.2.2/jtds-1.2.2.jar (manually,
with the Repository tab in the web console). The automatically
downloaded driver was installed repository/jtds/jtds/1.2/jtds-1.2.jar -
same paths as my colleague's.

I tried to name it in various way - OptitooDB (worked for MySQL - of
course, I removed the MySQL one before trying that), TestDB, MySQLDB,
fnadsnhfs, etc. - no special chars at all.

Hope that helps, but I don't think that the name or the repository name
are the problem here...

Flo

[Florian Schaetz-2]

Florian Schaetz (hey, that's me) wrote:

> I'm using a (locally installed) Geronimo 2.1.4 with a Java JDK 1.6.0.12
> and try to create a new "SQL Server (jTDS)" Pool with the web console (
> Database Pools -> Using the Geronimo database pool wizard). I enter a
> name, choose "SQL Server (jTDS)" and click on the "Next" button - and
> find myself back at the "Database Pools" page, instead at the page where
> I can edit the parameters.

A little addition: I was able to deploy the "SQL Server (jTDS)" manually
(by calling the deployer.jar from the command line, using a plan.xml
created by my colleague's geronimo). So, imho, there seems to be a
problem with the portlet...

I also tried to use a "new" Geronimo install (downloaded it again and
unzipped it to another destination), but this didn't help, deploying it
via the web console also doesn't work with this new install.

Flo

[kevan]

On Jun 22, 2009, at 11:55 AM, Florian Schaetz wrote:

> Hi,
>
> I'm using a (locally installed) Geronimo 2.1.4 with a Java JDK  
> 1.6.0.12
> and try to create a new "SQL Server (jTDS)" Pool with the web  
> console (
> Database Pools -> Using the Geronimo database pool wizard). I enter a
> name, choose "SQL Server (jTDS)" and click on the "Next" button - and
> find myself back at the "Database Pools" page, instead at the page  
> where
> I can edit the parameters.
>
> I did add a JTDS driver, both manually within the repository and by
> downloading it via Geronimo web console. Adding a new MySQL pool works
> fine, btw.
>
> There is no message in the console (neither web nor command), just  
> this
> text appears in the log file every time I try to do it:
>
> 2009-06-22 16:28:33,989 INFO  [SupportedModesServiceImpl] Portlet mode
> 'edit' not found for portletId: '/system-database.DBWizard!
> 1134683811|0'
> 2009-06-22 16:28:33,989 INFO  [SupportedModesServiceImpl] Portlet mode
> 'help' not found for portletId: '/system-database.DBWizard!
> 1134683811|0'
> 2009-06-22 16:28:34,005 INFO  [SupportedModesServiceImpl] Portlet mode
> 'edit' not found for portletId: '/system-database.RunSQLDS!
> 1134683811|1'
> 2009-06-22 16:28:34,005 INFO  [XSRFHandler] Updated HTML content with
> XSRF JavaScript for
> requestURI=/console/portal//Services/Database%20Pools/__pm0x3system-
> database0x2DBWizard!1134683811|0_view/__rp0x3system-
> database0x2DBWizard!1134683811|0_adapterDisplayName/
> TranQL0x8Generic0x8JDBC0x8Resource0x8Adapter/__rp0x3system-
> database0x2DBWizard!1134683811|0_mode/rdbms
>
> The strange thing is: Another coder, using the same geronimo version  
> (as
> we are working on the same project) has no problems creating a SQL
> Server (jTDS) Pool on his local geronimo.
>
> Has anyone got an idea what I'm doing wrong?

Don't see anything wrong that *you* are doing... ;-)

Those log messages look normal. However, they are generated during the  
"Create Database Pool -- Step 1" page creation -- before you are  
hitting next. What web browser are you using?

Are there any environmental differences between your system and your  
colleague's (who is able to create the pool)? Web Browser, OS, Java  
version, etc.

FYI, here's approximately what you'd see in the log, if the "Next"  
button was working...

2009-06-23 10:50:19,500 INFO  [SupportedModesServiceImpl] Portlet mode  
'edit' not found for portletId: '/system-database.DBWizard!1134683811|0'
2009-06-23 10:50:19,500 INFO  [SupportedModesServiceImpl] Portlet mode  
'help' not found for portletId: '/system-database.DBWizard!1134683811|0'
2009-06-23 10:50:19,514 INFO  [SupportedModesServiceImpl] Portlet mode  
'edit' not found for portletId: '/system-database.RunSQLDS!1134683811|1'
2009-06-23 10:50:19,522 INFO  [XSRFHandler] Updated HTML content with  
XSRF JavaScript for requestURI=/console/portal//Services/Database
%20Pools/__pm0x3system-database0x2DBWizard!1134683811%7C0_view/
__rp0x3system-database0x2DBWizard!1134683811%7C0_mode/rdbms/
__rp0x3system-database0x2DBWizard!1134683811%7C0_adapterDisplayName/
TranQL0x8Generic0x8JDBC0x8Resource0x8Adapter
2009-06-23 10:55:02,396 INFO  [SupportedModesServiceImpl] Portlet mode  
'edit' not found for portletId: '/system-database.DBWizard!1134683811|0'
2009-06-23 10:55:02,396 INFO  [SupportedModesServiceImpl] Portlet mode  
'help' not found for portletId: '/system-database.DBWizard!1134683811|0'
2009-06-23 10:55:02,417 INFO  [SupportedModesServiceImpl] Portlet mode  
'edit' not found for portletId: '/system-database.RunSQLDS!1134683811|1'
2009-06-23 10:55:02,430 INFO  [XSRFHandler] Updated HTML content with  
XSRF JavaScript for requestURI=/console/portal//Services/Database
%20Pools/__pm0x3system-database0x2DBWizard!1134683811%7C0_view/
__rp0x3system-database0x2DBWizard!1134683811%7C0_name/foo/
__rp0x3system-database0x2DBWizard!1134683811%7C0_rarPath/
org0x2tranql0x3tranql-connector-ra0x30x3rar/__rp0x3system-
database0x2DBWizard!1134683811%7C0_mode/params/__rp0x3system-
database0x2DBWizard!1134683811%7C0_transactionType/LOCAL/__rp0x3system-
database0x2DBWizard!1134683811%7C0_urlPrototype/jdbc:jtds:sqlserver:
0x30x3%7BHost%7D:%7BPort%7D;DatabaseName=%7BDatabase%7D/__rp0x3system-
database0x2DBWizard!1134683811%7C0_dbtype/SQL0x8Server0x8(jTDS)/
__rp0x3system-database0x2DBWizard!1134683811%7C0_driverClass/
net0x2sourceforge0x2jtds0x2jdbc0x2Driver/__rp0x3system-
database0x2DBWizard!1134683811%7C0_adapterDisplayName/
TranQL0x8Generic0x8JDBC0x8Resource0x8Adapter

--kevan

[Donald Woods-2]

That sounds like maybe a XSSXSRF filter problem....

Can you download and try the latest 2.1.5-SNAPSHOT build, which includes
some fixes for discovered issues with that filter?

http://people.apache.org/builds/geronimo/server/binaries/2.1/


-Donald


Florian Schaetz wrote:

> Florian Schaetz (hey, that's me) wrote:
>
>> I'm using a (locally installed) Geronimo 2.1.4 with a Java JDK 1.6.0.12
>> and try to create a new "SQL Server (jTDS)" Pool with the web console (
>> Database Pools -> Using the Geronimo database pool wizard). I enter a
>> name, choose "SQL Server (jTDS)" and click on the "Next" button - and
>> find myself back at the "Database Pools" page, instead at the page where
>> I can edit the parameters.
>
> A little addition: I was able to deploy the "SQL Server (jTDS)" manually
> (by calling the deployer.jar from the command line, using a plan.xml
> created by my colleague's geronimo). So, imho, there seems to be a
> problem with the portlet...
>
> I also tried to use a "new" Geronimo install (downloaded it again and
> unzipped it to another destination), but this didn't help, deploying it
> via the web console also doesn't work with this new install.
>
> Flo
>

[Florian Schaetz-2]

Donald Woods wrote:

> That sounds like maybe a XSSXSRF filter problem....

I get some strange messages concerning this filter sometimes, but I
didn't see any of them with this problem.

> Can you download and try the latest 2.1.5-SNAPSHOT build, which includes
> some fixes for discovered issues with that filter?

I'll try, thanks.

Flo

[Florian Schaetz-2]

Kevan Miller wrote:

> Those log messages look normal. However, they are generated during the
> "Create Database Pool -- Step 1" page creation -- before you are hitting
> next. What web browser are you using?

I use Firefox, but I also tried using Opera - didn't make any difference
here.

> Are there any environmental differences between your system and your
> colleague's (who is able to create the pool)? Web Browser, OS, Java
> version, etc.

He's using Opera on a W2K machine (iirc), I'm using Firefox on a WinXP
computer. Don't know about his java version exactly (it's a Java6, but I
don't know the exact version), I'm using a JDK 6.0.12 for the server.

Flo